RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA799842", tax_clade = "Sar" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA799842 · 3 ✖

tax_kingdom 0

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
4622041 4622041 PRJNA799842_P_NODE_152184_length_248_cov_0.880000_g150611_i0 PRJNA799842 152184 248 0.88 2.1824 Globobulimina turgida 313609 SAR_Eukaryotes SAR_Eukaryotes 279 9.45e-71   NTclustered gi|529159362|gb|KF170448.1| 313609 g150611 i0 87.815 34.3911290322581 238 29 96 0 11 248 249 12 Globobulimina turgida beta-tubulin type 1 isoform 3 gene, partial cds blastn 8529 279 1 Eukaryota Sar   Foraminifera   Rotaliida Buliminidae Globobulimina Globobulimina turgida
28317353 28317353 PRJNA799842_P_NODE_157966_length_247_cov_0.885057_g156393_i0 PRJNA799842 157966 247 0.885057 2.18609079 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.65e-4   NR ETO14801.1 46433 g156393 i0 36.8 0.923076923076923 76 31 92.3 1 246 19 78 136 ETO14801.1 hypothetical protein RFI_22567 [Reticulomyxa filosa] diamond 228 48.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30654200 30654200 PRJNA799842_P_NODE_148293_length_249_cov_0.875000_g146720_i0 PRJNA799842 148293 249 0.875 2.17875 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 124 9.3e-31   NR ETO33766.1 46433 g146720 i0 75.6 0.939759036144578 78 19 94 0 14 247 6 83 ETO33766.1 phosphoprotein phosphatase A [Reticulomyxa filosa] diamond 234 124 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;