RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA758398", 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 · 19 ✖

tax_kingdom 1

  • Pseudomonadati · 19 ✖

bioproject 1

  • PRJNA758398 · 19 ✖

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
739461 739461 PRJNA758398_S_NODE_12321_length_279_cov_0.886957_g12180_i0 PRJNA758398 12321 279 0.886957 2.47461003 Spirochaetota bacterium 2202144 Bacteria Bacteria 52.8 0.026   NTclustered gi|2649718686|emb|OZ001216.1| 2202144 g12180 i0 100 0.100358422939068 28 0 10 0 2 29 76012 75985 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 9 blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
19866873 19866873 PRJNA758398_S_NODE_51456_length_162_cov_0.964602_g51315_i0 PRJNA758398 51456 162 0.964602 1.56265524 Leptospira santarosai 28183 Bacteria Bacteria 137 3.6199999999999997e-28   NTclustered gi|1370526542|gb|CP027843.1| 28183 g51315 i0 87.931 3.67901234567901 116 14 72 0 1 116 1177449 1177334 Leptospira santarosai strain U160 chromosome I blastn 596 137 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira santarosai
22417319 22417319 PRJNA758398_S_NODE_52658_length_162_cov_0.902655_g52517_i0 PRJNA758398 52658 162 0.902655 1.4623011 Borrelia sp. A-FGy1 2608247 Bacteria Bacteria 54.7 0.004   NTclustered gi|1886106780|gb|CP043682.1| 2608247 g52517 i0 100 0.351851851851852 29 0 18 0 117 145 497254 497226 Borrelia sp. A-FGy1 chromosome blastn 57 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia sp. A-FGy1
27021470 27021470 PRJNA758398_S_NODE_6442_length_375_cov_2.650307_g6301_i0 PRJNA758398 6442 375 2.650307 9.93865125 Leptospiraceae bacterium 2026757 Bacteria Bacteria 45.8 0.0119   NR MBL8034127.1 2026757 g6301 i0 58.3 0.624 36 12 26.4 1 165 67 84 119 MBL8034127.1 MBL fold metallo-hydrolase [Leptospiraceae bacterium] diamond 234 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27789451 27789451 PRJNA758398_S_NODE_21584_length_220_cov_2.058480_g21443_i0 PRJNA758398 21584 220 2.05848 4.528656 Pseudomonadati 3379134 Bacteria Bacteria 78.6 6.65e-15   NR MBN1798525.1 2026792 g21443 i0 62.3 9.99545454545455 69 24 94.1 1 2 208 531 597 MBN1798525.1 transketolase [Spirochaetales bacterium] diamond 2199 79 0.994936708860759 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28347908 28347908 PRJNA758398_S_NODE_31866_length_189_cov_1.292857_g31725_i0 PRJNA758398 31866 189 1.292857 2.44349973 Spirochaetia bacterium 2053615 Bacteria Bacteria 52.8 3.1e-6   NR HOV62672.1 2053615 g31725 i0 48.7 0.619047619047619 39 20 61.9 0 73 189 80 118 HOV62672.1 uridine kinase [Spirochaetia bacterium] diamond 117 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28726858 28726858 PRJNA758398_S_NODE_6127_length_385_cov_2.324405_g5986_i0 PRJNA758398 6127 385 2.324405 8.94895925 Leptospiraceae bacterium 2026757 Bacteria Bacteria 62.4 3.51e-10   NR MCB1177358.1 2026757 g5986 i0 46.7 0.467532467532468 60 31 46 1 186 10 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 62.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29421252 29421252 PRJNA758398_S_NODE_38329_length_174_cov_1.632000_g38188_i0 PRJNA758398 38329 174 1.632 2.83968 Leptospiraceae bacterium 2026757 Bacteria Bacteria 81.3 6.17e-17   NR MDX1960600.1 2026757 g38188 i0 60.3 1 58 23 100 0 174 1 102 159 MDX1960600.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 174 81.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29610576 29610576 PRJNA758398_S_NODE_32530_length_187_cov_1.847826_g32389_i0 PRJNA758398 32530 187 1.847826 3.45543462 Entomospira nematocerorum 2719987 Bacteria Bacteria 68.6 1.06e-12   NR WP_167703056.1 2719987 g32389 i0 54.7 1.02673796791444 64 27 99.5 1 1 186 18 81 WP_167703056.1 GNAT family N-acetyltransferase [Entomospira nematocerorum] diamond 192 68.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Entomospira Entomospira nematocerorum
29746654 29746654 PRJNA758398_S_NODE_28210_length_199_cov_1.020000_g28069_i0 PRJNA758398 28210 199 1.02 2.0298 root 1 Root_unresolved Root_unresolved 65.5 1.78e-10   NR MEW5816449.1 2202144 g28069 i0 62.7 3.19597989949749 51 19 76.9 0 153 1 170 220 MEW5816449.1 CCA tRNA nucleotidyltransferase [Spirochaetota bacterium] diamond 636 65.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29989900 29989900 PRJNA758398_S_NODE_24711_length_209_cov_1.912500_g24570_i0 PRJNA758398 24711 209 1.9125 3.997125 Leptospiraceae bacterium 2026757 Bacteria Bacteria 118 3.22e-32   NR MCB1323381.1 2026757 g24570 i0 74.6 4.85167464114833 67 17 96.2 0 209 9 28 94 MCB1323381.1 VOC family protein [Leptospiraceae bacterium] diamond 1014 118 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30157337 30157337 PRJNA758398_S_NODE_39852_length_171_cov_1.360656_g39711_i0 PRJNA758398 39852 171 1.360656 2.32672176 Pseudomonadati 3379134 Bacteria Bacteria 87 1.59e-18   NR MBQ9630728.1 166 g39711 i0 70.4 3.87719298245614 54 16 94.7 0 164 3 76 129 MBQ9630728.1 type I glyceraldehyde-3-phosphate dehydrogenase [Treponema sp.] diamond 663 87 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30337849 30337849 PRJNA758398_S_NODE_12532_length_277_cov_1.065789_g12391_i0 PRJNA758398 12532 277 1.065789 2.95223553 Leptospira sp. 178 Bacteria Bacteria 90.1 1.69e-20   NR MCU0824711.1 178 g12391 i0 73.2 0.606498194945848 56 15 60.6 0 275 108 97 152 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 168 90.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
31190070 31190070 PRJNA758398_S_NODE_10055_length_305_cov_2.054688_g9914_i0 PRJNA758398 10055 305 2.054688 6.2667984 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 43.5 0.0377   NR MBK5201917.1 1898206 g9914 i0 48.1 0.511475409836066 52 22 51.1 1 305 150 149 195 MBK5201917.1 L-lactate dehydrogenase [Spirochaetaceae bacterium] diamond 156 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31601837 31601837 PRJNA758398_S_NODE_50916_length_163_cov_0.868421_g50775_i0 PRJNA758398 50916 163 0.868421 1.41552623 Spirochaetales bacterium 2026792 Bacteria Bacteria 45.1 0.00134   NR MBN1525358.1 2026792 g50775 i0 64.5 0.570552147239264 31 11 57.1 0 95 3 155 185 MBN1525358.1 peptidylprolyl isomerase [Spirochaetales bacterium] diamond 93 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31633221 31633221 PRJNA758398_S_NODE_32396_length_188_cov_1.100719_g32255_i0 PRJNA758398 32396 188 1.100719 2.06935172 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 43.5 0.00979   NR MDD9988086.1 1898206 g32255 i0 46 0.797872340425532 50 21 79.8 1 183 34 478 521 MDD9988086.1 ankyrin repeat domain-containing protein [Spirochaetaceae bacterium] diamond 150 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32044533 32044533 PRJNA758398_S_NODE_16178_length_247_cov_3.090909_g16037_i0 PRJNA758398 16178 247 3.090909 7.63454523 Spirochaetia bacterium 2053615 Bacteria Bacteria 42.7 0.041   NR MCI6592848.1 2053615 g16037 i0 39.7 0.947368421052632 78 44 91.1 1 231 7 301 378 MCI6592848.1 DUF6531 domain-containing protein [Spirochaetia bacterium] diamond 234 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32054218 32054218 PRJNA758398_S_NODE_26418_length_204_cov_1.264516_g26277_i0 PRJNA758398 26418 204 1.264516 2.57961264 Pseudomonadati 3379134 Bacteria Bacteria 48.1 2.74e-4   NR MBE7440661.1 2026792 g26277 i0 37.9 4.33823529411765 58 36 85.3 0 31 204 56 113 MBE7440661.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetales bacterium] diamond 885 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32361194 32361194 PRJNA758398_S_NODE_27759_length_200_cov_1.350993_g27618_i0 PRJNA758398 27759 200 1.350993 2.701986 Leptospira sp. 178 Bacteria Bacteria 105 7.88e-27   NR MCU0824711.1 178 g27618 i0 78.5 0.975 65 14 97.5 0 5 199 73 137 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 195 105 1 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);;