contig_metadata
7 rows where bioproject = "PRJNA685060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26702170 | 26702170 | PRJNA685060_P_NODE_10641_length_288_cov_1.525581_g10551_i0 | PRJNA685060 | 10641 | 288 | 1.525581 | 4.39367328 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 44.3 | 0.0175 | NR | MEM1032830.1 | 2818507 | g10551 | i0 | 37.9 | 0.604166666666667 | 58 | 27 | 60.4 | 1 | 13 | 186 | 45 | 93 | MEM1032830.1 hypothetical protein [Myxococcota bacterium] | diamond | 174 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27493067 | 27493067 | PRJNA685060_P_NODE_7623_length_345_cov_1.180147_g7533_i0 | PRJNA685060 | 7623 | 345 | 1.180147 | 4.07150715 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 168 | 6.579999999999999e-48 | NR | MDP2345811.1 | 2026735 | g7533 | i0 | 74.1 | 0.973913043478261 | 112 | 29 | 97.4 | 0 | 9 | 344 | 161 | 272 | MDP2345811.1 SPFH domain-containing protein [Deltaproteobacteria bacterium] | diamond | 336 | 168 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28503369 | 28503369 | PRJNA685060_P_NODE_10887_length_285_cov_1.221698_g10797_i0 | PRJNA685060 | 10887 | 285 | 1.221698 | 3.4818393 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 80.1 | 3.93e-15 | NR | NUP13379.1 | 2268199 | g10797 | i0 | 49.4 | 0.852631578947368 | 81 | 40 | 84.2 | 1 | 264 | 25 | 118 | 198 | NUP13379.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 243 | 80.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29103411 | 29103411 | PRJNA685060_P_NODE_12048_length_268_cov_1.579487_g11958_i0 | PRJNA685060 | 12048 | 268 | 1.579487 | 4.23302516 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 53.9 | 5.08e-6 | NR | MBW2119348.1 | 2026735 | g11958 | i0 | 35.6 | 1.90298507462687 | 87 | 54 | 97.4 | 1 | 263 | 3 | 2 | 86 | MBW2119348.1 AMP-binding protein [Deltaproteobacteria bacterium] | diamond | 510 | 53.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31958714 | 31958714 | PRJNA685060_P_NODE_8357_length_329_cov_1.089844_g8267_i0 | PRJNA685060 | 8357 | 329 | 1.089844 | 3.58558676 | Myxococcales | 29 | Bacteria | Bacteria | 89 | 6.38e-18 | NR | WP_407743218.1 | 2028555 | g8267 | i0 | 40.7 | 3.93920972644377 | 108 | 64 | 98.5 | 0 | 327 | 4 | 1246 | 1353 | WP_407743218.1 MG2 domain-containing protein [Hyalangium sp.] | diamond | 1296 | 89.7 | 0.992196209587514 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium sp. | ||
| 32705747 | 32705747 | PRJNA685060_P_NODE_5440_length_412_cov_1.035398_g5350_i0 | PRJNA685060 | 5440 | 412 | 1.035398 | 4.26583976 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 57.4 | 1.79e-6 | NR | MBW1811625.1 | 2026735 | g5350 | i0 | 56.8 | 0.269417475728155 | 37 | 16 | 26.9 | 0 | 409 | 299 | 206 | 242 | MBW1811625.1 calcium-binding EGF-like domain-containing protein [Deltaproteobacteria bacterium] | diamond | 111 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32843246 | 32843246 | PRJNA685060_P_NODE_8620_length_324_cov_0.900398_g8530_i0 | PRJNA685060 | 8620 | 324 | 0.900398 | 2.91728952 | Myxococcia | 32015 | Bacteria | Bacteria | 70.1 | 5.37e-12 | NR | MBE2253089.1 | 1929279 | g8530 | i0 | 45.8 | 2.36111111111111 | 83 | 41 | 76.9 | 1 | 75 | 323 | 4 | 82 | MBE2253089.1 NAD(P)H-binding protein [Myxococcus sp.] | diamond | 765 | 70.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. |
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);;