RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA758088" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA758088 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
8391715 8391715 PRJNA758088_P_NODE_50127_length_629_cov_1.483813_g43412_i0 PRJNA758088 50127 629 1.483813 9.33318377 Spirochaetia bacterium 2053615 Bacteria Bacteria 154 7.77e-45   NR MFO7729640.1 2053615 g43412 i0 93.9 0.391096979332273 82 3 39.1 1 1 246 22 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 246 154 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
21141415 21141415 PRJNA758088_P_NODE_70117_length_512_cov_1.612756_g63164_i0 PRJNA758088 70117 512 1.612756 8.25731072 Spirochaetia bacterium 2053615 Bacteria Bacteria 154 1.97e-45   NR MFO7729640.1 2053615 g63164 i0 93.9 0.48046875 82 3 48 1 1 246 22 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 246 154 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26736041 26736041 PRJNA758088_P_NODE_109621_length_400_cov_1.654434_g102651_i0 PRJNA758088 109621 400 1.654434 6.617736 Treponema sp. 166 Bacteria Bacteria 67.4 2.25e-10   NR MDR1307607.1 166 g102651 i0 34.6 5.2125 107 66 80.3 2 325 5 138 240 MDR1307607.1 CAP domain-containing protein [Treponema sp.] diamond 2085 67.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26831496 26831496 PRJNA758088_P_NODE_168081_length_327_cov_0.870079_g161110_i0 PRJNA758088 168081 327 0.870079 2.84515833 Alkalispirochaeta sp. 2024959 Bacteria Bacteria 44.7 0.0154   NR MFO8042912.1 2024959 g161110 i0 41.2 0.623853211009174 68 32 59.6 3 221 27 7 69 MFO8042912.1 isoprenylcysteine carboxylmethyltransferase family protein [Alkalispirochaeta sp.] diamond 204 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
28000769 28000769 PRJNA758088_P_NODE_281885_length_251_cov_0.865169_g274914_i0 PRJNA758088 281885 251 0.865169 2.17157419 Treponema sp. 166 Bacteria Bacteria 119 4.79e-31   NR MBQ5876354.1 166 g274914 i0 68.3 0.9800796812749 82 26 98 0 249 4 103 184 MBQ5876354.1 ATP-binding protein [Treponema sp.] diamond 246 119 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28442716 28442716 PRJNA758088_P_NODE_24066_length_1006_cov_0.884244_g19106_i0 PRJNA758088 24066 1006 0.884244 8.89549464 Spirochaetia bacterium 2053615 Bacteria Bacteria 120 4.15e-30   NR MFO7729640.1 2053615 g19106 i0 62.6 0.271371769383698 91 33 26.8 1 171 440 11 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 273 120 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29052429 29052429 PRJNA758088_P_NODE_291128_length_250_cov_0.870056_g284157_i0 PRJNA758088 291128 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 73.9 4.18e-13   NR MFP4152743.1 2024959 g284157 i0 43.4 6.948 83 47 99.6 0 2 250 410 492 MFP4152743.1 AMP-dependent synthetase/ligase [Alkalispirochaeta sp.] diamond 1737 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
29926756 29926756 PRJNA758088_P_NODE_281511_length_251_cov_0.865169_g274540_i0 PRJNA758088 281511 251 0.865169 2.17157419 Treponema sp. 166 Bacteria Bacteria 59.3 5.94e-8   NR MBD5446779.1 166 g274540 i0 57.1 1.00398406374502 42 18 50.2 0 247 122 637 678 MBD5446779.1 hypothetical protein [Treponema sp.] diamond 252 59.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30021527 30021527 PRJNA758088_P_NODE_167491_length_327_cov_1.212598_g160520_i0 PRJNA758088 167491 327 1.212598 3.96519546 Treponema sp. 166 Bacteria Bacteria 86.7 1.91e-17   NR MCR5061661.1 166 g160520 i0 43.1 1 109 60 99.1 2 1 324 208 315 MCR5061661.1 Ig-like domain-containing protein [Treponema sp.] diamond 327 86.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30052850 30052850 PRJNA758088_P_NODE_204751_length_297_cov_1.946429_g197780_i0 PRJNA758088 204751 297 1.946429 5.78089413 Treponema sp. 166 Bacteria Bacteria 79.7 4.69e-16   NR MBR5095864.1 166 g197780 i0 37.8 0.909090909090909 90 56 90.9 0 271 2 80 169 MBR5095864.1 hypothetical protein [Treponema sp.] diamond 270 79.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30147525 30147525 PRJNA758088_P_NODE_37292_length_762_cov_1.033382_g31078_i0 PRJNA758088 37292 762 1.033382 7.87437084 Spirochaetia bacterium 2053615 Bacteria Bacteria 180 3.47e-50   NR NBU97020.1 2053615 g31078 i0 49 0.779527559055118 198 98 77.6 2 597 7 228 423 NBU97020.1 hypothetical protein [Spirochaetia bacterium] diamond 594 180 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30843000 30843000 PRJNA758088_P_NODE_71734_length_505_cov_1.611111_g64775_i0 PRJNA758088 71734 505 1.611111 8.13611055 Spirochaetia bacterium 2053615 Bacteria Bacteria 49.7 0.00168   NR NBU97020.1 2053615 g64775 i0 56.1 0.243564356435644 41 15 23.2 2 433 317 386 425 NBU97020.1 hypothetical protein [Spirochaetia bacterium] diamond 123 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;