RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA812715" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 5 ✖

bioproject 1

  • PRJNA812715 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
3365793 3365793 PRJNA812715_P_NODE_96483_length_258_cov_2.497297_g94682_i0 PRJNA812715 96483 258 2.497297 6.44302626 unclassified Cetobacterium 2630983 Bacteria Bacteria 166 1.3699999999999998e-48   NR WP_047382551.1 2630983 g94682 i0 100 0.988372093023256 85 0 98.8 0 257 3 37 121 WP_047382551.1 MULTISPECIES: 3-deoxy-7-phosphoheptulonate synthase [unclassified Cetobacterium] diamond 255 166 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
11016946 11016946 PRJNA812715_P_NODE_35689_length_486_cov_1.305085_g33904_i0 PRJNA812715 35689 486 1.305085 6.3427131 Streptobacillus moniliformis 34105 Bacteria Bacteria 169 2.62e-51   NR WP_196759730.1 34105 g33904 i0 95.6 1.12345679012346 91 4 56.2 0 273 1 1 91 WP_196759730.1 NADH-quinone oxidoreductase subunit H, partial [Streptobacillus moniliformis] diamond 546 169 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
28317654 28317654 PRJNA812715_P_NODE_87786_length_272_cov_1.547739_g85985_i0 PRJNA812715 87786 272 1.547739 4.20985008 unclassified Cetobacterium 2630983 Bacteria Bacteria 184 2.8799999999999997e-56   NR WP_047384271.1 2630983 g85985 i0 100 0.992647058823529 90 0 99.3 0 1 270 144 233 WP_047384271.1 MULTISPECIES: UDP-3-O-acyl-N-acetylglucosamine deacetylase [unclassified Cetobacterium] diamond 270 184 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
29485593 29485593 PRJNA812715_P_NODE_116150_length_244_cov_0.900585_g114349_i0 PRJNA812715 116150 244 0.900585 2.1974274 unclassified Cetobacterium 2630983 Bacteria Bacteria 150 2.26e-43   NR WP_047384075.1 2630983 g114349 i0 100 0.983606557377049 80 0 98.4 0 242 3 52 131 WP_047384075.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] diamond 240 150 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
31571505 31571505 PRJNA812715_P_NODE_97856_length_256_cov_2.344262_g96055_i0 PRJNA812715 97856 256 2.344262 6.00131072 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 154 3.859999999999999e-42   NR WP_047384298.1 1340502 g96055 i0 98.8 0.99609375 85 1 99.6 0 256 2 264 348 WP_047384298.1 peptidylprolyl isomerase [Cetobacterium sp. ZWU0022] diamond 255 154 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);;