contig_metadata
14 rows where bioproject = "PRJNA721440", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22871151 | 22871151 | PRJNA721440_S_NODE_458_length_721_cov_3.813988_g370_i0 | PRJNA721440 | 458 | 721 | 3.813988 | 27.49885348 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 286 | 4.52e-93 | NR | RYD65414.1 | 2026800 | g370 | i0 | 73.4 | 0.844660194174757 | 203 | 52 | 84.5 | 1 | 609 | 1 | 56 | 256 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 609 | 286 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 24936674 | 24936674 | PRJNA721440_S_NODE_1160_length_486_cov_2.395881_g1036_i0 | PRJNA721440 | 1160 | 486 | 2.395881 | 11.64398166 | root | 1 | Root_unresolved | Root_unresolved | 196 | 9.09e-59 | NR | WP_184343325.1 | 48466 | g1036 | i0 | 55.8 | 22.2098765432099 | 163 | 65 | 98.1 | 2 | 478 | 2 | 161 | 320 | WP_184343325.1 SAM-dependent methyltransferase [Prosthecobacter vanneervenii] | diamond | 10794 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 27536537 | 27536537 | PRJNA721440_S_NODE_19903_length_162_cov_0.920354_g19777_i0 | PRJNA721440 | 19903 | 162 | 0.920354 | 1.49097348 | Bacteria | 2 | Bacteria | Bacteria | 61.6 | 6.39e-11 | NR | GBL24036.1 | 2026771 | g19777 | i0 | 59.6 | 7.55555555555556 | 47 | 19 | 87 | 0 | 2 | 142 | 18 | 64 | GBL24036.1 secretory immunoglobulin A-binding protein EsiB [Opitutia bacterium] | diamond | 1224 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 27852110 | 27852110 | PRJNA721440_S_NODE_12584_length_188_cov_1.395683_g12458_i0 | PRJNA721440 | 12584 | 188 | 1.395683 | 2.62388404 | root | 1 | Root_unresolved | Root_unresolved | 104 | 1.43e-24 | NR | WP_185690965.1 | 388746 | g12458 | i0 | 78.7 | 9.63829787234043 | 61 | 13 | 97.3 | 0 | 184 | 2 | 133 | 193 | WP_185690965.1 diaminopimelate decarboxylase [Puniceicoccus vermicola] | diamond | 1812 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccaceae | Puniceicoccus | Puniceicoccus vermicola | |
| 28978566 | 28978566 | PRJNA721440_S_NODE_12908_length_186_cov_2.875912_g12782_i0 | PRJNA721440 | 12908 | 186 | 2.875912 | 5.34919632 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 45.1 | 0.00268 | NR | MDP1591546.1 | 1965333 | g12782 | i0 | 62.9 | 0.564516129032258 | 35 | 13 | 56.5 | 0 | 105 | 1 | 10 | 44 | MDP1591546.1 UTP--glucose-1-phosphate uridylyltransferase [Prosthecobacter sp.] | diamond | 105 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29483387 | 29483387 | PRJNA721440_S_NODE_17430_length_168_cov_0.873950_g17304_i0 | PRJNA721440 | 17430 | 168 | 0.87395 | 1.468236 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 79.7 | 1.21e-15 | NR | RYD77031.1 | 2026800 | g17304 | i0 | 69.8 | 0.946428571428571 | 53 | 16 | 94.6 | 0 | 9 | 167 | 14 | 66 | RYD77031.1 MAG: hypothetical protein EOP84_16100, partial [Verrucomicrobiaceae bacterium] | diamond | 159 | 79.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29672730 | 29672730 | PRJNA721440_S_NODE_19930_length_162_cov_0.920354_g19804_i0 | PRJNA721440 | 19930 | 162 | 0.920354 | 1.49097348 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 41.6 | 0.0305 | NR | MCU0752501.1 | 2562705 | g19804 | i0 | 38.8 | 0.907407407407407 | 49 | 28 | 90.7 | 1 | 10 | 156 | 123 | 169 | MCU0752501.1 tetratricopeptide repeat protein [Akkermansiaceae bacterium] | diamond | 147 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 30241709 | 30241709 | PRJNA721440_S_NODE_21952_length_152_cov_4.067961_g21826_i0 | PRJNA721440 | 21952 | 152 | 4.067961 | 6.18330072 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 63.9 | 2.47e-10 | NR | RYD69104.1 | 2026800 | g21826 | i0 | 65.3 | 0.967105263157895 | 49 | 16 | 96.7 | 1 | 4 | 150 | 26 | 73 | RYD69104.1 MAG: MFS transporter, partial [Verrucomicrobiaceae bacterium] | diamond | 147 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30305283 | 30305283 | PRJNA721440_S_NODE_12312_length_189_cov_5.571429_g12186_i0 | PRJNA721440 | 12312 | 189 | 5.571429 | 10.53000081 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 67.4 | 1.22e-12 | NR | RYD73501.1 | 2026800 | g12186 | i0 | 78.6 | 0.666666666666667 | 42 | 9 | 66.7 | 0 | 128 | 3 | 3 | 44 | RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium] | diamond | 126 | 67.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30842037 | 30842037 | PRJNA721440_S_NODE_134_length_1122_cov_13.505126_g98_i0 | PRJNA721440 | 134 | 1122 | 13.505126 | 151.52751372 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 249 | 6.33e-76 | NR | RYD71398.1 | 2026800 | g98 | i0 | 45.7 | 0.802139037433155 | 300 | 150 | 78.6 | 6 | 9 | 890 | 69 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 900 | 249 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31000007 | 31000007 | PRJNA721440_S_NODE_19874_length_162_cov_0.920354_g19748_i0 | PRJNA721440 | 19874 | 162 | 0.920354 | 1.49097348 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 47 | 3.9e-4 | NR | RYD20361.1 | 2026800 | g19748 | i0 | 45.3 | 0.981481481481482 | 53 | 26 | 92.6 | 1 | 157 | 8 | 213 | 265 | RYD20361.1 MAG: phosphatidylinositol-specific phospholipase C domain-containing protein [Verrucomicrobiaceae bacterium] | diamond | 159 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31315989 | 31315989 | PRJNA721440_S_NODE_16295_length_171_cov_2.081967_g16169_i0 | PRJNA721440 | 16295 | 171 | 2.081967 | 3.56016357 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 99 | 5.089999999999999e-23 | NR | RYD81270.1 | 2026800 | g16169 | i0 | 83.9 | 0.982456140350877 | 56 | 9 | 98.2 | 0 | 169 | 2 | 56 | 111 | RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] | diamond | 168 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31474264 | 31474264 | PRJNA721440_S_NODE_14356_length_179_cov_2.238462_g14230_i0 | PRJNA721440 | 14356 | 179 | 2.238462 | 4.00684698 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 74.7 | 8.15e-14 | NR | RYD76251.1 | 2026800 | g14230 | i0 | 57.6 | 0.988826815642458 | 59 | 25 | 98.9 | 0 | 178 | 2 | 162 | 220 | RYD76251.1 MAG: hypothetical protein EOP84_17160, partial [Verrucomicrobiaceae bacterium] | diamond | 177 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32075196 | 32075196 | PRJNA721440_S_NODE_17798_length_167_cov_0.881356_g17672_i0 | PRJNA721440 | 17798 | 167 | 0.881356 | 1.47186452 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 100 | 3.9599999999999997e-23 | NR | HEX2748675.1 | 2026801 | g17672 | i0 | 83.3 | 1.94011976047904 | 54 | 9 | 97 | 0 | 166 | 5 | 250 | 303 | HEX2748675.1 UTP--glucose-1-phosphate uridylyltransferase [Verrucomicrobiales bacterium] | diamond | 324 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales 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);;