contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1182301" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 318879 | 318879 | PRJNA1182301_P_NODE_45661_length_254_cov_2.856354_g45536_i0 | PRJNA1182301 | 45661 | 254 | 2.856354 | 7.25513916 | Halomicrococcus gelatinilyticus | 1702103 | Archaea | Archaea | 287 | 5.81e-73 | NTclustered | gi|2270268908|gb|CP100465.1| | 1702103 | g45536 | i0 | 87.251 | 94.0826771653543 | 251 | 32 | 99 | 0 | 1 | 251 | 1692385 | 1692635 | Halomicrococcus gelatinilyticus strain GSLN9 chromosome, complete genome | blastn | 23897 | 287 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halomicrococcus | Halomicrococcus gelatinilyticus | |
| 1593009 | 1593009 | PRJNA1182301_P_NODE_25562_length_281_cov_1.495192_g25437_i0 | PRJNA1182301 | 25562 | 281 | 1.495192 | 4.20148952 | Natrinema versiforme | 88724 | Archaea | Archaea | 508 | 1.28e-139 | NTclustered | gi|1657691899|gb|CP040330.1| | 88724 | g25437 | i0 | 99.288 | 86.0640569395018 | 281 | 2 | 100 | 0 | 1 | 281 | 921428 | 921708 | Natrinema versiforme strain BOL5-4 chromosome, complete genome | blastn | 24184 | 508 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema versiforme | |
| 1593649 | 1593649 | PRJNA1182301_P_NODE_52662_length_248_cov_1.760000_g52537_i0 | PRJNA1182301 | 52662 | 248 | 1.76 | 4.3648 | Halosolutus gelatinilyticus | 2931975 | Archaea | Archaea | 182 | 2.74e-41 | NTclustered | gi|2225350841|gb|CP095491.1| | 2931975 | g52537 | i0 | 85.549 | 29.4838709677419 | 173 | 25 | 70 | 0 | 1 | 173 | 3105684 | 3105856 | Halosolutus gelatinilyticus strain SQT-29-1 chromosome, complete genome | blastn | 7312 | 182 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halosolutus | Halosolutus gelatinilyticus | |
| 1593884 | 1593884 | PRJNA1182301_P_NODE_62762_length_241_cov_1.827381_g62637_i0 | PRJNA1182301 | 62762 | 241 | 1.827381 | 4.40398821 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 267 | 7.12e-67 | NTclustered | gi|933677909|gb|CP011564.1| | 1604004 | g62637 | i0 | 87.179 | 71.0373443983403 | 234 | 30 | 97 | 0 | 8 | 241 | 1393986 | 1393753 | Halanaeroarchaeum sulfurireducens strain M27-SA2, complete genome | blastn | 17120 | 267 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 2869779 | 2869779 | PRJNA1182301_P_NODE_53003_length_248_cov_1.348571_g52878_i0 | PRJNA1182301 | 53003 | 248 | 1.348571 | 3.34445608 | Natronobeatus ordinarius | 2963433 | Archaea | Archaea | 261 | 3.42e-65 | NTclustered | gi|2274417427|gb|CP101456.1| | 2963433 | g52878 | i0 | 86.25 | 10.5564516129032 | 240 | 33 | 97 | 0 | 1 | 240 | 1402179 | 1401940 | Natronobeatus ordinarius strain WLHSJ27 chromosome, complete genome | blastn | 2618 | 261 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobeatus | Natronobeatus ordinarius | |
| 4146115 | 4146115 | PRJNA1182301_P_NODE_63264_length_241_cov_0.916667_g63139_i0 | PRJNA1182301 | 63264 | 241 | 0.916667 | 2.20916747 | Haloarcula halophila | 3032584 | Archaea | Archaea | 97.1 | 9.88e-16 | NTclustered | gi|2461916621|gb|CP119559.1| | 3032584 | g63139 | i0 | 87.209 | 0.356846473029046 | 86 | 10 | 35 | 1 | 16 | 100 | 2335881 | 2335796 | Haloarcula halophila strain DFY41 chromosome, complete genome | blastn | 86 | 97.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula halophila | |
| 5422126 | 5422126 | PRJNA1182301_P_NODE_54545_length_247_cov_0.885057_g54420_i0 | PRJNA1182301 | 54545 | 247 | 0.885057 | 2.18609079 | Halobacterium litoreum | 2039234 | Archaea | Archaea | 316 | 7.17e-82 | NTclustered | gi|2168234898|gb|CP089466.1| | 2039234 | g54420 | i0 | 91.667 | 36.3886639676113 | 228 | 19 | 92 | 0 | 20 | 247 | 572430 | 572657 | Halobacterium litoreum strain ZS-54-S2 chromosome, complete genome | blastn | 8988 | 316 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium litoreum | |
| 9245960 | 9245960 | PRJNA1182301_P_NODE_14868_length_310_cov_2.713080_g14743_i0 | PRJNA1182301 | 14868 | 310 | 2.71308 | 8.410548 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 169 | 2.7599999999999997e-37 | NTclustered | gi|299126090|gb|CP002063.1| | 795797 | g14743 | i0 | 90.551 | 1.22258064516129 | 127 | 12 | 41 | 0 | 1 | 127 | 3110 | 3236 | Halalkalicoccus jeotgali B3 plasmid 1, complete sequence | blastn | 379 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 15069615 | 15069615 | PRJNA1182301_P_NODE_67732_length_226_cov_2.588235_g67607_i0 | PRJNA1182301 | 67732 | 226 | 2.588235 | 5.8494111 | Halobacteriales | 2235 | Archaea | Archaea | 69.4 | 2e-7 | NTclustered | gi|2221492587|gb|CP095006.1| | 179637 | g67607 | i0 | 93.478 | 0.880530973451327 | 46 | 3 | 20 | 0 | 2 | 47 | 200242 | 200287 | Halococcus dombrowskii strain H4 plasmid unnamed1, complete sequence | blastn | 199 | 69.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 23270569 | 23270569 | PRJNA1182301_P_NODE_28039_length_278_cov_1.195122_g27914_i0 | PRJNA1182301 | 28039 | 278 | 1.195122 | 3.32243916 | Halorarum salinum | 2743089 | Archaea | Archaea | 143 | 1.48e-29 | NTclustered | gi|1868921854|gb|CP058579.1| | 2743089 | g27914 | i0 | 76.491 | 2.23741007194245 | 285 | 53 | 100 | 12 | 1 | 278 | 526959 | 527236 | Halorarum salinum strain NJ-3-1 chromosome, complete genome | blastn | 622 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorarum | Halorarum salinum | |
| 24545025 | 24545025 | PRJNA1182301_P_NODE_54940_length_247_cov_0.885057_g54815_i0 | PRJNA1182301 | 54940 | 247 | 0.885057 | 2.18609079 | Halobellus limi | 699433 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|1621075116|gb|CP031311.1| | 699433 | g54815 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 79 | 107 | 2657109 | 2657137 | Halobellus limi strain CGMCC 1.10331 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi |
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);;