RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA358049 · 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
27074829 27074829 PRJNA358049_S_NODE_11302_length_194_cov_1.372414_g11254_i0 PRJNA358049 11302 194 1.372414 2.66248316 Pseudoleptotrichia goodfellowii 157692 Bacteria Bacteria 75.9 1.56e-15   NR WP_036056043.1 157692 g11254 i0 84.3 0.788659793814433 51 7 78.9 1 166 14 1 50 WP_036056043.1 hypothetical protein [Pseudoleptotrichia goodfellowii] diamond 153 75.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudoleptotrichia Pseudoleptotrichia goodfellowii
28180065 28180065 PRJNA358049_S_NODE_16586_length_167_cov_0.881356_g16538_i0 PRJNA358049 16586 167 0.881356 1.47186452 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 48.5 1.22e-4   NR WP_053393131.1 712357 g16538 i0 45.5 0.988023952095808 55 30 98.8 0 166 2 459 513 WP_053393131.1 autotransporter domain-containing protein [Leptotrichia sp. oral taxon 212] diamond 165 48.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
29537880 29537880 PRJNA358049_S_NODE_13650_length_181_cov_1.007576_g13602_i0 PRJNA358049 13650 181 1.007576 1.82371256 Leptotrichia sp. 104608 Bacteria Bacteria 119 1.22e-29   NR MBF1332944.1 104608 g13602 i0 98.3 1.95580110497238 59 1 97.8 0 3 179 481 539 MBF1332944.1 alanine--tRNA ligase [Leptotrichia sp.] diamond 354 119 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia 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);;