RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA839281" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 3 ✖

bioproject 1

  • PRJNA839281 · 3 ✖

analysis 1

  • blastn · 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
829768 829768 PRJNA839281_S_NODE_28941_length_166_cov_0.871795_g28672_i0 PRJNA839281 28941 166 0.871795 1.4471797 Leptotrichia buccalis 40542 Bacteria Bacteria 302 1.2500000000000001e-77   NTclustered gi|257048753|gb|CP001685.1| 523794 g28672 i0 99.398 3.90361445783133 166 1 100 0 1 166 711415 711580 Leptotrichia buccalis DSM 1135, complete genome blastn 648 302 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
17807951 17807951 PRJNA839281_S_NODE_36174_length_162_cov_0.902655_g35905_i0 PRJNA839281 36174 162 0.902655 1.4623011 Fusobacterium 848 Bacteria Bacteria 300 4.36e-77   NTclustered gi|2269773925|gb|CP100429.1| 76857 g35905 i0 100 99.0061728395062 162 0 100 0 1 162 655520 655681 Fusobacterium polymorphum strain SSMR1 chromosome, complete genome blastn 16039 300 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
23782146 23782146 PRJNA839281_S_NODE_35379_length_162_cov_0.902655_g35110_i0 PRJNA839281 35379 162 0.902655 1.4623011 Sneathia vaginalis 187101 Bacteria Bacteria 289 9.44e-74   NTclustered gi|2769795739|gb|CP160094.1| 187101 g35110 i0 98.765 3.8641975308642 162 2 100 0 1 162 1207301 1207462 Sneathia vaginalis strain CCUG_64370 chromosome, complete genome blastn 626 289 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Sneathia Sneathia vaginalis

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