contig_metadata
6 rows where bioproject = "PRJNA929922" and tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8559485 | 8559485 | PRJNA929922_P_NODE_159847_length_241_cov_1.648810_g159307_i0 | PRJNA929922 | 159847 | 241 | 1.64881 | 3.9736321 | Methanobrevibacter sp. AbM4 | 224719 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|509083678|gb|CP004050.1| | 224719 | g159307 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 134 | 161 | 1082368 | 1082341 | Methanobrevibacter sp. AbM4, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. AbM4 | |
| 14007518 | 14007518 | PRJNA929922_P_NODE_127311_length_247_cov_1.298851_g126771_i0 | PRJNA929922 | 127311 | 247 | 1.298851 | 3.20816197 | Methanocaldococcus | 196118 | Archaea | Archaea | 145 | 3.58e-30 | NTclustered | gi|103488817|gb|DQ516870.1| | 2190 | g126771 | i0 | 100 | 0.631578947368421 | 78 | 0 | 32 | 0 | 170 | 247 | 971 | 1048 | Methanocaldococcus jannaschii spike-in control MJ-5000-154 genomic sequence | blastn | 156 | 145 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus jannaschii | |
| 27498984 | 27498984 | PRJNA929922_P_NODE_115583_length_250_cov_0.870056_g115043_i0 | PRJNA929922 | 115583 | 250 | 0.870056 | 2.17514 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 85.9 | 2.65e-17 | NR | WP_296889016.1 | 253161 | g115043 | i0 | 49.4 | 0.972 | 81 | 40 | 97.2 | 1 | 245 | 3 | 1577 | 1656 | WP_296889016.1 carboxypeptidase-like regulatory domain-containing protein [uncultured Methanobrevibacter sp.] | diamond | 243 | 85.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 29614039 | 29614039 | PRJNA929922_S_NODE_60890_length_251_cov_1.685393_g60666_i0 | PRJNA929922 | 60890 | 251 | 1.685393 | 4.23033643 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 119 | 2.38e-29 | NR | MDO5826752.1 | 66852 | g60666 | i0 | 95.6 | 0.812749003984064 | 68 | 3 | 81.3 | 0 | 2 | 205 | 412 | 479 | MDO5826752.1 flippase [Methanobrevibacter sp.] | diamond | 204 | 119 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31707078 | 31707078 | PRJNA929922_P_NODE_163237_length_241_cov_0.916667_g162697_i0 | PRJNA929922 | 163237 | 241 | 0.916667 | 2.20916747 | Methanobrevibacter | 2172 | Archaea | Archaea | 112 | 3.73e-30 | NR | WP_409198532.1 | 2172 | g162697 | i0 | 92.3 | 6.47302904564315 | 52 | 4 | 64.7 | 0 | 2 | 157 | 53 | 104 | WP_409198532.1 MULTISPECIES: translation initiation factor eIF-1A [Methanobrevibacter] | diamond | 1560 | 112 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | ||
| 31984658 | 31984658 | PRJNA929922_P_NODE_19018_length_429_cov_0.856742_g18483_i0 | PRJNA929922 | 19018 | 429 | 0.856742 | 3.67542318 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 45.4 | 0.0279 | NR | WP_221061479.1 | 39441 | g18483 | i0 | 37 | 0.566433566433566 | 81 | 47 | 55.2 | 2 | 169 | 405 | 202 | 280 | WP_221061479.1 DUF460 domain-containing protein [Methanobrevibacter arboriphilus] | diamond | 243 | 45.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus |
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);;