contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23730091 | 23730091 | PRJNA792582_P_NODE_56859_length_244_cov_0.900585_g56045_i0 | PRJNA792582 | 56859 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 4.75e-7 | NR | WP_012236970.1 | 56 | g56045 | i0 | 43.8 | 6.70081967213115 | 73 | 41 | 89.8 | 0 | 225 | 7 | 97 | 169 | WP_012236970.1 serine/threonine protein kinase [Sorangium cellulosum] | diamond | 1635 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 26927207 | 26927207 | PRJNA792582_P_NODE_40182_length_277_cov_1.588235_g39368_i0 | PRJNA792582 | 40182 | 277 | 1.588235 | 4.39941095 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 48.5 | 5.45e-5 | NR | MEC8422185.1 | 2818507 | g39368 | i0 | 40.2 | 0.888086642599278 | 82 | 49 | 88.8 | 0 | 26 | 271 | 4 | 85 | MEC8422185.1 hypothetical protein [Myxococcota bacterium] | diamond | 246 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27496228 | 27496228 | PRJNA792582_P_NODE_50423_length_250_cov_1.740113_g49609_i0 | PRJNA792582 | 50423 | 250 | 1.740113 | 4.3502825 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 50.1 | 7.66e-6 | NR | KYF55844.1 | 56 | g49609 | i0 | 52.4 | 0.504 | 42 | 17 | 46.8 | 1 | 2 | 118 | 32 | 73 | KYF55844.1 hypothetical protein BE08_04980 [Sorangium cellulosum] | diamond | 126 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 27780465 | 27780465 | PRJNA792582_P_NODE_51684_length_249_cov_0.875000_g50870_i0 | PRJNA792582 | 51684 | 249 | 0.875 | 2.17875 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 62.4 | 4.67e-9 | NR | HWL88207.1 | 2268199 | g50870 | i0 | 50.9 | 1.26506024096386 | 55 | 27 | 66.3 | 0 | 83 | 247 | 60 | 114 | HWL88207.1 thiamine pyrophosphate-binding protein [Polyangiaceae bacterium] | diamond | 315 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28885298 | 28885298 | PRJNA792582_P_NODE_22428_length_364_cov_1.202749_g21614_i0 | PRJNA792582 | 22428 | 364 | 1.202749 | 4.37800636 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 69.7 | 6.78e-12 | NR | MRR56327.1 | 2026735 | g21614 | i0 | 69.8 | 1.1043956043956 | 43 | 13 | 35.4 | 0 | 355 | 227 | 138 | 180 | MRR56327.1 peptidoglycan-associated lipoprotein Pal [Deltaproteobacteria bacterium] | diamond | 402 | 69.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29043450 | 29043450 | PRJNA792582_P_NODE_43248_length_269_cov_1.397959_g42434_i0 | PRJNA792582 | 43248 | 269 | 1.397959 | 3.76050971 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 44.3 | 0.0153 | NR | MCA9522042.1 | 2026763 | g42434 | i0 | 34.5 | 1.6728624535316 | 84 | 41 | 87 | 3 | 257 | 24 | 879 | 954 | MCA9522042.1 tetratricopeptide repeat protein [Myxococcales bacterium] | diamond | 450 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29769388 | 29769388 | PRJNA792582_P_NODE_47391_length_257_cov_1.869565_g46577_i0 | PRJNA792582 | 47391 | 257 | 1.869565 | 4.80478205 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.5 | 0.0227 | NR | HEX2870986.1 | 2268199 | g46577 | i0 | 38.5 | 0.75875486381323 | 65 | 34 | 68.9 | 2 | 187 | 11 | 158 | 222 | HEX2870986.1 c-type cytochrome [Polyangiaceae bacterium] | diamond | 195 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30653962 | 30653962 | PRJNA792582_P_NODE_61033_length_210_cov_4.058394_g60219_i0 | PRJNA792582 | 61033 | 210 | 4.058394 | 8.5226274 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 43.1 | 0.0172 | NR | MEO7732607.1 | 2212474 | g60219 | i0 | 45.5 | 0.628571428571429 | 44 | 17 | 62.9 | 2 | 142 | 11 | 338 | 374 | MEO7732607.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 132 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31096333 | 31096333 | PRJNA792582_P_NODE_44895_length_264_cov_2.246073_g44081_i0 | PRJNA792582 | 44895 | 264 | 2.246073 | 5.92963272 | Cystobacter sp. | 1965334 | Bacteria | Bacteria | 42 | 0.0426 | NR | MET0405238.1 | 1965334 | g44081 | i0 | 35.8 | 0.761363636363636 | 67 | 43 | 76.1 | 0 | 52 | 252 | 9 | 75 | MET0405238.1 hypothetical protein [Cystobacter sp.] | diamond | 201 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter sp. | ||
| 31285958 | 31285958 | PRJNA792582_P_NODE_35915_length_288_cov_2.330233_g35101_i0 | PRJNA792582 | 35915 | 288 | 2.330233 | 6.71107104 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.9 | 0.0242 | NR | MEB2310536.1 | 2268199 | g35101 | i0 | 63.9 | 0.375 | 36 | 10 | 36.5 | 2 | 254 | 150 | 187 | 220 | MEB2310536.1 apolipoprotein N-acyltransferase [Polyangiaceae bacterium] | diamond | 108 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31918700 | 31918700 | PRJNA792582_P_NODE_36217_length_288_cov_0.990698_g35403_i0 | PRJNA792582 | 36217 | 288 | 0.990698 | 2.85321024 | Archangium sp. | 1872627 | Bacteria | Bacteria | 44.3 | 0.0167 | NR | WP_414641468.1 | 1872627 | g35403 | i0 | 34.8 | 0.927083333333333 | 89 | 36 | 90.6 | 4 | 272 | 12 | 36 | 104 | WP_414641468.1 RCC1 domain-containing protein, partial [Archangium sp.] | diamond | 267 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 32140244 | 32140244 | PRJNA792582_P_NODE_54518_length_246_cov_0.890173_g53704_i0 | PRJNA792582 | 54518 | 246 | 0.890173 | 2.18982558 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 99 | 4.21e-22 | NR | MCA1826806.1 | 2026763 | g53704 | i0 | 57.3 | 5 | 82 | 35 | 100 | 0 | 1 | 246 | 225 | 306 | MCA1826806.1 2-oxo acid dehydrogenase subunit E2 [Myxococcales bacterium] | diamond | 1230 | 99 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32803412 | 32803412 | PRJNA792582_P_NODE_60620_length_229_cov_2.833333_g59806_i0 | PRJNA792582 | 60620 | 229 | 2.833333 | 6.48833257 | Paraliomyxa miuraensis | 376150 | Bacteria | Bacteria | 125 | 9.74e-34 | NR | WP_266221121.1 | 376150 | g59806 | i0 | 84.2 | 0.995633187772926 | 76 | 12 | 99.6 | 0 | 229 | 2 | 143 | 218 | WP_266221121.1 queuosine precursor transporter [Paraliomyxa miuraensis] | diamond | 228 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Paraliomyxa | Paraliomyxa miuraensis |
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);;