contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1078934 | 1078934 | PRJNA395690_P_NODE_10481_length_252_cov_0.990148_g10329_i0 | PRJNA395690 | 10481 | 252 | 0.990148 | 2.49517296 | Halorubrum | 56688 | Archaea | Archaea | 82.4 | 2.9099999999999998e-11 | NTclustered | gi|1565814486|gb|CP034940.1| | 337243 | g10329 | i0 | 85.897 | 0.619047619047619 | 78 | 9 | 31 | 2 | 1 | 77 | 1588073 | 1588149 | Halorubrum ezzemoulense strain Fb21 chromosome, complete genome | blastn | 156 | 82.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum ezzemoulense | |
| 4238742 | 4238742 | PRJNA395690_P_NODE_27544_length_168_cov_2.176471_g27392_i0 | PRJNA395690 | 27544 | 168 | 2.176471 | 3.65647128 | Halorubrum salinarum | 2739057 | Archaea | Archaea | 183 | 4.8e-42 | NTclustered | gi|1848526000|gb|CP053941.1| | 2739057 | g27392 | i0 | 91.667 | 19.3035714285714 | 132 | 11 | 79 | 0 | 35 | 166 | 2095155 | 2095024 | Halorubrum salinarum strain RHB-C chromosome, complete genome | blastn | 3243 | 183 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 6182058 | 6182058 | PRJNA395690_P_NODE_22765_length_180_cov_1.465649_g22613_i0 | PRJNA395690 | 22765 | 180 | 1.465649 | 2.6381682 | Natronosalvus | 3076685 | Archaea | Archaea | 226 | 8.5e-55 | NTclustered | gi|1804090075|gb|CP048032.1| | 1071085 | g22613 | i0 | 89.773 | 96.4666666666667 | 176 | 18 | 98 | 0 | 1 | 176 | 402285 | 402460 | Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome | blastn | 17364 | 226 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | haloarchaeon 3A1-DGR | |||
| 8065118 | 8065118 | PRJNA395690_P_NODE_37187_length_153_cov_2.298077_g37034_i0 | PRJNA395690 | 37187 | 153 | 2.298077 | 3.51605781 | Halorubrum trapanicum | 29284 | Archaea | Archaea | 272 | 8.84e-69 | NTclustered | gi|1041620905|dbj|AP017571.1| | 29284 | g37034 | i0 | 98.693 | 1 | 153 | 2 | 100 | 0 | 1 | 153 | 9436 | 9284 | Halorubrum trapanicum plasmid pCBA1232-02 DNA, complete genome, strain: CBA1232 | blastn | 153 | 272 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 8731790 | 8731790 | PRJNA395690_P_NODE_28547_length_167_cov_0.864407_g28395_i0 | PRJNA395690 | 28547 | 167 | 0.864407 | 1.44355969 | Halobacteriales | 2235 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|1196598842|gb|CP019893.1| | 745377 | g28395 | i0 | 100 | 0.335329341317365 | 28 | 0 | 17 | 0 | 32 | 59 | 539707 | 539680 | Natrarchaeobaculum aegyptiacum strain JW/NM-HA 15 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrarchaeobaculum | Natrarchaeobaculum aegyptiacum | |
| 11890435 | 11890435 | PRJNA395690_P_NODE_21130_length_184_cov_1.266667_g20978_i0 | PRJNA395690 | 21130 | 184 | 1.266667 | 2.33066728 | Halobaculum magnesiiphilum | 1017351 | Archaea | Archaea | 261 | 2.39e-65 | NTclustered | gi|2087953847|gb|CP081958.1| | 1017351 | g20978 | i0 | 92.35 | 100.619565217391 | 183 | 14 | 99 | 0 | 2 | 184 | 1742894 | 1742712 | Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome | blastn | 18514 | 261 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum magnesiiphilum | |
| 13165460 | 13165460 | PRJNA395690_P_NODE_30131_length_166_cov_0.871795_g29979_i0 | PRJNA395690 | 30131 | 166 | 0.871795 | 1.4471797 | Halosimplex rubrum | 869889 | Archaea | Archaea | 119 | 1.35e-22 | NTclustered | gi|1870062155|gb|CP058910.1| | 869889 | g29979 | i0 | 80.921 | 2.75301204819277 | 152 | 27 | 91 | 2 | 1 | 151 | 2690743 | 2690893 | Halosimplex rubrum strain R27 chromosome, complete genome | blastn | 457 | 119 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex rubrum | |
| 18930513 | 18930513 | PRJNA395690_P_NODE_30035_length_166_cov_0.871795_g29883_i0 | PRJNA395690 | 30035 | 166 | 0.871795 | 1.4471797 | Natronomonadaceae | 3402413 | Archaea | Archaea | 222 | 1e-53 | NTclustered | gi|2273574516|gb|CP101155.1| | 2961939 | g29883 | i0 | 91.358 | 1.95180722891566 | 162 | 14 | 98 | 0 | 1 | 162 | 141021 | 141182 | Natronomonas marina strain ZY43 plasmid unnamed1, complete sequence | blastn | 324 | 222 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 20205181 | 20205181 | PRJNA395690_P_NODE_25016_length_174_cov_3.176000_g24864_i0 | PRJNA395690 | 25016 | 174 | 3.176 | 5.52624 | Haloferacaceae | 1644056 | Archaea | Archaea | 163 | 6.480000000000001e-36 | NTclustered | gi|1041620700|dbj|AP017569.1| | 29284 | g24864 | i0 | 94.393 | 56.7298850574713 | 107 | 5 | 61 | 1 | 69 | 174 | 348670 | 348564 | Halorubrum trapanicum DNA, complete genome, strain: CBA1232 | blastn | 9871 | 163 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 22088155 | 22088155 | PRJNA395690_P_NODE_26698_length_170_cov_2.694215_g26546_i0 | PRJNA395690 | 26698 | 170 | 2.694215 | 4.5801655 | Halorubrum sp. PV6 | 634157 | Archaea | Archaea | 226 | 7.919999999999998e-55 | NTclustered | gi|1540603140|gb|CP030064.1| | 634157 | g26546 | i0 | 90.588 | 27.8294117647059 | 170 | 16 | 100 | 0 | 1 | 170 | 393947 | 393778 | Halorubrum sp. PV6 chromosome, complete genome | blastn | 4731 | 226 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. PV6 | |
| 24030675 | 24030675 | PRJNA395690_P_NODE_16599_length_199_cov_2.626667_g16447_i0 | PRJNA395690 | 16599 | 199 | 2.626667 | 5.22706733 | Halobacteriales | 2235 | Archaea | Archaea | 363 | 7.019999999999998e-96 | NTclustered | gi|1236765549|gb|MF425611.1| | 29286 | g16447 | i0 | 99.497 | 99.9597989949749 | 199 | 1 | 100 | 0 | 1 | 199 | 269 | 71 | Halococcus sp. strain GUGFAWS3 16S ribosomal RNA gene, partial sequence | blastn | 19892 | 363 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 25305229 | 25305229 | PRJNA395690_P_NODE_35420_length_161_cov_1.553571_g35268_i0 | PRJNA395690 | 35420 | 161 | 1.553571 | 2.50124931 | Halobacteriales | 2235 | Archaea | Archaea | 298 | 1.56e-76 | NTclustered | gi|2124061130|gb|CP085325.1| | 555573 | g35268 | i0 | 100 | 9.19254658385093 | 161 | 0 | 100 | 0 | 1 | 161 | 87275 | 87115 | Salarchaeum japonicum strain JCM 16327 plasmid unnamed1, complete sequence | blastn | 1480 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum japonicum |
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);;