RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1240805", 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

  • PRJNA1240805 · 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
27484361 27484361 PRJNA1240805_P_NODE_5203_length_200_cov_3.913907_g5154_i0 PRJNA1240805 5203 200 3.913907 7.827814 Gemmatimonas sp. UBA7669 1946568 Bacteria Bacteria 91.7 1.72e-21   NR WP_291163877.1 1946568 g5154 i0 96.1 0.765 51 2 76.5 0 13 165 114 164 WP_291163877.1 thioredoxin-dependent thiol peroxidase [Gemmatimonas sp. UBA7669] diamond 153 91.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp. UBA7669
28228424 28228424 PRJNA1240805_P_NODE_5006_length_204_cov_3.470968_g4957_i0 PRJNA1240805 5006 204 3.470968 7.08077472 Gemmatimonas 173479 Bacteria Bacteria 120 6.94e-30   NR WP_291155381.1 1946568 g4957 i0 88.5 1.79411764705882 61 7 89.7 0 185 3 488 548 WP_291155381.1 WD40/YVTN/BNR-like repeat-containing protein [Gemmatimonas sp. UBA7669] diamond 366 120 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp. UBA7669
29473238 29473238 PRJNA1240805_P_NODE_2850_length_279_cov_7.252174_g2801_i0 PRJNA1240805 2850 279 7.252174 20.23356546 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 168 4.34e-50   NR MFN0181132.1 2448054 g2801 i0 89.9 1.91397849462366 89 9 95.7 0 11 277 122 210 MFN0181132.1 restriction endonuclease [Gemmatimonadales bacterium] diamond 534 168 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales 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);;