contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA795663" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13532955 | 13532955 | PRJNA795663_S_NODE_14151_length_168_cov_1.259542_g14046_i0 | PRJNA795663 | 14151 | 168 | 1.259542 | 2.11603056 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 112 | 5.550000000000001e-27 | NR | HYP26891.1 | 2052146 | g14046 | i0 | 96.4 | 2 | 56 | 2 | 100 | 0 | 1 | 168 | 324 | 379 | HYP26891.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Blastocatellia bacterium] | diamond | 336 | 112 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 26610433 | 26610433 | PRJNA795663_S_NODE_19101_length_150_cov_1.017699_g18996_i0 | PRJNA795663 | 19101 | 150 | 1.017699 | 1.5265485 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 99.8 | 8.61e-23 | NR | HYP26892.1 | 2052146 | g18996 | i0 | 95.9 | 0.98 | 49 | 2 | 98 | 0 | 3 | 149 | 1444 | 1492 | HYP26892.1 amino acid adenylation domain-containing protein [Blastocatellia bacterium] | diamond | 147 | 99.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 26864261 | 26864261 | PRJNA795663_S_NODE_7321_length_220_cov_2.459016_g7216_i0 | PRJNA795663 | 7321 | 220 | 2.459016 | 5.4098352 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 110 | 7.260000000000001e-27 | NR | HVF92289.1 | 2052146 | g7216 | i0 | 91.5 | 0.804545454545455 | 59 | 5 | 80.5 | 0 | 3 | 179 | 149 | 207 | HVF92289.1 DNA replication and repair protein RecF [Blastocatellia bacterium] | diamond | 177 | 110 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27591129 | 27591129 | PRJNA795663_S_NODE_13604_length_171_cov_1.126866_g13499_i0 | PRJNA795663 | 13604 | 171 | 1.126866 | 1.92694086 | Luteitalea sp. | 2004800 | Bacteria | Bacteria | 103 | 5.22e-24 | NR | WP_291988900.1 | 2004800 | g13499 | i0 | 94.6 | 0.982456140350877 | 56 | 3 | 98.2 | 0 | 3 | 170 | 519 | 574 | WP_291988900.1 M14 family metallopeptidase [Luteitalea sp.] | diamond | 168 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. | ||
| 27843339 | 27843339 | PRJNA795663_S_NODE_8364_length_208_cov_2.023392_g8259_i0 | PRJNA795663 | 8364 | 208 | 2.023392 | 4.20865536 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 126 | 7.28e-33 | NR | HVF92289.1 | 2052146 | g8259 | i0 | 91.3 | 0.995192307692308 | 69 | 6 | 99.5 | 0 | 1 | 207 | 56 | 124 | HVF92289.1 DNA replication and repair protein RecF [Blastocatellia bacterium] | diamond | 207 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28064502 | 28064502 | PRJNA795663_S_NODE_4585_length_272_cov_2.246809_g4480_i0 | PRJNA795663 | 4585 | 272 | 2.246809 | 6.11132048 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 73.9 | 5.23e-13 | NR | HEY8550495.1 | 2910147 | g4480 | i0 | 56.7 | 0.661764705882353 | 60 | 26 | 66.2 | 0 | 79 | 258 | 1 | 60 | HEY8550495.1 ATP-binding protein [Vicinamibacterales bacterium] | diamond | 180 | 73.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28475034 | 28475034 | PRJNA795663_S_NODE_9986_length_193_cov_1.717949_g9881_i0 | PRJNA795663 | 9986 | 193 | 1.717949 | 3.31564157 | Terriglobus roseus | 392734 | Bacteria | Bacteria | 101 | 4.209999999999999e-24 | NR | WP_014785699.1 | 392734 | g9881 | i0 | 75 | 0.994818652849741 | 64 | 16 | 99.5 | 0 | 193 | 2 | 173 | 236 | WP_014785699.1 flagellar type III secretion system pore protein FliP [Terriglobus roseus] | diamond | 192 | 101 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus roseus | ||
| 29548313 | 29548313 | PRJNA795663_S_NODE_13010_length_174_cov_1.131387_g12905_i0 | PRJNA795663 | 13010 | 174 | 1.131387 | 1.96861338 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 68.6 | 8.08e-12 | NR | MCY4638120.1 | 1978231 | g12905 | i0 | 56.1 | 2.94827586206897 | 57 | 25 | 98.3 | 0 | 2 | 172 | 219 | 275 | MCY4638120.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 513 | 68.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29674454 | 29674454 | PRJNA795663_S_NODE_4490_length_275_cov_2.063025_g4385_i0 | PRJNA795663 | 4490 | 275 | 2.063025 | 5.67331875 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 89 | 6.27e-20 | NR | HLI76697.1 | 2052142 | g4385 | i0 | 78.8 | 0.567272727272727 | 52 | 11 | 56.7 | 0 | 161 | 6 | 1 | 52 | HLI76697.1 Hsp20/alpha crystallin family protein [Acidobacteriaceae bacterium] | diamond | 156 | 89 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30116877 | 30116877 | PRJNA795663_S_NODE_10452_length_189_cov_2.467105_g10347_i0 | PRJNA795663 | 10452 | 189 | 2.467105 | 4.66282845 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 98.6 | 2.1699999999999994e-24 | NR | MBK7708216.1 | 1978231 | g10347 | i0 | 79.4 | 2 | 63 | 13 | 100 | 0 | 1 | 189 | 65 | 127 | MBK7708216.1 fasciclin domain-containing protein [Acidobacteriota bacterium] | diamond | 378 | 98.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30180089 | 30180089 | PRJNA795663_S_NODE_17312_length_155_cov_1.932203_g17207_i0 | PRJNA795663 | 17312 | 155 | 1.932203 | 2.99491465 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 88.2 | 1.08e-18 | NR | HYP28682.1 | 2052146 | g17207 | i0 | 87 | 1.81935483870968 | 46 | 6 | 89 | 0 | 2 | 139 | 749 | 794 | HYP28682.1 M1 family metallopeptidase [Blastocatellia bacterium] | diamond | 282 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31791983 | 31791983 | PRJNA795663_S_NODE_9017_length_201_cov_2.109756_g8912_i0 | PRJNA795663 | 9017 | 201 | 2.109756 | 4.24060956 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 85.5 | 2.92e-18 | NR | HLI84964.1 | 2212468 | g8912 | i0 | 64.4 | 0.880597014925373 | 59 | 21 | 88.1 | 0 | 17 | 193 | 109 | 167 | HLI84964.1 PP2C family serine/threonine-protein phosphatase [Bryobacteraceae bacterium] | diamond | 177 | 85.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32172075 | 32172075 | PRJNA795663_S_NODE_5498_length_250_cov_1.267606_g5393_i0 | PRJNA795663 | 5498 | 250 | 1.267606 | 3.169015 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 77.4 | 4.37e-16 | NR | MBA3440242.1 | 2283092 | g5393 | i0 | 73.2 | 1.044 | 41 | 11 | 49.2 | 0 | 127 | 5 | 11 | 51 | MBA3440242.1 transposase [Pyrinomonadaceae bacterium] | diamond | 261 | 77.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32654886 | 32654886 | PRJNA795663_S_NODE_15040_length_164_cov_1.204724_g14935_i0 | PRJNA795663 | 15040 | 164 | 1.204724 | 1.97574736 | Bacteria | 2 | Bacteria | Bacteria | 87 | 7.2e-20 | NR | MBK5297403.1 | 2793154 | g14935 | i0 | 77.4 | 2.90853658536585 | 53 | 12 | 97 | 0 | 162 | 4 | 29 | 81 | MBK5297403.1 YjbQ family protein [Vicinamibacteria bacterium] | diamond | 477 | 87.8 | 0.990888382687927 | 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);;