contig_metadata
8 rows where bioproject = "PRJNA737474", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26260945 | 26260945 | PRJNA737474f_S_NODE_46310_length_348_cov_0.901818_g45632_i0 | PRJNA737474 | 46310 | 348 | 0.901818 | 3.13832664 | Candidatus Poseidoniia archaeon | 2666348 | Archaea | Archaea | 178 | 9.02e-51 | NR | MEO2221387.1 | 2666348 | g45632 | i0 | 80.2 | 27.8620689655172 | 101 | 20 | 87.1 | 0 | 1 | 303 | 86 | 186 | MEO2221387.1 CTP synthase (glutamine hydrolyzing) [Candidatus Poseidoniia archaeon] | diamond | 9696 | 178 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniia archaeon | |||||
| 32918873 | 32918873 | PRJNA737474d_S_NODE_19849_length_343_cov_5.262963_g19255_i0 | PRJNA737474 | 19849 | 343 | 5.262963 | 18.05196309 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 44.7 | 0.00196 | NR | MBU4190050.1 | 2806419 | g19255 | i0 | 43.4 | 0.463556851311953 | 53 | 19 | 46.4 | 2 | 79 | 237 | 12 | 53 | MBU4190050.1 zinc-ribbon domain-containing protein [Thermoplasmatota archaeon] | diamond | 159 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32937824 | 32937824 | PRJNA737474g_S_NODE_361409_length_247_cov_0.885057_g360115_i0 | PRJNA737474 | 361409 | 247 | 0.885057 | 2.18609079 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 46.6 | 0.00163 | NR | HJM44501.1 | 2666346 | g360115 | i0 | 42.5 | 0.88663967611336 | 73 | 33 | 77.7 | 1 | 224 | 33 | 345 | 417 | HJM44501.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] | diamond | 219 | 46.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 32952731 | 32952731 | PRJNA737474b_S_NODE_16546_length_394_cov_2.794393_g15507_i0 | PRJNA737474 | 16546 | 394 | 2.794393 | 11.00990842 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 44.7 | 0.0406 | NR | MFL2977781.1 | 2670411 | g15507 | i0 | 40.6 | 0.525380710659898 | 69 | 39 | 52.5 | 2 | 35 | 241 | 739 | 805 | MFL2977781.1 alpha-amylase family glycosyl hydrolase [Candidatus Thalassarchaeaceae archaeon] | diamond | 207 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 33056719 | 33056719 | PRJNA737474g_S_NODE_120173_length_313_cov_0.858333_g118879_i0 | PRJNA737474 | 120173 | 313 | 0.858333 | 2.68658229 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 60.5 | 5.07e-8 | NR | MFA5101580.1 | 2806419 | g118879 | i0 | 41.7 | 1.79233226837061 | 60 | 35 | 57.5 | 0 | 312 | 133 | 304 | 363 | MFA5101580.1 FG-GAP repeat protein [Thermoplasmatota archaeon] | diamond | 561 | 60.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 33125695 | 33125695 | PRJNA737474g_S_NODE_435247_length_241_cov_0.934524_g433953_i0 | PRJNA737474 | 435247 | 241 | 0.934524 | 2.25220284 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 48.5 | 3.32e-4 | NR | HKZ59478.1 | 2806419 | g433953 | i0 | 55.3 | 1.33195020746888 | 38 | 17 | 47.3 | 0 | 102 | 215 | 1121 | 1158 | HKZ59478.1 S8 family serine peptidase [Thermoplasmatota archaeon] | diamond | 321 | 48.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 33141609 | 33141609 | PRJNA737474f_S_NODE_28615_length_401_cov_6.542683_g27938_i0 | PRJNA737474 | 28615 | 401 | 6.542683 | 26.23615883 | Marine Group III euryarchaeote | 2173149 | Archaea | Archaea | 71.2 | 1.33e-11 | NR | HIG63927.1 | 2173149 | g27938 | i0 | 40 | 0.71072319201995 | 95 | 55 | 71.1 | 2 | 14 | 298 | 191 | 283 | HIG63927.1 isopenicillin N synthase family oxygenase [Marine Group III euryarchaeote] | diamond | 285 | 71.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Candidatus Thermoprofundales | Marine Group III euryarchaeote | ||||
| 33157718 | 33157718 | PRJNA737474d_S_NODE_15824_length_386_cov_2.501597_g15230_i0 | PRJNA737474 | 15824 | 386 | 2.501597 | 9.65616442 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.1 | 0.0279 | NR | UCH89457.1 | 1906666 | g15230 | i0 | 33.3 | 0.746113989637306 | 96 | 52 | 66.1 | 3 | 372 | 118 | 370 | 464 | UCH89457.1 MAG: right-handed parallel beta-helix repeat-containing protein, partial [Thermoplasmata archaeon] | diamond | 288 | 45.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;