contig_metadata
6 rows where bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1881584 | 1881584 | PRJNA635397_P_NODE_11442_length_508_cov_1.940230_g10989_i0 | PRJNA635397 | 11442 | 508 | 1.94023 | 9.8563684 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 822 | 0 | NTclustered | gi|1958122490|gb|CP065015.1| | 2026720 | g10989 | i0 | 95.89 | 226.403543307087 | 511 | 15 | 100 | 6 | 1 | 508 | 511896 | 511389 | Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome | blastn | 115013 | 822 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 5709667 | 5709667 | PRJNA635397_P_NODE_46305_length_242_cov_1.372781_g45851_i0 | PRJNA635397 | 46305 | 242 | 1.372781 | 3.32213002 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 442 | 1.1099999999999995e-119 | NTclustered | gi|1663049602|gb|CP040008.1| | 2572087 | g45851 | i0 | 99.587 | 294.07438016528903 | 242 | 1 | 100 | 0 | 1 | 242 | 138842 | 139083 | Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome | blastn | 71166 | 442 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 17731563 | 17731563 | PRJNA635397_P_NODE_16954_length_398_cov_1.458462_g16500_i0 | PRJNA635397 | 16954 | 398 | 1.458462 | 5.80467876 | Candidatus Southlakia | 3350975 | Bacteria | Bacteria | 649 | 0 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g16500 | i0 | 96 | 72.3643216080402 | 400 | 14 | 100 | 2 | 1 | 398 | 906677 | 906278 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 28801 | 649 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 18458082 | 18458082 | PRJNA635397_P_NODE_45895_length_243_cov_0.911765_g45441_i0 | PRJNA635397 | 45895 | 243 | 0.911765 | 2.21558895 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 444 | 3.09e-120 | NTclustered | gi|2890901196|gb|CP128407.1| | 713059 | g45441 | i0 | 99.588 | 10.9917695473251 | 243 | 1 | 100 | 0 | 1 | 243 | 391415 | 391657 | Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome | blastn | 2671 | 444 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 19732234 | 19732234 | PRJNA635397_P_NODE_20956_length_352_cov_0.910394_g20502_i0 | PRJNA635397 | 20956 | 352 | 0.910394 | 3.20458688 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 560 | 4.47e-155 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g20502 | i0 | 95.467 | 402.40625 | 353 | 13 | 100 | 3 | 1 | 352 | 150727 | 150377 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 141647 | 560 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 28975830 | 28975830 | PRJNA635397_P_NODE_41428_length_249_cov_0.886364_g40974_i0 | PRJNA635397 | 41428 | 249 | 0.886364 | 2.20704636 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 126 | 2.8099999999999998e-34 | NR | MBF1034843.1 | 2725945 | g40974 | i0 | 96.8 | 0.759036144578313 | 63 | 2 | 75.9 | 0 | 3 | 191 | 148 | 210 | MBF1034843.1 hypothetical protein [Candidatus Nanosynbacter sp.] | diamond | 189 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter 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);;