RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA596867 · 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
2415794 2415794 PRJNA596867_P_NODE_14762_length_242_cov_0.911243_g14687_i0 PRJNA596867 14762 242 0.911243 2.20520806 Cetobacterium 180162 Bacteria Bacteria 418 1.8699999999999998e-112   NTclustered gi|2666488225|gb|CP143319.1| 188913 g14687 i0 97.934 100.02479338843 242 4 100 1 1 242 479360 479120 Cetobacterium somerae strain ceto chromosome, complete genome blastn 24206 418 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
4968549 4968549 PRJNA596867_P_NODE_8264_length_288_cov_0.967442_g8189_i0 PRJNA596867 8264 288 0.967442 2.78623296 Cetobacterium 180162 Bacteria Bacteria 520 6.079999999999999e-143   NTclustered gi|2865368125|gb|CP122294.1| 188913 g8189 i0 99.303 513.211805555556 287 2 99 0 2 288 278818 279104 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 147805 520 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
20266882 20266882 PRJNA596867_P_NODE_14536_length_242_cov_10.071006_g14461_i0 PRJNA596867 14536 242 10.071006 24.37183452 Cetobacterium 180162 Bacteria Bacteria 442 1.1099999999999995e-119   NTclustered gi|2865368125|gb|CP122294.1| 188913 g14461 i0 99.587 503.479338842975 242 1 100 0 1 242 278913 278672 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 121842 442 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae

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