RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA784979", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 5 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 5 ✖

bioproject 1

  • PRJNA784979 · 5 ✖

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
29642732 29642732 PRJNA784979_S_NODE_12750_length_162_cov_1.035398_g12708_i0 PRJNA784979 12750 162 1.035398 1.67734476 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 58.5 1.75e-8   NR MBP9106038.1 2026741 g12708 i0 55.8 0.962962962962963 52 23 96.3 0 2 157 78 129 MBP9106038.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 156 58.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30780334 30780334 PRJNA784979_S_NODE_11334_length_165_cov_0.879310_g11292_i0 PRJNA784979 11334 165 0.87931 1.4508615 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 69.3 4.72e-12   NR MBM4186319.1 2026742 g11292 i0 56.4 1 55 24 100 0 1 165 267 321 MBM4186319.1 MBL fold metallo-hydrolase [Gemmatimonadota bacterium] diamond 165 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31263648 31263648 PRJNA784979_S_NODE_11935_length_164_cov_0.886957_g11893_i0 PRJNA784979 11935 164 0.886957 1.45460948 FCB group 1783270 Bacteria Bacteria 41.2 0.0447   NR MBK9410230.1 2026742 g11893 i0 45.1 3.64024390243902 51 28 93.3 0 10 162 36 86 MBK9410230.1 hypothetical protein [Gemmatimonadota bacterium] diamond 597 41.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31453528 31453528 PRJNA784979_S_NODE_5556_length_207_cov_1.272152_g5514_i0 PRJNA784979 5556 207 1.272152 2.63335464 root 1 Root_unresolved Root_unresolved 108 1.56e-25   NR KPK66790.1 1703358 g5514 i0 67.2 3.88405797101449 67 22 97.1 0 207 7 580 646 KPK66790.1 MAG: hypothetical protein AMS21_01150 [Gemmatimonas sp. SG8_38_2] diamond 804 108 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp. SG8_38_2
32054348 32054348 PRJNA784979_S_NODE_12798_length_162_cov_0.902655_g12756_i0 PRJNA784979 12798 162 0.902655 1.4623011 Bacteria 2 Bacteria Bacteria 103 9.76e-25   NR HVE36404.1 2026741 g12756 i0 98.1 13.7407407407407 53 1 98.1 0 2 160 184 236 HVE36404.1 phosphatidylserine/phosphatidylglycerophosphate/cardiolipin synthase family protein [Gemmatimonadaceae bacterium] diamond 2226 103 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);;