contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA605033" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1857099 | 1857099 | PRJNA605033_P_NODE_108042_length_222_cov_1.823529_g106473_i0 | PRJNA605033 | 108042 | 222 | 1.823529 | 4.04823438 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 134 | 6.84e-27 | NTclustered | gi|1805659474|gb|CP047919.1| | 713059 | g106473 | i0 | 98.667 | 2.02702702702703 | 75 | 1 | 34 | 0 | 148 | 222 | 292519 | 292593 | Candidatus Saccharibacteria bacterium oral taxon 488 strain FS13P chromosome, complete genome | blastn | 450 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 3133898 | 3133898 | PRJNA605033_P_NODE_69083_length_222_cov_3.229947_g67514_i0 | PRJNA605033 | 69083 | 222 | 3.229947 | 7.17048234 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 100 | 6.93e-17 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g67514 | i0 | 93.939 | 0.297297297297297 | 66 | 4 | 30 | 0 | 156 | 221 | 468882 | 468817 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 66 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 5685059 | 5685059 | PRJNA605033_P_NODE_119665_length_222_cov_1.556150_g118096_i0 | PRJNA605033 | 119665 | 222 | 1.55615 | 3.454653 | TM7 phylum sp. oral taxon 349 | 713051 | Bacteria | Bacteria | 139 | 1.47e-28 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g118096 | i0 | 100 | 0.995495495495496 | 75 | 0 | 68 | 0 | 148 | 222 | 224106 | 224032 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 221 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 6959556 | 6959556 | PRJNA605033_P_NODE_106206_length_222_cov_1.850267_g104637_i0 | PRJNA605033 | 106206 | 222 | 1.850267 | 4.10759274 | Candidatus Gottesmanbacteria bacterium | 2282145 | Bacteria | Bacteria | 63.9 | 9.1e-6 | NTclustered | gi|2874253727|emb|OY969569.1| | 2282145 | g104637 | i0 | 95 | 0.337837837837838 | 40 | 2 | 18 | 0 | 183 | 222 | 537307 | 537346 | MAG: Candidatus Gottesmanbacteria bacterium isolate MFD03899.bin.c.1 genome assembly, chromosome: 1 | blastn | 75 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Gottesmaniibacteriota | Candidatus Gottesmanbacteria bacterium | ||||||
| 6960831 | 6960831 | PRJNA605033_P_NODE_246186_length_150_cov_4.060870_g244617_i0 | PRJNA605033 | 246186 | 150 | 4.06087 | 6.091305 | TM7 phylum sp. oral taxon 349 | 713051 | Bacteria | Bacteria | 130 | 5.49e-26 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g244617 | i0 | 83.75 | 4.66 | 160 | 3 | 93 | 9 | 1 | 139 | 489615 | 489772 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 699 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 9510182 | 9510182 | PRJNA605033_P_NODE_166928_length_182_cov_1.632653_g165359_i0 | PRJNA605033 | 166928 | 182 | 1.632653 | 2.97142846 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 298 | 1.8e-76 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g165359 | i0 | 96.154 | 2 | 182 | 7 | 100 | 0 | 1 | 182 | 445025 | 445206 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 364 | 298 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 11348073 | 11348073 | PRJNA605033_P_NODE_110689_length_222_cov_1.786096_g109120_i0 | PRJNA605033 | 110689 | 222 | 1.786096 | 3.96513312 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 117 | 6.88e-22 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g109120 | i0 | 94.737 | 4.10810810810811 | 76 | 3 | 34 | 1 | 148 | 222 | 153050 | 152975 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 912 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 11348098 | 11348098 | PRJNA605033_P_NODE_114329_length_222_cov_1.721925_g112760_i0 | PRJNA605033 | 114329 | 222 | 1.721925 | 3.8226735 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 111 | 3.2e-20 | NTclustered | gi|734569044|gb|CP007496.1| | 2093824 | g112760 | i0 | 93.333 | 1.53603603603604 | 75 | 5 | 34 | 0 | 1 | 75 | 277699 | 277773 | Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome | blastn | 341 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter lyticus | ||
| 12623683 | 12623683 | PRJNA605033_P_NODE_112330_length_222_cov_1.754011_g110761_i0 | PRJNA605033 | 112330 | 222 | 1.754011 | 3.89390442 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 128 | 3.18e-25 | NTclustered | gi|2869833183|gb|CP175706.1| | 2093824 | g110761 | i0 | 97.333 | 3.01351351351351 | 75 | 2 | 34 | 0 | 1 | 75 | 676390 | 676316 | Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome | blastn | 669 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter lyticus | ||
| 13337179 | 13337179 | PRJNA605033_P_NODE_66391_length_222_cov_3.652406_g64822_i0 | PRJNA605033 | 66391 | 222 | 3.652406 | 8.10834132 | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | 2933970 | Bacteria | Bacteria | 141 | 4.09e-29 | NTclustered | gi|2179907571|gb|CP090820.1| | 2933970 | g64822 | i0 | 100 | 0.68018018018018 | 76 | 0 | 68 | 0 | 147 | 222 | 686701 | 686776 | MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome | blastn | 151 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-348_TM7c-JB | ||
| 17160919 | 17160919 | PRJNA605033_P_NODE_86874_length_222_cov_2.267380_g85305_i0 | PRJNA605033 | 86874 | 222 | 2.26738 | 5.0335836 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 110 | 1.15e-19 | NTclustered | gi|2874253756|emb|OY969696.1| | 2052149 | g85305 | i0 | 96.923 | 29.6351351351351 | 65 | 2 | 29 | 0 | 11 | 75 | 372405 | 372469 | MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1 | blastn | 6579 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 21547789 | 21547789 | PRJNA605033_P_NODE_77057_length_222_cov_2.641711_g75488_i0 | PRJNA605033 | 77057 | 222 | 2.641711 | 5.86459842 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 141 | 4.09e-29 | NTclustered | gi|2306607015|emb|OX335598.1| | 2026720 | g75488 | i0 | 100 | 6.34234234234234 | 76 | 0 | 34 | 0 | 1 | 76 | 268000 | 268075 | Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001 | blastn | 1408 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 23533997 | 23533997 | PRJNA605033_P_NODE_140479_length_204_cov_1.171598_g138910_i0 | PRJNA605033 | 140479 | 204 | 1.171598 | 2.39005992 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 287 | 4.479999999999999e-73 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g138910 | i0 | 92.118 | 1.97058823529412 | 203 | 16 | 99 | 0 | 1 | 203 | 793946 | 794148 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 402 | 287 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 24809218 | 24809218 | PRJNA605033_P_NODE_52560_length_236_cov_1.676617_g50992_i0 | PRJNA605033 | 52560 | 236 | 1.676617 | 3.95681612 | uncultured Poribacteria bacterium | 265321 | Bacteria | Bacteria | 76.8 | 1.26e-9 | NTclustered | gi|2546137836|emb|OY282383.1| | 265321 | g50992 | i0 | 85.135 | 2 | 74 | 11 | 31 | 0 | 163 | 236 | 5018645 | 5018572 | MAG: uncultured Poribacteria bacterium isolate 7c199f84-8048-4b63-b208-6e17c6421a0a genome assembly, chromosome: 1 | blastn | 472 | 76.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | uncultured Poribacteria bacterium | ||||||
| 25370890 | 25370890 | PRJNA605033_P_NODE_101640_length_222_cov_1.925134_g100071_i0 | PRJNA605033 | 101640 | 222 | 1.925134 | 4.27379748 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 137 | 5.279999999999999e-28 | NTclustered | gi|2306607015|emb|OX335598.1| | 2026720 | g100071 | i0 | 100 | 6.1036036036036 | 74 | 0 | 65 | 0 | 2 | 75 | 280946 | 281019 | Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001 | blastn | 1355 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 25371666 | 25371666 | PRJNA605033_P_NODE_231060_length_155_cov_1.333333_g229491_i0 | PRJNA605033 | 231060 | 155 | 1.333333 | 2.06666615 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 193 | 7.2e-45 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g229491 | i0 | 89.032 | 20.9677419354839 | 155 | 17 | 100 | 0 | 1 | 155 | 697095 | 697249 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 3250 | 193 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis |
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);;