contig_metadata
18 rows where bioproject = "PRJNA591127", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1840593 | 1840593 | PRJNA591127_P_NODE_21562_length_191_cov_3.337662_g21393_i0 | PRJNA591127 | 21562 | 191 | 3.337662 | 6.37493442 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 1.87e-91 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g21393 | i0 | 99.476 | 75.2198952879581 | 191 | 1 | 100 | 0 | 1 | 191 | 499 | 309 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 14367 | 348 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5668893 | 5668893 | PRJNA591127_P_NODE_3625_length_378_cov_3.636364_g3457_i0 | PRJNA591127 | 3625 | 378 | 3.636364 | 13.74545592 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 699 | 0 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g3457 | i0 | 100 | 49.478835978836 | 378 | 0 | 100 | 0 | 1 | 378 | 2107 | 1730 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 18703 | 699 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 6943138 | 6943138 | PRJNA591127_P_NODE_1146_length_614_cov_2.769497_g1008_i0 | PRJNA591127 | 1146 | 614 | 2.769497 | 17.00471158 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 1129 | 0 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g1008 | i0 | 99.837 | 18.4674267100977 | 614 | 1 | 100 | 0 | 1 | 614 | 631 | 18 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 11339 | 1129 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 6943237 | 6943237 | PRJNA591127_P_NODE_21686_length_190_cov_3.830065_g21517_i0 | PRJNA591127 | 21686 | 190 | 3.830065 | 7.2771235 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.02e-31 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g21517 | i0 | 81.026 | 13.7157894736842 | 195 | 29 | 99 | 7 | 1 | 189 | 2111 | 2303 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 2606 | 148 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 6943358 | 6943358 | PRJNA591127_P_NODE_9426_length_239_cov_17.524752_g9258_i0 | PRJNA591127 | 9426 | 239 | 17.524752 | 41.88415728 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 3.9199999999999986e-119 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g9258 | i0 | 100 | 41.7238493723849 | 238 | 0 | 99 | 0 | 2 | 239 | 358 | 121 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 9972 | 440 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9493490 | 9493490 | PRJNA591127_P_NODE_26148_length_162_cov_3.288000_g25979_i0 | PRJNA591127 | 26148 | 162 | 3.288 | 5.32656 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9.44e-74 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g25979 | i0 | 100 | 5.71604938271605 | 156 | 0 | 96 | 0 | 7 | 162 | 2900 | 2745 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 926 | 289 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9493502 | 9493502 | PRJNA591127_P_NODE_27168_length_157_cov_5.116667_g26999_i0 | PRJNA591127 | 27168 | 157 | 5.116667 | 8.03316719 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 3.31e-63 | NTclustered | gi|1402550486|gb|MH488772.1| | 2231170 | g26999 | i0 | 100 | 44.8407643312102 | 137 | 0 | 87 | 0 | 1 | 137 | 1393 | 1529 | Guttulinopsis rogosa isolate T1 small subunit ribosomal RNA gene, partial sequence | blastn | 7040 | 254 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 10067493 | 10067493 | PRJNA591127_P_NODE_5808_length_304_cov_2.011236_g5640_i0 | PRJNA591127 | 5808 | 304 | 2.011236 | 6.11415744 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 555 | 1.7699999999999994e-153 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g5640 | i0 | 99.67 | 29.9539473684211 | 303 | 1 | 99 | 0 | 1 | 303 | 1144 | 842 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 9106 | 555 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 10769468 | 10769468 | PRJNA591127_P_NODE_949_length_666_cov_34.359300_g821_i0 | PRJNA591127 | 949 | 666 | 34.3593 | 228.832938 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 603 | 1.4599999999999999e-167 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g821 | i0 | 99.696 | 97.8393393393393 | 329 | 1 | 98 | 0 | 2 | 330 | 30 | 358 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 65161 | 603 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12044178 | 12044178 | PRJNA591127_P_NODE_22550_length_184_cov_2.095238_g22381_i0 | PRJNA591127 | 22550 | 184 | 2.095238 | 3.85523792 | Rhogostoma leviosa | 2691105 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.01e-84 | NTclustered | gi|1787214106|gb|MN860277.1| | 2691105 | g22381 | i0 | 98.37 | 99.9565217391304 | 184 | 3 | 100 | 0 | 1 | 184 | 230 | 47 | Rhogostoma leviosa strain W2 small subunit ribosomal RNA gene, partial sequence | blastn | 18392 | 324 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Rhogostomidae | Rhogostoma | Rhogostoma leviosa | ||
| 12617726 | 12617726 | PRJNA591127_P_NODE_11330_length_219_cov_1.280220_g11161_i0 | PRJNA591127 | 11330 | 219 | 1.28022 | 2.8036818 | Rosculus | 373137 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.77e-67 | NTclustered | gi|1002343691|gb|KU738569.1| | 1808988 | g11161 | i0 | 88.696 | 16.7899543378995 | 230 | 13 | 100 | 10 | 1 | 219 | 334 | 107 | Rosculus elongata isolate S14D1 18S ribosomal RNA gene, partial sequence | blastn | 3677 | 268 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus elongata | ||||
| 13319007 | 13319007 | PRJNA591127_P_NODE_1971_length_492_cov_37.092308_g1814_i0 | PRJNA591127 | 1971 | 492 | 37.092308 | 182.49415536 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 904 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1814 | i0 | 99.797 | 24.0142276422764 | 492 | 1 | 100 | 0 | 1 | 492 | 316 | 807 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 11815 | 904 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17142807 | 17142807 | PRJNA591127_P_NODE_374_length_947_cov_115.805495_g303_i0 | PRJNA591127 | 374 | 947 | 115.805495 | 1096.67803765 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 2.33e-97 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g303 | i0 | 98.122 | 33.6631467793031 | 213 | 3 | 22 | 1 | 284 | 496 | 2 | 213 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31879 | 370 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17142823 | 17142823 | PRJNA591127_P_NODE_5854_length_303_cov_1.909774_g5686_i0 | PRJNA591127 | 5854 | 303 | 1.909774 | 5.78661522 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 5.42e-84 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g5686 | i0 | 86.23 | 43.4950495049505 | 305 | 35 | 100 | 6 | 1 | 303 | 3709 | 4008 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 13179 | 324 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19691384 | 19691384 | PRJNA591127_P_NODE_13956_length_197_cov_5.656250_g13787_i0 | PRJNA591127 | 13956 | 197 | 5.65625 | 11.1428125 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 1.929999999999999e-96 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g13787 | i0 | 100 | 100.319796954315 | 197 | 0 | 100 | 0 | 1 | 197 | 1037 | 841 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 19763 | 364 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20967337 | 20967337 | PRJNA591127_P_NODE_3197_length_399_cov_20.088398_g3029_i0 | PRJNA591127 | 3197 | 399 | 20.088398 | 80.15270802 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 699 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3029 | i0 | 98.246 | 92.7919799498747 | 399 | 7 | 100 | 0 | 1 | 399 | 2180 | 1782 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 37024 | 699 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22816108 | 22816108 | PRJNA591127_P_NODE_538_length_830_cov_9.865069_g446_i0 | PRJNA591127 | 538 | 830 | 9.865069 | 81.8800727 | Cercozoa sp. DMV | 1342330 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.13e-147 | NR | BAN37425.1 | 1342330 | g446 | i0 | 72.5 | 4.98795180722892 | 276 | 76 | 99.8 | 0 | 3 | 830 | 147 | 422 | BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] | diamond | 4140 | 429 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. DMV | ||||||
| 30237680 | 30237680 | PRJNA591127_P_NODE_26832_length_159_cov_1.786885_g26663_i0 | PRJNA591127 | 26832 | 159 | 1.786885 | 2.84114715 | Lotharella oceanica | 641309 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 2.87e-11 | NR | AIB09582.1 | 641309 | g26663 | i0 | 57.7 | 0.981132075471698 | 52 | 22 | 98.1 | 0 | 3 | 158 | 3 | 54 | AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] | diamond | 156 | 62 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella oceanica |
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);;