contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA814235" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4643797 | 4643797 | PRJNA814235_P_NODE_113024_length_203_cov_1.993976_g111629_i0 | PRJNA814235 | 113024 | 203 | 1.993976 | 4.04777128 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 100 | 6.23e-17 | NTclustered | gi|2874254031|emb|OY970356.1| | 179883 | g111629 | i0 | 90.667 | 0.369458128078818 | 75 | 7 | 37 | 0 | 128 | 202 | 367273 | 367347 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1 | blastn | 75 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 4645760 | 4645760 | PRJNA814235_P_NODE_24684_length_384_cov_45.242075_g23314_i0 | PRJNA814235 | 24684 | 384 | 45.242075 | 173.729568 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 632 | 1.0299999999999998e-176 | NTclustered | gi|1958122490|gb|CP065015.1| | 2026720 | g23314 | i0 | 96.354 | 140.473958333333 | 384 | 14 | 100 | 0 | 1 | 384 | 511198 | 511581 | Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome | blastn | 53942 | 632 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 7195683 | 7195683 | PRJNA814235_P_NODE_31906_length_338_cov_9.235880_g30520_i0 | PRJNA814235 | 31906 | 338 | 9.23588 | 31.2172744 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 442 | 1.6199999999999995e-119 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g30520 | i0 | 90.294 | 69.0798816568047 | 340 | 30 | 100 | 3 | 1 | 338 | 666709 | 667047 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 23349 | 442 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 12295845 | 12295845 | PRJNA814235_P_NODE_174070_length_156_cov_2.453782_g172675_i0 | PRJNA814235 | 174070 | 156 | 2.453782 | 3.82789992 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 250 | 4.25e-62 | NTclustered | gi|1663049602|gb|CP040008.1| | 2572087 | g172675 | i0 | 95.513 | 64.0448717948718 | 156 | 7 | 100 | 0 | 1 | 156 | 139585 | 139430 | Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome | blastn | 9991 | 250 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 |
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);;