contig_metadata
4 rows where bioproject = "PRJNA674308", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27618982 | 27618982 | PRJNA674308_P_NODE_14244_length_255_cov_1.733010_g14009_i0 | PRJNA674308 | 14244 | 255 | 1.73301 | 4.4191755 | Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_ | 2035772 | Bacteria | Bacteria | 77 | 3.66e-14 | NR | PIQ89452.1 | 1974746 | g14009 | i0 | 47.6 | 0.988235294117647 | 84 | 42 | 96.5 | 1 | 2 | 247 | 373 | 456 | PIQ89452.1 MAG: hypothetical protein COV72_02805 [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_42_13] | diamond | 252 | 77 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Ghiorseimicrobium | Candidatus Ghiorseimicrobium undicola | ||||
| 27618999 | 27618999 | PRJNA674308_P_NODE_39384_length_168_cov_0.873950_g39149_i0 | PRJNA674308 | 39384 | 168 | 0.87395 | 1.468236 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 55.5 | 1.58e-7 | NR | MDD5006669.1 | 2035772 | g39149 | i0 | 46.4 | 1 | 56 | 27 | 96.4 | 2 | 6 | 167 | 50 | 104 | MDD5006669.1 HNH endonuclease [Candidatus Omnitrophota bacterium] | diamond | 168 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30188364 | 30188364 | PRJNA674308_P_NODE_42752_length_166_cov_0.888889_g42517_i0 | PRJNA674308 | 42752 | 166 | 0.888889 | 1.47555574 | PVC group | 1783257 | Bacteria | Bacteria | 61.2 | 2.66e-9 | NR | MBI3997311.1 | 2035772 | g42517 | i0 | 63 | 10.7168674698795 | 46 | 17 | 83.1 | 0 | 29 | 166 | 5 | 50 | MBI3997311.1 molybdopterin-synthase adenylyltransferase MoeB [Candidatus Omnitrophota bacterium] | diamond | 1779 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31642164 | 31642164 | PRJNA674308_P_NODE_27796_length_191_cov_1.098592_g27561_i0 | PRJNA674308 | 27796 | 191 | 1.098592 | 2.09831072 | Bacteria | 2 | Bacteria | Bacteria | 44.3 | 0.00548 | NR | PIZ84147.1 | 1974733 | g27561 | i0 | 39.6 | 1.50785340314136 | 48 | 29 | 75.4 | 0 | 47 | 190 | 685 | 732 | PIZ84147.1 MAG: hypothetical protein COX96_05345, partial [Candidatus Omnitrophica bacterium CG_4_10_14_0_2_um_filter_44_9] | diamond | 288 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophica bacterium CG_4_10_14_0_2_um_filter_44_9 |
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);;