contig_metadata
16 rows where bioproject = "PRJNA408129", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2969297 | 2969297 | PRJNA408129_S_NODE_8883_length_229_cov_4.046875_g8865_i0 | PRJNA408129 | 8883 | 229 | 4.046875 | 9.26734375 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 268 | 1.86e-67 | NTclustered | gi|2874253852|emb|OY969908.1| | 194844 | g8865 | i0 | 90.594 | 83.3231441048035 | 202 | 19 | 88 | 0 | 28 | 229 | 2169556 | 2169355 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1 | blastn | 19081 | 268 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 5522118 | 5522118 | PRJNA408129_S_NODE_1465_length_355_cov_17712.261006_g1447_i0 | PRJNA408129 | 1465 | 355 | 17712.261006 | 62878.5265713 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 155 | 1.41e-41 | NR | MDQ3714372.1 | 1978231 | g1447 | i0 | 88.2 | 0.71830985915493 | 85 | 10 | 71.8 | 0 | 343 | 89 | 141 | 225 | MDQ3714372.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 255 | 155 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 15721027 | 15721027 | PRJNA408129_S_NODE_14053_length_199_cov_7.216049_g14035_i0 | PRJNA408129 | 14053 | 199 | 7.216049 | 14.35993751 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 116 | 2.3199999999999993e-28 | NR | HYI94836.1 | 2212468 | g14035 | i0 | 90.9 | 0.994974874371859 | 66 | 6 | 99.5 | 0 | 2 | 199 | 59 | 124 | HYI94836.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 198 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26790797 | 26790797 | PRJNA408129_S_NODE_21421_length_175_cov_2.384058_g21403_i0 | PRJNA408129 | 21421 | 175 | 2.384058 | 4.1721015 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 110 | 2.26e-26 | NR | MBS1795208.1 | 1978231 | g21403 | i0 | 81 | 0.994285714285714 | 58 | 11 | 99.4 | 0 | 175 | 2 | 470 | 527 | MBS1795208.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 174 | 110 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26822524 | 26822524 | PRJNA408129_S_NODE_10021_length_221_cov_8.184783_g10003_i0 | PRJNA408129 | 10021 | 221 | 8.184783 | 18.08837043 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 49.7 | 5.64e-6 | NR | HLN99585.1 | 2283092 | g10003 | i0 | 70.7 | 0.556561085972851 | 41 | 12 | 55.7 | 0 | 44 | 166 | 1 | 41 | HLN99585.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 123 | 49.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27328528 | 27328528 | PRJNA408129_S_NODE_26603_length_164_cov_1.818898_g26585_i0 | PRJNA408129 | 26603 | 164 | 1.818898 | 2.98299272 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 87.4 | 2.29e-18 | NR | MBI4904732.1 | 1978231 | g26585 | i0 | 71.7 | 0.969512195121951 | 53 | 15 | 97 | 0 | 3 | 161 | 249 | 301 | MBI4904732.1 S9 family peptidase [Acidobacteriota bacterium] | diamond | 159 | 87.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27517943 | 27517943 | PRJNA408129_S_NODE_4623_length_273_cov_2.830508_g4605_i0 | PRJNA408129 | 4623 | 273 | 2.830508 | 7.72728684 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.1 | 0.0378 | NR | HXN49145.1 | 2212468 | g4605 | i0 | 41.3 | 0.692307692307692 | 63 | 31 | 62.6 | 1 | 18 | 188 | 397 | 459 | HXN49145.1 immunoglobulin-like domain-containing protein [Bryobacteraceae bacterium] | diamond | 189 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27580982 | 27580982 | PRJNA408129_S_NODE_7984_length_236_cov_3.502513_g7966_i0 | PRJNA408129 | 7984 | 236 | 3.502513 | 8.26593068 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 107 | 1.09e-25 | NR | MEP7038772.1 | 1978231 | g7966 | i0 | 70.4 | 0.902542372881356 | 71 | 21 | 90.3 | 0 | 215 | 3 | 1 | 71 | MEP7038772.1 carbohydrate binding domain-containing protein [Acidobacteriota bacterium] | diamond | 213 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28418831 | 28418831 | PRJNA408129_S_NODE_17026_length_188_cov_1.980132_g17008_i0 | PRJNA408129 | 17026 | 188 | 1.980132 | 3.72264816 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 69.3 | 5.92e-12 | NR | PYP86624.1 | 2169412 | g17008 | i0 | 75 | 5.74468085106383 | 40 | 10 | 63.8 | 0 | 144 | 25 | 1 | 40 | PYP86624.1 MAG: alcohol dehydrogenase [Candidatus Angelobacter sp. Gp1-AA117] | diamond | 1080 | 69.7 | 0.994261119081779 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. Gp1-AA117 | ||||
| 30612520 | 30612520 | PRJNA408129_S_NODE_4853_length_269_cov_4.818966_g4835_i0 | PRJNA408129 | 4853 | 269 | 4.818966 | 12.96301854 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 144 | 7.599999999999999e-38 | NR | HYI95960.1 | 2212468 | g4835 | i0 | 89.5 | 0.95910780669145 | 86 | 9 | 95.9 | 0 | 267 | 10 | 1 | 86 | HYI95960.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 258 | 144 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31402933 | 31402933 | PRJNA408129_S_NODE_6936_length_245_cov_3.288462_g6918_i0 | PRJNA408129 | 6936 | 245 | 3.288462 | 8.0567319 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 148 | 2.4e-42 | NR | HYI92616.1 | 2212468 | g6918 | i0 | 90.1 | 0.991836734693878 | 81 | 8 | 99.2 | 0 | 3 | 245 | 142 | 222 | HYI92616.1 PAS domain S-box protein [Bryobacteraceae bacterium] | diamond | 243 | 148 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31434304 | 31434304 | PRJNA408129_S_NODE_30196_length_158_cov_1.066116_g30178_i0 | PRJNA408129 | 30196 | 158 | 1.066116 | 1.68446328 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 44.3 | 0.00336 | NR | HUR81816.1 | 2651171 | g30178 | i0 | 45.1 | 0.968354430379747 | 51 | 26 | 96.8 | 2 | 155 | 3 | 57 | 105 | HUR81816.1 ATP-binding protein [Thermoanaerobaculia bacterium] | diamond | 153 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 31877034 | 31877034 | PRJNA408129_S_NODE_20097_length_178_cov_7.028369_g20079_i0 | PRJNA408129 | 20097 | 178 | 7.028369 | 12.51049682 | Luteitalea sp. TBR-22 | 2802971 | Bacteria | Bacteria | 95.9 | 3.68e-22 | NR | WP_239488721.1 | 2802971 | g20079 | i0 | 87.3 | 1.85393258426966 | 55 | 7 | 92.7 | 0 | 10 | 174 | 24 | 78 | WP_239488721.1 translation elongation factor Ts [Luteitalea sp. TBR-22] | diamond | 330 | 95.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. TBR-22 | ||
| 32130520 | 32130520 | PRJNA408129_S_NODE_29238_length_159_cov_3.655738_g29220_i0 | PRJNA408129 | 29238 | 159 | 3.655738 | 5.81262342 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 75.5 | 2.94e-14 | NR | MCU1287826.1 | 1978231 | g29220 | i0 | 72 | 0.943396226415094 | 50 | 14 | 94.3 | 0 | 158 | 9 | 207 | 256 | MCU1287826.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 150 | 75.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32463539 | 32463539 | PRJNA408129_S_NODE_23739_length_169_cov_8.083333_g23721_i0 | PRJNA408129 | 23739 | 169 | 8.083333 | 13.66083277 | Luteitalea | 2004797 | Bacteria | Bacteria | 83.2 | 2.68e-17 | NR | WP_110173983.1 | 1855912 | g23721 | i0 | 75.5 | 3.71005917159763 | 53 | 13 | 94.1 | 0 | 11 | 169 | 192 | 244 | WP_110173983.1 YMGG-like glycine zipper-containing protein [Luteitalea pratensis] | diamond | 627 | 83.6 | 0.995215311004785 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea pratensis | ||
| 32730780 | 32730780 | PRJNA408129_S_NODE_16320_length_190_cov_4.078431_g16302_i0 | PRJNA408129 | 16320 | 190 | 4.078431 | 7.7490189 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 101 | 4.3e-26 | NR | HMY76456.1 | 2052146 | g16302 | i0 | 76.7 | 0.947368421052632 | 60 | 14 | 94.7 | 0 | 181 | 2 | 20 | 79 | HMY76456.1 YCF48-related protein [Blastocatellia bacterium] | diamond | 180 | 101 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia 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);;