RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1074408", tax_kingdom = "Fusobacteriati" 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

  • Fusobacteriati · 3 ✖

bioproject 1

  • PRJNA1074408 · 3 ✖

analysis 1

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
9944687 9944687 PRJNA1074408_S_NODE_4408_length_221_cov_1.808989_g4278_i0 PRJNA1074408 4408 221 1.808989 3.99786569 Leptotrichia 32067 Bacteria Bacteria 392 1.0199999999999999e-104   NTclustered gi|470484715|ref|NR_076664.1| 40542 g4278 i0 99.535 147.389140271493 215 1 97 0 7 221 402 188 Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence blastn 32573 392 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
13769857 13769857 PRJNA1074408_S_NODE_9511_length_153_cov_1.372727_g9381_i0 PRJNA1074408 9511 153 1.372727 2.10027231 Leptotrichia 32067 Bacteria Bacteria 278 1.9e-70   NTclustered gi|470484715|ref|NR_076664.1| 40542 g9381 i0 99.346 224.254901960784 153 1 100 0 1 153 1453 1301 Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence blastn 34311 278 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia buccalis
25242799 25242799 PRJNA1074408_S_NODE_4900_length_209_cov_1.837349_g4770_i0 PRJNA1074408 4900 209 1.837349 3.84005941 Leptotrichia 32067 Bacteria Bacteria 303 4.58e-78   NTclustered gi|1227268105|gb|CP016753.1| 712368 g4770 i0 92.823 166.200956937799 209 15 100 0 1 209 594134 593926 Leptotrichia sp. oral taxon 498, complete genome blastn 34736 303 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 498

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