contig_metadata
28 rows where bioproject = "PRJEB14175", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25502900 | 25502900 | PRJEB14175_P_NODE_140897_length_288_cov_4.581498_g138630_i0 | PRJEB14175 | 140897 | 288 | 4.581498 | 13.19471424 | Helkesimastix marina | 645121 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.5499999999999998e-24 | NTclustered | gi|237687967|gb|FJ410915.1| | 645121 | g138630 | i0 | 83.453 | 0.482638888888889 | 139 | 19 | 47 | 4 | 1 | 136 | 363 | 226 | Helkesimastix sp. ATCC 50328 18S ribosomal RNA gene, partial sequence | blastn | 139 | 126 | 1 | Eukaryota | Sar | Cercozoa | Helkesimastigidae | Helkesimastix | Helkesimastix marina | ||||
| 25505713 | 25505713 | PRJEB14175_P_NODE_202977_length_226_cov_1.478788_g200710_i0 | PRJEB14175 | 202977 | 226 | 1.478788 | 3.34206088 | uncultured Endomyxa | 1821257 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.19e-14 | NTclustered | gi|2915662025|gb|PV134890.1| | 1821257 | g200710 | i0 | 90.141 | 44.3495575221239 | 71 | 7 | 31 | 0 | 3 | 73 | 5208 | 5138 | Uncultured Endomyxa isolate IOM_2014_24 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 | 10023 | 93.5 | 1 | Eukaryota | Sar | Cercozoa | uncultured Endomyxa | ||||||
| 25506846 | 25506846 | PRJEB14175_P_NODE_23065_length_766_cov_8.887943_g21136_i0 | PRJEB14175 | 23065 | 766 | 8.887943 | 68.08164338 | Rosculus cf. ithacus CCAP 1571/3 | 1808993 | SAR_Eukaryotes | SAR_Eukaryotes | 1352 | 0 | NTclustered | gi|1002343692|gb|KU738570.1| | 1808993 | g21136 | i0 | 99.463 | 43.6031331592689 | 745 | 3 | 97 | 1 | 1 | 744 | 2144 | 1400 | Rosculus cf. ithacus CCAP 1571/3 18S ribosomal RNA gene, partial sequence | blastn | 33400 | 1352 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus cf. ithacus CCAP 1571/3 | ||||
| 25611263 | 25611263 | PRJEB14175_P_NODE_75577_length_422_cov_4.972299_g73318_i0 | PRJEB14175 | 75577 | 422 | 4.972299 | 20.98310178 | Cercomonadida | 188941 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 7.48e-114 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g73318 | i0 | 85.203 | 98.3388625592417 | 419 | 54 | 98 | 7 | 9 | 422 | 1435 | 1020 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 41499 | 425 | 0.997647058823529 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25745427 | 25745427 | PRJEB14175_P_NODE_216058_length_216_cov_2.593548_g213791_i0 | PRJEB14175 | 216058 | 216 | 2.593548 | 5.60206368 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.61e-94 | NTclustered | gi|68271541|gb|DQ086722.1| | 45107 | g213791 | i0 | 99.49 | 90.7638888888889 | 196 | 1 | 91 | 0 | 1 | 196 | 220 | 25 | Heteromita globosa isolate HETEGLOB large subunit ribosomal RNA gene, partial sequence | blastn | 19605 | 357 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25745855 | 25745855 | PRJEB14175_P_NODE_242186_length_205_cov_1.569444_g239918_i0 | PRJEB14175 | 242186 | 205 | 1.569444 | 3.2173602 | Heteromitidae | 45105 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 3.66e-39 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g239918 | i0 | 84.153 | 77.6634146341463 | 183 | 26 | 88 | 3 | 25 | 205 | 1468 | 1649 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15921 | 174 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25747947 | 25747947 | PRJEB14175_P_NODE_92874_length_374_cov_6.044728_g90608_i0 | PRJEB14175 | 92874 | 374 | 6.044728 | 22.60728272 | Rhogostoma | 981201 | SAR_Eukaryotes | SAR_Eukaryotes | 680 | 0 | NTclustered | gi|1012139125|gb|KT251168.1| | 1821242 | g90608 | i0 | 99.467 | 100.248663101604 | 375 | 1 | 100 | 1 | 1 | 374 | 505 | 879 | Uncultured Cryomonadida clone Fr_Ch_45 18S ribosomal RNA gene, partial sequence | blastn | 37493 | 680 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | uncultured Cryomonadida | |||||
| 25777320 | 25777320 | PRJEB14175_P_NODE_190115_length_236_cov_2.285714_g187848_i0 | PRJEB14175 | 190115 | 236 | 2.285714 | 5.39428504 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.96e-57 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g187848 | i0 | 84.583 | 46.4703389830508 | 240 | 33 | 100 | 3 | 1 | 236 | 1639 | 1878 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 10967 | 235 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25778760 | 25778760 | PRJEB14175_P_NODE_225107_length_210_cov_1.718121_g222839_i0 | PRJEB14175 | 225107 | 210 | 1.718121 | 3.6080541 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.27e-36 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g222839 | i0 | 93.805 | 56.3761904761905 | 113 | 2 | 52 | 3 | 91 | 199 | 8286 | 8175 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 11839 | 165 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 25880140 | 25880140 | PRJEB14175_P_NODE_165443_length_259_cov_2.696970_g163176_i0 | PRJEB14175 | 165443 | 259 | 2.69697 | 6.9851523 | Cercomonas | 45109 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.21e-114 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g163176 | i0 | 96.169 | 101.664092664093 | 261 | 8 | 100 | 2 | 1 | 259 | 2770 | 2510 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 26331 | 425 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 | |||
| 25883075 | 25883075 | PRJEB14175_P_NODE_61699_length_472_cov_1.802920_g59444_i0 | PRJEB14175 | 61699 | 472 | 1.80292 | 8.5097824 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 8.939999999999998e-74 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g59444 | i0 | 97.647 | 47.6716101694915 | 170 | 2 | 36 | 2 | 12 | 181 | 3250 | 3417 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 22501 | 291 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 25909679 | 25909679 | PRJEB14175_P_NODE_112092_length_333_cov_11.448529_g109826_i0 | PRJEB14175 | 112092 | 333 | 11.448529 | 38.12360157 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 5.49e-149 | NTclustered | gi|1002343683|gb|KU738561.1| | 175275 | g109826 | i0 | 99.329 | 17.2072072072072 | 298 | 2 | 89 | 0 | 1 | 298 | 298 | 1 | Uncultured Cercozoa clone agricultural_soil25 18S ribosomal RNA gene, partial sequence | blastn | 5730 | 540 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 26047295 | 26047295 | PRJEB14175_P_NODE_144701_length_283_cov_5.360360_g142434_i0 | PRJEB14175 | 144701 | 283 | 5.36036 | 15.1698188 | Rosculus cf. ithacus CCAP 1571/3 | 1808993 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 6.13e-123 | NTclustered | gi|1002343692|gb|KU738570.1| | 1808993 | g142434 | i0 | 98.084 | 22.4840989399293 | 261 | 4 | 92 | 1 | 1 | 261 | 1409 | 1150 | Rosculus cf. ithacus CCAP 1571/3 18S ribosomal RNA gene, partial sequence | blastn | 6363 | 453 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus cf. ithacus CCAP 1571/3 | ||||
| 26050977 | 26050977 | PRJEB14175_P_NODE_226469_length_209_cov_2.283784_g224201_i0 | PRJEB14175 | 226469 | 209 | 2.283784 | 4.77310856 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 7.4e-101 | NTclustered | gi|1402550488|gb|MH488774.1| | 2231170 | g224201 | i0 | 100 | 79.9808612440191 | 205 | 0 | 98 | 0 | 1 | 205 | 1895 | 2099 | Guttulinopsis rogosa isolate FOLDEDA sequence | blastn | 16716 | 379 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 26151967 | 26151967 | PRJEB14175_P_NODE_131477_length_301_cov_42.304167_g129210_i0 | PRJEB14175 | 131477 | 301 | 42.304167 | 127.33554267 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.7999999999999998e-133 | NTclustered | gi|2493707699|dbj|LC764482.1| | 45107 | g129210 | i0 | 97.251 | 96.5581395348837 | 291 | 2 | 95 | 2 | 15 | 301 | 119 | 407 | Heteromita globosa LAP3-2017 gene for 18S rRNA, partial sequence | blastn | 29064 | 488 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 26152871 | 26152871 | PRJEB14175_P_NODE_180389_length_244_cov_5.245902_g178122_i0 | PRJEB14175 | 180389 | 244 | 5.245902 | 12.80000088 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 8.889999999999998e-101 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g178122 | i0 | 96.916 | 25.4713114754098 | 227 | 5 | 93 | 2 | 1 | 227 | 1287 | 1063 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 6215 | 379 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 26183155 | 26183155 | PRJEB14175_P_NODE_136350_length_294_cov_18.798283_g134083_i0 | PRJEB14175 | 136350 | 294 | 18.798283 | 55.26695202 | Cercozoa sp. YPF5 | 1980070 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 7.42e-18 | NTclustered | gi|220983376|dbj|AB453012.1| | 552662 | g134083 | i0 | 84.545 | 11.0374149659864 | 110 | 11 | 36 | 6 | 16 | 122 | 1561 | 1667 | Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 3245 | 104 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. YPF501 | ||||||
| 26288173 | 26288173 | PRJEB14175_P_NODE_143166_length_285_cov_4.000000_g140899_i0 | PRJEB14175 | 143166 | 285 | 4 | 11.4 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.44e-57 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g140899 | i0 | 85.281 | 93.4421052631579 | 231 | 30 | 80 | 4 | 57 | 285 | 1760 | 1988 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 26631 | 235 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 26291750 | 26291750 | PRJEB14175_P_NODE_79958_length_408_cov_13.472622_g77696_i0 | PRJEB14175 | 79958 | 408 | 13.472622 | 54.96829776 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 702 | 0 | NTclustered | gi|33330170|gb|AF534712.1| | 212382 | g77696 | i0 | 99.483 | 90.6960784313726 | 387 | 0 | 95 | 2 | 23 | 408 | 2 | 387 | Cercomonas sp. SmallSA 18S ribosomal RNA gene, partial sequence | blastn | 37004 | 704 | 0.997159090909091 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. SmallSA | |||
| 26320811 | 26320811 | PRJEB14175_P_NODE_178511_length_246_cov_2.875676_g176244_i0 | PRJEB14175 | 178511 | 246 | 2.875676 | 7.07416296 | Pseudopirsonia sp. | 2083298 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.66e-28 | NTclustered | gi|2851478046|gb|PQ590051.1| | 2083298 | g176244 | i0 | 78.733 | 39.2845528455285 | 221 | 37 | 87 | 9 | 1 | 215 | 2832 | 2616 | Pseudopirsonia sp. strain MPL_CcPpc02 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 | 9664 | 139 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Marimonadida | Pseudopirsonia | Pseudopirsonia sp. | |||
| 26324384 | 26324384 | PRJEB14175_P_NODE_263351_length_198_cov_2.715328_g261083_i0 | PRJEB14175 | 263351 | 198 | 2.715328 | 5.37634944 | Verrucomonas longifila | 629764 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 4.64e-23 | NTclustered | gi|290760489|gb|GQ144692.1| | 629764 | g261083 | i0 | 85.47 | 33.4343434343434 | 117 | 15 | 59 | 2 | 78 | 194 | 1245 | 1359 | Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence | blastn | 6620 | 121 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas longifila | |||
| 26324653 | 26324653 | PRJEB14175_P_NODE_270511_length_189_cov_4.718750_g268243_i0 | PRJEB14175 | 270511 | 189 | 4.71875 | 8.9184375 | Paulinella longichromatophora | 1708747 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 5.549999999999999e-37 | NTclustered | gi|1314927581|gb|MG264610.1| | 1708747 | g268243 | i0 | 93.694 | 95.3280423280423 | 111 | 7 | 59 | 0 | 12 | 122 | 53955 | 53845 | Paulinella longichromatophora plastid, complete genome | blastn | 18017 | 167 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella longichromatophora | ||
| 26459175 | 26459175 | PRJEB14175_P_NODE_224896_length_210_cov_2.463087_g222628_i0 | PRJEB14175 | 224896 | 210 | 2.463087 | 5.1724827 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 3.72e-49 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g222628 | i0 | 84.475 | 22.3714285714286 | 219 | 24 | 100 | 6 | 1 | 210 | 1867 | 1650 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 4698 | 207 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 26460928 | 26460928 | PRJEB14175_P_NODE_269120_length_191_cov_2.669231_g266852_i0 | PRJEB14175 | 269120 | 191 | 2.669231 | 5.09823121 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 5.5799999999999996e-42 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g266852 | i0 | 84 | 24.5287958115183 | 200 | 23 | 100 | 5 | 1 | 191 | 1682 | 1881 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 4685 | 183 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 26461698 | 26461698 | PRJEB14175_P_NODE_36040_length_621_cov_19.592857_g33876_i0 | PRJEB14175 | 36040 | 621 | 19.592857 | 121.67164197 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 713 | 0 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g33876 | i0 | 88.264 | 0.974235104669887 | 605 | 59 | 96 | 11 | 19 | 616 | 17533 | 18132 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 605 | 713 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 32927226 | 32927226 | PRJEB14175_P_NODE_71817_length_434_cov_10.718499_g69558_i0 | PRJEB14175 | 71817 | 434 | 10.718499 | 46.51828566 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 3.32e-25 | NR | MES1914063.1 | 1215613 | g69558 | i0 | 78.7 | 1.28571428571429 | 61 | 13 | 42.2 | 0 | 411 | 229 | 126 | 186 | MES1914063.1 Arf GTPase arf1 [Cercozoa sp. M6MM] | diamond | 558 | 105 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 33011051 | 33011051 | PRJEB14175_P_NODE_136652_length_294_cov_3.244635_g134385_i0 | PRJEB14175 | 136652 | 294 | 3.244635 | 9.5392269 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 1.21e-13 | NR | MES1916707.1 | 1215613 | g134385 | i0 | 43.1 | 0.73469387755102 | 72 | 40 | 72.4 | 1 | 47 | 259 | 179 | 250 | MES1916707.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 216 | 74.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 33113154 | 33113154 | PRJEB14175_P_NODE_118247_length_322_cov_34.080460_g115981_i0 | PRJEB14175 | 118247 | 322 | 34.08046 | 109.7390812 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 8.06e-9 | NR | MES1915517.1 | 1215613 | g115981 | i0 | 50.8 | 0.549689440993789 | 59 | 29 | 55 | 0 | 23 | 199 | 265 | 323 | MES1915517.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 177 | 62.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;