contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB75017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961439 | 3961439 | PRJEB75017_P_NODE_14804_length_251_cov_0.876404_g14675_i0 | PRJEB75017 | 14804 | 251 | 0.876404 | 2.19977404 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 213 | 9.86e-51 | NTclustered | gi|1082264851|gb|CP016070.1| | 1873524 | g14675 | i0 | 83.406 | 1.82470119521912 | 229 | 38 | 91 | 0 | 1 | 229 | 1808771 | 1808543 | Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome | blastn | 458 | 213 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 7373109 | 7373109 | PRJEB75017_P_NODE_16226_length_247_cov_0.896552_g16097_i0 | PRJEB75017 | 16226 | 247 | 0.896552 | 2.21448344 | Haloarculaceae | 1963268 | Archaea | Archaea | 95.3 | 3.66e-15 | NTclustered | gi|256689853|gb|CP001687.1| | 519442 | g16097 | i0 | 95 | 0.48582995951417 | 60 | 3 | 24 | 0 | 3 | 62 | 76142 | 76201 | Halorhabdus utahensis DSM 12940, complete genome | blastn | 120 | 95.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorhabdus | Halorhabdus utahensis | |
| 16712037 | 16712037 | PRJEB75017_P_NODE_16934_length_245_cov_1.691860_g16805_i0 | PRJEB75017 | 16934 | 245 | 1.69186 | 4.145057 | Halorientalis litorea | 2931977 | Archaea | Archaea | 448 | 2.41e-121 | NTclustered | gi|2225350820|gb|CP095484.1| | 2931977 | g16805 | i0 | 99.592 | 4.58367346938776 | 245 | 1 | 100 | 0 | 1 | 245 | 103780 | 103536 | Halorientalis litorea strain ZY14 plasmid unnamed2, complete sequence | blastn | 1123 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis litorea | |
| 16712041 | 16712041 | PRJEB75017_P_NODE_17454_length_244_cov_0.912281_g17325_i0 | PRJEB75017 | 17454 | 244 | 0.912281 | 2.22596564 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 357 | 4.16e-94 | NTclustered | gi|2221492587|gb|CP095006.1| | 179637 | g17325 | i0 | 93.033 | 18.75 | 244 | 17 | 100 | 0 | 1 | 244 | 87209 | 87452 | Halococcus dombrowskii strain H4 plasmid unnamed1, complete sequence | blastn | 4575 | 357 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 17573462 | 17573462 | PRJEB75017_P_NODE_10794_length_281_cov_1.418269_g10665_i0 | PRJEB75017 | 10794 | 281 | 1.418269 | 3.98533589 | Haladaptatus | 367188 | Archaea | Archaea | 86.1 | 2.55e-12 | NTclustered | gi|2471356508|gb|CP120470.1| | 3032580 | g10665 | i0 | 82.353 | 2.97864768683274 | 102 | 15 | 36 | 3 | 55 | 155 | 483812 | 483911 | Haladaptatus sp. DYSN1 chromosome, complete genome | blastn | 837 | 86.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYSN1 | |
| 17986898 | 17986898 | PRJEB75017_P_NODE_12995_length_260_cov_1.160428_g12866_i0 | PRJEB75017 | 12995 | 260 | 1.160428 | 3.0171128 | Haladaptatus salinisoli | 2884876 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|2124061132|gb|CP085327.1| | 2884876 | g12866 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 166 | 193 | 669348 | 669375 | Haladaptatus salinisoli strain PSR8 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus salinisoli | |
| 17986908 | 17986908 | PRJEB75017_P_NODE_13855_length_253_cov_0.866667_g13726_i0 | PRJEB75017 | 13855 | 253 | 0.866667 | 2.19266751 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 318 | 2.05e-82 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g13726 | i0 | 89.328 | 4.96837944664032 | 253 | 27 | 100 | 0 | 1 | 253 | 2901233 | 2900981 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 1257 | 318 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 21812120 | 21812120 | PRJEB75017_P_NODE_17178_length_245_cov_0.906977_g17049_i0 | PRJEB75017 | 17178 | 245 | 0.906977 | 2.22209365 | Natronomonas marina | 2961939 | Archaea | Archaea | 309 | 1.19e-79 | NTclustered | gi|2273574514|gb|CP101154.1| | 2961939 | g17049 | i0 | 89.388 | 62.0285714285714 | 245 | 26 | 100 | 0 | 1 | 245 | 2087217 | 2087461 | Natronomonas marina strain ZY43 chromosome, complete genome | blastn | 15197 | 309 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina |
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);;