RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJDB12578" 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

  • PRJDB12578 · 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
27317054 27317054 PRJDB12578_S_NODE_141883_length_212_cov_0.926380_g118825_i0 PRJDB12578 141883 212 0.92638 1.9639256 Cetobacterium sp. 2071632 Bacteria Bacteria 109 1.44e-26   NR WP_291941149.1 2071632 g118825 i0 81.2 0.976415094339623 69 13 97.6 0 207 1 28 96 WP_291941149.1 hypothetical protein [Cetobacterium sp.] diamond 207 109 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp.
27569486 27569486 PRJDB12578_S_NODE_196104_length_168_cov_0.873950_g173046_i0 PRJDB12578 196104 168 0.87395 1.468236 Cetobacterium sp. ZWU 2071632 Bacteria Bacteria 105 6.1200000000000005e-27   NR WP_047384902.1 1340502 g173046 i0 100 0.982142857142857 55 0 98.2 0 167 3 97 151 WP_047384902.1 hypothetical protein [Cetobacterium sp. ZWU0022] diamond 165 105 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZWU0022
29306003 29306003 PRJDB12578_S_NODE_204589_length_165_cov_0.896552_g181531_i0 PRJDB12578 204589 165 0.896552 1.4793108 unclassified Cetobacterium 2630983 Bacteria Bacteria 110 3.84e-29   NR WP_047381955.1 2630983 g181531 i0 96.4 1 55 2 100 0 165 1 103 157 WP_047381955.1 MULTISPECIES: FKBP-type peptidyl-prolyl cis-trans isomerase [unclassified Cetobacterium] diamond 165 110 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
30158524 30158524 PRJDB12578_S_NODE_196552_length_168_cov_0.865546_g173494_i0 PRJDB12578 196552 168 0.865546 1.45411728 Cetobacterium sp. ZOR 2071632 Bacteria Bacteria 116 1.27e-29   NR WP_047394857.1 1339239 g173494 i0 98.2 0.982142857142857 55 1 98.2 0 3 167 234 288 WP_047394857.1 hypothetical protein [Cetobacterium sp. ZOR0034] diamond 165 116 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. ZOR0034
30190261 30190261 PRJDB12578_S_NODE_142452_length_211_cov_1.277778_g119394_i0 PRJDB12578 142452 211 1.277778 2.69611158 Fusobacteriota bacterium 2060921 Bacteria Bacteria 63.5 1.12e-9   NR MCI0502125.1 2060921 g119394 i0 52.6 5.74407582938389 57 27 81 0 41 211 4 60 MCI0502125.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Fusobacteriota bacterium] diamond 1212 63.5 1 Bacteria   Fusobacteriati Fusobacteriota         Fusobacteriota bacterium
32870785 32870785 PRJDB12578_S_NODE_214860_length_162_cov_0.902655_g191802_i0 PRJDB12578 214860 162 0.902655 1.4623011 Cetobacterium 180162 Bacteria Bacteria 115 1.5299999999999999e-31   NR WP_407536152.1 188913 g191802 i0 98.1 2 54 1 100 0 162 1 24 77 WP_407536152.1 hypothetical protein [Cetobacterium somerae] diamond 324 116 0.991379310344828 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);;