RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA299585" and tax_phylum = "Fusobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fusobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA299585 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
28702544 28702544 PRJNA299585_S_NODE_13807_length_166_cov_3.832117_g13577_i0 PRJNA299585 13807 166 3.832117 6.36131422 Cetobacterium 180162 Bacteria Bacteria 99 6.88e-25   NR WP_297597736.1 527638 g13577 i0 79.2 1.91566265060241 53 11 95.8 0 166 8 62 114 WP_297597736.1 Fur family transcriptional regulator [uncultured Cetobacterium sp.] diamond 318 100 0.99 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium uncultured Cetobacterium sp.
28969091 28969091 PRJNA299585_S_NODE_14688_length_159_cov_2.876923_g14458_i0 PRJNA299585 14688 159 2.876923 4.57430757 unclassified Cetobacterium 2630983 Bacteria Bacteria 104 3.0500000000000003e-27   NR WP_047383608.1 2630983 g14458 i0 100 0.981132075471698 52 0 98.1 0 2 157 22 73 WP_047383608.1 MULTISPECIES: desulfoferrodoxin family protein [unclassified Cetobacterium] diamond 156 104 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
31211195 31211195 PRJNA299585_S_NODE_12735_length_176_cov_2.292517_g12505_i0 PRJNA299585 12735 176 2.292517 4.03482992 Cetobacterium 180162 Bacteria Bacteria 93.6 1.1e-23   NR WP_291941138.1 180162 g12505 i0 88.1 0.715909090909091 42 5 71.6 0 51 176 1 42 WP_291941138.1 MULTISPECIES: rubredoxin [Cetobacterium] diamond 126 93.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  

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