RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1262902" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1262902 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2914226 2914226 PRJNA1262902_P_NODE_12163_length_241_cov_0.916667_g12121_i0 PRJNA1262902 12163 241 0.916667 2.20916747 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 74.3 8.92e-14   NR HEX3303819.1 2482790 g12121 i0 100 0.410788381742739 33 0 41.1 0 26 124 227 259 HEX3303819.1 L-iditol 2-dehydrogenase [Thermomicrobiales bacterium] diamond 99 74.3 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
10567683 10567683 PRJNA1262902_P_NODE_8749_length_248_cov_0.880000_g8707_i0 PRJNA1262902 8749 248 0.88 2.1824 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 134 1.88e-36   NR HEY7032396.1 2482790 g8707 i0 74.4 1.98387096774194 82 21 99.2 0 246 1 162 243 HEY7032396.1 LLM class flavin-dependent oxidoreductase [Thermomicrobiales bacterium] diamond 492 134 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
22040259 22040259 PRJNA1262902_P_NODE_9438_length_247_cov_0.885057_g9396_i0 PRJNA1262902 9438 247 0.885057 2.18609079 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 155 7.869999999999999e-45   NR MCA9834981.1 2482790 g9396 i0 92.7 1.9919028340081 82 6 99.6 0 247 2 146 227 MCA9834981.1 MoxR family ATPase [Thermomicrobiales bacterium] diamond 492 155 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
26789188 26789188 PRJNA1262902_P_NODE_10461_length_245_cov_0.895349_g10419_i0 PRJNA1262902 10461 245 0.895349 2.19360505 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 122 5.549999999999999e-31   NR HEX5503689.1 2482790 g10419 i0 82.1 1.88571428571429 78 14 95.5 0 12 245 311 388 HEX5503689.1 M20 family metallopeptidase [Thermomicrobiales bacterium] diamond 462 122 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
26820893 26820893 PRJNA1262902_P_NODE_11641_length_242_cov_0.911243_g11599_i0 PRJNA1262902 11641 242 0.911243 2.20520806 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 146 7.369999999999998e-41   NR MCC6792819.1 2482790 g11599 i0 91.3 0.991735537190083 80 7 99.2 0 241 2 82 161 MCC6792819.1 NAD-dependent epimerase/dehydratase family protein [Thermomicrobiales bacterium] diamond 240 146 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28052946 28052946 PRJNA1262902_P_NODE_6625_length_258_cov_2.124324_g6583_i0 PRJNA1262902 6625 258 2.124324 5.48075592 uncultured Thermomicrobiales bacterium 1645740 Bacteria Bacteria 63.5 2.19e-9   NR CAA9531128.1 1645740 g6583 i0 71.7 2.44186046511628 53 15 61.6 0 1 159 960 1012 CAA9531128.1 MAG: hypothetical protein AVDCRST_MAG73-962 [uncultured Thermomicrobiales bacterium] diamond 630 63.5 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     uncultured Thermomicrobiales bacterium
28210717 28210717 PRJNA1262902_P_NODE_9906_length_246_cov_0.890173_g9864_i0 PRJNA1262902 9906 246 0.890173 2.18982558 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 67 4.35e-11   NR HKG25810.1 2482790 g9864 i0 47.4 0.926829268292683 76 40 92.7 0 230 3 41 116 HKG25810.1 HAD family hydrolase [Thermomicrobiales bacterium] diamond 228 67 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28526829 28526829 PRJNA1262902_P_NODE_4907_length_280_cov_1.347826_g4865_i0 PRJNA1262902 4907 280 1.347826 3.7739128 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 121 5.579999999999999e-31   NR HEY8448131.1 2482790 g4865 i0 69.8 1.02857142857143 96 25 98.6 3 3 278 48 143 HEY8448131.1 dienelactone hydrolase family protein [Thermomicrobiales bacterium] diamond 288 121 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
28589944 28589944 PRJNA1262902_P_NODE_8507_length_249_cov_0.875000_g8465_i0 PRJNA1262902 8507 249 0.875 2.17875 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 134 1.8199999999999999e-34   NR MEA2585214.1 2482790 g8465 i0 81.7 3.95180722891566 82 15 98.8 0 2 247 902 983 MEA2585214.1 isoleucyl-tRNA synthetase [Thermomicrobiales bacterium] diamond 984 134 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
29789454 29789454 PRJNA1262902_P_NODE_8311_length_249_cov_0.875000_g8269_i0 PRJNA1262902 8311 249 0.875 2.17875 uncultured Thermomicrobiales bacterium 1645740 Bacteria Bacteria 129 7.95e-33   NR CAA9579294.1 1645740 g8269 i0 84.7 0.867469879518072 72 11 86.7 0 4 219 502 573 CAA9579294.1 MAG: Integrase [uncultured Thermomicrobiales bacterium] diamond 216 129 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     uncultured Thermomicrobiales bacterium
30263775 30263775 PRJNA1262902_P_NODE_8592_length_249_cov_0.875000_g8550_i0 PRJNA1262902 8592 249 0.875 2.17875 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 92.4 9.42e-20   NR MCC6790997.1 2482790 g8550 i0 53 1.92771084337349 83 34 94 1 3 236 338 420 MCC6790997.1 polysaccharide deacetylase family protein [Thermomicrobiales bacterium] diamond 480 92.4 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30800469 30800469 PRJNA1262902_P_NODE_7614_length_251_cov_0.865169_g7572_i0 PRJNA1262902 7614 251 0.865169 2.17157419 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 106 2.1e-25   NR MCO5219560.1 2482790 g7572 i0 67.1 1.88844621513944 79 25 93.2 1 235 2 111 189 MCO5219560.1 hypothetical protein [Thermomicrobiales bacterium] diamond 474 106 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales bacterium
30832139 30832139 PRJNA1262902_P_NODE_11494_length_243_cov_0.905882_g11452_i0 PRJNA1262902 11494 243 0.905882 2.20129326 Thermomicrobiales bacterium 2482790 Bacteria Bacteria 149 7.749999999999997e-42   NR MCA9835081.1 2482790 g11452 i0 87.5 2.95061728395062 80 10 98.8 0 2 241 144 223 MCA9835081.1 Gfo/Idh/MocA family oxidoreductase [Thermomicrobiales bacterium] diamond 717 149 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales     Thermomicrobiales 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);;