RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1022139", 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

  • PRJNA1022139 · 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
1436373 1436373 PRJNA1022139_P_NODE_20362_length_310_cov_1.299578_g20257_i0 PRJNA1022139 20362 310 1.299578 4.0286918 Leptospiraceae bacterium 2026757 Bacteria Bacteria 169 2.65e-51   NR HNO24933.1 2026757 g20257 i0 80.6 0.996774193548387 103 20 99.7 0 309 1 27 129 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 309 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
17581399 17581399 PRJNA1022139_P_NODE_38374_length_246_cov_1.780347_g38269_i0 PRJNA1022139 38374 246 1.780347 4.37965362 Treponema sp. 166 Bacteria Bacteria 65.1 5.14e-10   NR MDR2479594.1 166 g38269 i0 45.5 1.59756097560976 66 36 80.5 0 8 205 822 887 MDR2479594.1 response regulator [Treponema sp.] diamond 393 65.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
20562939 20562939 PRJNA1022139_P_NODE_6237_length_523_cov_1.380000_g6133_i0 PRJNA1022139 6237 523 1.38 7.2174 Leptospira 171 Bacteria Bacteria 197 6.549999999999999e-61   NR WP_012388348.1 171 g6133 i0 62.7 2.54684512428298 150 55 86 1 451 2 2 150 WP_012388348.1 MULTISPECIES: peroxiredoxin [Leptospira] diamond 1332 197 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira  
26869100 26869100 PRJNA1022139_P_NODE_25741_length_282_cov_1.421053_g25636_i0 PRJNA1022139 25741 282 1.421053 4.00736946 root 1 Root_unresolved Root_unresolved 146 3.93e-39   NR MCL2007854.1 166 g25636 i0 73.9 11.6170212765957 92 24 97.9 0 280 5 203 294 MCL2007854.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Treponema sp.] diamond 3276 146 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27446078 27446078 PRJNA1022139_P_NODE_43183_length_240_cov_3.718563_g43078_i0 PRJNA1022139 43183 240 3.718563 8.9245512 Leptospira yanagawae 293069 Bacteria Bacteria 42.7 0.034   NR WP_015676732.1 293069 g43078 i0 47.2 0.45 36 19 45 0 109 2 141 176 WP_015676732.1 hypothetical protein [Leptospira yanagawae] diamond 108 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira yanagawae
27690934 27690934 PRJNA1022139_P_NODE_33944_length_252_cov_1.290503_g33839_i0 PRJNA1022139 33944 252 1.290503 3.25206756 Leptospira 171 Bacteria Bacteria 53.1 8.54e-6   NR WP_336655929.1 447106 g33839 i0 31.3 2.41666666666667 80 52 95.2 1 12 251 35 111 WP_336655929.1 alpha/beta fold hydrolase, partial [Leptospira licerasiae] diamond 609 53.5 0.992523364485981 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae
28543258 28543258 PRJNA1022139_P_NODE_12327_length_384_cov_1.228296_g12222_i0 PRJNA1022139 12327 384 1.228296 4.71665664 Pseudomonadati 3379134 Bacteria Bacteria 55.1 8.73e-6   NR MDR2393933.1 166 g12222 i0 34.5 1.4609375 84 45 57.8 1 159 380 480 563 MDR2393933.1 leucine-rich repeat domain-containing protein [Treponema sp.] diamond 561 55.5 0.992792792792793 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28740342 28740342 PRJNA1022139_P_NODE_28927_length_271_cov_1.166667_g28822_i0 PRJNA1022139 28927 271 1.166667 3.16166757 Spirochaetota bacterium 2202144 Bacteria Bacteria 103 6.529999999999999e-24   NR MCX8124638.1 2202144 g28822 i0 56.3 0.96309963099631 87 38 96.3 0 6 266 43 129 MCX8124638.1 glycosyltransferase family 2 protein [Spirochaetota bacterium] diamond 261 103 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29087801 29087801 PRJNA1022139_P_NODE_35828_length_249_cov_1.801136_g35723_i0 PRJNA1022139 35828 249 1.801136 4.48482864 Treponema sp. 166 Bacteria Bacteria 48.9 2.71e-4   NR MDR0300936.1 166 g35723 i0 51.1 1.08433734939759 45 22 54.2 0 9 143 874 918 MDR0300936.1 leucine-rich repeat protein [Treponema sp.] diamond 270 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29151150 29151150 PRJNA1022139_P_NODE_30569_length_265_cov_1.083333_g30464_i0 PRJNA1022139 30569 265 1.083333 2.87083245 Treponema denticola 158 Bacteria Bacteria 48.5 4.67e-4   NR WP_010699523.1 158 g30464 i0 47.1 1.13207547169811 51 27 57.7 0 265 113 666 716 WP_010699523.1 leucine-rich repeat domain-containing protein [Treponema denticola] diamond 300 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
29214188 29214188 PRJNA1022139_P_NODE_42749_length_241_cov_0.916667_g42644_i0 PRJNA1022139 42749 241 0.916667 2.20916747 Treponema sp. 166 Bacteria Bacteria 50.8 5.06e-5   NR MBQ3837555.1 166 g42644 i0 51.1 1.21991701244813 47 23 58.5 0 20 160 311 357 MBQ3837555.1 leucine-rich repeat protein [Treponema sp.] diamond 294 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29308552 29308552 PRJNA1022139_P_NODE_27409_length_276_cov_1.517241_g27304_i0 PRJNA1022139 27409 276 1.517241 4.18758516 Spirochaetia bacterium 2053615 Bacteria Bacteria 73.9 3.95e-13   NR HUX13639.1 2053615 g27304 i0 45.2 3.81521739130435 62 33 67.4 1 193 8 8 68 HUX13639.1 GHMP kinase [Spirochaetia bacterium] diamond 1053 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29340295 29340295 PRJNA1022139_P_NODE_11949_length_389_cov_0.974684_g11844_i0 PRJNA1022139 11949 389 0.974684 3.79152076 Termitinemataceae bacterium 3022875 Bacteria Bacteria 45.8 0.0148   NR GMO23020.1 3022875 g11844 i0 45.1 0.393316195372751 51 28 39.3 0 155 3 484 534 GMO23020.1 MAG: hypothetical protein Ta2B_02110 [Termitinemataceae bacterium] diamond 153 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Termitinemataceae   Termitinemataceae bacterium
29782244 29782244 PRJNA1022139_P_NODE_28091_length_273_cov_5.320000_g27986_i0 PRJNA1022139 28091 273 5.32 14.5236 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 100 5.95e-24   NR TVR53158.1 1898206 g27986 i0 58.7 1.01098901098901 92 23 97.8 2 272 6 69 148 TVR53158.1 MAG: aldo/keto reductase [Spirochaetaceae bacterium] diamond 276 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31354363 31354363 PRJNA1022139_P_NODE_29856_length_267_cov_1.984536_g29751_i0 PRJNA1022139 29856 267 1.984536 5.29871112 Treponema 157 Bacteria Bacteria 48.5 4.67e-4   NR WP_010699523.1 158 g29751 i0 46.8 3.76404494382022 47 25 52.8 0 256 116 679 725 WP_010699523.1 leucine-rich repeat domain-containing protein [Treponema denticola] diamond 1005 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
31520397 31520397 PRJNA1022139_P_NODE_22536_length_295_cov_2.725225_g22431_i0 PRJNA1022139 22536 295 2.725225 8.03941375 Leptospiraceae bacterium 2026757 Bacteria Bacteria 49.3 2.86e-4   NR MCB1143782.1 2026757 g22431 i0 40.4 1.92203389830508 94 49 92.5 4 14 286 163 252 MCB1143782.1 hypothetical protein [Leptospiraceae bacterium] diamond 567 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31796921 31796921 PRJNA1022139_P_NODE_39777_length_245_cov_0.895349_g39672_i0 PRJNA1022139 39777 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 63.9 1.33e-9   NR MCL2129441.1 166 g39672 i0 46.1 5.21632653061225 76 38 93.1 2 233 6 1276 1348 MCL2129441.1 ATP-binding protein [Treponema sp.] diamond 1278 63.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31828535 31828535 PRJNA1022139_P_NODE_33597_length_253_cov_1.588889_g33492_i0 PRJNA1022139 33597 253 1.588889 4.01988917 Pseudomonadati 3379134 Bacteria Bacteria 44.3 0.0121   NR MCX8012882.1 1937017 g33492 i0 29.6 4.55335968379447 81 52 93.7 2 243 7 459 536 MCX8012882.1 tetratricopeptide repeat protein [Rectinema sp.] diamond 1152 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae Rectinema Rectinema sp.
32248233 32248233 PRJNA1022139_P_NODE_31778_length_260_cov_1.417112_g31673_i0 PRJNA1022139 31778 260 1.417112 3.6844912 Spirochaetia bacterium 2053615 Bacteria Bacteria 42.7 0.0422   NR HUW64027.1 2053615 g31673 i0 37.5 0.646153846153846 56 35 64.6 0 85 252 145 200 HUW64027.1 3-hydroxyacyl-CoA dehydrogenase family protein [Spirochaetia bacterium] diamond 168 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32469587 32469587 PRJNA1022139_P_NODE_21399_length_303_cov_1.339130_g21294_i0 PRJNA1022139 21399 303 1.33913 4.0575639 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 49.7 2.69e-4   NR MDC7248568.1 2791017 g21294 i0 56.8 0.435643564356436 44 19 43.6 0 1 132 390 433 MDC7248568.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 132 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae 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);;