contig_metadata
21 rows where bioproject = "PRJNA193544", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2330516 | 2330516 | PRJNA193544_S_NODE_2102_length_187_cov_23479.088608_g2087_i0 | PRJNA193544 | 2102 | 187 | 23479.088608 | 43905.89569696 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 5.4e-47 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2087 | i0 | 90.323 | 101.288770053476 | 155 | 11 | 82 | 3 | 1 | 154 | 3255 | 3406 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 18941 | 200 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2330531 | 2330531 | PRJNA193544_S_NODE_3182_length_156_cov_22.314961_g3167_i0 | PRJNA193544 | 3182 | 156 | 22.314961 | 34.81133916 | root | 1 | Root_unresolved | Root_unresolved | 267 | 4.2199999999999997e-67 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g3167 | i0 | 98.039 | 50.0576923076923 | 153 | 3 | 98 | 0 | 4 | 156 | 2311 | 2159 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 7809 | 267 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 2916541 | 2916541 | PRJNA193544_S_NODE_1903_length_195_cov_22020.174699_g1888_i0 | PRJNA193544 | 1903 | 195 | 22020.174699 | 42939.34066305 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 9.25e-65 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g1888 | i0 | 95.122 | 203.692307692308 | 164 | 8 | 84 | 0 | 32 | 195 | 2653 | 2490 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 39720 | 259 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 2916557 | 2916557 | PRJNA193544_S_NODE_263_length_369_cov_55.985294_g248_i0 | PRJNA193544 | 263 | 369 | 55.985294 | 206.58573486 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 2.32e-113 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g248 | i0 | 90.966 | 75.8644986449865 | 321 | 17 | 87 | 7 | 49 | 369 | 1882 | 1574 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 27994 | 422 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 4192965 | 4192965 | PRJNA193544_S_NODE_1464_length_215_cov_17.086022_g1449_i0 | PRJNA193544 | 1464 | 215 | 17.086022 | 36.7349473 | Mesofila limnetica | 1979842 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.02e-35 | NTclustered | gi|88792585|gb|DQ386166.1| | 1979842 | g1449 | i0 | 81.281 | 98.6790697674419 | 203 | 35 | 93 | 3 | 14 | 214 | 1688 | 1889 | Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence | blastn | 21216 | 161 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila limnetica | ||||
| 5469232 | 5469232 | PRJNA193544_S_NODE_265_length_369_cov_33.717647_g250_i0 | PRJNA193544 | 265 | 369 | 33.717647 | 124.41811743 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 5.13e-95 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g250 | i0 | 87.539 | 87.7127371273713 | 321 | 28 | 87 | 7 | 1 | 321 | 1574 | 1882 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 32366 | 361 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 8019259 | 8019259 | PRJNA193544_S_NODE_2167_length_184_cov_24808.858065_g2152_i0 | PRJNA193544 | 2167 | 184 | 24808.858065 | 45648.2988396 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 4.06e-53 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g2152 | i0 | 92.763 | 0.826086956521739 | 152 | 11 | 83 | 0 | 1 | 152 | 2038 | 2189 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 152 | 220 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 8707963 | 8707963 | PRJNA193544_S_NODE_1487_length_214_cov_64.464865_g1472_i0 | PRJNA193544 | 1487 | 214 | 64.464865 | 137.9548111 | Lecythium | 238772 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.1199999999999995e-101 | NTclustered | gi|49356806|gb|AY605210.1| | 175275 | g1472 | i0 | 99.522 | 98.2242990654206 | 209 | 1 | 98 | 0 | 6 | 214 | 637 | 429 | Uncultured cercozoan clone Sey075 small subunit ribosomal RNA gene, partial sequence | blastn | 21020 | 381 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 8707965 | 8707965 | PRJNA193544_S_NODE_1647_length_205_cov_21988.511364_g1632_i0 | PRJNA193544 | 1647 | 205 | 21988.511364 | 45076.4482962 | Lecythium | 238772 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.61e-77 | NTclustered | gi|49356806|gb|AY605210.1| | 175275 | g1632 | i0 | 98.256 | 83.7951219512195 | 172 | 3 | 84 | 0 | 34 | 205 | 447 | 276 | Uncultured cercozoan clone Sey075 small subunit ribosomal RNA gene, partial sequence | blastn | 17178 | 302 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 9983280 | 9983280 | PRJNA193544_S_NODE_2008_length_191_cov_844.049383_g1993_i0 | PRJNA193544 | 2008 | 191 | 844.049383 | 1612.13432153 | Chlamydophryidae | 862251 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 9.02e-65 | NTclustered | gi|1198038655|gb|KX580622.1| | 2004638 | g1993 | i0 | 97.368 | 79.0890052356021 | 152 | 4 | 80 | 0 | 25 | 176 | 347 | 196 | Lecythium jennyae strain KD1014 18S ribosomal RNA gene, partial sequence | blastn | 15106 | 259 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium jennyae | ||
| 10569969 | 10569969 | PRJNA193544_S_NODE_2769_length_166_cov_3.934307_g2754_i0 | PRJNA193544 | 2769 | 166 | 3.934307 | 6.53094962 | Cercomonas sp. HFCC53 | 458867 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 6.069999999999999e-46 | NTclustered | gi|161015705|gb|EF681939.1| | 458867 | g2754 | i0 | 88.024 | 3.01807228915663 | 167 | 18 | 100 | 2 | 1 | 166 | 507 | 342 | Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence | blastn | 501 | 196 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC53 | |||
| 10569992 | 10569992 | PRJNA193544_S_NODE_829_length_268_cov_2597.523013_g814_i0 | PRJNA193544 | 829 | 268 | 2597.523013 | 6961.36167484 | Cercozoa sp. CC-2009d | 629762 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 8.7e-12 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g814 | i0 | 73.991 | 26.9514925373134 | 223 | 50 | 81 | 6 | 51 | 268 | 2316 | 2097 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 7223 | 84.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 11844441 | 11844441 | PRJNA193544_S_NODE_1770_length_201_cov_8.750000_g1755_i0 | PRJNA193544 | 1770 | 201 | 8.75 | 17.5875 | uncultured Endomyxa | 1821257 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.2e-21 | NTclustered | gi|2915662025|gb|PV134890.1| | 1821257 | g1755 | i0 | 80.921 | 3.02487562189055 | 152 | 24 | 75 | 5 | 52 | 201 | 5917 | 5769 | 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 | 608 | 115 | 1 | Eukaryota | Sar | Cercozoa | uncultured Endomyxa | ||||||
| 11844446 | 11844446 | PRJNA193544_S_NODE_1950_length_193_cov_23542.737805_g1935_i0 | PRJNA193544 | 1950 | 193 | 23542.737805 | 45437.48396365 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 5.74e-32 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g1935 | i0 | 90.991 | 49.2487046632124 | 111 | 10 | 58 | 0 | 83 | 193 | 431 | 321 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 9505 | 150 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 15668689 | 15668689 | PRJNA193544_S_NODE_2193_length_184_cov_4.922581_g2178_i0 | PRJNA193544 | 2193 | 184 | 4.922581 | 9.05754904 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.08e-83 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g2178 | i0 | 100 | 9.21195652173913 | 174 | 0 | 95 | 0 | 11 | 184 | 356 | 529 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 1695 | 322 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 16943185 | 16943185 | PRJNA193544_S_NODE_614_length_299_cov_51.377778_g599_i0 | PRJNA193544 | 614 | 299 | 51.377778 | 153.61955622 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.49e-79 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g599 | i0 | 88.39 | 72.3612040133779 | 267 | 18 | 89 | 6 | 1 | 267 | 3663 | 3916 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21636 | 309 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18217588 | 18217588 | PRJNA193544_S_NODE_2375_length_178_cov_53.986577_g2360_i0 | PRJNA193544 | 2375 | 178 | 53.986577 | 96.09610706 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.34e-82 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2360 | i0 | 98.876 | 100.35393258427 | 178 | 2 | 100 | 0 | 1 | 178 | 1016 | 839 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 17863 | 318 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 18906692 | 18906692 | PRJNA193544_S_NODE_2195_length_184_cov_3.954839_g2180_i0 | PRJNA193544 | 2195 | 184 | 3.954839 | 7.27690376 | Cercomonas | 45109 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 7.0000000000000015e-31 | NTclustered | gi|223047882|gb|FJ032646.1| | 595691 | g2180 | i0 | 81.72 | 100.516304347826 | 186 | 25 | 100 | 8 | 1 | 184 | 1754 | 1932 | Cercomonadida sp. C15_1A03 28S ribosomal RNA gene, partial sequence | blastn | 18495 | 147 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadida sp. C15_1A03 | |||||
| 19491898 | 19491898 | PRJNA193544_S_NODE_3396_length_152_cov_5.252033_g3381_i0 | PRJNA193544 | 3396 | 152 | 5.252033 | 7.98309016 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 7.17e-30 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g3381 | i0 | 85.417 | 28.9210526315789 | 144 | 13 | 92 | 5 | 1 | 140 | 1656 | 1795 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 4396 | 143 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20767433 | 20767433 | PRJNA193544_S_NODE_3237_length_155_cov_5.103175_g3222_i0 | PRJNA193544 | 3237 | 155 | 5.103175 | 7.90992125 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.16e-67 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g3222 | i0 | 98.052 | 100.625806451613 | 154 | 3 | 99 | 0 | 2 | 155 | 1533 | 1380 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 15597 | 268 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 23317975 | 23317975 | PRJNA193544_S_NODE_1239_length_229_cov_3093.275000_g1224_i0 | PRJNA193544 | 1239 | 229 | 3093.275 | 7083.59975 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 5.11e-78 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g1224 | i0 | 97.207 | 19.4454148471616 | 179 | 5 | 78 | 0 | 51 | 229 | 2216 | 2038 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 4453 | 303 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina |
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);;