contig_metadata
26 rows where bioproject = "PRJNA515078", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486742 | 486742 | PRJNA515078_P_NODE_13921_length_236_cov_3.190955_g13688_i0 | PRJNA515078 | 13921 | 236 | 3.190955 | 7.5306538 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 4.999999999999999e-118 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g13688 | i0 | 100 | 29.0974576271186 | 236 | 0 | 100 | 0 | 1 | 236 | 2165 | 2400 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 6867 | 436 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5590726 | 5590726 | PRJNA515078_P_NODE_4745_length_438_cov_10.366584_g4512_i0 | PRJNA515078 | 4745 | 438 | 10.366584 | 45.40563792 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 582 | 1.2099999999999996e-161 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4512 | i0 | 98.777 | 100.96803652968 | 327 | 4 | 96 | 0 | 1 | 327 | 2136 | 1810 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 44224 | 582 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6214420 | 6214420 | PRJNA515078_P_NODE_2005_length_688_cov_3.771121_g1813_i0 | PRJNA515078 | 2005 | 688 | 3.771121 | 25.94531248 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 7.28e-141 | NTclustered | gi|238617636|gb|FJ973397.1| | 45107 | g1813 | i0 | 85.2 | 81.7369186046512 | 500 | 74 | 73 | 0 | 1 | 500 | 578 | 1077 | Heteromita globosa strain ATCC 50780 actin (act) gene, partial cds | blastn | 56235 | 514 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 6864530 | 6864530 | PRJNA515078_P_NODE_13706_length_238_cov_3.532338_g13473_i0 | PRJNA515078 | 13706 | 238 | 3.532338 | 8.40696444 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 7.53e-17 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g13473 | i0 | 76.087 | 7.59663865546218 | 230 | 33 | 96 | 15 | 1 | 228 | 3812 | 4021 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 1808 | 100 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 10039535 | 10039535 | PRJNA515078_P_NODE_9148_length_301_cov_2.674242_g8915_i0 | PRJNA515078 | 9148 | 301 | 2.674242 | 8.04946842 | Thaumatomonas | 45099 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.79e-138 | NTclustered | gi|33309605|gb|AF411259.1| | 188939 | g8915 | i0 | 97.01 | 98.5946843853821 | 301 | 8 | 100 | 1 | 1 | 301 | 334 | 35 | Thaumatomonas seravini 18S ribosomal RNA gene, complete sequence | blastn | 29677 | 505 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 11965687 | 11965687 | PRJNA515078_P_NODE_6230_length_376_cov_14.755162_g5997_i0 | PRJNA515078 | 6230 | 376 | 14.755162 | 55.47940912 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.8400000000000001e-109 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g5997 | i0 | 86.544 | 54.25 | 379 | 42 | 100 | 8 | 1 | 376 | 4032 | 3660 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20398 | 409 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13240800 | 13240800 | PRJNA515078_P_NODE_32791_length_153_cov_4.370690_g32558_i0 | PRJNA515078 | 32791 | 153 | 4.37069 | 6.6871557 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.0799999999999995e-72 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g32558 | i0 | 100 | 93.2875816993464 | 153 | 0 | 100 | 0 | 1 | 153 | 983 | 831 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14273 | 283 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15139038 | 15139038 | PRJNA515078_P_NODE_31832_length_155_cov_2.533898_g31599_i0 | PRJNA515078 | 31832 | 155 | 2.533898 | 3.9275419 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 3.23e-68 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g31599 | i0 | 98.065 | 98.8258064516129 | 155 | 3 | 100 | 0 | 1 | 155 | 2722 | 2568 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15318 | 270 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 15139051 | 15139051 | PRJNA515078_P_NODE_4612_length_447_cov_1.882927_g4380_i0 | PRJNA515078 | 4612 | 447 | 1.882927 | 8.41668369 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 604 | 2.6499999999999985e-168 | NTclustered | gi|238617670|gb|FJ973414.1| | 646463 | g4380 | i0 | 91.051 | 100.013422818792 | 447 | 40 | 100 | 0 | 1 | 447 | 237 | 683 | Gymnophrys sp. ATCC 50923 alpha-tubulin (atub) gene, partial cds | blastn | 44706 | 610 | 0.99016393442623 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 15789582 | 15789582 | PRJNA515078_P_NODE_28793_length_162_cov_2.184000_g28560_i0 | PRJNA515078 | 28793 | 162 | 2.184 | 3.53808 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.03e-75 | NTclustered | gi|161015724|gb|EF681958.1| | 188939 | g28560 | i0 | 99.387 | 92.4506172839506 | 163 | 0 | 100 | 1 | 1 | 162 | 708 | 870 | Thaumatomonas seravini strain HFCC58 28S ribosomal RNA gene, partial sequence | blastn | 14977 | 294 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 16413684 | 16413684 | PRJNA515078_P_NODE_6993_length_353_cov_2.145570_g6760_i0 | PRJNA515078 | 6993 | 353 | 2.14557 | 7.5738621 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.76e-50 | NR | MES1911029.1 | 1215613 | g6760 | i0 | 75.7 | 0.977337110481586 | 115 | 28 | 97.7 | 0 | 352 | 8 | 17 | 131 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 345 | 172 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 19612860 | 19612860 | PRJNA515078_P_NODE_2016_length_685_cov_11.046296_g1824_i0 | PRJNA515078 | 2016 | 685 | 11.046296 | 75.6671276 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 658 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g1824 | i0 | 87.136 | 95.7372262773723 | 583 | 71 | 85 | 4 | 1 | 581 | 313 | 893 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 65580 | 658 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22163555 | 22163555 | PRJNA515078_P_NODE_13398_length_241_cov_2.794118_g13165_i0 | PRJNA515078 | 13398 | 241 | 2.794118 | 6.73382438 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 5.129999999999999e-118 | NTclustered | gi|116222192|gb|DQ980477.1| | 407209 | g13165 | i0 | 99.177 | 45.195020746888 | 243 | 0 | 100 | 2 | 1 | 241 | 2319 | 2077 | Thaumatomonas sp. TMT002 large subunit ribosomal RNA gene, partial sequence | blastn | 10892 | 436 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 22163564 | 22163564 | PRJNA515078_P_NODE_1438_length_814_cov_27.472329_g1278_i0 | PRJNA515078 | 1438 | 814 | 27.472329 | 223.62475806 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 634 | 6.389999999999998e-177 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g1278 | i0 | 85.855 | 68.5859950859951 | 608 | 72 | 79 | 11 | 218 | 814 | 1943 | 1339 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 55829 | 634 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23439205 | 23439205 | PRJNA515078_P_NODE_1359_length_833_cov_8.095477_g1200_i0 | PRJNA515078 | 1359 | 833 | 8.095477 | 67.43532341 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 856 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1200 | i0 | 86.101 | 52.8571428571429 | 813 | 92 | 96 | 18 | 32 | 833 | 1 | 803 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 44030 | 856 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24062922 | 24062922 | PRJNA515078_P_NODE_33219_length_153_cov_0.913793_g32986_i0 | PRJNA515078 | 33219 | 153 | 0.913793 | 1.39810329 | Cercozoa | 136419 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 2.07e-10 | NTclustered | gi|290760481|gb|GQ144684.1| | 361426 | g32986 | i0 | 92.593 | 48.8823529411765 | 54 | 4 | 35 | 0 | 100 | 153 | 2679 | 2732 | Ebria tripartita large subunit ribosomal RNA gene, partial sequence | blastn | 7479 | 78.7 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ebriacea | Ebria | Ebria tripartita | |||
| 27835138 | 27835138 | PRJNA515078_P_NODE_26504_length_169_cov_1.181818_g26271_i0 | PRJNA515078 | 26504 | 169 | 1.181818 | 1.99727242 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 1.27e-6 | NR | MES1907419.1 | 1215613 | g26271 | i0 | 52.1 | 0.85207100591716 | 48 | 23 | 85.2 | 0 | 162 | 19 | 156 | 203 | MES1907419.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 144 | 53.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27866717 | 27866717 | PRJNA515078_P_NODE_13845_length_237_cov_1.755000_g13612_i0 | PRJNA515078 | 13845 | 237 | 1.755 | 4.15935 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 8.55e-36 | NR | ADK26622.1 | 323453 | g13612 | i0 | 84.3 | 0.886075949367089 | 70 | 11 | 88.6 | 0 | 2 | 211 | 61 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 210 | 127 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29634629 | 29634629 | PRJNA515078_P_NODE_6930_length_355_cov_1.946541_g6697_i0 | PRJNA515078 | 6930 | 355 | 1.946541 | 6.91022055 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 4.82e-35 | NR | MES1911029.1 | 1215613 | g6697 | i0 | 59.3 | 1.8169014084507 | 118 | 44 | 96.3 | 2 | 353 | 12 | 155 | 272 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 645 | 132 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29761172 | 29761172 | PRJNA515078_P_NODE_22991_length_181_cov_1.083333_g22758_i0 | PRJNA515078 | 22991 | 181 | 1.083333 | 1.96083273 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 9.89e-15 | NR | ADK26622.1 | 323453 | g22758 | i0 | 90 | 0.662983425414365 | 40 | 4 | 66.3 | 0 | 60 | 179 | 1 | 40 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 120 | 73.2 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29792716 | 29792716 | PRJNA515078_P_NODE_31011_length_157_cov_1.625000_g30778_i0 | PRJNA515078 | 31011 | 157 | 1.625 | 2.55125 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00238 | NR | MES1909263.1 | 1215613 | g30778 | i0 | 51.5 | 1.5859872611465 | 33 | 16 | 63.1 | 0 | 57 | 155 | 2785 | 2817 | MES1909263.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 249 | 44.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30425186 | 30425186 | PRJNA515078_P_NODE_7253_length_346_cov_1.440129_g7020_i0 | PRJNA515078 | 7253 | 346 | 1.440129 | 4.98284634 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.23e-18 | NR | ADK26624.1 | 323453 | g7020 | i0 | 72.7 | 0.476878612716763 | 55 | 15 | 47.7 | 0 | 345 | 181 | 222 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 165 | 89 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 30456698 | 30456698 | PRJNA515078_P_NODE_29213_length_161_cov_1.879032_g28980_i0 | PRJNA515078 | 29213 | 161 | 1.879032 | 3.02524152 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 5.53e-4 | NR | AAT09077.1 | 227086 | g28980 | i0 | 47.9 | 2.6832298136646 | 48 | 21 | 89.4 | 1 | 148 | 5 | 1 | 44 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 432 | 45.8 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 31182706 | 31182706 | PRJNA515078_P_NODE_18435_length_202_cov_1.890909_g18202_i0 | PRJNA515078 | 18435 | 202 | 1.890909 | 3.81963618 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 6.59e-29 | NR | ADK26624.1 | 323453 | g18202 | i0 | 77.6 | 0.995049504950495 | 67 | 15 | 99.5 | 0 | 1 | 201 | 137 | 203 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 201 | 113 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 31689001 | 31689001 | PRJNA515078_P_NODE_9437_length_296_cov_2.250965_g9204_i0 | PRJNA515078 | 9437 | 296 | 2.250965 | 6.6628564 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00128 | NR | MES1910542.1 | 1215613 | g9204 | i0 | 42.2 | 0.456081081081081 | 45 | 25 | 44.6 | 1 | 39 | 170 | 3871 | 3915 | MES1910542.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 135 | 47.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32732474 | 32732474 | PRJNA515078_P_NODE_29860_length_160_cov_1.235772_g29627_i0 | PRJNA515078 | 29860 | 160 | 1.235772 | 1.9772352 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 1.57e-11 | NR | MES1913677.1 | 1215613 | g29627 | i0 | 57.8 | 6.075 | 45 | 19 | 84.4 | 0 | 15 | 149 | 71 | 115 | MES1913677.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 972 | 65.1 | 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);;