RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA1195374", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 25 ✖

tax_kingdom 1

  • Pseudomonadati · 25 ✖

bioproject 1

  • PRJNA1195374 · 25 ✖

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
15624257 15624257 PRJNA1195374_P_NODE_36173_length_374_cov_1.009967_g35829_i0 PRJNA1195374 36173 374 1.009967 3.77727658 Bacteria 2 Bacteria Bacteria 192 2e-60   NR MCC5815248.1 178 g35829 i0 72.3 24.9144385026738 119 32 95.5 1 374 18 37 154 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 9318 192 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
22719448 22719448 PRJNA1195374_P_NODE_26458_length_441_cov_1.168478_g26114_i0 PRJNA1195374 26458 441 1.168478 5.15298798 Leptospirales bacterium 2604146 Bacteria Bacteria 115 1.54e-26   NR MBL8018401.1 2604146 g26114 i0 55.6 0.673469387755102 99 43 67.3 1 436 140 575 672 MBL8018401.1 NADPH-dependent 2,4-dienoyl-CoA reductase [Leptospirales bacterium] diamond 297 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
23273210 23273210 PRJNA1195374_P_NODE_12879_length_625_cov_2.786232_g12543_i0 PRJNA1195374 12879 625 2.786232 17.41395 Bacteria 2 Bacteria Bacteria 213 1.6e-66   NR HNH10519.1 2026757 g12543 i0 57.8 9.9024 187 79 89.8 0 561 1 3 189 HNH10519.1 NAD(P)H:quinone oxidoreductase [Leptospiraceae bacterium] diamond 6189 213 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
26851112 26851112 PRJNA1195374_P_NODE_48681_length_316_cov_1.267490_g48337_i0 PRJNA1195374 48681 316 1.26749 4.0052684 Treponema sp. 166 Bacteria Bacteria 48.9 6.06e-4   NR MEL3906274.1 166 g48337 i0 41.4 1.91772151898734 70 29 55.1 2 311 138 997 1066 MEL3906274.1 leucine-rich repeat protein [Treponema sp.] diamond 606 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27376201 27376201 PRJNA1195374_P_NODE_71523_length_251_cov_0.865169_g71179_i0 PRJNA1195374 71523 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 42.7 0.0384   NR MBO4386367.1 166 g71179 i0 55.3 0.896414342629482 38 17 45.4 0 251 138 266 303 MBO4386367.1 biotin--[acetyl-CoA-carboxylase] ligase [Treponema sp.] diamond 225 43.1 0.990719257540603 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27514773 27514773 PRJNA1195374_P_NODE_20903_length_496_cov_2.879433_g20560_i0 PRJNA1195374 20903 496 2.879433 14.28198768 Spirochaetota bacterium 2202144 Bacteria Bacteria 114 3.27e-29   NR MFC1669666.1 2202144 g20560 i0 51.5 1.37903225806452 99 43 59.9 1 434 138 3 96 MFC1669666.1 DUF268 domain-containing protein [Spirochaetota bacterium] diamond 684 114 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27818149 27818149 PRJNA1195374_P_NODE_65724_length_264_cov_1.968586_g65380_i0 PRJNA1195374 65724 264 1.968586 5.19706704 Pseudomonadati 3379134 Bacteria Bacteria 54.7 1.27e-6   NR MDR1901076.1 166 g65380 i0 38.6 8.86363636363636 83 45 94.3 1 252 4 82 158 MDR1901076.1 ribonuclease HII [Treponema sp.] diamond 2340 55.1 0.992740471869329 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28209256 28209256 PRJNA1195374_P_NODE_68766_length_256_cov_1.573770_g68422_i0 PRJNA1195374 68766 256 1.57377 4.0288512 Leptospira wolffii 409998 Bacteria Bacteria 42.4 0.043   NR TGK71453.1 409998 g68422 i0 46 0.5859375 50 25 56.3 2 153 10 135 184 TGK71453.1 hypothetical protein EHQ35_15120 [Leptospira wolffii] diamond 150 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
28481008 28481008 PRJNA1195374_P_NODE_41046_length_348_cov_1.112727_g40702_i0 PRJNA1195374 41046 348 1.112727 3.87228996 Bacteria 2 Bacteria Bacteria 106 1.32e-24   NR MBN1647407.1 2026792 g40702 i0 61.8 6.5948275862069 76 29 65.5 0 235 8 5 80 MBN1647407.1 UDP-galactopyranose mutase [Spirochaetales bacterium] diamond 2295 107 0.990654205607477 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28765055 28765055 PRJNA1195374_P_NODE_41187_length_347_cov_1.613139_g40843_i0 PRJNA1195374 41187 347 1.613139 5.59759233 Leptonema 32205 Bacteria Bacteria 144 1.64e-41   NR MCS7205395.1 2026757 g40843 i0 65.3 6.26801152737752 101 35 87.3 0 303 1 2 102 MCS7205395.1 VOC family protein [Leptospiraceae bacterium] diamond 2175 145 0.993103448275862 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28777605 28777605 PRJNA1195374_P_NODE_22767_length_476_cov_1.441687_g22423_i0 PRJNA1195374 22767 476 1.441687 6.86243012 Spirochaetales bacterium 2026792 Bacteria Bacteria 42 0.0451   NR NLV60267.1 2026792 g22423 i0 47.7 0.277310924369748 44 20 27.7 1 205 74 12 52 NLV60267.1 Hsp20/alpha crystallin family protein [Spirochaetales bacterium] diamond 132 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29049443 29049443 PRJNA1195374_P_NODE_36648_length_371_cov_1.328859_g36304_i0 PRJNA1195374 36648 371 1.328859 4.93006689 Pseudomonadati 3379134 Bacteria Bacteria 43.9 0.0248   NR MFA6936940.1 166 g36304 i0 25.9 1.51212938005391 108 78 87.3 1 38 361 24 129 MFA6936940.1 cell division protein ZapB [Treponema sp.] diamond 561 44.3 0.99097065462754 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29062077 29062077 PRJNA1195374_P_NODE_77448_length_246_cov_1.780347_g77104_i0 PRJNA1195374 77448 246 1.780347 4.37965362 Spirochaetota bacterium 2202144 Bacteria Bacteria 51.6 2.77e-5   NR HOJ50144.1 2202144 g77104 i0 45.3 0.646341463414634 53 29 64.6 0 169 11 192 244 HOJ50144.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium] diamond 159 51.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29093668 29093668 PRJNA1195374_P_NODE_64448_length_268_cov_1.184615_g64104_i0 PRJNA1195374 64448 268 1.184615 3.1747682 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 48.5 4.66e-4   NR MDC7126422.1 1898206 g64104 i0 44.2 0.951492537313433 43 24 48.1 0 11 139 365 407 MDC7126422.1 leucine-rich repeat protein [Spirochaetaceae bacterium] diamond 255 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30230402 30230402 PRJNA1195374_P_NODE_85392_length_241_cov_0.910714_g85048_i0 PRJNA1195374 85392 241 0.910714 2.19482074 Spirochaetales bacterium 2026792 Bacteria Bacteria 102 2.1e-23   NR MBN2441772.1 2026792 g85048 i0 62.8 2.93775933609959 78 28 97.1 1 6 239 298 374 MBN2441772.1 nicotinate phosphoribosyltransferase [Spirochaetales bacterium] diamond 708 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30483233 30483233 PRJNA1195374_P_NODE_77173_length_247_cov_0.885057_g76829_i0 PRJNA1195374 77173 247 0.885057 2.18609079 Spirochaetota bacterium 2202144 Bacteria Bacteria 48.1 4.99e-4   NR MDH5679942.1 2202144 g76829 i0 65.7 0.425101214574899 35 12 42.5 0 243 139 24 58 MDH5679942.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium] diamond 105 48.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30502151 30502151 PRJNA1195374_P_NODE_30673_length_408_cov_1.791045_g30329_i0 PRJNA1195374 30673 408 1.791045 7.3074636 FCB group 1783270 Bacteria Bacteria 45.4 0.0254   NR MBR4790225.1 166 g30329 i0 48.8 2.19852941176471 41 21 30.1 0 32 154 1228 1268 MBR4790225.1 InlB B-repeat-containing protein [Treponema sp.] diamond 897 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30767555 30767555 PRJNA1195374_P_NODE_60874_length_277_cov_1.789216_g60530_i0 PRJNA1195374 60874 277 1.789216 4.95612832 Leptospiraceae bacterium 2026757 Bacteria Bacteria 92.8 1.14e-21   NR MCX7997998.1 2026757 g60530 i0 47.3 5.94584837545126 91 47 98.6 1 273 1 55 144 MCX7997998.1 alcohol dehydrogenase catalytic domain-containing protein [Leptospiraceae bacterium] diamond 1647 92.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31146222 31146222 PRJNA1195374_P_NODE_42015_length_343_cov_2.029630_g41671_i0 PRJNA1195374 42015 343 2.02963 6.9616309 Spirochaetota bacterium 2202144 Bacteria Bacteria 51.2 2.24e-5   NR HNR87930.1 2202144 g41671 i0 50 0.402332361516035 46 23 40.2 0 15 152 65 110 HNR87930.1 LCCL domain-containing protein [Spirochaetota bacterium] diamond 138 51.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31178006 31178006 PRJNA1195374_P_NODE_76435_length_247_cov_0.885057_g76091_i0 PRJNA1195374 76435 247 0.885057 2.18609079 Spirochaetia bacterium 2053615 Bacteria Bacteria 79.3 4.71e-15   NR HET6451523.1 2053615 g76091 i0 44.4 3.93522267206478 81 45 98.4 0 245 3 355 435 HET6451523.1 PIG-L family deacetylase [Spirochaetia bacterium] diamond 972 79.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31671598 31671598 PRJNA1195374_P_NODE_43197_length_338_cov_1.452830_g42853_i0 PRJNA1195374 43197 338 1.45283 4.9105654 Pseudomonadati 3379134 Bacteria Bacteria 80.9 6e-17   NR MBI3395605.1 2053615 g42853 i0 46.8 2.79585798816568 77 40 67.5 1 322 95 47 123 MBI3395605.1 hypothetical protein [Spirochaetia bacterium] diamond 945 80.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31937230 31937230 PRJNA1195374_P_NODE_44437_length_333_cov_1.100000_g44093_i0 PRJNA1195374 44437 333 1.1 3.663 Spirochaetales bacterium 2026792 Bacteria Bacteria 72 5.55e-12   NR MBO5770184.1 2026792 g44093 i0 40 2.44144144144144 90 52 81.1 1 61 330 349 436 MBO5770184.1 carboxypeptidase M32 [Spirochaetales bacterium] diamond 813 72 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32190524 32190524 PRJNA1195374_P_NODE_29338_length_418_cov_1.982609_g28994_i0 PRJNA1195374 29338 418 1.982609 8.28730562 Leptospiraceae bacterium 2026757 Bacteria Bacteria 73.9 5.81e-14   NR MDX1958332.1 2026757 g28994 i0 59.2 0.351674641148325 49 20 35.2 0 53 199 55 103 MDX1958332.1 Mpo1-like protein [Leptospiraceae bacterium] diamond 147 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32538766 32538766 PRJNA1195374_P_NODE_48159_length_318_cov_1.106122_g47815_i0 PRJNA1195374 48159 318 1.106122 3.51746796 Alkalispirochaeta sphaeroplastigenens 1187066 Bacteria Bacteria 43.5 0.0488   NR WP_103680911.1 1187066 g47815 i0 37.8 0.69811320754717 74 46 69.8 0 253 32 817 890 WP_103680911.1 hypothetical protein [Alkalispirochaeta sphaeroplastigenens] diamond 222 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sphaeroplastigenens
32570444 32570444 PRJNA1195374_P_NODE_51559_length_305_cov_1.642241_g51215_i0 PRJNA1195374 51559 305 1.642241 5.00883505 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.5 0.039   NR HRX49589.1 2202144 g51215 i0 40.6 0.678688524590164 69 40 67.9 1 4 210 199 266 HRX49589.1 LL-diaminopimelate aminotransferase [Spirochaetota bacterium] diamond 207 43.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;