contig_metadata
7 rows where bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2011974 | 2011974 | PRJNA758088_P_NODE_225102_length_284_cov_1.137441_g218131_i0 | PRJNA758088 | 225102 | 284 | 1.137441 | 3.23033244 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 8.539999999999999e-72 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g218131 | i0 | 85.985 | 65.6232394366197 | 264 | 37 | 93 | 0 | 21 | 284 | 1749 | 2012 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 18637 | 283 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 2013825 | 2013825 | PRJNA758088_P_NODE_350762_length_243_cov_0.905882_g343791_i0 | PRJNA758088 | 350762 | 243 | 0.905882 | 2.20129326 | Rosculus incognitus | 2231162 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 5.21e-113 | NTclustered | gi|1402550483|gb|MH488769.1| | 2231162 | g343791 | i0 | 97.934 | 7.440329218107 | 242 | 5 | 99 | 0 | 1 | 242 | 248 | 489 | Rosculus incognitus isolate ATCC 50577 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1808 | 420 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus incognitus | ||||
| 4565066 | 4565066 | PRJNA758088_P_NODE_273844_length_254_cov_1.701657_g266873_i0 | PRJNA758088 | 273844 | 254 | 1.701657 | 4.32220878 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.67e-48 | NTclustered | gi|1402550488|gb|MH488774.1| | 2231170 | g266873 | i0 | 83.929 | 26.5472440944882 | 224 | 27 | 88 | 8 | 32 | 254 | 1715 | 1500 | Guttulinopsis rogosa isolate FOLDEDA sequence | blastn | 6743 | 206 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 9664864 | 9664864 | PRJNA758088_P_NODE_255448_length_265_cov_1.604167_g248477_i0 | PRJNA758088 | 255448 | 265 | 1.604167 | 4.25104255 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.07e-35 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g248477 | i0 | 87.857 | 35.8339622641509 | 140 | 15 | 53 | 2 | 126 | 265 | 3852 | 3715 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 9496 | 163 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 12216002 | 12216002 | PRJNA758088_P_NODE_257510_length_264_cov_1.251309_g250539_i0 | PRJNA758088 | 257510 | 264 | 1.251309 | 3.30345576 | Rosculus hawesi | 2231161 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.5799999999999996e-118 | NTclustered | gi|1402550478|gb|MH488764.1| | 2231161 | g250539 | i0 | 96.958 | 9.9280303030303 | 263 | 4 | 99 | 2 | 4 | 264 | 840 | 1100 | Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence | blastn | 2621 | 438 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus hawesi | ||||
| 28095258 | 28095258 | PRJNA758088_P_NODE_298485_length_249_cov_0.875000_g291514_i0 | PRJNA758088 | 298485 | 249 | 0.875 | 2.17875 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0149 | NR | MES1912058.1 | 1215613 | g291514 | i0 | 34.8 | 0.831325301204819 | 69 | 40 | 83.1 | 1 | 18 | 224 | 99 | 162 | MES1912058.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 207 | 43.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31759713 | 31759713 | PRJNA758088_P_NODE_290257_length_250_cov_0.870056_g283286_i0 | PRJNA758088 | 290257 | 250 | 0.870056 | 2.17514 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.66e-10 | NR | MES1917315.1 | 1215613 | g283286 | i0 | 38.8 | 0.96 | 80 | 48 | 94.8 | 1 | 10 | 246 | 136 | 215 | MES1917315.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 240 | 65.9 | 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);;