RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA489308" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA489308 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
13203965 13203965 PRJNA489308_P_NODE_39991_length_233_cov_2.512500_g39915_i0 PRJNA489308 39991 233 2.5125 5.854125 Pseudomonadati 3379134 Bacteria Bacteria 103 3.5399999999999995e-24   NR WP_010573175.1 408139 g39915 i0 70.1 19.8283261802575 77 22 99.1 1 2 232 272 347 WP_010573175.1 ornithine--oxo-acid transaminase [Leptospira kmetyi] diamond 4620 104 0.990384615384615 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kmetyi
15752732 15752732 PRJNA489308_P_NODE_11193_length_343_cov_2.040741_g11117_i0 PRJNA489308 11193 343 2.040741 6.99974163 root 1 Root_unresolved Root_unresolved 181 5.879999999999999e-52   NR WP_013314340.1 154 g11117 i0 80.7 38.8862973760933 114 21 99.7 1 342 1 79 191 WP_013314340.1 phosphoenolpyruvate mutase [Spirochaeta thermophila] diamond 13338 181 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Winmispirales Winmispiraceae Winmispira Winmispira thermophila
20851710 20851710 PRJNA489308_P_NODE_11837_length_337_cov_2.056818_g11761_i0 PRJNA489308 11837 337 2.056818 6.93147666 Leptospira sp. 178 Bacteria Bacteria 179 1.8499999999999996e-55   NR MCC5815248.1 178 g11761 i0 74.1 1.99406528189911 112 28 99.7 1 336 1 26 136 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 672 179 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
28150361 28150361 PRJNA489308_P_NODE_25905_length_265_cov_1.203125_g25829_i0 PRJNA489308 25905 265 1.203125 3.18828125 Spirochaetia bacterium 2053615 Bacteria Bacteria 62 5.46e-10   NR NCB00775.1 2053615 g25829 i0 34.5 0.984905660377358 87 56 98.5 1 262 2 6 91 NCB00775.1 alpha/beta hydrolase [Spirochaetia bacterium] diamond 261 62 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28781504 28781504 PRJNA489308_P_NODE_367_length_1268_cov_4.779079_g331_i0 PRJNA489308 367 1268 4.779079 60.59872172 Termitinemataceae bacterium 3022875 Bacteria Bacteria 70.9 1.03e-9   NR GMO38143.1 3022875 g331 i0 29 1.02917981072555 145 91 34.1 3 34 465 129 262 GMO38143.1 MAG: hypothetical protein Ta2F_14260 [Termitinemataceae bacterium] diamond 1305 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Termitinemataceae   Termitinemataceae bacterium
29255062 29255062 PRJNA489308_P_NODE_34329_length_246_cov_1.780347_g34253_i0 PRJNA489308 34329 246 1.780347 4.37965362 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.4 7.3e-5   NR MBU0926636.1 2202144 g34253 i0 48.2 0.682926829268293 56 26 68.3 1 234 67 324 376 MBU0926636.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 168 50.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29807994 29807994 PRJNA489308_P_NODE_33811_length_247_cov_0.885057_g33735_i0 PRJNA489308 33811 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 51.6 2.95e-5   NR MBP5252095.1 166 g33735 i0 37.7 1.89473684210526 53 33 64.4 0 16 174 570 622 MBP5252095.1 response regulator [Treponema sp.] diamond 468 52 0.992307692307692 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30107847 30107847 PRJNA489308_P_NODE_172_length_1544_cov_4.480625_g148_i0 PRJNA489308 172 1544 4.480625 69.18085 Spirochaetia bacterium 2053615 Bacteria Bacteria 59.7 6.86e-6   NR NBK25468.1 2053615 g148 i0 32.1 0.217616580310881 112 72 21.8 2 967 632 79 186 NBK25468.1 hypothetical protein [Spirochaetia bacterium] diamond 336 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30534688 30534688 PRJNA489308_P_NODE_26213_length_264_cov_1.209424_g26137_i0 PRJNA489308 26213 264 1.209424 3.19287936 Treponema 157 Bacteria Bacteria 52 1.78e-5   NR MEE0352807.1 166 g26137 i0 37.7 4.39772727272727 77 48 87.5 0 240 10 133 209 MEE0352807.1 tetratricopeptide repeat protein [Treponema sp.] diamond 1161 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30565998 30565998 PRJNA489308_P_NODE_4773_length_477_cov_2.049505_g4697_i0 PRJNA489308 4773 477 2.049505 9.77613885 Pseudomonadati 3379134 Bacteria Bacteria 65.9 3.64e-9   NR MCU0821199.1 2202144 g4697 i0 62.7 0.616352201257862 51 19 32.1 0 476 324 536 586 MCU0821199.1 acetate--CoA ligase [Spirochaetota bacterium] diamond 294 65.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30724258 30724258 PRJNA489308_P_NODE_39034_length_241_cov_0.916667_g38958_i0 PRJNA489308 39034 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 70.5 1.71e-12   NR HAF85417.1 1972642 g38958 i0 53.2 3.32365145228216 62 29 77.2 0 186 1 102 163 HAF85417.1 hypothetical protein [Sphaerochaeta sp.] diamond 801 70.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
30803016 30803016 PRJNA489308_P_NODE_29134_length_255_cov_1.648352_g29058_i0 PRJNA489308 29134 255 1.648352 4.2032976 Leptospira perolatii 2023191 Bacteria Bacteria 42.7 0.0372   NR WP_100715319.1 2023191 g29058 i0 50 0.882352941176471 36 16 40 1 251 150 198 233 WP_100715319.1 MORN repeat-containing protein [Leptospira perolatii] diamond 225 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira perolatii
31103317 31103317 PRJNA489308_P_NODE_31935_length_249_cov_2.562500_g31859_i0 PRJNA489308 31935 249 2.5625 6.380625 root 1 Root_unresolved Root_unresolved 79.3 5.05e-15   NR WP_016550879.1 48782 g31859 i0 54.2 8.44578313253012 72 33 86.7 0 247 32 464 535 WP_016550879.1 oleate hydratase [Leptospira fainei] diamond 2103 79.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira fainei
31846284 31846284 PRJNA489308_P_NODE_16477_length_304_cov_1.930736_g16401_i0 PRJNA489308 16477 304 1.930736 5.86943744 Spirochaetales bacterium 2026792 Bacteria Bacteria 95.9 4.77e-23   NR MEI8094677.1 2026792 g16401 i0 61.5 0.769736842105263 78 29 77 1 8 241 44 120 MEI8094677.1 RidA family protein [Spirochaetales bacterium] diamond 234 95.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32716021 32716021 PRJNA489308_P_NODE_23060_length_275_cov_1.212871_g22984_i0 PRJNA489308 23060 275 1.212871 3.33539525 root 1 Root_unresolved Root_unresolved 88.2 4.83e-20   NR MDA8411388.1 166 g22984 i0 48.4 4.92 93 46 99.3 2 274 2 12 104 MDA8411388.1 phosphoribosyltransferase family protein [Treponema sp.] diamond 1353 89 0.991011235955056 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32857442 32857442 PRJNA489308_P_NODE_21860_length_279_cov_2.058252_g21784_i0 PRJNA489308 21860 279 2.058252 5.74252308 Leptospira licerasiae 447106 Bacteria Bacteria 85.9 3.84e-17   NR WP_008593944.1 447106 g21784 i0 55.1 1.82795698924731 89 33 95.7 3 9 275 618 699 WP_008593944.1 ammonium transporter [Leptospira licerasiae] diamond 510 85.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae

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