contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA800053" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19923070 | 19923070 | PRJNA800053_P_NODE_6156_length_373_cov_1.020000_g5993_i0 | PRJNA800053 | 6156 | 373 | 1.02 | 3.8046 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 236 | 3.37e-73 | NR | MEO6391133.1 | 2283092 | g5993 | i0 | 91.8 | 0.981233243967828 | 122 | 10 | 98.1 | 0 | 370 | 5 | 175 | 296 | MEO6391133.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Pyrinomonadaceae bacterium] | diamond | 366 | 236 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26642451 | 26642451 | PRJNA800053_P_NODE_19221_length_248_cov_0.880000_g19057_i0 | PRJNA800053 | 19221 | 248 | 0.88 | 2.1824 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 115 | 7.31e-28 | NR | MBM3740730.1 | 1978231 | g19057 | i0 | 74.4 | 0.943548387096774 | 78 | 20 | 94.4 | 0 | 6 | 239 | 312 | 389 | MBM3740730.1 ATP-dependent DNA ligase [Acidobacteriota bacterium] | diamond | 234 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26896104 | 26896104 | PRJNA800053_P_NODE_21041_length_245_cov_0.895349_g20877_i0 | PRJNA800053 | 21041 | 245 | 0.895349 | 2.19360505 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 127 | 6.759999999999999e-32 | NR | HEX4946824.1 | 2052146 | g20877 | i0 | 77.8 | 0.991836734693878 | 81 | 17 | 99.2 | 1 | 243 | 1 | 40 | 119 | HEX4946824.1 CocE/NonD family hydrolase [Blastocatellia bacterium] | diamond | 243 | 127 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27307075 | 27307075 | PRJNA800053_P_NODE_17883_length_250_cov_1.429379_g17719_i0 | PRJNA800053 | 17883 | 250 | 1.429379 | 3.5734475 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 64.3 | 1.01e-9 | NR | HEX4278166.1 | 2212468 | g17719 | i0 | 47.9 | 0.876 | 73 | 36 | 87.6 | 1 | 30 | 248 | 704 | 774 | HEX4278166.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 219 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27465044 | 27465044 | PRJNA800053_P_NODE_18223_length_250_cov_0.870056_g18059_i0 | PRJNA800053 | 18223 | 250 | 0.870056 | 2.17514 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 132 | 9.01e-34 | NR | HRH43430.1 | 2283092 | g18059 | i0 | 76.5 | 0.972 | 81 | 19 | 97.2 | 0 | 246 | 4 | 922 | 1002 | HRH43430.1 ATP-dependent helicase [Pyrinomonadaceae bacterium] | diamond | 243 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27631789 | 27631789 | PRJNA800053_P_NODE_17784_length_250_cov_2.751412_g17620_i0 | PRJNA800053 | 17784 | 250 | 2.751412 | 6.87853 | Bacteria | 2 | Bacteria | Bacteria | 120 | 1.79e-29 | NR | MCC7033898.1 | 1978231 | g17620 | i0 | 73.2 | 11.808 | 82 | 22 | 98.4 | 0 | 3 | 248 | 171 | 252 | MCC7033898.1 ABC transporter permease [Acidobacteriota bacterium] | diamond | 2952 | 120 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27875268 | 27875268 | PRJNA800053_P_NODE_21905_length_244_cov_0.900585_g21741_i0 | PRJNA800053 | 21905 | 244 | 0.900585 | 2.1974274 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 139 | 4.19e-36 | NR | HYZ87431.1 | 2212468 | g21741 | i0 | 80 | 0.983606557377049 | 80 | 16 | 98.4 | 0 | 4 | 243 | 703 | 782 | HYZ87431.1 TonB-dependent receptor [Bryobacteraceae bacterium] | diamond | 240 | 139 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28421255 | 28421255 | PRJNA800053_P_NODE_18886_length_249_cov_0.875000_g18722_i0 | PRJNA800053 | 18886 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.9 | 1.86e-4 | NR | MCA1631568.1 | 1978231 | g18722 | i0 | 100 | 2.3855421686747 | 22 | 0 | 26.5 | 0 | 69 | 4 | 1 | 22 | MCA1631568.1 30S ribosomal protein S4 [Acidobacteriota bacterium] | diamond | 594 | 48.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28759335 | 28759335 | PRJNA800053_P_NODE_21767_length_244_cov_0.900585_g21603_i0 | PRJNA800053 | 21767 | 244 | 0.900585 | 2.1974274 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 159 | 9.56e-44 | NR | MBL8240225.1 | 2026791 | g21603 | i0 | 96.3 | 1.9672131147541 | 80 | 3 | 98.4 | 0 | 241 | 2 | 98 | 177 | MBL8240225.1 nitrite/sulfite reductase [Bryobacterales bacterium] | diamond | 480 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 29422268 | 29422268 | PRJNA800053_P_NODE_22349_length_243_cov_0.905882_g22185_i0 | PRJNA800053 | 22349 | 243 | 0.905882 | 2.20129326 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 171 | 1.38e-51 | NR | MBP9947575.1 | 2793154 | g22185 | i0 | 98.8 | 0.987654320987654 | 80 | 1 | 98.8 | 0 | 243 | 4 | 80 | 159 | MBP9947575.1 FAD-dependent thymidylate synthase [Vicinamibacteria bacterium] | diamond | 240 | 171 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 29517046 | 29517046 | PRJNA800053_P_NODE_11890_length_288_cov_1.344186_g11726_i0 | PRJNA800053 | 11890 | 288 | 1.344186 | 3.87125568 | Chloracidobacterium sp. | 2099375 | Bacteria | Bacteria | 68.2 | 5.56e-11 | NR | MBK8468061.1 | 2099375 | g11726 | i0 | 37.4 | 1.03125 | 99 | 56 | 96.9 | 1 | 285 | 7 | 136 | 234 | MBK8468061.1 hypothetical protein [Chloracidobacterium sp.] | diamond | 297 | 68.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 29548572 | 29548572 | PRJNA800053_P_NODE_25270_length_202_cov_4.387597_g25106_i0 | PRJNA800053 | 25270 | 202 | 4.387597 | 8.86294594 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 70.1 | 3.46e-12 | NR | MCW5956494.1 | 2283092 | g25106 | i0 | 54.7 | 0.95049504950495 | 64 | 29 | 95 | 0 | 7 | 198 | 27 | 90 | MCW5956494.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 192 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29580046 | 29580046 | PRJNA800053_P_NODE_15950_length_259_cov_2.005376_g15786_i0 | PRJNA800053 | 15950 | 259 | 2.005376 | 5.19392384 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 155 | 2.95e-46 | NR | MBK6725502.1 | 1978231 | g15786 | i0 | 90.4 | 0.961389961389961 | 83 | 8 | 96.1 | 0 | 254 | 6 | 65 | 147 | MBK6725502.1 dihydrofolate reductase [Acidobacteriota bacterium] | diamond | 249 | 155 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30117135 | 30117135 | PRJNA800053_P_NODE_24392_length_235_cov_2.802469_g24228_i0 | PRJNA800053 | 24392 | 235 | 2.802469 | 6.58580215 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 85.5 | 2.92e-17 | NR | HEY7336992.1 | 2212468 | g24228 | i0 | 68.3 | 1.60851063829787 | 63 | 20 | 80.4 | 0 | 3 | 191 | 296 | 358 | HEY7336992.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 378 | 85.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30812302 | 30812302 | PRJNA800053_P_NODE_15214_length_264_cov_1.267016_g15050_i0 | PRJNA800053 | 15214 | 264 | 1.267016 | 3.34492224 | Chloracidobacterium sp. | 2099375 | Bacteria | Bacteria | 55.8 | 9.66e-7 | NR | MBK8467761.1 | 2099375 | g15050 | i0 | 34.2 | 1.76136363636364 | 76 | 49 | 86.4 | 1 | 259 | 32 | 9 | 83 | MBK8467761.1 hypothetical protein [Chloracidobacterium sp.] | diamond | 465 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 31002032 | 31002032 | PRJNA800053_P_NODE_13354_length_277_cov_1.465686_g13190_i0 | PRJNA800053 | 13354 | 277 | 1.465686 | 4.05995022 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 169 | 2.38e-47 | NR | MCC6988999.1 | 1978231 | g13190 | i0 | 96.7 | 1.9927797833935 | 92 | 3 | 99.6 | 0 | 277 | 2 | 41 | 132 | MCC6988999.1 SurA N-terminal domain-containing protein [Acidobacteriota bacterium] | diamond | 552 | 169 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31476286 | 31476286 | PRJNA800053_P_NODE_12056_length_287_cov_1.168224_g11892_i0 | PRJNA800053 | 12056 | 287 | 1.168224 | 3.35280288 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 78.2 | 2.2e-14 | NR | HEV7642598.1 | 2283092 | g11892 | i0 | 57 | 0.825783972125436 | 79 | 34 | 82.6 | 0 | 269 | 33 | 306 | 384 | HEV7642598.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 237 | 78.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32013932 | 32013932 | PRJNA800053_P_NODE_23878_length_241_cov_0.916667_g23714_i0 | PRJNA800053 | 23878 | 241 | 0.916667 | 2.20916747 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 50.8 | 5.24e-5 | NR | HYL73830.1 | 2212468 | g23714 | i0 | 41.8 | 0.983402489626556 | 79 | 42 | 93.4 | 2 | 232 | 8 | 373 | 451 | HYL73830.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 237 | 50.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32140560 | 32140560 | PRJNA800053_P_NODE_13818_length_274_cov_1.208955_g13654_i0 | PRJNA800053 | 13818 | 274 | 1.208955 | 3.3125367 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 142 | 1.3999999999999996e-41 | NR | HMT09752.1 | 2283092 | g13654 | i0 | 72.7 | 1.93795620437956 | 88 | 24 | 96.4 | 0 | 4 | 267 | 37 | 124 | HMT09752.1 DUF2203 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 531 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32149523 | 32149523 | PRJNA800053_P_NODE_19858_length_247_cov_0.885057_g19694_i0 | PRJNA800053 | 19858 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 56.2 | 3.51e-8 | NR | MDE3196541.1 | 1978231 | g19694 | i0 | 69.4 | 2.46558704453441 | 36 | 11 | 43.7 | 0 | 245 | 138 | 38 | 73 | MDE3196541.1 phage terminase large subunit [Acidobacteriota bacterium] | diamond | 609 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32299046 | 32299046 | PRJNA800053_P_NODE_18919_length_249_cov_0.875000_g18755_i0 | PRJNA800053 | 18919 | 249 | 0.875 | 2.17875 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 98.6 | 3.08e-23 | NR | MEO5742285.1 | 2910147 | g18755 | i0 | 54.9 | 1.97590361445783 | 82 | 37 | 98.8 | 0 | 248 | 3 | 90 | 171 | MEO5742285.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 492 | 98.6 | 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);;