contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4309526 | 4309526 | PRJNA498309_S_NODE_7224_length_1018_cov_4.959308_g5670_i0 | PRJNA498309 | 7224 | 1018 | 4.959308 | 50.48575544 | Halobaculum litoreum | 3031998 | Archaea | Archaea | 387 | 2.49e-102 | NTclustered | gi|2511735787|gb|CP126156.1| | 3031998 | g5670 | i0 | 78.912 | 19.6630648330059 | 588 | 110 | 57 | 14 | 296 | 876 | 710371 | 709791 | Halobaculum litoreum strain DT92 chromosome, complete genome | blastn | 20017 | 387 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum litoreum | |
| 5586256 | 5586256 | PRJNA498309_S_NODE_49605_length_167_cov_2.136364_g47437_i0 | PRJNA498309 | 49605 | 167 | 2.136364 | 3.56772788 | Halohasta litchfieldiae | 1073996 | Archaea | Archaea | 76.8 | 8.31e-10 | NTclustered | gi|1279136099|gb|CP024845.1| | 1073996 | g47437 | i0 | 88.71 | 0.802395209580838 | 62 | 7 | 37 | 0 | 92 | 153 | 624368 | 624307 | Halohasta litchfieldiae strain tADL chromosome, complete genome | blastn | 134 | 76.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta litchfieldiae | |
| 6859353 | 6859353 | PRJNA498309_S_NODE_10606_length_771_cov_7.559783_g8815_i0 | PRJNA498309 | 10606 | 771 | 7.559783 | 58.28592693 | Halapricum desulfuricans | 2841257 | Archaea | Archaea | 440 | 1.4099999999999996e-118 | NTclustered | gi|1995629645|gb|CP064787.1| | 2841257 | g8815 | i0 | 78.099 | 11.124513618677 | 726 | 138 | 93 | 21 | 21 | 736 | 1892814 | 1893528 | Halapricum desulfuricans strain HSR12-1 chromosome, complete genome | blastn | 8577 | 440 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum desulfuricans | |
| 10683603 | 10683603 | PRJNA498309_P_NODE_100349_length_193_cov_2.064103_g98200_i0 | PRJNA498309 | 100349 | 193 | 2.064103 | 3.98371879 | Halapricum salinum | 1457250 | Archaea | Archaea | 207 | 3.36e-49 | NTclustered | gi|1621078650|gb|CP031310.1| | 1457250 | g98200 | i0 | 86.316 | 5.72538860103627 | 190 | 26 | 98 | 0 | 1 | 190 | 2560010 | 2560199 | Halapricum salinum strain CBA1105 chromosome, complete genome | blastn | 1105 | 207 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum salinum | |
| 14511255 | 14511255 | PRJNA498309_S_NODE_39532_length_216_cov_1.955801_g37364_i0 | PRJNA498309 | 39532 | 216 | 1.955801 | 4.22453016 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 217 | 6.39e-52 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g37364 | i0 | 88.333 | 1.49537037037037 | 180 | 21 | 83 | 0 | 25 | 204 | 2350028 | 2349849 | Halalkalicoccus jeotgali B3, complete genome | blastn | 323 | 217 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 15785142 | 15785142 | PRJNA498309_S_NODE_44853_length_187_cov_1.644737_g42685_i0 | PRJNA498309 | 44853 | 187 | 1.644737 | 3.07565819 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 206 | 1.1599999999999998e-48 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g42685 | i0 | 88.69 | 10.9304812834225 | 168 | 19 | 90 | 0 | 20 | 187 | 2316809 | 2316976 | Halalkalicoccus jeotgali B3, complete genome | blastn | 2044 | 206 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 19608204 | 19608204 | PRJNA498309_S_NODE_32796_length_270_cov_2.957447_g30628_i0 | PRJNA498309 | 32796 | 270 | 2.957447 | 7.9851069 | Natranaeroarchaeum sulfidigenes | 2784880 | Archaea | Archaea | 265 | 2.9199999999999997e-66 | NTclustered | gi|1995626524|gb|CP064786.1| | 2784880 | g30628 | i0 | 85.115 | 72.5407407407407 | 262 | 35 | 96 | 4 | 11 | 270 | 2142596 | 2142337 | Natranaeroarchaeum sulfidigenes strain AArc-S chromosome, complete genome | blastn | 19586 | 265 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Natranaeroarchaeum | Natranaeroarchaeum sulfidigenes | |
| 20884518 | 20884518 | PRJNA498309_S_NODE_46017_length_182_cov_1.326531_g43849_i0 | PRJNA498309 | 46017 | 182 | 1.326531 | 2.41428642 | Salinigranum rubrum | 755307 | Archaea | Archaea | 113 | 7e-21 | NTclustered | gi|1336553312|gb|CP026310.1| | 755307 | g43849 | i0 | 80.667 | 3.20879120879121 | 150 | 25 | 81 | 4 | 3 | 150 | 163031 | 163178 | Salinigranum rubrum strain GX10 plasmid unnamed1, complete sequence | blastn | 584 | 113 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 22158861 | 22158861 | PRJNA498309_S_NODE_31098_length_288_cov_4.343874_g28930_i0 | PRJNA498309 | 31098 | 288 | 4.343874 | 12.51035712 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 303 | 6.66e-78 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g28930 | i0 | 88.98 | 4.24652777777778 | 245 | 27 | 85 | 0 | 19 | 263 | 2023645 | 2023401 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 1223 | 303 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis |
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);;