RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1249042 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_clade 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
29094855 29094855 PRJNA1249042_S_NODE_69528_length_188_cov_1.620690_g69314_i0 PRJNA1249042 69528 188 1.62069 3.0468972 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 99.4 1.12e-25   NR MFM9904966.1 2283092 g69314 i0 86.9 1.96276595744681 61 8 97.3 0 1 183 5 65 MFM9904966.1 50S ribosomal protein L29 [Pyrinomonadaceae bacterium] diamond 369 99.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31116052 31116052 PRJNA1249042_S_NODE_115775_length_151_cov_1.305556_g115561_i0 PRJNA1249042 115775 151 1.305556 1.97138956 Terriglobia bacterium 2081523 Bacteria Bacteria 41.2 0.0363   NR MBZ5624850.1 2081523 g115561 i0 39.5 0.754966887417219 38 23 75.5 0 33 146 232 269 MBZ5624850.1 oligogalacturonate lyase family protein [Terriglobia bacterium] diamond 114 41.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
31906944 31906944 PRJNA1249042_S_NODE_14157_length_285_cov_2.396694_g13943_i0 PRJNA1249042 14157 285 2.396694 6.8305779 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 45.1 0.00548   NR HEV2861574.1 2283092 g13943 i0 41.5 0.557894736842105 53 31 55.8 0 59 217 84 136 HEV2861574.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 159 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32065097 32065097 PRJNA1249042_S_NODE_110078_length_154_cov_2.135135_g109864_i0 PRJNA1249042 110078 154 2.135135 3.2881079 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 42.4 0.0156   NR HXK11802.1 2793154 g109864 i0 71.4 0.818181818181818 21 6 40.9 0 29 91 409 429 HXK11802.1 isoleucine--tRNA ligase [Vicinamibacteria bacterium] diamond 126 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria 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);;