contig_metadata
21 rows where bioproject = "PRJNA980587", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1269591 | 1269591 | PRJNA980587_P_NODE_6981_length_1077_cov_8.260956_g6423_i0 | PRJNA980587 | 6981 | 1077 | 8.260956 | 88.97049612 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 124 | 4.54e-30 | NR | MCB0369154.1 | 2053517 | g6423 | i0 | 48.9 | 0.799442896935933 | 141 | 62 | 39 | 4 | 412 | 831 | 16 | 147 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 861 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 11159197 | 11159197 | PRJNA980587_P_NODE_54349_length_311_cov_0.945378_g53556_i0 | PRJNA980587 | 54349 | 311 | 0.945378 | 2.94012558 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 555 | 1.8199999999999994e-153 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g53556 | i0 | 99.032 | 58.6237942122186 | 310 | 2 | 99 | 1 | 1 | 309 | 512008 | 512317 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 18232 | 555 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 12434492 | 12434492 | PRJNA980587_P_NODE_10250_length_868_cov_2.031447_g9573_i0 | PRJNA980587 | 10250 | 868 | 2.031447 | 17.63295996 | Halobacteriovorax sp. | 2020862 | Bacteria | Bacteria | 201 | 1.44e-58 | NR | MBK23259.1 | 2020862 | g9573 | i0 | 58.6 | 2.39861751152074 | 174 | 70 | 59.8 | 2 | 1 | 519 | 197 | 369 | MBK23259.1 S-(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase [Halobacteriovorax sp.] | diamond | 2082 | 201 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. | ||
| 25182328 | 25182328 | PRJNA980587_P_NODE_81720_length_249_cov_0.875000_g80927_i0 | PRJNA980587 | 81720 | 249 | 0.875 | 2.17875 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 155 | 4.9099999999999996e-42 | NR | MBX3021635.1 | 2053517 | g80927 | i0 | 85.5 | 1 | 83 | 12 | 100 | 0 | 249 | 1 | 116 | 198 | MBX3021635.1 elongation factor G [Bdellovibrionales bacterium] | diamond | 249 | 155 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 26804581 | 26804581 | PRJNA980587_P_NODE_51841_length_319_cov_1.252033_g51048_i0 | PRJNA980587 | 51841 | 319 | 1.252033 | 3.99398527 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 52.8 | 2.69e-5 | NR | MDY0008143.1 | 2053517 | g51048 | i0 | 36.1 | 3.70532915360502 | 83 | 52 | 78.1 | 1 | 254 | 6 | 463 | 544 | MDY0008143.1 ankyrin repeat domain-containing protein [Bdellovibrionales bacterium] | diamond | 1182 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27437313 | 27437313 | PRJNA980587_P_NODE_82563_length_249_cov_0.875000_g81770_i0 | PRJNA980587 | 82563 | 249 | 0.875 | 2.17875 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 84 | 1.22e-16 | NR | MFL5813012.1 | 3034169 | g81770 | i0 | 53.8 | 0.963855421686747 | 80 | 35 | 96.4 | 2 | 247 | 8 | 537 | 614 | MFL5813012.1 M3 family metallopeptidase [Bdellovibrionia bacterium] | diamond | 240 | 84 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 27531776 | 27531776 | PRJNA980587_P_NODE_75803_length_256_cov_2.295082_g75010_i0 | PRJNA980587 | 75803 | 256 | 2.295082 | 5.87540992 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 43.9 | 0.0176 | NR | MAS87354.1 | 2024841 | g75010 | i0 | 34.6 | 0.94921875 | 81 | 51 | 94.9 | 1 | 2 | 244 | 489 | 567 | MAS87354.1 2-oxoglutarate dehydrogenase E1 component [Micavibrio sp.] | diamond | 243 | 43.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 27595074 | 27595074 | PRJNA980587_P_NODE_92984_length_242_cov_0.911243_g92191_i0 | PRJNA980587 | 92984 | 242 | 0.911243 | 2.20520806 | Halobacteriovorax marinus | 97084 | Bacteria | Bacteria | 69.3 | 1.6e-11 | NR | OUR98507.1 | 97084 | g92191 | i0 | 39.7 | 3.86776859504132 | 78 | 47 | 96.7 | 0 | 235 | 2 | 852 | 929 | OUR98507.1 isoleucine--tRNA ligase [Halobacteriovorax marinus] | diamond | 936 | 69.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 27910401 | 27910401 | PRJNA980587_P_NODE_72025_length_265_cov_1.458333_g71232_i0 | PRJNA980587 | 72025 | 265 | 1.458333 | 3.86458245 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 126 | 2.4e-34 | NR | MBX3020991.1 | 2053517 | g71232 | i0 | 75.6 | 0.883018867924528 | 78 | 19 | 88.3 | 0 | 31 | 264 | 1 | 78 | MBX3020991.1 DNA-3-methyladenine glycosylase [Bdellovibrionales bacterium] | diamond | 234 | 126 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27973812 | 27973812 | PRJNA980587_P_NODE_50845_length_322_cov_1.823293_g50052_i0 | PRJNA980587 | 50845 | 322 | 1.823293 | 5.87100346 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 127 | 1.23e-31 | NR | MBC7370521.1 | 2026715 | g50052 | i0 | 55.7 | 0.987577639751553 | 106 | 47 | 98.8 | 0 | 320 | 3 | 506 | 611 | MBC7370521.1 5-histidylcysteine sulfoxide synthase [Pseudobdellovibrionaceae bacterium] | diamond | 318 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 28668580 | 28668580 | PRJNA980587_P_NODE_96687_length_225_cov_4.026316_g95894_i0 | PRJNA980587 | 96687 | 225 | 4.026316 | 9.059211 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 55.8 | 6.71e-7 | NR | MFN8792340.1 | 2053517 | g95894 | i0 | 69.4 | 0.933333333333333 | 36 | 11 | 48 | 0 | 2 | 109 | 349 | 384 | MFN8792340.1 cystathionine gamma-synthase [Bdellovibrionales bacterium] | diamond | 210 | 55.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28920867 | 28920867 | PRJNA980587_P_NODE_76288_length_255_cov_1.917582_g75495_i0 | PRJNA980587 | 76288 | 255 | 1.917582 | 4.8898341 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 77 | 3.59e-14 | NR | WP_015468752.1 | 453816 | g75495 | i0 | 45.2 | 0.988235294117647 | 84 | 42 | 98.8 | 2 | 253 | 2 | 298 | 377 | WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 252 | 77 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 29079049 | 29079049 | PRJNA980587_P_NODE_72568_length_264_cov_1.209424_g71775_i0 | PRJNA980587 | 72568 | 264 | 1.209424 | 3.19287936 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 63.9 | 1.61e-9 | NR | WP_015468758.1 | 453816 | g71775 | i0 | 47.6 | 1.36363636363636 | 63 | 32 | 70.5 | 1 | 3 | 188 | 378 | 440 | WP_015468758.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 360 | 63.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 29205377 | 29205377 | PRJNA980587_P_NODE_35169_length_399_cov_2.723926_g34376_i0 | PRJNA980587 | 35169 | 399 | 2.723926 | 10.86846474 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 83.6 | 1.06e-15 | NR | WP_015468752.1 | 453816 | g34376 | i0 | 52.1 | 0.533834586466165 | 71 | 32 | 51.9 | 2 | 232 | 26 | 334 | 404 | WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 213 | 83.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 29741689 | 29741689 | PRJNA980587_P_NODE_66190_length_278_cov_1.502439_g65397_i0 | PRJNA980587 | 66190 | 278 | 1.502439 | 4.17678042 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 43.5 | 0.0302 | NR | MCM2350925.1 | 2081706 | g65397 | i0 | 34.9 | 0.89568345323741 | 83 | 45 | 79.9 | 3 | 9 | 230 | 455 | 537 | MCM2350925.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 249 | 43.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29931640 | 29931640 | PRJNA980587_P_NODE_96031_length_235_cov_2.432099_g95238_i0 | PRJNA980587 | 96031 | 235 | 2.432099 | 5.71543265 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 116 | 1.12e-30 | NR | MBX9767865.1 | 2053517 | g95238 | i0 | 66.7 | 0.995744680851064 | 78 | 26 | 99.6 | 0 | 2 | 235 | 73 | 150 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 234 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31194845 | 31194845 | PRJNA980587_P_NODE_94595_length_241_cov_0.916667_g93802_i0 | PRJNA980587 | 94595 | 241 | 0.916667 | 2.20916747 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 61.6 | 7.79e-9 | NR | MCB0393559.1 | 2053517 | g93802 | i0 | 58.3 | 1.3195020746888 | 48 | 18 | 59.8 | 1 | 155 | 12 | 45 | 90 | MCB0393559.1 biosynthetic arginine decarboxylase [Bdellovibrionales bacterium] | diamond | 318 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31897203 | 31897203 | PRJNA980587_P_NODE_89817_length_244_cov_0.900585_g89024_i0 | PRJNA980587 | 89817 | 244 | 0.900585 | 2.1974274 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 72 | 1.81e-12 | NR | MFN8847391.1 | 2053517 | g89024 | i0 | 70 | 1.95491803278689 | 50 | 15 | 61.5 | 0 | 155 | 6 | 1046 | 1095 | MFN8847391.1 tail fiber domain-containing protein [Bdellovibrionales bacterium] | diamond | 477 | 72 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31954277 | 31954277 | PRJNA980587_P_NODE_44137_length_348_cov_1.661818_g43344_i0 | PRJNA980587 | 44137 | 348 | 1.661818 | 5.78312664 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 77.4 | 8.19e-14 | NR | MFT6069596.1 | 2081706 | g43344 | i0 | 48.8 | 2.12068965517241 | 80 | 41 | 69 | 0 | 340 | 101 | 409 | 488 | MFT6069596.1 leucyl aminopeptidase [Bacteriovoracaceae bacterium] | diamond | 738 | 77.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32080860 | 32080860 | PRJNA980587_P_NODE_18678_length_595_cov_1.879310_g17895_i0 | PRJNA980587 | 18678 | 595 | 1.87931 | 11.1818945 | Bdellovibrionales bacterium RBG_16_4 | 2053517 | Bacteria | Bacteria | 48.1 | 0.0106 | NR | OFZ12118.1 | 1797388 | g17895 | i0 | 36.9 | 0.746218487394958 | 65 | 41 | 32.8 | 0 | 179 | 373 | 427 | 491 | OFZ12118.1 MAG: hypothetical protein A2Z20_07270 [Bdellovibrionales bacterium RBG_16_40_8] | diamond | 444 | 48.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RBG_16_40_8 | ||||
| 32239411 | 32239411 | PRJNA980587_P_NODE_23178_length_519_cov_1.697309_g22387_i0 | PRJNA980587 | 23178 | 519 | 1.697309 | 8.80903371 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 90.5 | 1.49e-17 | NR | WP_015468752.1 | 453816 | g22387 | i0 | 55.7 | 0.456647398843931 | 79 | 30 | 43.9 | 2 | 517 | 290 | 318 | 394 | WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 237 | 90.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus |
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);;