contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26921222 | 26921222 | PRJNA565584_P_NODE_208822_length_242_cov_0.911243_g207670_i0 | PRJNA565584 | 208822 | 242 | 0.911243 | 2.20520806 | Candidatus Methanoprimaticola sp. MG2 | 3228838 | Archaea | Archaea | 75.9 | 1.05e-14 | NR | WP_414596051.1 | 3228838 | g207670 | i0 | 50.6 | 0.979338842975207 | 79 | 39 | 97.9 | 0 | 241 | 5 | 94 | 172 | WP_414596051.1 vWA domain-containing protein [Candidatus Methanoprimaticola sp. MG2] | diamond | 237 | 75.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanoprimaticola | Candidatus Methanoprimaticola sp. MG2 | ||
| 27788132 | 27788132 | PRJNA565584_P_NODE_148684_length_263_cov_1.605263_g147532_i0 | PRJNA565584 | 148684 | 263 | 1.605263 | 4.22184169 | root | 1 | Root_unresolved | Root_unresolved | 64.7 | 8.73e-10 | NR | MEF8874699.1 | 2806419 | g147532 | i0 | 57.1 | 5.4638783269962 | 49 | 20 | 55.9 | 1 | 60 | 206 | 385 | 432 | MEF8874699.1 propionyl-CoA synthetase [Thermoplasmatota archaeon] | diamond | 1437 | 65.1 | 0.993855606758833 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 27837404 | 27837404 | PRJNA565584_P_NODE_49904_length_421_cov_1.770115_g48753_i0 | PRJNA565584 | 49904 | 421 | 1.770115 | 7.45218415 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 87 | 8.7e-17 | NR | MDX1534133.1 | 1906666 | g48753 | i0 | 36 | 0.990498812351544 | 139 | 76 | 97.6 | 4 | 3 | 413 | 572 | 699 | MDX1534133.1 M1 family metallopeptidase [Thermoplasmata archaeon] | diamond | 417 | 87 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28279323 | 28279323 | PRJNA565584_P_NODE_190766_length_246_cov_0.890173_g189614_i0 | PRJNA565584 | 190766 | 246 | 0.890173 | 2.18982558 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 69.7 | 1.29e-12 | NR | MFO1533209.1 | 2806419 | g189614 | i0 | 52.2 | 4.89024390243902 | 67 | 32 | 81.7 | 0 | 45 | 245 | 34 | 100 | MFO1533209.1 HEAT repeat domain-containing protein [Thermoplasmatota archaeon] | diamond | 1203 | 69.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30332614 | 30332614 | PRJNA565584_P_NODE_193292_length_246_cov_0.890173_g192140_i0 | PRJNA565584 | 193292 | 246 | 0.890173 | 2.18982558 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 53.9 | 2.45e-6 | NR | HIA39890.1 | 2163009 | g192140 | i0 | 36.3 | 1.85365853658537 | 80 | 43 | 93.9 | 2 | 232 | 2 | 74 | 148 | HIA39890.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 456 | 53.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 32261073 | 32261073 | PRJNA565584_P_NODE_218558_length_235_cov_2.851852_g217406_i0 | PRJNA565584 | 218558 | 235 | 2.851852 | 6.7018522 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 59.3 | 4.2e-9 | NR | MCL5804599.1 | 2806419 | g217406 | i0 | 67.5 | 0.51063829787234 | 40 | 13 | 51.1 | 0 | 24 | 143 | 79 | 118 | MCL5804599.1 nascent polypeptide-associated complex protein [Thermoplasmatota archaeon] | diamond | 120 | 59.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32261089 | 32261089 | PRJNA565584_P_NODE_36258_length_502_cov_1.027972_g35107_i0 | PRJNA565584 | 36258 | 502 | 1.027972 | 5.16041944 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 59.3 | 4.71e-7 | NR | HII50895.1 | 2666346 | g35107 | i0 | 50 | 1.00398406374502 | 56 | 28 | 33.5 | 0 | 334 | 501 | 6 | 61 | HII50895.1 hypothetical protein [Candidatus Poseidoniaceae archaeon] | diamond | 504 | 59.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 32639808 | 32639808 | PRJNA565584_P_NODE_196180_length_245_cov_0.895349_g195028_i0 | PRJNA565584 | 196180 | 245 | 0.895349 | 2.19360505 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 53.5 | 5.62e-6 | NR | HID71921.1 | 1906666 | g195028 | i0 | 35.1 | 0.906122448979592 | 74 | 48 | 90.6 | 0 | 244 | 23 | 192 | 265 | HID71921.1 tetratricopeptide repeat protein [Thermoplasmata archaeon] | diamond | 222 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32671536 | 32671536 | PRJNA565584_P_NODE_67040_length_363_cov_1.193103_g65889_i0 | PRJNA565584 | 67040 | 363 | 1.193103 | 4.33096389 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 44.3 | 0.0377 | NR | MEC7589734.1 | 2806419 | g65889 | i0 | 26 | 0.603305785123967 | 73 | 54 | 60.3 | 0 | 83 | 301 | 197 | 269 | MEC7589734.1 nucleotide sugar dehydrogenase [Thermoplasmatota archaeon] | diamond | 219 | 44.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota 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);;