RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB10320" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJEB10320 · 4 ✖

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
4810372 4810372 PRJEB10320_P_NODE_17064_length_215_cov_2.127778_g16806_i0 PRJEB10320 17064 215 2.127778 4.5747227 Cetobacterium 180162 Bacteria Bacteria 392 9.83e-105   NTclustered gi|2865368125|gb|CP122294.1| 188913 g16806 i0 99.535 537.209302325581 215 1 100 0 1 215 280767 280553 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 115500 392 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
5115946 5115946 PRJEB10320_P_NODE_27985_length_152_cov_1.367521_g27727_i0 PRJEB10320 27985 152 1.367521 2.07863192 Fusobacterium polymorphum 76857 Bacteria Bacteria 161 1.98e-35   NTclustered gi|2706496642|gb|CP084152.1| 76857 g27727 i0 86.806 88.3026315789474 144 19 95 0 6 149 1873400 1873257 Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome blastn 13422 161 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
23934915 23934915 PRJEB10320_P_NODE_7579_length_370_cov_2.035821_g7323_i0 PRJEB10320 7579 370 2.035821 7.5325377 Cetobacterium 180162 Bacteria Bacteria 678 0   NTclustered gi|2865368125|gb|CP122294.1| 188913 g7323 i0 99.73 516.632432432432 370 1 100 0 1 370 279599 279230 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 191154 678 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
25208506 25208506 PRJEB10320_P_NODE_10660_length_297_cov_2.175573_g10402_i0 PRJEB10320 10660 297 2.175573 6.46145181 Cetobacterium 180162 Bacteria Bacteria 549 8.029999999999997e-152   NTclustered gi|2865368125|gb|CP122294.1| 188913 g10402 i0 100 491.888888888889 297 0 100 0 1 297 279852 280148 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 146091 549 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);;