RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA637328" 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

  • PRJNA637328 · 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
6987525 6987525 PRJNA637328_P_NODE_15646_length_256_cov_0.980676_g15169_i0 PRJNA637328 15646 256 0.980676 2.51053056 unclassified Cetobacterium 2630983 Bacteria Bacteria 88.6 6.96e-19   NR WP_047382480.1 2630983 g15169 i0 89.8 0.57421875 49 5 57.4 0 109 255 149 197 WP_047382480.1 MULTISPECIES: 4-hydroxy-tetrahydrodipicolinate synthase [unclassified Cetobacterium] diamond 147 88.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
26922840 26922840 PRJNA637328_P_NODE_14742_length_260_cov_1.123223_g14265_i0 PRJNA637328 14742 260 1.123223 2.9203798 uncultured Cetobacterium sp. 527638 Bacteria Bacteria 174 1.51e-49   NR WP_294095131.1 527638 g14265 i0 98.8 1.98461538461538 86 1 99.2 0 260 3 67 152 WP_294095131.1 AAA family ATPase [uncultured Cetobacterium sp.] diamond 516 174 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium uncultured Cetobacterium sp.
28944503 28944503 PRJNA637328_P_NODE_15148_length_258_cov_1.454545_g14671_i0 PRJNA637328 15148 258 1.454545 3.7527261 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 156 2.3999999999999996e-44   NR WP_047393843.1 1339239 g14671 i0 89.4 0.988372093023256 85 9 98.8 0 256 2 241 325 WP_047393843.1 SEC-C metal-binding domain-containing protein [Cetobacterium sp. ZOR0034] diamond 255 156 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034
30997336 30997336 PRJNA637328_P_NODE_8254_length_319_cov_1.377778_g7779_i0 PRJNA637328 8254 319 1.377778 4.39511182 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 197 5.0000000000000005e-61   NR WP_052191600.1 1340502 g7779 i0 99 0.968652037617555 103 1 96.9 0 311 3 1 103 WP_052191600.1 RluA family pseudouridine synthase [Cetobacterium sp. ZWU0022] diamond 309 197 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022

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