RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJEB3181 · 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
26780222 26780222 PRJEB3181_S_NODE_7441_length_229_cov_3.603093_g7148_i0 PRJEB3181 7441 229 3.603093 8.25108297 Cetobacterium 180162 Bacteria Bacteria 85.5 4e-20   NR WP_047384514.1 180162 g7148 i0 100 0.510917030567686 39 0 51.1 0 125 9 1 39 WP_047384514.1 MULTISPECIES: indolepyruvate ferredoxin oxidoreductase subunit alpha [Cetobacterium] diamond 117 85.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
28738694 28738694 PRJEB3181_S_NODE_15287_length_166_cov_2.251908_g14994_i0 PRJEB3181 15287 166 2.251908 3.73816728 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 73.6 1.4e-14   NR WP_047384902.1 1340502 g14994 i0 92.3 2.1144578313253 39 3 70.5 0 50 166 1 39 WP_047384902.1 hypothetical protein [Cetobacterium sp. ZWU0022] diamond 351 73.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
29117736 29117736 PRJEB3181_P_NODE_20509_length_181_cov_1.853333_g20245_i0 PRJEB3181 20509 181 1.853333 3.35453273 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 120 4.15e-33   NR WP_047395902.1 1339239 g20245 i0 96.7 0.994475138121547 60 2 99.4 0 181 2 15 74 WP_047395902.1 hypothetical protein [Cetobacterium sp. ZOR0034] diamond 180 120 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034
31676668 31676668 PRJEB3181_S_NODE_1757_length_386_cov_3.692308_g1466_i0 PRJEB3181 1757 386 3.692308 14.25230888 unclassified Cetobacterium 2630983 Bacteria Bacteria 128 1.26e-35   NR WP_047381601.1 2630983 g1466 i0 100 0.715025906735751 92 0 71.5 0 36 311 1 92 WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] diamond 276 128 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);;