RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA853194" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA853194 · 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
11044113 11044113 PRJNA853194_S_NODE_4449_length_842_cov_23.807542_g3656_i0 PRJNA853194 4449 842 23.807542 200.45950364 Spirochaetales 136 Bacteria Bacteria 245 4.830000000000001e-77   NR MBO4759740.1 1898206 g3656 i0 56.5 2.95368171021378 214 88 74.5 1 833 207 49 262 MBO4759740.1 glucosamine-6-phosphate deaminase [Spirochaetaceae bacterium] diamond 2487 245 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
12319245 12319245 PRJNA853194_S_NODE_24310_length_415_cov_1.576023_g23219_i0 PRJNA853194 24310 415 1.576023 6.54049545 Treponema bryantii 163 Bacteria Bacteria 54.7 0.011   NTclustered gi|2581915939|dbj|AP025286.1| 163 g23219 i0 100 0.0698795180722892 29 0 7 0 300 328 3004272 3004300 Treponema bryantii JCM 32280 DNA, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
17419177 17419177 PRJNA853194_S_NODE_71714_length_259_cov_1.956989_g70623_i0 PRJNA853194 71714 259 1.956989 5.06860151 Brachyspira intermedia 84377 Bacteria Bacteria 54.7 0.007   NTclustered gi|343385146|gb|CP002874.1| 1045858 g70623 i0 100 0.111969111969112 29 0 11 0 231 259 2040411 2040383 Brachyspira intermedia PWS/A, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
22517926 22517926 PRJNA853194_S_NODE_84398_length_242_cov_1.307692_g83307_i0 PRJNA853194 84398 242 1.307692 3.16461464 Candidatus Borreliella tachyglossi 1964448 Bacteria Bacteria 52.8 0.022   NTclustered gi|1384974943|gb|CP025785.1| 1964448 g83307 i0 100 0.115702479338843 28 0 12 0 144 171 169848 169875 Candidatus Borreliella tachyglossi strain Bc-F10-1268 chromosome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Candidatus Borreliella tachyglossi

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