RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA804229 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
7600173 7600173 PRJNA804229_S_NODE_186446_length_151_cov_0.888889_g185488_i0 PRJNA804229 186446 151 0.888889 1.34222239 Fusobacterium 848 Bacteria Bacteria 279 5.19e-71   NTclustered gi|2446175567|gb|CP117964.1| 851 g185488 i0 100 488.033112582781 151 0 100 0 1 151 995884 996034 Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome blastn 73693 279 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
18656455 18656455 PRJNA804229_S_NODE_76175_length_233_cov_1.515789_g75217_i0 PRJNA804229 76175 233 1.515789 3.53178837 Fusobacterium hwasookii 1583098 Bacteria Bacteria 52.8 0.021   NTclustered gi|1890961856|gb|CP060114.1| 1583098 g75217 i0 94.118 0.145922746781116 34 2 15 0 98 131 8552 8519 Fusobacterium hwasookii strain KCOM 1249 plasmid pFh1249-2, complete sequence blastn 34 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
19928733 19928733 PRJNA804229_S_NODE_124236_length_183_cov_1.371429_g123278_i0 PRJNA804229 124236 183 1.371429 2.50971507 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 158 3.21e-34   NTclustered gi|1276712381|gb|CP024701.1| 2663009 g123278 i0 93.396 45.4371584699454 106 7 58 0 78 183 2167856 2167751 Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome blastn 8315 158 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
20348338 20348338 PRJNA804229_S_NODE_130536_length_179_cov_0.882353_g129578_i0 PRJNA804229 130536 179 0.882353 1.57941187 Fusobacterium 848 Bacteria Bacteria 318 1.35e-82   NTclustered gi|2706504035|gb|CP084159.1| 76857 g129578 i0 99.429 467.458100558659 175 1 98 0 1 175 284833 285007 Fusobacterium polymorphum strain KCOM1330 chromosome, complete genome blastn 83675 320 0.99375 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum

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