contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5079330 | 5079330 | PRJNA915212_P_NODE_804_length_739_cov_1.173913_g777_i0 | PRJNA915212 | 804 | 739 | 1.173913 | 8.67521707 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 333 | 2.3199999999999994e-104 | NR | MEO8499666.1 | 2793154 | g777 | i0 | 64.6 | 36.2841677943166 | 246 | 84 | 99.1 | 2 | 6 | 737 | 597 | 841 | MEO8499666.1 aminomethyl-transferring glycine dehydrogenase [Vicinamibacteria bacterium] | diamond | 26814 | 333 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 26651761 | 26651761 | PRJNA915212_P_NODE_161_length_1448_cov_2.264475_g151_i0 | PRJNA915212 | 161 | 1448 | 2.264475 | 32.789598 | Bacteria | 2 | Bacteria | Bacteria | 103 | 4.58e-19 | NR | MCZ6489067.1 | 1978231 | g151 | i0 | 32 | 3.91988950276243 | 281 | 147 | 54.1 | 11 | 1386 | 604 | 257 | 513 | MCZ6489067.1 SMP-30/gluconolactonase/LRE family protein [Acidobacteriota bacterium] | diamond | 5676 | 104 | 0.990384615384615 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27087882 | 27087882 | PRJNA915212_P_NODE_1022_length_662_cov_1.986949_g991_i0 | PRJNA915212 | 1022 | 662 | 1.986949 | 13.15360238 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 87.8 | 5.75e-16 | NR | PYP99840.1 | 1978231 | g991 | i0 | 36.6 | 0.829305135951662 | 183 | 99 | 82.5 | 5 | 553 | 8 | 174 | 340 | PYP99840.1 MAG: hypothetical protein DMF83_29675, partial [Acidobacteriota bacterium] | diamond | 549 | 87.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27245801 | 27245801 | PRJNA915212_P_NODE_8703_length_198_cov_0.872483_g8665_i0 | PRJNA915212 | 8703 | 198 | 0.872483 | 1.72751634 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 42 | 0.0361 | NR | HEV8394980.1 | 2910147 | g8665 | i0 | 37.3 | 0.893939393939394 | 59 | 36 | 87.9 | 1 | 194 | 21 | 201 | 259 | HEV8394980.1 class I SAM-dependent methyltransferase [Vicinamibacterales bacterium] | diamond | 177 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27467113 | 27467113 | PRJNA915212_P_NODE_2243_length_439_cov_1.287179_g2207_i0 | PRJNA915212 | 2243 | 439 | 1.287179 | 5.65071581 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 50.1 | 4.57e-4 | NR | HEX7529112.1 | 2651171 | g2207 | i0 | 46.4 | 1.42141230068337 | 69 | 23 | 37.6 | 3 | 97 | 261 | 5 | 73 | HEX7529112.1 DnaJ domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 624 | 50.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27561463 | 27561463 | PRJNA915212_P_NODE_12784_length_165_cov_0.879310_g12746_i0 | PRJNA915212 | 12784 | 165 | 0.87931 | 1.4508615 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 38.9 | 0.0426 | NR | HRH41715.1 | 2283092 | g12746 | i0 | 50 | 0.618181818181818 | 34 | 17 | 61.8 | 0 | 35 | 136 | 2 | 35 | HRH41715.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 102 | 38.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28287734 | 28287734 | PRJNA915212_P_NODE_8486_length_200_cov_1.013245_g8448_i0 | PRJNA915212 | 8486 | 200 | 1.013245 | 2.02649 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 78.2 | 6.47e-15 | NR | HSR53763.1 | 1978231 | g8448 | i0 | 58.7 | 7.755 | 63 | 26 | 94.5 | 0 | 190 | 2 | 300 | 362 | HSR53763.1 M20/M25/M40 family metallo-hydrolase [Acidobacteriota bacterium] | diamond | 1551 | 78.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28548082 | 28548082 | PRJNA915212_P_NODE_2727_length_390_cov_1.428152_g2691_i0 | PRJNA915212 | 2727 | 390 | 1.428152 | 5.5697928 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.6 | 4.39e-7 | NR | GMR22506.1 | 1978231 | g2691 | i0 | 29.9 | 2.99230769230769 | 97 | 59 | 73.8 | 2 | 334 | 47 | 3 | 91 | GMR22506.1 MAG: hypothetical protein BMS9Abin37_0861 [Acidobacteriota bacterium] | diamond | 1167 | 56.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28603719 | 28603719 | PRJNA915212_P_NODE_67_length_1919_cov_2.634225_g62_i0 | PRJNA915212 | 67 | 1919 | 2.634225 | 50.55077775 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 189 | 2.05e-46 | NR | HMV46425.1 | 2052146 | g62 | i0 | 49 | 1.16310578426264 | 259 | 110 | 38.1 | 8 | 10 | 741 | 285 | 536 | HMV46425.1 DUF4394 domain-containing protein [Blastocatellia bacterium] | diamond | 2232 | 189 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29487539 | 29487539 | PRJNA915212_P_NODE_5970_length_241_cov_2.968750_g5932_i0 | PRJNA915212 | 5970 | 241 | 2.96875 | 7.1546875 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0371 | NR | MDQ2777199.1 | 1978231 | g5932 | i0 | 33.9 | 0.734439834024896 | 59 | 38 | 72.2 | 1 | 196 | 23 | 476 | 534 | MDQ2777199.1 tetratricopeptide repeat protein [Acidobacteriota bacterium] | diamond | 177 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29550681 | 29550681 | PRJNA915212_P_NODE_1070_length_645_cov_1.454698_g1039_i0 | PRJNA915212 | 1070 | 645 | 1.454698 | 9.3828021 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 270 | 1.3299999999999993e-87 | NR | MFN7922683.1 | 2212468 | g1039 | i0 | 61.3 | 16.7255813953488 | 212 | 78 | 98.6 | 1 | 6 | 641 | 6 | 213 | MFN7922683.1 aldolase/citrate lyase family protein [Bryobacteraceae bacterium] | diamond | 10788 | 270 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29866677 | 29866677 | PRJNA915212_P_NODE_8871_length_196_cov_0.925170_g8833_i0 | PRJNA915212 | 8871 | 196 | 0.92517 | 1.8133332 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 49.3 | 1.01e-4 | NR | HEU4687149.1 | 2910147 | g8833 | i0 | 49.2 | 0.994897959183674 | 65 | 32 | 99.5 | 1 | 1 | 195 | 249 | 312 | HEU4687149.1 Calx-beta domain-containing protein [Vicinamibacterales bacterium] | diamond | 195 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29937237 | 29937237 | PRJNA915212_P_NODE_6631_length_227_cov_1.938202_g6593_i0 | PRJNA915212 | 6631 | 227 | 1.938202 | 4.39971854 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.2 | 5.35e-7 | NR | MBK9375779.1 | 2478486 | g6593 | i0 | 47.9 | 10.1762114537445 | 71 | 34 | 89.9 | 2 | 3 | 206 | 462 | 532 | MBK9375779.1 M4 family metallopeptidase [Holophagales bacterium] | diamond | 2310 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagales bacterium | ||||
| 30150733 | 30150733 | PRJNA915212_P_NODE_7152_length_219_cov_0.900000_g7114_i0 | PRJNA915212 | 7152 | 219 | 0.9 | 1.971 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 58.2 | 8.78e-8 | NR | MEO6392033.1 | 2283092 | g7114 | i0 | 41.4 | 0.958904109589041 | 70 | 36 | 93.2 | 2 | 219 | 16 | 149 | 215 | MEO6392033.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 210 | 58.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30214028 | 30214028 | PRJNA915212_P_NODE_5572_length_251_cov_1.252475_g5534_i0 | PRJNA915212 | 5572 | 251 | 1.252475 | 3.14371225 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 93.6 | 3.34e-20 | NR | HEU4387416.1 | 2052146 | g5534 | i0 | 62.9 | 0.836653386454183 | 70 | 26 | 83.7 | 0 | 40 | 249 | 247 | 316 | HEU4387416.1 D-alanyl-D-alanine carboxypeptidase family protein [Blastocatellia bacterium] | diamond | 210 | 93.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30782861 | 30782861 | PRJNA915212_P_NODE_3474_length_336_cov_1.595819_g3437_i0 | PRJNA915212 | 3474 | 336 | 1.595819 | 5.36195184 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 50.1 | 2.22e-4 | NR | HVG31754.1 | 2283092 | g3437 | i0 | 41.1 | 1.32142857142857 | 73 | 41 | 65.2 | 1 | 331 | 113 | 159 | 229 | HVG31754.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 444 | 50.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30877642 | 30877642 | PRJNA915212_P_NODE_9654_length_187_cov_1.108696_g9616_i0 | PRJNA915212 | 9654 | 187 | 1.108696 | 2.07326152 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 50.1 | 4.69e-5 | NR | HSS49596.1 | 2651171 | g9616 | i0 | 41.4 | 0.93048128342246 | 58 | 31 | 88.2 | 2 | 175 | 11 | 316 | 373 | HSS49596.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 174 | 50.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 31794355 | 31794355 | PRJNA915212_P_NODE_5757_length_246_cov_1.553299_g5719_i0 | PRJNA915212 | 5757 | 246 | 1.553299 | 3.82111554 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 50.8 | 5.11e-5 | NR | HEY2150812.1 | 2910147 | g5719 | i0 | 45 | 0.731707317073171 | 60 | 32 | 72 | 1 | 242 | 66 | 308 | 367 | HEY2150812.1 dipeptidase [Vicinamibacterales bacterium] | diamond | 180 | 50.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32529879 | 32529879 | PRJNA915212_P_NODE_9199_length_192_cov_0.895105_g9161_i0 | PRJNA915212 | 9199 | 192 | 0.895105 | 1.7186016 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 78.6 | 1.01e-15 | NR | HEX8888952.1 | 2283092 | g9161 | i0 | 52.4 | 7.875 | 63 | 29 | 98.4 | 1 | 2 | 190 | 63 | 124 | HEX8888952.1 pyridoxamine 5'-phosphate oxidase family protein [Pyrinomonadaceae bacterium] | diamond | 1512 | 79 | 0.994936708860759 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32868808 | 32868808 | PRJNA915212_P_NODE_11320_length_170_cov_1.264463_g11282_i0 | PRJNA915212 | 11320 | 170 | 1.264463 | 2.1495871 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 47 | 4.44e-4 | NR | MBL8172620.1 | 1978231 | g11282 | i0 | 51 | 0.864705882352941 | 49 | 23 | 86.5 | 1 | 154 | 8 | 454 | 501 | MBL8172620.1 M20/M25/M40 family metallo-hydrolase [Acidobacteriota bacterium] | diamond | 147 | 47 | 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);;