contig_metadata
5 rows where bioproject = "PRJNA1122875", tax_phylum = "Candidatus Bathyarchaeota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9205816 | 9205816 | PRJNA1122875_P_NODE_47348_length_247_cov_0.885057_g47124_i0 | PRJNA1122875 | 47348 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 136 | 2.25e-39 | NR | MBE3116355.1 | 2026714 | g47124 | i0 | 76.5 | 28.5303643724696 | 81 | 19 | 98.4 | 0 | 3 | 245 | 39 | 119 | MBE3116355.1 glycosyltransferase family 2 protein [Candidatus Bathyarchaeota archaeon] | diamond | 7047 | 137 | 0.992700729927007 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27765342 | 27765342 | PRJNA1122875_P_NODE_51264_length_243_cov_1.358824_g51040_i0 | PRJNA1122875 | 51264 | 243 | 1.358824 | 3.30194232 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 48.9 | 2.5e-4 | NR | MEE8355053.1 | 3045160 | g51040 | i0 | 39.5 | 0.530864197530864 | 43 | 22 | 53.1 | 1 | 100 | 228 | 339 | 377 | MEE8355053.1 glycoside hydrolase family 1 protein [Candidatus Bathyarchaeia archaeon] | diamond | 129 | 48.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28775379 | 28775379 | PRJNA1122875_P_NODE_34667_length_281_cov_1.365385_g34443_i0 | PRJNA1122875 | 34667 | 281 | 1.365385 | 3.83673185 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 67.4 | 1.09e-10 | NR | MEM2851084.1 | 3045160 | g34443 | i0 | 37.3 | 0.886120996441281 | 83 | 51 | 88.6 | 1 | 257 | 9 | 290 | 371 | MEM2851084.1 AAA family ATPase [Candidatus Bathyarchaeia archaeon] | diamond | 249 | 67.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29248960 | 29248960 | PRJNA1122875_P_NODE_28909_length_305_cov_1.659483_g28685_i0 | PRJNA1122875 | 28909 | 305 | 1.659483 | 5.06142315 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 112 | 3.31e-27 | NR | HYC19290.1 | 3045160 | g28685 | i0 | 54.9 | 2.99016393442623 | 102 | 44 | 99.3 | 2 | 2 | 304 | 102 | 202 | HYC19290.1 NAD(P)-dependent alcohol dehydrogenase [Candidatus Bathyarchaeia archaeon] | diamond | 912 | 112 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 30449490 | 30449490 | PRJNA1122875_P_NODE_31273_length_292_cov_1.054795_g31049_i0 | PRJNA1122875 | 31273 | 292 | 1.054795 | 3.0800014 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 76.6 | 2.97e-14 | NR | HID90616.1 | 2026714 | g31049 | i0 | 44.3 | 2.76369863013699 | 97 | 42 | 99.7 | 4 | 292 | 2 | 38 | 122 | HID90616.1 DNA-directed RNA polymerase subunit D [Candidatus Bathyarchaeota archaeon] | diamond | 807 | 76.6 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota 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);;