contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA515078" 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 | ||
| 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 |
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);;