contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA1126661" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26848969 | 26848969 | PRJNA1126661_P_NODE_32121_length_316_cov_4.757202_g31592_i0 | PRJNA1126661 | 32121 | 316 | 4.757202 | 15.03275832 | Methanococcoides methylutens | 2226 | Archaea | Archaea | 140 | 6.15e-37 | NR | WP_052721412.1 | 2226 | g31592 | i0 | 49.7 | 2.59177215189873 | 143 | 34 | 99.7 | 1 | 1 | 315 | 179 | 321 | WP_052721412.1 VWA domain-containing protein [Methanococcoides methylutens] | diamond | 819 | 140 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanococcoides | Methanococcoides methylutens | |
| 32851378 | 32851378 | PRJNA1126661_P_NODE_18960_length_326_cov_4.106719_g18431_i0 | PRJNA1126661 | 18960 | 326 | 4.106719 | 13.38790394 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 99 | 1.63e-21 | NR | HWR97819.1 | 2032688 | g18431 | i0 | 87.8 | 0.450920245398773 | 49 | 6 | 45.1 | 0 | 178 | 324 | 143 | 191 | HWR97819.1 ammonia-forming cytochrome c nitrite reductase subunit c552 [Candidatus Methanoperedens sp.] | diamond | 147 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 32851395 | 32851395 | PRJNA1126661_P_NODE_73180_length_245_cov_4.197674_g72650_i0 | PRJNA1126661 | 73180 | 245 | 4.197674 | 10.2843013 | Haladaptatus caseinilyticus | 2993314 | Archaea | Archaea | 81.6 | 3.58e-16 | NR | WP_266081598.1 | 2993314 | g72650 | i0 | 52.9 | 0.857142857142857 | 70 | 32 | 85.7 | 1 | 211 | 2 | 149 | 217 | WP_266081598.1 hypothetical protein [Haladaptatus caseinilyticus] | diamond | 210 | 81.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus caseinilyticus |
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);;