RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1022392" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 17 ✖

bioproject 1

  • PRJNA1022392 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
2279130 2279130 PRJNA1022392_P_NODE_59562_length_178_cov_1.175573_g58893_i0 PRJNA1022392 59562 178 1.175573 2.09251994 Deinococcus taklimakanensis 536443 Bacteria Bacteria 115 3.13e-29   NR WP_386845130.1 536443 g58893 i0 98.3 0.99438202247191 59 1 99.4 0 1 177 184 242 WP_386845130.1 ABC transporter ATP-binding protein [Deinococcus taklimakanensis] diamond 177 115 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
26654849 26654849 PRJNA1022392_P_NODE_29701_length_206_cov_3.779874_g29032_i0 PRJNA1022392 29701 206 3.779874 7.78654044 Thermus sp. CCB_US3_UF1 1111069 Bacteria Bacteria 64.7 3.7e-12   NR AEV17142.1 1111069 g29032 i0 90.6 0.466019417475728 32 3 46.6 0 98 3 1 32 AEV17142.1 Alpha-aminoadipate carrier protein lysW [Thermus sp. CCB_US3_UF1] diamond 96 64.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. CCB_US3_UF1
26654851 26654851 PRJNA1022392_P_NODE_44441_length_195_cov_2.358108_g43772_i0 PRJNA1022392 44441 195 2.358108 4.5983106 Deinococcus sp. RM 2316359 Bacteria Bacteria 61.6 2.81e-9   NR WP_119673422.1 2316359 g43772 i0 82.9 0.538461538461538 35 6 53.8 0 91 195 82 116 WP_119673422.1 hypothetical protein [Deinococcus sp. RM] diamond 105 61.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. RM
26971602 26971602 PRJNA1022392_P_NODE_84342_length_151_cov_2.461538_g83673_i0 PRJNA1022392 84342 151 2.461538 3.71692238 Deinococcus radiophilus 32062 Bacteria Bacteria 70.5 1.76e-12   NR WP_126351156.1 32062 g83673 i0 66.7 1.90728476821192 48 16 95.4 0 150 7 858 905 WP_126351156.1 DUF11 domain-containing protein [Deinococcus radiophilus] diamond 288 70.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
27003155 27003155 PRJNA1022392_P_NODE_33302_length_206_cov_2.767296_g32633_i0 PRJNA1022392 33302 206 2.767296 5.70062976 Deinococcus cellulosilyticus 401558 Bacteria Bacteria 65.1 3.49e-11   NR WP_186815829.1 401558 g32633 i0 96.9 0.466019417475728 32 1 46.6 0 2 97 83 114 WP_186815829.1 Lrp/AsnC family transcriptional regulator [Deinococcus cellulosilyticus] diamond 96 65.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cellulosilyticus
27287831 27287831 PRJNA1022392_P_NODE_60603_length_176_cov_3.116279_g59934_i0 PRJNA1022392 60603 176 3.116279 5.48465104 uncultured Truepera sp. 543023 Bacteria Bacteria 57.8 8e-9   NR CAA9562262.1 543023 g59934 i0 73.7 0.647727272727273 38 10 64.8 0 175 62 81 118 CAA9562262.1 MAG: hypothetical protein AVDCRST_MAG86-736 [uncultured Truepera sp.] diamond 114 57.8 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
28298243 28298243 PRJNA1022392_P_NODE_11506_length_328_cov_3.911032_g10844_i0 PRJNA1022392 11506 328 3.911032 12.82818496 Dethiosulfovibrio sp. 2944751 Bacteria Bacteria 138 7.74e-39   NR MDD4837478.1 2944751 g10844 i0 61.1 0.98780487804878 108 40 97 1 2 319 72 179 MDD4837478.1 hypothetical protein [Dethiosulfovibrio sp.] diamond 324 138 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Dethiosulfovibrio Dethiosulfovibrio sp.
28551103 28551103 PRJNA1022392_P_NODE_61167_length_176_cov_0.906977_g60498_i0 PRJNA1022392 61167 176 0.906977 1.59627952 Deinococcus misasensis 392413 Bacteria Bacteria 119 2.49e-31   NR WP_034345641.1 392413 g60498 i0 96.6 0.988636363636364 58 2 98.9 0 176 3 24 81 WP_034345641.1 alpha/beta hydrolase [Deinococcus misasensis] diamond 174 119 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
29024886 29024886 PRJNA1022392_P_NODE_34628_length_206_cov_2.484277_g33959_i0 PRJNA1022392 34628 206 2.484277 5.11761062 uncultured Truepera sp. 543023 Bacteria Bacteria 87.4 4.2e-18   NR CAA9586658.1 543023 g33959 i0 57.6 1.2378640776699 85 19 99 1 2 205 1007 1091 CAA9586658.1 MAG: GH13_16 | GH13_36 | GH13_23 | GH13_17 | GH13 _4 | GH13_31 | GH13 | GH13_40 | GH13_30 | GH13_29 | G H13_35 | GH13_20 | GH13_2 | GH13_21 | GH13_18 | GH13 _34 | GH13_1 [uncultured Truepera sp.] diamond 255 87.4 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
29561151 29561151 PRJNA1022392_P_NODE_47890_length_192_cov_4.255172_g47221_i0 PRJNA1022392 47890 192 4.255172 8.16993024 Deinococcus cavernae 2320857 Bacteria Bacteria 91.3 2.17e-20   NR WP_119759979.1 2320857 g47221 i0 52.2 1.4375 92 16 100 1 192 1 103 194 WP_119759979.1 cycloisomerase [Deinococcus cavernae] diamond 276 91.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus cavernae
29655591 29655591 PRJNA1022392_P_NODE_62090_length_174_cov_3.858268_g61421_i0 PRJNA1022392 62090 174 3.858268 6.71338632 Aminivibrio sp. 1872489 Bacteria Bacteria 39.3 0.0443   NR HPK07954.1 1872489 g61421 i0 54.3 0.603448275862069 35 15 60.3 1 38 142 14 47 HPK07954.1 hypothetical protein [Aminivibrio sp.] diamond 105 39.3 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminivibrio Aminivibrio sp.
29940389 29940389 PRJNA1022392_P_NODE_52311_length_187_cov_2.321429_g51642_i0 PRJNA1022392 52311 187 2.321429 4.34107223 Truepera radiovictrix 332249 Bacteria Bacteria 55.1 7.9e-7   NR WP_013177145.1 332249 g51642 i0 74.2 0.497326203208556 31 8 49.7 0 2 94 211 241 WP_013177145.1 N-6 DNA methylase [Truepera radiovictrix] diamond 93 55.1 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
30192884 30192884 PRJNA1022392_P_NODE_52192_length_187_cov_2.771429_g51523_i0 PRJNA1022392 52192 187 2.771429 5.18257223 Deinococcus aestuarii 2774531 Bacteria Bacteria 99.8 1.8199999999999994e-23   NR WP_216324452.1 2774531 g51523 i0 60 1.60427807486631 100 1 97.9 1 3 185 94 193 WP_216324452.1 DMT family transporter [Deinococcus aestuarii] diamond 300 99.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aestuarii
30635129 30635129 PRJNA1022392_P_NODE_40153_length_196_cov_4.684564_g39484_i0 PRJNA1022392 40153 196 4.684564 9.18174544 Meiothermus hypogaeus 884155 Bacteria Bacteria 52.8 4.08e-7   NR WP_119340678.1 884155 g39484 i0 89.7 0.443877551020408 29 3 44.4 0 3 89 32 60 WP_119340678.1 HypC/HybG/HupF family hydrogenase formation chaperone [Meiothermus hypogaeus] diamond 87 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus hypogaeus
31038476 31038476 PRJNA1022392_P_NODE_37575_length_204_cov_2.000000_g36906_i0 PRJNA1022392 37575 204 2 4.08 Deinococci 188787 Bacteria Bacteria 68.9 6.68e-13   NR MBA2666787.1 2026798 g36906 i0 85.4 2.41176470588235 41 6 60.3 0 204 82 36 76 MBA2666787.1 30S ribosomal protein S11 [Trueperaceae bacterium] diamond 492 68.9 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
31931420 31931420 PRJNA1022392_P_NODE_76817_length_160_cov_0.858407_g76148_i0 PRJNA1022392 76817 160 0.858407 1.3734512 Thermus oshimai 56957 Bacteria Bacteria 56.6 7.99e-9   NR GAA6741988.1 56957 g76148 i0 65.8 0.7125 38 13 71.3 0 155 42 45 82 GAA6741988.1 hypothetical protein Thermus77359_21750 [Thermus oshimai] diamond 114 56.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus oshimai
32532953 32532953 PRJNA1022392_P_NODE_57479_length_180_cov_3.699248_g56810_i0 PRJNA1022392 57479 180 3.699248 6.6586464 Fervidobacterium sp. 1871331 Bacteria Bacteria 99.8 1.93e-25   NR MBP9518197.1 1871331 g56810 i0 100 0.783333333333333 47 0 78.3 0 141 1 1 47 MBP9518197.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Fervidobacterium sp.] diamond 141 99.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium 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);;