contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11470660 | 11470660 | PRJNA975724_S_NODE_5809_length_506_cov_7.563510_g5630_i0 | PRJNA975724 | 5809 | 506 | 7.56351 | 38.2713606 | root | 1 | Root_unresolved | Root_unresolved | 126 | 3.56e-31 | NR | MBC7465500.1 | 28201 | g5630 | i0 | 73.3 | 10.6778656126482 | 86 | 23 | 51 | 0 | 506 | 249 | 304 | 389 | MBC7465500.1 cystathionine gamma-synthase [Bdellovibrio sp.] | diamond | 5403 | 126 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 26994110 | 26994110 | PRJNA975724_S_NODE_22522_length_375_cov_2.248344_g22341_i0 | PRJNA975724 | 22522 | 375 | 2.248344 | 8.43129 | Pseudobdellovibrio sp. | 2862747 | Bacteria | Bacteria | 153 | 2.97e-42 | NR | MCC2679291.1 | 2862747 | g22341 | i0 | 76 | 0.768 | 96 | 23 | 76.8 | 0 | 2 | 289 | 284 | 379 | MCC2679291.1 cystathionine gamma-lyase [Pseudobdellovibrio sp.] | diamond | 288 | 153 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. | ||
| 27443420 | 27443420 | PRJNA975724_S_NODE_71123_length_261_cov_1.228723_g70942_i0 | PRJNA975724 | 71123 | 261 | 1.228723 | 3.20696703 | Bdellovibrio | 958 | Bacteria | Bacteria | 144 | 9.349999999999999e-42 | NR | OYZ21784.1 | 1970323 | g70942 | i0 | 77.9 | 2.96551724137931 | 86 | 19 | 98.9 | 0 | 259 | 2 | 59 | 144 | OYZ21784.1 MAG: hypothetical protein B7Y39_08430 [Bdellovibrio sp. 28-41-41] | diamond | 774 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. 28-41-41 | ||
| 27815940 | 27815940 | PRJNA975724_S_NODE_86164_length_245_cov_0.895349_g85983_i0 | PRJNA975724 | 86164 | 245 | 0.895349 | 2.19360505 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 99.4 | 2.0299999999999998e-23 | NR | MBL7554494.1 | 2026715 | g85983 | i0 | 98.2 | 0.673469387755102 | 55 | 1 | 67.3 | 0 | 244 | 80 | 51 | 105 | MBL7554494.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 165 | 99.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29678270 | 29678270 | PRJNA975724_S_NODE_42330_length_314_cov_1.917012_g42149_i0 | PRJNA975724 | 42330 | 314 | 1.917012 | 6.01941768 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 166 | 4.99e-50 | NR | MBL7543824.1 | 2026715 | g42149 | i0 | 79.6 | 0.984076433121019 | 103 | 20 | 97.5 | 1 | 8 | 313 | 32 | 134 | MBL7543824.1 Hsp20/alpha crystallin family protein [Pseudobdellovibrionaceae bacterium] | diamond | 309 | 166 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 31384962 | 31384962 | PRJNA975724_S_NODE_82816_length_247_cov_2.931034_g82635_i0 | PRJNA975724 | 82816 | 247 | 2.931034 | 7.23965398 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 110 | 5.4300000000000006e-27 | NR | MES2801063.1 | 3034175 | g82635 | i0 | 63.2 | 1.91902834008097 | 76 | 27 | 92.3 | 1 | 235 | 8 | 246 | 320 | MES2801063.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 474 | 110 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota 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);;