contig_metadata
6 rows where bioproject = "PRJNA928559", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26613092 | 26613092 | PRJNA928559_P_NODE_171701_length_266_cov_2.787565_g170132_i0 | PRJNA928559 | 171701 | 266 | 2.787565 | 7.4149229 | Candidatus Vampirococcus lugosii | 2789015 | Bacteria | Bacteria | 50.8 | 7.22e-5 | NR | WP_213348134.1 | 2789015 | g170132 | i0 | 24.7 | 0.913533834586466 | 81 | 61 | 91.4 | 0 | 243 | 1 | 1839 | 1919 | WP_213348134.1 Ig-like domain-containing alpha-2-macroglobulin family protein [Candidatus Vampirococcus lugosii] | diamond | 243 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Vampirococcus | Candidatus Vampirococcus lugosii | |||||
| 26810434 | 26810434 | PRJNA928559_P_NODE_121941_length_322_cov_2.763052_g120372_i0 | PRJNA928559 | 121941 | 322 | 2.763052 | 8.89702744 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 0.00124 | NR | AHB41750.1 | 1394709 | g120372 | i0 | 53.1 | 1.3695652173913 | 49 | 23 | 45.7 | 0 | 1 | 147 | 133 | 181 | AHB41750.1 hypothetical protein P148_SR1C00001G0964 [candidate division SR1 bacterium RAAC1_SR1_1] | diamond | 441 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 26961365 | 26961365 | PRJNA928559_P_NODE_221382_length_231_cov_2.810127_g219813_i0 | PRJNA928559 | 221382 | 231 | 2.810127 | 6.49139337 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 48.1 | 1.23e-4 | NR | WP_231176587.1 | 2735562 | g219813 | i0 | 52.2 | 0.597402597402597 | 46 | 22 | 59.7 | 0 | 83 | 220 | 23 | 68 | WP_231176587.1 hypothetical protein [Candidatus Absconditicoccus praedator] | diamond | 138 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator | |||
| 28035654 | 28035654 | PRJNA928559_P_NODE_184345_length_255_cov_2.406593_g182776_i0 | PRJNA928559 | 184345 | 255 | 2.406593 | 6.13681215 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 107 | 7.97e-25 | NR | WP_231180222.1 | 2735562 | g182776 | i0 | 69.9 | 0.858823529411765 | 73 | 22 | 85.9 | 0 | 13 | 231 | 980 | 1052 | WP_231180222.1 efflux RND transporter permease subunit [Candidatus Absconditicoccus praedator] | diamond | 219 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator | |||
| 30814730 | 30814730 | PRJNA928559_P_NODE_76954_length_403_cov_2.793939_g75385_i0 | PRJNA928559 | 76954 | 403 | 2.793939 | 11.25957417 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 46.2 | 0.0133 | NR | MEF2175778.1 | 3018262 | g75385 | i0 | 42.9 | 0.364764267990074 | 49 | 28 | 36.5 | 0 | 135 | 281 | 2279 | 2327 | MEF2175778.1 lamin tail domain-containing protein [Candidatus Absconditabacteria bacterium] | diamond | 147 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria bacterium | ||||||
| 31794642 | 31794642 | PRJNA928559_P_NODE_99537_length_357_cov_3.880282_g97968_i0 | PRJNA928559 | 99537 | 357 | 3.880282 | 13.85260674 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 45.8 | 0.0111 | NR | MEF2175993.1 | 3018262 | g97968 | i0 | 50 | 0.369747899159664 | 44 | 20 | 35.3 | 1 | 232 | 107 | 207 | 250 | MEF2175993.1 DUF4215 domain-containing protein [Candidatus Absconditabacteria bacterium] | diamond | 132 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria 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);;