contig_metadata
14 rows where bioproject = "PRJNA407087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27075440 | 27075440 | PRJNA407087_S_NODE_9742_length_152_cov_4.853659_g9279_i0 | PRJNA407087 | 9742 | 152 | 4.853659 | 7.37756168 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.00787 | NR | MFP5230548.1 | 1978231 | g9279 | i0 | 72 | 2.17105263157895 | 25 | 7 | 49.3 | 0 | 78 | 152 | 2 | 26 | MFP5230548.1 trans-sulfuration enzyme family protein [Acidobacteriota bacterium] | diamond | 330 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27802122 | 27802122 | PRJNA407087_S_NODE_8544_length_164_cov_2.481481_g8081_i0 | PRJNA407087 | 8544 | 164 | 2.481481 | 4.06962884 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 70.1 | 2.11e-12 | NR | HVT04722.1 | 2651171 | g8081 | i0 | 67.4 | 4.09756097560976 | 46 | 15 | 84.1 | 0 | 1 | 138 | 280 | 325 | HVT04722.1 alpha-ketoacid dehydrogenase subunit beta [Thermoanaerobaculia bacterium] | diamond | 672 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28906848 | 28906848 | PRJNA407087_S_NODE_1668_length_517_cov_3.594262_g1235_i0 | PRJNA407087 | 1668 | 517 | 3.594262 | 18.58233454 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 152 | 1.36e-40 | NR | MDQ3684652.1 | 1978231 | g1235 | i0 | 42.7 | 0.992263056092843 | 171 | 97 | 99.2 | 1 | 3 | 515 | 182 | 351 | MDQ3684652.1 Xaa-Pro aminopeptidase [Acidobacteriota bacterium] | diamond | 513 | 152 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29254159 | 29254159 | PRJNA407087_S_NODE_669_length_915_cov_14.645598_g415_i0 | PRJNA407087 | 669 | 915 | 14.645598 | 134.0072217 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 333 | 3.72e-111 | NR | MFN7922683.1 | 2212468 | g415 | i0 | 58.1 | 7.31803278688525 | 279 | 113 | 91.5 | 1 | 909 | 73 | 6 | 280 | MFN7922683.1 aldolase/citrate lyase family protein [Bryobacteraceae bacterium] | diamond | 6696 | 333 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29790959 | 29790959 | PRJNA407087_S_NODE_2651_length_386_cov_3.985994_g2190_i0 | PRJNA407087 | 2651 | 386 | 3.985994 | 15.38593684 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 54.7 | 7.59e-6 | NR | HJR06586.1 | 2283092 | g2190 | i0 | 35.4 | 2.09844559585492 | 127 | 78 | 97.9 | 3 | 380 | 3 | 62 | 185 | HJR06586.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 810 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29980702 | 29980702 | PRJNA407087_S_NODE_3011_length_352_cov_5.256966_g2549_i0 | PRJNA407087 | 3011 | 352 | 5.256966 | 18.50452032 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 164 | 2.2e-45 | NR | MDR3736461.1 | 2052142 | g2549 | i0 | 66.7 | 1.99431818181818 | 117 | 39 | 99.7 | 0 | 352 | 2 | 75 | 191 | MDR3736461.1 chaperonin GroEL [Acidobacteriaceae bacterium] | diamond | 702 | 164 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 29980709 | 29980709 | PRJNA407087_S_NODE_5991_length_206_cov_2.598870_g5528_i0 | PRJNA407087 | 5991 | 206 | 2.59887 | 5.3536722 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42 | 0.044 | NR | MDE2851875.1 | 1978231 | g5528 | i0 | 47.1 | 0.495145631067961 | 34 | 18 | 49.5 | 0 | 204 | 103 | 1042 | 1075 | MDE2851875.1 DEAD/DEAH box helicase [Acidobacteriota bacterium] | diamond | 102 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30643995 | 30643995 | PRJNA407087_S_NODE_2853_length_366_cov_8.109792_g2391_i0 | PRJNA407087 | 2853 | 366 | 8.109792 | 29.68183872 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 68.9 | 7.47e-11 | NR | MCB1025656.1 | 1978231 | g2391 | i0 | 40.5 | 1.18852459016393 | 79 | 47 | 64.8 | 0 | 3 | 239 | 131 | 209 | MCB1025656.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 435 | 68.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30770699 | 30770699 | PRJNA407087_S_NODE_5134_length_230_cov_3.358209_g4671_i0 | PRJNA407087 | 5134 | 230 | 3.358209 | 7.7238807 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 49.3 | 1.43e-4 | NR | MEO6392033.1 | 2283092 | g4671 | i0 | 48.9 | 1.0304347826087 | 45 | 23 | 58.7 | 0 | 216 | 82 | 176 | 220 | MEO6392033.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 237 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31546058 | 31546058 | PRJNA407087_S_NODE_1156_length_657_cov_7.648089_g784_i0 | PRJNA407087 | 1156 | 657 | 7.648089 | 50.24794473 | Bacteria | 2 | Bacteria | Bacteria | 224 | 1.1399999999999999e-69 | NR | MBI1358074.1 | 1978231 | g784 | i0 | 55.7 | 18.4246575342466 | 192 | 81 | 87.7 | 1 | 652 | 77 | 92 | 279 | MBI1358074.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 12105 | 225 | 0.995555555555556 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31592623 | 31592623 | PRJNA407087_S_NODE_4056_length_275_cov_3.764228_g3593_i0 | PRJNA407087 | 4056 | 275 | 3.764228 | 10.351627 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 65.9 | 1.73e-10 | NR | HEV7744066.1 | 2283092 | g3593 | i0 | 42.7 | 0.970909090909091 | 89 | 51 | 97.1 | 0 | 270 | 4 | 62 | 150 | HEV7744066.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 267 | 65.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32098566 | 32098566 | PRJNA407087_S_NODE_4118_length_272_cov_4.209877_g3655_i0 | PRJNA407087 | 4118 | 272 | 4.209877 | 11.45086544 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 61.6 | 7.56e-10 | NR | MBI3665728.1 | 1978231 | g3655 | i0 | 41.7 | 1.77573529411765 | 72 | 41 | 78.3 | 1 | 5 | 217 | 36 | 107 | MBI3665728.1 RNA-binding protein [Acidobacteriota bacterium] | diamond | 483 | 61.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32162049 | 32162049 | PRJNA407087_S_NODE_3718_length_294_cov_7.547170_g3255_i0 | PRJNA407087 | 3718 | 294 | 7.54717 | 22.1886798 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 70.1 | 1.25e-11 | NR | MCB1025656.1 | 1978231 | g3255 | i0 | 50 | 1.30612244897959 | 62 | 31 | 63.3 | 0 | 292 | 107 | 131 | 192 | MCB1025656.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 384 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32825087 | 32825087 | PRJNA407087_S_NODE_1600_length_532_cov_22.292247_g545_i2 | PRJNA407087 | 1600 | 532 | 22.292247 | 118.59475404 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 59.3 | 8.81e-7 | NR | MBS1873370.1 | 1978231 | g545 | i2 | 34.4 | 0.704887218045113 | 125 | 60 | 68.8 | 5 | 442 | 77 | 112 | 217 | MBS1873370.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 375 | 59.3 | 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);;