contig_metadata
7 rows where bioproject = "PRJNA520845", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26855999 | 26855999 | PRJNA520845_P_NODE_213961_length_251_cov_0.865169_g212462_i0 | PRJNA520845 | 213961 | 251 | 0.865169 | 2.17157419 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.5 | 0.0223 | NR | HZY70575.1 | 1906666 | g212462 | i0 | 46.8 | 0.561752988047809 | 47 | 21 | 56.2 | 2 | 237 | 97 | 615 | 657 | HZY70575.1 aconitate hydratase AcnA [Thermoplasmata archaeon] | diamond | 141 | 43.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28024925 | 28024925 | PRJNA520845_P_NODE_244265_length_245_cov_0.895349_g242766_i0 | PRJNA520845 | 244265 | 245 | 0.895349 | 2.19360505 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 53.5 | 3.44e-6 | NR | MCI0497549.1 | 1906666 | g242766 | i0 | 39 | 1.00408163265306 | 82 | 41 | 94.3 | 2 | 244 | 14 | 10 | 87 | MCI0497549.1 GDSL-type esterase/lipase family protein [Thermoplasmata archaeon] | diamond | 246 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28530122 | 28530122 | PRJNA520845_P_NODE_165107_length_289_cov_2.578704_g163608_i0 | PRJNA520845 | 165107 | 289 | 2.578704 | 7.45245456 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 42.7 | 0.0319 | NR | MBP5734334.1 | 2517205 | g163608 | i0 | 31.5 | 1.12110726643599 | 54 | 37 | 56.1 | 0 | 1 | 162 | 14 | 67 | MBP5734334.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 324 | 42.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 30045495 | 30045495 | PRJNA520845_P_NODE_182231_length_276_cov_1.211823_g180732_i0 | PRJNA520845 | 182231 | 276 | 1.211823 | 3.34463148 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 121 | 1.43e-31 | NR | MFP4050406.1 | 1906666 | g180732 | i0 | 61.8 | 1.91304347826087 | 89 | 32 | 96.7 | 1 | 8 | 274 | 124 | 210 | MFP4050406.1 adenylate kinase family protein [Thermoplasmata archaeon] | diamond | 528 | 121 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30993591 | 30993591 | PRJNA520845_P_NODE_181214_length_277_cov_1.132353_g179715_i0 | PRJNA520845 | 181214 | 277 | 1.132353 | 3.13661781 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 65.9 | 3.45e-10 | NR | MCD6276010.1 | 1906666 | g179715 | i0 | 43.8 | 0.963898916967509 | 89 | 46 | 96.4 | 2 | 268 | 2 | 50 | 134 | MCD6276010.1 bis-aminopropyl spermidine synthase family protein [Thermoplasmata archaeon] | diamond | 267 | 65.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32147495 | 32147495 | PRJNA520845_P_NODE_38558_length_609_cov_1.615672_g37090_i0 | PRJNA520845 | 38558 | 609 | 1.615672 | 9.83944248 | Archaea | 2157 | Archaea | Archaea | 201 | 4.29e-59 | NR | PKK86187.1 | 2013852 | g37090 | i0 | 50 | 4.82758620689655 | 198 | 91 | 95.6 | 3 | 25 | 606 | 1 | 194 | PKK86187.1 MAG: ATPase [Thermoplasmata archaeon HGW-Thermoplasmata-1] | diamond | 2940 | 201 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon HGW-Thermoplasmata-1 | |||||
| 32448673 | 32448673 | PRJNA520845_P_NODE_109999_length_355_cov_1.092199_g108500_i0 | PRJNA520845 | 109999 | 355 | 1.092199 | 3.87730645 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 74.3 | 1.04e-12 | NR | MDP6906002.1 | 2670411 | g108500 | i0 | 42.5 | 0.676056338028169 | 80 | 46 | 67.6 | 0 | 99 | 338 | 319 | 398 | MDP6906002.1 M20/M25/M40 family metallo-hydrolase [Candidatus Thalassarchaeaceae archaeon] | diamond | 240 | 74.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon |
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);;