contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6123609 | 6123609 | PRJNA1108487_P_NODE_4045_length_345_cov_1.128676_g3979_i0 | PRJNA1108487 | 4045 | 345 | 1.128676 | 3.8939322 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 1.61e-30 | NR | MCS6817120.1 | 2052146 | g3979 | i0 | 77.5 | 5.82608695652174 | 80 | 18 | 69.6 | 0 | 36 | 275 | 1371 | 1450 | MCS6817120.1 glutamate synthase large subunit [Blastocatellia bacterium] | diamond | 2010 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 9141040 | 9141040 | PRJNA1108487_P_NODE_3308_length_375_cov_1.549669_g3242_i0 | PRJNA1108487 | 3308 | 375 | 1.549669 | 5.81125875 | Bacteria | 2 | Bacteria | Bacteria | 194 | 3.29e-57 | NR | MEA2489257.1 | 1978231 | g3242 | i0 | 74.8 | 46.152 | 119 | 30 | 95.2 | 0 | 2 | 358 | 321 | 439 | MEA2489257.1 adenosylhomocysteinase [Acidobacteriota bacterium] | diamond | 17307 | 195 | 0.994871794871795 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 9141084 | 9141084 | PRJNA1108487_P_NODE_8908_length_251_cov_0.876404_g8842_i0 | PRJNA1108487 | 8908 | 251 | 0.876404 | 2.19977404 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 60.5 | 2.34e-8 | NR | HYW48003.1 | 2212468 | g8842 | i0 | 49.4 | 1.92430278884462 | 81 | 38 | 95.6 | 2 | 11 | 250 | 16 | 94 | HYW48003.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 483 | 60.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 11692106 | 11692106 | PRJNA1108487_P_NODE_4030_length_345_cov_1.687500_g3964_i0 | PRJNA1108487 | 4030 | 345 | 1.6875 | 5.821875 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 125 | 1.1e-31 | NR | HXY49553.1 | 2282142 | g3964 | i0 | 75.6 | 2.03478260869565 | 78 | 17 | 67.8 | 1 | 1 | 234 | 244 | 319 | HXY49553.1 glycoside hydrolase family 27 protein [Terriglobales bacterium] | diamond | 702 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 11692126 | 11692126 | PRJNA1108487_P_NODE_7610_length_263_cov_1.642105_g7544_i0 | PRJNA1108487 | 7610 | 263 | 1.642105 | 4.31873615 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 117 | 9.59e-29 | NR | HEV2273247.1 | 2052142 | g7544 | i0 | 59.8 | 4.95057034220532 | 87 | 33 | 99.2 | 1 | 2 | 262 | 339 | 423 | HEV2273247.1 malate synthase A [Acidobacteriaceae bacterium] | diamond | 1302 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 27288971 | 27288971 | PRJNA1108487_P_NODE_1803_length_503_cov_0.997674_g1737_i0 | PRJNA1108487 | 1803 | 503 | 0.997674 | 5.01830022 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 55.1 | 2.4e-5 | NR | MBN1566786.1 | 1978231 | g1737 | i0 | 65.9 | 0.495029821073559 | 41 | 14 | 24.5 | 0 | 2 | 124 | 2 | 42 | MBN1566786.1 WD40 repeat domain-containing protein [Acidobacteriota bacterium] | diamond | 249 | 55.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27352442 | 27352442 | PRJNA1108487_P_NODE_10083_length_246_cov_0.901734_g10017_i0 | PRJNA1108487 | 10083 | 246 | 0.901734 | 2.21826564 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 103 | 1.56e-23 | NR | HET6890628.1 | 2283092 | g10017 | i0 | 64.1 | 5.63414634146341 | 78 | 24 | 95.1 | 2 | 234 | 1 | 504 | 577 | HET6890628.1 M28 family metallopeptidase [Pyrinomonadaceae bacterium] | diamond | 1386 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27604991 | 27604991 | PRJNA1108487_P_NODE_4824_length_320_cov_0.947368_g4758_i0 | PRJNA1108487 | 4824 | 320 | 0.947368 | 3.0315776 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 58.2 | 2.88e-7 | NR | MEO6392033.1 | 2283092 | g4758 | i0 | 41 | 0.778125 | 83 | 44 | 75.9 | 2 | 318 | 76 | 141 | 220 | MEO6392033.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 249 | 58.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27911597 | 27911597 | PRJNA1108487_P_NODE_10505_length_245_cov_0.906977_g10439_i0 | PRJNA1108487 | 10505 | 245 | 0.906977 | 2.22209365 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.4 | 0.0441 | NR | HWU00312.1 | 2282142 | g10439 | i0 | 46.9 | 0.783673469387755 | 32 | 14 | 39.2 | 1 | 197 | 102 | 141 | 169 | HWU00312.1 CpaD family pilus assembly lipoprotein [Terriglobales bacterium] | diamond | 192 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27920476 | 27920476 | PRJNA1108487_P_NODE_2425_length_436_cov_1.261708_g2359_i0 | PRJNA1108487 | 2425 | 436 | 1.261708 | 5.50104688 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 133 | 5.04e-33 | NR | HZU31460.1 | 2976921 | g2359 | i0 | 50 | 5.00917431192661 | 146 | 67 | 99.8 | 2 | 2 | 436 | 605 | 745 | HZU31460.1 galactose oxidase-like domain-containing protein [Candidatus Angelobacter sp.] | diamond | 2184 | 133 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 28078346 | 28078346 | PRJNA1108487_P_NODE_3525_length_365_cov_1.602740_g3459_i0 | PRJNA1108487 | 3525 | 365 | 1.60274 | 5.850001 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 56.2 | 5.83e-7 | NR | MDX6498392.1 | 2052146 | g3459 | i0 | 50 | 0.410958904109589 | 50 | 25 | 41.1 | 0 | 160 | 309 | 14 | 63 | MDX6498392.1 hypothetical protein [Blastocatellia bacterium] | diamond | 150 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28299380 | 28299380 | PRJNA1108487_P_NODE_1646_length_524_cov_1.383592_g1580_i0 | PRJNA1108487 | 1646 | 524 | 1.383592 | 7.25002208 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 138 | 2.86e-36 | NR | MDR3737318.1 | 2052142 | g1580 | i0 | 45.8 | 2.87977099236641 | 179 | 86 | 99.6 | 5 | 2 | 523 | 118 | 290 | MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 1509 | 138 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 28394100 | 28394100 | PRJNA1108487_P_NODE_11246_length_242_cov_0.923077_g11180_i0 | PRJNA1108487 | 11246 | 242 | 0.923077 | 2.23384634 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 41.2 | 0.0367 | NR | HEY1257492.1 | 1964191 | g11180 | i0 | 34.6 | 1.00413223140496 | 81 | 41 | 85.5 | 2 | 240 | 34 | 18 | 98 | HEY1257492.1 STAS domain-containing protein [Terracidiphilus sp.] | diamond | 243 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 28732840 | 28732840 | PRJNA1108487_P_NODE_11087_length_243_cov_0.917647_g11021_i0 | PRJNA1108487 | 11087 | 243 | 0.917647 | 2.22988221 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 87 | 1.29e-18 | NR | MBW4077046.1 | 1978231 | g11021 | i0 | 53.4 | 1.87654320987654 | 73 | 33 | 88.9 | 1 | 237 | 22 | 90 | 162 | MBW4077046.1 class I SAM-dependent methyltransferase [Acidobacteriota bacterium] | diamond | 456 | 87.8 | 0.990888382687927 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29088879 | 29088879 | PRJNA1108487_P_NODE_7428_length_266_cov_1.616580_g7362_i0 | PRJNA1108487 | 7428 | 266 | 1.61658 | 4.3001028 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 50.1 | 1.25e-4 | NR | MEM7246052.1 | 1978231 | g7362 | i0 | 58.8 | 0.383458646616541 | 34 | 14 | 38.3 | 0 | 109 | 8 | 125 | 158 | MEM7246052.1 polynucleotide adenylyltransferase PcnB [Acidobacteriota bacterium] | diamond | 102 | 50.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29499193 | 29499193 | PRJNA1108487_P_NODE_3070_length_388_cov_1.574603_g3004_i0 | PRJNA1108487 | 3070 | 388 | 1.574603 | 6.10945964 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 64.3 | 5.34e-9 | NR | HTP31531.1 | 2952895 | g3004 | i0 | 36.5 | 0.804123711340206 | 104 | 55 | 75 | 2 | 3 | 293 | 2 | 101 | HTP31531.1 hypothetical protein [Candidatus Acidiferrales bacterium] | diamond | 312 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 29688403 | 29688403 | PRJNA1108487_P_NODE_11250_length_242_cov_0.923077_g11184_i0 | PRJNA1108487 | 11250 | 242 | 0.923077 | 2.23384634 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 60.5 | 2.02e-8 | NR | HLG12932.1 | 2052146 | g11184 | i0 | 48.3 | 3.24793388429752 | 58 | 29 | 70.7 | 1 | 237 | 67 | 340 | 397 | HLG12932.1 alkaline phosphatase D family protein [Blastocatellia bacterium] | diamond | 786 | 60.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29972944 | 29972944 | PRJNA1108487_P_NODE_4331_length_335_cov_0.877863_g4265_i0 | PRJNA1108487 | 4331 | 335 | 0.877863 | 2.94084105 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 45.8 | 0.00898 | NR | HTS64537.1 | 2952895 | g4265 | i0 | 38.5 | 2.85671641791045 | 91 | 40 | 67.2 | 3 | 242 | 18 | 169 | 259 | HTS64537.1 protein kinase [Candidatus Acidiferrales bacterium] | diamond | 957 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 30036178 | 30036178 | PRJNA1108487_P_NODE_6951_length_273_cov_2.285000_g6885_i0 | PRJNA1108487 | 6951 | 273 | 2.285 | 6.23805 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 47.4 | 0.00119 | NR | MBI1872622.1 | 1978231 | g6885 | i0 | 48 | 0.549450549450549 | 50 | 26 | 54.9 | 0 | 15 | 164 | 259 | 308 | MBI1872622.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 150 | 47.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31354661 | 31354661 | PRJNA1108487_P_NODE_9596_length_248_cov_0.891429_g9530_i0 | PRJNA1108487 | 9596 | 248 | 0.891429 | 2.21074392 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.1 | 0.0274 | NR | HEX8472706.1 | 2283092 | g9530 | i0 | 38.2 | 1.72983870967742 | 68 | 22 | 58.1 | 3 | 37 | 180 | 159 | 226 | HEX8472706.1 glycosyltransferase [Pyrinomonadaceae bacterium] | diamond | 429 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31417819 | 31417819 | PRJNA1108487_P_NODE_936_length_676_cov_1.265340_g874_i0 | PRJNA1108487 | 936 | 676 | 1.26534 | 8.5536984 | Bacteria | 2 | Bacteria | Bacteria | 283 | 1.27e-92 | NR | MEP7354945.1 | 1978231 | g874 | i0 | 62.3 | 20.7825443786982 | 223 | 80 | 99 | 1 | 675 | 7 | 34 | 252 | MEP7354945.1 aldolase/citrate lyase family protein [Acidobacteriota bacterium] | diamond | 14049 | 285 | 0.992982456140351 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31837576 | 31837576 | PRJNA1108487_P_NODE_1697_length_516_cov_2.769752_g1631_i0 | PRJNA1108487 | 1697 | 516 | 2.769752 | 14.29192032 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 138 | 2.57e-36 | NR | MDR3737318.1 | 2052142 | g1631 | i0 | 46.5 | 1.97674418604651 | 170 | 86 | 97.1 | 3 | 515 | 15 | 141 | 308 | MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 1020 | 138 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 32280946 | 32280946 | PRJNA1108487_P_NODE_539_length_871_cov_3.909774_g486_i0 | PRJNA1108487 | 539 | 871 | 3.909774 | 34.05413154 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 210 | 1.65e-62 | NR | HEY5837861.1 | 2283092 | g486 | i0 | 58.7 | 4.10907003444317 | 196 | 79 | 67.5 | 1 | 768 | 181 | 134 | 327 | HEY5837861.1 peptidoglycan-binding protein [Pyrinomonadaceae bacterium] | diamond | 3579 | 210 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;