contig_metadata
10 rows where bioproject = "PRJNA1059246" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1011533 | 1011533 | PRJNA1059246_P_NODE_47941_length_298_cov_1.368889_g47315_i0 | PRJNA1059246 | 47941 | 298 | 1.368889 | 4.07928922 | Bacteria | 2 | Bacteria | Bacteria | 518 | 2.2699999999999998e-142 | NTclustered | gi|451917473|gb|KC451337.1| | 34034 | g47315 | i0 | 97.987 | 99.6040268456376 | 298 | 6 | 100 | 0 | 1 | 298 | 15 | 312 | Uncultured delta proteobacterium clone RLBp4165 16S ribosomal RNA gene, partial sequence | blastn | 29682 | 518 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 5279897 | 5279897 | PRJNA1059246_P_NODE_45005_length_312_cov_1.288703_g44379_i0 | PRJNA1059246 | 45005 | 312 | 1.288703 | 4.02075336 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g44379 | i0 | 96.774 | 0.0993589743589744 | 31 | 1 | 10 | 0 | 258 | 288 | 5319863 | 5319893 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 31 | 52.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 19302440 | 19302440 | PRJNA1059246_P_NODE_13216_length_650_cov_2.155979_g12632_i0 | PRJNA1059246 | 13216 | 650 | 2.155979 | 14.0138635 | Actinomycetota | 201174 | Bacteria | Bacteria | 77 | 8.07e-15 | NR | MBF0288354.1 | 2024889 | g12632 | i0 | 54.7 | 2.24769230769231 | 64 | 29 | 29.5 | 0 | 83 | 274 | 1 | 64 | MBF0288354.1 cold shock domain-containing protein [SAR324 cluster bacterium] | diamond | 1461 | 77.4 | 0.994832041343669 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 20578413 | 20578413 | PRJNA1059246_P_NODE_63257_length_250_cov_0.870056_g62631_i0 | PRJNA1059246 | 63257 | 250 | 0.870056 | 2.17514 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 67.8 | 4.95e-11 | NR | WP_141196655.1 | 2292766 | g62631 | i0 | 60 | 2.016 | 50 | 20 | 60 | 0 | 100 | 249 | 13 | 62 | WP_141196655.1 quinolinate synthase NadA [Persicimonas caeni] | diamond | 504 | 67.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 27880091 | 27880091 | PRJNA1059246_P_NODE_48145_length_297_cov_1.375000_g47519_i0 | PRJNA1059246 | 48145 | 297 | 1.375 | 4.08375 | Pseudomonadota | 1224 | Bacteria | Bacteria | 209 | 1.04e-67 | NR | WP_220096280.1 | 1765737 | g47519 | i0 | 100 | 1.97979797979798 | 98 | 0 | 99 | 0 | 295 | 2 | 33 | 130 | WP_220096280.1 zonular occludens toxin domain-containing protein, partial [Dissulfurirhabdus thermomarina] | diamond | 588 | 209 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Dissulfurirhabdaceae | Dissulfurirhabdus | Dissulfurirhabdus thermomarina | ||||
| 27974808 | 27974808 | PRJNA1059246_P_NODE_60765_length_253_cov_1.711111_g60139_i0 | PRJNA1059246 | 60765 | 253 | 1.711111 | 4.32911083 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.0123 | NR | OGP75284.1 | 1797832 | g60139 | i0 | 32.7 | 1.64822134387352 | 55 | 37 | 65.2 | 0 | 61 | 225 | 797 | 851 | OGP75284.1 MAG: hypothetical protein A2Y80_04575 [Deltaproteobacteria bacterium RBG_13_58_19] | diamond | 417 | 44.7 | 0.991051454138702 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_58_19 | ||||||
| 28448622 | 28448622 | PRJNA1059246_P_NODE_36606_length_355_cov_1.762411_g35980_i0 | PRJNA1059246 | 36606 | 355 | 1.762411 | 6.25655905 | Myxococcota | 2818505 | Bacteria | Bacteria | 55.1 | 6.55e-6 | NR | PKN53796.1 | 2013741 | g35980 | i0 | 33.3 | 1.72394366197183 | 99 | 55 | 79.4 | 4 | 31 | 312 | 760 | 852 | PKN53796.1 MAG: hypothetical protein CVU56_29970 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 612 | 55.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 30698836 | 30698836 | PRJNA1059246_P_NODE_52434_length_282_cov_1.162679_g51808_i0 | PRJNA1059246 | 52434 | 282 | 1.162679 | 3.27875478 | Deltaproteobacteria bacterium ADurb.Bin2 | 2026735 | Bacteria | Bacteria | 45.4 | 0.00272 | NR | OQB13206.1 | 1852869 | g51808 | i0 | 41.7 | 1.02127659574468 | 96 | 48 | 95.7 | 3 | 6 | 275 | 35 | 128 | OQB13206.1 MAG: Inner membrane protein YphA [Deltaproteobacteria bacterium ADurb.Bin207] | diamond | 288 | 45.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin207 | ||||||
| 31552635 | 31552635 | PRJNA1059246_P_NODE_68976_length_244_cov_1.035088_g68350_i0 | PRJNA1059246 | 68976 | 244 | 1.035088 | 2.52561472 | Bradymonas sediminis | 1548548 | Bacteria | Bacteria | 43.5 | 0.0198 | NR | WP_111331830.1 | 1548548 | g68350 | i0 | 51.4 | 0.430327868852459 | 35 | 17 | 43 | 0 | 231 | 127 | 294 | 328 | WP_111331830.1 hypothetical protein [Bradymonas sediminis] | diamond | 105 | 43.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis | |||
| 32816619 | 32816619 | PRJNA1059246_P_NODE_52660_length_281_cov_1.399038_g52034_i0 | PRJNA1059246 | 52660 | 281 | 1.399038 | 3.93129678 | Lujinxingiaceae bacterium | 2946527 | Bacteria | Bacteria | 47.8 | 0.00106 | NR | MBA2665161.1 | 2946527 | g52034 | i0 | 31.1 | 0.96085409252669 | 90 | 56 | 91.8 | 2 | 276 | 19 | 1869 | 1956 | MBA2665161.1 hypothetical protein [Lujinxingiaceae bacterium] | diamond | 270 | 47.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingiaceae 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);;