contig_metadata
3 rows where bioproject = "PRJNA1144090", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29754510 | 29754510 | PRJNA1144090_P_NODE_87131_length_269_cov_2.285714_g86596_i0 | PRJNA1144090 | 87131 | 269 | 2.285714 | 6.14857066 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 46.6 | 0.00229 | NR | HEY9790097.1 | 2364082 | g86596 | i0 | 55.9 | 0.379182156133829 | 34 | 15 | 37.9 | 0 | 56 | 157 | 647 | 680 | HEY9790097.1 DEAD/DEAH box helicase [Candidatus Obscuribacterales bacterium] | diamond | 102 | 46.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30670677 | 30670677 | PRJNA1144090_P_NODE_13773_length_754_cov_1.044053_g13303_i0 | PRJNA1144090 | 13773 | 754 | 1.044053 | 7.87215962 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 446 | 2.88e-156 | NR | MBX9770214.1 | 2364082 | g13303 | i0 | 83.7 | 0.99867374005305 | 251 | 41 | 99.9 | 0 | 753 | 1 | 20 | 270 | MBX9770214.1 elongation of very long chain fatty acids protein [Candidatus Obscuribacterales bacterium] | diamond | 753 | 446 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30923784 | 30923784 | PRJNA1144090_P_NODE_29974_length_481_cov_1.833333_g29440_i0 | PRJNA1144090 | 29974 | 481 | 1.833333 | 8.81833173 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 52.8 | 1.06e-4 | NR | MDP3508905.1 | 2052166 | g29440 | i0 | 35.6 | 0.455301455301455 | 73 | 46 | 44.9 | 1 | 229 | 14 | 116 | 188 | MDP3508905.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 219 | 52.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria 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);;