contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27116910 | 27116910 | PRJNA797655_S_NODE_24582_length_389_cov_3.982659_g23978_i0 | PRJNA797655 | 24582 | 389 | 3.982659 | 15.49254351 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 44.7 | 0.0338 | NR | MBK5299036.1 | 2793154 | g23978 | i0 | 45.1 | 0.393316195372751 | 51 | 24 | 36.2 | 1 | 22 | 162 | 28 | 78 | MBK5299036.1 glycosyltransferase family 4 protein [Vicinamibacteria bacterium] | diamond | 153 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 27211759 | 27211759 | PRJNA797655_S_NODE_198622_length_179_cov_2.426471_g198017_i0 | PRJNA797655 | 198622 | 179 | 2.426471 | 4.34338309 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 41.6 | 0.0414 | NR | HZT57189.1 | 2283092 | g198017 | i0 | 36.8 | 0.955307262569832 | 57 | 29 | 83.8 | 1 | 150 | 1 | 191 | 247 | HZT57189.1 DUF2339 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 171 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28159563 | 28159563 | PRJNA797655_S_NODE_272425_length_151_cov_4.685185_g271820_i0 | PRJNA797655 | 272425 | 151 | 4.685185 | 7.07462935 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 40.8 | 0.0498 | NR | HXE81542.1 | 2910147 | g271820 | i0 | 37.8 | 0.894039735099338 | 45 | 28 | 89.4 | 0 | 3 | 137 | 42 | 86 | HXE81542.1 PQQ-binding-like beta-propeller repeat protein [Vicinamibacterales bacterium] | diamond | 135 | 40.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29706041 | 29706041 | PRJNA797655_S_NODE_109470_length_237_cov_1.979381_g108865_i0 | PRJNA797655 | 109470 | 237 | 1.979381 | 4.69113297 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 45.8 | 0.00107 | NR | HEX2328619.1 | 2976921 | g108865 | i0 | 36.7 | 0.759493670886076 | 60 | 34 | 70.9 | 1 | 209 | 42 | 28 | 87 | HEX2328619.1 hypothetical protein [Candidatus Angelobacter sp.] | diamond | 180 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 29737802 | 29737802 | PRJNA797655_S_NODE_38930_length_340_cov_1.673401_g38325_i0 | PRJNA797655 | 38930 | 340 | 1.673401 | 5.6895634 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 45.1 | 0.0131 | NR | HEX8118517.1 | 2283092 | g38325 | i0 | 30.8 | 0.917647058823529 | 104 | 54 | 90.9 | 4 | 326 | 18 | 77 | 163 | HEX8118517.1 Crp/Fnr family transcriptional regulator [Pyrinomonadaceae bacterium] | diamond | 312 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30370321 | 30370321 | PRJNA797655_S_NODE_228772_length_166_cov_2.130081_g228167_i0 | PRJNA797655 | 228772 | 166 | 2.130081 | 3.53593446 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 41.2 | 0.0454 | NR | HEV3253237.1 | 2952895 | g228167 | i0 | 51.7 | 0.524096385542169 | 29 | 14 | 52.4 | 0 | 104 | 18 | 242 | 270 | HEV3253237.1 sodium:solute symporter family protein [Candidatus Acidiferrales bacterium] | diamond | 87 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 31539379 | 31539379 | PRJNA797655_S_NODE_220616_length_170_cov_1.133858_g220011_i0 | PRJNA797655 | 220616 | 170 | 1.133858 | 1.9275586 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 41.2 | 0.0208 | NR | MEA2326987.1 | 2651171 | g220011 | i0 | 53.1 | 0.564705882352941 | 32 | 15 | 56.5 | 0 | 165 | 70 | 69 | 100 | MEA2326987.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 96 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32520278 | 32520278 | PRJNA797655_S_NODE_186799_length_185_cov_1.690141_g186194_i0 | PRJNA797655 | 186799 | 185 | 1.690141 | 3.12676085 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 41.6 | 0.0445 | NR | HKO13742.1 | 2052142 | g186194 | i0 | 30 | 0.972972972972973 | 60 | 38 | 90.8 | 1 | 9 | 176 | 508 | 567 | HKO13742.1 capsule assembly Wzi family protein [Acidobacteriaceae bacterium] | diamond | 180 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 32835040 | 32835040 | PRJNA797655_S_NODE_223760_length_168_cov_2.304000_g223155_i0 | PRJNA797655 | 223760 | 168 | 2.304 | 3.87072 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0137 | NR | MSO20143.1 | 1978231 | g223155 | i0 | 44.9 | 0.875 | 49 | 23 | 80.4 | 1 | 162 | 28 | 180 | 228 | MSO20143.1 CPBP family intramembrane metalloprotease [Acidobacteriota bacterium] | diamond | 147 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;