contig_metadata
28 rows where bioproject = "PRJNA520845" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1764494 | 1764494 | PRJNA520845_P_NODE_177202_length_280_cov_1.207729_g175703_i0 | PRJNA520845 | 177202 | 280 | 1.207729 | 3.3816412 | Geomonas subterranea | 2847989 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2060227305|gb|CP077683.1| | 2847989 | g175703 | i0 | 100 | 0.210714285714286 | 28 | 0 | 10 | 0 | 21 | 48 | 932247 | 932220 | Geomonas subterranea strain RG2 chromosome, complete genome | blastn | 59 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas subterranea | ||
| 5593975 | 5593975 | PRJNA520845_P_NODE_211225_length_252_cov_2.022346_g209726_i0 | PRJNA520845 | 211225 | 252 | 2.022346 | 5.09631192 | Desulfovibrio sp. 86 | 2666132 | Bacteria | Bacteria | 466 | 6.89e-127 | NTclustered | gi|1862956133|emb|LR738849.1| | 2666132 | g209726 | i0 | 100 | 103 | 252 | 0 | 100 | 0 | 1 | 252 | 3245259 | 3245510 | Desulfovibrio sp. 86 genome assembly, chromosome: DESU86 | blastn | 25956 | 466 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. 86 | ||
| 14519241 | 14519241 | PRJNA520845_P_NODE_216792_length_251_cov_0.865169_g215293_i0 | PRJNA520845 | 216792 | 251 | 0.865169 | 2.17157419 | Trichlorobacter lovleyi | 313985 | Bacteria | Bacteria | 58.4 | 4.89e-4 | NTclustered | gi|189419341|gb|CP001089.1| | 398767 | g215293 | i0 | 100 | 0.239043824701195 | 31 | 0 | 12 | 0 | 201 | 231 | 2095406 | 2095436 | Geobacter lovleyi SZ, complete genome | blastn | 60 | 58.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Trichlorobacter | Trichlorobacter lovleyi | ||
| 15793906 | 15793906 | PRJNA520845_P_NODE_252293_length_244_cov_0.900585_g250794_i0 | PRJNA520845 | 252293 | 244 | 0.900585 | 2.1974274 | Pseudodesulfovibrio mercurii | 641491 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|365906293|gb|CP003220.1| | 641491 | g250794 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 131 | 158 | 1010159 | 1010186 | Pseudodesulfovibrio mercurii strain ND132 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio mercurii | ||
| 18963398 | 18963398 | PRJNA520845_P_NODE_260755_length_242_cov_0.911243_g259256_i0 | PRJNA520845 | 260755 | 242 | 0.911243 | 2.20520806 | Desulfosudis | 2904716 | Bacteria | Bacteria | 252 | 2e-62 | NTclustered | gi|158508843|gb|CP000859.1| | 96561 | g259256 | i0 | 85.714 | 201.285123966942 | 245 | 28 | 100 | 6 | 1 | 242 | 684011 | 683771 | Desulfococcus oleovorans Hxd3, complete genome | blastn | 48711 | 252 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosudaceae | Desulfosudis | Desulfosudis oleivorans | ||
| 19616251 | 19616251 | PRJNA520845_P_NODE_212896_length_251_cov_1.370787_g211397_i0 | PRJNA520845 | 212896 | 251 | 1.370787 | 3.44067537 | Desulfuromonas versatilis | 2802975 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2065532709|dbj|AP024355.1| | 2802975 | g211397 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 62 | 89 | 390868 | 390841 | Desulfuromonas versatilis NIT-T3 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas versatilis | ||
| 26602223 | 26602223 | PRJNA520845_P_NODE_253741_length_243_cov_1.358824_g252242_i0 | PRJNA520845 | 253741 | 243 | 1.358824 | 3.30194232 | Geomesophilobacter sediminis | 2798584 | Bacteria | Bacteria | 43.9 | 0.0137 | NR | WP_199382164.1 | 2798584 | g252242 | i0 | 36.1 | 0.888888888888889 | 72 | 40 | 81.5 | 2 | 40 | 237 | 177 | 248 | WP_199382164.1 site-2 protease family protein [Geomesophilobacter sediminis] | diamond | 216 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomesophilobacter | Geomesophilobacter sediminis | ||
| 26744016 | 26744016 | PRJNA520845_P_NODE_141761_length_314_cov_0.987552_g140262_i0 | PRJNA520845 | 141761 | 314 | 0.987552 | 3.10091328 | Desulfuromonadia | 3031651 | Bacteria | Bacteria | 67.8 | 4.06e-11 | NR | MFO7832004.1 | 2099677 | g140262 | i0 | 64.8 | 2.63694267515924 | 54 | 18 | 51.6 | 1 | 132 | 293 | 40 | 92 | MFO7832004.1 dNTP triphosphohydrolase [Desulfuromonadaceae bacterium] | diamond | 828 | 67.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonadaceae bacterium | |||
| 27456726 | 27456726 | PRJNA520845_P_NODE_243463_length_245_cov_1.668605_g241964_i0 | PRJNA520845 | 243463 | 245 | 1.668605 | 4.08808225 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 60.1 | 2.96e-8 | NR | MEN6319972.1 | 2052184 | g241964 | i0 | 44.3 | 4.8734693877551 | 70 | 37 | 84.5 | 2 | 209 | 3 | 531 | 599 | MEN6319972.1 chromosome condensation regulator RCC1 [Syntrophaceae bacterium] | diamond | 1194 | 60.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 27488123 | 27488123 | PRJNA520845_P_NODE_210323_length_253_cov_1.600000_g208824_i0 | PRJNA520845 | 210323 | 253 | 1.6 | 4.048 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 53.1 | 1.65e-6 | NR | MDD5169388.1 | 2928017 | g208824 | i0 | 57.9 | 0.948616600790514 | 38 | 16 | 45.1 | 0 | 117 | 4 | 45 | 82 | MDD5169388.1 RidA family protein [Syntrophales bacterium] | diamond | 240 | 53.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 27709497 | 27709497 | PRJNA520845_P_NODE_143644_length_312_cov_0.878661_g142145_i0 | PRJNA520845 | 143644 | 312 | 0.878661 | 2.74142232 | Trichlorobacter thiogenes | 115783 | Bacteria | Bacteria | 56.6 | 1.13e-6 | NR | WP_078791311.1 | 115783 | g142145 | i0 | 58.7 | 3.75 | 46 | 18 | 43.3 | 1 | 272 | 138 | 618 | 663 | WP_078791311.1 6-bladed beta-propeller [Trichlorobacter thiogenes] | diamond | 1170 | 56.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Trichlorobacter | Trichlorobacter thiogenes | ||
| 27930112 | 27930112 | PRJNA520845_P_NODE_214585_length_251_cov_0.865169_g213086_i0 | PRJNA520845 | 214585 | 251 | 0.865169 | 2.17157419 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 52.8 | 1.13e-5 | NR | MFP3912908.1 | 2049433 | g213086 | i0 | 36.3 | 1.08764940239044 | 91 | 50 | 99.2 | 3 | 249 | 1 | 129 | 219 | MFP3912908.1 C1 family peptidase [Desulfobacteraceae bacterium] | diamond | 273 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28498677 | 28498677 | PRJNA520845_P_NODE_97347_length_377_cov_0.723684_g95848_i0 | PRJNA520845 | 97347 | 377 | 0.723684 | 2.72828868 | Desulfovermiculus sp. | 2821143 | Bacteria | Bacteria | 175 | 3.11e-54 | NR | MFO7802529.1 | 2821143 | g95848 | i0 | 100 | 0.660477453580902 | 83 | 0 | 66 | 0 | 3 | 251 | 20 | 102 | MFO7802529.1 hypothetical protein [Desulfovermiculus sp.] | diamond | 249 | 175 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfovermiculus | Desulfovermiculus sp. | ||
| 28561710 | 28561710 | PRJNA520845_P_NODE_223767_length_249_cov_0.903409_g222268_i0 | PRJNA520845 | 223767 | 249 | 0.903409 | 2.24948841 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 42.7 | 0.039 | NR | MDW7771268.1 | 2053307 | g222268 | i0 | 38.8 | 0.807228915662651 | 67 | 36 | 79.5 | 3 | 7 | 204 | 224 | 286 | MDW7771268.1 hypothetical protein [Desulfobulbaceae bacterium] | diamond | 201 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 28719473 | 28719473 | PRJNA520845_P_NODE_120347_length_340_cov_1.352060_g118848_i0 | PRJNA520845 | 120347 | 340 | 1.35206 | 4.597004 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 97.1 | 8.430000000000001e-21 | NR | HYA14554.1 | 2928017 | g118848 | i0 | 48.3 | 0.785294117647059 | 89 | 45 | 78.5 | 1 | 2 | 268 | 296 | 383 | HYA14554.1 OmpH family outer membrane protein [Syntrophales bacterium] | diamond | 267 | 97.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 28940711 | 28940711 | PRJNA520845_P_NODE_269888_length_227_cov_2.590909_g268389_i0 | PRJNA520845 | 269888 | 227 | 2.590909 | 5.88136343 | Syntrophus sp. SKADARSKE-3 | 3029837 | Bacteria | Bacteria | 118 | 4.01e-30 | NR | MDQ5984429.1 | 3029837 | g268389 | i0 | 75.7 | 17.6563876651982 | 74 | 18 | 97.8 | 0 | 5 | 226 | 214 | 287 | MDQ5984429.1 Acetyl-CoA acetyltransferase [Syntrophus sp. SKADARSKE-3] | diamond | 4008 | 118 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | Syntrophus sp. SKADARSKE-3 | ||
| 29066923 | 29066923 | PRJNA520845_P_NODE_260148_length_242_cov_0.911243_g258649_i0 | PRJNA520845 | 260148 | 242 | 0.911243 | 2.20520806 | Desulfosudis oleivorans | 181663 | Bacteria | Bacteria | 57.8 | 1.8e-7 | NR | WP_012174578.1 | 181663 | g258649 | i0 | 44.4 | 0.78099173553719 | 63 | 35 | 78.1 | 0 | 198 | 10 | 136 | 198 | WP_012174578.1 ankyrin repeat domain-containing protein [Desulfosudis oleivorans] | diamond | 189 | 57.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosudaceae | Desulfosudis | Desulfosudis oleivorans | ||
| 30045486 | 30045486 | PRJNA520845_P_NODE_173591_length_283_cov_1.100000_g172092_i0 | PRJNA520845 | 173591 | 283 | 1.1 | 3.113 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 53.1 | 1.31e-5 | NR | MBI4804009.1 | 885 | g172092 | i0 | 50 | 0.551236749116608 | 52 | 25 | 55.1 | 1 | 25 | 180 | 321 | 371 | MBI4804009.1 GGDEF domain-containing protein [Desulfovibrio sp.] | diamond | 156 | 53.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 30614266 | 30614266 | PRJNA520845_P_NODE_210113_length_253_cov_1.711111_g208614_i0 | PRJNA520845 | 210113 | 253 | 1.711111 | 4.32911083 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 45.8 | 2.66e-4 | NR | MDR3604296.1 | 2052184 | g208614 | i0 | 46.7 | 1.64822134387352 | 45 | 24 | 53.4 | 0 | 7 | 141 | 11 | 55 | MDR3604296.1 ankyrin repeat domain-containing protein [Syntrophaceae bacterium] | diamond | 417 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 31436066 | 31436066 | PRJNA520845_P_NODE_245076_length_245_cov_0.895349_g243577_i0 | PRJNA520845 | 245076 | 245 | 0.895349 | 2.19360505 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 49.3 | 1.84e-4 | NR | MCD4677405.1 | 2593537 | g243577 | i0 | 46.4 | 1.82448979591837 | 56 | 25 | 64.9 | 2 | 242 | 84 | 24 | 77 | MCD4677405.1 PEGA domain-containing protein [Desulfobacula sp.] | diamond | 447 | 49.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 31436078 | 31436078 | PRJNA520845_P_NODE_262076_length_242_cov_0.911243_g260577_i0 | PRJNA520845 | 262076 | 242 | 0.911243 | 2.20520806 | Desulfovibrionales bacterium | 2448050 | Bacteria | Bacteria | 75.1 | 1.48e-13 | NR | MDK2954721.1 | 2448050 | g260577 | i0 | 45.2 | 1.8099173553719 | 73 | 40 | 90.5 | 0 | 242 | 24 | 882 | 954 | MDK2954721.1 two-component system, sensor histidine kinase and response regulator [Desulfovibrionales bacterium] | diamond | 438 | 75.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionales bacterium | ||||
| 31625832 | 31625832 | PRJNA520845_P_NODE_205916_length_257_cov_1.250000_g204417_i0 | PRJNA520845 | 205916 | 257 | 1.25 | 3.2125 | Desulfatirhabdium butyrativorans | 340467 | Bacteria | Bacteria | 59.3 | 6.3e-8 | NR | WP_028323589.1 | 340467 | g204417 | i0 | 38.3 | 2.83657587548638 | 81 | 48 | 94.6 | 1 | 243 | 1 | 69 | 147 | WP_028323589.1 hypothetical protein [Desulfatirhabdium butyrativorans] | diamond | 729 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfatirhabdiaceae | Desulfatirhabdium | Desulfatirhabdium butyrativorans | ||
| 31752301 | 31752301 | PRJNA520845_P_NODE_220077_length_250_cov_0.870056_g218578_i0 | PRJNA520845 | 220077 | 250 | 0.870056 | 2.17514 | Desulfococcaceae bacterium | 3024398 | Bacteria | Bacteria | 62.4 | 3.45e-9 | NR | MFP4308123.1 | 3024398 | g218578 | i0 | 48.8 | 0.984 | 82 | 36 | 94.8 | 2 | 249 | 13 | 44 | 122 | MFP4308123.1 pyrroline-5-carboxylate reductase [Desulfococcaceae bacterium] | diamond | 246 | 62.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcaceae bacterium | |||
| 31767679 | 31767679 | PRJNA520845_P_NODE_235157_length_247_cov_0.885057_g233658_i0 | PRJNA520845 | 235157 | 247 | 0.885057 | 2.18609079 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47 | 0.00106 | NR | RUM92003.1 | 1874629 | g233658 | i0 | 43.1 | 1.76113360323887 | 51 | 26 | 61.9 | 1 | 175 | 23 | 197 | 244 | RUM92003.1 MAG: hypothetical protein DSZ23_01130 [Thermodesulfatator sp.] | diamond | 435 | 47 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfatatoraceae | Thermodesulfatator | Thermodesulfatator sp. | ||
| 31973860 | 31973860 | PRJNA520845_P_NODE_230218_length_248_cov_0.880000_g228719_i0 | PRJNA520845 | 230218 | 248 | 0.88 | 2.1824 | Desulforhopalus sp. | 2099376 | Bacteria | Bacteria | 43.1 | 0.0277 | NR | MDK9706549.1 | 2099376 | g228719 | i0 | 39.1 | 0.834677419354839 | 69 | 38 | 78.6 | 2 | 52 | 246 | 110 | 178 | MDK9706549.1 DUF362 domain-containing protein [Desulforhopalus sp.] | diamond | 207 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulforhopalus | Desulforhopalus sp. | ||
| 32258935 | 32258935 | PRJNA520845_P_NODE_110078_length_355_cov_1.085106_g108579_i0 | PRJNA520845 | 110078 | 355 | 1.085106 | 3.8521263 | Desulfovermiculus sp. | 2821143 | Bacteria | Bacteria | 48.1 | 2.39e-4 | NR | MFO7802529.1 | 2821143 | g108579 | i0 | 100 | 0.169014084507042 | 20 | 0 | 16.9 | 0 | 295 | 354 | 1 | 20 | MFO7802529.1 hypothetical protein [Desulfovermiculus sp.] | diamond | 60 | 48.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfovermiculus | Desulfovermiculus sp. | ||
| 32700833 | 32700833 | PRJNA520845_P_NODE_262560_length_242_cov_0.911243_g261061_i0 | PRJNA520845 | 262560 | 242 | 0.911243 | 2.20520806 | Deferrisoma camini | 1035120 | Bacteria | Bacteria | 42.4 | 0.0378 | NR | WP_025321177.1 | 1035120 | g261061 | i0 | 47.4 | 0.471074380165289 | 38 | 20 | 47.1 | 0 | 135 | 22 | 106 | 143 | WP_025321177.1 ABC-type transport auxiliary lipoprotein family protein [Deferrisoma camini] | diamond | 114 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Deferrisomatia | Deferrisomatales | Deferrisomataceae | Deferrisoma | Deferrisoma camini | ||
| 32763913 | 32763913 | PRJNA520845_P_NODE_74000_length_432_cov_1.281337_g72501_i0 | PRJNA520845 | 74000 | 432 | 1.281337 | 5.53537584 | Geopsychrobacteraceae bacterium | 3065857 | Bacteria | Bacteria | 64.7 | 5.2e-9 | NR | HKJ05356.1 | 3065857 | g72501 | i0 | 56.6 | 1.84027777777778 | 53 | 22 | 36.8 | 1 | 160 | 2 | 296 | 347 | HKJ05356.1 type III PLP-dependent enzyme [Geopsychrobacteraceae bacterium] | diamond | 795 | 64.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Geopsychrobacteraceae bacterium |
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);;