RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB10140" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 23 ✖

bioproject 1

  • PRJEB10140 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
7664783 7664783 PRJEB10140_P_NODE_256387_length_167_cov_0.881356_g239078_i0 PRJEB10140 256387 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 107 3.04e-25   NR WP_051682911.1 2754 g239078 i0 98.2 87.9161676646707 55 1 98.8 0 2 166 366 420 WP_051682911.1 excinuclease ABC subunit A [Synergistes jonesii] diamond 14682 108 0.990740740740741 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Synergistes Synergistes jonesii
11185667 11185667 PRJEB10140_P_NODE_30449_length_1118_cov_11.699719_g18635_i0 PRJEB10140 30449 1118 11.699719 130.80285842 Deinococcus multiflagellatus 1656887 Bacteria Bacteria 303 3.619999999999999e-95   NR WP_224605023.1 1656887 g18635 i0 50.4 0.974060822898032 363 162 97.4 5 1117 29 59 403 WP_224605023.1 S8 family peptidase [Deinococcus multiflagellatus] diamond 1089 303 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus multiflagellatus
11491002 11491002 PRJEB10140_P_NODE_29890_length_1135_cov_9.259669_g18235_i0 PRJEB10140 29890 1135 9.259669 105.09724315 root 1 Root_unresolved Root_unresolved 257 4.04e-77   NR WP_013623097.1 1298 g18235 i0 43.5 28.0017621145374 368 188 95.9 9 6 1094 66 418 WP_013623097.1 MULTISPECIES: S8 family peptidase [Deinococcus] diamond 31782 259 0.992277992277992 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
14040580 14040580 PRJEB10140_P_NODE_256792_length_167_cov_0.881356_g239483_i0 PRJEB10140 256792 167 0.881356 1.47186452 uncultured Truepera sp. 543023 Bacteria Bacteria 104 4.9e-26   NR CAA9579776.1 543023 g239483 i0 92.6 0.970059880239521 54 4 97 0 167 6 75 128 CAA9579776.1 MAG: Transcriptional regulator, HxlR family [uncultured Truepera sp.] diamond 162 104 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
27380482 27380482 PRJEB10140_P_NODE_217443_length_184_cov_1.496296_g200134_i0 PRJEB10140 217443 184 1.496296 2.75318464 uncultured Truepera sp. 543023 Bacteria Bacteria 106 1.65e-25   NR CAA9572549.1 543023 g200134 i0 84.2 0.929347826086957 57 9 92.9 0 1 171 346 402 CAA9572549.1 MAG: Adenylosuccinate synthetase [uncultured Truepera sp.] diamond 171 106 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
27538298 27538298 PRJEB10140_P_NODE_284084_length_163_cov_0.903509_g266775_i0 PRJEB10140 284084 163 0.903509 1.47271967 Deinococcus proteolyticus 55148 Bacteria Bacteria 93.2 1.68e-20   NR WP_041222050.1 55148 g266775 i0 81.5 1.98773006134969 54 10 99.4 0 162 1 32 85 WP_041222050.1 RNB domain-containing ribonuclease [Deinococcus proteolyticus] diamond 324 93.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus proteolyticus
27822559 27822559 PRJEB10140_P_NODE_268324_length_165_cov_0.896552_g251015_i0 PRJEB10140 268324 165 0.896552 1.4793108 Allomeiothermus silvanus 52022 Bacteria Bacteria 100 3.36e-23   NR WP_273049399.1 52022 g251015 i0 92.6 0.981818181818182 54 4 98.2 0 3 164 352 405 WP_273049399.1 Trk system potassium transporter TrkA [Allomeiothermus silvanus] diamond 162 100 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
28169664 28169664 PRJEB10140_P_NODE_251746_length_168_cov_0.873950_g234437_i0 PRJEB10140 251746 168 0.87395 1.468236 Deinococcus sp. 47478 Bacteria Bacteria 103 6.4599999999999986e-24   NR MDB5045222.1 47478 g234437 i0 98.2 0.982142857142857 55 1 98.2 0 3 167 435 489 MDB5045222.1 primosomal protein [Deinococcus sp.] diamond 165 103 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
28485476 28485476 PRJEB10140_P_NODE_292387_length_162_cov_0.893805_g275078_i0 PRJEB10140 292387 162 0.893805 1.4479641 Trueperaceae bacterium 2026798 Bacteria Bacteria 94.4 7.270000000000001e-21   NR HET8985603.1 2026798 g275078 i0 96.3 1 54 2 100 0 162 1 84 137 HET8985603.1 potassium/proton antiporter [Trueperaceae bacterium] diamond 162 94.4 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
28643445 28643445 PRJEB10140_P_NODE_245607_length_169_cov_0.866667_g228298_i0 PRJEB10140 245607 169 0.866667 1.46466723 Deinococcus hopiensis 309885 Bacteria Bacteria 41.6 0.0048   NR WP_084050496.1 309885 g228298 i0 53.3 0.532544378698225 30 14 53.3 0 7 96 27 56 WP_084050496.1 hypothetical protein [Deinococcus hopiensis] diamond 90 41.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
28674959 28674959 PRJEB10140_P_NODE_284787_length_163_cov_0.894737_g267478_i0 PRJEB10140 284787 163 0.894737 1.45842131 Deinococcus kurensis 2662757 Bacteria Bacteria 57 1.18e-7   NR WP_155299040.1 2662757 g267478 i0 45.6 1.04907975460123 57 27 97.5 1 2 160 259 315 WP_155299040.1 hypothetical protein [Deinococcus kurensis] diamond 171 57 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus kurensis
29022558 29022558 PRJEB10140_P_NODE_259568_length_167_cov_0.872881_g242259_i0 PRJEB10140 259568 167 0.872881 1.45771127 Deinococcus aquatilis 519440 Bacteria Bacteria 110 2.52e-26   NR WP_019008891.1 519440 g242259 i0 98.2 0.988023952095808 55 1 98.8 0 166 2 748 802 WP_019008891.1 FHA domain-containing serine/threonine-protein kinase [Deinococcus aquatilis] diamond 165 110 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquatilis
29180142 29180142 PRJEB10140_P_NODE_110249_length_331_cov_1.567376_g92944_i0 PRJEB10140 110249 331 1.567376 5.18801456 Thermotoga sp. 4484_232 1968524 Bacteria Bacteria 58.5 2.83e-8   NR OQX56788.1 1968524 g92944 i0 53.8 0.471299093655589 52 22 47.1 1 326 171 74 123 OQX56788.1 MAG: glycine cleavage system protein H [Thermotoga sp. 4484_232] diamond 156 58.5 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp. 4484_232
30317486 30317486 PRJEB10140_P_NODE_159152_length_235_cov_1.580645_g141844_i0 PRJEB10140 159152 235 1.580645 3.71451575 Mesotoga prima 1184387 Bacteria Bacteria 43.9 0.0126   NR WP_324316300.1 1184387 g141844 i0 40.7 1.34042553191489 54 32 68.9 0 72 233 7 60 WP_324316300.1 serine hydrolase [Mesotoga prima] diamond 315 43.9 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Mesotoga Mesotoga prima
30349142 30349142 PRJEB10140_P_NODE_259852_length_167_cov_0.864407_g242543_i0 PRJEB10140 259852 167 0.864407 1.44355969 Marinitoga aeolica 2809031 Bacteria Bacteria 51.6 4.73e-6   NR WP_280997589.1 2809031 g242543 i0 50.9 4.86826347305389 55 24 98.8 2 165 1 90 141 WP_280997589.1 macro domain-containing protein [Marinitoga aeolica] diamond 813 51.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Marinitoga Marinitoga aeolica
30475016 30475016 PRJEB10140_P_NODE_135793_length_271_cov_1.144144_g118486_i0 PRJEB10140 135793 271 1.144144 3.10063024 Synergistaceae bacterium 2053624 Bacteria Bacteria 43.1 0.0338   NR MDR1020058.1 2053624 g118486 i0 41.4 0.642066420664207 58 34 64.2 0 194 21 180 237 MDR1020058.1 tRNA pseudouridine(38-40) synthase TruA [Synergistaceae bacterium] diamond 174 43.1 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
30475109 30475109 PRJEB10140_P_NODE_278033_length_164_cov_0.895652_g260724_i0 PRJEB10140 278033 164 0.895652 1.46886928 Deinococcus sp. VB343 3385567 Bacteria Bacteria 79.7 1.17e-15   NR WP_339096211.1 3385567 g260724 i0 73.1 0.951219512195122 52 14 95.1 0 162 7 879 930 WP_339096211.1 DNA methyltransferase [Deinococcus sp. VB343] diamond 156 79.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
30532058 30532058 PRJEB10140_P_NODE_83833_length_437_cov_1.443299_g66565_i0 PRJEB10140 83833 437 1.443299 6.30721663 Bacteria 2 Bacteria Bacteria 46.2 0.0129   NR HCL80079.1 2053624 g66565 i0 32.4 1.74370709382151 68 41 43.2 1 213 25 24 91 HCL80079.1 endonuclease [Synergistaceae bacterium] diamond 762 46.2 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
30822496 30822496 PRJEB10140_P_NODE_220554_length_182_cov_1.563910_g203245_i0 PRJEB10140 220554 182 1.56391 2.8463162 Trueperaceae bacterium 2026798 Bacteria Bacteria 103 8.27e-24   NR MCA9836966.1 2026798 g203245 i0 75 5.71978021978022 60 15 98.9 0 1 180 400 459 MCA9836966.1 S9 family peptidase [Trueperaceae bacterium] diamond 1041 103 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
31012042 31012042 PRJEB10140_P_NODE_21535_length_1439_cov_46.756835_g10342_i1 PRJEB10140 21535 1439 46.756835 672.83085565 Synergistaceae bacterium 2053624 Bacteria Bacteria 78.6 3.38e-11   NR MBQ3652924.1 2053624 g10342 i1 37.1 0.583738707435719 140 57 27.5 7 412 807 874 990 MBQ3652924.1 putative Ig domain-containing protein [Synergistaceae bacterium] diamond 840 78.6 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
31360009 31360009 PRJEB10140_P_NODE_276576_length_164_cov_0.904348_g259267_i0 PRJEB10140 276576 164 0.904348 1.48313072 Meiothermus granaticius 863370 Bacteria Bacteria 52 6.85e-6   NR WP_147021149.1 863370 g259267 i0 60 1.57317073170732 45 17 80.5 1 136 5 4 48 WP_147021149.1 hypothetical protein [Meiothermus granaticius] diamond 258 52 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus granaticius
32087463 32087463 PRJEB10140_P_NODE_90118_length_406_cov_1.949580_g72829_i0 PRJEB10140 90118 406 1.94958 7.9152948 Synergistaceae bacterium 2053624 Bacteria Bacteria 58.2 7.27e-7   NR MBQ7216726.1 2053624 g72829 i0 35.4 1.24137931034483 96 49 65 4 44 307 72 162 MBQ7216726.1 C-type lectin domain-containing protein [Synergistaceae bacterium] diamond 504 58.2 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
32467361 32467361 PRJEB10140_P_NODE_281579_length_163_cov_0.912281_g264270_i0 PRJEB10140 281579 163 0.912281 1.48701803 Truepera radiovictrix 332249 Bacteria Bacteria 73.6 9.03e-14   NR WP_013178466.1 332249 g264270 i0 74 0.920245398773006 50 13 92 0 160 11 245 294 WP_013178466.1 pseudouridine-5'-phosphate glycosidase [Truepera radiovictrix] diamond 150 73.6 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix

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