RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA690592 · 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
14700210 14700210 PRJNA690592_S_NODE_184392_length_252_cov_1.251397_g183378_i0 PRJNA690592 184392 252 1.251397 3.15352044 unclassified Cetobacterium 2630983 Bacteria Bacteria 96.3 1.35e-23   NR WP_047381601.1 2630983 g183378 i0 85.9 0.761904761904762 64 9 76.2 0 249 58 1 64 WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] diamond 192 96.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
26892823 26892823 PRJNA690592_S_NODE_174461_length_258_cov_3.410811_g173447_i0 PRJNA690592 174461 258 3.410811 8.79989238 Haliovirga abyssi 2996794 Bacteria Bacteria 47.8 7.08e-4   NR WP_307904513.1 2996794 g173447 i0 25.9 0.988372093023256 85 60 98.8 1 3 257 75 156 WP_307904513.1 WD40 repeat domain-containing protein [Haliovirga abyssi] diamond 255 47.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Haliovirgaceae Haliovirga Haliovirga abyssi
27082493 27082493 PRJNA690592_S_NODE_208042_length_243_cov_1.823529_g207028_i0 PRJNA690592 208042 243 1.823529 4.43117547 Fusobacteriota bacterium 2060921 Bacteria Bacteria 49.7 1.35e-4   NR HCB64194.1 2060921 g207028 i0 60 1.1358024691358 45 17 54.3 1 1 132 400 444 HCB64194.1 hypothetical protein [Fusobacteriota bacterium] diamond 276 49.7 1 Bacteria   Fusobacteriati Fusobacteriota         Fusobacteriota bacterium
28882466 28882466 PRJNA690592_S_NODE_36368_length_505_cov_17.368056_g35358_i0 PRJNA690592 36368 505 17.368056 87.7086828 Cetobacterium sp. NK 2071632 Bacteria Bacteria 46.2 0.029   NR WP_256690544.1 2993530 g35358 i0 32.2 0.534653465346535 90 52 52.9 4 410 144 824 905 WP_256690544.1 autotransporter domain-containing protein [Cetobacterium sp. NK01] diamond 270 46.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp. NK01
29356293 29356293 PRJNA690592_S_NODE_9789_length_917_cov_10.800948_g9052_i0 PRJNA690592 9789 917 10.800948 99.04469316 Fusobacterium sp. 68766 Bacteria Bacteria 57.4 3.41e-6   NR WP_177162534.1 68766 g9052 i0 41.3 0.206106870229008 63 37 20.6 0 235 423 22 84 WP_177162534.1 ankyrin repeat domain-containing protein [Fusobacterium sp.] diamond 189 57.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
32874889 32874889 PRJNA690592_S_NODE_27660_length_573_cov_1.700000_g26664_i0 PRJNA690592 27660 573 1.7 9.741 Bacteria 2 Bacteria Bacteria 100 7.91e-22   NR WP_032840617.1 851 g26664 i0 37.6 2.02094240837696 133 83 69.6 0 568 170 108 240 WP_032840617.1 ABC transporter ATP-binding protein [Fusobacterium nucleatum] diamond 1158 100 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);;