contig_metadata
6 rows where bioproject = "PRJNA1028258" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26908487 | 26908487 | PRJNA1028258_P_NODE_145482_length_232_cov_0.871166_g144919_i0 | PRJNA1028258 | 145482 | 232 | 0.871166 | 2.02110512 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 110 | 4.87e-26 | NR | MBI5838110.1 | 2212470 | g144919 | i0 | 69.7 | 3.93103448275862 | 76 | 22 | 98.3 | 1 | 3 | 230 | 414 | 488 | MBI5838110.1 energy-dependent translational throttle protein EttA [Candidatus Eiseniibacteriota bacterium] | diamond | 912 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 27319623 | 27319623 | PRJNA1028258_P_NODE_110663_length_252_cov_1.163934_g110100_i0 | PRJNA1028258 | 110663 | 252 | 1.163934 | 2.93311368 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 42.7 | 0.0389 | NR | MFH1679839.1 | 2212470 | g110100 | i0 | 36 | 1.02380952380952 | 86 | 48 | 95.2 | 4 | 11 | 250 | 73 | 157 | MFH1679839.1 ABC transporter ATP-binding protein [Candidatus Eiseniibacteriota bacterium] | diamond | 258 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 27477447 | 27477447 | PRJNA1028258_P_NODE_170083_length_226_cov_1.541401_g169520_i0 | PRJNA1028258 | 170083 | 226 | 1.541401 | 3.48356626 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 42.7 | 0.0291 | NR | MCK4548319.1 | 2212470 | g169520 | i0 | 33.9 | 0.743362831858407 | 56 | 34 | 70.4 | 1 | 34 | 192 | 111 | 166 | MCK4548319.1 glycosyltransferase family 2 protein [Candidatus Eiseniibacteriota bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29214305 | 29214305 | PRJNA1028258_P_NODE_78129_length_291_cov_2.238739_g77566_i0 | PRJNA1028258 | 78129 | 291 | 2.238739 | 6.51473049 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 72.8 | 1.87e-12 | NR | HXJ34712.1 | 2212470 | g77566 | i0 | 39.6 | 1.04123711340206 | 101 | 39 | 100 | 4 | 1 | 291 | 417 | 499 | HXJ34712.1 di-heme oxidoredictase family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 303 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29434745 | 29434745 | PRJNA1028258_P_NODE_161570_length_228_cov_1.528302_g161007_i0 | PRJNA1028258 | 161570 | 228 | 1.528302 | 3.48452856 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 87.4 | 5.6e-18 | NR | HEY2955372.1 | 2212470 | g161007 | i0 | 56.8 | 0.973684210526316 | 74 | 32 | 97.4 | 0 | 3 | 224 | 76 | 149 | HEY2955372.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 222 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30098181 | 30098181 | PRJNA1028258_P_NODE_87232_length_276_cov_1.371981_g86669_i0 | PRJNA1028258 | 87232 | 276 | 1.371981 | 3.78666756 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 43.1 | 0.0337 | NR | MFI5370700.1 | 2212470 | g86669 | i0 | 46.9 | 0.532608695652174 | 49 | 25 | 52.2 | 1 | 181 | 38 | 149 | 197 | MFI5370700.1 (d)CMP kinase [Candidatus Eiseniibacteriota bacterium] | diamond | 147 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium |
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);;