contig_metadata
11 rows where bioproject = "PRJNA1158727", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1579121 | 1579121 | PRJNA1158727_P_NODE_167862_length_215_cov_7.957746_g160400_i0 | PRJNA1158727 | 167862 | 215 | 7.957746 | 17.1091539 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 7.6e-106 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g160400 | i0 | 100 | 22.7488372093023 | 214 | 0 | 99 | 0 | 1 | 214 | 2194 | 2407 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 4891 | 396 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1580560 | 1580560 | PRJNA1158727_P_NODE_59042_length_431_cov_2.597765_g51581_i0 | PRJNA1158727 | 59042 | 431 | 2.597765 | 11.19636715 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 791 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g51581 | i0 | 99.768 | 75.5243619489559 | 431 | 1 | 100 | 0 | 1 | 431 | 1683 | 2113 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 32551 | 791 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5406787 | 5406787 | PRJNA1158727_P_NODE_12885_length_1434_cov_5.044820_g9421_i0 | PRJNA1158727 | 12885 | 1434 | 5.04482 | 72.3427188 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 8.699999999999998e-249 | NR | MES1909605.1 | 1215613 | g9421 | i0 | 77.1 | 5.54602510460251 | 433 | 99 | 90.6 | 0 | 1423 | 125 | 1 | 433 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 7953 | 701 | 0.991440798858773 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 7956962 | 7956962 | PRJNA1158727_P_NODE_133607_length_252_cov_1.698324_g126146_i0 | PRJNA1158727 | 133607 | 252 | 1.698324 | 4.27977648 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 6.89e-127 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g126146 | i0 | 100 | 100.420634920635 | 252 | 0 | 100 | 0 | 1 | 252 | 699 | 448 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25306 | 466 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9234353 | 9234353 | PRJNA1158727_P_NODE_76128_length_351_cov_3.384892_g68667_i0 | PRJNA1158727 | 76128 | 351 | 3.384892 | 11.88097092 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 6.459999999999999e-74 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g68667 | i0 | 82.621 | 51.5042735042735 | 351 | 39 | 99 | 14 | 3 | 351 | 4021 | 3691 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18078 | 291 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13059617 | 13059617 | PRJNA1158727_P_NODE_60991_length_419_cov_4.228324_g53530_i0 | PRJNA1158727 | 60991 | 419 | 4.228324 | 17.71667756 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 774 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g53530 | i0 | 100 | 19.0883054892601 | 419 | 0 | 100 | 0 | 1 | 419 | 352 | 770 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 7998 | 774 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 13060143 | 13060143 | PRJNA1158727_P_NODE_80411_length_338_cov_1.743396_g72950_i0 | PRJNA1158727 | 80411 | 338 | 1.743396 | 5.89267848 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 619 | 6.969999999999999e-173 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g72950 | i0 | 99.704 | 26.689349112426 | 338 | 1 | 100 | 0 | 1 | 338 | 587 | 250 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 9021 | 619 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14335131 | 14335131 | PRJNA1158727_P_NODE_70752_length_371_cov_2.493289_g63291_i0 | PRJNA1158727 | 70752 | 371 | 2.493289 | 9.25010219 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.01e-50 | NR | MES1910907.1 | 1215613 | g63291 | i0 | 66.7 | 1.98921832884097 | 123 | 41 | 99.5 | 0 | 371 | 3 | 1 | 123 | MES1910907.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 738 | 169 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 15607282 | 15607282 | PRJNA1158727_P_NODE_167053_length_227_cov_3.194805_g159591_i0 | PRJNA1158727 | 167053 | 227 | 3.194805 | 7.25220735 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.38e-93 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g159591 | i0 | 98.039 | 2.37004405286344 | 204 | 4 | 90 | 0 | 1 | 204 | 68 | 271 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 538 | 355 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17615315 | 17615315 | PRJNA1158727_P_NODE_156434_length_243_cov_1.358824_g148972_i0 | PRJNA1158727 | 156434 | 243 | 1.358824 | 3.30194232 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 7.08e-77 | NTclustered | gi|302026201|gb|GQ377711.1| | 323453 | g148972 | i0 | 88.889 | 94.7530864197531 | 243 | 27 | 100 | 0 | 1 | 243 | 349 | 107 | Heteromita sp. PRA-74 alpha-tubulin-like mRNA, partial sequence | blastn | 23025 | 300 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 26692078 | 26692078 | PRJNA1158727_P_NODE_158961_length_242_cov_1.751479_g151499_i0 | PRJNA1158727 | 158961 | 242 | 1.751479 | 4.23857918 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.72e-29 | NR | MES1907458.1 | 1215613 | g151499 | i0 | 68.8 | 0.991735537190083 | 80 | 25 | 99.2 | 0 | 1 | 240 | 31 | 110 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 240 | 115 | 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);;