RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA797475", 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 · 3 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJNA797475 · 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
27275204 27275204 PRJNA797475_P_NODE_15603_length_280_cov_1.777778_g15504_i0 PRJNA797475 15603 280 1.777778 4.9777784 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 190 3.9499999999999996e-54   NR HWJ24585.1 2026741 g15504 i0 98.9 0.996428571428571 93 1 99.6 0 280 2 38 130 HWJ24585.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium] diamond 279 190 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30180189 30180189 PRJNA797475_P_NODE_25252_length_247_cov_0.885057_g25153_i0 PRJNA797475 25252 247 0.885057 2.18609079 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 99.8 6.6e-24   NR HEY8104798.1 2448054 g25153 i0 60.5 1.96761133603239 81 32 98.4 0 245 3 125 205 HEY8104798.1 aquaporin [Gemmatimonadales bacterium] diamond 486 99.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31136957 31136957 PRJNA797475_P_NODE_13695_length_291_cov_0.802752_g13596_i0 PRJNA797475 13695 291 0.802752 2.33600832 Bacteria 2 Bacteria Bacteria 102 6.72e-23   NR HEY0995648.1 2026741 g13596 i0 52.1 4.94845360824742 96 46 99 0 289 2 210 305 HEY0995648.1 PAS domain-containing sensor histidine kinase [Gemmatimonadaceae bacterium] diamond 1440 102 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);;