contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1111146" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 216593 | 216593 | PRJNA1111146_P_NODE_377201_length_180_cov_1.795276_g376063_i0 | PRJNA1111146 | 377201 | 180 | 1.795276 | 3.2314968 | Halorubrum sp. CBA1229 | 1853699 | Archaea | Archaea | 316 | 4.899999999999999e-82 | NTclustered | gi|1861361976|gb|CP054586.1| | 1853699 | g376063 | i0 | 98.333 | 37.8055555555556 | 180 | 3 | 100 | 0 | 1 | 180 | 94457 | 94278 | Halorubrum sp. CBA1229 plasmid pCBA1229, complete sequence | blastn | 6805 | 316 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CBA1229 | |
| 1491190 | 1491190 | PRJNA1111146_P_NODE_351162_length_182_cov_0.883721_g350024_i0 | PRJNA1111146 | 351162 | 182 | 0.883721 | 1.60837222 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 106 | 1.17e-18 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g350024 | i0 | 100 | 7.82967032967033 | 57 | 0 | 31 | 0 | 2 | 58 | 2818090 | 2818034 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 1425 | 106 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 4042622 | 4042622 | PRJNA1111146_P_NODE_183504_length_210_cov_1.076433_g182366_i0 | PRJNA1111146 | 183504 | 210 | 1.076433 | 2.2605093 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 331 | 2.11e-86 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g182366 | i0 | 95.631 | 163.666666666667 | 206 | 9 | 98 | 0 | 1 | 206 | 3202433 | 3202228 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 34370 | 331 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 4043739 | 4043739 | PRJNA1111146_P_NODE_433484_length_177_cov_0.919355_g432346_i0 | PRJNA1111146 | 433484 | 177 | 0.919355 | 1.62725835 | Natrinema zhouii | 1710539 | Archaea | Archaea | 80.5 | 6.86e-11 | NTclustered | gi|2118780553|gb|CP084884.1| | 1710539 | g432346 | i0 | 94.231 | 4.31638418079096 | 52 | 3 | 29 | 0 | 2 | 53 | 54801 | 54852 | Natrinema zhouii strain YPL30 plasmid unnamed3, complete sequence | blastn | 764 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema zhouii | |
| 6594908 | 6594908 | PRJNA1111146_P_NODE_405926_length_179_cov_0.888889_g404788_i0 | PRJNA1111146 | 405926 | 179 | 0.888889 | 1.59111131 | Halorarius halobius | 2962671 | Archaea | Archaea | 169 | 1.4399999999999998e-37 | NTclustered | gi|2273560677|gb|CP101164.1| | 2962671 | g404788 | i0 | 97.03 | 1.63128491620112 | 101 | 2 | 56 | 1 | 80 | 179 | 48790 | 48690 | Halorarius halobius strain ZY10 plasmid unnamed3, complete sequence | blastn | 292 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halorarius | Halorarius halobius | |
| 7868257 | 7868257 | PRJNA1111146_P_NODE_100467_length_243_cov_1.200000_g99329_i0 | PRJNA1111146 | 100467 | 243 | 1.2 | 2.916 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 176 | 1.25e-39 | NTclustered | gi|1082264851|gb|CP016070.1| | 1873524 | g99329 | i0 | 81.69 | 1.75308641975309 | 213 | 37 | 87 | 2 | 22 | 233 | 984779 | 984990 | Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome | blastn | 426 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 11695151 | 11695151 | PRJNA1111146_P_NODE_331130_length_183_cov_1.753846_g329992_i0 | PRJNA1111146 | 331130 | 183 | 1.753846 | 3.20953818 | Natronomonas gomsonensis | 1046043 | Archaea | Archaea | 220 | 4.04e-53 | NTclustered | gi|2273673091|gb|CP101324.1| | 1046043 | g329992 | i0 | 100 | 10.3934426229508 | 119 | 0 | 65 | 0 | 1 | 119 | 97716 | 97834 | Natronomonas gomsonensis strain KCTC 4088 plasmid unnamed1, complete sequence | blastn | 1902 | 220 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas gomsonensis | |
| 12970398 | 12970398 | PRJNA1111146_P_NODE_353571_length_182_cov_0.883721_g352433_i0 | PRJNA1111146 | 353571 | 182 | 0.883721 | 1.60837222 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 263 | 6.57e-66 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g352433 | i0 | 93.258 | 11.6813186813187 | 178 | 12 | 98 | 0 | 3 | 180 | 824286 | 824109 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 2126 | 263 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 16792936 | 16792936 | PRJNA1111146_P_NODE_177314_length_211_cov_1.981013_g176176_i0 | PRJNA1111146 | 177314 | 211 | 1.981013 | 4.17993743 | Halovivax cerinus | 1487865 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|2279709464|gb|CP101824.1| | 1487865 | g176176 | i0 | 100 | 0.137440758293839 | 29 | 0 | 14 | 0 | 43 | 71 | 1611361 | 1611389 | Halovivax cerinus strain IBRC-M 10256 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovivax | Halovivax cerinus | |
| 16793506 | 16793506 | PRJNA1111146_P_NODE_315094_length_185_cov_0.863636_g313956_i0 | PRJNA1111146 | 315094 | 185 | 0.863636 | 1.5977266 | Salarchaeum sp. JOR-1 | 2599399 | Archaea | Archaea | 228 | 2.4499999999999995e-55 | NTclustered | gi|1717336197|gb|CP042241.1| | 2599399 | g313956 | i0 | 90.23 | 4.72972972972973 | 174 | 17 | 94 | 0 | 3 | 176 | 1734737 | 1734910 | Salarchaeum sp. JOR-1 chromosome, complete genome | blastn | 875 | 228 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum sp. JOR-1 | |
| 16793967 | 16793967 | PRJNA1111146_P_NODE_417134_length_178_cov_0.912000_g415996_i0 | PRJNA1111146 | 417134 | 178 | 0.912 | 1.62336 | Halapricum desulfuricans | 2841257 | Archaea | Archaea | 209 | 8.44e-50 | NTclustered | gi|1995638849|gb|CP064791.1| | 2841257 | g415996 | i0 | 89.634 | 3.78651685393258 | 164 | 17 | 92 | 0 | 13 | 176 | 1301243 | 1301080 | Halapricum desulfuricans strain HSR-Est chromosome, complete genome | blastn | 674 | 209 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum desulfuricans | |
| 18068103 | 18068103 | PRJNA1111146_P_NODE_339495_length_183_cov_0.876923_g338357_i0 | PRJNA1111146 | 339495 | 183 | 0.876923 | 1.60476909 | Haloarcula litorea | 3032579 | Archaea | Archaea | 117 | 5.45e-22 | NTclustered | gi|2463595526|gb|CP119779.1| | 3032579 | g338357 | i0 | 89.247 | 0.508196721311475 | 93 | 10 | 51 | 0 | 4 | 96 | 2177566 | 2177474 | Haloarcula litorea strain GDY20 chromosome, complete genome | blastn | 93 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula litorea | |
| 18068345 | 18068345 | PRJNA1111146_P_NODE_390255_length_180_cov_0.881890_g389117_i0 | PRJNA1111146 | 390255 | 180 | 0.88189 | 1.587402 | Halobacterium noricense | 223182 | Archaea | Archaea | 189 | 1.1199999999999996e-43 | NTclustered | gi|2168244610|gb|CP089468.1| | 223182 | g389117 | i0 | 85.955 | 0.988888888888889 | 178 | 24 | 99 | 1 | 1 | 178 | 948970 | 949146 | Halobacterium noricense strain JCM 15102 chromosome, complete genome | blastn | 178 | 189 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium noricense | |
| 21893365 | 21893365 | PRJNA1111146_P_NODE_366178_length_181_cov_0.890625_g365040_i0 | PRJNA1111146 | 366178 | 181 | 0.890625 | 1.61203125 | Salinirarus marinus | 3068310 | Archaea | Archaea | 291 | 2.9899999999999993e-74 | NTclustered | gi|2563036161|gb|CP132293.1| | 3068310 | g365040 | i0 | 97.633 | 65.878453038674 | 169 | 4 | 93 | 0 | 6 | 174 | 97125 | 97293 | Haloferacaceae archaeon XH8 plasmid unnamed, complete sequence | blastn | 11924 | 291 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 23168155 | 23168155 | PRJNA1111146_P_NODE_194059_length_207_cov_2.064935_g192921_i0 | PRJNA1111146 | 194059 | 207 | 2.064935 | 4.27441545 | Halorubrum sp. CBA1229 | 1853699 | Archaea | Archaea | 198 | 2.2e-46 | NTclustered | gi|1861358827|gb|CP054585.1| | 1853699 | g192921 | i0 | 83.981 | 0.995169082125604 | 206 | 33 | 99 | 0 | 1 | 206 | 2141384 | 2141589 | Halorubrum sp. CBA1229 chromosome, complete genome | blastn | 206 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CBA1229 |
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);;