contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1123436" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 279022 | 279022 | PRJNA1123436_P_NODE_114701_length_245_cov_0.895349_g113487_i0 | PRJNA1123436 | 114701 | 245 | 0.895349 | 2.19360505 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 200 | 7.46e-47 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g113487 | i0 | 89.744 | 0.636734693877551 | 156 | 16 | 64 | 0 | 1 | 156 | 3356521 | 3356366 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 156 | 200 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 279153 | 279153 | PRJNA1123436_P_NODE_121821_length_243_cov_0.905882_g120607_i0 | PRJNA1123436 | 121821 | 243 | 0.905882 | 2.20129326 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 241 | 4.36e-59 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g120607 | i0 | 89.474 | 0.781893004115226 | 190 | 20 | 78 | 0 | 52 | 241 | 182866 | 183055 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 190 | 241 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 1553488 | 1553488 | PRJNA1123436_P_NODE_111422_length_246_cov_0.890173_g110208_i0 | PRJNA1123436 | 111422 | 246 | 0.890173 | 2.18982558 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 176 | 1.26e-39 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g110208 | i0 | 85.294 | 67.150406504065 | 170 | 25 | 69 | 0 | 26 | 195 | 1873424 | 1873593 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 16519 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 1553757 | 1553757 | PRJNA1123436_P_NODE_124642_length_242_cov_0.911243_g123428_i0 | PRJNA1123436 | 124642 | 242 | 0.911243 | 2.20520806 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 268 | 1.99e-67 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g123428 | i0 | 86.831 | 3.0702479338843 | 243 | 28 | 99 | 4 | 1 | 241 | 972595 | 972835 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 743 | 268 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 1555441 | 1555441 | PRJNA1123436_P_NODE_98422_length_250_cov_0.870056_g97208_i0 | PRJNA1123436 | 98422 | 250 | 0.870056 | 2.17514 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 303 | 5.66e-78 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g97208 | i0 | 88.71 | 0.992 | 248 | 28 | 99 | 0 | 1 | 248 | 2590492 | 2590739 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 248 | 303 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 2829377 | 2829377 | PRJNA1123436_P_NODE_101503_length_249_cov_0.875000_g100289_i0 | PRJNA1123436 | 101503 | 249 | 0.875 | 2.17875 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 195 | 3.5399999999999996e-45 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g100289 | i0 | 80.8 | 1.21285140562249 | 250 | 46 | 100 | 2 | 1 | 249 | 917929 | 918177 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 302 | 195 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 2831525 | 2831525 | PRJNA1123436_P_NODE_99723_length_250_cov_0.870056_g98509_i0 | PRJNA1123436 | 99723 | 250 | 0.870056 | 2.17514 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 222 | 1.63e-53 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g98509 | i0 | 82.8 | 44.8 | 250 | 41 | 99 | 2 | 1 | 249 | 4010832 | 4011080 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 11200 | 222 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 9208701 | 9208701 | PRJNA1123436_P_NODE_93028_length_254_cov_1.049724_g91814_i0 | PRJNA1123436 | 93028 | 254 | 1.049724 | 2.66629896 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 268 | 2.0999999999999998e-67 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g91814 | i0 | 87.029 | 0.940944881889764 | 239 | 30 | 94 | 1 | 16 | 254 | 2876562 | 2876799 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 239 | 268 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 11757527 | 11757527 | PRJNA1123436_P_NODE_116510_length_244_cov_0.900585_g115296_i0 | PRJNA1123436 | 116510 | 244 | 0.900585 | 2.1974274 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 298 | 2.56e-76 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g115296 | i0 | 88.71 | 2.50819672131148 | 248 | 23 | 100 | 5 | 1 | 244 | 3845259 | 3845505 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 612 | 298 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 16856199 | 16856199 | PRJNA1123436_P_NODE_114414_length_245_cov_0.895349_g113200_i0 | PRJNA1123436 | 114414 | 245 | 0.895349 | 2.19360505 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 174 | 4.52e-39 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g113200 | i0 | 80 | 1 | 245 | 42 | 99 | 6 | 3 | 245 | 1168303 | 1168542 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 245 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 18130716 | 18130716 | PRJNA1123436_P_NODE_114555_length_245_cov_0.895349_g113341_i0 | PRJNA1123436 | 114555 | 245 | 0.895349 | 2.19360505 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 254 | 5.65e-63 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g113341 | i0 | 85.306 | 1 | 245 | 36 | 100 | 0 | 1 | 245 | 816930 | 817174 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 245 | 254 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 20681889 | 20681889 | PRJNA1123436_P_NODE_77537_length_283_cov_0.919048_g76323_i0 | PRJNA1123436 | 77537 | 283 | 0.919048 | 2.60090584 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 440 | 4.769999999999998e-119 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g76323 | i0 | 94.7 | 1.77385159010601 | 283 | 15 | 100 | 0 | 1 | 283 | 1416164 | 1415882 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 502 | 440 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 23231099 | 23231099 | PRJNA1123436_P_NODE_106759_length_247_cov_1.609195_g105545_i0 | PRJNA1123436 | 106759 | 247 | 1.609195 | 3.97471165 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 73.1 | 1.71e-8 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g105545 | i0 | 100 | 14.4898785425101 | 39 | 0 | 16 | 0 | 209 | 247 | 2165628 | 2165666 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 3579 | 73.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 24504846 | 24504846 | PRJNA1123436_P_NODE_110100_length_246_cov_1.289017_g108886_i0 | PRJNA1123436 | 110100 | 246 | 1.289017 | 3.17098182 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 327 | 3.3e-85 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g108886 | i0 | 90.65 | 55.849593495935 | 246 | 23 | 100 | 0 | 1 | 246 | 3567163 | 3566918 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 13739 | 327 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 24506380 | 24506380 | PRJNA1123436_P_NODE_78860_length_280_cov_1.458937_g77646_i0 | PRJNA1123436 | 78860 | 280 | 1.458937 | 4.0850236 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 161 | 4.11e-35 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g77646 | i0 | 79.253 | 10.7642857142857 | 241 | 42 | 85 | 8 | 44 | 280 | 4041475 | 4041239 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 3014 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota 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);;