contig_metadata
5 rows where bioproject = "PRJNA692200", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24898978 | 24898978 | PRJNA692200_S_NODE_16620_length_180_cov_1.312977_g16563_i0 | PRJNA692200 | 16620 | 180 | 1.312977 | 2.3633586 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 204 | 3.98e-48 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g16563 | i0 | 96 | 80.2333333333333 | 125 | 5 | 69 | 0 | 4 | 128 | 3197 | 3073 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 14442 | 204 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 27398765 | 27398765 | PRJNA692200_S_NODE_343_length_541_cov_17.666667_g312_i0 | PRJNA692200 | 343 | 541 | 17.666667 | 95.57666847 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.9 | 0.00431 | NR | HEU17834.1 | 2026735 | g312 | i0 | 31.9 | 1.45286506469501 | 119 | 60 | 57.7 | 4 | 68 | 379 | 138 | 250 | HEU17834.1 LysM domain-containing protein [Deltaproteobacteria bacterium] | diamond | 786 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29734825 | 29734825 | PRJNA692200_S_NODE_21330_length_163_cov_3.535088_g21273_i0 | PRJNA692200 | 21330 | 163 | 3.535088 | 5.76219344 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 48.1 | 1.58e-4 | NR | MET0593877.1 | 2268199 | g21273 | i0 | 75 | 4.63803680981595 | 28 | 7 | 51.5 | 0 | 2 | 85 | 383 | 410 | MET0593877.1 URC4/urg3 family protein [Polyangiaceae bacterium] | diamond | 756 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30188586 | 30188586 | PRJNA692200_S_NODE_10972_length_215_cov_0.873494_g10915_i0 | PRJNA692200 | 10972 | 215 | 0.873494 | 1.8780121 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.2 | 8.24e-8 | NR | NUN13108.1 | 2026763 | g10915 | i0 | 39.4 | 1.98139534883721 | 71 | 42 | 99.1 | 1 | 3 | 215 | 182 | 251 | NUN13108.1 SRPBCC family protein [Myxococcales bacterium] | diamond | 426 | 58.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32180490 | 32180490 | PRJNA692200_S_NODE_17638_length_175_cov_1.642857_g17581_i0 | PRJNA692200 | 17638 | 175 | 1.642857 | 2.87499975 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 66.2 | 2.74e-11 | NR | WP_047861188.1 | 48 | g17581 | i0 | 59.3 | 4.44 | 54 | 22 | 92.6 | 0 | 174 | 13 | 2 | 55 | WP_047861188.1 Fe2+-dependent dioxygenase [Archangium gephyra] | diamond | 777 | 66.6 | 0.993993993993994 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra |
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);;