contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830586 | 830586 | PRJNA841653_P_NODE_40021_length_261_cov_1.170213_g39347_i0 | PRJNA841653 | 40021 | 261 | 1.170213 | 3.05425593 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 342 | 1.26e-89 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g39347 | i0 | 91.235 | 72.7126436781609 | 251 | 22 | 96 | 0 | 11 | 261 | 2800152 | 2799902 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 18978 | 342 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 830668 | 830668 | PRJNA841653_P_NODE_44801_length_250_cov_1.621469_g44127_i0 | PRJNA841653 | 44801 | 250 | 1.621469 | 4.0536725 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 171 | 5.99e-38 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g44127 | i0 | 81.863 | 2.26 | 204 | 35 | 81 | 2 | 5 | 207 | 2650984 | 2651186 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 565 | 171 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 2105764 | 2105764 | PRJNA841653_P_NODE_25842_length_321_cov_1.221774_g25168_i0 | PRJNA841653 | 25842 | 321 | 1.221774 | 3.92189454 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 250 | 9.95e-62 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g25168 | i0 | 81.27 | 4.00623052959502 | 315 | 54 | 98 | 5 | 4 | 318 | 2741961 | 2741652 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 1286 | 250 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 2106324 | 2106324 | PRJNA841653_P_NODE_53622_length_245_cov_1.505814_g52948_i0 | PRJNA841653 | 53622 | 245 | 1.505814 | 3.6892443 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 254 | 5.65e-63 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g52948 | i0 | 87.387 | 62.9428571428571 | 222 | 27 | 90 | 1 | 11 | 231 | 4985427 | 4985648 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 15421 | 254 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 2106442 | 2106442 | PRJNA841653_P_NODE_60622_length_242_cov_0.911243_g59948_i0 | PRJNA841653 | 60622 | 242 | 0.911243 | 2.20520806 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 318 | 1.95e-82 | NTclustered | gi|2874253678|emb|OY969112.1| | 171953 | g59948 | i0 | 91.102 | 1.96694214876033 | 236 | 20 | 98 | 1 | 5 | 240 | 3092179 | 3091945 | MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 | blastn | 476 | 318 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 2106536 | 2106536 | PRJNA841653_P_NODE_7922_length_601_cov_1.840909_g7264_i0 | PRJNA841653 | 7922 | 601 | 1.840909 | 11.06386309 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 472 | 3.85e-128 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g7264 | i0 | 87.409 | 0.770382695507488 | 413 | 49 | 77 | 3 | 10 | 420 | 4108822 | 4108411 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 463 | 472 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 3381433 | 3381433 | PRJNA841653_P_NODE_40103_length_260_cov_2.336898_g39429_i0 | PRJNA841653 | 40103 | 260 | 2.336898 | 6.0759348 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 255 | 1.68e-63 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g39429 | i0 | 86.192 | 39.1153846153846 | 239 | 30 | 91 | 3 | 13 | 249 | 3983224 | 3982987 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 10170 | 255 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4658701 | 4658701 | PRJNA841653_P_NODE_25104_length_325_cov_15.297619_g24430_i0 | PRJNA841653 | 25104 | 325 | 15.297619 | 49.71726175 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 579 | 1.1299999999999997e-160 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g24430 | i0 | 100 | 145.803076923077 | 313 | 0 | 96 | 0 | 1 | 313 | 635885 | 636197 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 47386 | 579 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 4659091 | 4659091 | PRJNA841653_P_NODE_44404_length_251_cov_0.865169_g43730_i0 | PRJNA841653 | 44404 | 251 | 0.865169 | 2.17157419 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 411 | 3.2599999999999996e-110 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g43730 | i0 | 96.748 | 72.4262948207171 | 246 | 8 | 98 | 0 | 6 | 251 | 605981 | 605736 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 18179 | 411 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 4659238 | 4659238 | PRJNA841653_P_NODE_53244_length_246_cov_0.890173_g52570_i0 | PRJNA841653 | 53244 | 246 | 0.890173 | 2.18982558 | Luteitalea sp. TBR-22 | 2802971 | Bacteria | Bacteria | 198 | 2.7e-46 | NTclustered | gi|2131947417|dbj|AP024452.2| | 2802971 | g52570 | i0 | 82.883 | 2.4349593495935 | 222 | 36 | 90 | 2 | 18 | 238 | 5986870 | 5986650 | Vicinamibacteria bacterium TBR-22 DNA, complete genome | blastn | 599 | 198 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea sp. TBR-22 | ||
| 8483735 | 8483735 | PRJNA841653_P_NODE_59607_length_242_cov_0.911243_g58933_i0 | PRJNA841653 | 59607 | 242 | 0.911243 | 2.20520806 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2874254139|emb|OY970224.1| | 171953 | g58933 | i0 | 96.875 | 0.132231404958678 | 32 | 1 | 13 | 0 | 1 | 32 | 2822915 | 2822884 | MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 9758926 | 9758926 | PRJNA841653_P_NODE_57248_length_243_cov_1.629412_g56574_i0 | PRJNA841653 | 57248 | 243 | 1.629412 | 3.95947116 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 204 | 5.71e-48 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g56574 | i0 | 82.403 | 0.958847736625514 | 233 | 41 | 96 | 0 | 1 | 233 | 6243083 | 6243315 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 233 | 204 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 11434290 | 11434290 | PRJNA841653_P_NODE_14769_length_428_cov_1.084507_g14098_i0 | PRJNA841653 | 14769 | 428 | 1.084507 | 4.64168996 | Bacteria | 2 | Bacteria | Bacteria | 553 | 9.279999999999999e-153 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g14098 | i0 | 90.453 | 165.294392523364 | 419 | 40 | 98 | 0 | 1 | 419 | 2367398 | 2367816 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 70746 | 553 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13583947 | 13583947 | PRJNA841653_P_NODE_24631_length_328_cov_16.392157_g23957_i0 | PRJNA841653 | 24631 | 328 | 16.392157 | 53.76627496 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 444 | 4.36e-120 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g23957 | i0 | 93.115 | 0.929878048780488 | 305 | 18 | 93 | 3 | 24 | 328 | 6082326 | 6082025 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 305 | 444 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 14858786 | 14858786 | PRJNA841653_P_NODE_53472_length_245_cov_2.302326_g52798_i0 | PRJNA841653 | 53472 | 245 | 2.302326 | 5.6406987 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 309 | 1.19e-79 | NTclustered | gi|1958093598|gb|CP065003.1| | 1978231 | g52798 | i0 | 90.295 | 360.844897959184 | 237 | 22 | 96 | 1 | 10 | 245 | 317552 | 317316 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome | blastn | 88407 | 309 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 18681783 | 18681783 | PRJNA841653_P_NODE_34955_length_278_cov_1.126829_g34281_i0 | PRJNA841653 | 34955 | 278 | 1.126829 | 3.13258462 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 346 | 1.05e-90 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g34281 | i0 | 93.886 | 0.823741007194245 | 229 | 14 | 82 | 0 | 37 | 265 | 5524189 | 5524417 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 229 | 346 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 21232875 | 21232875 | PRJNA841653_P_NODE_51577_length_247_cov_0.867816_g50903_i0 | PRJNA841653 | 51577 | 247 | 0.867816 | 2.14350552 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 237 | 5.74e-58 | NTclustered | gi|2874253959|emb|OY970284.1| | 2651171 | g50903 | i0 | 85.106 | 2.59919028340081 | 235 | 31 | 94 | 4 | 1 | 232 | 5113387 | 5113154 | MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1 | blastn | 642 | 237 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 21232997 | 21232997 | PRJNA841653_P_NODE_58837_length_243_cov_0.905882_g58163_i0 | PRJNA841653 | 58837 | 243 | 0.905882 | 2.20129326 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 198 | 2.6599999999999998e-46 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g58163 | i0 | 81.405 | 0.995884773662551 | 242 | 45 | 99 | 0 | 2 | 243 | 4403523 | 4403282 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 242 | 198 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 |
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);;