contig_metadata
23 rows where bioproject = "PRJNA888821" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9791185 | 9791185 | PRJNA888821_P_NODE_788_length_590_cov_12.651838_g716_i0 | PRJNA888821 | 788 | 590 | 12.651838 | 74.6458442 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 558 | 2.82e-154 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g716 | i0 | 84.228 | 22.7271186440678 | 596 | 70 | 100 | 19 | 1 | 590 | 3043467 | 3044044 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 13409 | 558 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 11066757 | 11066757 | PRJNA888821_P_NODE_689_length_619_cov_31.315018_g618_i0 | PRJNA888821 | 689 | 619 | 31.315018 | 193.83996142 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 614 | 6.239999999999999e-171 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g618 | i0 | 84.897 | 42.4184168012924 | 629 | 72 | 99 | 18 | 3 | 618 | 231271 | 231889 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 26257 | 614 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 12341705 | 12341705 | PRJNA888821_P_NODE_1530_length_479_cov_13.512315_g1455_i0 | PRJNA888821 | 1530 | 479 | 13.512315 | 64.72398885 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 394 | 6.729999999999999e-105 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g1455 | i0 | 81.893 | 232.807933194154 | 486 | 71 | 100 | 15 | 1 | 479 | 5915732 | 5915257 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 111515 | 394 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 13616809 | 13616809 | PRJNA888821_P_NODE_49411_length_207_cov_10.388060_g49328_i0 | PRJNA888821 | 49411 | 207 | 10.38806 | 21.5032842 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 278 | 2.75e-70 | NTclustered | gi|2874254163|emb|OY970395.1| | 412054 | g49328 | i0 | 90.909 | 70.8695652173913 | 209 | 15 | 100 | 4 | 1 | 207 | 1607679 | 1607885 | MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 | blastn | 14670 | 278 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 14891191 | 14891191 | PRJNA888821_P_NODE_53572_length_196_cov_8.609756_g53489_i0 | PRJNA888821 | 53572 | 196 | 8.609756 | 16.87512176 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 244 | 2.61e-60 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g53489 | i0 | 89.286 | 49.9948979591837 | 196 | 20 | 100 | 1 | 1 | 196 | 1903444 | 1903250 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 9799 | 244 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 15269797 | 15269797 | PRJNA888821_P_NODE_36752_length_246_cov_17.647399_g36669_i0 | PRJNA888821 | 36752 | 246 | 17.647399 | 43.41260154 | Gemmatimonadaceae | 219687 | Bacteria | Bacteria | 383 | 6.94e-102 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g36669 | i0 | 94.737 | 164.414634146341 | 247 | 12 | 100 | 1 | 1 | 246 | 2321 | 2567 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 40446 | 383 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 16165293 | 16165293 | PRJNA888821_P_NODE_13813_length_310_cov_7.464135_g13731_i0 | PRJNA888821 | 13813 | 310 | 7.464135 | 23.1388185 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 171 | 7.66e-38 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g13731 | i0 | 87.417 | 4.34838709677419 | 151 | 15 | 96 | 4 | 1 | 150 | 1903778 | 1903631 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 1348 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 16165514 | 16165514 | PRJNA888821_P_NODE_2833_length_398_cov_14.046154_g2754_i0 | PRJNA888821 | 2833 | 398 | 14.046154 | 55.90369292 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 424 | 7.01e-114 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g2754 | i0 | 86.146 | 156.072864321608 | 397 | 49 | 99 | 6 | 4 | 398 | 172445 | 172053 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 62117 | 424 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 21265216 | 21265216 | PRJNA888821_P_NODE_797_length_588_cov_1.155340_g725_i0 | PRJNA888821 | 797 | 588 | 1.15534 | 6.7933992 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 850 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g725 | i0 | 92.869 | 145.382653061224 | 589 | 37 | 100 | 4 | 1 | 588 | 3043134 | 3043718 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 85485 | 850 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 21265227 | 21265227 | PRJNA888821_P_NODE_8317_length_310_cov_13.873418_g8235_i0 | PRJNA888821 | 8317 | 310 | 13.873418 | 43.0075958 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 137 | 7.77e-28 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g8235 | i0 | 86.885 | 0.793548387096774 | 122 | 16 | 39 | 0 | 1 | 122 | 133375 | 133254 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 246 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 22919668 | 22919668 | PRJNA888821_P_NODE_51258_length_202_cov_7.627907_g51175_i0 | PRJNA888821 | 51258 | 202 | 7.627907 | 15.40837214 | Bacteria | 2 | Bacteria | Bacteria | 147 | 7.84e-31 | NTclustered | gi|2107911987|gb|CP070812.1| | 2026742 | g51175 | i0 | 80.612 | 13.5891089108911 | 196 | 32 | 96 | 6 | 2 | 194 | 1718945 | 1719137 | MAG: Gemmatimonadetes bacterium isolate bin1194 chromosome | blastn | 2745 | 148 | 0.993243243243243 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 23815393 | 23815393 | PRJNA888821_P_NODE_5479_length_321_cov_6.475806_g5397_i0 | PRJNA888821 | 5479 | 321 | 6.475806 | 20.78733726 | Pseudogemmatithrix spongiicola | 3062599 | Bacteria | Bacteria | 110 | 1.76e-19 | NTclustered | gi|2557479348|gb|CP130613.1| | 3062599 | g5397 | i0 | 81.679 | 0.81619937694704 | 131 | 24 | 41 | 0 | 1 | 131 | 2220257 | 2220387 | Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome | blastn | 262 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Pseudogemmatithrix | Pseudogemmatithrix spongiicola | |
| 27245094 | 27245094 | PRJNA888821_P_NODE_45883_length_218_cov_8.448276_g45800_i0 | PRJNA888821 | 45883 | 218 | 8.448276 | 18.41724168 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 95.1 | 8.050000000000001e-21 | NR | HEY4306869.1 | 2026741 | g45800 | i0 | 63.9 | 1.87155963302752 | 72 | 25 | 97.7 | 1 | 5 | 217 | 322 | 393 | HEY4306869.1 pitrilysin family protein [Gemmatimonadaceae bacterium] | diamond | 408 | 95.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28161102 | 28161102 | PRJNA888821_P_NODE_11045_length_310_cov_9.932489_g10963_i0 | PRJNA888821 | 11045 | 310 | 9.932489 | 30.7907159 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 91.3 | 7.27e-19 | NR | HET6778985.1 | 2448054 | g10963 | i0 | 92 | 3 | 50 | 4 | 48.4 | 0 | 1 | 150 | 505 | 554 | HET6778985.1 3-deoxy-7-phosphoheptulonate synthase [Gemmatimonadales bacterium] | diamond | 930 | 91.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28823694 | 28823694 | PRJNA888821_P_NODE_38248_length_243_cov_6.547059_g38165_i0 | PRJNA888821 | 38248 | 243 | 6.547059 | 15.90935337 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 142 | 2.62e-41 | NR | WP_331050585.1 | 1962908 | g38165 | i0 | 87.7 | 1 | 81 | 10 | 100 | 0 | 243 | 1 | 20 | 100 | WP_331050585.1 hypothetical protein [Gemmatimonas sp.] | diamond | 243 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 29644489 | 29644489 | PRJNA888821_P_NODE_42230_length_231_cov_4.094937_g42147_i0 | PRJNA888821 | 42230 | 231 | 4.094937 | 9.45930447 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 152 | 9.67e-44 | NR | HZN98768.1 | 2448054 | g42147 | i0 | 92.1 | 2.96103896103896 | 76 | 6 | 98.7 | 0 | 2 | 229 | 119 | 194 | HZN98768.1 PHP domain-containing protein [Gemmatimonadales bacterium] | diamond | 684 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29652412 | 29652412 | PRJNA888821_P_NODE_2990_length_392_cov_12.542320_g2909_i0 | PRJNA888821 | 2990 | 392 | 12.54232 | 49.1658944 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 138 | 7.729999999999998e-35 | NR | MBV9108362.1 | 2026742 | g2909 | i0 | 77.3 | 2.34183673469388 | 75 | 17 | 57.4 | 0 | 392 | 168 | 673 | 747 | MBV9108362.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 918 | 138 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29842195 | 29842195 | PRJNA888821_P_NODE_22631_length_307_cov_10.115385_g22549_i0 | PRJNA888821 | 22631 | 307 | 10.115385 | 31.05423195 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.4 | 7.17e-9 | NR | WP_337172358.1 | 173480 | g22549 | i0 | 59.6 | 0.928338762214984 | 47 | 19 | 45.9 | 0 | 1 | 141 | 128 | 174 | WP_337172358.1 SRPBCC domain-containing protein [Gemmatimonas aurantiaca] | diamond | 285 | 62.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 30442636 | 30442636 | PRJNA888821_P_NODE_31433_length_264_cov_1.246073_g31350_i0 | PRJNA888821 | 31433 | 264 | 1.246073 | 3.28963272 | Gemmatimonas | 173479 | Bacteria | Bacteria | 130 | 6.7999999999999995e-35 | NR | WP_291261215.1 | 1962908 | g31350 | i0 | 80.2 | 8.76136363636364 | 86 | 17 | 97.7 | 0 | 259 | 2 | 161 | 246 | WP_291261215.1 prohibitin family protein [Gemmatimonas sp.] | diamond | 2313 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 30782171 | 30782171 | PRJNA888821_P_NODE_40494_length_237_cov_5.152439_g40411_i0 | PRJNA888821 | 40494 | 237 | 5.152439 | 12.21128043 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 106 | 1.16e-24 | NR | MBV9108362.1 | 2026742 | g40411 | i0 | 67.6 | 0.936708860759494 | 74 | 24 | 93.7 | 0 | 225 | 4 | 927 | 1000 | MBV9108362.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 222 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31224364 | 31224364 | PRJNA888821_P_NODE_19195_length_310_cov_3.388186_g19113_i0 | PRJNA888821 | 19195 | 310 | 3.388186 | 10.5033766 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 93.6 | 8.719999999999999e-23 | NR | HEY4132494.1 | 2026741 | g19113 | i0 | 89.8 | 1.42258064516129 | 49 | 5 | 47.4 | 0 | 164 | 310 | 1 | 49 | HEY4132494.1 pyruvate kinase [Gemmatimonadaceae bacterium] | diamond | 441 | 93.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32015296 | 32015296 | PRJNA888821_P_NODE_10398_length_310_cov_10.611814_g10316_i0 | PRJNA888821 | 10398 | 310 | 10.611814 | 32.8966234 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 74.3 | 5.59e-13 | NR | MEO7367026.1 | 2026741 | g10316 | i0 | 48.2 | 2.92258064516129 | 85 | 42 | 82.3 | 1 | 292 | 38 | 151 | 233 | MEO7367026.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadaceae bacterium] | diamond | 906 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32023253 | 32023253 | PRJNA888821_P_NODE_14378_length_310_cov_7.021097_g14296_i0 | PRJNA888821 | 14378 | 310 | 7.021097 | 21.7654007 | FCB group | 1783270 | Bacteria | Bacteria | 92 | 2.76e-20 | NR | MCC6771627.1 | 2026741 | g14296 | i0 | 91.8 | 0.948387096774194 | 49 | 4 | 47.4 | 0 | 162 | 308 | 46 | 94 | MCC6771627.1 ceramidase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 294 | 92.8 | 0.991379310344828 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;