contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA949785" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13686864 | 13686864 | PRJNA949785_P_NODE_18471_length_242_cov_1.378698_g18274_i0 | PRJNA949785 | 18471 | 242 | 1.378698 | 3.33644916 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 149 | 2.5799999999999993e-42 | NR | MFB6085499.1 | 1980530 | g18274 | i0 | 89.9 | 1.97107438016529 | 79 | 8 | 97.9 | 0 | 241 | 5 | 65 | 143 | MFB6085499.1 lipoyl synthase [Halodesulfurarchaeum sp.] | diamond | 477 | 149 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 21335328 | 21335328 | PRJNA949785_P_NODE_7457_length_395_cov_1.195652_g7260_i0 | PRJNA949785 | 7457 | 395 | 1.195652 | 4.7228254 | archaeon | 1906665 | Archaea | Archaea | 194 | 1.3e-57 | NR | RYG65165.1 | 1906665 | g7260 | i0 | 75 | 2.00506329113924 | 132 | 32 | 99.5 | 1 | 394 | 2 | 188 | 319 | RYG65165.1 MAG: ABC-F family ATP-binding cassette domain-containing protein [archaeon] | diamond | 792 | 194 | 1 | Archaea | archaeon | ||||||||
| 26740212 | 26740212 | PRJNA949785_P_NODE_15501_length_251_cov_0.865169_g15304_i0 | PRJNA949785 | 15501 | 251 | 0.865169 | 2.17157419 | Halanaeroarchaeum sp. | 1963275 | Archaea | Archaea | 139 | 1.0499999999999998e-37 | NR | MFB6094000.1 | 1963275 | g15304 | i0 | 86.7 | 0.99203187250996006 | 83 | 11 | 99.2 | 0 | 3 | 251 | 209 | 291 | MFB6094000.1 tubulin/FtsZ family protein [Halanaeroarchaeum sp.] | diamond | 249 | 139 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 26962080 | 26962080 | PRJNA949785_P_NODE_18962_length_241_cov_0.916667_g18765_i0 | PRJNA949785 | 18962 | 241 | 0.916667 | 2.20916747 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 66.6 | 1.37e-10 | NR | WP_181691579.1 | 2750669 | g18765 | i0 | 93.8 | 0.398340248962656 | 32 | 2 | 39.8 | 0 | 96 | 1 | 1 | 32 | WP_181691579.1 NCS2 family permease [Natronomonas sp. LN261] | diamond | 96 | 66.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 27246774 | 27246774 | PRJNA949785_P_NODE_18403_length_243_cov_0.888235_g18206_i0 | PRJNA949785 | 18403 | 243 | 0.888235 | 2.15841105 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 155 | 4.08e-44 | NR | WP_181692849.1 | 2750669 | g18206 | i0 | 92.5 | 0.987654320987654 | 80 | 6 | 98.8 | 0 | 3 | 242 | 246 | 325 | WP_181692849.1 thiolase family protein [Natronomonas sp. LN261] | diamond | 240 | 155 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 27310212 | 27310212 | PRJNA949785_P_NODE_17983_length_244_cov_0.900585_g17786_i0 | PRJNA949785 | 17983 | 244 | 0.900585 | 2.1974274 | Haloferax larsenii JCM 13917 | 1227460 | Archaea | Archaea | 62.4 | 2.18e-10 | NR | ELZ79431.1 | 1227460 | g17786 | i0 | 50 | 0.688524590163934 | 56 | 28 | 68.9 | 0 | 227 | 60 | 51 | 106 | ELZ79431.1 hypothetical protein C455_07602 [Haloferax larsenii JCM 13917] | diamond | 168 | 62.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax larsenii | |
| 27373506 | 27373506 | PRJNA949785_P_NODE_5483_length_478_cov_0.735802_g5286_i0 | PRJNA949785 | 5483 | 478 | 0.735802 | 3.51713356 | Haloferax sp. Q22 | 1526048 | Archaea | Archaea | 44.7 | 0.0257 | NR | WP_157575373.1 | 1526048 | g5286 | i0 | 66.7 | 0.169456066945607 | 27 | 9 | 16.9 | 0 | 394 | 474 | 42 | 68 | WP_157575373.1 HNH endonuclease signature motif containing protein [Haloferax sp. Q22] | diamond | 81 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. Q22 | |
| 27759012 | 27759012 | PRJNA949785_P_NODE_19464_length_226_cov_3.385621_g19267_i0 | PRJNA949785 | 19464 | 226 | 3.385621 | 7.65150346 | Nanobdellati | 1783276 | Archaea | Archaea | 48.1 | 3.13e-4 | NR | MFH1401221.1 | 2026764 | g19267 | i0 | 53.7 | 2.25663716814159 | 41 | 19 | 54.4 | 0 | 125 | 3 | 102 | 142 | MFH1401221.1 ZIP family metal transporter [Nanoarchaeota archaeon] | diamond | 510 | 48.5 | 0.991752577319588 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28099339 | 28099339 | PRJNA949785_P_NODE_15545_length_251_cov_0.865169_g15348_i0 | PRJNA949785 | 15545 | 251 | 0.865169 | 2.17157419 | Halobellus limi | 699433 | Archaea | Archaea | 44.7 | 0.00685 | NR | WP_103989965.1 | 699433 | g15348 | i0 | 53.1 | 0.382470119521912 | 32 | 15 | 38.2 | 0 | 73 | 168 | 3 | 34 | WP_103989965.1 hypothetical protein [Halobellus limi] | diamond | 96 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi | |
| 28983752 | 28983752 | PRJNA949785_P_NODE_16108_length_249_cov_1.312500_g15911_i0 | PRJNA949785 | 16108 | 249 | 1.3125 | 3.268125 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 161 | 4.81e-45 | NR | WP_181691523.1 | 2750669 | g15911 | i0 | 96.3 | 0.987951807228916 | 82 | 3 | 98.8 | 0 | 2 | 247 | 378 | 459 | WP_181691523.1 sensor histidine kinase [Natronomonas sp. LN261] | diamond | 246 | 161 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 28983755 | 28983755 | PRJNA949785_P_NODE_17428_length_245_cov_1.534884_g17231_i0 | PRJNA949785 | 17428 | 245 | 1.534884 | 3.7604658 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 130 | 1.64e-33 | NR | MDZ7849954.1 | 1980530 | g17231 | i0 | 82.7 | 0.991836734693878 | 81 | 14 | 99.2 | 0 | 245 | 3 | 57 | 137 | MDZ7849954.1 ABC transporter permease [Halodesulfurarchaeum sp.] | diamond | 243 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 29173121 | 29173121 | PRJNA949785_P_NODE_15829_length_250_cov_0.870056_g15632_i0 | PRJNA949785 | 15829 | 250 | 0.870056 | 2.17514 | Halocalculus aciditolerans | 1383812 | Archaea | Archaea | 74.3 | 2.87e-13 | NR | WP_188977489.1 | 1383812 | g15632 | i0 | 51.3 | 1.872 | 78 | 32 | 92.4 | 2 | 248 | 18 | 6 | 78 | WP_188977489.1 DNA (cytosine-5-)-methyltransferase [Halocalculus aciditolerans] | diamond | 468 | 74.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halocalculus | Halocalculus aciditolerans | |
| 29835940 | 29835940 | PRJNA949785_P_NODE_4391_length_544_cov_1.225053_g4196_i0 | PRJNA949785 | 4391 | 544 | 1.225053 | 6.66428832 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 48.1 | 0.00697 | NR | RLJ00689.1 | 3121606 | g4196 | i0 | 33 | 0.501838235294118 | 91 | 53 | 48 | 2 | 141 | 401 | 1 | 87 | RLJ00689.1 MAG: TraB family protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 273 | 48.1 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29930946 | 29930946 | PRJNA949785_P_NODE_16311_length_249_cov_0.875000_g16114_i0 | PRJNA949785 | 16311 | 249 | 0.875 | 2.17875 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 120 | 1.85e-32 | NR | MDT7864685.1 | 2056631 | g16114 | i0 | 98.3 | 0.72289156626506 | 60 | 1 | 72.3 | 0 | 247 | 68 | 113 | 172 | MDT7864685.1 hypothetical protein [Thermoproteota archaeon] | diamond | 180 | 120 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30183482 | 30183482 | PRJNA949785_P_NODE_15872_length_250_cov_0.870056_g15675_i0 | PRJNA949785 | 15872 | 250 | 0.870056 | 2.17514 | Halomicroarcula sp. GCM1 | 44098 | Archaea | Archaea | 85.9 | 1e-17 | NR | WP_379788386.1 | 3252667 | g15675 | i0 | 45.2 | 1.008 | 84 | 45 | 99.6 | 1 | 249 | 1 | 116 | 199 | WP_379788386.1 homing endonuclease associated repeat-containing protein [Halomicroarcula sp. GCM10025324] | diamond | 252 | 85.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Halomicroarcula sp. GCM10025324 | |
| 30342036 | 30342036 | PRJNA949785_P_NODE_17992_length_244_cov_0.900585_g17795_i0 | PRJNA949785 | 17992 | 244 | 0.900585 | 2.1974274 | Haloprofundus sp. MHR1 | 2572921 | Archaea | Archaea | 55.5 | 1.26e-6 | NR | WP_137046907.1 | 2572921 | g17795 | i0 | 51.1 | 2.36065573770492 | 45 | 22 | 55.3 | 0 | 2 | 136 | 706 | 750 | WP_137046907.1 PAS domain S-box protein [Haloprofundus sp. MHR1] | diamond | 576 | 55.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus sp. MHR1 | |
| 30594145 | 30594145 | PRJNA949785_P_NODE_19033_length_241_cov_0.916667_g18836_i0 | PRJNA949785 | 19033 | 241 | 0.916667 | 2.20916747 | Haloplanus sp. | 1961696 | Archaea | Archaea | 71.2 | 6.2e-13 | NR | WP_299335884.1 | 1961696 | g18836 | i0 | 55.6 | 1.81742738589212 | 72 | 32 | 89.6 | 0 | 226 | 11 | 102 | 173 | WP_299335884.1 MinD/ParA family ATP-binding protein [Haloplanus sp.] | diamond | 438 | 71.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. | |
| 30910359 | 30910359 | PRJNA949785_P_NODE_17534_length_245_cov_0.895349_g17337_i0 | PRJNA949785 | 17534 | 245 | 0.895349 | 2.19360505 | Halorubrum aidingense | 368623 | Archaea | Archaea | 167 | 3.15e-48 | NR | WP_007999408.1 | 368623 | g17337 | i0 | 96.3 | 0.991836734693878 | 81 | 3 | 99.2 | 0 | 243 | 1 | 217 | 297 | WP_007999408.1 glycosyltransferase [Halorubrum aidingense] | diamond | 243 | 167 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum aidingense | |
| 31415954 | 31415954 | PRJNA949785_P_NODE_13796_length_271_cov_1.363636_g13599_i0 | PRJNA949785 | 13796 | 271 | 1.363636 | 3.69545356 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 101 | 2.03e-25 | NR | HOG74200.1 | 2666341 | g13599 | i0 | 52.4 | 0.907749077490775 | 82 | 39 | 90.8 | 0 | 2 | 247 | 34 | 115 | HOG74200.1 SLOG family protein [Methanofastidiosum sp.] | diamond | 246 | 101 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 32340214 | 32340214 | PRJNA949785_P_NODE_15019_length_256_cov_1.409836_g14822_i0 | PRJNA949785 | 15019 | 256 | 1.409836 | 3.60918016 | Halobacteriales | 2235 | Archaea | Archaea | 70.1 | 7.53e-12 | NR | WP_151114225.1 | 2251 | g14822 | i0 | 84.2 | 1.41796875 | 38 | 5 | 43.4 | 1 | 255 | 145 | 296 | 333 | WP_151114225.1 MULTISPECIES: ABC transporter permease [Haloferax] | diamond | 363 | 70.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | ||
| 32743989 | 32743989 | PRJNA949785_P_NODE_14360_length_264_cov_1.209424_g14163_i0 | PRJNA949785 | 14360 | 264 | 1.209424 | 3.19287936 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 75.9 | 6.01e-14 | NR | HET8792660.1 | 2169593 | g14163 | i0 | 36.4 | 1 | 88 | 55 | 100 | 1 | 264 | 1 | 117 | 203 | HET8792660.1 DnaJ C-terminal domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 264 | 75.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32744001 | 32744001 | PRJNA949785_P_NODE_4100_length_568_cov_1.747475_g3909_i0 | PRJNA949785 | 4100 | 568 | 1.747475 | 9.925658 | Candidatus Culexarchaeum yellowstonense | 2928963 | Archaea | Archaea | 121 | 3e-29 | NR | WP_304329670.1 | 2928963 | g3909 | i0 | 37.5 | 1.80105633802817 | 192 | 111 | 99.8 | 4 | 1 | 567 | 66 | 251 | WP_304329670.1 RNA 3'-terminal phosphate cyclase [Candidatus Culexarchaeum yellowstonense] | diamond | 1023 | 121 | 1 | Archaea | Thermoproteati | Candidatus Culexarchaeota | Candidatus Culexarchaeia | Candidatus Culexarchaeles | Candidatus Culexarchaeaceae | Candidatus Culexarchaeum | Candidatus Culexarchaeum yellowstonense | ||
| 32813357 | 32813357 | PRJNA949785_P_NODE_18120_length_243_cov_1.782353_g17923_i0 | PRJNA949785 | 18120 | 243 | 1.782353 | 4.33111779 | Halanaeroarchaeum | 1656823 | Archaea | Archaea | 90.5 | 5.49e-19 | NR | MFB6070912.1 | 1963275 | g17923 | i0 | 74.2 | 1.62962962962963 | 66 | 17 | 81.5 | 0 | 1 | 198 | 457 | 522 | MFB6070912.1 hydantoinase/oxoprolinase family protein [Halanaeroarchaeum sp.] | diamond | 396 | 90.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 32901171 | 32901171 | PRJNA949785_P_NODE_18200_length_243_cov_0.905882_g18003_i0 | PRJNA949785 | 18200 | 243 | 0.905882 | 2.20129326 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 155 | 4.91e-45 | NR | WP_050047917.1 | 1604004 | g18003 | i0 | 92.6 | 1 | 81 | 6 | 100 | 0 | 243 | 1 | 69 | 149 | WP_050047917.1 tryptophan synthase subunit alpha [Halanaeroarchaeum sulfurireducens] | diamond | 243 | 155 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens |
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);;