contig_metadata
19 rows where bioproject = "PRJNA896973", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873234 | 873234 | PRJNA896973_P_NODE_23101_length_249_cov_0.875000_g23007_i0 | PRJNA896973 | 23101 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 146 | 2.98e-42 | NR | MBI3754747.1 | 2026735 | g23007 | i0 | 77.1 | 15.0722891566265 | 83 | 19 | 100 | 0 | 1 | 249 | 9 | 91 | MBI3754747.1 DNA adenine methylase [Deltaproteobacteria bacterium] | diamond | 3753 | 146 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 3795944 | 3795944 | PRJNA896973_P_NODE_26323_length_244_cov_0.865497_g26229_i0 | PRJNA896973 | 26323 | 244 | 0.865497 | 2.11181268 | Sorangium | 39643 | Bacteria | Bacteria | 106 | 1.67e-18 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g26229 | i0 | 85.859 | 13.0409836065574 | 99 | 14 | 41 | 0 | 1 | 99 | 2637937 | 2638035 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 3182 | 106 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 3795959 | 3795959 | PRJNA896973_P_NODE_29183_length_208_cov_4.844444_g29089_i0 | PRJNA896973 | 29183 | 208 | 4.844444 | 10.07644352 | Polyangiaceae | 49 | Bacteria | Bacteria | 224 | 3.65e-54 | NTclustered | gi|908353314|gb|CP012159.1| | 52 | g29089 | i0 | 86.256 | 35.9423076923077 | 211 | 23 | 99 | 5 | 3 | 208 | 1431182 | 1430973 | Chondromyces crocatus strain Cm c5, complete genome | blastn | 7476 | 224 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 5976449 | 5976449 | PRJNA896973_P_NODE_19825_length_260_cov_4.657754_g19731_i0 | PRJNA896973 | 19825 | 260 | 4.657754 | 12.1101604 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 453 | 5.5600000000000005e-123 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g19731 | i0 | 98.077 | 149.503846153846 | 260 | 5 | 100 | 0 | 1 | 260 | 3942556 | 3942815 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 38871 | 453 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 11076828 | 11076828 | PRJNA896973_P_NODE_27449_length_242_cov_0.911243_g27355_i0 | PRJNA896973 | 27449 | 242 | 0.911243 | 2.20520806 | Myxococcia | 32015 | Bacteria | Bacteria | 95.1 | 1.28e-20 | NR | HTQ44979.1 | 2268199 | g27355 | i0 | 64.9 | 1.98347107438017 | 77 | 25 | 95.5 | 2 | 10 | 240 | 366 | 440 | HTQ44979.1 glycosyltransferase family 39 protein [Polyangiaceae bacterium] | diamond | 480 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 19999916 | 19999916 | PRJNA896973_P_NODE_28276_length_241_cov_0.898810_g28182_i0 | PRJNA896973 | 28276 | 241 | 0.89881 | 2.1661321 | Anaeromyxobacter paludicola | 2918171 | Bacteria | Bacteria | 241 | 4.310000000000001e-59 | NTclustered | gi|2199271117|dbj|AP025592.1| | 2918171 | g28182 | i0 | 84.774 | 253.800829875519 | 243 | 33 | 100 | 4 | 1 | 241 | 1383976 | 1384216 | Anaeromyxobacter paludicola DNA, complete genome | blastn | 61166 | 241 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter paludicola | ||
| 22550049 | 22550049 | PRJNA896973_P_NODE_22198_length_250_cov_1.305085_g22104_i0 | PRJNA896973 | 22198 | 250 | 1.305085 | 3.2627125 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 209 | 1.27e-49 | NTclustered | gi|2258824976|gb|CP060221.1| | 2026763 | g22104 | i0 | 84.375 | 96.124 | 224 | 24 | 88 | 10 | 32 | 250 | 1312681 | 1312464 | MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome | blastn | 24031 | 209 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26612385 | 26612385 | PRJNA896973_P_NODE_23381_length_248_cov_1.622857_g23287_i0 | PRJNA896973 | 23381 | 248 | 1.622857 | 4.02468536 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 119 | 1.6599999999999998e-31 | NR | HEX4355194.1 | 3034171 | g23287 | i0 | 76.5 | 2.93951612903226 | 81 | 19 | 98 | 0 | 1 | 243 | 74 | 154 | HEX4355194.1 dTMP kinase [Polyangiales bacterium] | diamond | 729 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 27150093 | 27150093 | PRJNA896973_P_NODE_27942_length_241_cov_0.916667_g27848_i0 | PRJNA896973 | 27942 | 241 | 0.916667 | 2.20916747 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 128 | 2.38e-32 | NR | HKP59477.1 | 3034171 | g27848 | i0 | 75 | 0.995850622406639 | 80 | 20 | 99.6 | 0 | 2 | 241 | 324 | 403 | HKP59477.1 lipase maturation factor family protein [Polyangiales bacterium] | diamond | 240 | 128 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 28097933 | 28097933 | PRJNA896973_P_NODE_25845_length_244_cov_1.502924_g25751_i0 | PRJNA896973 | 25845 | 244 | 1.502924 | 3.66713456 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 43.1 | 0.0269 | NR | MFO0610084.1 | 3034171 | g25751 | i0 | 38.4 | 0.897540983606557 | 73 | 42 | 89.8 | 1 | 21 | 239 | 432 | 501 | MFO0610084.1 hypothetical protein [Polyangiales bacterium] | diamond | 219 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 28508514 | 28508514 | PRJNA896973_S_NODE_1007_length_368_cov_2.257627_g993_i0 | PRJNA896973 | 1007 | 368 | 2.257627 | 8.30806736 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 66.2 | 1.23e-10 | NR | MCA9590635.1 | 2026763 | g993 | i0 | 44.4 | 0.733695652173913 | 90 | 46 | 73.4 | 1 | 324 | 55 | 18 | 103 | MCA9590635.1 hypothetical protein [Myxococcales bacterium] | diamond | 270 | 66.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28760946 | 28760946 | PRJNA896973_P_NODE_25387_length_245_cov_0.895349_g25293_i0 | PRJNA896973 | 25387 | 245 | 0.895349 | 2.19360505 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 95.5 | 1.02e-20 | NR | HVW26207.1 | 2268199 | g25293 | i0 | 61 | 1.95918367346939 | 82 | 30 | 99.2 | 2 | 1 | 243 | 126 | 206 | HVW26207.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 480 | 95.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29076960 | 29076960 | PRJNA896973_P_NODE_27528_length_242_cov_0.911243_g27434_i0 | PRJNA896973 | 27528 | 242 | 0.911243 | 2.20520806 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 93.2 | 1.52e-22 | NR | HEX4515231.1 | 2268199 | g27434 | i0 | 61.5 | 1.93388429752066 | 78 | 29 | 95.5 | 1 | 12 | 242 | 23 | 100 | HEX4515231.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 468 | 93.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29802926 | 29802926 | PRJNA896973_P_NODE_16831_length_279_cov_1.126214_g16737_i0 | PRJNA896973 | 16831 | 279 | 1.126214 | 3.14213706 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 90.1 | 1.36e-19 | NR | MCC6646400.1 | 2268199 | g16737 | i0 | 76.3 | 2.60215053763441 | 59 | 14 | 63.4 | 0 | 102 | 278 | 5 | 63 | MCC6646400.1 phospholipase [Polyangiaceae bacterium] | diamond | 726 | 90.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30719129 | 30719129 | PRJNA896973_S_NODE_654_length_455_cov_3.112565_g640_i0 | PRJNA896973 | 654 | 455 | 3.112565 | 14.16217075 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 67 | 1.1e-9 | NR | MBI4705874.1 | 2026735 | g640 | i0 | 52.3 | 0.428571428571429 | 65 | 30 | 42.2 | 1 | 230 | 39 | 16 | 80 | MBI4705874.1 polymer-forming cytoskeletal protein [Deltaproteobacteria bacterium] | diamond | 195 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30940563 | 30940563 | PRJNA896973_P_NODE_24214_length_247_cov_0.885057_g24120_i0 | PRJNA896973 | 24214 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 111 | 1.5600000000000002e-26 | NR | MBP1690301.1 | 2026735 | g24120 | i0 | 76.1 | 2.61133603238866 | 71 | 17 | 86.2 | 0 | 31 | 243 | 1 | 71 | MBP1690301.1 amidase, Asp-tRNAAsn/Glu-tRNAGln amidotransferase subunit [Deltaproteobacteria bacterium] | diamond | 645 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31003652 | 31003652 | PRJNA896973_P_NODE_28054_length_241_cov_0.916667_g27960_i0 | PRJNA896973 | 28054 | 241 | 0.916667 | 2.20916747 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 134 | 3.7e-35 | NR | HET6334771.1 | 3034171 | g27960 | i0 | 76.3 | 3.98340248962656 | 80 | 19 | 99.6 | 0 | 2 | 241 | 213 | 292 | HET6334771.1 PQQ-binding-like beta-propeller repeat protein [Polyangiales bacterium] | diamond | 960 | 134 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 31730717 | 31730717 | PRJNA896973_P_NODE_20977_length_254_cov_1.701657_g20883_i0 | PRJNA896973 | 20977 | 254 | 1.701657 | 4.32220878 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 152 | 7.74e-45 | NR | MBS2013417.1 | 2026735 | g20883 | i0 | 96.4 | 0.992125984251969 | 84 | 3 | 99.2 | 0 | 3 | 254 | 103 | 186 | MBS2013417.1 sigma-70 family RNA polymerase sigma factor [Deltaproteobacteria bacterium] | diamond | 252 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32300701 | 32300701 | PRJNA896973_S_NODE_1779_length_293_cov_0.918182_g1765_i0 | PRJNA896973 | 1779 | 293 | 0.918182 | 2.69027326 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 90.9 | 8.08e-19 | NR | HEY8143702.1 | 2212474 | g1765 | i0 | 44.9 | 2.00682593856655 | 98 | 51 | 97.3 | 1 | 9 | 293 | 217 | 314 | HEY8143702.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 588 | 90.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae 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);;