RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA700095" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA700095 · 3 ✖

analysis 1

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
6288298 6288298 PRJNA700095_P_NODE_64825_length_241_cov_1.827381_g63561_i0 PRJNA700095 64825 241 1.827381 4.40398821 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 80.1 2.41e-15   NR MEK6596999.1 2026742 g63561 i0 56.2 0.908713692946058 73 28 90.9 1 220 2 229 297 MEK6596999.1 response regulator [Gemmatimonadota bacterium] diamond 219 80.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29861631 29861631 PRJNA700095_P_NODE_5111_length_873_cov_10.172500_g4122_i0 PRJNA700095 5111 873 10.1725 88.805925 Longimicrobium sp. 2029185 Bacteria Bacteria 121 3.41e-29   NR HEX2080112.1 2029185 g4122 i0 36.8 3.65979381443299 220 121 73.9 8 90 734 2 208 HEX2080112.1 hypothetical protein [Longimicrobium sp.] diamond 3195 121 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31832144 31832144 PRJNA700095_P_NODE_13517_length_512_cov_2.218679_g12262_i0 PRJNA700095 13517 512 2.218679 11.35963648 Bacteria 2 Bacteria Bacteria 166 1.76e-45   NR HVT40705.1 2026741 g12262 i0 51.2 6.73828125 164 75 96.1 2 21 512 218 376 HVT40705.1 4-coumarate--CoA ligase family protein [Gemmatimonadaceae bacterium] diamond 3450 166 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium

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