RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax_phylum = "Aquificota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Aquificota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA977246 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
3820771 3820771 PRJNA977246_S_NODE_19543_length_314_cov_6679.771930_g18551_i0 PRJNA977246 19543 314 6679.77193 20974.4838602 Aquificaceae bacterium 2053503 Bacteria Bacteria 146 5.9999999999999996e-40   NR MCY0866423.1 2053503 g18551 i0 92.7 0.78343949044586 82 6 78.3 0 302 57 140 221 MCY0866423.1 hypothetical protein [Aquificaceae bacterium] diamond 246 146 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
8603702 8603702 PRJNA977246_S_NODE_11287_length_450_cov_12.004751_g10337_i0 PRJNA977246 11287 450 12.004751 54.0213795 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 275 1.88e-90   NR MBX0311664.1 2053621 g10337 i0 93.8 0.966666666666667 145 9 96.7 0 437 3 9 153 MBX0311664.1 AAA family ATPase [Sulfurihydrogenibium sp.] diamond 435 275 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
10197540 10197540 PRJNA977246_S_NODE_27688_length_241_cov_8924.853774_g26696_i0 PRJNA977246 27688 241 8924.853774 21508.89759534 root 1 Root_unresolved Root_unresolved 98.2 6.33e-22   NR MBX0310205.1 2053621 g26696 i0 92.6 1.34439834024896 54 4 67.2 0 68 229 231 284 MBX0310205.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 324 98.2 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
10197761 10197761 PRJNA977246_S_NODE_8428_length_536_cov_3693.818540_g7568_i0 PRJNA977246 8428 536 3693.81854 19798.8673744 Aquificota bacterium 2202151 Bacteria Bacteria 306 2.67e-97   NR MEW6655393.1 2202151 g7568 i0 94.5 0.917910447761194 164 9 91.8 0 31 522 161 324 MEW6655393.1 SBBP repeat-containing protein [Aquificota bacterium] diamond 492 306 1 Bacteria   Pseudomonadati Aquificota         Aquificota bacterium
14022745 14022745 PRJNA977246_S_NODE_26151_length_252_cov_8546.968610_g25159_i0 PRJNA977246 26151 252 8546.96861 21538.3608972 Hydrogenobacter sp. T-8 1632019 Bacteria Bacteria 85.5 1.36e-18   NR WP_173833989.1 1632019 g25159 i0 90 0.595238095238095 50 5 59.5 0 50 199 108 157 WP_173833989.1 DUF507 family protein [Hydrogenobacter sp. T-8] diamond 150 85.5 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae Pampinifervens Pampinifervens florentissimum
14022764 14022764 PRJNA977246_S_NODE_28111_length_238_cov_1330.559809_g27119_i0 PRJNA977246 28111 238 1330.559809 3166.73234542 Hydrogenobacter thermophilus 940 Bacteria Bacteria 78.6 6.91e-16   NR WP_340694963.1 940 g27119 i0 100 0.491596638655462 39 0 49.2 0 118 2 10 48 WP_340694963.1 TetR/AcrR family transcriptional regulator [Hydrogenobacter thermophilus] diamond 117 78.6 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae Hydrogenobacter Hydrogenobacter thermophilus
15296722 15296722 PRJNA977246_S_NODE_20812_length_300_cov_6726.140221_g19820_i0 PRJNA977246 20812 300 6726.140221 20178.420663 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 71.2 4.68e-12   NR MBX0310550.1 2053621 g19820 i0 74.1 0.54 54 14 54 0 298 137 123 176 MBX0310550.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 162 71.2 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
21671480 21671480 PRJNA977246_S_NODE_6777_length_609_cov_6523.998276_g5992_i0 PRJNA977246 6777 609 6523.998276 39731.14950084 Venenivibrio stagnispumantis 407998 Bacteria Bacteria 136 8.21e-34   NR WP_265134373.1 407998 g5992 i0 45.5 0.704433497536946 143 78 70.4 0 568 140 138 280 WP_265134373.1 site-specific DNA-methyltransferase [Venenivibrio stagnispumantis] diamond 429 136 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Venenivibrio Venenivibrio stagnispumantis
25177448 25177448 PRJNA977246_S_NODE_30700_length_222_cov_4457.119171_g29708_i0 PRJNA977246 30700 222 4457.119171 9894.80455962 Aquificaceae bacterium 2053503 Bacteria Bacteria 132 2.57e-36   NR MCY0866857.1 2053503 g29708 i0 95.2 0.851351351351351 63 3 85.1 0 221 33 11 73 MCY0866857.1 peptidoglycan-binding protein [Aquificaceae bacterium] diamond 189 132 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
27152110 27152110 PRJNA977246_S_NODE_24262_length_268_cov_4.669456_g23270_i0 PRJNA977246 24262 268 4.669456 12.51414208 Aquificota bacterium 2202151 Bacteria Bacteria 154 8.21e-45   NR QWK12679.1 2202151 g23270 i0 88.6 0.985074626865672 88 10 98.5 0 4 267 114 201 QWK12679.1 MAG: ATP-binding cassette domain-containing protein [Aquificota bacterium] diamond 264 154 1 Bacteria   Pseudomonadati Aquificota         Aquificota bacterium
27215582 27215582 PRJNA977246_S_NODE_31742_length_217_cov_2.792553_g30750_i0 PRJNA977246 31742 217 2.792553 6.05984001 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 44.7 0.00294   NR MBX0310509.1 2053621 g30750 i0 78.6 0.387096774193548 28 6 38.7 0 214 131 132 159 MBX0310509.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 84 44.7 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
27247366 27247366 PRJNA977246_S_NODE_23603_length_274_cov_3.657143_g22611_i0 PRJNA977246 23603 274 3.657143 10.02057182 Aquificaceae bacterium 2053503 Bacteria Bacteria 142 6.57e-41   NR MCY0866278.1 2053503 g22611 i0 94 0.908759124087591 83 5 90.9 0 26 274 79 161 MCY0866278.1 hypothetical protein [Aquificaceae bacterium] diamond 249 142 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
27253418 27253418 PRJNA977246_S_NODE_14083_length_393_cov_8.195055_g13098_i0 PRJNA977246 14083 393 8.195055 32.20656615 Bacteria 2 Bacteria Bacteria 190 7.96e-58   NR MEZ0338082.1 2053503 g13098 i0 97 3.02290076335878 99 3 75.6 0 307 11 115 213 MEZ0338082.1 hypothetical protein [Aquificaceae bacterium] diamond 1188 190 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
27348545 27348545 PRJNA977246_S_NODE_32843_length_211_cov_3.807692_g31851_i0 PRJNA977246 32843 211 3.807692 8.03423012 Bacteria 2 Bacteria Bacteria 130 5.88e-34   NR HCO38775.1 2053503 g31851 i0 98.4 1.81990521327014 64 1 91 0 204 13 167 230 HCO38775.1 hypothetical protein [Aquificaceae bacterium] diamond 384 130 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
27910319 27910319 PRJNA977246_S_NODE_49305_length_155_cov_4.047619_g48313_i0 PRJNA977246 49305 155 4.047619 6.27380945 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 95.5 1.17e-21   NR MBX0310549.1 2053621 g48313 i0 90.2 0.987096774193548 51 5 98.7 0 153 1 221 271 MBX0310549.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 153 95.5 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
28036998 28036998 PRJNA977246_S_NODE_30825_length_222_cov_2.492228_g29833_i0 PRJNA977246 30825 222 2.492228 5.53274616 Hydrogenobacter thermophilus 940 Bacteria Bacteria 133 1.64e-37   NR WP_340694963.1 940 g29833 i0 93.2 1 74 5 100 0 222 1 33 106 WP_340694963.1 TetR/AcrR family transcriptional regulator [Hydrogenobacter thermophilus] diamond 222 133 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae Hydrogenobacter Hydrogenobacter thermophilus
28478964 28478964 PRJNA977246_S_NODE_45986_length_163_cov_4.574627_g44994_i0 PRJNA977246 45986 163 4.5746270000000004 7.45664201 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 89.4 3.4900000000000005e-21   NR MBX0310199.1 2053621 g44994 i0 72.5 0.938650306748466 51 14 93.9 0 1 153 25 75 MBX0310199.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 153 89.4 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
28731566 28731566 PRJNA977246_S_NODE_48027_length_158_cov_3.736434_g47035_i0 PRJNA977246 48027 158 3.736434 5.90356572 Aquificaceae bacterium 2053503 Bacteria Bacteria 99 1.2e-23   NR HAV39581.1 2053503 g47035 i0 96.2 0.987341772151899 52 2 98.7 0 3 158 78 129 HAV39581.1 universal stress protein [Aquificaceae bacterium] diamond 156 99 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
29741603 29741603 PRJNA977246_S_NODE_24970_length_262_cov_6.266094_g23978_i0 PRJNA977246 24970 262 6.266094 16.41716628 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 145 1.7199999999999999e-43   NR MBX0310513.1 2053621 g23978 i0 90.7 0.858778625954199 75 7 85.9 0 24 248 4 78 MBX0310513.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 225 145 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
30057604 30057604 PRJNA977246_S_NODE_22371_length_285_cov_5.703125_g21379_i0 PRJNA977246 22371 285 5.703125 16.25390625 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 95.5 3.45e-22   NR MBX0312569.1 2053621 g21379 i0 58.2 0.831578947368421 79 33 83.2 0 46 282 1 79 MBX0312569.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 237 95.5 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
30247547 30247547 PRJNA977246_S_NODE_30032_length_226_cov_4.025381_g29040_i0 PRJNA977246 30032 226 4.025381 9.09736106 Aquificaceae bacterium 2053503 Bacteria Bacteria 145 5.36e-41   NR MDM7267173.1 2053503 g29040 i0 95.8 0.942477876106195 71 3 94.2 0 215 3 171 241 MDM7267173.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Aquificaceae bacterium] diamond 213 145 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
30626285 30626285 PRJNA977246_S_NODE_26953_length_247_cov_2.857798_g25961_i0 PRJNA977246 26953 247 2.857798 7.05876106 Aquificaceae bacterium 2053503 Bacteria Bacteria 161 1.4999999999999996e-47   NR HAV39581.1 2053503 g25961 i0 98.8 0.995951417004049 82 1 99.6 0 1 246 4 85 HAV39581.1 universal stress protein [Aquificaceae bacterium] diamond 246 161 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
30626292 30626292 PRJNA977246_S_NODE_39913_length_182_cov_2.281046_g38921_i0 PRJNA977246 39913 182 2.281046 4.15150372 Aquificaceae bacterium 2053503 Bacteria Bacteria 55.8 3.76e-7   NR MEZ0338115.1 2053503 g38921 i0 96.6 0.956043956043956 29 1 47.8 0 182 96 324 352 MEZ0338115.1 LptF/LptG family permease [Aquificaceae bacterium] diamond 174 55.8 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
30721128 30721128 PRJNA977246_S_NODE_34894_length_202_cov_2.283237_g33902_i0 PRJNA977246 34894 202 2.283237 4.61213874 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 131 2.0800000000000002e-36   NR MBX0311689.1 2053621 g33902 i0 94 0.995049504950495 67 4 99.5 0 2 202 121 187 MBX0311689.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 201 131 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
30942581 30942581 PRJNA977246_S_NODE_50414_length_153_cov_2.064516_g49422_i0 PRJNA977246 50414 153 2.064516 3.15870948 Hydrogenobacter thermophilus 940 Bacteria Bacteria 63.5 1.37e-10   NR WP_304092550.1 940 g49422 i0 52.1 0.941176470588235 48 23 94.1 0 6 149 42 89 WP_304092550.1 hypothetical protein [Hydrogenobacter thermophilus] diamond 144 63.5 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae Hydrogenobacter Hydrogenobacter thermophilus
31005615 31005615 PRJNA977246_S_NODE_31874_length_216_cov_3.844920_g30882_i0 PRJNA977246 31874 216 3.84492 8.3050272 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 115 2.34e-29   NR MBX0310551.1 2053621 g30882 i0 95.1 0.847222222222222 61 3 84.7 0 34 216 4 64 MBX0310551.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 183 115 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
31770591 31770591 PRJNA977246_S_NODE_31837_length_216_cov_5.235294_g30845_i0 PRJNA977246 31837 216 5.235294 11.30823504 Bacteria 2 Bacteria Bacteria 79 4.52e-15   NR HCO38775.1 2053503 g30845 i0 88.6 1.22222222222222 44 5 61.1 0 156 25 122 165 HCO38775.1 hypothetical protein [Aquificaceae bacterium] diamond 264 79 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
31795917 31795917 PRJNA977246_S_NODE_23897_length_271_cov_5.747934_g22905_i0 PRJNA977246 23897 271 5.747934 15.57690114 Aquificaceae bacterium 2053503 Bacteria Bacteria 106 1.82e-24   NR HCO38995.1 2053503 g22905 i0 98.1 1.15129151291513 52 1 57.6 0 271 116 293 344 HCO38995.1 hypothetical protein [Aquificaceae bacterium] diamond 312 106 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Aquificaceae   Aquificaceae bacterium
32555787 32555787 PRJNA977246_S_NODE_38359_length_187_cov_4.639241_g37367_i0 PRJNA977246 38359 187 4.639241 8.67538067 Sulfurihydrogenibium sp. 2053621 Bacteria Bacteria 101 5.6e-25   NR MBX0311662.1 2053621 g37367 i0 93.4 1.9572192513369 61 4 97.9 0 3 185 79 139 MBX0311662.1 hypothetical protein [Sulfurihydrogenibium sp.] diamond 366 101 1 Bacteria   Pseudomonadati Aquificota Aquificia Aquificales Hydrogenothermaceae Sulfurihydrogenibium Sulfurihydrogenibium sp.
32681214 32681214 PRJNA977246_S_NODE_43980_length_169_cov_2.150000_g42988_i0 PRJNA977246 43980 169 2.15 3.6335 Aquificota bacterium 2202151 Bacteria Bacteria 97.8 5.57e-22   NR QWK12592.1 2202151 g42988 i0 91.1 1.98816568047337 56 5 99.4 0 1 168 592 647 QWK12592.1 MAG: DNA topoisomerase (ATP-hydrolyzing) subunit B [Aquificota bacterium] diamond 336 97.8 1 Bacteria   Pseudomonadati Aquificota         Aquificota 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);;