contig_metadata
12 rows where bioproject = "PRJNA703759" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3736700 | 3736700 | PRJNA703759_P_NODE_38723_length_250_cov_0.881356_g38247_i0 | PRJNA703759 | 38723 | 250 | 0.881356 | 2.20339 | Haladaptatus | 367188 | Archaea | Archaea | 108 | 4.76e-19 | NTclustered | gi|2471356508|gb|CP120470.1| | 3032580 | g38247 | i0 | 82.927 | 1.916 | 123 | 18 | 49 | 1 | 1 | 123 | 292142 | 292023 | Haladaptatus sp. DYSN1 chromosome, complete genome | blastn | 479 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYSN1 | |
| 4512388 | 4512388 | PRJNA703759_P_NODE_26584_length_279_cov_1.058252_g26108_i0 | PRJNA703759 | 26584 | 279 | 1.058252 | 2.95252308 | Methanococcus maripaludis | 39152 | Archaea | Archaea | 58.4 | 5.52e-4 | NTclustered | gi|1342459100|gb|CP026606.1| | 39152 | g26108 | i0 | 94.737 | 0.136200716845878 | 38 | 1 | 14 | 1 | 101 | 138 | 324531 | 324495 | Methanococcus maripaludis strain DSM 2067 chromosome, complete genome | blastn | 38 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 19036724 | 19036724 | PRJNA703759_P_NODE_35875_length_252_cov_0.871508_g35399_i0 | PRJNA703759 | 35875 | 252 | 0.871508 | 2.19620016 | Haladaptatus | 367188 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2471356512|gb|CP120472.1| | 3032580 | g35399 | i0 | 100 | 0.333333333333333 | 28 | 0 | 11 | 0 | 215 | 242 | 499684 | 499711 | Haladaptatus sp. DYSN1 plasmid unnamed2, complete sequence | blastn | 84 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYSN1 | |
| 19811503 | 19811503 | PRJNA703759_P_NODE_39976_length_249_cov_0.886364_g39500_i0 | PRJNA703759 | 39976 | 249 | 0.886364 | 2.20704636 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g39500 | i0 | 96.875 | 0.1285140562249 | 32 | 0 | 12 | 1 | 2 | 32 | 2173963 | 2173994 | Halalkalicoccus jeotgali B3, complete genome | blastn | 32 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 22361456 | 22361456 | PRJNA703759_P_NODE_24178_length_288_cov_1.418605_g23702_i0 | PRJNA703759 | 24178 | 288 | 1.418605 | 4.0855824 | Methanobacterium sp. ACI-7 | 3240853 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|2904246484|gb|CP166866.1| | 3240853 | g23702 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 181 | 208 | 1982143 | 1982170 | Methanobacterium sp. ACI-7 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ACI-7 | |
| 22361850 | 22361850 | PRJNA703759_P_NODE_40878_length_249_cov_0.886364_g40402_i0 | PRJNA703759 | 40878 | 249 | 0.886364 | 2.20704636 | Haloplanus sp. GX21 | 3127120 | Archaea | Archaea | 263 | 9.56e-66 | NTclustered | gi|2700851762|gb|CP147874.1| | 3127120 | g40402 | i0 | 90.547 | 3.49397590361446 | 201 | 16 | 80 | 3 | 52 | 249 | 650801 | 650601 | Haloplanus sp. GX21 chromosome, complete genome | blastn | 870 | 263 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. GX21 | |
| 23637131 | 23637131 | PRJNA703759_P_NODE_24979_length_285_cov_1.396226_g24503_i0 | PRJNA703759 | 24979 | 285 | 1.396226 | 3.9792441 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 222 | 1.9e-53 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g24503 | i0 | 80.836 | 1.00701754385965 | 287 | 51 | 100 | 4 | 1 | 285 | 1842812 | 1843096 | Halalkalicoccus jeotgali B3, complete genome | blastn | 287 | 222 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 27304183 | 27304183 | PRJNA703759_P_NODE_33943_length_254_cov_1.292818_g33467_i0 | PRJNA703759 | 33943 | 254 | 1.292818 | 3.28375772 | Natrinema pallidum | 69527 | Archaea | Archaea | 40 | 0.0358 | NR | WP_152422535.1 | 69527 | g33467 | i0 | 65.2 | 0.271653543307087 | 23 | 8 | 27.2 | 0 | 186 | 254 | 6 | 28 | WP_152422535.1 hypothetical protein [Natrinema pallidum] | diamond | 69 | 40 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema pallidum | |
| 27588426 | 27588426 | PRJNA703759_P_NODE_32244_length_259_cov_1.645161_g31768_i0 | PRJNA703759 | 32244 | 259 | 1.645161 | 4.26096699 | Haladaptatus sp. DYF46 | 2886041 | Archaea | Archaea | 43.5 | 0.0225 | NR | WP_303646666.1 | 2886041 | g31768 | i0 | 64.7 | 0.393822393822394 | 34 | 11 | 39.4 | 1 | 248 | 147 | 317 | 349 | WP_303646666.1 non-hydrolyzing UDP-N-acetylglucosamine 2-epimerase [Haladaptatus sp. DYF46] | diamond | 102 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYF46 | |
| 28693622 | 28693622 | PRJNA703759_P_NODE_40527_length_249_cov_0.886364_g40051_i0 | PRJNA703759 | 40527 | 249 | 0.886364 | 2.20704636 | Halobacterium sp. KA-4 | 2896367 | Archaea | Archaea | 54.7 | 8.49e-8 | NR | WP_230888317.1 | 2896367 | g40051 | i0 | 82.4 | 0.409638554216867 | 34 | 6 | 41 | 0 | 103 | 2 | 1 | 34 | WP_230888317.1 hypothetical protein [Halobacterium sp. KA-4] | diamond | 102 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. KA-4 | |
| 29009530 | 29009530 | PRJNA703759_P_NODE_20108_length_309_cov_1.593220_g19632_i0 | PRJNA703759 | 20108 | 309 | 1.59322 | 4.9230498 | Halorientalis marina | 2931976 | Archaea | Archaea | 43.5 | 0.0409 | NR | WP_246986624.1 | 2931976 | g19632 | i0 | 29.8 | 1.00970873786408 | 104 | 63 | 96.1 | 4 | 3 | 299 | 78 | 176 | WP_246986624.1 cytochrome P450 [Halorientalis marina] | diamond | 312 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis marina | |
| 29399111 | 29399111 | PRJNA703759_P_NODE_51229_length_242_cov_0.923077_g50753_i0 | PRJNA703759 | 51229 | 242 | 0.923077 | 2.23384634 | Halobacteriales | 2235 | Archaea | Archaea | 84 | 1.14e-16 | NR | WP_276410133.1 | 2237 | g50753 | i0 | 50.6 | 24.4710743801653 | 81 | 37 | 96.7 | 1 | 7 | 240 | 550 | 630 | WP_276410133.1 MULTISPECIES: DUF2309 domain-containing protein [Haloarcula] | diamond | 5922 | 84.7 | 0.991735537190083 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula |
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);;