contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27219680 | 27219680 | PRJNA640143_S_NODE_25902_length_173_cov_2.580882_g25692_i0 | PRJNA640143 | 25902 | 173 | 2.580882 | 4.46492586 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 81.6 | 1.41e-16 | NR | QWB90966.1 | 1917697 | g25692 | i0 | 75.5 | 1.69942196531792 | 49 | 12 | 85 | 0 | 2 | 148 | 78 | 126 | QWB90966.1 MAG: hypothetical protein HXL38_003235 [Candidatus Saccharimonas sp.] | diamond | 294 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 27997123 | 27997123 | PRJNA640143_S_NODE_4745_length_376_cov_6.280236_g4537_i0 | PRJNA640143 | 4745 | 376 | 6.280236 | 23.61368736 | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_ | 1802133 | Bacteria | Bacteria | 155 | 2.16e-41 | NR | OGL23191.1 | 1802133 | g4537 | i0 | 74.1 | 1.79521276595745 | 112 | 29 | 89.4 | 0 | 4 | 339 | 252 | 363 | OGL23191.1 MAG: copper-translocating P-type ATPase [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30] | diamond | 675 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30 | ||||||
| 30618033 | 30618033 | PRJNA640143_S_NODE_24173_length_179_cov_4.633803_g23963_i0 | PRJNA640143 | 24173 | 179 | 4.633803 | 8.29450737 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 43.5 | 0.00845 | NR | MCL2037661.1 | 2026720 | g23963 | i0 | 52.2 | 0.770949720670391 | 46 | 21 | 77.1 | 1 | 11 | 148 | 189 | 233 | MCL2037661.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 138 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30902542 | 30902542 | PRJNA640143_S_NODE_14314_length_230_cov_2.461140_g14104_i0 | PRJNA640143 | 14314 | 230 | 2.46114 | 5.660622 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 80.9 | 9.2e-17 | NR | HMS31291.1 | 2026720 | g14104 | i0 | 59.7 | 3 | 77 | 30 | 99.1 | 1 | 2 | 229 | 103 | 179 | HMS31291.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 690 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31345064 | 31345064 | PRJNA640143_S_NODE_27136_length_168_cov_3.740458_g26926_i0 | PRJNA640143 | 27136 | 168 | 3.740458 | 6.28396944 | Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1 | 2013831 | Bacteria | Bacteria | 85.5 | 9.22e-18 | NR | PKL31332.1 | 2013831 | g26926 | i0 | 83 | 1.66071428571429 | 47 | 8 | 83.9 | 0 | 141 | 1 | 362 | 408 | PKL31332.1 MAG: hypothetical protein CVV43_03100 [Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1] | diamond | 279 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium HGW-Saccharibacteria-1 | ||||||
| 31439802 | 31439802 | PRJNA640143_S_NODE_8256_length_295_cov_23.856589_g8046_i0 | PRJNA640143 | 8256 | 295 | 23.856589 | 70.37693755 | Candidatus Nanosyncoccus nanoralicus | 2171996 | Bacteria | Bacteria | 80.5 | 6.87e-18 | NR | WP_129604879.1 | 2171996 | g8046 | i0 | 90.9 | 0.884745762711864 | 44 | 4 | 44.7 | 0 | 268 | 137 | 1 | 44 | WP_129604879.1 50S ribosomal protein L34 [Candidatus Nanosyncoccus nanoralicus] | diamond | 261 | 80.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanosyncoccales | Candidatus Nanosyncoccaceae | Candidatus Nanosyncoccus | Candidatus Nanosyncoccus nanoralicus | ||
| 32104149 | 32104149 | PRJNA640143_S_NODE_32458_length_151_cov_1.368421_g32248_i0 | PRJNA640143 | 32458 | 151 | 1.368421 | 2.06631571 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 47.4 | 2.5e-4 | NR | HEX6462224.1 | 2973664 | g32248 | i0 | 41.7 | 0.95364238410596 | 48 | 28 | 95.4 | 0 | 4 | 147 | 539 | 586 | HEX6462224.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 144 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;