contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1719143 | 1719143 | PRJNA473201_P_NODE_67362_length_250_cov_1.740113_g66620_i0 | PRJNA473201 | 67362 | 250 | 1.740113 | 4.3502825 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 136 | 8.360000000000001e-36 | NR | MEB2310901.1 | 2268199 | g66620 | i0 | 76.8 | 3.876 | 82 | 19 | 98.4 | 0 | 246 | 1 | 108 | 189 | MEB2310901.1 adenosylhomocysteinase [Polyangiaceae bacterium] | diamond | 969 | 136 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 14473224 | 14473224 | PRJNA473201_P_NODE_80712_length_243_cov_0.905882_g79970_i0 | PRJNA473201 | 80712 | 243 | 0.905882 | 2.20129326 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 135 | 2.85e-38 | NR | HEX7666565.1 | 2268199 | g79970 | i0 | 80 | 1.97530864197531 | 80 | 16 | 98.8 | 0 | 242 | 3 | 73 | 152 | HEX7666565.1 amidohydrolase family protein [Polyangiaceae bacterium] | diamond | 480 | 135 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 26886526 | 26886526 | PRJNA473201_P_NODE_71641_length_248_cov_0.880000_g70899_i0 | PRJNA473201 | 71641 | 248 | 0.88 | 2.1824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 57.4 | 2.58e-7 | NR | MCC6527321.1 | 2268199 | g70899 | i0 | 51.8 | 1.34274193548387 | 56 | 27 | 67.7 | 0 | 247 | 80 | 315 | 370 | MCC6527321.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 333 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28592157 | 28592157 | PRJNA473201_P_NODE_64567_length_254_cov_1.403315_g63825_i0 | PRJNA473201 | 64567 | 254 | 1.403315 | 3.5644201 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 54.7 | 2.73e-6 | NR | MEW5847593.1 | 2818507 | g63825 | i0 | 41 | 0.921259842519685 | 78 | 40 | 92.1 | 3 | 5 | 238 | 755 | 826 | MEW5847593.1 hypothetical protein [Myxococcota bacterium] | diamond | 234 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29034351 | 29034351 | PRJNA473201_P_NODE_83728_length_242_cov_0.911243_g82986_i0 | PRJNA473201 | 83728 | 242 | 0.911243 | 2.20520806 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 57 | 3.41e-7 | NR | HEY8076659.1 | 1971228 | g82986 | i0 | 42 | 1.00413223140496 | 81 | 38 | 89.3 | 3 | 240 | 25 | 185 | 265 | HEY8076659.1 hypothetical protein [Labilithrix sp.] | diamond | 243 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29113520 | 29113520 | PRJNA473201_P_NODE_79688_length_244_cov_0.900585_g78946_i0 | PRJNA473201 | 79688 | 244 | 0.900585 | 2.1974274 | Myxococcus | 32 | Bacteria | Bacteria | 58.2 | 5.86e-8 | NR | WP_234072210.1 | 83455 | g78946 | i0 | 41.4 | 2.97540983606557 | 87 | 39 | 99.6 | 4 | 2 | 244 | 70 | 150 | WP_234072210.1 protease [Myxococcus stipitatus] | diamond | 726 | 58.5 | 0.994871794871795 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 31008642 | 31008642 | PRJNA473201_P_NODE_74474_length_247_cov_0.885057_g73732_i0 | PRJNA473201 | 74474 | 247 | 0.885057 | 2.18609079 | Minicystis | 1649470 | Bacteria | Bacteria | 106 | 1.25e-24 | NR | MFT3771950.1 | 1971901 | g73732 | i0 | 63.4 | 14.9392712550607 | 82 | 29 | 99.6 | 1 | 247 | 2 | 243 | 323 | MFT3771950.1 tetratricopeptide repeat protein [Minicystis sp.] | diamond | 3690 | 107 | 0.990654205607477 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis sp. | |||
| 31893982 | 31893982 | PRJNA473201_P_NODE_73417_length_247_cov_0.885057_g72675_i0 | PRJNA473201 | 73417 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.0141 | NR | TMA41047.1 | 2026735 | g72675 | i0 | 37.5 | 3.80161943319838 | 56 | 34 | 68 | 1 | 245 | 78 | 128 | 182 | TMA41047.1 MAG: alpha/beta hydrolase [Deltaproteobacteria bacterium] | diamond | 939 | 44.3 | 0.99097065462754 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31909490 | 31909490 | PRJNA473201_P_NODE_59337_length_268_cov_1.246154_g58595_i0 | PRJNA473201 | 59337 | 268 | 1.246154 | 3.33969272 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 42.4 | 0.0496 | NR | MEZ4401898.1 | 2212474 | g58595 | i0 | 42 | 0.559701492537313 | 50 | 29 | 56 | 0 | 106 | 255 | 37 | 86 | MEZ4401898.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 150 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32447619 | 32447619 | PRJNA473201_P_NODE_74099_length_247_cov_0.885057_g73357_i0 | PRJNA473201 | 74099 | 247 | 0.885057 | 2.18609079 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 65.1 | 4.96e-10 | NR | MCS6912558.1 | 2818507 | g73357 | i0 | 46.4 | 1.59109311740891 | 69 | 36 | 83.8 | 1 | 33 | 239 | 263 | 330 | MCS6912558.1 amidase [Myxococcota bacterium] | diamond | 393 | 65.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32636633 | 32636633 | PRJNA473201_P_NODE_81620_length_243_cov_0.905882_g80878_i0 | PRJNA473201 | 81620 | 243 | 0.905882 | 2.20129326 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 47.8 | 6.32e-4 | NR | MDB5216023.1 | 2484252 | g80878 | i0 | 41.1 | 0.901234567901235 | 73 | 35 | 88.9 | 3 | 239 | 24 | 673 | 738 | MDB5216023.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 219 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32762791 | 32762791 | PRJNA473201_P_NODE_74940_length_246_cov_1.462428_g74198_i0 | PRJNA473201 | 74940 | 246 | 1.462428 | 3.59757288 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 60.8 | 1.58e-8 | NR | MEQ1503773.1 | 2818507 | g74198 | i0 | 52.7 | 4.02439024390244 | 55 | 23 | 63.4 | 1 | 1 | 156 | 365 | 419 | MEQ1503773.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Myxococcota bacterium] | diamond | 990 | 60.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32888620 | 32888620 | PRJNA473201_P_NODE_78840_length_244_cov_0.900585_g78098_i0 | PRJNA473201 | 78840 | 244 | 0.900585 | 2.1974274 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 45.4 | 0.00438 | NR | MFT7582533.1 | 2818507 | g78098 | i0 | 42.3 | 1.2172131147541 | 52 | 27 | 60.2 | 1 | 237 | 91 | 34 | 85 | MFT7582533.1 hypothetical protein [Myxococcota bacterium] | diamond | 297 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota 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);;