contig_metadata
9 rows where bioproject = "PRJEB29441", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5129011 | 5129011 | PRJEB29441_P_NODE_34865_length_177_cov_1.210938_g34424_i0 | PRJEB29441 | 34865 | 177 | 1.210938 | 2.14336026 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 239 | 1.07e-58 | NTclustered | gi|2874253873|emb|OY969928.1| | 179883 | g34424 | i0 | 90.96 | 82.1299435028249 | 177 | 16 | 100 | 0 | 1 | 177 | 597313 | 597489 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1 | blastn | 14537 | 239 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 5129113 | 5129113 | PRJEB29441_P_NODE_41025_length_165_cov_2.465517_g40584_i0 | PRJEB29441 | 41025 | 165 | 2.465517 | 4.06810305 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 294 | 2.08e-75 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g40584 | i0 | 98.788 | 63.3151515151515 | 165 | 2 | 100 | 0 | 1 | 165 | 851672 | 851508 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 10447 | 294 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 6091439 | 6091439 | PRJEB29441_P_NODE_36225_length_173_cov_1.653226_g35784_i0 | PRJEB29441 | 36225 | 173 | 1.653226 | 2.86008098 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 263 | 6.169999999999999e-66 | NTclustered | gi|1842054184|gb|CP039999.1| | 713059 | g35784 | i0 | 94.22 | 123.85549132948 | 173 | 9 | 100 | 1 | 1 | 173 | 142212 | 142383 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome | blastn | 21427 | 263 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 7366016 | 7366016 | PRJEB29441_P_NODE_8066_length_406_cov_2.187675_g7627_i0 | PRJEB29441 | 8066 | 406 | 2.187675 | 8.8819605 | Candidatus Minimicrobia | 2905967 | Bacteria | Bacteria | 568 | 3.13e-157 | NTclustered | gi|2306607015|emb|OX335598.1| | 2026720 | g7627 | i0 | 92.157 | 257.773399014778 | 408 | 23 | 100 | 5 | 1 | 406 | 80537 | 80937 | Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001 | blastn | 104656 | 568 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 7678908 | 7678908 | PRJEB29441_P_NODE_36807_length_172_cov_1.195122_g36366_i0 | PRJEB29441 | 36807 | 172 | 1.195122 | 2.05560984 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 307 | 2.79e-79 | NTclustered | gi|2070571752|gb|CP072208.2| | 2725942 | g36366 | i0 | 98.837 | 108.302325581395 | 172 | 2 | 100 | 0 | 1 | 172 | 112313 | 112484 | MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome | blastn | 18628 | 307 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 10229109 | 10229109 | PRJEB29441_P_NODE_17369_length_258_cov_5.023923_g16928_i0 | PRJEB29441 | 17369 | 258 | 5.023923 | 12.96172134 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 431 | 2.58e-116 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g16928 | i0 | 96.887 | 252.895348837209 | 257 | 8 | 99 | 0 | 1 | 257 | 667790 | 667534 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 65247 | 431 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 25214244 | 25214244 | PRJEB29441_P_NODE_14220_length_291_cov_1.603306_g13779_i0 | PRJEB29441 | 14220 | 291 | 1.603306 | 4.66562046 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 481 | 2.899999999999999e-131 | NTclustered | gi|1842054184|gb|CP039999.1| | 713059 | g13779 | i0 | 96.564 | 83.2783505154639 | 291 | 8 | 100 | 1 | 1 | 291 | 143535 | 143823 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome | blastn | 24234 | 481 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 26938179 | 26938179 | PRJEB29441_P_NODE_42122_length_165_cov_0.879310_g41681_i0 | PRJEB29441 | 42122 | 165 | 0.87931 | 1.4508615 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 57.8 | 8.03e-9 | NR | MCA9330407.1 | 2026720 | g41681 | i0 | 53.8 | 0.945454545454545 | 52 | 23 | 92.7 | 1 | 3 | 155 | 45 | 96 | MCA9330407.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 156 | 57.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27343061 | 27343061 | PRJEB29441_P_NODE_46203_length_162_cov_0.902655_g45762_i0 | PRJEB29441 | 46203 | 162 | 0.902655 | 1.4623011 | Candidatus Saccharimonadota | 95818 | Bacteria | Bacteria | 102 | 9.04e-24 | NR | RKW02091.1 | 1917697 | g45762 | i0 | 92.6 | 9 | 54 | 4 | 100 | 0 | 1 | 162 | 88 | 141 | RKW02091.1 MAG: DUF87 domain-containing protein, partial [Candidatus Saccharimonas sp.] | diamond | 1458 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas 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);;