contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1182301" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 318955 | 318955 | PRJNA1182301_P_NODE_48981_length_251_cov_0.865169_g48856_i0 | PRJNA1182301 | 48981 | 251 | 0.865169 | 2.17157419 | Halobellus limi | 699433 | Archaea | Archaea | 88.6 | 3.12e-18 | NR | SEF66128.1 | 699433 | g48856 | i0 | 54.3 | 5.84462151394422 | 81 | 37 | 96.8 | 0 | 7 | 249 | 1465 | 1545 | SEF66128.1 PGF-CTERM protein [Halobellus limi] | diamond | 1467 | 88.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi | |
| 2869691 | 2869691 | PRJNA1182301_P_NODE_49043_length_251_cov_0.865169_g48918_i0 | PRJNA1182301 | 49043 | 251 | 0.865169 | 2.17157419 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 144 | 4.32e-41 | NR | WP_259518466.1 | 2866382 | g48918 | i0 | 80.7 | 0.99203187250996006 | 83 | 16 | 99.2 | 0 | 250 | 2 | 3 | 85 | WP_259518466.1 energy-coupling factor ABC transporter ATP-binding protein [Halanaeroarchaeum sp. HSR-CO] | diamond | 249 | 144 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO | |
| 4145155 | 4145155 | PRJNA1182301_P_NODE_21844_length_286_cov_1.953052_g21719_i0 | PRJNA1182301 | 21844 | 286 | 1.953052 | 5.58572872 | Halobacteriales archaeon | 1904752 | Archaea | Archaea | 108 | 9.25e-26 | NR | HKJ57889.1 | 1904752 | g21719 | i0 | 58.5 | 0.986013986013986 | 94 | 39 | 98.6 | 0 | 2 | 283 | 163 | 256 | HKJ57889.1 polymer-forming cytoskeletal protein [Halobacteriales archaeon] | diamond | 282 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 24544635 | 24544635 | PRJNA1182301_P_NODE_38300_length_264_cov_1.612565_g38175_i0 | PRJNA1182301 | 38300 | 264 | 1.612565 | 4.2571716 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 155 | 8.61e-42 | NR | WP_181692425.1 | 2750669 | g38175 | i0 | 93.2 | 1 | 88 | 6 | 100 | 0 | 1 | 264 | 517 | 604 | WP_181692425.1 thioredoxin domain-containing protein [Natronomonas sp. LN261] | diamond | 264 | 155 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 26723571 | 26723571 | PRJNA1182301_P_NODE_34881_length_268_cov_3.333333_g34756_i0 | PRJNA1182301 | 34881 | 268 | 3.333333 | 8.93333244 | Candidatus Nanohaloarchaea archaeon | 2594798 | Archaea | Archaea | 54.3 | 2.41e-7 | NR | MFB6203425.1 | 2594798 | g34756 | i0 | 43.5 | 0.694029850746269 | 62 | 35 | 69.4 | 0 | 23 | 208 | 15 | 76 | MFB6203425.1 histone [Candidatus Nanohaloarchaea archaeon] | diamond | 186 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Nanohaloarchaea | Candidatus Nanohaloarchaea archaeon | ||||
| 26755507 | 26755507 | PRJNA1182301_P_NODE_29461_length_276_cov_1.295567_g29336_i0 | PRJNA1182301 | 29461 | 276 | 1.295567 | 3.57576492 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 169 | 1.4299999999999999e-46 | NR | WP_181693315.1 | 2750669 | g29336 | i0 | 91.2 | 0.989130434782609 | 91 | 8 | 98.9 | 0 | 275 | 3 | 818 | 908 | WP_181693315.1 DNA polymerase domain-containing protein [Natronomonas sp. LN261] | diamond | 273 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 27628653 | 27628653 | PRJNA1182301_P_NODE_36944_length_266_cov_1.512953_g36819_i0 | PRJNA1182301 | 36944 | 266 | 1.512953 | 4.02445498 | Halobacteriaceae | 2236 | Archaea | Archaea | 45.1 | 0.00757 | NR | MFB6082214.1 | 1963275 | g36819 | i0 | 63.3 | 0.676691729323308 | 30 | 11 | 33.8 | 0 | 264 | 175 | 654 | 683 | MFB6082214.1 type B DNA-directed DNA polymerase [Halanaeroarchaeum sp.] | diamond | 180 | 45.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 28240599 | 28240599 | PRJNA1182301_P_NODE_21006_length_287_cov_2.471963_g20881_i0 | PRJNA1182301 | 21006 | 287 | 2.471963 | 7.09453381 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 154 | 2.5299999999999993e-42 | NR | WP_181692427.1 | 2750669 | g20881 | i0 | 95.3 | 0.888501742160279 | 85 | 4 | 88.9 | 0 | 1 | 255 | 432 | 516 | WP_181692427.1 hypothetical protein [Natronomonas sp. LN261] | diamond | 255 | 154 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 28335508 | 28335508 | PRJNA1182301_P_NODE_61806_length_242_cov_0.911243_g61681_i0 | PRJNA1182301 | 61806 | 242 | 0.911243 | 2.20520806 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 151 | 1.31e-44 | NR | WP_181691783.1 | 2750669 | g61681 | i0 | 92.5 | 0.991735537190083 | 80 | 6 | 99.2 | 0 | 240 | 1 | 73 | 152 | WP_181691783.1 helix-turn-helix transcriptional regulator [Natronomonas sp. LN261] | diamond | 240 | 151 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 28493508 | 28493508 | PRJNA1182301_P_NODE_66467_length_231_cov_2.620253_g66342_i0 | PRJNA1182301 | 66467 | 231 | 2.620253 | 6.05278443 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 79.3 | 4.08e-15 | NR | WP_181692687.1 | 2750669 | g66342 | i0 | 85.7 | 0.636363636363636 | 49 | 7 | 63.6 | 0 | 60 | 206 | 921 | 969 | WP_181692687.1 BGTF surface domain-containing protein [Natronomonas sp. LN261] | diamond | 147 | 79.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 29471901 | 29471901 | PRJNA1182301_P_NODE_54410_length_247_cov_1.362069_g54285_i0 | PRJNA1182301 | 54410 | 247 | 1.362069 | 3.36431043 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 95.5 | 3.26e-22 | NR | WP_050047757.1 | 1604004 | g54285 | i0 | 79 | 1.50607287449393 | 62 | 13 | 75.3 | 0 | 61 | 246 | 133 | 194 | WP_050047757.1 dienelactone hydrolase family protein [Halanaeroarchaeum sulfurireducens] | diamond | 372 | 95.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 31228636 | 31228636 | PRJNA1182301_P_NODE_43115_length_258_cov_1.605405_g42990_i0 | PRJNA1182301 | 43115 | 258 | 1.605405 | 4.1419449 | Halanaeroarchaeum | 1656823 | Archaea | Archaea | 101 | 5.34e-23 | NR | WP_050047778.1 | 1604004 | g42990 | i0 | 82.5 | 3.62790697674419 | 63 | 11 | 73.3 | 0 | 189 | 1 | 1 | 63 | WP_050047778.1 MgtC/SapB family protein [Halanaeroarchaeum sulfurireducens] | diamond | 936 | 102 | 0.990196078431373 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 31778902 | 31778902 | PRJNA1182301_P_NODE_26957_length_279_cov_1.975728_g26832_i0 | PRJNA1182301 | 26957 | 279 | 1.975728 | 5.51228112 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 157 | 1.78e-44 | NR | WP_181691260.1 | 2750669 | g26832 | i0 | 95.7 | 0.989247311827957 | 92 | 4 | 98.9 | 0 | 277 | 2 | 141 | 232 | WP_181691260.1 signal peptidase I [Natronomonas sp. LN261] | diamond | 276 | 157 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 32127214 | 32127214 | PRJNA1182301_P_NODE_36778_length_266_cov_1.595855_g36653_i0 | PRJNA1182301 | 36778 | 266 | 1.595855 | 4.2449743 | Halolamina salina | 1220023 | Archaea | Archaea | 42 | 0.0442 | NR | WP_379732489.1 | 1220023 | g36653 | i0 | 40 | 0.676691729323308 | 60 | 33 | 67.7 | 2 | 61 | 240 | 71 | 127 | WP_379732489.1 cytidine deaminase [Halolamina salina] | diamond | 180 | 42 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina salina |
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);;