contig_metadata
24 rows where bioproject = "PRJNA1005695", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153690 | 153690 | PRJNA1005695_P_NODE_6921_length_596_cov_3.378585_g6090_i0 | PRJNA1005695 | 6921 | 596 | 3.378585 | 20.1363666 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 752 | 0 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g6090 | i0 | 91.32 | 102.578859060403 | 553 | 45 | 93 | 3 | 45 | 596 | 634952 | 635502 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 61137 | 752 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 1428261 | 1428261 | PRJNA1005695_P_NODE_27562_length_285_cov_1.250000_g26710_i0 | PRJNA1005695 | 27562 | 285 | 1.25 | 3.5625 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g26710 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 0 | 180 | 207 | 5483412 | 5483439 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 2703628 | 2703628 | PRJNA1005695_P_NODE_15583_length_385_cov_1.355769_g14731_i0 | PRJNA1005695 | 15583 | 385 | 1.355769 | 5.21971065 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 534 | 2.99e-147 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g14731 | i0 | 91.688 | 553.787012987013 | 385 | 32 | 100 | 0 | 1 | 385 | 4648950 | 4648566 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 213208 | 534 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 3979874 | 3979874 | PRJNA1005695_P_NODE_22264_length_318_cov_1.934694_g21412_i0 | PRJNA1005695 | 22264 | 318 | 1.934694 | 6.15232692 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 394 | 4.3e-105 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g21412 | i0 | 89.028 | 126.455974842767 | 319 | 33 | 100 | 2 | 1 | 318 | 4232009 | 4231692 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 40213 | 394 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 3980111 | 3980111 | PRJNA1005695_P_NODE_8584_length_534_cov_1.171367_g7738_i0 | PRJNA1005695 | 8584 | 534 | 1.171367 | 6.25509978 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 752 | 0 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g7738 | i0 | 92.037 | 142.104868913858 | 540 | 35 | 100 | 6 | 1 | 534 | 3299732 | 3299195 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 75884 | 752 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 5256417 | 5256417 | PRJNA1005695_P_NODE_24285_length_304_cov_7.194805_g23433_i0 | PRJNA1005695 | 24285 | 304 | 7.194805 | 21.8722072 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 257 | 5.59e-64 | NTclustered | gi|2874254108|emb|OY970193.1| | 171953 | g23433 | i0 | 87.5 | 187.131578947368 | 224 | 26 | 74 | 2 | 5 | 228 | 1689585 | 1689364 | MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 | blastn | 56888 | 257 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 7806141 | 7806141 | PRJNA1005695_P_NODE_35367_length_251_cov_1.988764_g34515_i0 | PRJNA1005695 | 35367 | 251 | 1.988764 | 4.99179764 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 375 | 1.1899999999999998e-99 | NTclustered | gi|2874253796|emb|OY969780.1| | 194844 | g34515 | i0 | 93.676 | 114.733067729084 | 253 | 12 | 100 | 3 | 1 | 251 | 285268 | 285018 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 | blastn | 28798 | 375 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 7806192 | 7806192 | PRJNA1005695_P_NODE_39907_length_242_cov_1.526627_g39055_i0 | PRJNA1005695 | 39907 | 242 | 1.526627 | 3.69443734 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 169 | 2.07e-37 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g39055 | i0 | 81.132 | 0.87603305785124 | 212 | 38 | 87 | 2 | 32 | 242 | 4108587 | 4108797 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 212 | 169 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 10356745 | 10356745 | PRJNA1005695_P_NODE_37049_length_248_cov_0.891429_g36197_i0 | PRJNA1005695 | 37049 | 248 | 0.891429 | 2.21074392 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 226 | 1.2499999999999999e-54 | NTclustered | gi|112980870|gb|DQ829674.1| | 171953 | g36197 | i0 | 83.065 | 131.084677419355 | 248 | 42 | 100 | 0 | 1 | 248 | 319 | 566 | Uncultured Acidobacteria bacterium clone DON24 23S ribosomal RNA gene, partial sequence | blastn | 32509 | 226 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13754624 | 13754624 | PRJNA1005695_P_NODE_8031_length_552_cov_3.736952_g7193_i0 | PRJNA1005695 | 8031 | 552 | 3.736952 | 20.62797504 | Chloracidobacterium | 458032 | Bacteria | Bacteria | 665 | 0 | NTclustered | gi|470487921|ref|NR_076842.1| | 458033 | g7193 | i0 | 88.73 | 94.8405797101449 | 559 | 43 | 100 | 14 | 1 | 552 | 369 | 914 | Chloracidobacterium thermophilum strain B 23S ribosomal RNA, complete sequence | blastn | 52352 | 665 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium thermophilum | ||
| 14182199 | 14182199 | PRJNA1005695_P_NODE_27752_length_284_cov_1.165877_g26900_i0 | PRJNA1005695 | 27752 | 284 | 1.165877 | 3.31109068 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 291 | 5.1000000000000005e-74 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g26900 | i0 | 90.222 | 130.669014084507 | 225 | 18 | 79 | 3 | 60 | 284 | 634682 | 634902 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 37110 | 291 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 15456172 | 15456172 | PRJNA1005695_P_NODE_28993_length_277_cov_3.200980_g28141_i0 | PRJNA1005695 | 28993 | 277 | 3.20098 | 8.8667146 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 324 | 4.89e-84 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g28141 | i0 | 88.087 | 203.512635379061 | 277 | 28 | 100 | 3 | 1 | 277 | 4784548 | 4784819 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 56373 | 324 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 16730287 | 16730287 | PRJNA1005695_P_NODE_10574_length_477_cov_2.722772_g9722_i0 | PRJNA1005695 | 10574 | 477 | 2.722772 | 12.98762244 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 52.8 | 0.046 | NTclustered | gi|2874253700|emb|OY969426.1| | 2651171 | g9722 | i0 | 100 | 0.117400419287212 | 28 | 0 | 6 | 0 | 171 | 198 | 1355450 | 1355423 | MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1 | blastn | 56 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 16730346 | 16730346 | PRJNA1005695_P_NODE_17894_length_357_cov_2.577465_g17042_i0 | PRJNA1005695 | 17894 | 357 | 2.577465 | 9.20155005 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 627 | 4.4199999999999986e-175 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g17042 | i0 | 98.319 | 129.857142857143 | 357 | 6 | 100 | 0 | 1 | 357 | 633728 | 633372 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 46359 | 627 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 20554661 | 20554661 | PRJNA1005695_P_NODE_23277_length_311_cov_3.500000_g22425_i0 | PRJNA1005695 | 23277 | 311 | 3.5 | 10.885 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 575 | 1.3899999999999995e-159 | NTclustered | gi|157142413|gb|EU122684.1| | 171953 | g22425 | i0 | 100 | 99.7845659163987 | 311 | 0 | 100 | 0 | 1 | 311 | 218 | 528 | Uncultured Acidobacteria bacterium clone KL2-087 16S ribosomal RNA gene, partial sequence | blastn | 31033 | 575 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 21830368 | 21830368 | PRJNA1005695_P_NODE_34898_length_252_cov_2.240223_g34046_i0 | PRJNA1005695 | 34898 | 252 | 2.240223 | 5.64536196 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 444 | 3.2299999999999996e-120 | NTclustered | gi|2874253862|emb|OY969918.1| | 171953 | g34046 | i0 | 98.413 | 125.416666666667 | 252 | 4 | 100 | 0 | 1 | 252 | 2908054 | 2907803 | MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1 | blastn | 31605 | 444 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 21830379 | 21830379 | PRJNA1005695_P_NODE_35958_length_250_cov_1.440678_g35106_i0 | PRJNA1005695 | 35958 | 250 | 1.440678 | 3.601695 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 309 | 1.22e-79 | NTclustered | gi|2874253796|emb|OY969780.1| | 194844 | g35106 | i0 | 90.041 | 101.488 | 241 | 20 | 96 | 4 | 1 | 239 | 285729 | 285967 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 | blastn | 25372 | 309 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 23105864 | 23105864 | PRJNA1005695_P_NODE_39299_length_243_cov_2.294118_g38447_i0 | PRJNA1005695 | 39299 | 243 | 2.294118 | 5.57470674 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 346 | 8.97e-91 | NTclustered | gi|2874253750|emb|OY969625.1| | 194844 | g38447 | i0 | 92.857 | 111.448559670782 | 238 | 17 | 98 | 0 | 1 | 238 | 2558 | 2321 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1 | blastn | 27082 | 346 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 28992749 | 28992749 | PRJNA1005695_P_NODE_1268_length_1406_cov_2.809452_g904_i0 | PRJNA1005695 | 1268 | 1406 | 2.809452 | 39.50089512 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 100 | 2.36e-18 | NR | HEX5069531.1 | 2910147 | g904 | i0 | 28.6 | 3.80440967283073 | 262 | 152 | 52.3 | 7 | 1386 | 652 | 369 | 612 | HEX5069531.1 long-chain fatty acid--CoA ligase [Vicinamibacterales bacterium] | diamond | 5349 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30350963 | 30350963 | PRJNA1005695_P_NODE_37432_length_247_cov_1.344828_g36580_i0 | PRJNA1005695 | 37432 | 247 | 1.344828 | 3.32172516 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 45.4 | 0.00375 | NR | MBK6313972.1 | 2052146 | g36580 | i0 | 34.1 | 1.88259109311741 | 85 | 51 | 97.2 | 2 | 242 | 3 | 59 | 143 | MBK6313972.1 ABC transporter ATP-binding protein [Blastocatellia bacterium] | diamond | 465 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31638742 | 31638742 | PRJNA1005695_P_NODE_35516_length_251_cov_0.876404_g34664_i0 | PRJNA1005695 | 35516 | 251 | 0.876404 | 2.19977404 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.1 | 1.04e-4 | NR | WP_164981626.1 | 1560006 | g34664 | i0 | 35 | 6.47808764940239 | 80 | 52 | 95.6 | 0 | 12 | 251 | 290 | 369 | WP_164981626.1 tetratricopeptide repeat protein [Silvibacterium dinghuense] | diamond | 1626 | 50.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Silvibacterium | Silvibacterium dinghuense | ||
| 31867615 | 31867615 | PRJNA1005695_P_NODE_38977_length_244_cov_0.912281_g38125_i0 | PRJNA1005695 | 38977 | 244 | 0.912281 | 2.22596564 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 42.7 | 0.0347 | NR | HEY8549577.1 | 2910147 | g38125 | i0 | 39 | 0.725409836065574 | 59 | 31 | 66.4 | 1 | 59 | 220 | 137 | 195 | HEY8549577.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 177 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31962630 | 31962630 | PRJNA1005695_P_NODE_31178_length_267_cov_2.097938_g30326_i0 | PRJNA1005695 | 31178 | 267 | 2.097938 | 5.60149446 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0383 | NR | MDH3522665.1 | 1978231 | g30326 | i0 | 41.3 | 0.842696629213483 | 75 | 38 | 82 | 3 | 37 | 255 | 285 | 355 | MDH3522665.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 225 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32776699 | 32776699 | PRJNA1005695_P_NODE_10180_length_487_cov_1.845411_g9328_i0 | PRJNA1005695 | 10180 | 487 | 1.845411 | 8.98715157 | root | 1 | Root_unresolved | Root_unresolved | 74.3 | 2.41e-12 | NR | MCW5950305.1 | 2283092 | g9328 | i0 | 43 | 2.49486652977413 | 107 | 40 | 53 | 2 | 155 | 412 | 36 | 142 | MCW5950305.1 cytochrome c oxidase subunit 3 [Pyrinomonadaceae bacterium] | diamond | 1215 | 74.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;