contig_metadata
6 rows where bioproject = "PRJNA1020854", tax_phylum = "Thermodesulfobacteriota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24386934 | 24386934 | PRJNA1020854_S_NODE_21840_length_232_cov_5.995074_g19076_i0 | PRJNA1020854 | 21840 | 232 | 5.995074 | 13.90857168 | Bacteria | 2 | Bacteria | Bacteria | 137 | 6.009999999999999e-37 | NR | MDD2467322.1 | 895 | g19076 | i0 | 81.8 | 10.9525862068966 | 77 | 14 | 99.6 | 0 | 2 | 232 | 129 | 205 | MDD2467322.1 UDP-4-amino-4,6-dideoxy-N-acetyl-beta-L-altrosamine transaminase [Desulfobulbus sp.] | diamond | 2541 | 137 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 27224358 | 27224358 | PRJNA1020854_S_NODE_22903_length_225_cov_3.826531_g20139_i0 | PRJNA1020854 | 22903 | 225 | 3.826531 | 8.60969475 | Desulfomicrobium escambiense | 29503 | Bacteria | Bacteria | 91.3 | 1.56e-19 | NR | WP_028576375.1 | 29503 | g20139 | i0 | 83.3 | 0.72 | 54 | 9 | 72 | 0 | 201 | 40 | 273 | 326 | WP_028576375.1 EAL and HDOD domain-containing protein [Desulfomicrobium escambiense] | diamond | 162 | 91.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium escambiense | ||
| 27311815 | 27311815 | PRJNA1020854_S_NODE_25363_length_210_cov_4.370166_g22599_i0 | PRJNA1020854 | 25363 | 210 | 4.370166 | 9.1773486 | Bacteria | 2 | Bacteria | Bacteria | 108 | 7.07e-27 | NR | WP_235263991.1 | 392333 | g22599 | i0 | 80.6 | 23.9142857142857 | 62 | 12 | 88.6 | 0 | 24 | 209 | 74 | 135 | WP_235263991.1 UDP-4-amino-4,6-dideoxy-N-acetyl-beta-L-altrosamine transaminase [Geoalkalibacter ferrihydriticus] | diamond | 5022 | 108 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geoalkalibacteraceae | Geoalkalibacter | Geoalkalibacter ferrihydriticus | ||
| 27666923 | 27666923 | PRJNA1020854_S_NODE_32844_length_178_cov_3.100671_g30080_i0 | PRJNA1020854 | 32844 | 178 | 3.100671 | 5.51919438 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 53.1 | 3.18e-6 | NR | MEN8134060.1 | 2202153 | g30080 | i0 | 46.8 | 0.792134831460674 | 47 | 25 | 79.2 | 0 | 18 | 158 | 192 | 238 | MEN8134060.1 sugar nucleotide-binding protein [Thermodesulfobacteriota bacterium] | diamond | 141 | 53.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29561050 | 29561050 | PRJNA1020854_S_NODE_32710_length_178_cov_31.449664_g29946_i0 | PRJNA1020854 | 32710 | 178 | 31.449664 | 55.98040192 | Desulfovibrionales bacterium | 2448050 | Bacteria | Bacteria | 60.8 | 6.04e-9 | NR | NLY41234.1 | 2448050 | g29946 | i0 | 58.7 | 0.775280898876405 | 46 | 19 | 77.5 | 0 | 3 | 140 | 335 | 380 | NLY41234.1 HDOD domain-containing protein [Desulfovibrionales bacterium] | diamond | 138 | 60.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionales bacterium | ||||
| 30951351 | 30951351 | PRJNA1020854_S_NODE_23354_length_222_cov_5.901554_g20590_i0 | PRJNA1020854 | 23354 | 222 | 5.901554 | 13.10144988 | Desulfobulbus sp. | 895 | Bacteria | Bacteria | 115 | 8.03e-29 | NR | MDD2467322.1 | 895 | g20590 | i0 | 78.8 | 2.68918918918919 | 66 | 14 | 89.2 | 0 | 3 | 200 | 198 | 263 | MDD2467322.1 UDP-4-amino-4,6-dideoxy-N-acetyl-beta-L-altrosamine transaminase [Desulfobulbus sp.] | diamond | 597 | 115 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. |
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);;