RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB55122" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 5 ✖

bioproject 1

  • PRJEB55122 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
120632 120632 PRJEB55122_P_NODE_19201_length_255_cov_2.626214_g18804_i0 PRJEB55122 19201 255 2.626214 6.6968457 Fusobacterium vincentii 155615 Bacteria Bacteria 466 6.98e-127   NTclustered gi|2706461406|gb|CP084075.1| 155615 g18804 i0 99.608 477.878431372549 255 1 100 0 1 255 272106 271852 Fusobacterium vincentii strain SB055 plasmid pSB055A, complete sequence blastn 121859 466 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium vincentii
5223701 5223701 PRJEB55122_P_NODE_37065_length_169_cov_0.866667_g36668_i0 PRJEB55122 37065 169 0.866667 1.46466723 Fusobacterium polymorphum 76857 Bacteria Bacteria 185 1.33e-42   NTclustered gi|958164477|gb|CP013328.1| 76857 g36668 i0 87.117 148.171597633136 163 21 96 0 6 168 163007 163169 Fusobacterium nucleatum subsp. polymorphum strain ChDC F319 genome blastn 25041 185 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
8644902 8644902 PRJEB55122_P_NODE_13727_length_323_cov_1.934307_g13330_i0 PRJEB55122 13727 323 1.934307 6.24781161 Cetobacterium 180162 Bacteria Bacteria 592 1.4499999999999999e-164   NTclustered gi|2865368125|gb|CP122294.1| 188913 g13330 i0 99.69 486.034055727554 323 1 100 0 1 323 279188 279510 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 156989 592 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
17972848 17972848 PRJEB55122_P_NODE_37635_length_168_cov_0.873950_g37238_i0 PRJEB55122 37635 168 0.87395 1.468236 Cetobacterium somerae 188913 Bacteria Bacteria 110 8.26e-20   NTclustered gi|2666488225|gb|CP143319.1| 188913 g37238 i0 81.618 0.80952380952381 136 22 79 1 10 142 1354987 1355122 Cetobacterium somerae strain ceto chromosome, complete genome blastn 136 110 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
23073218 23073218 PRJEB55122_P_NODE_36359_length_169_cov_1.733333_g35962_i0 PRJEB55122 36359 169 1.733333 2.92933277 Fusobacterium mortiferum 850 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|1370540179|gb|CP028102.1| 469616 g35962 i0 100 534.390532544379 169 0 100 0 1 169 104660 104492 Fusobacterium mortiferum ATCC 9817 chromosome, complete genome blastn 90312 313 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium mortiferum

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