RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "blastn", bioproject = "PRJNA1132896" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 34 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1132896 · 34 ✖

analysis 1

  • blastn · 34 ✖
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
283645 283645 PRJNA1132896_P_NODE_5521_length_267_cov_1.572165_g5430_i0 PRJNA1132896 5521 267 1.572165 4.19768055 Timema tahoe 61484 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1948236325|emb|OE005703.1| 61484 g5430 i0 92.308 0.385767790262172 39 3 15 0 143 181 29723 29685 4_Tte_b3v08 blastn 103 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
1031742 1031742 PRJNA1132896_P_NODE_3361_length_308_cov_1.506383_g3270_i0 PRJNA1132896 3361 308 1.506383 4.63965964 Artemia 6660 Arthropoda Arthropoda 401 2.4799999999999992e-107   NTclustered gi|511347781|ref|NC_021383.1| 351233 g3270 i0 100 74.1525974025974 217 0 100 0 1 217 12653 12869 Artemia tibetiana mitochondrion, complete genome blastn 22839 401 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
2307102 2307102 PRJNA1132896_P_NODE_3442_length_305_cov_1.327586_g3351_i0 PRJNA1132896 3442 305 1.327586 4.0491373 Calanoida 6833 Arthropoda Arthropoda 134 9.87e-27   NTclustered gi|408816150|dbj|AB753549.1| 544705 g3351 i0 90.909 32.1540983606557 99 9 32 0 198 296 284 186 Lucicutia flavicornis genes for ITS2, 28S ribosomal RNA, partial sequence, isolate: 2012JH031 blastn 9807 135 0.992592592592593 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Lucicutiidae Lucicutia Lucicutia flavicornis
2834263 2834263 PRJNA1132896_P_NODE_1883_length_392_cov_2.896552_g1792_i0 PRJNA1132896 1883 392 2.896552 11.35448384 Chrysoperla carnea 189513 Arthropoda Arthropoda 278 5.68e-70   NTclustered gi|2125088822|ref|XM_044887875.1| 189513 g1792 i0 80.315 87.8239795918367 381 63 96 9 5 382 432 803 PREDICTED: Chrysoperla carnea heat shock protein 83 (LOC123306014), mRNA blastn 34427 278 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Chrysopidae Chrysoperla Chrysoperla carnea
5386794 5386794 PRJNA1132896_P_NODE_10585_length_231_cov_2.240506_g10494_i0 PRJNA1132896 10585 231 2.240506 5.17556886 Liposcelis brunnea 209989 Arthropoda Arthropoda 331 2.37e-86   NTclustered gi|54399833|gb|AY630473.1| 209989 g10494 i0 92.641 10.6969696969697 231 14 99 3 1 230 243 471 Liposcelis brunnea voucher KY245 18S ribosomal RNA gene, partial sequence blastn 2471 331 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis brunnea
5386798 5386798 PRJNA1132896_P_NODE_1345_length_452_cov_1.646438_g1254_i0 PRJNA1132896 1345 452 1.646438 7.44189976 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.044   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g1254 i0 100 0.0619469026548673 28 0 6 0 88 115 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
5386801 5386801 PRJNA1132896_P_NODE_1625_length_416_cov_1.985423_g1534_i0 PRJNA1132896 1625 416 1.985423 8.25935968 Culicoides brevitarsis 469753 Arthropoda Arthropoda 226 2.2299999999999998e-54   NTclustered gi|2701309065|ref|XM_063844043.1| 469753 g1534 i0 86.124 62.9278846153846 209 29 50 0 27 235 66 274 PREDICTED: Culicoides brevitarsis ubiquitin-ribosomal protein eL40 fusion protein (LOC134830534), mRNA blastn 26178 226 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
5386804 5386804 PRJNA1132896_P_NODE_2025_length_380_cov_0.765472_g1934_i0 PRJNA1132896 2025 380 0.765472 2.9087936 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.036   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g1934 i0 96.875 0.0842105263157895 32 0 8 1 7 37 14100601 14100632 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
5386806 5386806 PRJNA1132896_P_NODE_2065_length_377_cov_0.973684_g1974_i0 PRJNA1132896 2065 377 0.973684 3.67078868 Ceratitis capitata 7213 Arthropoda Arthropoda 261 5.48e-65   NTclustered gi|1314931694|ref|XM_023302906.1| 7213 g1974 i0 79.255 103.079575596817 376 76 99 2 1 375 1326 952 PREDICTED: Ceratitis capitata polyubiquitin-C (LOC101461787), mRNA blastn 38861 261 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
5386821 5386821 PRJNA1132896_P_NODE_3185_length_315_cov_1.239669_g3094_i0 PRJNA1132896 3185 315 1.239669 3.90495735 Procambarus clarkii 6728 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2837479954|ref|XR_011227976.1| 6728 g3094 i0 94.444 0.114285714285714 36 2 11 0 123 158 391 426 PREDICTED: Procambarus clarkii uncharacterized lncRNA (LOC138363011), ncRNA blastn 36 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
6134584 6134584 PRJNA1132896_P_NODE_3545_length_300_cov_2.392070_g3454_i0 PRJNA1132896 3545 300 2.39207 7.17621 Artemia 6660 Arthropoda Arthropoda 555 1.7399999999999995e-153   NTclustered gi|1198284985|gb|KX925423.1| 351233 g3454 i0 100 97.9633333333333 300 0 100 0 1 300 248 547 Artemia tibetiana isolate Tibet 2015 16S ribosomal RNA gene, partial sequence; tRNA-Val gene, complete sequence; and 12S ribosomal RNA gene, partial sequence; mitochondrial blastn 29389 555 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
7409690 7409690 PRJNA1132896_P_NODE_7286_length_250_cov_0.870056_g7195_i0 PRJNA1132896 7286 250 0.870056 2.17514 Opisthokonta 33154 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|1321350938|ref|XM_014380694.2| 7493 g7195 i0 100 0.24 28 0 11 0 212 239 568 595 PREDICTED: Trichogramma pretiosum histone-lysine N-methyltransferase, H3 lysine-79 specific (LOC106658653), mRNA blastn 60 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
7936632 7936632 PRJNA1132896_P_NODE_3247_length_312_cov_1.552301_g3156_i0 PRJNA1132896 3247 312 1.552301 4.84317912 Trichoplusia ni 7111 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1496250427|ref|XM_026880109.1| 7111 g3156 i0 100 0.182692307692308 29 0 9 0 197 225 1994 1966 PREDICTED: Trichoplusia ni calphotin-like (LOC113499595), mRNA blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Trichoplusia Trichoplusia ni
9211613 9211613 PRJNA1132896_P_NODE_2948_length_324_cov_2.960159_g2857_i0 PRJNA1132896 2948 324 2.960159 9.59091516 Timema poppense 170557 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|1946153605|emb|OD012397.1| 170557 g2857 i0 100 0.0864197530864197 28 0 9 0 153 180 9148 9121 1_Tps_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema poppense
9211681 9211681 PRJNA1132896_P_NODE_8668_length_245_cov_2.563953_g8577_i0 PRJNA1132896 8668 245 2.563953 6.28168485 Culicoides sonorensis 179676 Arthropoda Arthropoda 215 2.67e-51   NTclustered gi|56199553|gb|AY752853.1| 179676 g8577 i0 86 124.808163265306 200 28 82 0 42 241 384 185 Culicoides sonorensis clone CsUB2 ubiquitin mRNA, partial cds blastn 30578 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides sonorensis
11762250 11762250 PRJNA1132896_P_NODE_6410_length_255_cov_1.549451_g6319_i0 PRJNA1132896 6410 255 1.549451 3.95110005 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 206 1.68e-48   NTclustered gi|146198881|gb|AC202216.3| 7029 g6319 i0 86.957 21.7294117647059 184 23 72 1 1 184 877 1059 Acyrthosiphon pisum BAC VMRC38-20-A5 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence blastn 5541 206 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
11762254 11762254 PRJNA1132896_P_NODE_7010_length_250_cov_1.740113_g6919_i0 PRJNA1132896 7010 250 1.740113 4.3502825 Oppiella nova 334625 Arthropoda Arthropoda 457 4.1099999999999985e-124   NTclustered gi|1964814752|emb|OC915929.1| 334625 g6919 i0 99.6 6.96 250 1 100 0 1 250 13379 13130 Oppiella nova blastn 1740 457 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
13037313 13037313 PRJNA1132896_P_NODE_1571_length_423_cov_2.020000_g1480_i0 PRJNA1132896 1571 423 2.02 8.5446 Bradysia coprophila 38358 Arthropoda Arthropoda 313 1.69e-80   NTclustered gi|1928081288|ref|XM_037188404.1| 38358 g1480 i0 81.159 103.427895981087 414 57 96 14 2 409 1015 617 PREDICTED: Bradysia coprophila ATP synthase subunit beta, mitochondrial (LOC119080178), mRNA blastn 43750 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
13037319 13037319 PRJNA1132896_P_NODE_3071_length_319_cov_1.280488_g2980_i0 PRJNA1132896 3071 319 1.280488 4.08475672 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g2980 i0 100 0.0909090909090909 29 0 9 0 188 216 14100628 14100600 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
13037359 13037359 PRJNA1132896_P_NODE_6591_length_252_cov_2.245810_g6500_i0 PRJNA1132896 6591 252 2.24581 5.6594412 Macrocheles sp. 1 APGD-2010 704003 Arthropoda Arthropoda 433 6.98e-117   NTclustered gi|283462465|gb|FJ911756.1| 704003 g6500 i0 97.619 100.384920634921 252 6 100 0 1 252 77 328 Macrocheles sp. 1 APGD-2010 28S ribosomal RNA gene, partial sequence blastn 25297 433 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Macrochelidae Macrocheles Macrocheles sp. 1 APGD-2010
13037387 13037387 PRJNA1132896_P_NODE_8711_length_245_cov_1.639535_g8620_i0 PRJNA1132896 8711 245 1.639535 4.01686075 Anopheles arabiensis 7173 Arthropoda Arthropoda 62.1 3.67e-5   NTclustered gi|2017707931|ref|XM_040304354.1| 7173 g8620 i0 95 0.302040816326531 40 1 16 1 44 82 6 45 PREDICTED: Anopheles arabiensis homeobox protein B-H2 (LOC120898460), transcript variant X5, mRNA blastn 74 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles arabiensis
13785119 13785119 PRJNA1132896_P_NODE_8011_length_247_cov_2.477011_g7920_i0 PRJNA1132896 8011 247 2.477011 6.11821717 Drosophila 7215 Arthropoda Arthropoda 189 1.6299999999999999e-43   NTclustered gi|1509801425|ref|XM_001979159.3| 7220 g7920 i0 85.326 54.9716599190283 184 25 74 2 3 185 2767 2949 PREDICTED: Drosophila erecta uncharacterized LOC6553277 (LOC6553277), mRNA blastn 13578 189 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila erecta
14312528 14312528 PRJNA1132896_P_NODE_1172_length_481_cov_1.247549_g1081_i0 PRJNA1132896 1172 481 1.247549 6.00071069 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.047   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g1081 i0 100 0.0582120582120582 28 0 6 0 180 207 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
14312530 14312530 PRJNA1132896_P_NODE_1512_length_430_cov_8.378151_g1421_i0 PRJNA1132896 1512 430 8.378151 36.0260493 Hydrometra stagnorum 446445 Arthropoda Arthropoda 496 1.5899999999999998e-135   NTclustered gi|1131051030|gb|KX821841.1| 446445 g1421 i0 89.078 1.37674418604651 412 27 93 11 30 429 1469 1064 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 592 496 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
15586518 15586518 PRJNA1132896_P_NODE_2453_length_351_cov_1.053957_g2362_i0 PRJNA1132896 2453 351 1.053957 3.69938907 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1963345359|emb|OE839378.1| 629358 g2362 i0 100 0.475783475783476 29 0 8 0 147 175 6940 6912 5_Tge_b3v08 blastn 167 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
17609444 17609444 PRJNA1132896_P_NODE_7974_length_248_cov_0.880000_g7883_i0 PRJNA1132896 7974 248 0.88 2.1824 Nymphalidae 33415 Arthropoda Arthropoda 143 1.29e-29   NTclustered gi|2569058887|gb|OL120234.1| 306009 g7883 i0 80.311 46.3548387096774 193 34 77 2 19 209 1043 853 Ithomia patilla voucher MGCL:LEP-22845 delta-aminolevulinic acid dehydratase gene, partial cds blastn 11496 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Ithomia Ithomia patilla
20685006 20685006 PRJNA1132896_P_NODE_3817_length_291_cov_2.628440_g3726_i0 PRJNA1132896 3817 291 2.62844 7.6487604 Zeugodacus cucurbitae 28588 Arthropoda Arthropoda 267 8.839999999999999e-67   NTclustered gi|2460032817|ref|XM_011180357.3| 28588 g3726 i0 83.448 76.3058419243986 290 44 99 4 3 290 1032 1319 PREDICTED: Zeugodacus cucurbitae V-type proton ATPase catalytic subunit A (LOC105209762), mRNA blastn 22205 267 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Zeugodacus Zeugodacus cucurbitae
20685035 20685035 PRJNA1132896_P_NODE_6637_length_252_cov_1.290503_g6546_i0 PRJNA1132896 6637 252 1.290503 3.25206756 Penaeus japonicus 27405 Arthropoda Arthropoda 58.4 4.91e-4   NTclustered gi|2080998944|ref|XM_043024804.1| 27405 g6546 i0 97.059 3.45634920634921 34 1 13 0 36 69 791 758 PREDICTED: Penaeus japonicus signal-induced proliferation-associated 1-like protein 2 (LOC122258697), transcript variant X5, mRNA blastn 871 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus japonicus
20685045 20685045 PRJNA1132896_P_NODE_8217_length_247_cov_0.885057_g8126_i0 PRJNA1132896 8217 247 0.885057 2.18609079 Lucilia cuprina 7375 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2202983020|ref|XM_046953043.1| 7375 g8126 i0 100 0.11336032388664 28 0 11 0 215 242 799 772 PREDICTED: Lucilia cuprina repressor of RNA polymerase III transcription MAF1 homolog (LOC111683866), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
21960413 21960413 PRJNA1132896_P_NODE_5018_length_274_cov_2.283582_g4927_i0 PRJNA1132896 5018 274 2.283582 6.25701468 Drosophila sulfurigaster 88886 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2648625517|ref|XM_062275921.1| 89887 g4927 i0 96.875 0.116788321167883 32 1 12 0 141 172 1072 1041 PREDICTED: Drosophila sulfurigaster albostrigata uncharacterized LOC133842713 (LOC133842713), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila sulfurigaster
21960442 21960442 PRJNA1132896_P_NODE_7278_length_250_cov_0.870056_g7187_i0 PRJNA1132896 7278 250 0.870056 2.17514 Artemia franciscana 6661 Arthropoda Arthropoda 135 2.1900000000000003e-27   NTclustered gi|2743049060|ref|XM_065720839.1| 6661 g7187 i0 81.503 0.692 173 24 67 5 13 179 3763 3933 PREDICTED: Artemia franciscana uncharacterized LOC136037954 (LOC136037954), transcript variant X2, mRNA blastn 173 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
23235907 23235907 PRJNA1132896_P_NODE_10259_length_241_cov_0.916667_g10168_i0 PRJNA1132896 10259 241 0.916667 2.20916747 Artemia franciscana 6661 Arthropoda Arthropoda 239 1.55e-58   NTclustered gi|2743031272|ref|XR_010618607.1| 6661 g10168 i0 85.062 200.099585062241 241 28 99 5 1 239 1016 782 PREDICTED: Artemia franciscana uncharacterized LOC136031869 (LOC136031869), transcript variant X11, ncRNA blastn 48224 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
23235935 23235935 PRJNA1132896_P_NODE_4799_length_278_cov_1.248780_g4708_i0 PRJNA1132896 4799 278 1.24878 3.4716084 Pseudodiaptomus poplesia 213370 Arthropoda Arthropoda 76.8 1.52e-9   NTclustered gi|1148369163|gb|KY357902.1| 213370 g4708 i0 79.817 1.8273381294964 109 18 38 3 170 276 598 492 Pseudodiaptomus poplesia clone BPPOP43-2(2) 60S ribosomal protein l23a mRNA, complete cds blastn 508 76.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Pseudodiaptomidae Pseudodiaptomus Pseudodiaptomus poplesia
23984098 23984098 PRJNA1132896_P_NODE_8079_length_247_cov_1.304598_g7988_i0 PRJNA1132896 8079 247 1.304598 3.22235706 Diptera 7147 Arthropoda Arthropoda 222 1.61e-53   NTclustered gi|2635633245|ref|XM_061543059.1| 27455 g7988 i0 82.927 27.1336032388664 246 42 99 0 1 246 974 729 PREDICTED: Musca vetustissima V-type proton ATPase subunit B (LOC133334731), mRNA blastn 6702 222 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;