RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1069776", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1069776 · 6 ✖

analysis 1

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
30035821 30035821 PRJNA1069776_S_NODE_37111_length_179_cov_2.772059_g36797_i0 PRJNA1069776 37111 179 2.772059 4.96198561 Treponema porcinum 261392 Bacteria Bacteria 94 6.420000000000001e-21   NR MCI7114387.1 261392 g36797 i0 100 2.11173184357542 42 0 70.4 0 54 179 1 42 MCI7114387.1 class I tRNA ligase family protein [Treponema porcinum] diamond 378 94 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
30667653 30667653 PRJNA1069776_S_NODE_17073_length_251_cov_8.346154_g16759_i0 PRJNA1069776 17073 251 8.346154 20.94884654 Treponema sp. 166 Bacteria Bacteria 164 1.07e-44   NR MBQ1175515.1 166 g16759 i0 100 1.93625498007968 81 0 96.8 0 2 244 227 307 MBQ1175515.1 translocation/assembly module TamB domain-containing protein [Treponema sp.] diamond 486 164 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30667659 30667659 PRJNA1069776_S_NODE_8033_length_328_cov_16.768421_g7719_i0 PRJNA1069776 8033 328 16.768421 55.00042088 Spirochaetia bacterium 2053615 Bacteria Bacteria 214 4.1e-64   NR MCI5830413.1 2053615 g7719 i0 100 0.98780487804878 108 0 98.8 0 326 3 364 471 MCI5830413.1 hypothetical protein [Spirochaetia bacterium] diamond 324 214 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30730831 30730831 PRJNA1069776_S_NODE_32434_length_190_cov_4.850340_g32120_i0 PRJNA1069776 32434 190 4.85034 9.215646 Treponema sp. 166 Bacteria Bacteria 71.2 1.64e-12   NR MEE3410728.1 166 g32120 i0 68.5 0.852631578947368 54 17 85.3 0 163 2 89 142 MEE3410728.1 HAD family hydrolase [Treponema sp.] diamond 162 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31457952 31457952 PRJNA1069776_S_NODE_12336_length_285_cov_5.119835_g12022_i0 PRJNA1069776 12336 285 5.119835 14.59152975 Spirochaetales bacterium 2026792 Bacteria Bacteria 182 6.109999999999998e-55   NR MBQ1998513.1 2026792 g12022 i0 87.2 1.97894736842105 94 12 98.9 0 284 3 149 242 MBQ1998513.1 carbon-nitrogen hydrolase family protein [Spirochaetales bacterium] diamond 564 182 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32848453 32848453 PRJNA1069776_S_NODE_53760_length_151_cov_3.555556_g53446_i0 PRJNA1069776 53760 151 3.555556 5.36888956 Treponema sp. 166 Bacteria Bacteria 93.2 5.73e-22   NR MCQ2598573.1 166 g53446 i0 96 0.993377483443709 50 2 99.3 0 151 2 2 51 MCQ2598573.1 DUF3990 domain-containing protein [Treponema sp.] diamond 150 93.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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