RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA407087" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA407087 · 4 ✖

analysis 1

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
28938758 28938758 PRJNA407087_S_NODE_9408_length_155_cov_3.357143_g8945_i0 PRJNA407087 9408 155 3.357143 5.20357165 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 83.2 2.73e-18   NR ETO27122.1 46433 g8945 i0 74.5 4.93548387096774 51 13 98.7 0 3 155 93 143 ETO27122.1 citrate synthase [Reticulomyxa filosa] diamond 765 83.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28970261 28970261 PRJNA407087_S_NODE_6468_length_196_cov_2.227545_g6005_i0 PRJNA407087 6468 196 2.227545 4.3659882 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 108 1.1e-26   NR ETO35564.1 46433 g6005 i0 76.6 0.979591836734694 64 15 98 0 4 195 89 152 ETO35564.1 succinyl-coa:alpha-ketoacid-coa transferase [Reticulomyxa filosa] diamond 192 108 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29365863 29365863 PRJNA407087_S_NODE_3909_length_283_cov_2.547244_g3446_i0 PRJNA407087 3909 283 2.547244 7.20870052 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 108 4.59e-25   NR ETO19934.1 46433 g3446 i0 55.8 3.97526501766784 95 40 98.6 1 283 5 7 101 ETO19934.1 hypothetical protein RFI_17287, partial [Reticulomyxa filosa] diamond 1125 108 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31276067 31276067 PRJNA407087_S_NODE_6635_length_193_cov_2.286585_g6172_i0 PRJNA407087 6635 193 2.286585 4.41310905 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 75.5 7.91e-15   NR ETO27975.1 46433 g6172 i0 56.5 0.963730569948187 62 27 96.4 0 192 7 34 95 ETO27975.1 hypothetical protein RFI_09160 [Reticulomyxa filosa] diamond 186 75.5 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);;