RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB75230" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJEB75230 · 18 ✖

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
1412521 1412521 PRJEB75230_P_NODE_8802_length_492_cov_1.467780_g8620_i0 PRJEB75230 8802 492 1.46778 7.2214776 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 87.4 1.35e-16   NR MDA3851947.1 1898206 g8620 i0 39.3 0.823170731707317 135 78 79.9 3 475 83 411 545 MDA3851947.1 hypothetical protein [Spirochaetaceae bacterium] diamond 405 87.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
7373234 7373234 PRJEB75230_P_NODE_104186_length_260_cov_1.647059_g104004_i0 PRJEB75230 104186 260 1.647059 4.2823534 Borrelia 138 Bacteria Bacteria 52.8 0.024   NTclustered gi|2225474869|gb|CP073159.1| 141 g104004 i0 100 0.323076923076923 28 0 11 0 178 205 521860 521833 Borrelia parkeri strain SLO chromosome, complete genome blastn 84 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia parkeri
14164541 14164541 PRJEB75230_P_NODE_133412_length_249_cov_0.875000_g133230_i0 PRJEB75230 133412 249 0.875 2.17875 Borreliella valaisiana 62088 Bacteria Bacteria 54.7 0.006   NTclustered gi|224497476|gb|CP001442.1| 445987 g133230 i0 96.875 0.1285140562249 32 1 13 0 107 138 261 230 Borreliella valaisiana VS116 plasmid VS116_lp28-8, complete sequence blastn 32 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella valaisiana
18847506 18847506 PRJEB75230_P_NODE_129375_length_249_cov_1.312500_g129193_i0 PRJEB75230 129375 249 1.3125 3.268125 Leptospira 171 Bacteria Bacteria 54.7 0.006   NTclustered gi|2612877174|gb|CP136243.1| 173 g129193 i0 94.444 10.0401606425703 36 0 14 1 103 138 3928431 3928464 Leptospira interrogans strain CUDO5 chromosome I, complete sequence blastn 2500 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
23088395 23088395 PRJEB75230_P_NODE_161619_length_244_cov_0.900585_g161437_i0 PRJEB75230 161619 244 0.900585 2.1974274 Treponema sp. OMZ 305 1659192 Bacteria Bacteria 239 1.57e-58   NTclustered gi|2265133351|gb|CP051300.1| 1659192 g161437 i0 85.043 5.75409836065574 234 35 96 0 2 235 241366 241133 Treponema sp. OMZ 305 chromosome, complete genome blastn 1404 239 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 305
27034169 27034169 PRJEB75230_P_NODE_13202_length_430_cov_1.501401_g13020_i0 PRJEB75230 13202 430 1.501401 6.4560243 Leptospira gorisiae 3235175 Bacteria Bacteria 56.2 3.26e-6   NR XDD51168.1 3235175 g13020 i0 41.8 0.551162790697674 79 44 54.4 2 412 179 155 232 XDD51168.1 ankyrin repeat domain-containing protein [Leptospira gorisiae] diamond 237 56.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira gorisiae
28006357 28006357 PRJEB75230_P_NODE_134065_length_249_cov_0.875000_g133883_i0 PRJEB75230 134065 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 119 2.3199999999999997e-30   NR MCF7914868.1 1898206 g133883 i0 96.7 1.44578313253012 60 2 72.3 0 247 68 276 335 MCF7914868.1 tetratricopeptide repeat protein [Spirochaetaceae bacterium] diamond 360 119 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28044880 28044880 PRJEB75230_P_NODE_130005_length_249_cov_0.875000_g129823_i0 PRJEB75230 130005 249 0.875 2.17875 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.5 0.0209   NR HPO49132.1 2202144 g129823 i0 44.1 0.710843373493976 59 28 65.1 2 246 85 37 95 HPO49132.1 alpha/beta hydrolase [Spirochaetota bacterium] diamond 177 43.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28290145 28290145 PRJEB75230_P_NODE_118886_length_251_cov_0.865169_g118704_i0 PRJEB75230 118886 251 0.865169 2.17157419 Spirochaetales 136 Bacteria Bacteria 42.7 0.0386   NR MDR0878287.1 166 g118704 i0 43.8 1.0996015936255 48 24 53.8 2 191 57 47 94 MDR0878287.1 sugar ABC transporter permease [Treponema sp.] diamond 276 43.1 0.990719257540603 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28644973 28644973 PRJEB75230_P_NODE_107867_length_258_cov_1.070270_g107685_i0 PRJEB75230 107867 258 1.07027 2.7612966 Sphaerochaeta halotolerans 2293840 Bacteria Bacteria 42.7 0.0424   NR WP_160528017.1 2293840 g107685 i0 32.9 0.848837209302326 73 38 84.9 2 33 251 144 205 WP_160528017.1 ABC transporter ATP-binding protein [Sphaerochaeta halotolerans] diamond 219 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta halotolerans
28771102 28771102 PRJEB75230_P_NODE_150267_length_246_cov_0.890173_g150085_i0 PRJEB75230 150267 246 0.890173 2.18982558 Leptospira borgpetersenii 174 Bacteria Bacteria 43.9 0.0069   NR WP_228029286.1 174 g150085 i0 57.6 0.402439024390244 33 14 40.2 0 114 16 109 141 WP_228029286.1 hypothetical protein, partial [Leptospira borgpetersenii] diamond 99 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira borgpetersenii
29087029 29087029 PRJEB75230_P_NODE_152488_length_246_cov_0.890173_g152306_i0 PRJEB75230 152488 246 0.890173 2.18982558 Spirochaetales bacterium 2026792 Bacteria Bacteria 42.7 0.0361   NR MBN2534445.1 2026792 g152306 i0 31.5 1.08536585365854 89 47 91.5 2 14 238 2 90 MBN2534445.1 radical SAM protein [Spirochaetales bacterium] diamond 267 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29560352 29560352 PRJEB75230_P_NODE_160670_length_244_cov_0.900585_g160488_i0 PRJEB75230 160670 244 0.900585 2.1974274 Borreliella garinii 29519 Bacteria Bacteria 61.2 2.51e-10   NR WP_369122472.1 29519 g160488 i0 61.2 1.20491803278689 49 19 60.2 0 230 84 21 69 WP_369122472.1 reverse transcriptase domain-containing protein [Borreliella garinii] diamond 294 61.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
29749656 29749656 PRJEB75230_P_NODE_175051_length_242_cov_0.911243_g174869_i0 PRJEB75230 175051 242 0.911243 2.20520806 Leptospiraceae bacterium 2026757 Bacteria Bacteria 72.4 2.47e-13   NR MCX7810126.1 2026757 g174869 i0 100 0.433884297520661 35 0 43.4 0 138 242 1 35 MCX7810126.1 thioredoxin family protein [Leptospiraceae bacterium] diamond 105 72.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31139654 31139654 PRJEB75230_P_NODE_143015_length_247_cov_0.885057_g142833_i0 PRJEB75230 143015 247 0.885057 2.18609079 Leptospiraceae bacterium 2026757 Bacteria Bacteria 50.4 4.34e-5   NR MCB1179945.1 2026757 g142833 i0 45.5 2.27125506072874 44 22 51 1 3 128 155 198 MCB1179945.1 hypothetical protein [Leptospiraceae bacterium] diamond 561 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31804074 31804074 PRJEB75230_P_NODE_61737_length_297_cov_1.839286_g61555_i0 PRJEB75230 61737 297 1.839286 5.46267942 Leptospira bandrabouensis 2484903 Bacteria Bacteria 45.1 0.00694   NR WP_238753647.1 2484903 g61555 i0 42.9 0.565656565656566 56 31 56.6 1 88 255 27 81 WP_238753647.1 TetR/AcrR family transcriptional regulator [Leptospira bandrabouensis] diamond 168 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira bandrabouensis
31835655 31835655 PRJEB75230_P_NODE_37657_length_332_cov_1.486486_g37475_i0 PRJEB75230 37657 332 1.486486 4.93513352 Leptospira interrogans 173 Bacteria Bacteria 47.4 1.81e-4   NR WP_141607967.1 173 g37475 i0 61.1 0.325301204819277 36 14 32.5 0 284 177 29 64 WP_141607967.1 hypothetical protein [Leptospira interrogans] diamond 108 47.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
31899153 31899153 PRJEB75230_P_NODE_53397_length_307_cov_2.790598_g53215_i0 PRJEB75230 53397 307 2.790598 8.56713586 Leptospira ainazelensis 2810034 Bacteria Bacteria 57.4 2.05e-7   NR WP_205275263.1 2810034 g53215 i0 31.6 1.87622149837134 98 63 95.8 1 294 1 68 161 WP_205275263.1 ankyrin repeat domain-containing protein [Leptospira ainazelensis] diamond 576 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ainazelensis

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