contig_metadata
6 rows where bioproject = "PRJNA966993", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27025842 | 27025842 | PRJNA966993_P_NODE_36322_length_356_cov_1.088339_g35870_i0 | PRJNA966993 | 36322 | 356 | 1.088339 | 3.87448684 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 69.7 | 4.93e-11 | NR | RCH77183.1 | 2163009 | g35870 | i0 | 40 | 0.884831460674157 | 105 | 58 | 86 | 2 | 31 | 336 | 366 | 468 | RCH77183.1 MAG: hypothetical protein DBX04_01445 [Candidatus Poseidoniales archaeon] | diamond | 315 | 69.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28668245 | 28668245 | PRJNA966993_P_NODE_45867_length_319_cov_1.252033_g45415_i0 | PRJNA966993 | 45867 | 319 | 1.252033 | 3.99398527 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 75.9 | 4.53e-14 | NR | MFL2976240.1 | 2670411 | g45415 | i0 | 43.8 | 3.38557993730408 | 89 | 41 | 83.7 | 2 | 268 | 2 | 11 | 90 | MFL2976240.1 glutathione S-transferase family protein [Candidatus Thalassarchaeaceae archaeon] | diamond | 1080 | 75.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 29994423 | 29994423 | PRJNA966993_P_NODE_101051_length_230_cov_2.515924_g100599_i0 | PRJNA966993 | 101051 | 230 | 2.515924 | 5.7866252 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 65.1 | 4.2e-10 | NR | MEC7178563.1 | 2806419 | g100599 | i0 | 56.5 | 0.808695652173913 | 62 | 25 | 78.3 | 2 | 51 | 230 | 416 | 477 | MEC7178563.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 186 | 65.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30537726 | 30537726 | PRJNA966993_P_NODE_15493_length_531_cov_4.703057_g15051_i0 | PRJNA966993 | 15493 | 531 | 4.703057 | 24.97323267 | Archaea | 2157 | Archaea | Archaea | 85.9 | 1.04e-17 | NR | HXQ49019.1 | 1906666 | g15051 | i0 | 38 | 3.24858757062147 | 137 | 82 | 76.3 | 2 | 32 | 436 | 12 | 147 | HXQ49019.1 universal stress protein [Thermoplasmata archaeon] | diamond | 1725 | 85.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30784147 | 30784147 | PRJNA966993_P_NODE_29374_length_391_cov_1.761006_g28922_i0 | PRJNA966993 | 29374 | 391 | 1.761006 | 6.88553346 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 62.4 | 2.81e-8 | NR | MDP7203619.1 | 2666346 | g28922 | i0 | 55.8 | 0.398976982097187 | 52 | 23 | 39.9 | 0 | 391 | 236 | 211 | 262 | MDP7203619.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] | diamond | 156 | 62.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 31226394 | 31226394 | PRJNA966993_P_NODE_24995_length_421_cov_4.818966_g24548_i0 | PRJNA966993 | 24995 | 421 | 4.818966 | 20.28784686 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 80.5 | 1.78e-14 | NR | UCH71462.1 | 2268204 | g24548 | i0 | 46.1 | 1.43230403800475 | 102 | 51 | 71.3 | 2 | 406 | 107 | 306 | 405 | UCH71462.1 MAG: pyruvate:ferredoxin (flavodoxin) oxidoreductase, partial [Thermoplasmatales archaeon] | diamond | 603 | 80.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales 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);;