contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3293632 | 3293632 | PRJNA760976_P_NODE_31363_length_297_cov_2.008929_g31042_i0 | PRJNA760976 | 31363 | 297 | 2.008929 | 5.96651913 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 129 | 2.49e-32 | NR | HEY5753501.1 | 2201154 | g31042 | i0 | 61.5 | 4.57575757575758 | 91 | 35 | 91.9 | 0 | 3 | 275 | 382 | 472 | HEY5753501.1 alpha-galactosidase [Chthoniobacterales bacterium] | diamond | 1359 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27811474 | 27811474 | PRJNA760976_P_NODE_34064_length_289_cov_1.027778_g33743_i0 | PRJNA760976 | 34064 | 289 | 1.027778 | 2.97027842 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 99.4 | 8.34e-22 | NR | HEX3148041.1 | 2052164 | g33743 | i0 | 54.3 | 1.94117647058824 | 94 | 43 | 97.6 | 0 | 3 | 284 | 635 | 728 | HEX3148041.1 hypothetical protein [Gemmataceae bacterium] | diamond | 561 | 99.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 28852974 | 28852974 | PRJNA760976_P_NODE_56048_length_241_cov_1.351190_g55727_i0 | PRJNA760976 | 56048 | 241 | 1.35119 | 3.2563679 | Fuerstiella sp. | 1936112 | Bacteria | Bacteria | 74.7 | 1.71e-13 | NR | MEP3482112.1 | 1936112 | g55727 | i0 | 50 | 1.81742738589212 | 72 | 34 | 89.6 | 1 | 239 | 24 | 204 | 273 | MEP3482112.1 NO-inducible flavohemoprotein [Fuerstiella sp.] | diamond | 438 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Fuerstiella | Fuerstiella sp. | |
| 28916098 | 28916098 | PRJNA760976_P_NODE_39848_length_272_cov_1.155779_g39527_i0 | PRJNA760976 | 39848 | 272 | 1.155779 | 3.14371888 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 95.5 | 1.2e-23 | NR | MBA3721671.1 | 2052176 | g39527 | i0 | 64.6 | 1.43382352941176 | 65 | 23 | 71.7 | 0 | 76 | 270 | 1 | 65 | MBA3721671.1 CsbD family protein [Parachlamydiaceae bacterium] | diamond | 390 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 28979659 | 28979659 | PRJNA760976_P_NODE_41908_length_266_cov_1.554404_g41587_i0 | PRJNA760976 | 41908 | 266 | 1.554404 | 4.13471464 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 48.9 | 3.17e-4 | NR | HEY8503922.1 | 2052164 | g41587 | i0 | 37.7 | 0.868421052631579 | 77 | 39 | 86.8 | 3 | 231 | 1 | 266 | 333 | HEY8503922.1 hypothetical protein [Gemmataceae bacterium] | diamond | 231 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 29526023 | 29526023 | PRJNA760976_P_NODE_47910_length_251_cov_1.264045_g47589_i0 | PRJNA760976 | 47910 | 251 | 1.264045 | 3.17275295 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 102 | 6.989999999999999e-24 | NR | MBS0634548.1 | 2026799 | g47589 | i0 | 61.8 | 3.70517928286853 | 76 | 29 | 90.8 | 0 | 249 | 22 | 28 | 103 | MBS0634548.1 glycosyltransferase [Verrucomicrobiota bacterium] | diamond | 930 | 103 | 0.990291262135922 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30653276 | 30653276 | PRJNA760976_P_NODE_49273_length_248_cov_2.600000_g48952_i0 | PRJNA760976 | 49273 | 248 | 2.6 | 6.448 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 45.8 | 7.3e-4 | NR | MEI6341283.1 | 2026799 | g48952 | i0 | 58.1 | 0.375 | 31 | 13 | 37.5 | 0 | 105 | 13 | 4 | 34 | MEI6341283.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 93 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30811400 | 30811400 | PRJNA760976_P_NODE_35834_length_283_cov_1.442857_g35513_i0 | PRJNA760976 | 35834 | 283 | 1.442857 | 4.08328531 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 47.8 | 8.72e-4 | NR | MES2344608.1 | 2081524 | g35513 | i0 | 42.2 | 0.477031802120141 | 45 | 25 | 47.7 | 1 | 3 | 137 | 172 | 215 | MES2344608.1 hypothetical protein [Chlamydiota bacterium] | diamond | 135 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30843120 | 30843120 | PRJNA760976_P_NODE_12134_length_418_cov_0.849275_g11814_i0 | PRJNA760976 | 12134 | 418 | 0.849275 | 3.5499695 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 56.2 | 4.75e-6 | NR | NLE60524.1 | 2026780 | g11814 | i0 | 37.6 | 0.839712918660287 | 117 | 69 | 83.3 | 3 | 409 | 62 | 67 | 180 | NLE60524.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetota bacterium] | diamond | 351 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30874591 | 30874591 | PRJNA760976_P_NODE_46994_length_253_cov_1.633333_g46673_i0 | PRJNA760976 | 46994 | 253 | 1.633333 | 4.13233249 | Simkania sp. | 34094 | Bacteria | Bacteria | 152 | 4.39e-45 | NR | MCB1084326.1 | 34094 | g46673 | i0 | 78.3 | 0.984189723320158 | 83 | 18 | 98.4 | 0 | 253 | 5 | 47 | 129 | MCB1084326.1 serine/threonine-protein kinase [Simkania sp.] | diamond | 249 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 31664863 | 31664863 | PRJNA760976_P_NODE_51137_length_246_cov_0.890173_g50816_i0 | PRJNA760976 | 51137 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.4 | 0.0423 | NR | MCX6950839.1 | 2026799 | g50816 | i0 | 39.3 | 0.682926829268293 | 56 | 33 | 68.3 | 1 | 62 | 229 | 106 | 160 | MCX6950839.1 phosphatase PAP2 family protein [Verrucomicrobiota bacterium] | diamond | 168 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32298122 | 32298122 | PRJNA760976_P_NODE_39559_length_273_cov_0.950000_g39238_i0 | PRJNA760976 | 39559 | 273 | 0.95 | 2.5935 | Haloferula helveola | 490095 | Bacteria | Bacteria | 56.2 | 9.72e-7 | NR | WP_338688672.1 | 490095 | g39238 | i0 | 50 | 0.769230769230769 | 70 | 27 | 73.6 | 3 | 34 | 234 | 116 | 180 | WP_338688672.1 IPT/TIG domain-containing protein [Haloferula helveola] | diamond | 210 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola | |
| 32613942 | 32613942 | PRJNA760976_P_NODE_57040_length_239_cov_2.728916_g56719_i0 | PRJNA760976 | 57040 | 239 | 2.728916 | 6.52210924 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 97.1 | 5.69e-22 | NR | HYY13565.1 | 2201154 | g56719 | i0 | 60 | 8.56066945606694 | 75 | 30 | 94.1 | 0 | 230 | 6 | 28 | 102 | HYY13565.1 hypothetical protein [Chthoniobacterales bacterium] | diamond | 2046 | 97.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32645092 | 32645092 | PRJNA760976_P_NODE_53460_length_244_cov_0.859649_g53139_i0 | PRJNA760976 | 53460 | 244 | 0.859649 | 2.09754356 | Tepidisphaeraceae bacterium | 2876886 | Bacteria | Bacteria | 50.8 | 4.87e-5 | NR | HMB95802.1 | 2876886 | g53139 | i0 | 82.6 | 0.565573770491803 | 23 | 4 | 28.3 | 0 | 244 | 176 | 282 | 304 | HMB95802.1 DUF4139 domain-containing protein [Tepidisphaeraceae bacterium] | diamond | 138 | 50.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Tepidisphaeraceae 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);;