contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA694557" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 673288 | 673288 | PRJNA694557_P_NODE_17381_length_306_cov_2.030043_g17161_i0 | PRJNA694557 | 17381 | 306 | 2.030043 | 6.21193158 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.5 | 4.33e-18 | NR | WP_263356596.1 | 542300 | g17161 | i0 | 66.2 | 1.2843137254902 | 65 | 22 | 63.7 | 0 | 306 | 112 | 136 | 200 | WP_263356596.1 cation transporter [Acidicapsa ligni] | diamond | 393 | 85.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidicapsa | Acidicapsa ligni | ||
| 10877295 | 10877295 | PRJNA694557_P_NODE_17189_length_308_cov_3.153191_g16969_i0 | PRJNA694557 | 17189 | 308 | 3.153191 | 9.71182828 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 153 | 6.2299999999999996e-46 | NR | MDQ4122153.1 | 1978231 | g16969 | i0 | 94 | 0.808441558441558 | 83 | 5 | 80.8 | 0 | 308 | 60 | 21 | 103 | MDQ4122153.1 co-chaperone GroES [Acidobacteriota bacterium] | diamond | 249 | 153 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 14702322 | 14702322 | PRJNA694557_P_NODE_21512_length_266_cov_1.595855_g21292_i0 | PRJNA694557 | 21512 | 266 | 1.595855 | 4.2449743 | Candidatus Acidiferrum | 2817524 | Bacteria | Bacteria | 142 | 5.829999999999999e-38 | NR | HXB69149.1 | 2952895 | g21292 | i0 | 81.9 | 4.68045112781955 | 83 | 15 | 93.6 | 0 | 11 | 259 | 12 | 94 | HXB69149.1 N-6 DNA methylase [Candidatus Acidiferrales bacterium] | diamond | 1245 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 14702532 | 14702532 | PRJNA694557_P_NODE_9212_length_454_cov_3.866142_g8992_i0 | PRJNA694557 | 9212 | 454 | 3.866142 | 17.55228468 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 240 | 1.07e-75 | NR | MEO6051104.1 | 2283092 | g8992 | i0 | 82.8 | 1.95594713656388 | 145 | 25 | 95.8 | 0 | 436 | 2 | 89 | 233 | MEO6051104.1 threonine ammonia-lyase [Pyrinomonadaceae bacterium] | diamond | 888 | 240 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 19031212 | 19031212 | PRJNA694557_P_NODE_18335_length_295_cov_3.981982_g18115_i0 | PRJNA694557 | 18335 | 295 | 3.981982 | 11.7468469 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 174 | 1.99e-51 | NR | MBL8230456.1 | 2026791 | g18115 | i0 | 90.2 | 0.935593220338983 | 92 | 9 | 93.6 | 0 | 278 | 3 | 207 | 298 | MBL8230456.1 glycosyltransferase family 2 protein [Bryobacterales bacterium] | diamond | 276 | 174 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 22856938 | 22856938 | PRJNA694557_P_NODE_20938_length_271_cov_1.555556_g20718_i0 | PRJNA694557 | 20938 | 271 | 1.555556 | 4.21555676 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 136 | 3.7e-36 | NR | MBU6202576.1 | 1978231 | g20718 | i0 | 88.6 | 0.874538745387454 | 79 | 9 | 87.5 | 0 | 259 | 23 | 128 | 206 | MBU6202576.1 ABC transporter ATP-binding protein [Acidobacteriota bacterium] | diamond | 237 | 136 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27019324 | 27019324 | PRJNA694557_P_NODE_24522_length_246_cov_1.780347_g24302_i0 | PRJNA694557 | 24522 | 246 | 1.780347 | 4.37965362 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 103 | 8.11e-24 | NR | HSL81264.1 | 2651171 | g24302 | i0 | 56.3 | 0.975609756097561 | 80 | 35 | 97.6 | 0 | 4 | 243 | 340 | 419 | HSL81264.1 L,D-transpeptidase family protein [Thermoanaerobaculia bacterium] | diamond | 240 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27062261 | 27062261 | PRJNA694557_P_NODE_10442_length_420_cov_4.060519_g10222_i0 | PRJNA694557 | 10442 | 420 | 4.060519 | 17.0541798 | Bacteria | 2 | Bacteria | Bacteria | 238 | 8.580000000000001e-70 | NR | MBI2685981.1 | 1978231 | g10222 | i0 | 79.5 | 2.82857142857143 | 132 | 27 | 94.3 | 0 | 7 | 402 | 975 | 1106 | MBI2685981.1 TonB-dependent receptor [Acidobacteriota bacterium] | diamond | 1188 | 239 | 0.99581589958159 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27588199 | 27588199 | PRJNA694557_P_NODE_20484_length_275_cov_1.668317_g20264_i0 | PRJNA694557 | 20484 | 275 | 1.668317 | 4.58787175 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 181 | 6.18e-51 | NR | HEX9003066.1 | 2052146 | g20264 | i0 | 100 | 0.992727272727273 | 91 | 0 | 99.3 | 0 | 273 | 1 | 188 | 278 | HEX9003066.1 putative Ig domain-containing protein [Blastocatellia bacterium] | diamond | 273 | 181 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27840481 | 27840481 | PRJNA694557_P_NODE_21964_length_262_cov_2.179894_g21744_i0 | PRJNA694557 | 21964 | 262 | 2.179894 | 5.71132228 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 51.2 | 1.69e-5 | NR | HEY0429767.1 | 2283092 | g21744 | i0 | 66.7 | 0.377862595419847 | 33 | 11 | 37.8 | 0 | 112 | 14 | 124 | 156 | HEY0429767.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] | diamond | 99 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28440740 | 28440740 | PRJNA694557_P_NODE_4906_length_673_cov_1.775000_g4690_i0 | PRJNA694557 | 4906 | 673 | 1.775 | 11.94575 | Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11 | 1797187 | Bacteria | Bacteria | 365 | 1.45e-114 | NR | OFW03494.1 | 1797187 | g4690 | i0 | 83 | 0.945022288261516 | 212 | 36 | 94.5 | 0 | 2 | 637 | 863 | 1074 | OFW03494.1 MAG: hypothetical protein A3G20_06590, partial [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11] | diamond | 636 | 365 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11 | ||||||
| 28535499 | 28535499 | PRJNA694557_P_NODE_527_length_2182_cov_4.237079_g483_i0 | PRJNA694557 | 527 | 2182 | 4.237079 | 92.45306378 | Acidobacteria bacterium RBG_16_64_8 | 1797172 | Bacteria | Bacteria | 165 | 1.76e-40 | NR | OFV79361.1 | 1797172 | g483 | i0 | 44.7 | 0.261228230980752 | 190 | 102 | 26 | 2 | 2172 | 1606 | 130 | 317 | OFV79361.1 MAG: hypothetical protein A2W26_00100 [Acidobacteria bacterium RBG_16_64_8] | diamond | 570 | 165 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RBG_16_64_8 | ||||||
| 28598606 | 28598606 | PRJNA694557_P_NODE_15067_length_334_cov_3.394636_g14847_i0 | PRJNA694557 | 15067 | 334 | 3.394636 | 11.33808424 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 113 | 1.51e-26 | NR | MBX9604173.1 | 2212468 | g14847 | i0 | 74 | 0.655688622754491 | 73 | 19 | 65.6 | 0 | 221 | 3 | 4 | 76 | MBX9604173.1 glycosyl hydrolase [Bryobacteraceae bacterium] | diamond | 219 | 113 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29766567 | 29766567 | PRJNA694557_P_NODE_21671_length_264_cov_7.539267_g21451_i0 | PRJNA694557 | 21671 | 264 | 7.539267 | 19.90366488 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 85.1 | 1.37e-18 | NR | HEY0429767.1 | 2283092 | g21451 | i0 | 63.9 | 0.693181818181818 | 61 | 22 | 69.3 | 0 | 243 | 61 | 100 | 160 | HEY0429767.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] | diamond | 183 | 85.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29829803 | 29829803 | PRJNA694557_P_NODE_4491_length_711_cov_2.567398_g4279_i0 | PRJNA694557 | 4491 | 711 | 2.567398 | 18.25419978 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 211 | 4.47e-59 | NR | MBL8172928.1 | 1978231 | g4279 | i0 | 80.5 | 0.540084388185654 | 128 | 25 | 54 | 0 | 461 | 78 | 139 | 266 | MBL8172928.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 384 | 211 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30208706 | 30208706 | PRJNA694557_P_NODE_16832_length_312_cov_2.573222_g16612_i0 | PRJNA694557 | 16832 | 312 | 2.573222 | 8.02845264 | Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11 | 1797187 | Bacteria | Bacteria | 170 | 1.32e-46 | NR | OFW03494.1 | 1797187 | g16612 | i0 | 81.7 | 2 | 104 | 19 | 100 | 0 | 312 | 1 | 1164 | 1267 | OFW03494.1 MAG: hypothetical protein A3G20_06590, partial [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11] | diamond | 624 | 170 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11 | ||||||
| 30524896 | 30524896 | PRJNA694557_P_NODE_4693_length_692_cov_4.471729_g4479_i0 | PRJNA694557 | 4693 | 692 | 4.471729 | 30.94436468 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 48.5 | 0.00954 | NR | HEX8294468.1 | 2283092 | g4479 | i0 | 30.5 | 0.554913294797688 | 128 | 71 | 52.9 | 5 | 264 | 629 | 24 | 139 | HEX8294468.1 metal-dependent hydrolase [Pyrinomonadaceae bacterium] | diamond | 384 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31346649 | 31346649 | PRJNA694557_P_NODE_26556_length_231_cov_2.848101_g26336_i0 | PRJNA694557 | 26556 | 231 | 2.848101 | 6.57911331 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 81.3 | 2.32e-17 | NR | MEP6925069.1 | 2283092 | g26336 | i0 | 83.3 | 0.623376623376623 | 48 | 8 | 62.3 | 0 | 2 | 145 | 104 | 151 | MEP6925069.1 PA2169 family four-helix-bundle protein [Pyrinomonadaceae bacterium] | diamond | 144 | 81.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31504861 | 31504861 | PRJNA694557_P_NODE_12056_length_384_cov_1.633441_g11836_i0 | PRJNA694557 | 12056 | 384 | 1.633441 | 6.27241344 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 175 | 1.15e-52 | NR | MEP6923303.1 | 2283092 | g11836 | i0 | 68.8 | 1 | 128 | 40 | 100 | 0 | 1 | 384 | 10 | 137 | MEP6923303.1 50S ribosomal protein L25 [Pyrinomonadaceae bacterium] | diamond | 384 | 175 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32148794 | 32148794 | PRJNA694557_P_NODE_17658_length_303_cov_1.591304_g17438_i0 | PRJNA694557 | 17658 | 303 | 1.591304 | 4.82165112 | Bacteria | 2 | Bacteria | Bacteria | 169 | 3.08e-51 | NR | MCA1849487.1 | 1978231 | g17438 | i0 | 83 | 19.8019801980198 | 100 | 17 | 99 | 0 | 302 | 3 | 52 | 151 | MCA1849487.1 ribosome recycling factor [Acidobacteriota bacterium] | diamond | 6000 | 169 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32359162 | 32359162 | PRJNA694557_P_NODE_9859_length_435_cov_16.168508_g9639_i0 | PRJNA694557 | 9859 | 435 | 16.168508 | 70.3330098 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 53.5 | 3.94e-5 | NR | MBX3291457.1 | 1978231 | g9639 | i0 | 36.4 | 0.606896551724138 | 88 | 50 | 59.3 | 4 | 69 | 326 | 234 | 317 | MBX3291457.1 bacteriocin fulvocin C-related protein [Acidobacteriota bacterium] | diamond | 264 | 53.5 | 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);;