contig_metadata
7 rows where bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1385112 | 1385112 | PRJEB49404_P_NODE_500662_length_182_cov_0.769231_g486861_i0 | PRJEB49404 | 500662 | 182 | 0.769231 | 1.40000042 | Natrinema thermotolerans | 121872 | Archaea | Archaea | 80.5 | 7.1e-11 | NTclustered | gi|1621090060|gb|CP031304.1| | 121872 | g486861 | i0 | 82.292 | 56.7637362637363 | 96 | 13 | 85 | 4 | 43 | 136 | 953230 | 953323 | Natrinema thermotolerans strain A29 plasmid unnamed6, complete sequence | blastn | 10331 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema thermotolerans | |
| 5219383 | 5219383 | PRJEB49404_P_NODE_630705_length_154_cov_0.991304_g616904_i0 | PRJEB49404 | 630705 | 154 | 0.991304 | 1.52660816 | Salarchaeum japonicum | 555573 | Archaea | Archaea | 135 | 1.2200000000000002e-27 | NTclustered | gi|2124061129|gb|CP085324.1| | 555573 | g616904 | i0 | 82.692 | 2.93506493506493 | 156 | 23 | 100 | 4 | 1 | 154 | 191326 | 191479 | Salarchaeum japonicum strain JCM 16327 chromosome, complete genome | blastn | 452 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum japonicum | |
| 23067169 | 23067169 | PRJEB49404_P_NODE_592879_length_161_cov_1.008197_g579078_i0 | PRJEB49404 | 592879 | 161 | 1.008197 | 1.62319717 | Natronomonas | 63743 | Archaea | Archaea | 107 | 3.04e-28 | NR | WP_015408170.1 | 416273 | g579078 | i0 | 86.8 | 1.97515527950311 | 53 | 7 | 98.8 | 0 | 3 | 161 | 70 | 122 | WP_015408170.1 Rieske (2Fe-2S) protein [Natronomonas moolapensis] | diamond | 318 | 108 | 0.990740740740741 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 26653388 | 26653388 | PRJEB49404_P_NODE_597381_length_160_cov_1.347107_g583580_i0 | PRJEB49404 | 597381 | 160 | 1.347107 | 2.1553712 | Halorubrum laminariae | 1433523 | Archaea | Archaea | 103 | 1.7599999999999998e-24 | NR | WP_256418948.1 | 1433523 | g583580 | i0 | 96.2 | 0.99375 | 53 | 2 | 99.4 | 0 | 160 | 2 | 59 | 111 | WP_256418948.1 Cdc6/Cdc18 family protein [Halorubrum laminariae] | diamond | 159 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum laminariae | |
| 27191451 | 27191451 | PRJEB49404_P_NODE_651702_length_150_cov_1.405405_g637901_i0 | PRJEB49404 | 651702 | 150 | 1.405405 | 2.1081075 | Halonotius roseus | 2511997 | Archaea | Archaea | 77.4 | 1.93e-16 | NR | WP_142444172.1 | 2511997 | g637901 | i0 | 90.9 | 1.76 | 44 | 4 | 88 | 0 | 18 | 149 | 1 | 44 | WP_142444172.1 universal stress protein [Halonotius roseus] | diamond | 264 | 77.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius roseus | |
| 29875654 | 29875654 | PRJEB49404_P_NODE_430351_length_203_cov_1.000000_g416550_i0 | PRJEB49404 | 430351 | 203 | 1 | 2.03 | Halopenitus sp. H-Gu1 | 3242697 | Archaea | Archaea | 120 | 4.4599999999999996e-32 | NR | WP_373674591.1 | 3242697 | g416550 | i0 | 83.6 | 0.990147783251232 | 67 | 11 | 99 | 0 | 201 | 1 | 117 | 183 | WP_373674591.1 nitrous oxide reductase accessory protein NosL [Halopenitus sp. H-Gu1] | diamond | 201 | 120 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. H-Gu1 | |
| 32720373 | 32720373 | PRJEB49404_P_NODE_625180_length_155_cov_1.025862_g611379_i0 | PRJEB49404 | 625180 | 155 | 1.025862 | 1.5900861 | Natronomonas pharaonis | 2257 | Archaea | Archaea | 65.1 | 1.05e-10 | NR | WP_011323308.1 | 2257 | g611379 | i0 | 81.6 | 2.94193548387097 | 38 | 7 | 73.5 | 0 | 41 | 154 | 1 | 38 | WP_011323308.1 type II methionyl aminopeptidase [Natronomonas pharaonis] | diamond | 456 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas pharaonis |
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);;