contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10553522 | 10553522 | PRJNA1240805_P_NODE_5729_length_191_cov_2.507042_g5680_i0 | PRJNA1240805 | 5729 | 191 | 2.507042 | 4.78845022 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 102 | 1.2499999999999999e-23 | NR | HEY8278743.1 | 3034175 | g5680 | i0 | 84.1 | 0.989528795811518 | 63 | 10 | 99 | 0 | 190 | 2 | 56 | 118 | HEY8278743.1 MFS transporter [Bdellovibrionota bacterium] | diamond | 189 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 22026200 | 22026200 | PRJNA1240805_P_NODE_4158_length_225_cov_3.215909_g4109_i0 | PRJNA1240805 | 4158 | 225 | 3.215909 | 7.23579525 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 101 | 5.249999999999999e-24 | NR | HMN68280.1 | 2053517 | g4109 | i0 | 77.3 | 2.64 | 66 | 15 | 88 | 0 | 200 | 3 | 191 | 256 | HMN68280.1 cation transporter [Bdellovibrionales bacterium] | diamond | 594 | 101 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27389808 | 27389808 | PRJNA1240805_P_NODE_823_length_554_cov_7.653465_g776_i0 | PRJNA1240805 | 823 | 554 | 7.653465 | 42.4001961 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 135 | 6.72e-35 | NR | HXH76158.1 | 2081706 | g776 | i0 | 63 | 0.541516245487365 | 100 | 37 | 54.2 | 0 | 323 | 24 | 1 | 100 | HXH76158.1 IS630 family transposase [Bacteriovoracaceae bacterium] | diamond | 300 | 135 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 27800267 | 27800267 | PRJNA1240805_P_NODE_6604_length_178_cov_3.062016_g6555_i0 | PRJNA1240805 | 6604 | 178 | 3.062016 | 5.45038848 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 66.2 | 7.91e-11 | NR | MCB0368368.1 | 2053517 | g6555 | i0 | 56.3 | 0.808988764044944 | 48 | 21 | 80.9 | 0 | 34 | 177 | 119 | 166 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 144 | 66.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28052625 | 28052625 | PRJNA1240805_P_NODE_785_length_564_cov_6.617476_g738_i0 | PRJNA1240805 | 785 | 564 | 6.617476 | 37.32256464 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 156 | 2.45e-44 | NR | MFL5783649.1 | 2081706 | g738 | i0 | 87.2 | 0.414893617021277 | 78 | 10 | 41.5 | 0 | 294 | 527 | 1 | 78 | MFL5783649.1 DsbA family oxidoreductase [Bacteriovoracaceae bacterium] | diamond | 234 | 156 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28305245 | 28305245 | PRJNA1240805_P_NODE_5926_length_188_cov_2.201439_g5877_i0 | PRJNA1240805 | 5926 | 188 | 2.201439 | 4.13870532 | Bdellovibrionales bacterium RBG_16_4 | 2053517 | Bacteria | Bacteria | 55.1 | 7.84e-7 | NR | OFZ17887.1 | 1797388 | g5877 | i0 | 53.7 | 0.861702127659574 | 54 | 24 | 86.2 | 1 | 17 | 178 | 171 | 223 | OFZ17887.1 MAG: hypothetical protein A2Z20_10635 [Bdellovibrionales bacterium RBG_16_40_8] | diamond | 162 | 55.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RBG_16_40_8 | ||||
| 28778784 | 28778784 | PRJNA1240805_P_NODE_1307_length_434_cov_12.654545_g1258_i0 | PRJNA1240805 | 1307 | 434 | 12.654545 | 54.9207253 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 92.4 | 2.76e-21 | NR | NUM87850.1 | 2053517 | g1258 | i0 | 63.6 | 0.532258064516129 | 77 | 28 | 53.2 | 0 | 247 | 17 | 1 | 77 | NUM87850.1 ATP synthase F0 subunit C [Bdellovibrionales bacterium] | diamond | 231 | 92.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29536670 | 29536670 | PRJNA1240805_P_NODE_510_length_682_cov_6.799368_g473_i0 | PRJNA1240805 | 510 | 682 | 6.799368 | 46.37168976 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 248 | 4.67e-74 | NR | MES2527348.1 | 3034175 | g473 | i0 | 82.6 | 0.633431085043988 | 144 | 25 | 63.3 | 0 | 677 | 246 | 565 | 708 | MES2527348.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 432 | 248 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29631082 | 29631082 | PRJNA1240805_P_NODE_1650_length_381_cov_2.605422_g1601_i0 | PRJNA1240805 | 1650 | 381 | 2.605422 | 9.92665782 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 70.9 | 2.3e-11 | NR | MEW6058255.1 | 3034175 | g1601 | i0 | 52.8 | 0.417322834645669 | 53 | 25 | 41.7 | 0 | 20 | 178 | 395 | 447 | MEW6058255.1 translocation protein TolB [Bdellovibrionota bacterium] | diamond | 159 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29631083 | 29631083 | PRJNA1240805_P_NODE_1930_length_348_cov_2.675585_g1881_i0 | PRJNA1240805 | 1930 | 348 | 2.675585 | 9.3110358 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 152 | 5.5e-41 | NR | MFL5785935.1 | 2081706 | g1881 | i0 | 72.9 | 0.827586206896552 | 96 | 26 | 82.8 | 0 | 348 | 61 | 438 | 533 | MFL5785935.1 fatty acid CoA ligase family protein [Bacteriovoracaceae bacterium] | diamond | 288 | 152 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29997034 | 29997034 | PRJNA1240805_P_NODE_3971_length_232_cov_1.021858_g3922_i0 | PRJNA1240805 | 3971 | 232 | 1.021858 | 2.37071056 | Bacteria | 2 | Bacteria | Bacteria | 112 | 1.63e-28 | NR | MFL5783183.1 | 2081706 | g3922 | i0 | 86.9 | 1.57758620689655 | 61 | 8 | 78.9 | 0 | 2 | 184 | 191 | 251 | MFL5783183.1 type IV pilus twitching motility protein PilT [Bacteriovoracaceae bacterium] | diamond | 366 | 113 | 0.991150442477876 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 30136388 | 30136388 | PRJNA1240805_P_NODE_432_length_729_cov_6.501471_g396_i0 | PRJNA1240805 | 432 | 729 | 6.5014709999999996 | 47.39572359 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 78.6 | 4.26e-14 | NR | HEY8278972.1 | 3034175 | g396 | i0 | 31.3 | 0.670781893004115 | 163 | 100 | 62.6 | 4 | 655 | 200 | 1 | 162 | HEY8278972.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 489 | 78.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30831795 | 30831795 | PRJNA1240805_P_NODE_6114_length_185_cov_2.161765_g6065_i0 | PRJNA1240805 | 6114 | 185 | 2.161765 | 3.99926525 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 95.1 | 6.09e-21 | NR | MES2529060.1 | 3034175 | g6065 | i0 | 81.5 | 0.875675675675676 | 54 | 10 | 87.6 | 0 | 182 | 21 | 1 | 54 | MES2529060.1 sulfatase-like hydrolase/transferase [Bdellovibrionota bacterium] | diamond | 162 | 95.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31021477 | 31021477 | PRJNA1240805_P_NODE_6955_length_174_cov_2.968000_g6906_i0 | PRJNA1240805 | 6955 | 174 | 2.968 | 5.16432 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 48.9 | 5.38e-6 | NR | HLE11650.1 | 2081706 | g6906 | i0 | 59.5 | 1.27586206896552 | 37 | 15 | 63.8 | 0 | 172 | 62 | 18 | 54 | HLE11650.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 222 | 48.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31115955 | 31115955 | PRJNA1240805_P_NODE_1095_length_477_cov_6.750000_g1048_i0 | PRJNA1240805 | 1095 | 477 | 6.75 | 32.1975 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 128 | 1.26e-32 | NR | MBX3020898.1 | 2053517 | g1048 | i0 | 62.8 | 0.540880503144654 | 86 | 32 | 54.1 | 0 | 197 | 454 | 27 | 112 | MBX3020898.1 DUF4421 family protein [Bdellovibrionales bacterium] | diamond | 258 | 128 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31147391 | 31147391 | PRJNA1240805_P_NODE_4195_length_224_cov_1.622857_g4146_i0 | PRJNA1240805 | 4195 | 224 | 1.622857 | 3.63519968 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 60.1 | 2.22e-8 | NR | MES2528487.1 | 3034175 | g4146 | i0 | 89.2 | 0.495535714285714 | 37 | 4 | 49.6 | 0 | 113 | 223 | 557 | 593 | MES2528487.1 VWA domain-containing protein [Bdellovibrionota bacterium] | diamond | 111 | 60.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31210511 | 31210511 | PRJNA1240805_P_NODE_735_length_579_cov_5.794340_g688_i0 | PRJNA1240805 | 735 | 579 | 5.79434 | 33.5492286 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 298 | 7.089999999999999e-96 | NR | MES2527780.1 | 3034175 | g688 | i0 | 82.1 | 0.953367875647668 | 184 | 33 | 95.3 | 0 | 556 | 5 | 326 | 509 | MES2527780.1 murein biosynthesis integral membrane protein MurJ [Bdellovibrionota bacterium] | diamond | 552 | 298 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31653617 | 31653617 | PRJNA1240805_P_NODE_1317_length_431_cov_11.945026_g1268_i0 | PRJNA1240805 | 1317 | 431 | 11.945026 | 51.48306206 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 198 | 2.29e-61 | NR | HEX4922785.1 | 2053517 | g1268 | i0 | 70.4 | 0.939675174013921 | 135 | 40 | 94 | 0 | 407 | 3 | 44 | 178 | HEX4922785.1 aminotransferase class IV [Bdellovibrionales bacterium] | diamond | 405 | 198 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31653621 | 31653621 | PRJNA1240805_P_NODE_817_length_555_cov_23.980237_g770_i0 | PRJNA1240805 | 817 | 555 | 23.980237 | 133.09031535 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 182 | 1.75e-50 | NR | HEY8279270.1 | 3034175 | g770 | i0 | 70 | 0.702702702702703 | 130 | 39 | 70.3 | 0 | 142 | 531 | 1 | 130 | HEY8279270.1 ABC transporter ATP-binding protein [Bdellovibrionota bacterium] | diamond | 390 | 182 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32001778 | 32001778 | PRJNA1240805_P_NODE_2878_length_278_cov_2.266376_g2829_i0 | PRJNA1240805 | 2878 | 278 | 2.266376 | 6.30052528 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 53.5 | 8.84e-6 | NR | WP_015469527.1 | 453816 | g2829 | i0 | 66.7 | 0.420863309352518 | 39 | 13 | 42.1 | 0 | 126 | 10 | 45 | 83 | WP_015469527.1 GldG family protein [Pseudobdellovibrio exovorus] | diamond | 117 | 53.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 32508280 | 32508280 | PRJNA1240805_P_NODE_1199_length_455_cov_5.889163_g1151_i0 | PRJNA1240805 | 1199 | 455 | 5.889163 | 26.79569165 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 250 | 2.7700000000000003e-79 | NR | MES2528493.1 | 3034175 | g1151 | i0 | 86.1 | 0.995604395604396 | 151 | 21 | 99.6 | 0 | 3 | 455 | 149 | 299 | MES2528493.1 type II secretion system F family protein [Bdellovibrionota bacterium] | diamond | 453 | 250 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32697109 | 32697109 | PRJNA1240805_P_NODE_3560_length_245_cov_3.357143_g3511_i0 | PRJNA1240805 | 3560 | 245 | 3.357143 | 8.22500035 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 112 | 5.94e-28 | NR | MBS1985132.1 | 2053517 | g3511 | i0 | 65.8 | 0.96734693877551 | 79 | 27 | 96.7 | 0 | 3 | 239 | 172 | 250 | MBS1985132.1 COX15/CtaA family protein [Bdellovibrionales bacterium] | diamond | 237 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales 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);;