contig_metadata
25 rows where bioproject = "PRJNA950981", tax_phylum = "Myxococcota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12412936 | 12412936 | PRJNA950981_P_NODE_13610_length_279_cov_1.825243_g13434_i0 | PRJNA950981 | 13610 | 279 | 1.825243 | 5.09242797 | Nannocystis pusilla | 889268 | Bacteria | Bacteria | 178 | 4.7199999999999984e-55 | NR | WP_224194864.1 | 889268 | g13434 | i0 | 88.2 | 8 | 93 | 11 | 100 | 0 | 1 | 279 | 6 | 98 | WP_224194864.1 peptidylprolyl isomerase [Nannocystis pusilla] | diamond | 2232 | 178 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis pusilla | |||
| 19113865 | 19113865 | PRJNA950981_P_NODE_7335_length_366_cov_0.979522_g7159_i0 | PRJNA950981 | 7335 | 366 | 0.979522 | 3.58505052 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 149 | 6.53e-41 | NR | MFT7626187.1 | 2818507 | g7159 | i0 | 62.9 | 1.92622950819672 | 116 | 40 | 95.1 | 3 | 8 | 355 | 172 | 284 | MFT7626187.1 taurine--2-oxoglutarate transaminase [Myxococcota bacterium] | diamond | 705 | 149 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 25159981 | 25159981 | PRJNA950981_P_NODE_12200_length_294_cov_1.411765_g12024_i0 | PRJNA950981 | 12200 | 294 | 1.411765 | 4.1505891 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 398 | 3.0399999999999997e-106 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g12024 | i0 | 91.186 | 113.649659863946 | 295 | 22 | 99 | 4 | 2 | 294 | 3942326 | 3942034 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 33413 | 398 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 26899084 | 26899084 | PRJNA950981_P_NODE_7281_length_367_cov_1.326531_g7105_i0 | PRJNA950981 | 7281 | 367 | 1.326531 | 4.86836877 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 48.9 | 8.86e-4 | NR | HEY4240652.1 | 2212474 | g7105 | i0 | 35.4 | 4.27520435967302 | 99 | 41 | 66.2 | 5 | 66 | 308 | 109 | 202 | HEY4240652.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 1569 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 26993667 | 26993667 | PRJNA950981_P_NODE_12102_length_295_cov_1.405405_g11926_i0 | PRJNA950981 | 12102 | 295 | 1.405405 | 4.14594475 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 64.7 | 1.21e-9 | NR | MEI6790489.1 | 2484252 | g11926 | i0 | 55.6 | 0.549152542372881 | 54 | 24 | 54.9 | 0 | 279 | 118 | 332 | 385 | MEI6790489.1 GMC family oxidoreductase N-terminal domain-containing protein [Myxococcaceae bacterium] | diamond | 162 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 27000294 | 27000294 | PRJNA950981_P_NODE_19162_length_247_cov_1.321839_g18986_i0 | PRJNA950981 | 19162 | 247 | 1.321839 | 3.26494233 | Bacteria | 2 | Bacteria | Bacteria | 94.7 | 1.86e-20 | NR | HZH03096.1 | 2484252 | g18986 | i0 | 56.8 | 6.36437246963563 | 81 | 35 | 98.4 | 0 | 245 | 3 | 261 | 341 | HZH03096.1 ABC transporter transmembrane domain-containing protein [Myxococcaceae bacterium] | diamond | 1572 | 94.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 27341804 | 27341804 | PRJNA950981_P_NODE_13443_length_281_cov_1.360577_g13267_i0 | PRJNA950981 | 13443 | 281 | 1.360577 | 3.82322137 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 76.6 | 4.75e-14 | NR | WP_395848649.1 | 43 | g13267 | i0 | 53.3 | 2.95729537366548 | 92 | 31 | 96.1 | 6 | 12 | 281 | 236 | 317 | WP_395848649.1 M35 family metallo-endopeptidase [Cystobacter fuscus] | diamond | 831 | 76.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 28036416 | 28036416 | PRJNA950981_P_NODE_8225_length_349_cov_0.847826_g8049_i0 | PRJNA950981 | 8225 | 349 | 0.847826 | 2.95891274 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 47 | 0.0035 | NR | MFO0652429.1 | 3034171 | g8049 | i0 | 33 | 0.756446991404012 | 88 | 54 | 73.1 | 4 | 348 | 94 | 206 | 291 | MFO0652429.1 hypothetical protein [Polyangiales bacterium] | diamond | 264 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 28351991 | 28351991 | PRJNA950981_P_NODE_18546_length_249_cov_0.886364_g18370_i0 | PRJNA950981 | 18546 | 249 | 0.886364 | 2.20704636 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 77.4 | 2.47e-14 | NR | HEY6460759.1 | 2268199 | g18370 | i0 | 52.9 | 1.73493975903614 | 70 | 32 | 83.1 | 1 | 37 | 243 | 353 | 422 | HEY6460759.1 thaumatin family protein [Polyangiaceae bacterium] | diamond | 432 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28509963 | 28509963 | PRJNA950981_P_NODE_16067_length_256_cov_1.704918_g15891_i0 | PRJNA950981 | 16067 | 256 | 1.704918 | 4.36459008 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 125 | 2.09e-33 | NR | HEX5062729.1 | 2212474 | g15891 | i0 | 64.6 | 0.9609375 | 82 | 29 | 96.1 | 0 | 256 | 11 | 121 | 202 | HEX5062729.1 M15 family metallopeptidase [Kofleriaceae bacterium] | diamond | 246 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28730986 | 28730986 | PRJNA950981_P_NODE_6367_length_389_cov_0.987342_g6191_i0 | PRJNA950981 | 6367 | 389 | 0.987342 | 3.84076038 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 47 | 0.00552 | NR | MBL0212867.1 | 2026763 | g6191 | i0 | 44.4 | 0.416452442159383 | 54 | 28 | 41.6 | 1 | 370 | 209 | 373 | 424 | MBL0212867.1 tyrosine--tRNA ligase [Myxococcales bacterium] | diamond | 162 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28926927 | 28926927 | PRJNA950981_P_NODE_17468_length_251_cov_0.876404_g17292_i0 | PRJNA950981 | 17468 | 251 | 0.876404 | 2.19977404 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79 | 2.22e-16 | NR | UCD85006.1 | 2026735 | g17292 | i0 | 47 | 10.7689243027888 | 83 | 44 | 99.2 | 0 | 250 | 2 | 34 | 116 | UCD85006.1 MAG: Hsp20/alpha crystallin family protein [Deltaproteobacteria bacterium] | diamond | 2703 | 79 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28952188 | 28952188 | PRJNA950981_P_NODE_10208_length_318_cov_1.587755_g10032_i0 | PRJNA950981 | 10208 | 318 | 1.587755 | 5.0490609 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 94.4 | 6.91e-20 | NR | MFO0651061.1 | 3034171 | g10032 | i0 | 48 | 1.86792452830189 | 100 | 52 | 94.3 | 0 | 302 | 3 | 298 | 397 | MFO0651061.1 hypothetical protein [Polyangiales bacterium] | diamond | 594 | 94.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 29109934 | 29109934 | PRJNA950981_P_NODE_5548_length_414_cov_1.372434_g5372_i0 | PRJNA950981 | 5548 | 414 | 1.372434 | 5.68187676 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 139 | 4.069999999999999e-35 | NR | MDO9017237.1 | 2026763 | g5372 | i0 | 51.4 | 1.94202898550725 | 138 | 66 | 99.3 | 1 | 4 | 414 | 283 | 420 | MDO9017237.1 hypothetical protein [Myxococcales bacterium] | diamond | 804 | 139 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29173152 | 29173152 | PRJNA950981_P_NODE_11089_length_307_cov_1.299145_g10913_i0 | PRJNA950981 | 11089 | 307 | 1.299145 | 3.98837515 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 80.9 | 2.16e-15 | NR | RYE89468.1 | 2026763 | g10913 | i0 | 53.6 | 1.71986970684039 | 84 | 38 | 82.1 | 1 | 257 | 6 | 9 | 91 | RYE89468.1 MAG: hypothetical protein EOO75_11760, partial [Myxococcales bacterium] | diamond | 528 | 80.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29173154 | 29173154 | PRJNA950981_P_NODE_17449_length_251_cov_0.876404_g17273_i0 | PRJNA950981 | 17449 | 251 | 0.876404 | 2.19977404 | Bradymonadia bacterium | 3121696 | Bacteria | Bacteria | 77.4 | 1.07e-15 | NR | MFT6398796.1 | 3121696 | g17273 | i0 | 52.9 | 4.87649402390438 | 70 | 32 | 83.7 | 1 | 31 | 240 | 3 | 71 | MFT6398796.1 putative membrane protein YedE/YeeE [Bradymonadia bacterium] | diamond | 1224 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Bradymonadia | Bradymonadia bacterium | |||||
| 29236232 | 29236232 | PRJNA950981_P_NODE_20229_length_245_cov_0.906977_g20053_i0 | PRJNA950981 | 20229 | 245 | 0.906977 | 2.22209365 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 46.6 | 0.00173 | NR | HKP64827.1 | 3034171 | g20053 | i0 | 48 | 1.22448979591837 | 50 | 25 | 61.2 | 1 | 49 | 198 | 1132 | 1180 | HKP64827.1 clostripain-related cysteine peptidase [Polyangiales bacterium] | diamond | 300 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 29369033 | 29369033 | PRJNA950981_P_NODE_16269_length_254_cov_2.077348_g16093_i0 | PRJNA950981 | 16269 | 254 | 2.077348 | 5.27646392 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.0121 | NR | PZR09590.1 | 48 | g16093 | i0 | 39.1 | 3.72047244094488 | 64 | 34 | 74.4 | 3 | 41 | 229 | 21 | 80 | PZR09590.1 MAG: hypothetical protein DI536_21865 [Archangium gephyra] | diamond | 945 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 31289336 | 31289336 | PRJNA950981_P_NODE_17815_length_250_cov_0.881356_g17639_i0 | PRJNA950981 | 17815 | 250 | 0.881356 | 2.20339 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 43.1 | 0.0284 | NR | MCH8891761.1 | 2026763 | g17639 | i0 | 33.3 | 2.016 | 84 | 53 | 97.2 | 2 | 6 | 248 | 122 | 205 | MCH8891761.1 heme lyase CcmF/NrfE family subunit [Myxococcales bacterium] | diamond | 504 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31447635 | 31447635 | PRJNA950981_P_NODE_10716_length_312_cov_1.179916_g10540_i0 | PRJNA950981 | 10716 | 312 | 1.179916 | 3.68133792 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 55.1 | 3.55e-6 | NR | MEO0814787.1 | 2818507 | g10540 | i0 | 38.9 | 1.625 | 72 | 44 | 69.2 | 0 | 3 | 218 | 292 | 363 | MEO0814787.1 ubiquitin-like protein [Myxococcota bacterium] | diamond | 507 | 55.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31763920 | 31763920 | PRJNA950981_P_NODE_18457_length_249_cov_0.886364_g18281_i0 | PRJNA950981 | 18457 | 249 | 0.886364 | 2.20704636 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 47 | 0.00129 | NR | MBP7125131.1 | 2818507 | g18281 | i0 | 52.3 | 0.530120481927711 | 44 | 16 | 47 | 1 | 69 | 185 | 998 | 1041 | MBP7125131.1 S8 family serine peptidase [Myxococcota bacterium] | diamond | 132 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32270329 | 32270329 | PRJNA950981_P_NODE_16558_length_253_cov_0.866667_g16382_i0 | PRJNA950981 | 16558 | 253 | 0.866667 | 2.19266751 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 85.1 | 5.07e-17 | NR | MCB9727208.1 | 2026735 | g16382 | i0 | 59.6 | 0.675889328063241 | 57 | 21 | 65.2 | 1 | 251 | 87 | 912 | 968 | MCB9727208.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 171 | 85.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32460113 | 32460113 | PRJNA950981_P_NODE_11259_length_305_cov_1.344828_g11083_i0 | PRJNA950981 | 11259 | 305 | 1.344828 | 4.1017254 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 63.5 | 1.23e-9 | NR | MCA9634375.1 | 2026763 | g11083 | i0 | 59.6 | 1.12131147540984 | 47 | 19 | 46.2 | 0 | 164 | 304 | 75 | 121 | MCA9634375.1 hypothetical protein [Myxococcales bacterium] | diamond | 342 | 63.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32555230 | 32555230 | PRJNA950981_P_NODE_16239_length_255_cov_0.923077_g16063_i0 | PRJNA950981 | 16239 | 255 | 0.923077 | 2.35384635 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 80.5 | 2.13e-15 | NR | RJR45769.1 | 2026735 | g16063 | i0 | 52.9 | 4.02352941176471 | 68 | 31 | 80 | 1 | 51 | 254 | 376 | 442 | RJR45769.1 MAG: NAD(FAD)-dependent dehydrogenase [Deltaproteobacteria bacterium] | diamond | 1026 | 80.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32555233 | 32555233 | PRJNA950981_P_NODE_21079_length_243_cov_0.917647_g20903_i0 | PRJNA950981 | 21079 | 243 | 0.917647 | 2.22988221 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 80.9 | 1.44e-15 | NR | MBI3294266.1 | 2026735 | g20903 | i0 | 53.2 | 0.975308641975309 | 79 | 36 | 97.5 | 1 | 237 | 1 | 71 | 148 | MBI3294266.1 response regulator [Deltaproteobacteria bacterium] | diamond | 237 | 80.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;