contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3423682 | 3423682 | PRJNA896758_P_NODE_6343_length_452_cov_1.216359_g5953_i0 | PRJNA896758 | 6343 | 452 | 1.216359 | 5.49794268 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 160 | 4.2099999999999996e-47 | NR | MCB0370127.1 | 2053517 | g5953 | i0 | 72.3 | 0.743362831858407 | 112 | 31 | 74.3 | 0 | 336 | 1 | 37 | 148 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 336 | 160 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 26992233 | 26992233 | PRJNA896758_P_NODE_22822_length_248_cov_0.880000_g22432_i0 | PRJNA896758 | 22822 | 248 | 0.88 | 2.1824 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 75.9 | 8.67e-14 | NR | HAR41289.1 | 2053517 | g22432 | i0 | 62.5 | 3.81048387096774 | 64 | 21 | 77.4 | 1 | 2 | 193 | 221 | 281 | HAR41289.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 945 | 75.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27308755 | 27308755 | PRJNA896758_P_NODE_18883_length_268_cov_1.184615_g18493_i0 | PRJNA896758 | 18883 | 268 | 1.184615 | 3.1747682 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 63.2 | 2.34e-9 | NR | MCB0369784.1 | 2053517 | g18493 | i0 | 58.5 | 0.593283582089552 | 53 | 22 | 59.3 | 0 | 192 | 34 | 160 | 212 | MCB0369784.1 insulinase family protein [Bdellovibrionales bacterium] | diamond | 159 | 63.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28603270 | 28603270 | PRJNA896758_P_NODE_21807_length_250_cov_0.870056_g21417_i0 | PRJNA896758 | 21807 | 250 | 0.870056 | 2.17514 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 148 | 2.9e-39 | NR | HEU4839420.1 | 2024841 | g21417 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 1 | 249 | 71 | 153 | HEU4839420.1 type I secretion system permease/ATPase [Micavibrio sp.] | diamond | 249 | 148 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 28760906 | 28760906 | PRJNA896758_P_NODE_11047_length_345_cov_1.981618_g10657_i0 | PRJNA896758 | 11047 | 345 | 1.981618 | 6.8365821 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 47.4 | 0.0019 | NR | MCB0368971.1 | 2053517 | g10657 | i0 | 35.8 | 0.460869565217391 | 53 | 34 | 46.1 | 0 | 88 | 246 | 34 | 86 | MCB0368971.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 159 | 47.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29013967 | 29013967 | PRJNA896758_P_NODE_26608_length_241_cov_0.916667_g26218_i0 | PRJNA896758 | 26608 | 241 | 0.916667 | 2.20916747 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 44.3 | 0.00254 | NR | MCB0368049.1 | 2053517 | g26218 | i0 | 65.6 | 0.398340248962656 | 32 | 11 | 39.8 | 0 | 86 | 181 | 62 | 93 | MCB0368049.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 96 | 44.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29360990 | 29360990 | PRJNA896758_P_NODE_22669_length_248_cov_1.760000_g22279_i0 | PRJNA896758 | 22669 | 248 | 1.76 | 4.3648 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 103 | 2.55e-25 | NR | MBX9702836.1 | 2654442 | g22279 | i0 | 53.1 | 0.979838709677419 | 81 | 38 | 98 | 0 | 248 | 6 | 126 | 206 | MBX9702836.1 protein kinase [Silvanigrellaceae bacterium] | diamond | 243 | 103 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 29992547 | 29992547 | PRJNA896758_P_NODE_11491_length_339_cov_1.157895_g11101_i0 | PRJNA896758 | 11491 | 339 | 1.157895 | 3.92526405 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 141 | 5.88e-41 | NR | MCB0370182.1 | 2053517 | g11101 | i0 | 87 | 1.43362831858407 | 77 | 10 | 68.1 | 0 | 1 | 231 | 43 | 119 | MCB0370182.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 486 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30118751 | 30118751 | PRJNA896758_P_NODE_16312_length_285_cov_1.382075_g15922_i0 | PRJNA896758 | 16312 | 285 | 1.382075 | 3.93891375 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 45.1 | 0.00272 | NR | MCB0370850.1 | 2053517 | g15922 | i0 | 52.8 | 0.378947368421053 | 36 | 16 | 36.8 | 1 | 204 | 100 | 52 | 87 | MCB0370850.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 108 | 45.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31351360 | 31351360 | PRJNA896758_P_NODE_11596_length_338_cov_0.871698_g11206_i0 | PRJNA896758 | 11596 | 338 | 0.871698 | 2.94633924 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 100 | 5.54e-25 | NR | MCB0371230.1 | 2053517 | g11206 | i0 | 72.5 | 0.612426035502959 | 69 | 19 | 61.2 | 0 | 6 | 212 | 18 | 86 | MCB0371230.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 207 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31920635 | 31920635 | PRJNA896758_P_NODE_26097_length_242_cov_0.911243_g25707_i0 | PRJNA896758 | 26097 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 45.4 | 0.00404 | NR | MCB0370360.1 | 2053517 | g25707 | i0 | 33.8 | 1.90909090909091 | 77 | 51 | 95.5 | 0 | 11 | 241 | 158 | 234 | MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium] | diamond | 462 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32015517 | 32015517 | PRJNA896758_P_NODE_14218_length_305_cov_0.995690_g13828_i0 | PRJNA896758 | 14218 | 305 | 0.99569 | 3.0368545 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 130 | 4.71e-33 | NR | MCB0370360.1 | 2053517 | g13828 | i0 | 81.8 | 0.757377049180328 | 77 | 14 | 75.7 | 0 | 303 | 73 | 400 | 476 | MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium] | diamond | 231 | 130 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32110508 | 32110508 | PRJNA896758_P_NODE_26858_length_230_cov_2.738854_g26468_i0 | PRJNA896758 | 26858 | 230 | 2.738854 | 6.2993642 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 104 | 2.67e-27 | NR | MCB0369232.1 | 2053517 | g26468 | i0 | 62.3 | 0.9 | 69 | 26 | 90 | 0 | 228 | 22 | 10 | 78 | MCB0369232.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 207 | 104 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32142144 | 32142144 | PRJNA896758_P_NODE_15618_length_289_cov_1.685185_g15228_i0 | PRJNA896758 | 15618 | 289 | 1.685185 | 4.87018465 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 66.6 | 3.47e-11 | NR | MCB0368770.1 | 2053517 | g15228 | i0 | 39.5 | 0.892733564013841 | 86 | 49 | 86.2 | 2 | 39 | 287 | 4 | 89 | MCB0368770.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 258 | 66.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32363834 | 32363834 | PRJNA896758_P_NODE_6719_length_437_cov_2.541209_g6329_i0 | PRJNA896758 | 6719 | 437 | 2.541209 | 11.10508333 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 241 | 1.8200000000000003e-79 | NR | MCB0369869.1 | 2053517 | g6329 | i0 | 82.8 | 1.9908466819222 | 145 | 25 | 99.5 | 0 | 1 | 435 | 3 | 147 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 870 | 241 | 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);;