contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1055999 | 1055999 | PRJNA207343_S_NODE_6341_length_249_cov_5.400943_g5804_i0 | PRJNA207343 | 6341 | 249 | 5.400943 | 13.44834807 | Poteriospumella | 1117026 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.9e-122 | NTclustered | gi|685431582|gb|KF697341.1| | 1117027 | g5804 | i0 | 100 | 81.0481927710843 | 244 | 0 | 98 | 0 | 6 | 249 | 22 | 265 | Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence | blastn | 20181 | 451 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 1641804 | 1641804 | PRJNA207343_S_NODE_8362_length_194_cov_3.292994_g7825_i0 | PRJNA207343 | 8362 | 194 | 3.292994 | 6.38840836 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 8.809999999999999e-95 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7825 | i0 | 100 | 27.9948453608247 | 194 | 0 | 100 | 0 | 1 | 194 | 2911 | 2718 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 5431 | 359 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2917509 | 2917509 | PRJNA207343_S_NODE_3443_length_440_cov_2.091811_g2911_i0 | PRJNA207343 | 3443 | 440 | 2.091811 | 9.2039684 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 532 | 1.25e-146 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2911 | i0 | 89.302 | 66.1568181818182 | 430 | 38 | 97 | 8 | 1 | 425 | 1892 | 2318 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 29109 | 532 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2917621 | 2917621 | PRJNA207343_S_NODE_7563_length_212_cov_3.040000_g7026_i0 | PRJNA207343 | 7563 | 212 | 3.04 | 6.4448 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.32e-63 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g7026 | i0 | 90.722 | 72.5377358490566 | 194 | 15 | 91 | 3 | 1 | 193 | 3682 | 3873 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 15378 | 255 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 2917650 | 2917650 | PRJNA207343_S_NODE_8663_length_189_cov_1.243421_g8126_i0 | PRJNA207343 | 8663 | 189 | 1.243421 | 2.35006569 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.39e-90 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g8126 | i0 | 99.471 | 1 | 189 | 1 | 100 | 0 | 1 | 189 | 477 | 665 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 189 | 344 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3606409 | 3606409 | PRJNA207343_S_NODE_5083_length_308_cov_146.985240_g4546_i0 | PRJNA207343 | 5083 | 308 | 146.98524 | 452.7145392 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 2.21e-8 | NTclustered | gi|1079281417|gb|EF494740.3| | 478820 | g4546 | i0 | 97.619 | 65.0064935064935 | 42 | 1 | 14 | 0 | 267 | 308 | 3544 | 3585 | Blastocystis sp. NandII mitochondrion, complete genome | blastn | 20022 | 73.1 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 4194066 | 4194066 | PRJNA207343_S_NODE_7204_length_221_cov_35.233696_g6667_i0 | PRJNA207343 | 7204 | 221 | 35.233696 | 77.86646816 | Synura macracantha | 1261423 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 2.39e-41 | NTclustered | gi|859809363|gb|KM590648.1| | 1261423 | g6667 | i0 | 83.105 | 63.737556561086 | 219 | 17 | 98 | 13 | 4 | 220 | 2321 | 2521 | Synura macracantha strain S90B5 26S ribosomal RNA gene, partial sequence | blastn | 14086 | 182 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura macracantha | |||
| 7433786 | 7433786 | PRJNA207343_S_NODE_2646_length_551_cov_13.501946_g2135_i0 | PRJNA207343 | 2646 | 551 | 13.501946 | 74.39572246 | Spumella | 89043 | SAR_Eukaryotes | SAR_Eukaryotes | 645 | 1.959999999999999e-180 | NTclustered | gi|2055919756|gb|MZ420314.1| | 1955568 | g2135 | i0 | 88.172 | 100.722323049002 | 558 | 45 | 99 | 16 | 1 | 549 | 1186 | 1731 | Spumella sp. strain Woeam021018A5 large subunit ribosomal RNA gene, partial sequence | blastn | 55498 | 645 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. | |||
| 8020169 | 8020169 | PRJNA207343_S_NODE_10587_length_160_cov_16.691057_g10050_i0 | PRJNA207343 | 10587 | 160 | 16.691057 | 26.7056912 | Cercozoa sp. CC-2009d | 629762 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 9.9e-29 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g10050 | i0 | 82.609 | 70.41875 | 161 | 24 | 100 | 4 | 1 | 160 | 1471 | 1628 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 11267 | 139 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 8020265 | 8020265 | PRJNA207343_S_NODE_3407_length_443_cov_9.822660_g2875_i0 | PRJNA207343 | 3407 | 443 | 9.82266 | 43.5143838 | Hyphochytrium catenoides | 42384 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 8.77e-39 | NTclustered | gi|2440064|emb|X80345.1| | 42384 | g2875 | i0 | 75.626 | 40.216704288939 | 439 | 59 | 98 | 29 | 3 | 434 | 2119 | 1722 | H.catenoides gene for 28S ribosomal RNA | blastn | 17816 | 174 | 1 | Eukaryota | Sar | Hyphochytriomycetes | Hyphochytriales | Hyphochytriaceae | Hyphochytrium | Hyphochytrium catenoides | |||
| 8708532 | 8708532 | PRJNA207343_S_NODE_11407_length_152_cov_2.191304_g10870_i0 | PRJNA207343 | 11407 | 152 | 2.191304 | 3.33078208 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 1.94e-50 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10870 | i0 | 96.154 | 5.69078947368421 | 130 | 3 | 85 | 2 | 18 | 146 | 203 | 331 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 865 | 211 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9983916 | 9983916 | PRJNA207343_S_NODE_10568_length_161_cov_1.508065_g10031_i0 | PRJNA207343 | 10568 | 161 | 1.508065 | 2.42798465 | Mallomonas | 2988 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.28e-32 | NTclustered | gi|323690590|gb|GU935649.1| | 990301 | g10031 | i0 | 86.014 | 30.7950310559006 | 143 | 19 | 88 | 1 | 13 | 154 | 2542 | 2684 | Mallomonas matvienkoae var. matvienkoae strain Gungnam052507A 28S ribosomal RNA gene, partial sequence | blastn | 4958 | 152 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Mallomonas | Mallomonas matvienkoae | |||
| 10571013 | 10571013 | PRJNA207343_S_NODE_6289_length_251_cov_3.897196_g5752_i0 | PRJNA207343 | 6289 | 251 | 3.897196 | 9.78196196 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 7.459999999999999e-67 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g5752 | i0 | 86.747 | 8.32270916334661 | 249 | 22 | 98 | 5 | 7 | 251 | 2566 | 2807 | Rosculus vulgaris isolate CCA sequence | blastn | 2089 | 267 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 11845410 | 11845410 | PRJNA207343_S_NODE_3050_length_489_cov_16.960177_g2521_i0 | PRJNA207343 | 3050 | 489 | 16.960177 | 82.93526553 | Poteriospumella sp. | 2003111 | SAR_Eukaryotes | SAR_Eukaryotes | 656 | 0 | NTclustered | gi|1209183032|gb|KX100774.1| | 2003111 | g2521 | i0 | 91.564 | 45.5848670756646 | 486 | 23 | 98 | 11 | 1 | 477 | 725 | 249 | Poteriospumella sp. strain D-7-A2 28S ribosomal RNA gene, partial sequence | blastn | 22291 | 656 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella sp. | |||
| 11845487 | 11845487 | PRJNA207343_S_NODE_5190_length_302_cov_4.532075_g4653_i0 | PRJNA207343 | 5190 | 302 | 4.532075 | 13.6868665 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 8.47e-127 | NTclustered | gi|1402550476|gb|MH488762.1| | 2231160 | g4653 | i0 | 95.254 | 56.9403973509934 | 295 | 12 | 97 | 2 | 9 | 302 | 1965 | 1672 | Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 17196 | 466 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 13120845 | 13120845 | PRJNA207343_S_NODE_8791_length_186_cov_7.919463_g8254_i0 | PRJNA207343 | 8791 | 186 | 7.919463 | 14.73020118 | Metromonas simplex | 281027 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 5.25e-62 | NTclustered | gi|197723534|gb|EF681916.2| | 281027 | g8254 | i0 | 90.909 | 100.596774193548 | 187 | 16 | 100 | 1 | 1 | 186 | 1228 | 1042 | Metromonas simplex strain HFCC68 28S ribosomal RNA gene, partial sequence | blastn | 18711 | 250 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Metromonadea | Metromonas | Metromonas simplex | |||
| 15083580 | 15083580 | PRJNA207343_S_NODE_9012_length_183_cov_1.164384_g8475_i0 | PRJNA207343 | 9012 | 183 | 1.164384 | 2.13082272 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 7.2e-6 | NTclustered | gi|404425900|gb|JX310029.1| | 692531 | g8475 | i0 | 95.122 | 19.0655737704918 | 41 | 1 | 22 | 1 | 1 | 40 | 1943 | 1903 | Sathrophilus holtae voucher FXP2007102402 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 3489 | 63.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Cinetochilidae | Sathrophilus | Sathrophilus holtae | ||
| 16358414 | 16358414 | PRJNA207343_S_NODE_8213_length_197_cov_6.950000_g7676_i0 | PRJNA207343 | 8213 | 197 | 6.95 | 13.6915 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 7.239999999999999e-66 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g7676 | i0 | 94.22 | 87.8071065989848 | 173 | 9 | 87 | 1 | 18 | 189 | 1397 | 1225 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 17298 | 263 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 19492870 | 19492870 | PRJNA207343_S_NODE_5136_length_305_cov_9.473881_g4599_i0 | PRJNA207343 | 5136 | 305 | 9.473881 | 28.89533705 | Attheya septentrionalis | 420275 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.4899999999999998e-99 | NTclustered | gi|2632235279|gb|OR922661.1| | 420275 | g4599 | i0 | 89.18 | 99.3967213114754 | 305 | 28 | 100 | 4 | 1 | 305 | 3259 | 3558 | Attheya septentrionalis strain AGSB0004 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 30316 | 375 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Attheyaceae | Attheya | Attheya septentrionalis | ||
| 19492878 | 19492878 | PRJNA207343_S_NODE_5376_length_291_cov_375.728346_g4839_i0 | PRJNA207343 | 5376 | 291 | 375.728346 | 1093.36948686 | Poteriospumella sp. | 2003111 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 3.09e-86 | NTclustered | gi|1209183032|gb|KX100774.1| | 2003111 | g4839 | i0 | 94.836 | 32.7903780068728 | 213 | 9 | 73 | 1 | 17 | 227 | 238 | 26 | Poteriospumella sp. strain D-7-A2 28S ribosomal RNA gene, partial sequence | blastn | 9542 | 331 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella sp. | |||
| 19492966 | 19492966 | PRJNA207343_S_NODE_8076_length_200_cov_8.098160_g7539_i0 | PRJNA207343 | 8076 | 200 | 8.09816 | 16.19632 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.14e-36 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7539 | i0 | 82.564 | 19.145 | 195 | 27 | 96 | 7 | 7 | 197 | 2905 | 2714 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 3829 | 165 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22043353 | 22043353 | PRJNA207343_S_NODE_10498_length_161_cov_8.669355_g9961_i0 | PRJNA207343 | 10498 | 161 | 8.669355 | 13.95766155 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 9.7e-49 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g9961 | i0 | 90.385 | 103.968944099379 | 156 | 15 | 97 | 0 | 6 | 161 | 1378 | 1533 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 16739 | 206 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22043452 | 22043452 | PRJNA207343_S_NODE_3698_length_412_cov_33.933333_g3163_i0 | PRJNA207343 | 3698 | 412 | 33.933333 | 139.80533196 | uncultured Chrysophyceae | 183512 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 1.2399999999999996e-101 | NTclustered | gi|406609805|dbj|AB749080.1| | 183512 | g3163 | i0 | 93.774 | 67.2815533980583 | 257 | 13 | 73 | 3 | 11 | 265 | 889 | 634 | Uncultured chrysophyte gene for 18S ribosomal RNA, partial sequence, clone: Bs-St.5-31 | blastn | 27720 | 383 | 1 | Eukaryota | Sar | Chrysophyceae | uncultured Chrysophyceae | ||||||
| 22043458 | 22043458 | PRJNA207343_S_NODE_3858_length_398_cov_146.542936_g3321_i0 | PRJNA207343 | 3858 | 398 | 146.542936 | 583.24088528 | Rosculus incognitus | 2231162 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 1.17e-111 | NTclustered | gi|1402550483|gb|MH488769.1| | 2231162 | g3321 | i0 | 91.973 | 46.1633165829146 | 299 | 20 | 75 | 4 | 101 | 398 | 1985 | 1690 | Rosculus incognitus isolate ATCC 50577 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 18373 | 416 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus incognitus | ||||
| 22732582 | 22732582 | PRJNA207343_S_NODE_10278_length_164_cov_3.464567_g9741_i0 | PRJNA207343 | 10278 | 164 | 3.464567 | 5.68188988 | root | 1 | Root_unresolved | Root_unresolved | 104 | 3.73e-18 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g9741 | i0 | 86.458 | 2.34146341463415 | 96 | 11 | 57 | 2 | 71 | 164 | 2274 | 2179 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 384 | 104 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23319047 | 23319047 | PRJNA207343_S_NODE_7259_length_220_cov_2.601093_g6722_i0 | PRJNA207343 | 7259 | 220 | 2.601093 | 5.7224046 | Rosculus cf. ithacus CCAP 1571/3 | 1808993 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.44e-33 | NTclustered | gi|1002343692|gb|KU738570.1| | 1808993 | g6722 | i0 | 80.556 | 10.2454545454545 | 216 | 30 | 95 | 10 | 11 | 220 | 1566 | 1775 | Rosculus cf. ithacus CCAP 1571/3 18S ribosomal RNA gene, partial sequence | blastn | 2254 | 156 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus cf. ithacus CCAP 1571/3 | ||||
| 25282024 | 25282024 | PRJNA207343_S_NODE_6000_length_262_cov_12.942222_g5463_i0 | PRJNA207343 | 6000 | 262 | 12.942222 | 33.90862164 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.03e-16 | NTclustered | gi|2757671034|gb|PQ008779.1| | 2990 | g5463 | i0 | 98.214 | 32.5076335877863 | 56 | 1 | 36 | 0 | 11 | 66 | 1841 | 1896 | Mallomonas striata strain CZ04D internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 8517 | 100 | 0.99 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Mallomonas | Mallomonas striata | |||
| 25282063 | 25282063 | PRJNA207343_S_NODE_7880_length_204_cov_47.329341_g7343_i0 | PRJNA207343 | 7880 | 204 | 47.329341 | 96.55185564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 9.56e-80 | NTclustered | gi|157411037|gb|EF990208.1| | 3013 | g7343 | i0 | 95.361 | 95.1029411764706 | 194 | 9 | 95 | 0 | 11 | 204 | 2739 | 2546 | Fucus gardneri large subunit ribosomal RNA gene, partial sequence | blastn | 19401 | 309 | 1 | Eukaryota | Sar | Phaeophyceae | Fucales | Fucaceae | Fucus | Fucus gardneri |
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);;