contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5434878 | 5434878 | PRJNA1215774_P_NODE_84405_length_241_cov_0.916667_g84085_i0 | PRJNA1215774 | 84405 | 241 | 0.916667 | 2.20916747 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 149 | 8.41e-44 | NR | MEZ0312878.1 | 2818507 | g84085 | i0 | 93.8 | 0.995850622406639 | 80 | 5 | 99.6 | 0 | 1 | 240 | 81 | 160 | MEZ0312878.1 hypoxanthine phosphoribosyltransferase [Myxococcota bacterium] | diamond | 240 | 149 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 26660874 | 26660874 | PRJNA1215774_P_NODE_53421_length_288_cov_1.372093_g53101_i0 | PRJNA1215774 | 53421 | 288 | 1.372093 | 3.95162784 | Archangium sp. | 1872627 | Bacteria | Bacteria | 71.2 | 6.01e-12 | NR | MBL8915066.1 | 1872627 | g53101 | i0 | 88.6 | 0.364583333333333 | 35 | 4 | 36.5 | 0 | 1 | 105 | 443 | 477 | MBL8915066.1 poly(A) polymerase [Archangium sp.] | diamond | 105 | 71.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 26660876 | 26660876 | PRJNA1215774_P_NODE_72261_length_249_cov_0.875000_g71941_i0 | PRJNA1215774 | 72261 | 249 | 0.875 | 2.17875 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 157 | 1.54e-42 | NR | MBL8684601.1 | 2026763 | g71941 | i0 | 90.4 | 1 | 83 | 8 | 100 | 0 | 1 | 249 | 833 | 915 | MBL8684601.1 hypothetical protein [Myxococcales bacterium] | diamond | 249 | 157 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27167348 | 27167348 | PRJNA1215774_P_NODE_65722_length_257_cov_1.358696_g65402_i0 | PRJNA1215774 | 65722 | 257 | 1.358696 | 3.49184872 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 130 | 6.41e-35 | NR | HET7502329.1 | 2212474 | g65402 | i0 | 80 | 3.96887159533074 | 85 | 17 | 99.2 | 0 | 256 | 2 | 175 | 259 | HET7502329.1 LysR family transcriptional regulator [Kofleriaceae bacterium] | diamond | 1020 | 130 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27830754 | 27830754 | PRJNA1215774_P_NODE_62364_length_265_cov_1.557292_g62044_i0 | PRJNA1215774 | 62364 | 265 | 1.557292 | 4.1268238 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 44.3 | 0.0141 | NR | HET8733811.1 | 2510643 | g62044 | i0 | 52.9 | 0.984905660377358 | 51 | 21 | 56.6 | 2 | 159 | 10 | 6 | 54 | HET8733811.1 hypothetical protein [Anaeromyxobacteraceae bacterium] | diamond | 261 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 28493959 | 28493959 | PRJNA1215774_P_NODE_73967_length_248_cov_0.880000_g73647_i0 | PRJNA1215774 | 73967 | 248 | 0.88 | 2.1824 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 100 | 1.37e-22 | NR | MFO0625250.1 | 3034171 | g73647 | i0 | 74.1 | 0.979838709677419 | 81 | 18 | 98 | 3 | 244 | 2 | 4 | 81 | MFO0625250.1 hypothetical protein [Polyangiales bacterium] | diamond | 243 | 100 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 29377947 | 29377947 | PRJNA1215774_P_NODE_80129_length_244_cov_0.900585_g79809_i0 | PRJNA1215774 | 80129 | 244 | 0.900585 | 2.1974274 | Archangium sp. | 1872627 | Bacteria | Bacteria | 115 | 1.49e-28 | NR | MBL8913544.1 | 1872627 | g79809 | i0 | 70.9 | 0.971311475409836 | 79 | 23 | 97.1 | 0 | 7 | 243 | 144 | 222 | MBL8913544.1 choice-of-anchor D domain-containing protein [Archangium sp.] | diamond | 237 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 29788228 | 29788228 | PRJNA1215774_P_NODE_76291_length_246_cov_0.890173_g75971_i0 | PRJNA1215774 | 76291 | 246 | 0.890173 | 2.18982558 | Archangium sp. | 1872627 | Bacteria | Bacteria | 147 | 3.91e-39 | NR | MBL8916053.1 | 1872627 | g75971 | i0 | 92.6 | 0.98780487804878 | 81 | 6 | 98.8 | 0 | 245 | 3 | 80 | 160 | MBL8916053.1 FtsX-like permease family protein [Archangium sp.] | diamond | 243 | 147 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 30452072 | 30452072 | PRJNA1215774_P_NODE_73213_length_248_cov_0.880000_g72893_i0 | PRJNA1215774 | 73213 | 248 | 0.88 | 2.1824 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 46.6 | 4.89e-4 | NR | MBC7793731.1 | 2026735 | g72893 | i0 | 61.5 | 0.471774193548387 | 39 | 15 | 47.2 | 0 | 2 | 118 | 77 | 115 | MBC7793731.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 117 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30596896 | 30596896 | PRJNA1215774_P_NODE_73353_length_248_cov_0.880000_g73033_i0 | PRJNA1215774 | 73353 | 248 | 0.88 | 2.1824 | Myxococcia | 32015 | Bacteria | Bacteria | 77.4 | 2.51e-14 | NR | MBL9020065.1 | 2026763 | g73033 | i0 | 50 | 8.72177419354839 | 80 | 40 | 96.8 | 0 | 243 | 4 | 590 | 669 | MBL9020065.1 FecR domain-containing protein [Myxococcales bacterium] | diamond | 2163 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30799249 | 30799249 | PRJNA1215774_P_NODE_83294_length_242_cov_0.911243_g82974_i0 | PRJNA1215774 | 83294 | 242 | 0.911243 | 2.20520806 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 162 | 6.74e-47 | NR | MBL8680229.1 | 2026763 | g82974 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 2 | 241 | 46 | 125 | MBL8680229.1 flippase-like domain-containing protein [Myxococcales bacterium] | diamond | 240 | 162 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31209627 | 31209627 | PRJNA1215774_P_NODE_72355_length_249_cov_0.875000_g72035_i0 | PRJNA1215774 | 72355 | 249 | 0.875 | 2.17875 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 68.9 | 2.36e-11 | NR | MCA9581090.1 | 2026763 | g72035 | i0 | 48.8 | 0.987951807228916 | 82 | 40 | 96.4 | 2 | 249 | 10 | 249 | 330 | MCA9581090.1 hypothetical protein [Myxococcales bacterium] | diamond | 246 | 68.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31431497 | 31431497 | PRJNA1215774_P_NODE_71416_length_249_cov_0.875000_g71096_i0 | PRJNA1215774 | 71416 | 249 | 0.875 | 2.17875 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 101 | 7.74e-23 | NR | MDQ3034256.1 | 2818507 | g71096 | i0 | 62.8 | 0.939759036144578 | 78 | 25 | 94 | 1 | 16 | 249 | 276 | 349 | MDQ3034256.1 DUF4388 domain-containing protein [Myxococcota bacterium] | diamond | 234 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31589856 | 31589856 | PRJNA1215774_P_NODE_79196_length_244_cov_0.900585_g78876_i0 | PRJNA1215774 | 79196 | 244 | 0.900585 | 2.1974274 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 62.4 | 4.35e-9 | NR | MEZ4329816.1 | 3034171 | g78876 | i0 | 38.9 | 1.10655737704918 | 90 | 46 | 99.6 | 2 | 2 | 244 | 312 | 401 | MEZ4329816.1 FHA domain-containing protein [Polyangiales bacterium] | diamond | 270 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales 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);;