contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax_phylum = "Planctomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6589215 | 6589215 | PRJNA1098727_P_NODE_13986_length_166_cov_0.888889_g13745_i0 | PRJNA1098727 | 13986 | 166 | 0.888889 | 1.47555574 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 94 | 1.03e-21 | NR | HID22001.1 | 2026779 | g13745 | i0 | 78.2 | 0.993975903614458 | 55 | 12 | 99.4 | 0 | 165 | 1 | 55 | 109 | HID22001.1 3-oxoacyl-[acyl-carrier-protein] reductase [Planctomycetaceae bacterium] | diamond | 165 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 19336876 | 19336876 | PRJNA1098727_P_NODE_13176_length_168_cov_0.873950_g12935_i0 | PRJNA1098727 | 13176 | 168 | 0.87395 | 1.468236 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 119 | 1.39e-29 | NR | MEZ6015363.1 | 2026780 | g12935 | i0 | 100 | 3.92857142857143 | 55 | 0 | 98.2 | 0 | 167 | 3 | 123 | 177 | MEZ6015363.1 alkaline phosphatase family protein [Planctomycetota bacterium] | diamond | 660 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 26750737 | 26750737 | PRJNA1098727_P_NODE_13521_length_167_cov_0.881356_g13280_i0 | PRJNA1098727 | 13521 | 167 | 0.881356 | 1.47186452 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 55.8 | 2.93e-7 | NR | MBL8863036.1 | 2026780 | g13280 | i0 | 51 | 1.54491017964072 | 49 | 23 | 86.2 | 1 | 19 | 162 | 3 | 51 | MBL8863036.1 DUF1376 domain-containing protein [Planctomycetota bacterium] | diamond | 258 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27162243 | 27162243 | PRJNA1098727_P_NODE_11942_length_174_cov_1.784000_g11701_i0 | PRJNA1098727 | 11942 | 174 | 1.784 | 3.10416 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 48.5 | 1.27e-4 | NR | MBM4009064.1 | 2026780 | g11701 | i0 | 41.5 | 1.41379310344828 | 41 | 21 | 65.5 | 1 | 124 | 11 | 135 | 175 | MBM4009064.1 DMT family transporter [Planctomycetota bacterium] | diamond | 246 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27352362 | 27352362 | PRJNA1098727_P_NODE_14463_length_165_cov_0.896552_g14222_i0 | PRJNA1098727 | 14463 | 165 | 0.896552 | 1.4793108 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 75.5 | 3.62e-14 | NR | MFN3240355.1 | 2026780 | g14222 | i0 | 68.5 | 0.981818181818182 | 54 | 17 | 98.2 | 0 | 3 | 164 | 435 | 488 | MFN3240355.1 tetratricopeptide repeat protein [Planctomycetota bacterium] | diamond | 162 | 75.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27857266 | 27857266 | PRJNA1098727_P_NODE_14025_length_166_cov_0.888889_g13784_i0 | PRJNA1098727 | 14025 | 166 | 0.888889 | 1.47555574 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 66.6 | 4.88e-11 | NR | MEZ6014408.1 | 2026780 | g13784 | i0 | 49 | 3.79518072289157 | 51 | 26 | 92.2 | 0 | 2 | 154 | 94 | 144 | MEZ6014408.1 hypothetical protein [Planctomycetota bacterium] | diamond | 630 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28962676 | 28962676 | PRJNA1098727_P_NODE_12888_length_169_cov_0.866667_g12647_i0 | PRJNA1098727 | 12888 | 169 | 0.866667 | 1.46466723 | Planctomycetales bacterium | 2053591 | Bacteria | Bacteria | 53.9 | 1.48e-6 | NR | MCA9106575.1 | 2053591 | g12647 | i0 | 58.5 | 0.727810650887574 | 41 | 17 | 72.8 | 0 | 131 | 9 | 37 | 77 | MCA9106575.1 hypothetical protein [Planctomycetales bacterium] | diamond | 123 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium | |||
| 29751516 | 29751516 | PRJNA1098727_P_NODE_15771_length_162_cov_0.920354_g15530_i0 | PRJNA1098727 | 15771 | 162 | 0.920354 | 1.49097348 | Isosphaeraceae bacterium | 2691532 | Bacteria | Bacteria | 98.6 | 1.2e-22 | NR | MFO0957168.1 | 2691532 | g15530 | i0 | 79.6 | 1 | 54 | 11 | 100 | 0 | 1 | 162 | 263 | 316 | MFO0957168.1 hypothetical protein [Isosphaeraceae bacterium] | diamond | 162 | 98.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 29814833 | 29814833 | PRJNA1098727_P_NODE_13031_length_168_cov_1.596639_g12790_i0 | PRJNA1098727 | 13031 | 168 | 1.596639 | 2.68235352 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.00979 | NR | HBP19403.1 | 2026780 | g12790 | i0 | 47.7 | 1.42857142857143 | 44 | 18 | 69.6 | 1 | 51 | 167 | 41 | 84 | HBP19403.1 hypothetical protein [Planctomycetota bacterium] | diamond | 240 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30067583 | 30067583 | PRJNA1098727_P_NODE_3752_length_342_cov_9.351536_g3511_i0 | PRJNA1098727 | 3752 | 342 | 9.351536 | 31.98225312 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.7 | 0.0226 | NR | MBL4844746.1 | 2026780 | g3511 | i0 | 43.3 | 0.526315789473684 | 60 | 33 | 51.8 | 1 | 318 | 142 | 46 | 105 | MBL4844746.1 protein kinase [Planctomycetota bacterium] | diamond | 180 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30352553 | 30352553 | PRJNA1098727_P_NODE_7812_length_221_cov_1.197674_g7571_i0 | PRJNA1098727 | 7812 | 221 | 1.197674 | 2.64685954 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 52.4 | 1.11e-5 | NR | RKY19218.1 | 2026780 | g7571 | i0 | 37.5 | 0.97737556561086 | 72 | 45 | 97.7 | 0 | 219 | 4 | 315 | 386 | RKY19218.1 MAG: hypothetical protein DRQ55_11190 [Planctomycetota bacterium] | diamond | 216 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30825885 | 30825885 | PRJNA1098727_P_NODE_13714_length_167_cov_0.881356_g13473_i0 | PRJNA1098727 | 13714 | 167 | 0.881356 | 1.47186452 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 89.4 | 3.69e-19 | NR | MBU6309917.1 | 2026780 | g13473 | i0 | 77.8 | 0.970059880239521 | 54 | 12 | 97 | 0 | 164 | 3 | 364 | 417 | MBU6309917.1 four-carbon acid sugar kinase family protein [Planctomycetota bacterium] | diamond | 162 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31774308 | 31774308 | PRJNA1098727_P_NODE_11597_length_177_cov_1.625000_g11356_i0 | PRJNA1098727 | 11597 | 177 | 1.625 | 2.87625 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 52 | 8.51e-6 | NR | MFM1903009.1 | 2026780 | g11356 | i0 | 89.7 | 0.491525423728814 | 29 | 3 | 49.2 | 0 | 177 | 91 | 471 | 499 | MFM1903009.1 Trigger factor [Planctomycetota bacterium] | diamond | 87 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31932510 | 31932510 | PRJNA1098727_P_NODE_13137_length_168_cov_0.873950_g12896_i0 | PRJNA1098727 | 13137 | 168 | 0.87395 | 1.468236 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 41.6 | 0.036 | NR | MCB9906960.1 | 2026780 | g12896 | i0 | 42.6 | 0.964285714285714 | 54 | 24 | 96.4 | 1 | 165 | 4 | 294 | 340 | MCB9906960.1 hypothetical protein [Planctomycetota bacterium] | diamond | 162 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota 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);;