RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA724011" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 22 ✖

bioproject 1

  • PRJNA724011 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
19837514 19837514 PRJNA724011_P_NODE_35176_length_458_cov_1.937662_g34157_i0 PRJNA724011 35176 458 1.937662 8.87449196 Bacteria 2 Bacteria Bacteria 110 1.32e-25   NR MFN2321341.1 2026798 g34157 i0 79.1 11.1615720524017 67 14 43.9 0 251 451 3 69 MFN2321341.1 low specificity L-threonine aldolase [Trueperaceae bacterium] diamond 5112 110 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
26935910 26935910 PRJNA724011_P_NODE_67482_length_307_cov_1.799145_g66459_i0 PRJNA724011 67482 307 1.799145 5.52337515 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 85.9 5.63e-17   NR WP_165143968.1 1755814 g66459 i0 45.3 5.65798045602606 106 46 94.8 3 13 303 153 255 WP_165143968.1 IGHMBP2 family helicase [Marinitoga sp. 38H-ov] diamond 1737 85.9 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Marinitoga Marinitoga sp. 38H-ov
27178336 27178336 PRJNA724011_P_NODE_111782_length_229_cov_3.500000_g110759_i0 PRJNA724011 111782 229 3.5 8.015 Thermotogaceae bacterium 2268206 Bacteria Bacteria 42 0.0338   NR MDI3471901.1 2268206 g110759 i0 37 0.707423580786026 54 33 70.7 1 204 43 4 56 MDI3471901.1 uncharacterized protein [Thermotogaceae bacterium] diamond 162 42 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
27589376 27589376 PRJNA724011_P_NODE_32584_length_480_cov_1.464373_g31565_i0 PRJNA724011 32584 480 1.464373 7.0289904 Calidithermus terrae 1408545 Bacteria Bacteria 104 9.22e-23   NR WP_147372671.1 1408545 g31565 i0 43.1 1.76875 144 70 88.8 5 9 434 423 556 WP_147372671.1 penicillin acylase family protein, partial [Calidithermus terrae] diamond 849 104 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus terrae
27873392 27873392 PRJNA724011_P_NODE_46065_length_385_cov_1.750000_g45042_i0 PRJNA724011 46065 385 1.75 6.7375 Kosmotoga pacifica 1330330 Bacteria Bacteria 44.7 0.0278   NR WP_245612731.1 1330330 g45042 i0 50 0.358441558441558 46 21 35.8 1 141 4 12 55 WP_245612731.1 deoxyribose-phosphate aldolase [Kosmotoga pacifica] diamond 138 44.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Kosmotoga Kosmotoga pacifica
28126135 28126135 PRJNA724011_P_NODE_84265_length_269_cov_1.000000_g83242_i0 PRJNA724011 84265 269 1 2.69 Deinococcus peraridilitoris 432329 Bacteria Bacteria 134 1.56e-37   NR WP_041232012.1 432329 g83242 i0 61.5 1.01486988847584 91 33 99.3 1 2 268 86 176 WP_041232012.1 SMI1/KNR4 family protein [Deinococcus peraridilitoris] diamond 273 134 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
28188874 28188874 PRJNA724011_P_NODE_19266_length_672_cov_1.908180_g18260_i0 PRJNA724011 19266 672 1.90818 12.8229696 Deinococcales bacterium 2478479 Bacteria Bacteria 86.7 4.07e-16   NR MEZ4631478.1 2478479 g18260 i0 28.7 6.72321428571429 216 126 96.4 4 23 670 22 209 MEZ4631478.1 sugar ABC transporter substrate-binding protein [Deinococcales bacterium] diamond 4518 86.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales     Deinococcales bacterium
28199376 28199376 PRJNA724011_P_NODE_72466_length_294_cov_1.723982_g71443_i0 PRJNA724011 72466 294 1.723982 5.06850708 Bacteria 2 Bacteria Bacteria 105 1.29e-24   NR HKI57866.1 2026798 g71443 i0 53.6 3.95918367346939 97 45 99 0 3 293 112 208 HKI57866.1 beta-ketoacyl-ACP synthase II [Trueperaceae bacterium] diamond 1164 106 0.990566037735849 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
28915107 28915107 PRJNA724011_P_NODE_61368_length_325_cov_1.214286_g60345_i0 PRJNA724011 61368 325 1.214286 3.9464295 Pseudothermotoga sp. 2033661 Bacteria Bacteria 115 1.7e-30   NR HOJ87808.1 2033661 g60345 i0 60.4 1.69846153846154 91 36 84 0 325 53 33 123 HOJ87808.1 glycine cleavage system protein GcvH [Pseudothermotoga sp.] diamond 552 115 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
29515045 29515045 PRJNA724011_P_NODE_22430_length_608_cov_5.730841_g21417_i0 PRJNA724011 22430 608 5.730841 34.84351328 Synergistales bacterium 2268201 Bacteria Bacteria 51.6 3e-4   NR GHS94371.1 2268201 g21417 i0 38.3 0.463815789473684 94 47 41 4 295 47 70 163 GHS94371.1 hypothetical protein AGMMS50276_06870 [Synergistales bacterium] diamond 282 51.6 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales     Synergistales bacterium
29546648 29546648 PRJNA724011_P_NODE_18490_length_690_cov_1.260940_g17487_i0 PRJNA724011 18490 690 1.26094 8.700486 Pseudothermotoga sp. 2033661 Bacteria Bacteria 49.3 0.00819   NR MEJ5229452.1 2033661 g17487 i0 34.7 1.53913043478261 98 51 38.3 3 52 315 478 572 MEJ5229452.1 ATP-binding protein [Pseudothermotoga sp.] diamond 1062 49.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
29641207 29641207 PRJNA724011_P_NODE_44570_length_393_cov_1.675000_g43547_i0 PRJNA724011 44570 393 1.675 6.58275 Trueperaceae bacterium 2026798 Bacteria Bacteria 60.5 1.17e-7   NR MDF1522747.1 2026798 g43547 i0 29.7 1.98473282442748 128 86 97.7 1 391 8 304 427 MDF1522747.1 F0F1 ATP synthase subunit alpha [Trueperaceae bacterium] diamond 780 60.5 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
29999535 29999535 PRJNA724011_P_NODE_52311_length_357_cov_1.066901_g51288_i0 PRJNA724011 52311 357 1.066901 3.80883657 Thermotoga 2335 Bacteria Bacteria 53.5 2.08e-5   NR WP_041844430.1 126738 g51288 i0 37.5 2.6890756302521 80 49 67.2 1 98 337 229 307 WP_041844430.1 magnesium transporter [Thermotoga sp. RQ7] diamond 960 53.5 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp. RQ7
30620795 30620795 PRJNA724011_P_NODE_64313_length_316_cov_1.716049_g63290_i0 PRJNA724011 64313 316 1.716049 5.42271484 Deinococcus peraridilitoris 432329 Bacteria Bacteria 72.4 4.4e-13   NR WP_041232012.1 432329 g63290 i0 37.9 0.977848101265823 103 59 93 2 294 1 6 108 WP_041232012.1 SMI1/KNR4 family protein [Deinococcus peraridilitoris] diamond 309 72.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
31252825 31252825 PRJNA724011_P_NODE_42355_length_406_cov_1.603604_g41332_i0 PRJNA724011 42355 406 1.603604 6.51063224 Thermotogaceae bacterium 2268206 Bacteria Bacteria 44.7 0.0381   NR MDN5359838.1 2268206 g41332 i0 28.4 0.701970443349754 95 65 68 1 48 323 214 308 MDN5359838.1 heat-inducible transcriptional repressor [Thermotogaceae bacterium] diamond 285 44.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
31326454 31326454 PRJNA724011_P_NODE_2675_length_1795_cov_9.968641_g2332_i0 PRJNA724011 2675 1795 9.968641 178.93710595 Bacteria 2 Bacteria Bacteria 267 1.18e-78   NR WP_273990980.1 328692 g2332 i0 35.7 6.48635097493036 499 293 80.6 6 1753 308 5 492 WP_273990980.1 factor-independent urate hydroxylase [Deinococcus aquaticus] diamond 11643 267 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
31411028 31411028 PRJNA724011_P_NODE_39096_length_428_cov_1.529577_g38073_i0 PRJNA724011 39096 428 1.529577 6.54658956 Meiothermus sp. 1955249 Bacteria Bacteria 88.6 2.83e-17   NR MER3555365.1 1955249 g38073 i0 39.8 0.827102803738318 118 69 82.7 1 74 427 443 558 MER3555365.1 peptidase M16 [Meiothermus sp.] diamond 354 88.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus sp.
31790331 31790331 PRJNA724011_P_NODE_43297_length_400_cov_2.342508_g42274_i0 PRJNA724011 43297 400 2.342508 9.370032 Deinococcus piscis 394230 Bacteria Bacteria 101 4.77e-24   NR WP_189642814.1 394230 g42274 i0 52.4 0.63 84 40 63 0 22 273 90 173 WP_189642814.1 SMI1/KNR4 family protein [Deinococcus piscis] diamond 252 101 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus piscis
31800743 31800743 PRJNA724011_P_NODE_81297_length_274_cov_3.064677_g80274_i0 PRJNA724011 81297 274 3.064677 8.39721498 Bacteria 2 Bacteria Bacteria 50.8 6.7e-5   NR WP_041083630.1 1508420 g80274 i0 38.8 1.92700729927007 49 30 53.6 0 12 158 232 280 WP_041083630.1 ACP S-malonyltransferase [Thermotoga profunda] diamond 528 51.2 0.9921875 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga profunda
32297181 32297181 PRJNA724011_P_NODE_63539_length_318_cov_2.171429_g62516_i0 PRJNA724011 63539 318 2.171429 6.90514422 Deinococcus roseus 392414 Bacteria Bacteria 94 9.68e-20   NR WP_229684590.1 392414 g62516 i0 70.2 0.537735849056604 57 17 53.8 0 142 312 352 408 WP_229684590.1 glycosyl hydrolase family 18 protein [Deinococcus roseus] diamond 171 94 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus roseus
32550214 32550214 PRJNA724011_P_NODE_78959_length_279_cov_2.747573_g77936_i0 PRJNA724011 78959 279 2.747573 7.66572867 Candidatus Equadaptatus faecalis 3083093 Bacteria Bacteria 42.4 0.0379   NR MBQ0055330.1 3083093 g77936 i0 31.1 0.655913978494624 61 42 65.6 0 13 195 28 88 MBQ0055330.1 PqqD family protein [Candidatus Equadaptatus faecalis] diamond 183 42.4 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Candidatus Equadaptatus Candidatus Equadaptatus faecalis
32906556 32906556 PRJNA724011_P_NODE_15280_length_777_cov_2.738636_g14319_i0 PRJNA724011 15280 777 2.738636 21.27920172 root 1 Root_unresolved Root_unresolved 154 5.13e-40   NR WP_370533121.1 275 g14319 i0 44.4 15.4555984555985 207 107 79.5 3 708 91 72 271 WP_370533121.1 DEAD/DEAH box helicase, partial [Thermus sp.] diamond 12009 154 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.

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