contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1262902" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1638337 | 1638337 | PRJNA1262902_P_NODE_3022_length_317_cov_1.110656_g2980_i0 | PRJNA1262902 | 3022 | 317 | 1.110656 | 3.52077952 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 250 | 9.81e-62 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g2980 | i0 | 83.456 | 0.858044164037855 | 272 | 42 | 85 | 3 | 47 | 317 | 23982 | 24251 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 272 | 250 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 1638372 | 1638372 | PRJNA1262902_P_NODE_7102_length_253_cov_1.711111_g7060_i0 | PRJNA1262902 | 7102 | 253 | 1.711111 | 4.32911083 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 204 | 5.99e-48 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g7060 | i0 | 81.818 | 1 | 253 | 36 | 98 | 7 | 6 | 253 | 3824979 | 3824732 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 253 | 204 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 1638408 | 1638408 | PRJNA1262902_P_NODE_9662_length_246_cov_0.890173_g9620_i0 | PRJNA1262902 | 9662 | 246 | 0.890173 | 2.18982558 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 211 | 3.46e-50 | NTclustered | gi|2874254133|emb|OY970218.1| | 1672391 | g9620 | i0 | 82.845 | 0.971544715447154 | 239 | 37 | 96 | 3 | 10 | 246 | 2217243 | 2217007 | MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1 | blastn | 239 | 211 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 2914212 | 2914212 | PRJNA1262902_P_NODE_10483_length_245_cov_0.895349_g10441_i0 | PRJNA1262902 | 10483 | 245 | 0.895349 | 2.19360505 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 161 | 3.52e-35 | NTclustered | gi|2874253835|emb|OY969885.1| | 1672391 | g10441 | i0 | 84.756 | 1.29795918367347 | 164 | 21 | 66 | 4 | 79 | 240 | 2009116 | 2009277 | MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 | blastn | 318 | 161 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 4190635 | 4190635 | PRJNA1262902_P_NODE_5584_length_271_cov_1.166667_g5542_i0 | PRJNA1262902 | 5584 | 271 | 1.166667 | 3.16166757 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 176 | 1.41e-39 | NTclustered | gi|2874254133|emb|OY970218.1| | 1672391 | g5542 | i0 | 78.598 | 7.56457564575646 | 271 | 54 | 99 | 4 | 1 | 269 | 1885492 | 1885760 | MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1 | blastn | 2050 | 176 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5466814 | 5466814 | PRJNA1262902_P_NODE_10845_length_244_cov_0.900585_g10803_i0 | PRJNA1262902 | 10845 | 244 | 0.900585 | 2.1974274 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 222 | 1.59e-53 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g10803 | i0 | 83.333 | 1.00819672131148 | 246 | 35 | 99 | 5 | 1 | 243 | 3493534 | 3493776 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 246 | 222 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5466862 | 5466862 | PRJNA1262902_P_NODE_4465_length_286_cov_1.446009_g4423_i0 | PRJNA1262902 | 4465 | 286 | 1.446009 | 4.13558574 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 172 | 1.94e-38 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g4423 | i0 | 83.77 | 1.38111888111888 | 191 | 21 | 67 | 4 | 94 | 284 | 1829318 | 1829498 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 395 | 172 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5466865 | 5466865 | PRJNA1262902_P_NODE_5025_length_278_cov_1.502439_g4983_i0 | PRJNA1262902 | 5025 | 278 | 1.502439 | 4.17678042 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 158 | 5.2699999999999985e-34 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g4983 | i0 | 89.516 | 37.1942446043165 | 124 | 13 | 45 | 0 | 26 | 149 | 7817081 | 7816958 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 10340 | 158 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 6741281 | 6741281 | PRJNA1262902_P_NODE_11206_length_243_cov_0.905882_g11164_i0 | PRJNA1262902 | 11206 | 243 | 0.905882 | 2.20129326 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 252 | 2.01e-62 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g11164 | i0 | 85.425 | 1.83539094650206 | 247 | 31 | 99 | 5 | 2 | 243 | 32700 | 32454 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 446 | 252 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 9291733 | 9291733 | PRJNA1262902_P_NODE_9828_length_246_cov_0.890173_g9786_i0 | PRJNA1262902 | 9828 | 246 | 0.890173 | 2.18982558 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 222 | 1.5999999999999996e-53 | NTclustered | gi|2874253835|emb|OY969885.1| | 1672391 | g9786 | i0 | 93.333 | 2.71544715447154 | 150 | 10 | 61 | 0 | 5 | 154 | 788285 | 788136 | MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 | blastn | 668 | 222 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10567627 | 10567627 | PRJNA1262902_P_NODE_1609_length_377_cov_1.013158_g1567_i0 | PRJNA1262902 | 1609 | 377 | 1.013158 | 3.81960566 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 307 | 6.940000000000001e-79 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g1567 | i0 | 82.486 | 1.97082228116711 | 354 | 58 | 93 | 4 | 26 | 377 | 3099666 | 3100017 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 743 | 307 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 11842157 | 11842157 | PRJNA1262902_P_NODE_10430_length_245_cov_0.895349_g10388_i0 | PRJNA1262902 | 10430 | 245 | 0.895349 | 2.19360505 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 292 | 1.2e-74 | NTclustered | gi|2874253835|emb|OY969885.1| | 1672391 | g10388 | i0 | 88.983 | 5.56326530612245 | 236 | 26 | 96 | 0 | 6 | 241 | 1648512 | 1648747 | MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 | blastn | 1363 | 292 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 11842197 | 11842197 | PRJNA1262902_P_NODE_4630_length_284_cov_1.265403_g4588_i0 | PRJNA1262902 | 4630 | 284 | 1.265403 | 3.59374452 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 226 | 1.4599999999999998e-54 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g4588 | i0 | 81.053 | 12.9718309859155 | 285 | 53 | 100 | 1 | 1 | 284 | 780005 | 779721 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 3684 | 226 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 11842232 | 11842232 | PRJNA1262902_P_NODE_8230_length_249_cov_1.363636_g8188_i0 | PRJNA1262902 | 8230 | 249 | 1.363636 | 3.39545364 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 180 | 9.91e-41 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g8188 | i0 | 81.9 | 6.09236947791165 | 221 | 33 | 87 | 6 | 29 | 245 | 1697576 | 1697793 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 1517 | 180 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 15666442 | 15666442 | PRJNA1262902_P_NODE_4993_length_279_cov_1.286408_g4951_i0 | PRJNA1262902 | 4993 | 279 | 1.286408 | 3.58907832 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 195 | 4.03e-45 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g4951 | i0 | 82.589 | 1.44444444444444 | 224 | 36 | 79 | 2 | 1 | 221 | 1758594 | 1758817 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 403 | 195 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 20765115 | 20765115 | PRJNA1262902_P_NODE_6637_length_258_cov_1.718919_g6595_i0 | PRJNA1262902 | 6637 | 258 | 1.718919 | 4.43481102 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 226 | 1.31e-54 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g6595 | i0 | 83.401 | 1.56589147286822 | 247 | 38 | 95 | 3 | 6 | 250 | 1433131 | 1433376 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 404 | 226 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 20765132 | 20765132 | PRJNA1262902_P_NODE_7957_length_250_cov_0.870056_g7915_i0 | PRJNA1262902 | 7957 | 250 | 0.870056 | 2.17514 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 219 | 2.11e-52 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g7915 | i0 | 85.849 | 31.104 | 212 | 22 | 83 | 6 | 1 | 208 | 2047857 | 2048064 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 7776 | 219 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 22730826 | 22730826 | PRJNA1262902_P_NODE_8678_length_248_cov_1.320000_g8636_i0 | PRJNA1262902 | 8678 | 248 | 1.32 | 3.2736 | Phototrophicus | 2922426 | Bacteria | Bacteria | 263 | 9.519999999999998e-66 | NTclustered | gi|1985684846|gb|CP069394.1| | 2026724 | g8636 | i0 | 88 | 508.532258064516 | 225 | 24 | 90 | 3 | 25 | 248 | 1474004 | 1474226 | Chloroflexi bacterium strain ZRK35 chromosome, complete genome | blastn | 126116 | 263 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 23315663 | 23315663 | PRJNA1262902_P_NODE_11179_length_243_cov_0.905882_g11137_i0 | PRJNA1262902 | 11179 | 243 | 0.905882 | 2.20129326 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 267 | 7.19e-67 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g11137 | i0 | 86.42 | 1.99588477366255 | 243 | 33 | 100 | 0 | 1 | 243 | 1536668 | 1536910 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 485 | 267 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia 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);;