contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA688352" and tax_phylum = "Thermotogota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942897 | 1942897 | PRJNA688352_P_NODE_7722_length_250_cov_0.870056_g7619_i0 | PRJNA688352 | 7722 | 250 | 0.870056 | 2.17514 | Petrotogaceae bacterium | 2819251 | Bacteria | Bacteria | 140 | 2.1e-36 | NR | HOG34777.1 | 2819251 | g7619 | i0 | 100 | 3.456 | 72 | 0 | 86.4 | 0 | 216 | 1 | 378 | 449 | HOG34777.1 response regulator [Petrotogaceae bacterium] | diamond | 864 | 140 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotogaceae bacterium | |||
| 7045546 | 7045546 | PRJNA688352_P_NODE_7986_length_250_cov_0.870056_g7883_i0 | PRJNA688352 | 7986 | 250 | 0.870056 | 2.17514 | Thermotogae | 188708 | Bacteria | Bacteria | 173 | 5.519999999999999e-48 | NR | HQQ56591.1 | 2053577 | g7883 | i0 | 100 | 4.98 | 83 | 0 | 99.6 | 0 | 250 | 2 | 754 | 836 | HQQ56591.1 hypothetical protein [Mesotoga sp.] | diamond | 1245 | 173 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 26639033 | 26639033 | PRJNA688352_P_NODE_11721_length_242_cov_0.911243_g11618_i0 | PRJNA688352 | 11721 | 242 | 0.911243 | 2.20520806 | Thermotogaceae bacterium | 2268206 | Bacteria | Bacteria | 65.5 | 3.54e-12 | NR | NLX33236.1 | 2268206 | g11618 | i0 | 100 | 0.384297520661157 | 31 | 0 | 38.4 | 0 | 95 | 3 | 1 | 31 | NLX33236.1 AbrB/MazE/SpoVT family DNA-binding domain-containing protein [Thermotogaceae bacterium] | diamond | 93 | 65.5 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotogaceae bacterium | |||
| 26987199 | 26987199 | PRJNA688352_P_NODE_5942_length_271_cov_1.555556_g5839_i0 | PRJNA688352 | 5942 | 271 | 1.555556 | 4.21555676 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 184 | 1.7299999999999996e-55 | NR | HQN29238.1 | 2053577 | g5839 | i0 | 100 | 5.91143911439114 | 89 | 0 | 98.5 | 0 | 3 | 269 | 180 | 268 | HQN29238.1 YjgP/YjgQ family permease [Mesotoga sp.] | diamond | 1602 | 184 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 27366993 | 27366993 | PRJNA688352_P_NODE_8903_length_248_cov_0.880000_g8800_i0 | PRJNA688352 | 8903 | 248 | 0.88 | 2.1824 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 100 | 1.0799999999999999e-24 | NR | MDD4478506.1 | 2053577 | g8800 | i0 | 100 | 1.18548387096774 | 49 | 0 | 59.3 | 0 | 2 | 148 | 102 | 150 | MDD4478506.1 RluA family pseudouridine synthase [Mesotoga sp.] | diamond | 294 | 100 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 27524590 | 27524590 | PRJNA688352_P_NODE_7243_length_251_cov_0.865169_g7140_i0 | PRJNA688352 | 7243 | 251 | 0.865169 | 2.17157419 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 79.3 | 1.18e-16 | NR | HPB64872.1 | 2053577 | g7140 | i0 | 97.4 | 0.466135458167331 | 39 | 1 | 46.6 | 0 | 250 | 134 | 99 | 137 | HPB64872.1 YbaK/EbsC family protein [Mesotoga sp.] | diamond | 117 | 79.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 28661357 | 28661357 | PRJNA688352_P_NODE_9667_length_246_cov_0.890173_g9564_i0 | PRJNA688352 | 9667 | 246 | 0.890173 | 2.18982558 | Petrotogaceae bacterium | 2819251 | Bacteria | Bacteria | 87.4 | 6.54e-18 | NR | HPX16689.1 | 2819251 | g9564 | i0 | 100 | 2 | 41 | 0 | 50 | 0 | 1 | 123 | 437 | 477 | HPX16689.1 molybdopterin-dependent oxidoreductase [Petrotogaceae bacterium] | diamond | 492 | 87.4 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotogaceae bacterium | |||
| 28693026 | 28693026 | PRJNA688352_P_NODE_12407_length_241_cov_0.916667_g12304_i0 | PRJNA688352 | 12407 | 241 | 0.916667 | 2.20916747 | Mesotoga infera | 1236046 | Bacteria | Bacteria | 158 | 5.869999999999998e-47 | NR | WP_169699785.1 | 1236046 | g12304 | i0 | 96.3 | 0.995850622406639 | 80 | 3 | 99.6 | 0 | 2 | 241 | 45 | 124 | WP_169699785.1 deoxynucleoside kinase [Mesotoga infera] | diamond | 240 | 158 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga infera | ||
| 29450371 | 29450371 | PRJNA688352_P_NODE_8290_length_249_cov_0.875000_g8187_i0 | PRJNA688352 | 8290 | 249 | 0.875 | 2.17875 | Thermotogaceae bacterium | 2268206 | Bacteria | Bacteria | 172 | 1.02e-53 | NR | NLX34217.1 | 2268206 | g8187 | i0 | 100 | 1 | 83 | 0 | 100 | 0 | 249 | 1 | 10 | 92 | NLX34217.1 glycosyltransferase family 1 protein [Thermotogaceae bacterium] | diamond | 249 | 172 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotogaceae bacterium | |||
| 29513576 | 29513576 | PRJNA688352_P_NODE_5010_length_290_cov_1.949309_g4907_i0 | PRJNA688352 | 5010 | 290 | 1.949309 | 5.6529961 | Mesotoga prima | 1184387 | Bacteria | Bacteria | 189 | 1.3099999999999995e-55 | NR | WP_333641396.1 | 1184387 | g4907 | i0 | 100 | 1.97586206896552 | 96 | 0 | 99.3 | 0 | 2 | 289 | 29 | 124 | WP_333641396.1 transposase [Mesotoga prima] | diamond | 573 | 189 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga prima | ||
| 29525461 | 29525461 | PRJNA688352_P_NODE_8330_length_249_cov_0.875000_g8227_i0 | PRJNA688352 | 8330 | 249 | 0.875 | 2.17875 | Thermotogae | 188708 | Bacteria | Bacteria | 160 | 1.22e-43 | NR | MDD5743626.1 | 2053577 | g8227 | i0 | 100 | 3.95180722891566 | 82 | 0 | 98.8 | 0 | 2 | 247 | 374 | 455 | MDD5743626.1 hypothetical protein [Mesotoga sp.] | diamond | 984 | 160 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 29671261 | 29671261 | PRJNA688352_P_NODE_11810_length_242_cov_0.911243_g11707_i0 | PRJNA688352 | 11810 | 242 | 0.911243 | 2.20520806 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 129 | 9.07e-35 | NR | HPB63487.1 | 2053577 | g11707 | i0 | 100 | 0.84297520661157 | 68 | 0 | 84.3 | 0 | 206 | 3 | 1 | 68 | HPB63487.1 NAD/NADP octopine/nopaline dehydrogenase family protein [Mesotoga sp.] | diamond | 204 | 129 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 29809395 | 29809395 | PRJNA688352_P_NODE_8571_length_248_cov_0.880000_g8468_i0 | PRJNA688352 | 8571 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 64.3 | 8.25e-10 | NR | HPM22242.1 | 2053689 | g8468 | i0 | 96.4 | 0.67741935483871 | 28 | 1 | 33.9 | 0 | 165 | 248 | 1 | 28 | HPM22242.1 IS5 family transposase [Thermotogota bacterium] | diamond | 168 | 64.3 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium | ||||||
| 30113744 | 30113744 | PRJNA688352_P_NODE_7652_length_250_cov_0.870056_g7549_i0 | PRJNA688352 | 7652 | 250 | 0.870056 | 2.17514 | Petrotogaceae bacterium | 2819251 | Bacteria | Bacteria | 173 | 4.97e-53 | NR | HQH34038.1 | 2819251 | g7549 | i0 | 98.8 | 2.988 | 83 | 1 | 99.6 | 0 | 250 | 2 | 83 | 165 | HQH34038.1 sugar transferase [Petrotogaceae bacterium] | diamond | 747 | 173 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotogaceae bacterium | |||
| 30272102 | 30272102 | PRJNA688352_P_NODE_9752_length_246_cov_0.890173_g9649_i0 | PRJNA688352 | 9752 | 246 | 0.890173 | 2.18982558 | Petrotogaceae bacterium | 2819251 | Bacteria | Bacteria | 170 | 5.92e-47 | NR | HPO27047.1 | 2819251 | g9649 | i0 | 100 | 2 | 82 | 0 | 100 | 0 | 1 | 246 | 494 | 575 | HPO27047.1 phosphoribosylformylglycinamidine synthase [Petrotogaceae bacterium] | diamond | 492 | 170 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotogaceae bacterium | |||
| 30504632 | 30504632 | PRJNA688352_P_NODE_8193_length_249_cov_0.875000_g8090_i0 | PRJNA688352 | 8193 | 249 | 0.875 | 2.17875 | Mesotoga | 1184396 | Bacteria | Bacteria | 125 | 2.89e-33 | NR | WP_183084357.1 | 1462923 | g8090 | i0 | 95.5 | 3.2289156626506 | 67 | 3 | 80.7 | 0 | 248 | 48 | 210 | 276 | WP_183084357.1 carbohydrate ABC transporter permease [Mesotoga sp. HF07.pep.5.2.highcov] | diamond | 804 | 125 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. HF07.pep.5.2.highcov | ||
| 30587612 | 30587612 | PRJNA688352_P_NODE_11053_length_243_cov_0.905882_g10950_i0 | PRJNA688352 | 11053 | 243 | 0.905882 | 2.20129326 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 167 | 1.33e-50 | NR | HQN27205.1 | 2053577 | g10950 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 241 | 2 | 111 | 190 | HQN27205.1 short-chain dehydrogenase [Mesotoga sp.] | diamond | 240 | 167 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 31124504 | 31124504 | PRJNA688352_P_NODE_11795_length_242_cov_0.911243_g11692_i0 | PRJNA688352 | 11795 | 242 | 0.911243 | 2.20520806 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 157 | 4.5099999999999985e-47 | NR | MDD5744723.1 | 2053577 | g11692 | i0 | 100 | 3.96694214876033 | 80 | 0 | 99.2 | 0 | 3 | 242 | 91 | 170 | MDD5744723.1 FAD/NAD(P)-binding oxidoreductase [Mesotoga sp.] | diamond | 960 | 157 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 31757377 | 31757377 | PRJNA688352_P_NODE_8857_length_248_cov_0.880000_g8754_i0 | PRJNA688352 | 8857 | 248 | 0.88 | 2.1824 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 149 | 1.59e-42 | NR | MDD5744642.1 | 2053577 | g8754 | i0 | 100 | 1.98387096774194 | 82 | 0 | 99.2 | 0 | 247 | 2 | 175 | 256 | MDD5744642.1 TRAP transporter large permease subunit [Mesotoga sp.] | diamond | 492 | 149 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 31852156 | 31852156 | PRJNA688352_P_NODE_5597_length_278_cov_1.126829_g5494_i0 | PRJNA688352 | 5597 | 278 | 1.126829 | 3.13258462 | Petrotogaceae bacterium | 2819251 | Bacteria | Bacteria | 181 | 3.6899999999999985e-55 | NR | HNV06217.1 | 2819251 | g5494 | i0 | 100 | 0.992805755395683 | 92 | 0 | 99.3 | 0 | 3 | 278 | 88 | 179 | HNV06217.1 MBL fold metallo-hydrolase [Petrotogaceae bacterium] | diamond | 276 | 181 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotogaceae bacterium | |||
| 31852157 | 31852157 | PRJNA688352_P_NODE_7777_length_250_cov_0.870056_g7674_i0 | PRJNA688352 | 7777 | 250 | 0.870056 | 2.17514 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 156 | 2.3499999999999992e-43 | NR | HOI64358.1 | 2053577 | g7674 | i0 | 97.6 | 0.996 | 83 | 2 | 99.6 | 0 | 1 | 249 | 294 | 376 | HOI64358.1 DUF4127 family protein [Mesotoga sp.] | diamond | 249 | 156 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 32010498 | 32010498 | PRJNA688352_P_NODE_7178_length_251_cov_0.865169_g7075_i0 | PRJNA688352 | 7178 | 251 | 0.865169 | 2.17157419 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 103 | 1.31e-25 | NR | HPB64423.1 | 2053577 | g7075 | i0 | 100 | 0.621513944223108 | 52 | 0 | 62.2 | 0 | 249 | 94 | 123 | 174 | HPB64423.1 winged helix-turn-helix domain-containing protein [Mesotoga sp.] | diamond | 156 | 103 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 32200376 | 32200376 | PRJNA688352_P_NODE_9398_length_247_cov_0.885057_g9295_i0 | PRJNA688352 | 9398 | 247 | 0.885057 | 2.18609079 | Mesotoga prima | 1184387 | Bacteria | Bacteria | 169 | 4.4999999999999994e-49 | NR | WP_333642293.1 | 1184387 | g9295 | i0 | 97.6 | 2.98785425101215 | 82 | 2 | 99.6 | 0 | 246 | 1 | 71 | 152 | WP_333642293.1 DNA methyltransferase, partial [Mesotoga prima] | diamond | 738 | 169 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga prima | ||
| 32485277 | 32485277 | PRJNA688352_P_NODE_9099_length_247_cov_0.885057_g8996_i0 | PRJNA688352 | 9099 | 247 | 0.885057 | 2.18609079 | Mesotoga infera | 1236046 | Bacteria | Bacteria | 165 | 1.6099999999999998e-45 | NR | HPD39138.1 | 1236046 | g8996 | i0 | 98.8 | 0.983805668016194 | 81 | 1 | 98.4 | 0 | 245 | 3 | 239 | 319 | HPD39138.1 TIGR03986 family CRISPR-associated RAMP protein [Mesotoga infera] | diamond | 243 | 165 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga infera |
Advanced export
JSON shape: default, array, newline-delimited
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);;