contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB11523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3533152 | 3533152 | PRJEB11523_P_NODE_3043_length_288_cov_4.100418_g2965_i0 | PRJEB11523 | 3043 | 288 | 4.100418 | 11.80920384 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 150 | 6.4e-44 | NR | MBX3019228.1 | 2026715 | g2965 | i0 | 85.9 | 2.61458333333333 | 85 | 12 | 88.5 | 0 | 277 | 23 | 75 | 159 | MBX3019228.1 F0F1 ATP synthase subunit beta [Pseudobdellovibrionaceae bacterium] | diamond | 753 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 8940714 | 8940714 | PRJEB11523_P_NODE_2608_length_320_cov_17.033210_g2530_i0 | PRJEB11523 | 2608 | 320 | 17.03321 | 54.506272 | Bdellovibrio svalbardensis | 2972972 | Bacteria | Bacteria | 179 | 7.2899999999999995e-53 | NR | WP_277577659.1 | 2972972 | g2530 | i0 | 87.9 | 0.928125 | 99 | 12 | 92.8 | 0 | 10 | 306 | 76 | 174 | WP_277577659.1 hypothetical protein [Bdellovibrio svalbardensis] | diamond | 297 | 179 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio svalbardensis | ||
| 12461624 | 12461624 | PRJEB11523_P_NODE_3990_length_240_cov_10.335079_g3912_i0 | PRJEB11523 | 3990 | 240 | 10.335079 | 24.8041896 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 62.4 | 4.23e-9 | NR | MCB0346244.1 | 2053517 | g3912 | i0 | 58 | 2.0625 | 50 | 21 | 62.5 | 0 | 173 | 24 | 407 | 456 | MCB0346244.1 AAA family ATPase [Bdellovibrionales bacterium] | diamond | 495 | 62.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 15315943 | 15315943 | PRJEB11523_P_NODE_1393_length_487_cov_6.041096_g1315_i0 | PRJEB11523 | 1393 | 487 | 6.041096 | 29.42013752 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 61.6 | 1.17e-7 | NR | WP_413287619.1 | 3394358 | g1315 | i0 | 36.7 | 0.554414784394251 | 90 | 48 | 51.7 | 3 | 406 | 155 | 206 | 292 | WP_413287619.1 hypothetical protein [Bdellovibrio sp. HCB337] | diamond | 270 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 26715796 | 26715796 | PRJEB11523_P_NODE_3921_length_243_cov_7.958763_g3843_i0 | PRJEB11523 | 3921 | 243 | 7.958763 | 19.33979409 | Bdellovibrio sp. 28-41-41 | 1970323 | Bacteria | Bacteria | 84.7 | 6.13e-17 | NR | OYZ24114.1 | 1970323 | g3843 | i0 | 56.9 | 1.77777777777778 | 72 | 31 | 88.9 | 0 | 5 | 220 | 149 | 220 | OYZ24114.1 MAG: hypothetical protein B7Y39_02630 [Bdellovibrio sp. 28-41-41] | diamond | 432 | 84.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. 28-41-41 | ||
| 26969366 | 26969366 | PRJEB11523_P_NODE_4882_length_213_cov_2.048780_g4804_i0 | PRJEB11523 | 4882 | 213 | 2.04878 | 4.3639014 | Bdellovibrio sp. NC | 28201 | Bacteria | Bacteria | 112 | 4.7e-27 | NR | WP_142697576.1 | 2220073 | g4804 | i0 | 80.9 | 0.957746478873239 | 68 | 13 | 95.8 | 0 | 2 | 205 | 358 | 425 | WP_142697576.1 aspartate--tRNA ligase [Bdellovibrio sp. NC01] | diamond | 204 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 27000898 | 27000898 | PRJEB11523_P_NODE_7762_length_166_cov_0.871795_g7684_i0 | PRJEB11523 | 7762 | 166 | 0.871795 | 1.4471797 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 79.7 | 1.17e-15 | NR | MFN8391120.1 | 3034175 | g7684 | i0 | 66.7 | 1.95180722891566 | 54 | 18 | 97.6 | 0 | 164 | 3 | 20 | 73 | MFN8391120.1 DNA polymerase I [Bdellovibrionota bacterium] | diamond | 324 | 79.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27980379 | 27980379 | PRJEB11523_P_NODE_7905_length_165_cov_0.879310_g7827_i0 | PRJEB11523 | 7905 | 165 | 0.87931 | 1.4508615 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 98.2 | 1.52e-24 | NR | MCM2349922.1 | 2081706 | g7827 | i0 | 81.5 | 0.981818181818182 | 54 | 10 | 98.2 | 0 | 163 | 2 | 16 | 69 | MCM2349922.1 PaaI family thioesterase [Bacteriovoracaceae bacterium] | diamond | 162 | 98.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28232687 | 28232687 | PRJEB11523_P_NODE_4506_length_223_cov_1.172414_g4428_i0 | PRJEB11523 | 4506 | 223 | 1.172414 | 2.61448322 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 143 | 9.62e-40 | NR | MDH4467768.1 | 2081706 | g4428 | i0 | 93.2 | 0.982062780269058 | 73 | 5 | 98.2 | 0 | 221 | 3 | 54 | 126 | MDH4467768.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 219 | 143 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28706655 | 28706655 | PRJEB11523_P_NODE_1267_length_517_cov_26.190171_g1190_i0 | PRJEB11523 | 1267 | 517 | 26.190171 | 135.40318407 | Bdellovibrio sp. BCCA | 3136281 | Bacteria | Bacteria | 72.8 | 2.15e-11 | NR | WP_340591252.1 | 3136281 | g1190 | i0 | 32.7 | 0.870406189555126 | 150 | 93 | 86.5 | 4 | 24 | 470 | 274 | 416 | WP_340591252.1 alkaline phosphatase D family protein [Bdellovibrio sp. BCCA] | diamond | 450 | 72.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. BCCA | ||
| 28864353 | 28864353 | PRJEB11523_P_NODE_8448_length_162_cov_0.902655_g8370_i0 | PRJEB11523 | 8448 | 162 | 0.902655 | 1.4623011 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 71.6 | 4.71e-13 | NR | MCM2349925.1 | 2081706 | g8370 | i0 | 53.7 | 1 | 54 | 25 | 100 | 0 | 1 | 162 | 57 | 110 | MCM2349925.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 162 | 71.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28959373 | 28959373 | PRJEB11523_P_NODE_2688_length_312_cov_22.216730_g2610_i0 | PRJEB11523 | 2688 | 312 | 22.21673 | 69.3161976 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 137 | 3.71e-35 | NR | HPI40107.1 | 2026715 | g2610 | i0 | 63.7 | 0.875 | 91 | 33 | 87.5 | 0 | 290 | 18 | 65 | 155 | HPI40107.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 273 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29653398 | 29653398 | PRJEB11523_P_NODE_5310_length_202_cov_10.660131_g5232_i0 | PRJEB11523 | 5310 | 202 | 10.660131 | 21.53346462 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 45.4 | 0.00163 | NR | HEY8270081.1 | 2026715 | g5232 | i0 | 66.7 | 0.445544554455446 | 30 | 10 | 44.6 | 0 | 169 | 80 | 156 | 185 | HEY8270081.1 DUF4143 domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 90 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29969521 | 29969521 | PRJEB11523_P_NODE_4511_length_222_cov_20.855491_g4433_i0 | PRJEB11523 | 4511 | 222 | 20.855491 | 46.29919002 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 47.8 | 4.5e-4 | NR | MCO5141707.1 | 2599941 | g4433 | i0 | 42.3 | 0.702702702702703 | 52 | 28 | 67.6 | 1 | 172 | 23 | 13 | 64 | MCO5141707.1 hypothetical protein [Oligoflexia bacterium] | diamond | 156 | 47.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30095811 | 30095811 | PRJEB11523_P_NODE_2972_length_292_cov_15.106996_g2894_i0 | PRJEB11523 | 2972 | 292 | 15.106996 | 44.11242832 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 77.4 | 1.01e-14 | NR | MEZ4741646.1 | 3034175 | g2894 | i0 | 58.1 | 0.636986301369863 | 62 | 25 | 63.7 | 1 | 269 | 84 | 29 | 89 | MEZ4741646.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 186 | 77.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30127253 | 30127253 | PRJEB11523_P_NODE_1492_length_467_cov_3.500000_g1414_i0 | PRJEB11523 | 1492 | 467 | 3.5 | 16.345 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 162 | 1.97e-43 | NR | MBC7396357.1 | 2599941 | g1414 | i0 | 56 | 0.963597430406852 | 150 | 66 | 96.4 | 0 | 460 | 11 | 1 | 150 | MBC7396357.1 hypothetical protein [Oligoflexia bacterium] | diamond | 450 | 162 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30254199 | 30254199 | PRJEB11523_P_NODE_4212_length_232_cov_19.240437_g4134_i0 | PRJEB11523 | 4212 | 232 | 19.240437 | 44.63781384 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 124 | 3.98e-33 | NR | MBC7741172.1 | 28201 | g4134 | i0 | 78.9 | 1.96551724137931 | 76 | 16 | 98.3 | 0 | 230 | 3 | 38 | 113 | MBC7741172.1 ABC transporter permease subunit [Bdellovibrio sp.] | diamond | 456 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 30664658 | 30664658 | PRJEB11523_P_NODE_5413_length_200_cov_2.132450_g5335_i0 | PRJEB11523 | 5413 | 200 | 2.13245 | 4.2649 | Bdellovibrio sp. HCB274 | 3394361 | Bacteria | Bacteria | 62.8 | 1.01e-10 | NR | WP_413584657.1 | 3394361 | g5335 | i0 | 74.4 | 0.585 | 39 | 10 | 58.5 | 0 | 200 | 84 | 58 | 96 | WP_413584657.1 hypothetical protein [Bdellovibrio sp. HCB274] | diamond | 117 | 62.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB274 | ||
| 30822629 | 30822629 | PRJEB11523_P_NODE_2394_length_340_cov_39.257732_g2316_i0 | PRJEB11523 | 2394 | 340 | 39.257732 | 133.4762888 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 162 | 3.89e-47 | NR | MFN8370375.1 | 2081706 | g2316 | i0 | 90.1 | 0.714705882352941 | 81 | 8 | 71.5 | 0 | 244 | 2 | 1 | 81 | MFN8370375.1 SPASM domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 243 | 162 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31360110 | 31360110 | PRJEB11523_P_NODE_6296_length_184_cov_1.518519_g6218_i0 | PRJEB11523 | 6296 | 184 | 1.518519 | 2.79407496 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 77 | 1.34e-14 | NR | MBX7231652.1 | 2053517 | g6218 | i0 | 58.3 | 0.978260869565217 | 60 | 25 | 97.8 | 0 | 3 | 182 | 300 | 359 | MBX7231652.1 DUF4153 domain-containing protein [Bdellovibrionales bacterium] | diamond | 180 | 77 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31707827 | 31707827 | PRJEB11523_P_NODE_4217_length_232_cov_11.967213_g4139_i0 | PRJEB11523 | 4217 | 232 | 11.967213 | 27.76393416 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 100 | 5.77e-23 | NR | MEQ1876290.1 | 3034169 | g4139 | i0 | 64.9 | 0.956896551724138 | 74 | 26 | 95.7 | 0 | 7 | 228 | 227 | 300 | MEQ1876290.1 inner-membrane translocator [Bdellovibrionia bacterium] | diamond | 222 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 31739307 | 31739307 | PRJEB11523_P_NODE_4617_length_219_cov_3.347059_g4539_i0 | PRJEB11523 | 4617 | 219 | 3.347059 | 7.33005921 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 143 | 6.25e-40 | NR | AZZ35809.1 | 1916293 | g4539 | i0 | 92.5 | 2.75342465753425 | 67 | 5 | 91.8 | 0 | 201 | 1 | 146 | 212 | AZZ35809.1 hypothetical protein CIK05_03000 [Bdellovibrio sp. qaytius] | diamond | 603 | 143 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 32870898 | 32870898 | PRJEB11523_P_NODE_1840_length_407_cov_21.153631_g1762_i0 | PRJEB11523 | 1840 | 407 | 21.153631 | 86.09527817 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 128 | 1.19e-33 | NR | MCB0319140.1 | 2053517 | g1762 | i0 | 48.4 | 2.77886977886978 | 128 | 65 | 93.6 | 1 | 1 | 381 | 107 | 234 | MCB0319140.1 prolipoprotein diacylglyceryl transferase [Bdellovibrionales bacterium] | diamond | 1131 | 128 | 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);;