contig_metadata
9 rows where bioproject = "PRJNA415856", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2970124 | 2970124 | PRJNA415856_P_NODE_45003_length_164_cov_0.886957_g44742_i0 | PRJNA415856 | 45003 | 164 | 0.886957 | 1.45460948 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 303 | 3.42e-78 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g44742 | i0 | 100 | 2 | 164 | 0 | 100 | 0 | 1 | 164 | 197879 | 197716 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 328 | 303 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 9347350 | 9347350 | PRJNA415856_P_NODE_20888_length_192_cov_1.069930_g20627_i0 | PRJNA415856 | 20888 | 192 | 1.06993 | 2.0542656 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 340 | 3.15e-89 | NTclustered | gi|2070571752|gb|CP072208.2| | 2725942 | g20627 | i0 | 98.947 | 52.8177083333333 | 190 | 2 | 99 | 0 | 3 | 192 | 111642 | 111453 | MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome | blastn | 10141 | 340 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 18270937 | 18270937 | PRJNA415856_P_NODE_33335_length_169_cov_1.641667_g33074_i0 | PRJNA415856 | 33335 | 169 | 1.641667 | 2.77441723 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 267 | 4.63e-67 | NTclustered | gi|1805660319|gb|CP047920.1| | 713059 | g33074 | i0 | 96.296 | 19.491124260355 | 162 | 6 | 96 | 0 | 1 | 162 | 689702 | 689863 | Candidatus Saccharibacteria bacterium oral taxon 488 strain FS07P chromosome, complete genome | blastn | 3294 | 267 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 21485246 | 21485246 | PRJNA415856_P_NODE_42617_length_164_cov_1.773913_g42356_i0 | PRJNA415856 | 42617 | 164 | 1.773913 | 2.90921732 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 272 | 9.65e-69 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g42356 | i0 | 96.933 | 58.8048780487805 | 163 | 3 | 99 | 2 | 1 | 162 | 697274 | 697435 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 9644 | 272 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 27833586 | 27833586 | PRJNA415856_P_NODE_48824_length_162_cov_0.902655_g48563_i0 | PRJNA415856 | 48824 | 162 | 0.902655 | 1.4623011 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 84.7 | 4.65e-19 | NR | MDO4870867.1 | 2026720 | g48563 | i0 | 95.7 | 0.851851851851852 | 46 | 2 | 85.2 | 0 | 25 | 162 | 1 | 46 | MDO4870867.1 30S ribosomal protein S7 [Candidatus Saccharibacteria bacterium] | diamond | 138 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28307308 | 28307308 | PRJNA415856_P_NODE_26706_length_180_cov_1.534351_g26445_i0 | PRJNA415856 | 26706 | 180 | 1.534351 | 2.7618318 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 116 | 1.7299999999999999e-28 | NR | MBF1037421.1 | 2725945 | g26445 | i0 | 89.8 | 0.983333333333333 | 59 | 6 | 98.3 | 0 | 179 | 3 | 288 | 346 | MBF1037421.1 hypothetical protein [Candidatus Nanosynbacter sp.] | diamond | 177 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 28560012 | 28560012 | PRJNA415856_P_NODE_26227_length_181_cov_1.462121_g25966_i0 | PRJNA415856 | 26227 | 181 | 1.462121 | 2.64643901 | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | 1986206 | Bacteria | Bacteria | 123 | 1.96e-31 | NR | WP_129693348.1 | 1986206 | g25966 | i0 | 100 | 1.95580110497238 | 60 | 0 | 99.4 | 0 | 181 | 2 | 118 | 177 | WP_129693348.1 dihydrolipoyl dehydrogenase family protein [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 354 | 123 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 28623185 | 28623185 | PRJNA415856_P_NODE_34627_length_167_cov_1.728814_g34366_i0 | PRJNA415856 | 34627 | 167 | 1.728814 | 2.88711938 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 83.6 | 1.09e-17 | NR | MEO5950029.1 | 2973664 | g34366 | i0 | 74.1 | 0.970059880239521 | 54 | 14 | 97 | 0 | 167 | 6 | 19 | 72 | MEO5950029.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 162 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30724069 | 30724069 | PRJNA415856_P_NODE_29594_length_175_cov_1.563492_g29333_i0 | PRJNA415856 | 29594 | 175 | 1.563492 | 2.736111 | Bacteria | 2 | Bacteria | Bacteria | 72.8 | 3.35e-13 | NR | TAH36621.1 | 2026720 | g29333 | i0 | 60.7 | 2.88 | 56 | 21 | 96 | 1 | 171 | 4 | 90 | 144 | TAH36621.1 MAG: PrgI family protein [Candidatus Saccharibacteria bacterium] | diamond | 504 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;