contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA358009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1673000 | 1673000 | PRJNA358009_P_NODE_4402_length_327_cov_2.147482_g4339_i0 | PRJNA358009 | 4402 | 327 | 2.147482 | 7.02226614 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 106 | 3.689999999999999e-24 | NR | MBI2378747.1 | 2026735 | g4339 | i0 | 54 | 2.07339449541284 | 113 | 47 | 99.1 | 1 | 3 | 326 | 525 | 637 | MBI2378747.1 GcvT family protein [Deltaproteobacteria bacterium] | diamond | 678 | 106 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 20799783 | 20799783 | PRJNA358009_P_NODE_2757_length_327_cov_3.287770_g2694_i0 | PRJNA358009 | 2757 | 327 | 3.28777 | 10.7510079 | Myxococcia | 32015 | Bacteria | Bacteria | 92 | 1.59e-19 | NR | MBK7584397.1 | 2026763 | g2694 | i0 | 50.9 | 3.96330275229358 | 108 | 16 | 99.1 | 1 | 3 | 326 | 59 | 129 | MBK7584397.1 aldo/keto reductase [Myxococcales bacterium] | diamond | 1296 | 92 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26599733 | 26599733 | PRJNA358009_P_NODE_14801_length_164_cov_0.886957_g14732_i0 | PRJNA358009 | 14801 | 164 | 0.886957 | 1.45460948 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 76.3 | 1.69e-14 | NR | HVJ14070.1 | 2268199 | g14732 | i0 | 68.6 | 0.932926829268293 | 51 | 16 | 93.3 | 0 | 3 | 155 | 253 | 303 | HVJ14070.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 153 | 76.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27074828 | 27074828 | PRJNA358009_P_NODE_5882_length_327_cov_1.611511_g5819_i0 | PRJNA358009 | 5882 | 327 | 1.611511 | 5.26964097 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 64.7 | 1.34e-9 | NR | HET7541141.1 | 2268199 | g5819 | i0 | 36.7 | 1 | 109 | 28 | 98.2 | 2 | 322 | 2 | 80 | 149 | HET7541141.1 LysR family transcriptional regulator [Polyangiaceae bacterium] | diamond | 327 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27675339 | 27675339 | PRJNA358009_P_NODE_6044_length_327_cov_1.561151_g5981_i0 | PRJNA358009 | 6044 | 327 | 1.561151 | 5.10496377 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 70.9 | 1.28e-11 | NR | MFO0667773.1 | 2268199 | g5981 | i0 | 38.3 | 2.10091743119266 | 115 | 64 | 99.1 | 1 | 3 | 326 | 114 | 228 | MFO0667773.1 serine/threonine-protein kinase [Polyangiaceae bacterium] | diamond | 687 | 70.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28022556 | 28022556 | PRJNA358009_P_NODE_3785_length_327_cov_2.438849_g3722_i0 | PRJNA358009 | 3785 | 327 | 2.438849 | 7.97503623 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 59.3 | 2e-8 | NR | MEO6574730.1 | 2268199 | g3722 | i0 | 87.1 | 0.568807339449541 | 31 | 4 | 28.4 | 0 | 100 | 8 | 8 | 38 | MEO6574730.1 VOC family protein [Polyangiaceae bacterium] | diamond | 186 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28401301 | 28401301 | PRJNA358009_P_NODE_4386_length_327_cov_2.151079_g4323_i0 | PRJNA358009 | 4386 | 327 | 2.151079 | 7.03402833 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 70.5 | 1.81e-11 | NR | MBK6463064.1 | 2026763 | g4323 | i0 | 48.9 | 0.862385321100917 | 94 | 8 | 86.2 | 1 | 8 | 289 | 709 | 762 | MBK6463064.1 polyphosphate kinase 1 [Myxococcales bacterium] | diamond | 282 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28559340 | 28559340 | PRJNA358009_P_NODE_10607_length_179_cov_1.569231_g10538_i0 | PRJNA358009 | 10607 | 179 | 1.569231 | 2.80892349 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 53.9 | 1.03e-6 | NR | HEY2511347.1 | 2268199 | g10538 | i0 | 48.3 | 1.74301675977654 | 58 | 27 | 92.2 | 1 | 4 | 168 | 108 | 165 | HEY2511347.1 DNA-3-methyladenine glycosylase [Polyangiaceae bacterium] | diamond | 312 | 53.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28607857 | 28607857 | PRJNA358009_P_NODE_15067_length_163_cov_1.789474_g14998_i0 | PRJNA358009 | 15067 | 163 | 1.789474 | 2.91684262 | Bacteria | 2 | Bacteria | Bacteria | 83.6 | 3.95e-18 | NR | MBS2011573.1 | 2026735 | g14998 | i0 | 76.1 | 2.5398773006135 | 46 | 10 | 84.7 | 1 | 156 | 19 | 164 | 208 | MBS2011573.1 cytochrome c3 family protein [Deltaproteobacteria bacterium] | diamond | 414 | 83.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29096044 | 29096044 | PRJNA358009_P_NODE_8188_length_205_cov_3.884615_g8119_i0 | PRJNA358009 | 8188 | 205 | 3.884615 | 7.96346075 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 85.1 | 2.61e-17 | NR | HSO31238.1 | 1971228 | g8119 | i0 | 64.4 | 1.72682926829268 | 59 | 21 | 86.3 | 0 | 182 | 6 | 726 | 784 | HSO31238.1 protein kinase [Labilithrix sp.] | diamond | 354 | 85.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29176381 | 29176381 | PRJNA358009_P_NODE_16549_length_160_cov_6.486486_g16480_i0 | PRJNA358009 | 16549 | 160 | 6.486486 | 10.3783776 | Bacteria | 2 | Bacteria | Bacteria | 84.3 | 2.54e-17 | NR | HEX4447968.1 | 2268199 | g16480 | i0 | 75.5 | 7.40625 | 49 | 12 | 91.9 | 0 | 9 | 155 | 704 | 752 | HEX4447968.1 TIGR03960 family B12-binding radical SAM protein [Polyangiaceae bacterium] | diamond | 1185 | 84.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29460048 | 29460048 | PRJNA358009_P_NODE_15590_length_162_cov_1.805310_g15521_i0 | PRJNA358009 | 15590 | 162 | 1.80531 | 2.9246022 | Bacteria | 2 | Bacteria | Bacteria | 106 | 5.17e-25 | NR | MBI5538329.1 | 2026735 | g15521 | i0 | 92.2 | 8.5 | 51 | 4 | 94.4 | 0 | 160 | 8 | 574 | 624 | MBI5538329.1 beta-propeller domain-containing protein [Deltaproteobacteria bacterium] | diamond | 1377 | 106 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29569446 | 29569446 | PRJNA358009_P_NODE_14490_length_164_cov_1.773913_g14421_i0 | PRJNA358009 | 14490 | 164 | 1.773913 | 2.90921732 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 61.6 | 2.54e-9 | NR | WP_053231028.1 | 927083 | g14421 | i0 | 59.6 | 0.951219512195122 | 52 | 21 | 95.1 | 0 | 2 | 157 | 196 | 247 | WP_053231028.1 hypothetical protein [Sandaracinus amylolyticus] | diamond | 156 | 61.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 29712573 | 29712573 | PRJNA358009_P_NODE_13350_length_166_cov_4.136752_g13281_i0 | PRJNA358009 | 13350 | 166 | 4.136752 | 6.86700832 | Polyangiales | 3031712 | Bacteria | Bacteria | 90.5 | 3.4900000000000005e-21 | NR | MBX3191450.1 | 1971228 | g13281 | i0 | 88.5 | 11.2951807228916 | 52 | 6 | 94 | 0 | 164 | 9 | 25 | 76 | MBX3191450.1 pyruvate dehydrogenase (acetyl-transferring) E1 component subunit alpha [Labilithrix sp.] | diamond | 1875 | 90.9 | 0.995599559955996 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29948531 | 29948531 | PRJNA358009_P_NODE_5831_length_327_cov_1.625899_g5768_i0 | PRJNA358009 | 5831 | 327 | 1.625899 | 5.31668973 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 55.8 | 5.32e-7 | NR | HRE89373.1 | 2818507 | g5768 | i0 | 77.4 | 0.284403669724771 | 31 | 7 | 28.4 | 0 | 228 | 320 | 31 | 61 | HRE89373.1 DUF2442 domain-containing protein [Myxococcota bacterium] | diamond | 93 | 55.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30264736 | 30264736 | PRJNA358009_P_NODE_4012_length_327_cov_2.316547_g3949_i0 | PRJNA358009 | 4012 | 327 | 2.316547 | 7.57510869 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 86.3 | 4.13e-17 | NR | MCA9583872.1 | 2026763 | g3949 | i0 | 40.8 | 1.14678899082569 | 125 | 56 | 98.2 | 1 | 326 | 6 | 197 | 321 | MCA9583872.1 FHA domain-containing protein [Myxococcales bacterium] | diamond | 375 | 86.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30611840 | 30611840 | PRJNA358009_P_NODE_14773_length_164_cov_0.886957_g14704_i0 | PRJNA358009 | 14773 | 164 | 0.886957 | 1.45460948 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 80.9 | 4.37e-16 | NR | HSO35561.1 | 1971228 | g14704 | i0 | 74.1 | 1.90243902439024 | 54 | 14 | 98.8 | 0 | 164 | 3 | 357 | 410 | HSO35561.1 AgmX/PglI C-terminal domain-containing protein [Labilithrix sp.] | diamond | 312 | 80.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31654935 | 31654935 | PRJNA358009_P_NODE_9857_length_183_cov_4.664179_g9788_i0 | PRJNA358009 | 9857 | 183 | 4.664179 | 8.53544757 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 103 | 2.0199999999999998e-24 | NR | HTA89467.1 | 2268199 | g9788 | i0 | 74.6 | 0.967213114754098 | 59 | 15 | 96.7 | 0 | 6 | 182 | 163 | 221 | HTA89467.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 177 | 103 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31781460 | 31781460 | PRJNA358009_P_NODE_10257_length_181_cov_2.053030_g10188_i0 | PRJNA358009 | 10257 | 181 | 2.05303 | 3.7159843 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 109 | 3.55e-26 | NR | MEO8874357.1 | 2268199 | g10188 | i0 | 86 | 1.88950276243094 | 57 | 8 | 94.5 | 0 | 179 | 9 | 428 | 484 | MEO8874357.1 penicillin-binding transpeptidase domain-containing protein [Polyangiaceae bacterium] | diamond | 342 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32288184 | 32288184 | PRJNA358009_P_NODE_5879_length_327_cov_1.611511_g5816_i0 | PRJNA358009 | 5879 | 327 | 1.611511 | 5.26964097 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 56.6 | 1.23e-6 | NR | MBX3231279.1 | 1971228 | g5816 | i0 | 34 | 0.972477064220184 | 106 | 47 | 97.2 | 1 | 325 | 8 | 180 | 262 | MBX3231279.1 hypothetical protein [Labilithrix sp.] | diamond | 318 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32761481 | 32761481 | PRJNA358009_P_NODE_11640_length_173_cov_2.443548_g11571_i0 | PRJNA358009 | 11640 | 173 | 2.443548 | 4.22733804 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 62.8 | 1.17e-9 | NR | MBX3189752.1 | 1971228 | g11571 | i0 | 56.4 | 3.8150289017341 | 55 | 24 | 95.4 | 0 | 2 | 166 | 90 | 144 | MBX3189752.1 ArsA family ATPase [Labilithrix sp.] | diamond | 660 | 62.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix 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);;