contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838714 | 838714 | PRJNA849822_P_NODE_42661_length_242_cov_1.846154_g42487_i0 | PRJNA849822 | 42661 | 242 | 1.846154 | 4.46769268 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 377 | 3.17e-100 | NTclustered | gi|1082264851|gb|CP016070.1| | 1873524 | g42487 | i0 | 96.903 | 3.93388429752066 | 226 | 5 | 93 | 2 | 17 | 242 | 517544 | 517767 | Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome | blastn | 952 | 377 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 4667169 | 4667169 | PRJNA849822_P_NODE_40884_length_244_cov_1.824561_g40710_i0 | PRJNA849822 | 40884 | 244 | 1.824561 | 4.45192884 | Halobacterium sp. GSL-19 | 2812551 | Archaea | Archaea | 355 | 1.5e-93 | NTclustered | gi|1992388976|gb|CP070376.1| | 2812551 | g40710 | i0 | 93.004 | 1.99590163934426 | 243 | 17 | 99 | 0 | 1 | 243 | 35717 | 35959 | Halobacterium sp. GSL-19 plasmid pGSL19_54.9, complete sequence | blastn | 487 | 355 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. GSL-19 | |
| 5061563 | 5061563 | PRJNA849822_P_NODE_36004_length_250_cov_0.881356_g35830_i0 | PRJNA849822 | 36004 | 250 | 0.881356 | 2.20339 | Halobacteriales | 2235 | Archaea | Archaea | 171 | 5.99e-38 | NTclustered | gi|1995635729|gb|CP064789.1| | 2841257 | g35830 | i0 | 84.706 | 11.636 | 170 | 26 | 68 | 0 | 81 | 250 | 1126596 | 1126427 | Halapricum desulfuricans strain HSR-Bgl chromosome, complete genome | blastn | 2909 | 171 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum desulfuricans | |
| 7216785 | 7216785 | PRJNA849822_P_NODE_33426_length_253_cov_0.866667_g33252_i0 | PRJNA849822 | 33426 | 253 | 0.866667 | 2.19266751 | Halobacterium sp. DL1 | 751944 | Archaea | Archaea | 220 | 5.95e-53 | NTclustered | gi|573484043|gb|CP007060.1| | 751944 | g33252 | i0 | 82.661 | 8.53359683794466 | 248 | 43 | 98 | 0 | 1 | 248 | 8023 | 7776 | Halobacterium sp. DL1, complete genome | blastn | 2159 | 220 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. DL1 | |
| 8491526 | 8491526 | PRJNA849822_P_NODE_35307_length_251_cov_0.876404_g35133_i0 | PRJNA849822 | 35307 | 251 | 0.876404 | 2.19977404 | Halohasta litchfieldiae | 1073996 | Archaea | Archaea | 150 | 7.84e-32 | NTclustered | gi|1279136099|gb|CP024845.1| | 1073996 | g35133 | i0 | 85.915 | 1.74103585657371 | 142 | 18 | 56 | 2 | 88 | 228 | 71468 | 71328 | Halohasta litchfieldiae strain tADL chromosome, complete genome | blastn | 437 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta litchfieldiae | |
| 12713100 | 12713100 | PRJNA849822_P_NODE_30110_length_266_cov_1.616580_g29936_i0 | PRJNA849822 | 30110 | 266 | 1.61658 | 4.3001028 | Natronomonadaceae | 3402413 | Archaea | Archaea | 486 | 5.629999999999999e-133 | NTclustered | gi|2273574516|gb|CP101155.1| | 2961939 | g29936 | i0 | 99.624 | 3 | 266 | 1 | 100 | 0 | 1 | 266 | 145392 | 145127 | Natronomonas marina strain ZY43 plasmid unnamed1, complete sequence | blastn | 798 | 486 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 12713104 | 12713104 | PRJNA849822_P_NODE_32530_length_256_cov_1.704918_g32356_i0 | PRJNA849822 | 32530 | 256 | 1.704918 | 4.36459008 | Haloplanus | 376170 | Archaea | Archaea | 204 | 6.07e-48 | NTclustered | gi|1785199060|gb|CP034345.1| | 1816183 | g32356 | i0 | 81.526 | 1.95703125 | 249 | 44 | 97 | 2 | 7 | 254 | 103842 | 103595 | Haloplanus rallus strain MBLA0036 chromosome, complete genome | blastn | 501 | 204 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rallus | |
| 13592311 | 13592311 | PRJNA849822_P_NODE_26411_length_283_cov_1.485714_g26237_i0 | PRJNA849822 | 26411 | 283 | 1.485714 | 4.20457062 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 198 | 3.1699999999999993e-46 | NTclustered | gi|1082264851|gb|CP016070.1| | 1873524 | g26237 | i0 | 79.72 | 15.434628975265 | 286 | 49 | 100 | 6 | 1 | 283 | 28295 | 28016 | Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome | blastn | 4368 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 19965119 | 19965119 | PRJNA849822_P_NODE_35616_length_251_cov_0.876404_g35442_i0 | PRJNA849822 | 35616 | 251 | 0.876404 | 2.19977404 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 292 | 1.2299999999999999e-74 | NTclustered | gi|2295222443|gb|CP087724.1| | 2866382 | g35442 | i0 | 87.698 | 79.0756972111554 | 252 | 29 | 100 | 2 | 1 | 251 | 231294 | 231044 | Halanaeroarchaeum sp. HSR-CO chromosome, complete genome | blastn | 19848 | 292 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO | |
| 22911125 | 22911125 | PRJNA849822_P_NODE_29238_length_270_cov_1.492386_g29064_i0 | PRJNA849822 | 29238 | 270 | 1.492386 | 4.0294422 | Methanosarcina | 2207 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|827396966|gb|CP008746.1| | 796385 | g29064 | i0 | 100 | 0.52962962962963 | 28 | 0 | 10 | 0 | 235 | 262 | 1595783 | 1595810 | Methanosarcina barkeri CM1, complete genome | blastn | 143 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 23790920 | 23790920 | PRJNA849822_P_NODE_34299_length_252_cov_0.871508_g34125_i0 | PRJNA849822 | 34299 | 252 | 0.871508 | 2.19620016 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 292 | 1.24e-74 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g34125 | i0 | 87.649 | 29.218253968254 | 251 | 31 | 99 | 0 | 1 | 251 | 936546 | 936296 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 7363 | 292 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 23790959 | 23790959 | PRJNA849822_P_NODE_39899_length_246_cov_0.901734_g39725_i0 | PRJNA849822 | 39899 | 246 | 0.901734 | 2.21826564 | Halolamina sp. CBA1230 | 1853690 | Archaea | Archaea | 449 | 6.74e-122 | NTclustered | gi|1861365533|gb|CP054589.1| | 1853690 | g39725 | i0 | 99.593 | 7.5650406504065 | 246 | 1 | 100 | 0 | 1 | 246 | 120279 | 120034 | Halolamina sp. CBA1230 plasmid pCBA1230-02, complete sequence | blastn | 1861 | 449 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. CBA1230 |
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);;