contig_metadata
9 rows where bioproject = "PRJNA867519", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5951490 | 5951490 | PRJNA867519_P_NODE_5365_length_466_cov_2.226463_g5211_i0 | PRJNA867519 | 5365 | 466 | 2.226463 | 10.37531758 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 1.69e-82 | NR | MES1914943.1 | 1215613 | g5211 | i0 | 81.3 | 1.99570815450644 | 155 | 29 | 99.8 | 0 | 465 | 1 | 329 | 483 | MES1914943.1 Adenosylhomocysteinase 1 [Cercozoa sp. M6MM] | diamond | 930 | 261 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 18699442 | 18699442 | PRJNA867519_P_NODE_22395_length_265_cov_1.359375_g22241_i0 | PRJNA867519 | 22395 | 265 | 1.359375 | 3.60234375 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.24e-57 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g22241 | i0 | 90.503 | 45.3924528301887 | 179 | 16 | 68 | 1 | 4 | 182 | 3696 | 3873 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 12029 | 235 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 22524880 | 22524880 | PRJNA867519_P_NODE_32518_length_242_cov_1.473373_g32364_i0 | PRJNA867519 | 32518 | 242 | 1.473373 | 3.56556266 | Clathrulina elegans | 238774 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 5.81e-33 | NTclustered | gi|33089911|gb|AY283754.1| | 238774 | g32364 | i0 | 87.879 | 17.6363636363636 | 132 | 14 | 54 | 2 | 65 | 195 | 784 | 654 | Clathrulina elegans isolate Cla70_1 actin mRNA, partial cds | blastn | 4268 | 154 | 1 | Eukaryota | Sar | Cercozoa | Clathrulinidae | Clathrulina | Clathrulina elegans | ||||
| 26675014 | 26675014 | PRJNA867519_P_NODE_2941_length_599_cov_1.638783_g2790_i0 | PRJNA867519 | 2941 | 599 | 1.638783 | 9.81631017 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 8.59e-20 | NR | MES1913063.1 | 1215613 | g2790 | i0 | 43.1 | 2.09348914858097 | 123 | 65 | 61.6 | 2 | 2 | 370 | 367 | 484 | MES1913063.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1254 | 97.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27244786 | 27244786 | PRJNA867519_P_NODE_8403_length_384_cov_1.237942_g8249_i0 | PRJNA867519 | 8403 | 384 | 1.237942 | 4.75369728 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.5000000000000002e-22 | NR | MES1910692.1 | 1215613 | g8249 | i0 | 42.6 | 3.875 | 122 | 66 | 92.2 | 1 | 29 | 382 | 34 | 155 | MES1910692.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1488 | 97.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29044828 | 29044828 | PRJNA867519_P_NODE_22068_length_266_cov_1.611399_g21914_i0 | PRJNA867519 | 22068 | 266 | 1.611399 | 4.28632134 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 1.75e-8 | NR | MES1916707.1 | 1215613 | g21914 | i0 | 45.8 | 0.665413533834586 | 59 | 32 | 66.5 | 0 | 10 | 186 | 186 | 244 | MES1916707.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 177 | 60.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29518189 | 29518189 | PRJNA867519_P_NODE_31210_length_244_cov_0.900585_g31056_i0 | PRJNA867519 | 31210 | 244 | 0.900585 | 2.1974274 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.9e-12 | NR | MES1906886.1 | 1215613 | g31056 | i0 | 45.8 | 3.55327868852459 | 72 | 39 | 88.5 | 0 | 240 | 25 | 140 | 211 | MES1906886.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 867 | 70.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31540581 | 31540581 | PRJNA867519_P_NODE_2476_length_642_cov_1.884007_g2327_i0 | PRJNA867519 | 2476 | 642 | 1.884007 | 12.09532494 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 1.09e-30 | NR | MES1907597.1 | 1215613 | g2327 | i0 | 43.9 | 1.83644859813084 | 139 | 77 | 64.5 | 1 | 642 | 229 | 26 | 164 | MES1907597.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1179 | 125 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32521586 | 32521586 | PRJNA867519_P_NODE_7079_length_413_cov_1.891176_g6925_i0 | PRJNA867519 | 7079 | 413 | 1.891176 | 7.81055688 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 2.87e-9 | NR | ACF24554.1 | 67809 | g6925 | i0 | 30.5 | 0.929782082324455 | 128 | 74 | 83.5 | 3 | 68 | 412 | 19 | 144 | ACF24554.1 putative SNF4 kinase-activating protein [Gymnochlora stellata] | diamond | 384 | 65.1 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata |
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);;