contig_metadata
8 rows where bioproject = "PRJNA520845", tax_clade = "delta/epsilon subdivisions" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27013981 | 27013981 | PRJNA520845_P_NODE_38442_length_610_cov_1.700186_g36976_i0 | PRJNA520845 | 38442 | 610 | 1.700186 | 10.3711346 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 48.5 | 0.00155 | NR | ADI19205.1 | 710829 | g36976 | i0 | 60 | 0.147540983606557 | 30 | 12 | 14.8 | 0 | 439 | 528 | 63 | 92 | ADI19205.1 hypothetical protein [uncultured delta proteobacterium HF0130_20J24] | diamond | 90 | 48.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0130_20J24 | ||||||
| 27866875 | 27866875 | PRJNA520845_P_NODE_6285_length_1538_cov_6.242321_g5622_i0 | PRJNA520845 | 6285 | 1538 | 6.242321 | 96.00689698 | Lujinxingia litoralis | 2211119 | Bacteria | Bacteria | 55.1 | 2.59e-4 | NR | WP_158542511.1 | 2211119 | g5622 | i0 | 40.6 | 0.308192457737321 | 69 | 35 | 12.3 | 2 | 3 | 191 | 54 | 122 | WP_158542511.1 OmpA family protein [Lujinxingia litoralis] | diamond | 474 | 55.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingia | Lujinxingia litoralis | |||
| 27993365 | 27993365 | PRJNA520845_P_NODE_222845_length_249_cov_1.750000_g221346_i0 | PRJNA520845 | 222845 | 249 | 1.75 | 4.3575 | Lujinxingia litoralis | 2211119 | Bacteria | Bacteria | 53.5 | 6.43e-6 | NR | WP_111728921.1 | 2211119 | g221346 | i0 | 37.1 | 1.74698795180723 | 70 | 37 | 84.3 | 2 | 5 | 214 | 9 | 71 | WP_111728921.1 PPC domain-containing protein [Lujinxingia litoralis] | diamond | 435 | 53.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingia | Lujinxingia litoralis | |||
| 28119564 | 28119564 | PRJNA520845_P_NODE_61505_length_475_cov_1.393035_g60007_i0 | PRJNA520845 | 61505 | 475 | 1.393035 | 6.61691625 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 55.5 | 1.4e-5 | NR | WP_146962556.1 | 2600177 | g60007 | i0 | 56.3 | 0.303157894736842 | 48 | 19 | 30.3 | 1 | 209 | 66 | 356 | 401 | WP_146962556.1 hypothetical protein [Microvenator marinus] | diamond | 144 | 55.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 28340593 | 28340593 | PRJNA520845_P_NODE_268726_length_236_cov_2.061350_g267227_i0 | PRJNA520845 | 268726 | 236 | 2.06135 | 4.864786 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 49.7 | 1.14e-4 | NR | MBN1945519.1 | 2099667 | g267227 | i0 | 52.4 | 1.57627118644068 | 42 | 17 | 53.4 | 1 | 223 | 98 | 9 | 47 | MBN1945519.1 DUF4215 domain-containing protein [Bradymonadales bacterium] | diamond | 372 | 49.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 31182878 | 31182878 | PRJNA520845_P_NODE_80035_length_415_cov_1.505848_g78536_i0 | PRJNA520845 | 80035 | 415 | 1.505848 | 6.2492692 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 160 | 1.33e-47 | NR | HJL95153.1 | 2024889 | g78536 | i0 | 58.6 | 3.84578313253012 | 133 | 53 | 94.7 | 1 | 1 | 393 | 23 | 155 | HJL95153.1 hypothetical protein [SAR324 cluster bacterium] | diamond | 1596 | 160 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 31830804 | 31830804 | PRJNA520845_P_NODE_216197_length_251_cov_0.865169_g214698_i0 | PRJNA520845 | 216197 | 251 | 0.865169 | 2.17157419 | Pseudomonadota | 1224 | Bacteria | Bacteria | 80.5 | 2.07e-16 | NR | CAB1063070.1 | 698986 | g214698 | i0 | 53.8 | 2.84462151394422 | 80 | 36 | 94.4 | 1 | 238 | 2 | 2 | 81 | CAB1063070.1 hypothetical protein D1BOALGB6SA_7853 [Olavius sp. associated proteobacterium Delta 1] | diamond | 714 | 80.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Olavius sp. associated proteobacterium Delta 1 | ||||||
| 32732603 | 32732603 | PRJNA520845_P_NODE_256840_length_243_cov_0.905882_g255341_i0 | PRJNA520845 | 256840 | 243 | 0.905882 | 2.20129326 | Deltaproteobacteria bacterium ADurb.Bin2 | 2026735 | Bacteria | Bacteria | 91.3 | 3.05e-19 | NR | OQB17715.1 | 1852869 | g255341 | i0 | 55.3 | 0.938271604938272 | 76 | 34 | 93.8 | 0 | 230 | 3 | 500 | 575 | OQB17715.1 MAG: hypothetical protein BWY17_00711 [Deltaproteobacteria bacterium ADurb.Bin207] | diamond | 228 | 91.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin207 |
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);;