contig_metadata
5 rows where bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26665697 | 26665697 | PRJNA529241_P_NODE_38061_length_331_cov_6.493197_g35742_i0 | PRJNA529241 | 38061 | 331 | 6.493197 | 21.49248207 | Methanobacterium sp. | 2164 | Archaea | Archaea | 67.8 | 1.51e-12 | NR | MEN6292319.1 | 2164 | g35742 | i0 | 59.6 | 0.425981873111782 | 47 | 19 | 42.6 | 0 | 177 | 317 | 15 | 61 | MEN6292319.1 hypothetical protein [Methanobacterium sp.] | diamond | 141 | 67.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 27709732 | 27709732 | PRJNA529241_P_NODE_308904_length_173_cov_3.404412_g306582_i0 | PRJNA529241 | 308904 | 173 | 3.404412 | 5.88963276 | Methanobrevibacter woesei | 190976 | Archaea | Archaea | 45.8 | 0.00119 | NR | WP_276847257.1 | 190976 | g306582 | i0 | 84 | 0.433526011560694 | 25 | 4 | 43.4 | 0 | 75 | 1 | 38 | 62 | WP_276847257.1 hypothetical protein [Methanobrevibacter woesei] | diamond | 75 | 45.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter woesei | |
| 27835483 | 27835483 | PRJNA529241_P_NODE_46244_length_300_cov_3.391635_g43922_i0 | PRJNA529241 | 46244 | 300 | 3.391635 | 10.174905 | Methanobacterium sp. | 2164 | Archaea | Archaea | 65.5 | 6.81e-10 | NR | MEN6294228.1 | 2164 | g43922 | i0 | 65.9 | 0.41 | 41 | 14 | 41 | 0 | 299 | 177 | 220 | 260 | MEN6294228.1 hypothetical protein [Methanobacterium sp.] | diamond | 123 | 65.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29287860 | 29287860 | PRJNA529241_P_NODE_30489_length_374_cov_5.255193_g28179_i0 | PRJNA529241 | 30489 | 374 | 5.255193 | 19.65442182 | Methanobacterium sp. | 2164 | Archaea | Archaea | 59.3 | 2.01e-7 | NR | MEN6292542.1 | 2164 | g28179 | i0 | 67.6 | 0.272727272727273 | 34 | 11 | 27.3 | 0 | 103 | 2 | 153 | 186 | MEN6292542.1 hypothetical protein [Methanobacterium sp.] | diamond | 102 | 59.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 30267371 | 30267371 | PRJNA529241_P_NODE_351252_length_173_cov_2.845588_g348930_i0 | PRJNA529241 | 351252 | 173 | 2.845588 | 4.92286724 | Methanobacterium sp. | 2164 | Archaea | Archaea | 43.5 | 0.00702 | NR | MEN6292541.1 | 2164 | g348930 | i0 | 80 | 0.867052023121387 | 25 | 5 | 43.4 | 0 | 1 | 75 | 136 | 160 | MEN6292541.1 hypothetical protein [Methanobacterium sp.] | diamond | 150 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. |
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);;