RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA643700", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 8 ✖

tax_phylum 1

  • Spirochaetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA643700 · 8 ✖

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
1894239 1894239 PRJNA643700_P_NODE_104982_length_406_cov_3.859944_g103428_i0 PRJNA643700 104982 406 3.859944 15.67137264 Spirochaetia bacterium 2053615 Bacteria Bacteria 52.8 0.039   NTclustered gi|2621717749|emb|OY776146.1| 2053615 g103428 i0 100 0.137931034482759 28 0 7 0 49 76 2826286 2826259 MAG: Spirochaetia bacterium isolate efeffb62-48c8-43b6-be4a-4368b18f5a81 genome assembly, chromosome: 1 blastn 56 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
3168925 3168925 PRJNA643700_P_NODE_234803_length_250_cov_1.810945_g233247_i0 PRJNA643700 234803 250 1.810945 4.5273625 Brachyspira hampsonii 1287055 Bacteria Bacteria 56.5 0.002   NTclustered gi|1214564172|gb|CP019914.1| 1287055 g233247 i0 100 0.12 30 0 12 0 171 200 402436 402407 Brachyspira hampsonii strain NSH-16 chromosome, complete genome blastn 30 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hampsonii
4445903 4445903 PRJNA643700_P_NODE_374544_length_174_cov_1.488000_g372988_i0 PRJNA643700 374544 174 1.488 2.58912 Spirochaetota bacterium 2202144 Bacteria Bacteria 54.7 0.004   NTclustered gi|2649718685|emb|OZ001215.1| 2202144 g372988 i0 96.97 0.189655172413793 33 0 19 1 53 85 126406 126437 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 8 blastn 33 54.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
13372137 13372137 PRJNA643700_P_NODE_247211_length_241_cov_2.437500_g245655_i0 PRJNA643700 247211 241 2.4375 5.874375 Leptospira mgodei 3235172 Bacteria Bacteria 52.8 0.022   NTclustered gi|2777195838|gb|CP162139.1| 3235172 g245655 i0 100 0.116182572614108 28 0 12 0 137 164 2734326 2734353 Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira mgodei
13912565 13912565 PRJNA643700_P_NODE_129031_length_363_cov_1.592357_g127476_i0 PRJNA643700 129031 363 1.592357 5.78025591 Brachyspira 29521 Bacteria Bacteria 52.8 0.034   NTclustered gi|2021755399|gb|CP046930.1| 159 g127476 i0 100 0.617079889807163 28 0 8 0 328 355 1770253 1770280 Brachyspira hyodysenteriae strain BHZ375 chromosome, complete genome blastn 224 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
14647007 14647007 PRJNA643700_P_NODE_221312_length_260_cov_2.540284_g219756_i0 PRJNA643700 221312 260 2.540284 6.6047384 Leptospira noguchii 28182 Bacteria Bacteria 52.8 0.024   NTclustered gi|2218375133|gb|CP091928.1| 28182 g219756 i0 100 0.323076923076923 28 0 11 0 30 57 2141653 2141626 Leptospira noguchii strain IP1712055 chromosome 1, complete sequence blastn 84 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira noguchii
28502468 28502468 PRJNA643700_P_NODE_296627_length_211_cov_3.154321_g295071_i0 PRJNA643700 296627 211 3.154321 6.65561731 Spirochaetae bacterium HGW-Spirochaetae-1 2013832 Bacteria Bacteria 42.4 0.0331   NR PKL36258.1 2013832 g295071 i0 43.9 0.582938388625592 41 22 56.9 1 196 77 36 76 PKL36258.1 MAG: hypothetical protein CVV44_18775 [Spirochaetae bacterium HGW-Spirochaetae-1] diamond 123 42.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-1
31851178 31851178 PRJNA643700_P_NODE_344737_length_188_cov_1.122302_g343181_i0 PRJNA643700 344737 188 1.122302 2.10992776 Leptospirales bacterium 2604146 Bacteria Bacteria 41.6 0.0454   NR MBL8018415.1 2604146 g343181 i0 48.4 0.49468085106383 31 16 49.5 0 56 148 40 70 MBL8018415.1 metallophosphoesterase [Leptospirales bacterium] diamond 93 41.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium

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