contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1126661" and tax_kingdom = "Methanobacteriati"
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 | |
| 27291628 | 27291628 | PRJNA1126661_P_NODE_35423_length_301_cov_5.934211_g34894_i0 | PRJNA1126661 | 35423 | 301 | 5.934211 | 17.86197511 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 147 | 7.51e-41 | NR | MEE0901010.1 | 66852 | g34894 | i0 | 96.1 | 0.767441860465116 | 77 | 3 | 76.7 | 0 | 301 | 71 | 247 | 323 | MEE0901010.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 231 | 147 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28049433 | 28049433 | PRJNA1126661_P_NODE_30585_length_325_cov_14.599206_g30056_i0 | PRJNA1126661 | 30585 | 325 | 14.599206 | 47.4474195 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 94.7 | 5.63e-20 | NR | MCH7661053.1 | 2026739 | g30056 | i0 | 32.5 | 4.48615384615385 | 243 | 29 | 99.7 | 1 | 325 | 2 | 199 | 441 | MCH7661053.1 MMPL family transporter [Methanobacteriota archaeon] | diamond | 1458 | 94.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28396751 | 28396751 | PRJNA1126661_P_NODE_76766_length_235_cov_5.432099_g76236_i0 | PRJNA1126661 | 76766 | 235 | 5.432099 | 12.76543265 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 108 | 7.28e-27 | NR | MEK6975271.1 | 2806419 | g76236 | i0 | 68 | 2.89787234042553 | 75 | 24 | 95.7 | 0 | 234 | 10 | 98 | 172 | MEK6975271.1 Ku protein [Thermoplasmatota archaeon] | diamond | 681 | 108 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30355193 | 30355193 | PRJNA1126661_P_NODE_30952_length_325_cov_5.595238_g30423_i0 | PRJNA1126661 | 30952 | 325 | 5.595238 | 18.1845235 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 88.2 | 1.07e-17 | NR | HUR68234.1 | 2806419 | g30423 | i0 | 89.8 | 3.15692307692308 | 49 | 5 | 45.2 | 0 | 177 | 323 | 590 | 638 | HUR68234.1 NADP-dependent malic enzyme [Thermoplasmatota archaeon] | diamond | 1026 | 88.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 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);;