RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA408129", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA408129 · 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
2358196 2358196 PRJNA408129_S_NODE_35802_length_150_cov_2.858407_g35784_i0 PRJNA408129 35802 150 2.858407 4.2876105 Borreliella 64895 Bacteria Bacteria 54.7 0.003   NTclustered gi|1112967167|gb|CP018265.1| 29518 g35784 i0 100 1.35333333333333 29 0 19 0 107 135 16748 16720 Borreliella afzelii strain BO23 plasmid lp28-3, partial sequence blastn 203 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella afzelii
10010791 10010791 PRJNA408129_S_NODE_16148_length_191_cov_2.422078_g16130_i0 PRJNA408129 16148 191 2.422078 4.62616898 Leptospira 171 Bacteria Bacteria 63.9 7.59e-6   NTclustered gi|1634136587|gb|CP039283.1| 173 g16130 i0 97.297 22.1099476439791 37 1 19 0 51 87 3608453 3608417 Leptospira interrogans strain FMAS_AW1 chromosome I, complete sequence blastn 4223 63.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
29145146 29145146 PRJNA408129_S_NODE_16369_length_190_cov_3.006536_g16351_i0 PRJNA408129 16369 190 3.006536 5.7124184 Spirochaetales 136 Bacteria Bacteria 119 1.81e-29   NR WP_132780366.1 2094121 g16351 i0 96.7 2.84210526315789 60 2 94.7 0 180 1 48 107 WP_132780366.1 4Fe-4S binding protein [Treponema sp. J25] diamond 540 120 0.991666666666667 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. J25
29886154 29886154 PRJNA408129_S_NODE_4251_length_279_cov_4.830579_g4233_i0 PRJNA408129 4251 279 4.830579 13.47731541 Sphaerochaeta associata 1129264 Bacteria Bacteria 43.1 0.0353   NR WP_323385125.1 1129264 g4233 i0 28.8 0.709677419354839 66 45 68.8 1 279 88 76 141 WP_323385125.1 GntR family transcriptional regulator [Sphaerochaeta associata] diamond 198 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta associata
30882009 30882009 PRJNA408129_S_NODE_14474_length_198_cov_1.409938_g14456_i0 PRJNA408129 14474 198 1.409938 2.79167724 Treponema 157 Bacteria Bacteria 102 6.93e-24   NR WP_303932638.1 158 g14456 i0 79 4.6969696969697 62 13 93.9 0 192 7 297 358 WP_303932638.1 UDP-N-acetylmuramyl-tripeptide synthetase, partial [Treponema denticola] diamond 930 103 0.990291262135922 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
32747284 32747284 PRJNA408129_S_NODE_16840_length_188_cov_5.291391_g16822_i0 PRJNA408129 16840 188 5.291391 9.94781508 Pseudomonadati 3379134 Bacteria Bacteria 101 1.04e-24   NR MCE9500260.1 178 g16822 i0 84.5 1.85106382978723 58 9 92.6 0 175 2 61 118 MCE9500260.1 alpha/beta fold hydrolase [Leptospira sp.] diamond 348 102 0.990196078431373 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira 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);;