Well, obviously you have to associate metatags with the sites somehow. If you don't have that, how can you possibly know which site the metatag applies to?

So I imagine metatag would look something like this:
Code:
id UUID PRIMARY KEY
site UUID REFERENCES sites
tagname STRING
relevancy REAL(1, 3)
where UUID is some ID type.

Then the join should be obvious.