contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB80557" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1413645 | 1413645 | PRJEB80557_S_NODE_15262_length_240_cov_1.261780_g14866_i0 | PRJEB80557 | 15262 | 240 | 1.26178 | 3.028272 | Pyrinomonas | 1562565 | Bacteria | Bacteria | 105 | 1.67e-25 | NR | WP_041976015.1 | 454194 | g14866 | i0 | 71 | 1.725 | 69 | 20 | 86.3 | 0 | 1 | 207 | 72 | 140 | WP_041976015.1 flagellar motor protein MotB [Pyrinomonas methylaliphatogenes] | diamond | 414 | 105 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonas | Pyrinomonas methylaliphatogenes | ||
| 12892751 | 12892751 | PRJEB80557_S_NODE_8771_length_306_cov_1.408560_g8375_i0 | PRJEB80557 | 8771 | 306 | 1.40856 | 4.3101936 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 124 | 1.59e-30 | NR | HVH90456.1 | 3069120 | g8375 | i0 | 85.3 | 0.666666666666667 | 68 | 10 | 66.7 | 0 | 305 | 102 | 455 | 522 | HVH90456.1 DNA polymerase [Candidatus Acidiferrum sp.] | diamond | 204 | 124 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 15441645 | 15441645 | PRJEB80557_S_NODE_33673_length_168_cov_0.873950_g33277_i0 | PRJEB80557 | 33673 | 168 | 0.87395 | 1.468236 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 91.7 | 2.71e-20 | NR | MEP7305382.1 | 1978231 | g33277 | i0 | 88.5 | 2.82142857142857 | 52 | 6 | 92.9 | 0 | 156 | 1 | 34 | 85 | MEP7305382.1 sodium/proton-translocating pyrophosphatase [Acidobacteriota bacterium] | diamond | 474 | 91.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28234188 | 28234188 | PRJEB80557_S_NODE_4146_length_412_cov_2.845730_g3750_i0 | PRJEB80557 | 4146 | 412 | 2.84573 | 11.7244076 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 76.3 | 5.65e-14 | NR | MBD0371117.1 | 2283092 | g3750 | i0 | 67.2 | 0.422330097087379 | 58 | 18 | 41.5 | 1 | 80 | 250 | 151 | 208 | MBD0371117.1 VWA domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 174 | 76.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29087067 | 29087067 | PRJEB80557_S_NODE_25208_length_192_cov_1.083916_g24812_i0 | PRJEB80557 | 25208 | 192 | 1.083916 | 2.08111872 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 90.5 | 2e-19 | NR | HVL69247.1 | 2910147 | g24812 | i0 | 71.4 | 0.984375 | 63 | 18 | 98.4 | 0 | 3 | 191 | 235 | 297 | HVL69247.1 VWA domain-containing protein [Vicinamibacterales bacterium] | diamond | 189 | 90.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29939666 | 29939666 | PRJEB80557_S_NODE_26031_length_189_cov_1.392857_g25635_i0 | PRJEB80557 | 26031 | 189 | 1.392857 | 2.63249973 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 59.3 | 6.3e-9 | NR | HVH91277.1 | 3069120 | g25635 | i0 | 52.8 | 0.841269841269841 | 53 | 25 | 84.1 | 0 | 162 | 4 | 33 | 85 | HVH91277.1 hypothetical protein [Candidatus Acidiferrum sp.] | diamond | 159 | 59.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 30595515 | 30595515 | PRJEB80557_S_NODE_28173_length_182_cov_1.533835_g27777_i0 | PRJEB80557 | 28173 | 182 | 1.533835 | 2.7915797 | Bacteria | 2 | Bacteria | Bacteria | 90.1 | 3.24e-19 | NR | MBI2149991.1 | 1978231 | g27777 | i0 | 71.9 | 3.77472527472527 | 57 | 16 | 94 | 0 | 177 | 7 | 264 | 320 | MBI2149991.1 methylmalonyl-CoA mutase [Acidobacteriota bacterium] | diamond | 687 | 90.5 | 0.995580110497237 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31867375 | 31867375 | PRJEB80557_S_NODE_32937_length_169_cov_1.741667_g32541_i0 | PRJEB80557 | 32937 | 169 | 1.741667 | 2.94341723 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 41.6 | 0.0365 | NR | MDT7541686.1 | 1978231 | g32541 | i0 | 45.2 | 0.745562130177515 | 42 | 23 | 74.6 | 0 | 151 | 26 | 239 | 280 | MDT7541686.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 126 | 41.6 | 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);;