contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA784979" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27085317 | 27085317 | PRJNA784979_S_NODE_11262_length_165_cov_0.879310_g11220_i0 | PRJNA784979 | 11262 | 165 | 0.87931 | 1.4508615 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 54.7 | 8.12e-7 | NR | MFN2455377.1 | 2283092 | g11220 | i0 | 62 | 2.74545454545455 | 50 | 18 | 90.9 | 1 | 7 | 156 | 692 | 740 | MFN2455377.1 translocation/assembly module TamB domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 453 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27685804 | 27685804 | PRJNA784979_S_NODE_12804_length_162_cov_0.902655_g12762_i0 | PRJNA784979 | 12804 | 162 | 0.902655 | 1.4623011 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 70.5 | 1.98e-12 | NR | HWK10687.1 | 2910147 | g12762 | i0 | 50 | 1.2962962962963 | 70 | 18 | 98.1 | 1 | 1 | 159 | 88 | 157 | HWK10687.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 210 | 70.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27906245 | 27906245 | PRJNA784979_S_NODE_11265_length_165_cov_0.879310_g11223_i0 | PRJNA784979 | 11265 | 165 | 0.87931 | 1.4508615 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 70.9 | 1.53e-12 | NR | MBL8174237.1 | 2026791 | g11223 | i0 | 60.4 | 0.963636363636364 | 53 | 21 | 96.4 | 0 | 164 | 6 | 752 | 804 | MBL8174237.1 hypothetical protein [Bryobacterales bacterium] | diamond | 159 | 70.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 28159323 | 28159323 | PRJNA784979_S_NODE_12505_length_163_cov_0.894737_g12463_i0 | PRJNA784979 | 12505 | 163 | 0.894737 | 1.45842131 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 59.3 | 1.77e-8 | NR | HEX2457361.1 | 2910147 | g12463 | i0 | 51.9 | 0.993865030674847 | 54 | 25 | 99.4 | 1 | 1 | 162 | 196 | 248 | HEX2457361.1 BACON domain-containing carbohydrate-binding protein [Vicinamibacterales bacterium] | diamond | 162 | 59.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28696036 | 28696036 | PRJNA784979_S_NODE_12267_length_163_cov_0.894737_g12225_i0 | PRJNA784979 | 12267 | 163 | 0.894737 | 1.45842131 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 80.1 | 3.32e-16 | NR | HVS02468.1 | 2651171 | g12225 | i0 | 70.4 | 1.98773006134969 | 54 | 16 | 99.4 | 0 | 162 | 1 | 14 | 67 | HVS02468.1 ATP-binding protein [Thermoanaerobaculia bacterium] | diamond | 324 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28727470 | 28727470 | PRJNA784979_S_NODE_11947_length_164_cov_0.886957_g11905_i0 | PRJNA784979 | 11947 | 164 | 0.886957 | 1.45460948 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 83.6 | 5.14e-17 | NR | HEU4893683.1 | 2910147 | g11905 | i0 | 85.2 | 0.98780487804878 | 54 | 8 | 98.8 | 0 | 164 | 3 | 485 | 538 | HEU4893683.1 4-alpha-glucanotransferase [Vicinamibacterales bacterium] | diamond | 162 | 83.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29557468 | 29557468 | PRJNA784979_S_NODE_10910_length_166_cov_0.871795_g10868_i0 | PRJNA784979 | 10910 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 40.8 | 0.029 | NR | KAA6459671.1 | 1230846 | g10868 | i0 | 40.7 | 4.51807228915663 | 54 | 31 | 95.8 | 1 | 159 | 1 | 46 | 99 | KAA6459671.1 hypothetical protein DYQ86_16260 [Acidobacteria bacterium AB60] | diamond | 750 | 41.2 | 0.990291262135922 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium AB60 | ||||||
| 31127523 | 31127523 | PRJNA784979_S_NODE_10915_length_166_cov_0.871795_g10873_i0 | PRJNA784979 | 10915 | 166 | 0.871795 | 1.4471797 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 93.2 | 1.82e-20 | NR | HXF07257.1 | 2952895 | g10873 | i0 | 90.7 | 0.975903614457831 | 54 | 5 | 97.6 | 0 | 164 | 3 | 248 | 301 | HXF07257.1 M48 family metalloprotease [Candidatus Acidiferrales bacterium] | diamond | 162 | 93.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 31317568 | 31317568 | PRJNA784979_S_NODE_13275_length_161_cov_0.910714_g13233_i0 | PRJNA784979 | 13275 | 161 | 0.910714 | 1.46624954 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 94.4 | 8.050000000000001e-21 | NR | HXF09104.1 | 2952895 | g13233 | i0 | 84.9 | 0.987577639751553 | 53 | 8 | 98.8 | 0 | 1 | 159 | 349 | 401 | HXF09104.1 hypothetical protein [Candidatus Acidiferrales bacterium] | diamond | 159 | 94.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 31381033 | 31381033 | PRJNA784979_S_NODE_10676_length_166_cov_1.299145_g10634_i0 | PRJNA784979 | 10676 | 166 | 1.299145 | 2.1565807 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 103 | 1.24e-24 | NR | MBM3792844.1 | 1978231 | g10634 | i0 | 90.9 | 1.98795180722892 | 55 | 5 | 99.4 | 0 | 165 | 1 | 88 | 142 | MBM3792844.1 Gfo/Idh/MocA family oxidoreductase [Acidobacteriota bacterium] | diamond | 330 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32298641 | 32298641 | PRJNA784979_S_NODE_9679_length_170_cov_1.264463_g9637_i0 | PRJNA784979 | 9679 | 170 | 1.264463 | 2.1495871 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 57.8 | 6.59e-8 | NR | HET8647381.1 | 2793154 | g9637 | i0 | 51.9 | 0.952941176470588 | 54 | 22 | 95.3 | 3 | 167 | 6 | 247 | 296 | HET8647381.1 hypothetical protein [Vicinamibacteria bacterium] | diamond | 162 | 57.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria 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);;