contig_metadata
13 rows where bioproject = "PRJNA781196", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10963708 | 10963708 | PRJNA781196_P_NODE_56349_length_249_cov_0.886364_g55972_i0 | PRJNA781196 | 56349 | 249 | 0.886364 | 2.20704636 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 120 | 3.5099999999999993e-31 | NR | MCB0370750.1 | 2053517 | g55972 | i0 | 73.2 | 0.987951807228916 | 82 | 20 | 98.8 | 1 | 247 | 2 | 116 | 195 | MCB0370750.1 inositol-3-phosphate synthase [Bdellovibrionales bacterium] | diamond | 246 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 17337366 | 17337366 | PRJNA781196_P_NODE_26754_length_335_cov_1.786260_g26377_i0 | PRJNA781196 | 26754 | 335 | 1.78626 | 5.983971 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 194 | 5.35e-58 | NR | MCB0368368.1 | 2053517 | g26377 | i0 | 87.3 | 0.985074626865672 | 110 | 14 | 98.5 | 0 | 330 | 1 | 164 | 273 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 330 | 194 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 23712029 | 23712029 | PRJNA781196_P_NODE_31559_length_313_cov_1.416667_g31182_i0 | PRJNA781196 | 31559 | 313 | 1.416667 | 4.43416771 | Bacteria | 2 | Bacteria | Bacteria | 173 | 3.08e-50 | NR | WP_102242450.1 | 960 | g31182 | i0 | 85.6 | 38.8753993610224 | 97 | 14 | 93 | 0 | 291 | 1 | 2 | 98 | WP_102242450.1 isocitrate dehydrogenase (NADP(+)) [Bacteriovorax stolpii] | diamond | 12168 | 173 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 23712505 | 23712505 | PRJNA781196_P_NODE_62219_length_245_cov_0.906977_g61842_i0 | PRJNA781196 | 62219 | 245 | 0.906977 | 2.22209365 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 147 | 6.63e-39 | NR | MES3036873.1 | 3034175 | g61842 | i0 | 80.2 | 3.96734693877551 | 81 | 16 | 99.2 | 0 | 3 | 245 | 78 | 158 | MES3036873.1 aconitate hydratase [Bdellovibrionota bacterium] | diamond | 972 | 147 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27157355 | 27157355 | PRJNA781196_P_NODE_11422_length_479_cov_1.034483_g11046_i0 | PRJNA781196 | 11422 | 479 | 1.034483 | 4.95517357 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 145 | 1.84e-41 | NR | GJL85093.1 | 2024841 | g11046 | i0 | 58.1 | 4.84133611691023 | 124 | 51 | 77 | 1 | 371 | 3 | 4 | 127 | GJL85093.1 MAG: group 1 truncated hemoglobin [Micavibrio sp.] | diamond | 2319 | 146 | 0.993150684931507 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 27306467 | 27306467 | PRJNA781196_P_NODE_12823_length_455_cov_2.861257_g12446_i0 | PRJNA781196 | 12823 | 455 | 2.861257 | 13.01871935 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 120 | 3.5e-28 | NR | MEZ4704431.1 | 3034175 | g12446 | i0 | 45.7 | 0.995604395604396 | 151 | 71 | 99.6 | 4 | 2 | 454 | 408 | 547 | MEZ4704431.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 453 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27748759 | 27748759 | PRJNA781196_P_NODE_52044_length_252_cov_0.871508_g51667_i0 | PRJNA781196 | 52044 | 252 | 0.871508 | 2.19620016 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 48.9 | 2.58e-4 | NR | MAS86452.1 | 2024841 | g51667 | i0 | 49 | 1.5952380952381 | 51 | 22 | 60.7 | 1 | 238 | 86 | 138 | 184 | MAS86452.1 RNA pseudouridine synthase [Micavibrio sp.] | diamond | 402 | 48.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 27938051 | 27938051 | PRJNA781196_P_NODE_50065_length_253_cov_0.866667_g49688_i0 | PRJNA781196 | 50065 | 253 | 0.866667 | 2.19266751 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 96.3 | 6.559999999999999e-23 | NR | MBP9675022.1 | 2081706 | g49688 | i0 | 82.5 | 0.675889328063241 | 57 | 10 | 67.6 | 0 | 171 | 1 | 27 | 83 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 171 | 96.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29210426 | 29210426 | PRJNA781196_P_NODE_42329_length_275_cov_1.544554_g41952_i0 | PRJNA781196 | 42329 | 275 | 1.544554 | 4.2475235 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 68.2 | 5.83e-11 | NR | MCB0326472.1 | 2053517 | g41952 | i0 | 60.4 | 2.22545454545455 | 53 | 20 | 56.7 | 1 | 118 | 273 | 190 | 242 | MCB0326472.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 612 | 68.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30274932 | 30274932 | PRJNA781196_P_NODE_24552_length_347_cov_1.609489_g24175_i0 | PRJNA781196 | 24552 | 347 | 1.609489 | 5.58492683 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 104 | 2.3299999999999994e-23 | NR | MCM2348460.1 | 2081706 | g24175 | i0 | 44.1 | 1.92795389048991 | 111 | 61 | 96 | 1 | 345 | 13 | 972 | 1081 | MCM2348460.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 669 | 104 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31507434 | 31507434 | PRJNA781196_P_NODE_40016_length_283_cov_1.152381_g39639_i0 | PRJNA781196 | 40016 | 283 | 1.152381 | 3.26123823 | Pseudobacteriovorax sp. | 2020859 | Bacteria | Bacteria | 57.4 | 3.25e-7 | NR | NRA68171.1 | 2020859 | g39639 | i0 | 38.8 | 0.848056537102474 | 80 | 41 | 84.8 | 1 | 281 | 42 | 216 | 287 | NRA68171.1 alpha/beta hydrolase [Pseudobacteriovorax sp.] | diamond | 240 | 57.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Pseudobacteriovoracaceae | Pseudobacteriovorax | Pseudobacteriovorax sp. | ||
| 31539022 | 31539022 | PRJNA781196_P_NODE_45696_length_265_cov_1.218750_g45319_i0 | PRJNA781196 | 45696 | 265 | 1.21875 | 3.2296875 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 132 | 4.77e-36 | NR | MCB0368225.1 | 2053517 | g45319 | i0 | 72.4 | 0.984905660377358 | 87 | 24 | 98.5 | 0 | 261 | 1 | 34 | 120 | MCB0368225.1 HAD family hydrolase [Bdellovibrionales bacterium] | diamond | 261 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32529215 | 32529215 | PRJNA781196_P_NODE_54059_length_250_cov_1.762712_g53682_i0 | PRJNA781196 | 54059 | 250 | 1.762712 | 4.40678 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 114 | 3.69e-27 | NR | MFN8943610.1 | 2026715 | g53682 | i0 | 70.4 | 6.936 | 81 | 24 | 97.2 | 0 | 2 | 244 | 128 | 208 | MFN8943610.1 pyruvate, phosphate dikinase [Pseudobdellovibrionaceae bacterium] | diamond | 1734 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae 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);;