contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1022392" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1437218 | 1437218 | PRJNA1022392_P_NODE_66142_length_169_cov_2.926230_g65473_i0 | PRJNA1022392 | 66142 | 169 | 2.92623 | 4.9453287 | Haloarcula taiwanensis | 1932004 | Archaea | Archaea | 110 | 8.26e-20 | NTclustered | gi|1315059818|gb|CP019154.1| | 1932004 | g65473 | i0 | 81.159 | 5.86390532544379 | 138 | 24 | 81 | 2 | 33 | 169 | 707807 | 707671 | Haloarcula taiwanensis strain Taiwanensis chromosome I, complete sequence | blastn | 991 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula taiwanensis | |
| 3989035 | 3989035 | PRJNA1022392_P_NODE_68044_length_167_cov_2.008333_g67375_i0 | PRJNA1022392 | 68044 | 167 | 2.008333 | 3.35391611 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 219 | 1.3099999999999999e-52 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g67375 | i0 | 90.361 | 100.137724550898 | 166 | 16 | 99 | 0 | 2 | 167 | 2317179 | 2317014 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 16723 | 219 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 6540755 | 6540755 | PRJNA1022392_P_NODE_77926_length_159_cov_0.910714_g77257_i0 | PRJNA1022392 | 77926 | 159 | 0.910714 | 1.44803526 | Halosimplex rubrum | 869889 | Archaea | Archaea | 294 | 1.98e-75 | NTclustered | gi|1870062155|gb|CP058910.1| | 869889 | g77257 | i0 | 100 | 12.7358490566038 | 159 | 0 | 100 | 0 | 1 | 159 | 3135524 | 3135682 | Halosimplex rubrum strain R27 chromosome, complete genome | blastn | 2025 | 294 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex rubrum | |
| 9089959 | 9089959 | PRJNA1022392_P_NODE_60628_length_176_cov_2.968992_g59959_i0 | PRJNA1022392 | 60628 | 176 | 2.968992 | 5.22542592 | Natronomonas salina | 1710540 | Archaea | Archaea | 145 | 2.38e-30 | NTclustered | gi|1865519430|gb|CP058335.1| | 1710540 | g59959 | i0 | 88.889 | 4.42045454545455 | 117 | 13 | 66 | 0 | 1 | 117 | 388197 | 388081 | Natronomonas salina strain YPL13 chromosome, complete genome | blastn | 778 | 145 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas salina | |
| 9089963 | 9089963 | PRJNA1022392_P_NODE_61008_length_176_cov_1.480620_g60339_i0 | PRJNA1022392 | 61008 | 176 | 1.48062 | 2.6058912 | Haloquadratum walsbyi | 293091 | Archaea | Archaea | 193 | 8.39e-45 | NTclustered | gi|109624723|emb|AM180088.1| | 362976 | g60339 | i0 | 91.429 | 1.05113636363636 | 140 | 12 | 80 | 0 | 37 | 176 | 2945501 | 2945640 | Haloquadratum walsbyi DSM 16790 complete genome | blastn | 185 | 193 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloquadratum | Haloquadratum walsbyi | |
| 9090059 | 9090059 | PRJNA1022392_P_NODE_69568_length_165_cov_2.542373_g68899_i0 | PRJNA1022392 | 69568 | 165 | 2.542373 | 4.19491545 | Natronomonas marina | 2961939 | Archaea | Archaea | 178 | 2.18e-40 | NTclustered | gi|2273574514|gb|CP101154.1| | 2961939 | g68899 | i0 | 87.261 | 0.951515151515152 | 157 | 18 | 95 | 2 | 10 | 165 | 924296 | 924451 | Natronomonas marina strain ZY43 chromosome, complete genome | blastn | 157 | 178 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 9090118 | 9090118 | PRJNA1022392_P_NODE_74748_length_161_cov_2.131579_g74079_i0 | PRJNA1022392 | 74748 | 161 | 2.131579 | 3.43184219 | Natronomonas marina | 2961939 | Archaea | Archaea | 111 | 2.18e-20 | NTclustered | gi|2273574514|gb|CP101154.1| | 2961939 | g74079 | i0 | 87.629 | 0.602484472049689 | 97 | 10 | 60 | 2 | 66 | 161 | 581112 | 581207 | Natronomonas marina strain ZY43 chromosome, complete genome | blastn | 97 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 10365720 | 10365720 | PRJNA1022392_P_NODE_70369_length_165_cov_0.864407_g69700_i0 | PRJNA1022392 | 70369 | 165 | 0.864407 | 1.42627155 | Salinirarus marinus | 3068310 | Archaea | Archaea | 226 | 7.679999999999999e-55 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g69700 | i0 | 91.463 | 24.2242424242424 | 164 | 14 | 99 | 0 | 2 | 165 | 717620 | 717783 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 3997 | 226 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 11640983 | 11640983 | PRJNA1022392_P_NODE_60170_length_177_cov_1.569231_g59501_i0 | PRJNA1022392 | 60170 | 177 | 1.569231 | 2.77753887 | Salinirubellus litoreus | 3131999 | Archaea | Archaea | 86.1 | 1.47e-12 | NTclustered | gi|2700494409|gb|CP147841.1| | 3131999 | g59501 | i0 | 86.25 | 1.63841807909605 | 80 | 9 | 45 | 2 | 99 | 177 | 3486961 | 3486883 | Salinirubellus litoreus strain SYNS196 chromosome, complete genome | blastn | 290 | 86.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus litoreus | |
| 11641057 | 11641057 | PRJNA1022392_P_NODE_67090_length_168_cov_2.404959_g66421_i0 | PRJNA1022392 | 67090 | 168 | 2.404959 | 4.04033112 | Salarchaeum japonicum | 555573 | Archaea | Archaea | 156 | 1.05e-33 | NTclustered | gi|2124061129|gb|CP085324.1| | 555573 | g66421 | i0 | 83.529 | 1.01190476190476 | 170 | 24 | 100 | 4 | 1 | 168 | 723679 | 723846 | Salarchaeum japonicum strain JCM 16327 chromosome, complete genome | blastn | 170 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum japonicum | |
| 18014246 | 18014246 | PRJNA1022392_P_NODE_61475_length_175_cov_2.648438_g60806_i0 | PRJNA1022392 | 61475 | 175 | 2.648438 | 4.6347665 | Halohasta litchfieldiae | 1073996 | Archaea | Archaea | 97.1 | 6.72e-16 | NTclustered | gi|1279136099|gb|CP024845.1| | 1073996 | g60806 | i0 | 81.301 | 6.82285714285714 | 123 | 19 | 69 | 4 | 47 | 167 | 2905469 | 2905349 | Halohasta litchfieldiae strain tADL chromosome, complete genome | blastn | 1194 | 97.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta litchfieldiae | |
| 19288029 | 19288029 | PRJNA1022392_P_NODE_56096_length_182_cov_2.540741_g55427_i0 | PRJNA1022392 | 56096 | 182 | 2.540741 | 4.62414862 | Haloferax volcanii | 2246 | Archaea | Archaea | 165 | 1.91e-36 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g55427 | i0 | 82.967 | 23.3736263736264 | 182 | 31 | 100 | 0 | 1 | 182 | 2006469 | 2006650 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 4254 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 21838881 | 21838881 | PRJNA1022392_P_NODE_31738_length_206_cov_3.125786_g31069_i0 | PRJNA1022392 | 31738 | 206 | 3.125786 | 6.43911916 | Halorarum halophilum | 2743090 | Archaea | Archaea | 67.6 | 6.43e-7 | NTclustered | gi|1868817999|gb|CP058529.1| | 2743090 | g31069 | i0 | 91.667 | 0.233009708737864 | 48 | 4 | 23 | 0 | 50 | 97 | 718067 | 718020 | Halorarum halophilum strain Gai3-2 chromosome, complete genome | blastn | 48 | 67.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorarum | Halorarum halophilum | |
| 21839386 | 21839386 | PRJNA1022392_P_NODE_72798_length_163_cov_0.879310_g72129_i0 | PRJNA1022392 | 72798 | 163 | 0.87931 | 1.4332753 | Halobaculum magnesiiphilum | 1017351 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|2087953847|gb|CP081958.1| | 1017351 | g72129 | i0 | 100 | 0.184049079754601 | 30 | 0 | 18 | 0 | 1 | 30 | 1867946 | 1867975 | Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum magnesiiphilum | |
| 23114287 | 23114287 | PRJNA1022392_P_NODE_31659_length_206_cov_3.144654_g30990_i0 | PRJNA1022392 | 31659 | 206 | 3.144654 | 6.47798724 | Halobacterium sp. NMX12-1 | 3166650 | Archaea | Archaea | 126 | 1.05e-24 | NTclustered | gi|2752251234|gb|CP159204.1| | 3166650 | g30990 | i0 | 89.899 | 33.9077669902913 | 99 | 8 | 48 | 2 | 1 | 98 | 12262 | 12359 | Halobacterium sp. NMX12-1 chromosome, complete genome | blastn | 6985 | 126 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. NMX12-1 | |
| 23114598 | 23114598 | PRJNA1022392_P_NODE_55159_length_183_cov_3.654412_g54490_i0 | PRJNA1022392 | 55159 | 183 | 3.654412 | 6.68757396 | Halorussus vallis | 2953749 | Archaea | Archaea | 267 | 5.109999999999999e-67 | NTclustered | gi|2263966384|gb|CP100000.1| | 2953749 | g54490 | i0 | 92.896 | 99.1475409836066 | 183 | 13 | 100 | 0 | 1 | 183 | 3650513 | 3650695 | Halorussus vallis strain XZYJT10 chromosome, complete genome | blastn | 18144 | 267 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 24388126 | 24388126 | PRJNA1022392_P_NODE_32320_length_206_cov_2.981132_g31651_i0 | PRJNA1022392 | 32320 | 206 | 2.981132 | 6.14113192 | Salinirarus marinus | 3068310 | Archaea | Archaea | 102 | 1.76e-17 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g31651 | i0 | 85.714 | 1.21844660194175 | 98 | 12 | 47 | 2 | 1 | 97 | 2328813 | 2328717 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 251 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus |
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);;