RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 6 ✖

bioproject 1

  • PRJNA630162 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
21553182 21553182 PRJNA630162_P_NODE_150597_length_164_cov_1.678261_g149074_i0 PRJNA630162 150597 164 1.678261 2.75234804 Fusobacteriaceae bacterium 2053555 Bacteria Bacteria 116 2.6399999999999997e-32   NR MBP6408539.1 2053555 g149074 i0 100 0.98780487804878 54 0 98.8 0 1 162 8 61 MBP6408539.1 thioredoxin [Fusobacteriaceae bacterium] diamond 162 116 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae   Fusobacteriaceae bacterium
28817274 28817274 PRJNA630162_P_NODE_138588_length_167_cov_1.516949_g137065_i0 PRJNA630162 138588 167 1.516949 2.53330483 Caviibacter abscessus 1766719 Bacteria Bacteria 78.6 2.44e-17   NR WP_068267579.1 1766719 g137065 i0 87.5 0.862275449101796 48 6 86.2 0 144 1 1 48 WP_068267579.1 HU family DNA-binding protein [Caviibacter abscessus] diamond 144 78.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Caviibacter Caviibacter abscessus
29386200 29386200 PRJNA630162_P_NODE_91489_length_191_cov_1.218310_g89966_i0 PRJNA630162 91489 191 1.21831 2.3269721 Oceanivirga salmonicida 1769291 Bacteria Bacteria 87.4 3.16e-18   NR WP_156285905.1 1769291 g89966 i0 61.3 0.973821989528796 62 24 97.4 0 187 2 24 85 WP_156285905.1 extracellular solute-binding protein [Oceanivirga salmonicida] diamond 186 87.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Oceanivirga Oceanivirga salmonicida
30712531 30712531 PRJNA630162_P_NODE_146374_length_165_cov_1.732759_g144851_i0 PRJNA630162 146374 165 1.732759 2.85905235 Leptotrichiaceae bacterium 2782225 Bacteria Bacteria 79.3 1.46e-15   NR MBP6103392.1 2782225 g144851 i0 68.6 0.927272727272727 51 16 92.7 0 153 1 58 108 MBP6103392.1 hypothetical protein [Leptotrichiaceae bacterium] diamond 153 79.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae   Leptotrichiaceae bacterium
32641102 32641102 PRJNA630162_P_NODE_139340_length_167_cov_0.881356_g137817_i0 PRJNA630162 139340 167 0.881356 1.47186452 Fusobacteriaceae bacterium 2053555 Bacteria Bacteria 77.8 1.6e-16   NR MBP6467857.1 2053555 g137817 i0 82.5 0.718562874251497 40 7 71.9 0 7 126 100 139 MBP6467857.1 transcriptional repressor [Fusobacteriaceae bacterium] diamond 120 77.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae   Fusobacteriaceae bacterium
32767199 32767199 PRJNA630162_P_NODE_120080_length_174_cov_2.176000_g118557_i0 PRJNA630162 120080 174 2.176 3.78624 Fusobacterium nucleatum 851 Bacteria Bacteria 72 6.82e-13   NR WP_032840754.1 851 g118557 i0 80 1.51724137931034 45 9 77.6 0 39 173 2 46 WP_032840754.1 HAD-IIIC family phosphatase [Fusobacterium nucleatum] diamond 264 72 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum

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