contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax_phylum = "Bdellovibrionota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3277808 | 3277808 | PRJNA751877_P_NODE_26903_length_245_cov_0.895349_g26781_i0 | PRJNA751877 | 26903 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 148 | 5.73e-44 | NR | MBX2988187.1 | 2026715 | g26781 | i0 | 91.1 | 4.8734693877551 | 79 | 7 | 96.7 | 0 | 243 | 7 | 30 | 108 | MBX2988187.1 nucleoside-diphosphate kinase [Pseudobdellovibrionaceae bacterium] | diamond | 1194 | 148 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 26809616 | 26809616 | PRJNA751877_P_NODE_27921_length_244_cov_0.900585_g27799_i0 | PRJNA751877 | 27921 | 244 | 0.900585 | 2.1974274 | Bdellovibrio | 958 | Bacteria | Bacteria | 75.9 | 7.75e-14 | NR | WP_347357380.1 | 958 | g27799 | i0 | 74.5 | 1.15573770491803 | 47 | 12 | 57.8 | 0 | 242 | 102 | 494 | 540 | WP_347357380.1 MULTISPECIES: lytic transglycosylase domain-containing protein [Bdellovibrio] | diamond | 282 | 75.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 28505501 | 28505501 | PRJNA751877_P_NODE_30047_length_241_cov_0.916667_g29925_i0 | PRJNA751877 | 30047 | 241 | 0.916667 | 2.20916747 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 132 | 5.78e-36 | NR | MBK9324357.1 | 2026715 | g29925 | i0 | 94.2 | 5.15352697095436 | 69 | 4 | 85.9 | 0 | 35 | 241 | 1 | 69 | MBK9324357.1 LysR family transcriptional regulator [Pseudobdellovibrionaceae bacterium] | diamond | 1242 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29484067 | 29484067 | PRJNA751877_P_NODE_20170_length_264_cov_1.612565_g20048_i0 | PRJNA751877 | 20170 | 264 | 1.612565 | 4.2571716 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 86.7 | 1.56e-17 | NR | MCM2279095.1 | 2599941 | g20048 | i0 | 51.3 | 0.886363636363636 | 78 | 36 | 86.4 | 1 | 236 | 9 | 421 | 498 | MCM2279095.1 hydroxymethylbilane synthase [Oligoflexia bacterium] | diamond | 234 | 86.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 29515696 | 29515696 | PRJNA751877_P_NODE_19710_length_267_cov_1.298969_g19588_i0 | PRJNA751877 | 19710 | 267 | 1.298969 | 3.46824723 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 140 | 1.98e-38 | NR | MFN8791039.1 | 2053517 | g19588 | i0 | 78.2 | 1.96629213483146 | 87 | 19 | 97.8 | 0 | 265 | 5 | 92 | 178 | MFN8791039.1 type IV pilus assembly protein PilM [Bdellovibrionales bacterium] | diamond | 525 | 140 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29515701 | 29515701 | PRJNA751877_P_NODE_29770_length_241_cov_0.916667_g29648_i0 | PRJNA751877 | 29770 | 241 | 0.916667 | 2.20916747 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 147 | 8.08e-39 | NR | NUM60332.1 | 2026715 | g29648 | i0 | 91.3 | 1.99170124481328 | 80 | 7 | 99.6 | 0 | 2 | 241 | 971 | 1050 | NUM60332.1 efflux RND transporter permease subunit [Pseudobdellovibrionaceae bacterium] | diamond | 480 | 147 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29673459 | 29673459 | PRJNA751877_P_NODE_28470_length_243_cov_0.905882_g28348_i0 | PRJNA751877 | 28470 | 243 | 0.905882 | 2.20129326 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 82.8 | 1.32e-16 | NR | HRO66702.1 | 2026715 | g28348 | i0 | 48.1 | 1.90123456790123 | 77 | 38 | 92.6 | 2 | 238 | 14 | 92 | 168 | HRO66702.1 PQQ-dependent sugar dehydrogenase [Pseudobdellovibrionaceae bacterium] | diamond | 462 | 82.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29768371 | 29768371 | PRJNA751877_P_NODE_26231_length_246_cov_0.890173_g26109_i0 | PRJNA751877 | 26231 | 246 | 0.890173 | 2.18982558 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 55.8 | 9.1e-7 | NR | MFN8791216.1 | 2053517 | g26109 | i0 | 71.1 | 0.463414634146341 | 38 | 11 | 46.3 | 0 | 245 | 132 | 565 | 602 | MFN8791216.1 tetratricopeptide repeat protein [Bdellovibrionales bacterium] | diamond | 114 | 55.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29831624 | 29831624 | PRJNA751877_P_NODE_24111_length_249_cov_0.875000_g23989_i0 | PRJNA751877 | 24111 | 249 | 0.875 | 2.17875 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 132 | 3.909999999999999e-35 | NR | HXH75518.1 | 2081706 | g23989 | i0 | 78.3 | 1.66265060240964 | 69 | 15 | 83.1 | 0 | 249 | 43 | 17 | 85 | HXH75518.1 UDP-galactopyranose mutase [Bacteriovoracaceae bacterium] | diamond | 414 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29926553 | 29926553 | PRJNA751877_P_NODE_17091_length_283_cov_2.042857_g16969_i0 | PRJNA751877 | 17091 | 283 | 2.042857 | 5.78128531 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 139 | 2.15e-39 | NR | MFN8790341.1 | 2053517 | g16969 | i0 | 89.9 | 0.837455830388693 | 79 | 8 | 83.7 | 0 | 3 | 239 | 118 | 196 | MFN8790341.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 237 | 139 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29999697 | 29999697 | PRJNA751877_P_NODE_30011_length_241_cov_0.916667_g29889_i0 | PRJNA751877 | 30011 | 241 | 0.916667 | 2.20916747 | Bdellovibrio | 958 | Bacteria | Bacteria | 138 | 1.19e-37 | NR | WP_181605561.1 | 2748865 | g29889 | i0 | 81.3 | 1.99170124481328 | 80 | 15 | 99.6 | 0 | 2 | 241 | 67 | 146 | WP_181605561.1 alpha/beta fold hydrolase [Bdellovibrio sp. KM01] | diamond | 480 | 139 | 0.992805755395683 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. KM01 | ||
| 30274232 | 30274232 | PRJNA751877_P_NODE_16792_length_285_cov_1.452830_g16670_i0 | PRJNA751877 | 16792 | 285 | 1.45283 | 4.1405655 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 84.3 | 4.38e-17 | NR | MFN8791679.1 | 2053517 | g16670 | i0 | 47.5 | 1.04210526315789 | 99 | 47 | 98.9 | 1 | 3 | 284 | 166 | 264 | MFN8791679.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 297 | 84.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30432315 | 30432315 | PRJNA751877_P_NODE_21853_length_253_cov_1.283333_g21731_i0 | PRJNA751877 | 21853 | 253 | 1.283333 | 3.24683249 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 60.8 | 7.14e-9 | NR | MCB0368971.1 | 2053517 | g21731 | i0 | 45.8 | 0.853754940711462 | 72 | 38 | 85.4 | 1 | 217 | 2 | 21 | 91 | MCB0368971.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 216 | 60.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30652915 | 30652915 | PRJNA751877_P_NODE_27873_length_244_cov_0.900585_g27751_i0 | PRJNA751877 | 27873 | 244 | 0.900585 | 2.1974274 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 88.6 | 2.79e-18 | NR | MBC7457256.1 | 2026715 | g27751 | i0 | 51.9 | 0.995901639344262 | 81 | 39 | 99.6 | 0 | 1 | 243 | 124 | 204 | MBC7457256.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 243 | 88.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30747914 | 30747914 | PRJNA751877_P_NODE_26394_length_246_cov_0.890173_g26272_i0 | PRJNA751877 | 26394 | 246 | 0.890173 | 2.18982558 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 142 | 7.24e-38 | NR | MFN8790050.1 | 2053517 | g26272 | i0 | 78 | 1 | 82 | 18 | 100 | 0 | 1 | 246 | 51 | 132 | MFN8790050.1 acyl-CoA dehydrogenase family protein [Bdellovibrionales bacterium] | diamond | 246 | 142 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31000736 | 31000736 | PRJNA751877_P_NODE_27434_length_244_cov_1.801170_g27312_i0 | PRJNA751877 | 27434 | 244 | 1.80117 | 4.3948548 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 4.62e-42 | NR | MCB0369869.1 | 2053517 | g27312 | i0 | 84 | 0.995901639344262 | 81 | 13 | 99.6 | 0 | 1 | 243 | 20 | 100 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 243 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31000737 | 31000737 | PRJNA751877_P_NODE_28034_length_244_cov_0.900585_g27912_i0 | PRJNA751877 | 28034 | 244 | 0.900585 | 2.1974274 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 149 | 1.44e-41 | NR | MFN8790556.1 | 2053517 | g27912 | i0 | 86.4 | 0.995901639344262 | 81 | 11 | 99.6 | 0 | 1 | 243 | 298 | 378 | MFN8790556.1 signal recognition particle-docking protein FtsY [Bdellovibrionales bacterium] | diamond | 243 | 149 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31474989 | 31474989 | PRJNA751877_P_NODE_24336_length_249_cov_0.875000_g24214_i0 | PRJNA751877 | 24336 | 249 | 0.875 | 2.17875 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 116 | 1.52e-29 | NR | MES2855841.1 | 3034175 | g24214 | i0 | 62.2 | 0.987951807228916 | 82 | 31 | 98.8 | 0 | 2 | 247 | 41 | 122 | MES2855841.1 DMT family transporter [Bdellovibrionota bacterium] | diamond | 246 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31854360 | 31854360 | PRJNA751877_P_NODE_29657_length_241_cov_1.744048_g29535_i0 | PRJNA751877 | 29657 | 241 | 1.744048 | 4.20315568 | Bdellovibrio sp. ArHS | 1569284 | Bacteria | Bacteria | 89 | 1.05e-18 | NR | WP_041874894.1 | 1569284 | g29535 | i0 | 50.7 | 6.63485477178423 | 75 | 37 | 93.4 | 0 | 225 | 1 | 41 | 115 | WP_041874894.1 CapA family protein [Bdellovibrio sp. ArHS] | diamond | 1599 | 89 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. ArHS | ||
| 32234408 | 32234408 | PRJNA751877_P_NODE_23578_length_250_cov_0.870056_g23456_i0 | PRJNA751877 | 23578 | 250 | 0.870056 | 2.17514 | Bacteriovoracia bacterium | 3058048 | Bacteria | Bacteria | 62.8 | 1.76e-9 | NR | MFP5490308.1 | 3058048 | g23456 | i0 | 33.8 | 1.968 | 80 | 53 | 96 | 0 | 7 | 246 | 29 | 108 | MFP5490308.1 hypothetical protein [Bacteriovoracia bacterium] | diamond | 492 | 62.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracia 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);;