contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1167252" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1589301 | 1589301 | PRJNA1167252_P_NODE_26642_length_247_cov_0.896552_g26369_i0 | PRJNA1167252 | 26642 | 247 | 0.896552 | 2.21448344 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 206 | 1.6199999999999998e-48 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g26369 | i0 | 82.353 | 9.98380566801619 | 238 | 40 | 96 | 2 | 1 | 237 | 2167517 | 2167753 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 2466 | 206 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 2865482 | 2865482 | PRJNA1167252_P_NODE_28223_length_244_cov_0.912281_g27950_i0 | PRJNA1167252 | 28223 | 244 | 0.912281 | 2.22596564 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 121 | 5.949999999999999e-23 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g27950 | i0 | 94.805 | 33.1967213114754 | 77 | 4 | 32 | 0 | 16 | 92 | 2896919 | 2896843 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 8100 | 121 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 9242101 | 9242101 | PRJNA1167252_P_NODE_10128_length_394_cov_1.545171_g9855_i0 | PRJNA1167252 | 10128 | 394 | 1.545171 | 6.08797374 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 507 | 6.69e-139 | NTclustered | gi|2874254133|emb|OY970218.1| | 1672391 | g9855 | i0 | 89.588 | 345.756345177665 | 413 | 24 | 100 | 9 | 1 | 394 | 18413 | 18825 | MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1 | blastn | 136228 | 507 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10518165 | 10518165 | PRJNA1167252_P_NODE_21869_length_258_cov_1.589189_g21596_i0 | PRJNA1167252 | 21869 | 258 | 1.589189 | 4.10010762 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 172 | 1.73e-38 | NTclustered | gi|2874254133|emb|OY970218.1| | 1672391 | g21596 | i0 | 80.804 | 1.15891472868217 | 224 | 40 | 86 | 3 | 15 | 236 | 1424523 | 1424745 | MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1 | blastn | 299 | 172 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10518235 | 10518235 | PRJNA1167252_P_NODE_24489_length_250_cov_0.881356_g24216_i0 | PRJNA1167252 | 24489 | 250 | 0.881356 | 2.20339 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 211 | 3.53e-50 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g24216 | i0 | 85.437 | 13.228 | 206 | 27 | 82 | 3 | 3 | 206 | 1590705 | 1590501 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 3307 | 211 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 11793271 | 11793271 | PRJNA1167252_P_NODE_27630_length_245_cov_0.906977_g27357_i0 | PRJNA1167252 | 27630 | 245 | 0.906977 | 2.22209365 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 211 | 3.45e-50 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g27357 | i0 | 84.475 | 104.326530612245 | 219 | 28 | 88 | 6 | 30 | 245 | 2778120 | 2778335 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 25560 | 211 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 11793411 | 11793411 | PRJNA1167252_P_NODE_5930_length_541_cov_2.162393_g5657_i0 | PRJNA1167252 | 5930 | 541 | 2.162393 | 11.69854613 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 806 | 0 | NTclustered | gi|2556903179|gb|CP129482.1| | 2073117 | g5657 | i0 | 93.554 | 83.8502772643253 | 543 | 31 | 100 | 4 | 1 | 541 | 3065982 | 3065442 | MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome | blastn | 45363 | 806 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 14343274 | 14343274 | PRJNA1167252_P_NODE_15752_length_309_cov_0.991525_g15479_i0 | PRJNA1167252 | 15752 | 309 | 0.991525 | 3.06381225 | Tepidiformaceae bacterium | 3022862 | Bacteria | Bacteria | 156 | 2.14e-33 | NTclustered | gi|2893358404|emb|OZ220695.1| | 3022862 | g15479 | i0 | 86.525 | 233.016181229773 | 141 | 19 | 46 | 0 | 1 | 141 | 1222145 | 1222285 | MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1 | blastn | 72002 | 156 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiformaceae bacterium | |||
| 15617309 | 15617309 | PRJNA1167252_P_NODE_22933_length_253_cov_0.866667_g22660_i0 | PRJNA1167252 | 22933 | 253 | 0.866667 | 2.19266751 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 163 | 1.02e-35 | NTclustered | gi|2893358376|emb|OZ220670.1| | 2026734 | g22660 | i0 | 79.583 | 73.4347826086957 | 240 | 39 | 93 | 9 | 19 | 253 | 1642813 | 1643047 | MAG: Dehalococcoidia bacterium isolate 3214a3e4-8eac-45e1-a090-ccf36b200536 genome assembly, chromosome: 1 | blastn | 18579 | 163 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 15617394 | 15617394 | PRJNA1167252_P_NODE_26393_length_247_cov_0.896552_g26120_i0 | PRJNA1167252 | 26393 | 247 | 0.896552 | 2.21448344 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 259 | 1.23e-64 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g26120 | i0 | 87.5 | 3.21052631578947 | 224 | 28 | 91 | 0 | 24 | 247 | 2238346 | 2238123 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 793 | 259 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 16891750 | 16891750 | PRJNA1167252_P_NODE_27694_length_245_cov_0.906977_g27421_i0 | PRJNA1167252 | 27694 | 245 | 0.906977 | 2.22209365 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 359 | 1.16e-94 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g27421 | i0 | 93.061 | 77.134693877551 | 245 | 17 | 100 | 0 | 1 | 245 | 1056607 | 1056363 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 18898 | 359 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 20715661 | 20715661 | PRJNA1167252_P_NODE_15777_length_308_cov_3.157447_g15504_i0 | PRJNA1167252 | 15777 | 308 | 3.157447 | 9.72493676 | uncultured Chloroflexota bacterium | 166587 | Bacteria | Bacteria | 483 | 8.6e-132 | NTclustered | gi|409900407|gb|JX859928.1| | 166587 | g15504 | i0 | 96.259 | 95.2662337662338 | 294 | 11 | 95 | 0 | 7 | 300 | 773 | 480 | Uncultured Chloroflexi bacterium clone TRF-202 16S ribosomal RNA gene, partial sequence | blastn | 29342 | 483 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexota 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);;