contig_metadata
16 rows where bioproject = "PRJEB83101", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12895495 | 12895495 | PRJEB83101_P_NODE_42371_length_290_cov_1.331797_g42066_i0 | PRJEB83101 | 42371 | 290 | 1.331797 | 3.8622113 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 162 | 8.74e-44 | NR | MFN8846768.1 | 2053517 | g42066 | i0 | 83.3 | 0.993103448275862 | 96 | 16 | 99.3 | 0 | 290 | 3 | 834 | 929 | MFN8846768.1 DNA-directed RNA polymerase subunit beta' [Bdellovibrionales bacterium] | diamond | 288 | 162 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 23095044 | 23095044 | PRJEB83101_P_NODE_82319_length_244_cov_0.912281_g82014_i0 | PRJEB83101 | 82319 | 244 | 0.912281 | 2.22596564 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 401 | 1.8999999999999998e-107 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g82014 | i0 | 96.311 | 13.8975409836066 | 244 | 9 | 100 | 0 | 1 | 244 | 375146 | 375389 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 3391 | 401 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 26710097 | 26710097 | PRJEB83101_P_NODE_89541_length_231_cov_2.278481_g89236_i0 | PRJEB83101 | 89541 | 231 | 2.278481 | 5.26329111 | Micavibrio | 213485 | Bacteria | Bacteria | 105 | 2.45e-26 | NR | WP_015468097.1 | 349221 | g89236 | i0 | 82.5 | 2.22077922077922 | 57 | 10 | 74 | 0 | 171 | 1 | 1 | 57 | WP_015468097.1 helix-turn-helix domain-containing protein [Micavibrio aeruginosavorus] | diamond | 513 | 105 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 26868952 | 26868952 | PRJEB83101_P_NODE_59421_length_261_cov_1.393617_g59116_i0 | PRJEB83101 | 59421 | 261 | 1.393617 | 3.63734037 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 142 | 6.1399999999999995e-37 | NR | MBC7467272.1 | 28201 | g59116 | i0 | 83.9 | 16 | 87 | 14 | 100 | 0 | 261 | 1 | 918 | 1004 | MBC7467272.1 efflux RND transporter permease subunit [Bdellovibrio sp.] | diamond | 4176 | 142 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 27729680 | 27729680 | PRJEB83101_P_NODE_45104_length_285_cov_1.127358_g44799_i0 | PRJEB83101 | 45104 | 285 | 1.127358 | 3.2129703 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 63.5 | 2.97e-9 | NR | PZP55814.1 | 349221 | g44799 | i0 | 47.3 | 1.17894736842105 | 112 | 41 | 98.9 | 4 | 282 | 1 | 122 | 233 | PZP55814.1 MAG: hybrid sensor histidine kinase/response regulator, partial [Micavibrio aeruginosavorus] | diamond | 336 | 63.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 28100715 | 28100715 | PRJEB83101_P_NODE_75605_length_247_cov_1.793103_g75300_i0 | PRJEB83101 | 75605 | 247 | 1.793103 | 4.42896441 | Bacteria | 2 | Bacteria | Bacteria | 145 | 9.27e-40 | NR | HVK61701.1 | 2053517 | g75300 | i0 | 90.2 | 1.9919028340081 | 82 | 8 | 99.6 | 0 | 1 | 246 | 303 | 384 | HVK61701.1 acetyl-CoA C-acyltransferase [Bdellovibrionales bacterium] | diamond | 492 | 145 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29276311 | 29276311 | PRJEB83101_P_NODE_60749_length_259_cov_1.317204_g60444_i0 | PRJEB83101 | 60749 | 259 | 1.317204 | 3.41155836 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 53.1 | 3.95e-7 | NR | MBT7670529.1 | 2053517 | g60444 | i0 | 60.5 | 1.47104247104247 | 43 | 15 | 47.5 | 1 | 137 | 259 | 5 | 47 | MBT7670529.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 381 | 53.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30090046 | 30090046 | PRJEB83101_P_NODE_84572_length_243_cov_0.917647_g84267_i0 | PRJEB83101 | 84572 | 243 | 0.917647 | 2.22988221 | Bdellovibrio | 958 | Bacteria | Bacteria | 150 | 1.1199999999999999e-40 | NR | MEN0057597.1 | 28201 | g84267 | i0 | 83.8 | 1.97530864197531 | 80 | 13 | 98.8 | 0 | 3 | 242 | 119 | 198 | MEN0057597.1 DEAD/DEAH box helicase [Bdellovibrio sp.] | diamond | 480 | 151 | 0.993377483443709 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 30097406 | 30097406 | PRJEB83101_P_NODE_62772_length_256_cov_1.327869_g62467_i0 | PRJEB83101 | 62772 | 256 | 1.327869 | 3.39934464 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 107 | 3.3100000000000004e-26 | NR | PZP56867.1 | 349221 | g62467 | i0 | 65.4 | 0.94921875 | 81 | 28 | 94.9 | 0 | 251 | 9 | 5 | 85 | PZP56867.1 MAG: hypothetical protein DI586_02315 [Micavibrio aeruginosavorus] | diamond | 243 | 107 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30406479 | 30406479 | PRJEB83101_P_NODE_50713_length_275_cov_1.262376_g50408_i0 | PRJEB83101 | 50713 | 275 | 1.262376 | 3.471534 | Bacteria | 2 | Bacteria | Bacteria | 88.2 | 4.31e-18 | NR | MCM2281808.1 | 2026715 | g50408 | i0 | 51.3 | 4.37454545454545 | 78 | 38 | 85.1 | 0 | 275 | 42 | 279 | 356 | MCM2281808.1 O-antigen ligase family protein [Pseudobdellovibrionaceae bacterium] | diamond | 1203 | 88.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 31202907 | 31202907 | PRJEB83101_P_NODE_64155_length_254_cov_1.342541_g63850_i0 | PRJEB83101 | 64155 | 254 | 1.342541 | 3.41005414 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 57.8 | 2.02e-7 | NR | MBS1969502.1 | 2053517 | g63850 | i0 | 42.2 | 0.980314960629921 | 83 | 40 | 94.5 | 5 | 253 | 14 | 220 | 297 | MBS1969502.1 porin [Bdellovibrionales bacterium] | diamond | 249 | 57.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31519808 | 31519808 | PRJEB83101_P_NODE_52916_length_271_cov_1.575758_g52611_i0 | PRJEB83101 | 52916 | 271 | 1.575758 | 4.27030418 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 173 | 5.5e-51 | NR | MBX3023203.1 | 2053517 | g52611 | i0 | 88.8 | 0.985239852398524 | 89 | 10 | 98.5 | 0 | 268 | 2 | 70 | 158 | MBX3023203.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 267 | 173 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31962465 | 31962465 | PRJEB83101_P_NODE_64538_length_253_cov_1.788889_g64233_i0 | PRJEB83101 | 64538 | 253 | 1.788889 | 4.52588917 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 135 | 3.1899999999999997e-37 | NR | HEY8280076.1 | 3034175 | g64233 | i0 | 79.8 | 0.99604743083004 | 84 | 17 | 99.6 | 0 | 252 | 1 | 107 | 190 | HEY8280076.1 carboxylating nicotinate-nucleotide diphosphorylase [Bdellovibrionota bacterium] | diamond | 252 | 135 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32057394 | 32057394 | PRJEB83101_P_NODE_60758_length_259_cov_1.306452_g60453_i0 | PRJEB83101 | 60758 | 259 | 1.306452 | 3.38371068 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 162 | 3.92e-44 | NR | MES2767986.1 | 3034175 | g60453 | i0 | 91.8 | 0.984555984555985 | 85 | 7 | 98.5 | 0 | 3 | 257 | 329 | 413 | MES2767986.1 3'-5' exonuclease [Bdellovibrionota bacterium] | diamond | 255 | 162 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32279129 | 32279129 | PRJEB83101_P_NODE_79579_length_245_cov_1.523256_g79274_i0 | PRJEB83101 | 79579 | 245 | 1.523256 | 3.7319772 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 136 | 5.1e-37 | NR | HMN68335.1 | 2053517 | g79274 | i0 | 86.4 | 0.991836734693878 | 81 | 11 | 99.2 | 0 | 2 | 244 | 96 | 176 | HMN68335.1 peptidylprolyl isomerase [Bdellovibrionales bacterium] | diamond | 243 | 136 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32847021 | 32847021 | PRJEB83101_P_NODE_77780_length_246_cov_1.427746_g77475_i0 | PRJEB83101 | 77780 | 246 | 1.427746 | 3.51225516 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 159 | 1.5e-45 | NR | MCK6594806.1 | 2081706 | g77475 | i0 | 96.3 | 1 | 82 | 3 | 100 | 0 | 246 | 1 | 64 | 145 | MCK6594806.1 alanine racemase [Bacteriovoracaceae bacterium] | diamond | 246 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae 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);;