contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA949785" and tax_clade = "Stenosarchaea group"
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. | |
| 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 | |
| 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 | |
| 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 | ||
| 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);;