contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA902515" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7259336 | 7259336 | PRJNA902515_P_NODE_15066_length_244_cov_0.912281_g15043_i0 | PRJNA902515 | 15066 | 244 | 0.912281 | 2.22596564 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 159 | 1.04e-45 | NR | MBK8997310.1 | 2026763 | g15043 | i0 | 98.8 | 0.983606557377049 | 80 | 1 | 98.4 | 0 | 3 | 242 | 114 | 193 | MBK8997310.1 ketoacyl-ACP synthase III [Myxococcales bacterium] | diamond | 240 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 13634850 | 13634850 | PRJNA902515_P_NODE_11091_length_253_cov_0.866667_g11068_i0 | PRJNA902515 | 11091 | 253 | 0.866667 | 2.19266751 | Archangium | 47 | Bacteria | Bacteria | 129 | 6.38e-33 | NR | HEY1088277.1 | 1872627 | g11068 | i0 | 77.4 | 4.9802371541502 | 84 | 19 | 99.6 | 0 | 252 | 1 | 105 | 188 | HEY1088277.1 long-chain fatty acid--CoA ligase [Archangium sp.] | diamond | 1260 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 18732620 | 18732620 | PRJNA902515_P_NODE_12455_length_250_cov_0.881356_g12432_i0 | PRJNA902515 | 12455 | 250 | 0.881356 | 2.20339 | Archangium sp. | 1872627 | Bacteria | Bacteria | 144 | 5.879999999999999e-38 | NR | HEY1088374.1 | 1872627 | g12432 | i0 | 83.1 | 1.992 | 83 | 14 | 99.6 | 0 | 1 | 249 | 280 | 362 | HEY1088374.1 polyribonucleotide nucleotidyltransferase [Archangium sp.] | diamond | 498 | 144 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 22558066 | 22558066 | PRJNA902515_P_NODE_12358_length_250_cov_0.881356_g12335_i0 | PRJNA902515 | 12358 | 250 | 0.881356 | 2.20339 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 157 | 1.52e-42 | NR | MBE7482697.1 | 2268199 | g12335 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 249 | 1 | 719 | 801 | MBE7482697.1 glycosyltransferase family 39 protein [Polyangiaceae bacterium] | diamond | 249 | 157 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28635156 | 28635156 | PRJNA902515_P_NODE_7907_length_292_cov_1.415525_g7884_i0 | PRJNA902515 | 7907 | 292 | 1.415525 | 4.133333 | Archangium sp. | 1872627 | Bacteria | Bacteria | 198 | 2.5e-60 | NR | HEY1088621.1 | 1872627 | g7884 | i0 | 90.7 | 1.99315068493151 | 97 | 9 | 99.7 | 0 | 2 | 292 | 126 | 222 | HEY1088621.1 VOC family protein [Archangium sp.] | diamond | 582 | 198 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28982421 | 28982421 | PRJNA902515_P_NODE_12408_length_250_cov_0.881356_g12385_i0 | PRJNA902515 | 12408 | 250 | 0.881356 | 2.20339 | Sorangiineae bacterium PRO1 | 2293716 | Bacteria | Bacteria | 166 | 7.85e-50 | NR | MCE7893686.1 | 2293716 | g12385 | i0 | 100 | 1.992 | 83 | 0 | 99.6 | 0 | 2 | 250 | 109 | 191 | MCE7893686.1 hypothetical protein [Sorangiineae bacterium PRO1] | diamond | 498 | 166 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Sorangiineae bacterium PRO1 | ||||
| 31454026 | 31454026 | PRJNA902515_P_NODE_14836_length_245_cov_0.906977_g14813_i0 | PRJNA902515 | 14836 | 245 | 0.906977 | 2.22209365 | Myxococcia | 32015 | Bacteria | Bacteria | 119 | 3.3800000000000003e-29 | NR | MBK8994214.1 | 2026763 | g14813 | i0 | 100 | 1.39591836734694 | 57 | 0 | 69.8 | 0 | 245 | 75 | 547 | 603 | MBK8994214.1 hypothetical protein [Myxococcales bacterium] | diamond | 342 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32054861 | 32054861 | PRJNA902515_P_NODE_10938_length_254_cov_1.353591_g10915_i0 | PRJNA902515 | 10938 | 254 | 1.353591 | 3.43812114 | Myxococcia | 32015 | Bacteria | Bacteria | 163 | 7.7e-45 | NR | MBE7483573.1 | 2268199 | g10915 | i0 | 98.8 | 1.98425196850394 | 84 | 1 | 99.2 | 0 | 254 | 3 | 513 | 596 | MBE7483573.1 protein kinase [Polyangiaceae bacterium] | diamond | 504 | 163 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32268997 | 32268997 | PRJNA902515_P_NODE_13338_length_248_cov_0.891429_g13315_i0 | PRJNA902515 | 13338 | 248 | 0.891429 | 2.21074392 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 62.8 | 3.35e-9 | NR | HEX6271431.1 | 2268199 | g13315 | i0 | 40 | 0.967741935483871 | 80 | 41 | 96.8 | 1 | 247 | 8 | 370 | 442 | HEX6271431.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 240 | 62.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32679328 | 32679328 | PRJNA902515_P_NODE_15960_length_242_cov_0.923077_g15937_i0 | PRJNA902515 | 15960 | 242 | 0.923077 | 2.23384634 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 74.3 | 2.68e-13 | NR | MBX3227896.1 | 1971228 | g15937 | i0 | 51.8 | 1.02892561983471 | 83 | 36 | 99.2 | 2 | 241 | 2 | 38 | 119 | MBX3227896.1 mechanosensitive ion channel family protein [Labilithrix sp.] | diamond | 249 | 74.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32805491 | 32805491 | PRJNA902515_P_NODE_13720_length_247_cov_0.896552_g13697_i0 | PRJNA902515 | 13720 | 247 | 0.896552 | 2.21448344 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 115 | 2.2e-29 | NR | MSP25349.1 | 2026763 | g13697 | i0 | 67.9 | 0.983805668016194 | 81 | 26 | 98.4 | 0 | 245 | 3 | 74 | 154 | MSP25349.1 hypothetical protein [Myxococcales bacterium] | diamond | 243 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;