RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA576995" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA576995 · 7 ✖

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
1136972 1136972 PRJNA576995_P_NODE_26261_length_298_cov_1.342222_g25669_i0 PRJNA576995 26261 298 1.342222 3.99982156 Bacteria 2 Bacteria Bacteria 124 7.65e-31   NR PKL17136.1 2013837 g25669 i0 64 11.3758389261745 89 32 89.6 0 31 297 1 89 PKL17136.1 MAG: IMP dehydrogenase [Spirochaetae bacterium HGW-Spirochaetae-5] diamond 3390 125 0.992 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-5
19687347 19687347 PRJNA576995_P_NODE_41596_length_243_cov_0.905882_g41004_i0 PRJNA576995 41596 243 0.905882 2.20129326 Treponema sp. OMZ 305 1659192 Bacteria Bacteria 250 7.2399999999999995e-62   NTclustered gi|2265133351|gb|CP051300.1| 1659192 g41004 i0 85.417 0.987654320987654 240 35 99 0 4 243 790569 790808 Treponema sp. OMZ 305 chromosome, complete genome blastn 240 250 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 305
27205750 27205750 PRJNA576995_P_NODE_28842_length_284_cov_1.459716_g28250_i0 PRJNA576995 28842 284 1.459716 4.14559344 Spirochaetae bacterium HGW-Spirochaetae-8 2013840 Bacteria Bacteria 47.4 0.00132   NR PKL14600.1 2013840 g28250 i0 54.5 3.46478873239437 44 20 46.5 0 139 8 85 128 PKL14600.1 MAG: TIGR02452 family protein [Spirochaetae bacterium HGW-Spirochaetae-8] diamond 984 47.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-8
29069242 29069242 PRJNA576995_P_NODE_24568_length_308_cov_1.310638_g23976_i0 PRJNA576995 24568 308 1.310638 4.03676504 Leptospiraceae bacterium 2026757 Bacteria Bacteria 43.5 0.0427   NR MBL8035044.1 2026757 g23976 i0 42.1 0.555194805194805 57 31 55.5 1 1 171 607 661 MBL8035044.1 hypothetical protein [Leptospiraceae bacterium] diamond 171 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30092923 30092923 PRJNA576995_P_NODE_30132_length_277_cov_1.509804_g29540_i0 PRJNA576995 30132 277 1.509804 4.18215708 Bacteria 2 Bacteria Bacteria 150 1.79e-42   NR CCY23707.1 1262759 g29540 i0 73.9 17.913357400722 92 24 99.6 0 2 277 136 227 CCY23707.1 nAD-dependent epimerase/dehydratase [Brachyspira sp. CAG:484] diamond 4962 150 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira sp. CAG:484
32021397 32021397 PRJNA576995_P_NODE_34738_length_251_cov_0.865169_g34146_i0 PRJNA576995 34738 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 59.3 7.51e-9   NR MCK9171751.1 166 g34146 i0 40.6 1.55378486055777 69 37 82.5 1 43 249 50 114 MCK9171751.1 MBL fold metallo-hydrolase [Treponema sp.] diamond 390 59.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32166233 32166233 PRJNA576995_P_NODE_42958_length_241_cov_0.916667_g42366_i0 PRJNA576995 42958 241 0.916667 2.20916747 Treponema sp. 166 Bacteria Bacteria 50.4 6.77e-5   NR HCC36792.1 166 g42366 i0 35.6 0.908713692946058 73 45 90.9 1 221 3 178 248 HCC36792.1 hypothetical protein [Treponema sp.] diamond 219 50.4 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);;