RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA744060", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 20 ✖

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA744060 · 20 ✖

analysis 1

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
723682 723682 PRJNA744060_P_NODE_6901_length_606_cov_3.150094_g6578_i0 PRJNA744060 6901 606 3.150094 19.08956964 Spirochaetales bacterium 2026792 Bacteria Bacteria 181 2.49e-51   NR MBN1797675.1 2026792 g6578 i0 45.5 0.945544554455445 191 96 94.6 2 604 32 267 449 MBN1797675.1 glycoside hydrolase family 30 protein [Spirochaetales bacterium] diamond 573 181 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
4551571 4551571 PRJNA744060_P_NODE_18384_length_376_cov_3.405941_g18055_i0 PRJNA744060 18384 376 3.405941 12.80633816 Spirochaetia bacterium 2053615 Bacteria Bacteria 125 2.3e-31   NR MDH5720351.1 2053615 g18055 i0 72.4 6.67021276595745 76 21 60.6 0 3 230 326 401 MDH5720351.1 elongation factor Tu [Spirochaetia bacterium] diamond 2508 125 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
21125839 21125839 PRJNA744060_P_NODE_29877_length_299_cov_1.946903_g29548_i0 PRJNA744060 29877 299 1.946903 5.82123997 root 1 Root_unresolved Root_unresolved 65.9 5.54e-10   NR MCL2441774.1 166 g29548 i0 48.3 5.31772575250836 87 44 86.3 1 297 40 918 1004 MCL2441774.1 response regulator [Treponema sp.] diamond 1590 66.2 0.995468277945619 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26777984 26777984 PRJNA744060_P_NODE_18881_length_372_cov_1.180602_g18552_i0 PRJNA744060 18881 372 1.180602 4.39183944 Pseudomonadati 3379134 Bacteria Bacteria 44.7 0.0154   NR HOK92975.1 2202144 g18552 i0 58.8 0.580645161290323 34 14 27.4 0 235 134 30 63 HOK92975.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium] diamond 216 44.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26841406 26841406 PRJNA744060_P_NODE_15061_length_414_cov_1.809384_g14732_i0 PRJNA744060 15061 414 1.809384 7.49084976 Pseudomonadati 3379134 Bacteria Bacteria 66.6 8.93e-10   NR MBO5730434.1 166 g14732 i0 33 4.39130434782609 109 72 79 1 7 333 229 336 MBO5730434.1 hypothetical protein [Treponema sp.] diamond 1818 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26926112 26926112 PRJNA744060_P_NODE_20062_length_361_cov_0.951389_g19733_i0 PRJNA744060 20062 361 0.951389 3.43451429 Spirochaetota bacterium 2202144 Bacteria Bacteria 83.6 5.91e-16   NR MCX7679163.1 2202144 g19733 i0 39.4 2.45983379501385 99 54 81.4 2 14 307 113 206 MCX7679163.1 MFS transporter [Spirochaetota bacterium] diamond 888 83.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27505281 27505281 PRJNA744060_P_NODE_35903_length_276_cov_1.458128_g35574_i0 PRJNA744060 35903 276 1.458128 4.02443328 Bacteria 2 Bacteria Bacteria 72 1.19e-12   NR HMX58034.1 2026757 g35574 i0 44 4.54347826086957 84 42 91.3 2 3 254 77 155 HMX58034.1 FAD-dependent oxidoreductase [Leptospiraceae bacterium] diamond 1254 72 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28884241 28884241 PRJNA744060_P_NODE_20868_length_354_cov_1.893238_g20539_i0 PRJNA744060 20868 354 1.893238 6.70206252 Spirochaetales bacterium 2026792 Bacteria Bacteria 96.7 9.25e-21   NR MBN2534890.1 2026792 g20539 i0 49.5 0.940677966101695 111 48 94.1 2 11 343 299 401 MBN2534890.1 bifunctional ornithine acetyltransferase/N-acetylglutamate synthase [Spirochaetales bacterium] diamond 333 96.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28884289 28884289 PRJNA744060_P_NODE_53508_length_231_cov_2.569620_g53179_i0 PRJNA744060 53508 231 2.56962 5.9358222 Spirochaetia bacterium 2053615 Bacteria Bacteria 70.1 3.17e-12   NR MBP7106702.1 2053615 g53179 i0 55.7 1.80519480519481 70 29 88.3 2 24 227 2 71 MBP7106702.1 VIT1/CCC1 transporter family protein [Spirochaetia bacterium] diamond 417 70.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29178666 29178666 PRJNA744060_P_NODE_50009_length_244_cov_0.888889_g49680_i0 PRJNA744060 50009 244 0.888889 2.16888916 root 1 Root_unresolved Root_unresolved 55.8 8.87e-7   NR MCQ2248321.1 166 g49680 i0 44.6 2.32377049180328 65 35 78.7 1 2 193 278 342 MCQ2248321.1 zinc-ribbon domain-containing protein [Treponema sp.] diamond 567 55.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30147229 30147229 PRJNA744060_P_NODE_49472_length_244_cov_2.304094_g49143_i0 PRJNA744060 49472 244 2.304094 5.62198936 Spirochaetota bacterium 2202144 Bacteria Bacteria 58.2 1.34e-7   NR MCX7788760.1 2202144 g49143 i0 44.4 0.885245901639344 72 37 88.5 1 24 239 54 122 MCX7788760.1 aspartate--tRNA ligase [Spirochaetota bacterium] diamond 216 58.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30495159 30495159 PRJNA744060_P_NODE_32733_length_287_cov_2.261682_g32404_i0 PRJNA744060 32733 287 2.261682 6.49102734 Spirochaetia bacterium 2053615 Bacteria Bacteria 72.4 4.63e-13   NR MBL8993729.1 2053615 g32404 i0 55.2 0.700348432055749 67 30 70 0 201 1 1 67 MBL8993729.1 adenylate/guanylate cyclase domain-containing protein [Spirochaetia bacterium] diamond 201 72.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31168298 31168298 PRJNA744060_P_NODE_28895_length_304_cov_1.324675_g28566_i0 PRJNA744060 28895 304 1.324675 4.027012 Pseudomonadati 3379134 Bacteria Bacteria 74.3 5.69e-13   NR MBE7439278.1 2026792 g28566 i0 38.2 8.05263157894737 102 62 99.7 1 2 304 292 393 MBE7439278.1 adenylate/guanylate cyclase domain-containing protein [Spirochaetales bacterium] diamond 2448 74.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31221540 31221540 PRJNA744060_P_NODE_4935_length_710_cov_5.040816_g4634_i0 PRJNA744060 4935 710 5.040816 35.7897936 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 105 7.35e-23   NR TVR56237.1 1898206 g4634 i0 37.8 3.29154929577465 193 112 81.5 6 708 130 125 309 TVR56237.1 MAG: fasciclin domain-containing protein [Spirochaetaceae bacterium] diamond 2337 105 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31516637 31516637 PRJNA744060_P_NODE_42076_length_257_cov_2.010870_g41747_i0 PRJNA744060 42076 257 2.01087 5.1679359 Leptospira 171 Bacteria Bacteria 63.5 1.47e-10   NR MDZ4726675.1 178 g41747 i0 71.1 2.64980544747082 38 11 44.4 0 2 115 88 125 MDZ4726675.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Leptospira sp.] diamond 681 63.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
31569874 31569874 PRJNA744060_P_NODE_20056_length_361_cov_1.083333_g19727_i0 PRJNA744060 20056 361 1.083333 3.91083213 Spirochaetota bacterium 2202144 Bacteria Bacteria 87.8 2.17e-17   NR MEK6796071.1 2202144 g19727 i0 50.9 0.930747922437673 112 49 93.1 2 358 23 343 448 MEK6796071.1 cellulase family glycosylhydrolase [Spirochaetota bacterium] diamond 336 87.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31727719 31727719 PRJNA744060_P_NODE_39957_length_263_cov_1.642105_g39628_i0 PRJNA744060 39957 263 1.642105 4.31873615 uncultured Sphaerochaeta sp. 886478 Bacteria Bacteria 60.1 3.04e-8   NR WP_320128410.1 886478 g39628 i0 41.3 2.97718631178707 75 42 85.6 1 227 3 185 257 WP_320128410.1 TIGR02452 family protein [uncultured Sphaerochaeta sp.] diamond 783 60.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta uncultured Sphaerochaeta sp.
32075825 32075825 PRJNA744060_P_NODE_38978_length_266_cov_1.616580_g38649_i0 PRJNA744060 38978 266 1.61658 4.3001028 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 55.1 1.52e-6   NR MDF1566751.1 1898206 g38649 i0 56.6 1.40977443609023 53 18 56.4 2 266 117 171 221 MDF1566751.1 metallophosphoesterase [Spirochaetaceae bacterium] diamond 375 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32171000 32171000 PRJNA744060_P_NODE_49678_length_244_cov_1.380117_g49349_i0 PRJNA744060 49678 244 1.380117 3.36748548 Spirochaetota bacterium 2202144 Bacteria Bacteria 88.2 1.83e-18   NR MBN8220082.1 2202144 g49349 i0 57.3 2.01639344262295 82 29 99.6 2 244 2 52 128 MBN8220082.1 hypothetical protein [Spirochaetota bacterium] diamond 492 88.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32833840 32833840 PRJNA744060_P_NODE_20840_length_354_cov_2.533808_g20511_i0 PRJNA744060 20840 354 2.533808 8.96968032 Spirochaetales bacterium 2026792 Bacteria Bacteria 143 1.74e-39   NR HOV94687.1 2026792 g20511 i0 62.4 2.77118644067797 109 41 92.4 0 328 2 23 131 HOV94687.1 HAD-IIA family hydrolase [Spirochaetales bacterium] diamond 981 143 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales 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);;