RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA940501", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA940501 · 4 ✖

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
26620469 26620469 PRJNA940501_S_NODE_229121_length_184_cov_1.666667_g228303_i0 PRJNA940501 229121 184 1.666667 3.06666728 Hallerella 2815788 Bacteria Bacteria 124 4.79e-33   NR WP_353846859.1 2815788 g228303 i0 100 1.98913043478261 61 0 99.5 0 184 2 106 166 WP_353846859.1 MULTISPECIES: RhuM family protein [Hallerella] diamond 366 124 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Hallerella  
29172809 29172809 PRJNA940501_S_NODE_317469_length_164_cov_1.090909_g316651_i0 PRJNA940501 317469 164 1.090909 1.78909076 Fibrobacter sp. 35828 Bacteria Bacteria 103 4.630000000000001e-27   NR WP_405333699.1 35828 g316651 i0 88.7 0.969512195121951 53 6 97 0 1 159 30 82 WP_405333699.1 phage holin family protein [Fibrobacter sp.] diamond 159 103 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
29614299 29614299 PRJNA940501_S_NODE_231710_length_183_cov_2.835714_g230892_i0 PRJNA940501 231710 183 2.835714 5.18935662 Fibrobacter sp. UWB5 1964360 Bacteria Bacteria 106 1.92e-25   NR WP_088627128.1 1964360 g230892 i0 93.3 0.983606557377049 60 4 98.4 0 2 181 306 365 WP_088627128.1 ABC transporter permease [Fibrobacter sp. UWB5] diamond 180 106 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp. UWB5
32869470 32869470 PRJNA940501_S_NODE_38980_length_303_cov_2.592308_g38162_i0 PRJNA940501 38980 303 2.592308 7.85469324 Fibrobacter sp. 35828 Bacteria Bacteria 44.3 0.016   NR MBR6450909.1 35828 g38162 i0 40 0.643564356435644 65 34 62.4 2 1 189 81 142 MBR6450909.1 phosphodiesterase [Fibrobacter sp.] diamond 195 44.3 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.

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