RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA966993", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 22 ✖

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJNA966993 · 22 ✖

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
27000361 27000361 PRJNA966993_P_NODE_2062_length_1369_cov_5.514660_g1861_i0 PRJNA966993 2062 1369 5.51466 75.4956954 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.82e-11   NR MDR2632347.1 166 g1861 i0 27.5 2.20014609203798 189 121 38.8 5 40 570 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 77 0.990909090909091 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27310571 27310571 PRJNA966993_P_NODE_43503_length_327_cov_1.744094_g43051_i0 PRJNA966993 43503 327 1.744094 5.70318738 Spirochaetes bacterium ADurb.Bin133 1852909 Bacteria Bacteria 138 1.95e-36   NR OQB69803.1 1852909 g43051 i0 56 2 109 48 100 0 327 1 210 318 OQB69803.1 MAG: Serine--tRNA ligase [Spirochaetes bacterium ADurb.Bin133] diamond 654 138 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium ADurb.Bin133
27916515 27916515 PRJNA966993_P_NODE_81285_length_252_cov_1.720670_g80833_i0 PRJNA966993 81285 252 1.72067 4.3360884 root 1 Root_unresolved Root_unresolved 44.3 0.0124   NR MDR2768187.1 166 g80833 i0 56.1 5.94047619047619 41 17 47.6 1 240 121 863 903 MDR2768187.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 1497 44.7 0.991051454138702 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27973503 27973503 PRJNA966993_P_NODE_65485_length_277_cov_1.132353_g65033_i0 PRJNA966993 65485 277 1.132353 3.13661781 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.4 0.00636   NR MCK4907404.1 2202144 g65033 i0 51.2 0.444043321299639 41 20 44.4 0 34 156 148 188 MCK4907404.1 VWA domain-containing protein [Spirochaetota bacterium] diamond 123 45.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28263787 28263787 PRJNA966993_P_NODE_54266_length_294_cov_1.742081_g53814_i0 PRJNA966993 54266 294 1.742081 5.12171814 Leptospira 171 Bacteria Bacteria 77 5.35e-14   NR WP_025176879.1 173 g53814 i0 48.5 3.95918367346939 97 42 99 2 292 2 243 331 WP_025176879.1 sodium/proton-translocating pyrophosphatase, partial [Leptospira interrogans] diamond 1164 77 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
28415616 28415616 PRJNA966993_P_NODE_101646_length_226_cov_2.013072_g101194_i0 PRJNA966993 101646 226 2.013072 4.54954272 Turneriella parva 29510 Bacteria Bacteria 67.8 4.3e-11   NR WP_041948496.1 29510 g101194 i0 45.8 1.10176991150442 83 34 98.2 2 224 3 175 255 WP_041948496.1 D-arabinono-1,4-lactone oxidase [Turneriella parva] diamond 249 67.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
28605007 28605007 PRJNA966993_P_NODE_86467_length_249_cov_0.875000_g86015_i0 PRJNA966993 86467 249 0.875 2.17875 Brevinematales bacterium 2614249 Bacteria Bacteria 42.4 0.0478   NR MCX7820385.1 2614249 g86015 i0 36.5 0.891566265060241 74 43 84.3 1 9 218 82 155 MCX7820385.1 hypothetical protein [Brevinematales bacterium] diamond 222 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
28706143 28706143 PRJNA966993_P_NODE_28967_length_393_cov_6.571875_g28515_i0 PRJNA966993 28967 393 6.571875 25.82746875 Leptospira 171 Bacteria Bacteria 45.8 0.0153   NR WP_004750092.1 29507 g28515 i0 50 1.64885496183206 54 21 36.6 2 273 130 397 450 WP_004750092.1 AAA family ATPase [Leptospira kirschneri] diamond 648 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kirschneri
28895338 28895338 PRJNA966993_P_NODE_75568_length_261_cov_2.627660_g75116_i0 PRJNA966993 75568 261 2.62766 6.8581926 Treponema 157 Bacteria Bacteria 66.6 1.77e-10   NR NLK60217.1 166 g75116 i0 45.3 2.96551724137931 86 44 98.9 1 2 259 413 495 NLK60217.1 adenylate/guanylate cyclase domain-containing protein [Treponema sp.] diamond 774 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30373822 30373822 PRJNA966993_P_NODE_38712_length_345_cov_2.246324_g38260_i0 PRJNA966993 38712 345 2.246324 7.7498178 Brachyspira aalborgi 29522 Bacteria Bacteria 44.3 0.0176   NR WP_147748559.1 29522 g38260 i0 38.1 0.547826086956522 63 36 54.8 1 50 238 2 61 WP_147748559.1 hypothetical protein [Brachyspira aalborgi] diamond 189 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira aalborgi
30569059 30569059 PRJNA966993_P_NODE_70793_length_269_cov_1.479592_g70341_i0 PRJNA966993 70793 269 1.479592 3.98010248 Pseudomonadati 3379134 Bacteria Bacteria 50.8 7.29e-5   NR HPQ52919.1 2202144 g70341 i0 59.5 1.34944237918216 37 15 41.3 0 177 67 8 44 HPQ52919.1 aminopeptidase N [Spirochaetota bacterium] diamond 363 51.2 0.9921875 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30689236 30689236 PRJNA966993_P_NODE_100313_length_236_cov_2.411043_g99861_i0 PRJNA966993 100313 236 2.411043 5.69006148 Treponema sp. 166 Bacteria Bacteria 44.3 0.00935   NR MDR0668988.1 166 g99861 i0 32.4 0.902542372881356 71 46 87.7 1 17 223 10 80 MDR0668988.1 AmmeMemoRadiSam system radical SAM enzyme [Treponema sp.] diamond 213 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30720893 30720893 PRJNA966993_P_NODE_65694_length_276_cov_2.157635_g65242_i0 PRJNA966993 65694 276 2.157635 5.9550726 Spirochaetota bacterium 2202144 Bacteria Bacteria 49.3 2.18e-4   NR HPS57601.1 2202144 g65242 i0 69 0.673913043478261 29 9 31.5 0 154 68 149 177 HPS57601.1 tetratricopeptide repeat protein [Spirochaetota bacterium] diamond 186 49.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30815763 30815763 PRJNA966993_P_NODE_69494_length_271_cov_1.393939_g69042_i0 PRJNA966993 69494 271 1.393939 3.77757469 Leptospiraceae bacterium 2026757 Bacteria Bacteria 43.5 0.0266   NR MBL8034781.1 2026757 g69042 i0 42.6 0.520295202952029 47 27 52 0 263 123 345 391 MBL8034781.1 hypothetical protein [Leptospiraceae bacterium] diamond 141 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30815767 30815767 PRJNA966993_P_NODE_71714_length_267_cov_2.922680_g71262_i0 PRJNA966993 71714 267 2.92268 7.8035556 Leptospiraceae bacterium 2026757 Bacteria Bacteria 57 4.52e-7   NR MCB1178264.1 2026757 g71262 i0 44.3 0.685393258426966 61 34 68.5 0 1 183 185 245 MCB1178264.1 caspase family protein [Leptospiraceae bacterium] diamond 183 57 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31194498 31194498 PRJNA966993_P_NODE_14395_length_553_cov_1.793750_g13955_i0 PRJNA966993 14395 553 1.79375 9.9194375 Treponema sp. 166 Bacteria Bacteria 58.9 9.8e-7   NR MEE0352004.1 166 g13955 i0 36.8 1.22061482820976 114 66 61.8 3 544 203 131 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 675 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31511424 31511424 PRJNA966993_P_NODE_79916_length_254_cov_1.701657_g79464_i0 PRJNA966993 79916 254 1.701657 4.32220878 Leptospira sp. 178 Bacteria Bacteria 58.9 8.09e-8   NR MCZ8155651.1 178 g79464 i0 44.4 0.74409448818897606 63 35 74.4 0 20 208 19 81 MCZ8155651.1 DUF1566 domain-containing protein [Leptospira sp.] diamond 189 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32245493 32245493 PRJNA966993_P_NODE_59098_length_286_cov_1.446009_g58646_i0 PRJNA966993 59098 286 1.446009 4.13558574 root 1 Root_unresolved Root_unresolved 45.1 0.0067   NR NCN08250.1 178 g58646 i0 31.5 2.27622377622378 73 47 76.6 1 225 7 71 140 NCN08250.1 CBS domain-containing protein [Leptospira sp.] diamond 651 45.4 0.993392070484582 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32397135 32397135 PRJNA966993_P_NODE_37139_length_352_cov_1.655914_g36687_i0 PRJNA966993 37139 352 1.655914 5.82881728 Spirochaetia bacterium 2053615 Bacteria Bacteria 93.6 1.79e-20   NR MFP4385393.1 2053615 g36687 i0 40 0.980113636363636 115 67 98 2 347 3 83 195 MFP4385393.1 hypothetical protein [Spirochaetia bacterium] diamond 345 93.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32618230 32618230 PRJNA966993_P_NODE_48820_length_310_cov_2.582278_g48368_i0 PRJNA966993 48820 310 2.582278 8.0050618 Treponema sp. 166 Bacteria Bacteria 47.4 0.0018600000000000001   NR MCH5291676.1 166 g48368 i0 36.2 0.561290322580645 58 37 56.1 0 310 137 373 430 MCH5291676.1 tetratricopeptide repeat protein [Treponema sp.] diamond 174 47.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32655722 32655722 PRJNA966993_P_NODE_59440_length_285_cov_3.051887_g58988_i0 PRJNA966993 59440 285 3.051887 8.69787795 Pseudomonadati 3379134 Bacteria Bacteria 42.7 0.0316   NR MDR2662759.1 166 g58988 i0 29.6 1.68421052631579 81 53 85.3 1 4 246 46 122 MDR2662759.1 DNA repair protein RecO [Treponema sp.] diamond 480 43.1 0.990719257540603 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32807150 32807150 PRJNA966993_P_NODE_58020_length_287_cov_2.799065_g57568_i0 PRJNA966993 58020 287 2.799065 8.03331655 Borreliella afzelii 29518 Bacteria Bacteria 52 3.57e-6   NR WP_373538324.1 29518 g57568 i0 38 0.742160278745645 71 39 73.2 2 267 58 30 96 WP_373538324.1 ankyrin repeat domain-containing protein [Borreliella afzelii] diamond 213 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella afzelii

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