contig_metadata
8 rows where bioproject = "PRJNA1082072" and tax_phylum = "Elusimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20594219 | 20594219 | PRJNA1082072_P_NODE_1477_length_287_cov_1.556075_g1470_i0 | PRJNA1082072 | 1477 | 287 | 1.556075 | 4.46593525 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 167 | 1.12e-47 | NR | MFI5345421.1 | 2030800 | g1470 | i0 | 92.6 | 1.98606271777003 | 95 | 7 | 99.3 | 0 | 285 | 1 | 85 | 179 | MFI5345421.1 glutamate-1-semialdehyde 2,1-aminomutase [Elusimicrobiota bacterium] | diamond | 570 | 167 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 27320447 | 27320447 | PRJNA1082072_P_NODE_2063_length_251_cov_0.865169_g2056_i0 | PRJNA1082072 | 2063 | 251 | 0.865169 | 2.17157419 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 100 | 1.17e-22 | NR | HEX4048888.1 | 2030800 | g2056 | i0 | 66.7 | 2.0199203187251 | 84 | 24 | 99.2 | 2 | 3 | 251 | 367 | 447 | HEX4048888.1 serine/threonine-protein kinase [Elusimicrobiota bacterium] | diamond | 507 | 100 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 28994139 | 28994139 | PRJNA1082072_P_NODE_2008_length_253_cov_1.711111_g2001_i0 | PRJNA1082072 | 2008 | 253 | 1.711111 | 4.32911083 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 129 | 2.44e-36 | NR | HXT00855.1 | 2030800 | g2001 | i0 | 79.3 | 1.94466403162055 | 82 | 17 | 97.2 | 0 | 6 | 251 | 37 | 118 | HXT00855.1 response regulator [Elusimicrobiota bacterium] | diamond | 492 | 129 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 29593359 | 29593359 | PRJNA1082072_P_NODE_1950_length_258_cov_1.664865_g1943_i0 | PRJNA1082072 | 1950 | 258 | 1.664865 | 4.2953517 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 96.3 | 5.3100000000000005e-21 | NR | MDE2510253.1 | 2030800 | g1943 | i0 | 91.1 | 1.33720930232558 | 56 | 5 | 65.1 | 0 | 2 | 169 | 438 | 493 | MDE2510253.1 Flp pilus assembly complex ATPase component TadA [Elusimicrobiota bacterium] | diamond | 345 | 96.3 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 30352396 | 30352396 | PRJNA1082072_P_NODE_1352_length_298_cov_1.368889_g1345_i0 | PRJNA1082072 | 1352 | 298 | 1.368889 | 4.07928922 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 181 | 9.41e-53 | NR | MBI3563772.1 | 2030800 | g1345 | i0 | 84.4 | 0.966442953020134 | 96 | 15 | 96.6 | 0 | 2 | 289 | 23 | 118 | MBI3563772.1 DUF4178 domain-containing protein [Elusimicrobiota bacterium] | diamond | 288 | 181 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 30889009 | 30889009 | PRJNA1082072_P_NODE_2014_length_253_cov_1.322222_g2007_i0 | PRJNA1082072 | 2014 | 253 | 1.322222 | 3.34522166 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 159 | 9.6e-45 | NR | MBI5629378.1 | 2030800 | g2007 | i0 | 91.7 | 0.99604743083004 | 84 | 7 | 99.6 | 0 | 252 | 1 | 259 | 342 | MBI5629378.1 efflux RND transporter periplasmic adaptor subunit [Elusimicrobiota bacterium] | diamond | 252 | 159 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 30920767 | 30920767 | PRJNA1082072_P_NODE_2894_length_242_cov_0.911243_g2887_i0 | PRJNA1082072 | 2894 | 242 | 0.911243 | 2.20520806 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 111 | 1.7600000000000002e-26 | NR | MCR4295978.1 | 2030800 | g2887 | i0 | 65 | 1.94628099173554 | 80 | 28 | 99.2 | 0 | 240 | 1 | 310 | 389 | MCR4295978.1 hypothetical protein [Elusimicrobiota bacterium] | diamond | 471 | 111 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 31204484 | 31204484 | PRJNA1082072_P_NODE_2255_length_249_cov_0.875000_g2248_i0 | PRJNA1082072 | 2255 | 249 | 0.875 | 2.17875 | Elusimicrobia bacterium GWA2_66_18 | 1797926 | Bacteria | Bacteria | 73.9 | 1.87e-13 | NR | OGR46552.1 | 1797926 | g2248 | i0 | 61.8 | 0.662650602409639 | 55 | 20 | 65.1 | 1 | 5 | 166 | 233 | 287 | OGR46552.1 MAG: hypothetical protein A2X37_08760 [Elusimicrobia bacterium GWA2_66_18] | diamond | 165 | 73.9 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobia bacterium GWA2_66_18 |
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);;