contig_metadata
6 rows where bioproject = "PRJNA1102048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9139355 | 9139355 | PRJNA1102048_P_NODE_2368_length_536_cov_0.993521_g2265_i0 | PRJNA1102048 | 2368 | 536 | 0.993521 | 5.32527256 | Halorussus caseinilyticus | 3034025 | Archaea | Archaea | 54.7 | 0.015 | NTclustered | gi|2463595565|gb|CP119811.1| | 3034025 | g2265 | i0 | 100 | 0.21641791044776101 | 29 | 0 | 5 | 0 | 382 | 410 | 42645 | 42617 | Halorussus caseinilyticus strain DT72 plasmid unnamed2, complete sequence | blastn | 116 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus caseinilyticus | |
| 27825902 | 27825902 | PRJNA1102048_P_NODE_4464_length_404_cov_1.280967_g4360_i0 | PRJNA1102048 | 4464 | 404 | 1.280967 | 5.17510668 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 98.6 | 3.77e-21 | NR | MBN2602997.1 | 2806419 | g4360 | i0 | 49.4 | 1.76732673267327 | 83 | 42 | 61.6 | 0 | 398 | 150 | 349 | 431 | MBN2602997.1 polyamine aminopropyltransferase [Thermoplasmatota archaeon] | diamond | 714 | 98.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28962688 | 28962688 | PRJNA1102048_P_NODE_11748_length_259_cov_2.263441_g11644_i0 | PRJNA1102048 | 11748 | 259 | 2.263441 | 5.86231219 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 114 | 1.02e-27 | NR | RLF35890.1 | 1906666 | g11644 | i0 | 64.3 | 1.93436293436293 | 84 | 30 | 97.3 | 0 | 3 | 254 | 240 | 323 | RLF35890.1 MAG: spermidine synthase [Thermoplasmata archaeon] | diamond | 501 | 114 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29404517 | 29404517 | PRJNA1102048_P_NODE_1889_length_585_cov_1.328125_g1788_i0 | PRJNA1102048 | 1889 | 585 | 1.328125 | 7.76953125 | Haloarculaceae archaeon | 2497615 | Archaea | Archaea | 90.5 | 6.43e-18 | NR | MFB6074683.1 | 2497615 | g1788 | i0 | 32.3 | 2.61025641025641 | 167 | 107 | 83.6 | 5 | 540 | 52 | 43 | 207 | MFB6074683.1 DUF4397 domain-containing protein [Haloarculaceae archaeon] | diamond | 1527 | 90.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon | ||
| 29941459 | 29941459 | PRJNA1102048_P_NODE_11111_length_266_cov_1.435233_g11007_i0 | PRJNA1102048 | 11111 | 266 | 1.435233 | 3.81771978 | Candidatus Methanophaga sp. ANME-1 ERB7 | 2759913 | Archaea | Archaea | 57.8 | 7.7e-8 | NR | QNO56085.1 | 2759913 | g11007 | i0 | 32.9 | 0.823308270676692 | 73 | 49 | 82.3 | 0 | 225 | 7 | 15 | 87 | QNO56085.1 hypothetical protein GIJIEOGM_00026 [Candidatus Methanophaga sp. ANME-1 ERB7] | diamond | 219 | 57.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophaga | Candidatus Methanophaga sp. ANME-1 ERB7 | |
| 30880410 | 30880410 | PRJNA1102048_P_NODE_14974_length_246_cov_1.450867_g14870_i0 | PRJNA1102048 | 14974 | 246 | 1.450867 | 3.56913282 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 1.31e-7 | NR | WP_171481123.1 | 74969 | g14870 | i0 | 43.2 | 13.7926829268293 | 81 | 32 | 98.8 | 3 | 3 | 245 | 242 | 308 | WP_171481123.1 4-hydroxyphenylpyruvate dioxygenase [Ferroplasma acidiphilum] | diamond | 3393 | 58.5 | 0.994871794871795 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Ferroplasma | Ferroplasma acidiphilum |
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);;