contig_metadata
31 rows where bioproject = "PRJNA798511" and tax_phylum = "Annelida"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 791157 | 791157 | PRJNA798511_P_NODE_85301_length_256_cov_1.262295_g81035_i0 | PRJNA798511 | 85301 | 256 | 1.262295 | 3.2314752 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.87e-5 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g81035 | i0 | 91.304 | 0.921875 | 46 | 2 | 36 | 2 | 184 | 229 | 14363340 | 14363297 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 236 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2066666 | 2066666 | PRJNA798511_P_NODE_65042_length_302_cov_1.973799_g60776_i0 | PRJNA798511 | 65042 | 302 | 1.973799 | 5.96087298 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g60776 | i0 | 100 | 0.28476821192053 | 29 | 0 | 10 | 0 | 188 | 216 | 843326 | 843354 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4619299 | 4619299 | PRJNA798511_P_NODE_68804_length_292_cov_1.566210_g64538_i0 | PRJNA798511 | 68804 | 292 | 1.56621 | 4.5733332 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g64538 | i0 | 87.755 | 0.167808219178082 | 49 | 4 | 16 | 2 | 74 | 120 | 6101102 | 6101150 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 49 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5893911 | 5893911 | PRJNA798511_P_NODE_36445_length_455_cov_1.068063_g32186_i0 | PRJNA798511 | 36445 | 455 | 1.068063 | 4.85968665 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.012 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g32186 | i0 | 94.286 | 0.138461538461538 | 35 | 2 | 8 | 0 | 300 | 334 | 4784586 | 4784620 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 63 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5894751 | 5894751 | PRJNA798511_P_NODE_91845_length_248_cov_1.765714_g87579_i0 | PRJNA798511 | 91845 | 248 | 1.765714 | 4.37897072 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g87579 | i0 | 100 | 5.66532258064516 | 29 | 0 | 12 | 0 | 99 | 127 | 8645408 | 8645436 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 1405 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7169566 | 7169566 | PRJNA798511_P_NODE_95046_length_246_cov_1.219653_g90780_i0 | PRJNA798511 | 95046 | 246 | 1.219653 | 3.00034638 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 4.78e-4 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g90780 | i0 | 97.059 | 0.252032520325203 | 34 | 1 | 14 | 0 | 195 | 228 | 1199910 | 1199943 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9719211 | 9719211 | PRJNA798511_P_NODE_81168_length_264_cov_1.591623_g76902_i0 | PRJNA798511 | 81168 | 264 | 1.591623 | 4.20188472 | Metazoa | 33208 | Annelida | Annelida | 121 | 7.73e-33 | NR | CCD27758.1 | 210783 | g76902 | i0 | 77.3 | 19.2840909090909 | 75 | 17 | 85.2 | 0 | 39 | 263 | 65 | 139 | CCD27758.1 ribosomal protein l17, partial [Apionsoma misakianum] | diamond | 5091 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Phascolosomatiformes | Phascolosomatidae | Apionsoma | Apionsoma misakianum | |
| 12269702 | 12269702 | PRJNA798511_P_NODE_32450_length_502_cov_1.934732_g28198_i0 | PRJNA798511 | 32450 | 502 | 1.934732 | 9.71235464 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|675877575|ref|XM_009026100.1| | 6412 | g28198 | i0 | 96.97 | 0.472111553784861 | 33 | 1 | 7 | 0 | 57 | 89 | 1176 | 1144 | Helobdella robusta hypothetical protein mRNA | blastn | 237 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 13543471 | 13543471 | PRJNA798511_P_NODE_17651_length_912_cov_1.673421_g13917_i0 | PRJNA798511 | 17651 | 912 | 1.673421 | 15.26159952 | Metazoa | 33208 | Annelida | Annelida | 201 | 8.77e-57 | NR | KAK2174841.1 | 27915 | g13917 | i0 | 37.3 | 3.85526315789474 | 287 | 178 | 94.1 | 2 | 859 | 2 | 11 | 296 | KAK2174841.1 hypothetical protein NP493_774g00007 [Ridgeia piscesae] | diamond | 3516 | 201 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 14819058 | 14819058 | PRJNA798511_P_NODE_53972_length_339_cov_1.364662_g49706_i0 | PRJNA798511 | 53972 | 339 | 1.364662 | 4.62620418 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g49706 | i0 | 100 | 0.0884955752212389 | 30 | 0 | 9 | 0 | 9 | 38 | 4685479 | 4685508 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16093699 | 16093699 | PRJNA798511_P_NODE_83853_length_259_cov_1.150538_g79587_i0 | PRJNA798511 | 83853 | 259 | 1.150538 | 2.97989342 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g79587 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 70 | 97 | 8279198 | 8279171 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17369432 | 17369432 | PRJNA798511_P_NODE_77454_length_272_cov_1.547739_g73188_i0 | PRJNA798511 | 77454 | 272 | 1.547739 | 4.20985008 | Opisthokonta | 33154 | Annelida | Annelida | 101 | 2.18e-25 | NR | CAH1794544.1 | 6347 | g73188 | i0 | 63.2 | 15.2205882352941 | 87 | 31 | 94.9 | 1 | 269 | 12 | 39 | 125 | CAH1794544.1 unnamed protein product [Owenia fusiformis] | diamond | 4140 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 19917311 | 19917311 | PRJNA798511_P_NODE_42356_length_403_cov_0.827273_g38092_i0 | PRJNA798511 | 42356 | 403 | 0.827273 | 3.33391019 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.039 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g38092 | i0 | 100 | 0.0694789081885856 | 28 | 0 | 7 | 0 | 16 | 43 | 13644653 | 13644680 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23743560 | 23743560 | PRJNA798511_P_NODE_63299_length_307_cov_2.136752_g59033_i0 | PRJNA798511 | 63299 | 307 | 2.136752 | 6.55982864 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g59033 | i0 | 100 | 0.0944625407166124 | 29 | 0 | 9 | 0 | 119 | 147 | 10345452 | 10345480 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25016829 | 25016829 | PRJNA798511_P_NODE_36200_length_457_cov_2.104167_g31941_i0 | PRJNA798511 | 36200 | 457 | 2.104167 | 9.61604319 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g31941 | i0 | 100 | 0.636761487964989 | 31 | 0 | 7 | 0 | 311 | 341 | 3728493 | 3728463 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 291 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25016900 | 25016900 | PRJNA798511_P_NODE_39760_length_423_cov_1.494286_g35497_i0 | PRJNA798511 | 39760 | 423 | 1.494286 | 6.32082978 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.88e-5 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g35497 | i0 | 97.297 | 1.34042553191489 | 37 | 1 | 9 | 0 | 22 | 58 | 10232720 | 10232684 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 567 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26895975 | 26895975 | PRJNA798511_P_NODE_60121_length_317_cov_1.577869_g55855_i0 | PRJNA798511 | 60121 | 317 | 1.577869 | 5.00184473 | Capitella teleta | 283909 | Annelida | Annelida | 43.1 | 0.0135 | NR | ELU01614.1 | 283909 | g55855 | i0 | 50 | 0.67192429022082 | 36 | 18 | 34.1 | 0 | 183 | 76 | 32 | 67 | ELU01614.1 hypothetical protein CAPTEDRAFT_139171, partial [Capitella teleta] | diamond | 213 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27085634 | 27085634 | PRJNA798511_P_NODE_73982_length_280_cov_0.961353_g69716_i0 | PRJNA798511 | 73982 | 280 | 0.961353 | 2.6917884 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 44.7 | 0.0124 | NR | KAK2145615.1 | 53620 | g69716 | i0 | 34.3 | 0.717857142857143 | 67 | 41 | 68.6 | 1 | 250 | 59 | 182 | 248 | KAK2145615.1 hypothetical protein LSH36_669g04058 [Paralvinella palmiformis] | diamond | 201 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27780609 | 27780609 | PRJNA798511_P_NODE_104744_length_228_cov_2.516129_g100478_i0 | PRJNA798511 | 104744 | 228 | 2.516129 | 5.73677412 | Owenia fusiformis | 6347 | Annelida | Annelida | 43.5 | 0.0169 | NR | CAH1801914.1 | 6347 | g100478 | i0 | 50 | 0.394736842105263 | 30 | 15 | 39.5 | 0 | 194 | 105 | 2449 | 2478 | CAH1801914.1 unnamed protein product [Owenia fusiformis] | diamond | 90 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27812296 | 27812296 | PRJNA798511_P_NODE_47244_length_371_cov_2.224832_g42978_i0 | PRJNA798511 | 47244 | 371 | 2.224832 | 8.25412672 | Helobdella robusta | 6412 | Annelida | Annelida | 70.9 | 9.99e-12 | NR | XP_009021524.1 | 6412 | g42978 | i0 | 50 | 2.28032345013477 | 82 | 38 | 63.9 | 2 | 296 | 60 | 196 | 277 | XP_009021524.1 hypothetical protein HELRODRAFT_175915 [Helobdella robusta] | diamond | 846 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28096238 | 28096238 | PRJNA798511_P_NODE_74125_length_279_cov_1.781553_g69859_i0 | PRJNA798511 | 74125 | 279 | 1.781553 | 4.97053287 | Capitella teleta | 283909 | Annelida | Annelida | 42.7 | 0.0111 | NR | ELT95635.1 | 283909 | g69859 | i0 | 62.5 | 0.688172043010753 | 32 | 12 | 34.4 | 0 | 183 | 278 | 39 | 70 | ELT95635.1 hypothetical protein CAPTEDRAFT_138181, partial [Capitella teleta] | diamond | 192 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28159576 | 28159576 | PRJNA798511_P_NODE_16645_length_963_cov_8.900000_g13035_i0 | PRJNA798511 | 16645 | 963 | 8.9 | 85.707 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 61.6 | 1.01e-7 | NR | KAK2162938.1 | 53620 | g13035 | i0 | 100 | 0.0872274143302181 | 28 | 0 | 8.7 | 0 | 963 | 880 | 105 | 132 | KAK2162938.1 hypothetical protein LSH36_89g04027 [Paralvinella palmiformis] | diamond | 84 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28159619 | 28159619 | PRJNA798511_P_NODE_81085_length_264_cov_1.753927_g76819_i0 | PRJNA798511 | 81085 | 264 | 1.753927 | 4.63036728 | Ridgeia piscesae | 27915 | Annelida | Annelida | 56.6 | 1.88e-7 | NR | KAK2165611.1 | 27915 | g76819 | i0 | 40.3 | 1.64772727272727 | 72 | 43 | 81.8 | 0 | 49 | 264 | 23 | 94 | KAK2165611.1 hypothetical protein NP493_1358g00002 [Ridgeia piscesae] | diamond | 435 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28727739 | 28727739 | PRJNA798511_P_NODE_16547_length_970_cov_2.578595_g12947_i0 | PRJNA798511 | 16547 | 970 | 2.578595 | 25.0123715 | Capitella teleta | 283909 | Annelida | Annelida | 61.6 | 2.56e-6 | NR | ELU07992.1 | 283909 | g12947 | i0 | 42.9 | 0.194845360824742 | 63 | 36 | 19.5 | 0 | 515 | 703 | 1305 | 1367 | ELU07992.1 hypothetical protein CAPTEDRAFT_216620 [Capitella teleta] | diamond | 189 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28957990 | 28957990 | PRJNA798511_P_NODE_30868_length_525_cov_1.820796_g26624_i0 | PRJNA798511 | 30868 | 525 | 1.820796 | 9.559179 | Metazoa | 33208 | Annelida | Annelida | 46.6 | 0.0238 | NR | CAH1791901.1 | 6347 | g26624 | i0 | 52.5 | 2.19428571428571 | 40 | 19 | 22.9 | 0 | 105 | 224 | 244 | 283 | CAH1791901.1 unnamed protein product [Owenia fusiformis] | diamond | 1152 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29012185 | 29012185 | PRJNA798511_P_NODE_17428_length_923_cov_1.795294_g13724_i0 | PRJNA798511 | 17428 | 923 | 1.795294 | 16.57056362 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 197 | 6.29e-53 | NR | KAI0224709.1 | 104711 | g13724 | i0 | 50 | 4.90790899241603 | 196 | 98 | 63.7 | 0 | 694 | 107 | 762 | 957 | KAI0224709.1 hypothetical protein LSAT2_024312 [Lamellibrachia satsuma] | diamond | 4530 | 197 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 29296012 | 29296012 | PRJNA798511_P_NODE_26429_length_606_cov_1.283302_g22226_i0 | PRJNA798511 | 26429 | 606 | 1.283302 | 7.77681012 | Helobdella robusta | 6412 | Annelida | Annelida | 46.2 | 0.0187 | NR | XP_009022605.1 | 6412 | g22226 | i0 | 50 | 0.504950495049505 | 34 | 17 | 16.8 | 0 | 485 | 384 | 90 | 123 | XP_009022605.1 hypothetical protein HELRODRAFT_162029 [Helobdella robusta] | diamond | 306 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29801118 | 29801118 | PRJNA798511_P_NODE_92671_length_248_cov_0.880000_g88405_i0 | PRJNA798511 | 92671 | 248 | 0.88 | 2.1824 | Helobdella robusta | 6412 | Annelida | Annelida | 79.3 | 4.49e-15 | NR | XP_009011430.1 | 6412 | g88405 | i0 | 57.6 | 0.798387096774194 | 66 | 26 | 79.8 | 1 | 1 | 198 | 143 | 206 | XP_009011430.1 hypothetical protein HELRODRAFT_183591 [Helobdella robusta] | diamond | 198 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30410907 | 30410907 | PRJNA798511_P_NODE_95253_length_246_cov_0.890173_g90987_i0 | PRJNA798511 | 95253 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Annelida | Annelida | 47 | 9.5e-4 | NR | CAH1791497.1 | 6347 | g90987 | i0 | 54.5 | 5.86585365853659 | 33 | 15 | 40.2 | 0 | 2 | 100 | 174 | 206 | CAH1791497.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1443 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30631555 | 30631555 | PRJNA798511_P_NODE_71753_length_285_cov_1.089623_g67487_i0 | PRJNA798511 | 71753 | 285 | 1.089623 | 3.10542555 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00652 | NR | ELU11830.1 | 283909 | g67487 | i0 | 45.2 | 2.16842105263158 | 42 | 23 | 44.2 | 0 | 127 | 2 | 15 | 56 | ELU11830.1 hypothetical protein CAPTEDRAFT_188638 [Capitella teleta] | diamond | 618 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31412808 | 31412808 | PRJNA798511_P_NODE_74816_length_278_cov_1.126829_g70550_i0 | PRJNA798511 | 74816 | 278 | 1.126829 | 3.13258462 | Helobdella robusta | 6412 | Annelida | Annelida | 97.1 | 2.66e-21 | NR | XP_009011430.1 | 6412 | g70550 | i0 | 55.1 | 1.92086330935252 | 89 | 37 | 95 | 2 | 278 | 15 | 124 | 210 | XP_009011430.1 hypothetical protein HELRODRAFT_183591 [Helobdella robusta] | diamond | 534 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;