contig_metadata
20 rows where bioproject = "PRJNA1115053" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1503546 | 1503546 | PRJNA1115053_S_NODE_52362_length_331_cov_2.934028_g50545_i0 | PRJNA1115053 | 52362 | 331 | 2.934028 | 9.71163268 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 340 | 5.94e-89 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g50545 | i0 | 85.893 | 43.4078549848943 | 319 | 45 | 96 | 0 | 6 | 324 | 3557986 | 3557668 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 14368 | 340 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 9154919 | 9154919 | PRJNA1115053_S_NODE_30488_length_399_cov_6.806180_g28676_i0 | PRJNA1115053 | 30488 | 399 | 6.80618 | 27.1566582 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 176 | 2.17e-39 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g28676 | i0 | 77.918 | 3.6516290726817 | 317 | 47 | 77 | 19 | 68 | 374 | 3020140 | 3019837 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 1457 | 176 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 19351037 | 19351037 | PRJNA1115053_S_NODE_214376_length_188_cov_1.324138_g212559_i0 | PRJNA1115053 | 214376 | 188 | 1.324138 | 2.48937944 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 82.8 | 4.53e-17 | NR | MDQ3321255.1 | 1978231 | g212559 | i0 | 74.1 | 1.72340425531915 | 54 | 14 | 86.2 | 0 | 27 | 188 | 235 | 288 | MDQ3321255.1 phosphate/phosphite/phosphonate ABC transporter substrate-binding protein [Acidobacteriota bacterium] | diamond | 324 | 82.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27036371 | 27036371 | PRJNA1115053_S_NODE_227082_length_183_cov_1.800000_g225265_i0 | PRJNA1115053 | 227082 | 183 | 1.8 | 3.294 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 41.6 | 0.0371 | NR | MDX6458592.1 | 2052142 | g225265 | i0 | 46.3 | 1.19672131147541 | 41 | 22 | 67.2 | 0 | 179 | 57 | 46 | 86 | MDX6458592.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 219 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 27352724 | 27352724 | PRJNA1115053_S_NODE_194903_length_196_cov_1.568627_g193086_i0 | PRJNA1115053 | 194903 | 196 | 1.568627 | 3.07450892 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 93.2 | 1.44e-21 | NR | HEX8287632.1 | 2283092 | g193086 | i0 | 75 | 1.95918367346939 | 64 | 16 | 98 | 0 | 3 | 194 | 63 | 126 | HEX8287632.1 HAD family hydrolase [Pyrinomonadaceae bacterium] | diamond | 384 | 93.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27415920 | 27415920 | PRJNA1115053_S_NODE_274003_length_168_cov_1.984000_g272186_i0 | PRJNA1115053 | 274003 | 168 | 1.984 | 3.33312 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 40.8 | 0.0212 | NR | HEY5444364.1 | 2283092 | g272186 | i0 | 33.3 | 0.75 | 42 | 25 | 75 | 1 | 27 | 152 | 37 | 75 | HEY5444364.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 126 | 40.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28710353 | 28710353 | PRJNA1115053_S_NODE_137187_length_228_cov_1.324324_g135370_i0 | PRJNA1115053 | 137187 | 228 | 1.324324 | 3.01945872 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 68.2 | 1.26e-12 | NR | HEX8251201.1 | 2283092 | g135370 | i0 | 73.3 | 0.986842105263158 | 75 | 16 | 98.7 | 1 | 1 | 225 | 9 | 79 | HEX8251201.1 BON domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 225 | 68.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28963004 | 28963004 | PRJNA1115053_S_NODE_178308_length_204_cov_1.192547_g176491_i0 | PRJNA1115053 | 178308 | 204 | 1.192547 | 2.43279588 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 90.9 | 5.930000000000001e-21 | NR | HEY0051392.1 | 2283092 | g176491 | i0 | 72.3 | 0.955882352941177 | 65 | 18 | 95.6 | 0 | 2 | 196 | 98 | 162 | HEY0051392.1 Spy/CpxP family protein refolding chaperone [Pyrinomonadaceae bacterium] | diamond | 195 | 90.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28994629 | 28994629 | PRJNA1115053_S_NODE_106308_length_253_cov_1.600000_g104491_i0 | PRJNA1115053 | 106308 | 253 | 1.6 | 4.048 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.1 | 0.032 | NR | HEY6217504.1 | 2283092 | g104491 | i0 | 33.8 | 1.54150197628458 | 65 | 34 | 66.4 | 1 | 25 | 192 | 488 | 552 | HEY6217504.1 PQQ-dependent sugar dehydrogenase [Pyrinomonadaceae bacterium] | diamond | 390 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29026247 | 29026247 | PRJNA1115053_S_NODE_200948_length_193_cov_3.026667_g199131_i0 | PRJNA1115053 | 200948 | 193 | 3.026667 | 5.84146731 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 42 | 0.0289 | NR | HYM05365.1 | 2282142 | g199131 | i0 | 38.6 | 1.0880829015544 | 70 | 32 | 91.7 | 1 | 3 | 179 | 76 | 145 | HYM05365.1 isoprenylcysteine carboxylmethyltransferase family protein [Terriglobales bacterium] | diamond | 210 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 29120864 | 29120864 | PRJNA1115053_S_NODE_205869_length_191_cov_2.594595_g204052_i0 | PRJNA1115053 | 205869 | 191 | 2.594595 | 4.95567645 | Holophagaceae bacterium | 2052165 | Bacteria | Bacteria | 41.6 | 0.0271 | NR | HJV89555.1 | 2052165 | g204052 | i0 | 41.1 | 0.879581151832461 | 56 | 29 | 88 | 2 | 24 | 191 | 44 | 95 | HJV89555.1 hypothetical protein [Holophagaceae bacterium] | diamond | 168 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae bacterium | |||
| 29183994 | 29183994 | PRJNA1115053_S_NODE_216689_length_187_cov_1.666667_g214872_i0 | PRJNA1115053 | 216689 | 187 | 1.666667 | 3.11666729 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 41.6 | 0.0457 | NR | HEU0184367.1 | 2052146 | g214872 | i0 | 36.8 | 0.609625668449198 | 38 | 24 | 61 | 0 | 154 | 41 | 300 | 337 | HEU0184367.1 hypothetical protein [Blastocatellia bacterium] | diamond | 114 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29404836 | 29404836 | PRJNA1115053_S_NODE_181589_length_202_cov_1.811321_g179772_i0 | PRJNA1115053 | 181589 | 202 | 1.811321 | 3.65886842 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 111 | 4.630000000000001e-27 | NR | HQU81800.1 | 2283092 | g179772 | i0 | 83.6 | 0.995049504950495 | 67 | 11 | 99.5 | 0 | 202 | 2 | 35 | 101 | HQU81800.1 cupredoxin domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 201 | 111 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29499458 | 29499458 | PRJNA1115053_S_NODE_144670_length_223_cov_1.311111_g142853_i0 | PRJNA1115053 | 144670 | 223 | 1.311111 | 2.92377753 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 42.7 | 0.0296 | NR | HEY2544787.1 | 3069120 | g142853 | i0 | 32.8 | 0.820627802690583 | 61 | 41 | 82.1 | 0 | 32 | 214 | 5 | 65 | HEY2544787.1 DNA polymerase I [Candidatus Acidiferrum sp.] | diamond | 183 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 30099430 | 30099430 | PRJNA1115053_S_NODE_129872_length_233_cov_1.768421_g128055_i0 | PRJNA1115053 | 129872 | 233 | 1.768421 | 4.12042093 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 42.7 | 0.0318 | NR | MFL6439215.1 | 2282142 | g128055 | i0 | 41.7 | 0.618025751072961 | 48 | 25 | 61.8 | 1 | 209 | 66 | 80 | 124 | MFL6439215.1 glycosyltransferase [Terriglobales bacterium] | diamond | 144 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 32186175 | 32186175 | PRJNA1115053_S_NODE_279038_length_167_cov_1.161290_g277221_i0 | PRJNA1115053 | 279038 | 167 | 1.16129 | 1.9393543 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42 | 0.0249 | NR | MEE2636171.1 | 1978231 | g277221 | i0 | 50 | 0.646706586826347 | 36 | 18 | 64.7 | 0 | 39 | 146 | 139 | 174 | MEE2636171.1 ComEC/Rec2 family competence protein [Acidobacteriota bacterium] | diamond | 108 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32217782 | 32217782 | PRJNA1115053_S_NODE_110318_length_249_cov_2.097087_g108501_i0 | PRJNA1115053 | 110318 | 249 | 2.097087 | 5.22174663 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.5 | 0.022 | NR | HEX9425746.1 | 2283092 | g108501 | i0 | 46.2 | 1.87951807228916 | 52 | 25 | 62.7 | 1 | 245 | 90 | 848 | 896 | HEX9425746.1 glucoamylase family protein [Pyrinomonadaceae bacterium] | diamond | 468 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32249710 | 32249710 | PRJNA1115053_S_NODE_233218_length_181_cov_1.471014_g231401_i0 | PRJNA1115053 | 233218 | 181 | 1.471014 | 2.66253534 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 41.2 | 0.0161 | NR | HEX7778990.1 | 2910147 | g231401 | i0 | 44.4 | 0.74585635359116 | 45 | 25 | 74.6 | 0 | 2 | 136 | 44 | 88 | HEX7778990.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 135 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32407631 | 32407631 | PRJNA1115053_S_NODE_118099_length_242_cov_2.633166_g116282_i0 | PRJNA1115053 | 118099 | 242 | 2.633166 | 6.37226172 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 40 | 0.0488 | NR | MFV0388867.1 | 2283092 | g116282 | i0 | 51.6 | 0.384297520661157 | 31 | 15 | 38.4 | 0 | 240 | 148 | 28 | 58 | MFV0388867.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 93 | 40 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32880576 | 32880576 | PRJNA1115053_S_NODE_278860_length_167_cov_1.161290_g277043_i0 | PRJNA1115053 | 278860 | 167 | 1.16129 | 1.9393543 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 42.7 | 0.00346 | NR | HXD19284.1 | 2910147 | g277043 | i0 | 50 | 0.574850299401198 | 32 | 16 | 57.5 | 0 | 1 | 96 | 62 | 93 | HXD19284.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 96 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales 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);;