contig_metadata
16 rows where bioproject = "PRJNA1186363", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10523412 | 10523412 | PRJNA1186363_P_NODE_23569_length_379_cov_1.261438_g22681_i0 | PRJNA1186363 | 23569 | 379 | 1.261438 | 4.78085002 | Polyangium sp. | 3409587 | Bacteria | Bacteria | 226 | 1.2999999999999999e-73 | NR | HMY20693.1 | 57 | g22681 | i0 | 86.4 | 4.94722955145119 | 125 | 17 | 98.9 | 0 | 4 | 378 | 1 | 125 | HMY20693.1 peptidylprolyl isomerase [Polyangium sp.] | diamond | 1875 | 226 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 11245292 | 11245292 | PRJNA1186363_P_NODE_4009_length_1045_cov_1.597737_g3437_i0 | PRJNA1186363 | 4009 | 1045 | 1.597737 | 16.69635165 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 404 | 1.4699999999999996e-137 | NR | MBS1256101.1 | 2026735 | g3437 | i0 | 57.1 | 2.83349282296651 | 329 | 140 | 94.4 | 1 | 54 | 1040 | 1 | 328 | MBS1256101.1 Adenine deaminase [Deltaproteobacteria bacterium] | diamond | 2961 | 404 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 21996372 | 21996372 | PRJNA1186363_P_NODE_17258_length_467_cov_0.868020_g16371_i0 | PRJNA1186363 | 17258 | 467 | 0.86802 | 4.0536534 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 647 | 0 | NTclustered | gi|1243034522|gb|CP022098.1| | 43 | g16371 | i0 | 92.308 | 278.235546038544 | 455 | 35 | 97 | 0 | 13 | 467 | 389384 | 388930 | Cystobacter fuscus strain DSM 52655 chromosome, complete genome | blastn | 129936 | 647 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 27008873 | 27008873 | PRJNA1186363_P_NODE_22462_length_392_cov_0.902821_g21574_i0 | PRJNA1186363 | 22462 | 392 | 0.902821 | 3.53905832 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 49.3 | 9.81e-4 | NR | WP_394838112.1 | 2741070 | g21574 | i0 | 43.6 | 0.420918367346939 | 55 | 31 | 42.1 | 0 | 214 | 50 | 769 | 823 | WP_394838112.1 protein kinase domain-containing protein [Pendulispora rubella] | diamond | 165 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 27040741 | 27040741 | PRJNA1186363_P_NODE_40122_length_250_cov_0.881356_g39234_i0 | PRJNA1186363 | 40122 | 250 | 0.881356 | 2.20339 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 50.1 | 1.06e-4 | NR | HEY1553870.1 | 2212474 | g39234 | i0 | 69.2 | 1.824 | 39 | 11 | 46.8 | 1 | 234 | 118 | 395 | 432 | HEY1553870.1 S53 family peptidase [Kofleriaceae bacterium] | diamond | 456 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27312866 | 27312866 | PRJNA1186363_P_NODE_28323_length_331_cov_1.511628_g27435_i0 | PRJNA1186363 | 28323 | 331 | 1.511628 | 5.00348868 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.0102 | NR | WP_095989961.1 | 43 | g27435 | i0 | 34 | 3.87009063444109 | 106 | 62 | 93.4 | 4 | 14 | 322 | 94 | 194 | WP_095989961.1 hypothetical protein [Cystobacter fuscus] | diamond | 1281 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 28556749 | 28556749 | PRJNA1186363_P_NODE_18527_length_446_cov_1.045576_g17639_i0 | PRJNA1186363 | 18527 | 446 | 1.045576 | 4.66326896 | Archangium gephyra | 48 | Bacteria | Bacteria | 62.4 | 4.84e-8 | NR | WP_053066116.1 | 48 | g17639 | i0 | 63.3 | 0.659192825112108 | 49 | 18 | 33 | 0 | 15 | 161 | 827 | 875 | WP_053066116.1 kelch repeat-containing protein [Archangium gephyra] | diamond | 294 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 30451726 | 30451726 | PRJNA1186363_P_NODE_8153_length_737_cov_1.879518_g7322_i0 | PRJNA1186363 | 8153 | 737 | 1.879518 | 13.85204766 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 291 | 1.8899999999999997e-93 | NR | MBP9205654.1 | 2212474 | g7322 | i0 | 61.3 | 2.9674355495251 | 243 | 87 | 98.5 | 3 | 736 | 11 | 99 | 335 | MBP9205654.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 2187 | 291 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30798836 | 30798836 | PRJNA1186363_P_NODE_16814_length_475_cov_0.970149_g15927_i0 | PRJNA1186363 | 16814 | 475 | 0.970149 | 4.60820775 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 87 | 1.61e-16 | NR | MBL8685173.1 | 2026763 | g15927 | i0 | 52.8 | 1.55368421052632 | 89 | 36 | 52.4 | 1 | 225 | 473 | 754 | 842 | MBL8685173.1 hypothetical protein [Myxococcales bacterium] | diamond | 738 | 87 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31273040 | 31273040 | PRJNA1186363_P_NODE_3475_length_1110_cov_5.571842_g2963_i0 | PRJNA1186363 | 3475 | 1110 | 5.571842 | 61.8474462 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 72.8 | 1.02e-9 | NR | NMB77427.1 | 2026763 | g2963 | i0 | 31.2 | 1.71621621621622 | 218 | 90 | 49.2 | 10 | 70 | 615 | 337 | 530 | NMB77427.1 hypothetical protein [Myxococcales bacterium] | diamond | 1905 | 72.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31652360 | 31652360 | PRJNA1186363_P_NODE_29157_length_324_cov_0.932271_g28269_i0 | PRJNA1186363 | 29157 | 324 | 0.932271 | 3.02055804 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 49.3 | 2.78e-4 | NR | MEQ8279463.1 | 2026735 | g28269 | i0 | 33.3 | 1.5 | 81 | 49 | 74.1 | 2 | 319 | 80 | 56 | 132 | MEQ8279463.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 486 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31715801 | 31715801 | PRJNA1186363_P_NODE_29637_length_320_cov_0.821862_g28749_i0 | PRJNA1186363 | 29637 | 320 | 0.821862 | 2.6299584 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 133 | 4.889999999999998e-35 | NR | TFH26984.1 | 2026763 | g28749 | i0 | 63.3 | 1.875 | 109 | 35 | 97.5 | 3 | 2 | 313 | 45 | 153 | TFH26984.1 MAG: aldehyde reductase [Myxococcales bacterium] | diamond | 600 | 133 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32222057 | 32222057 | PRJNA1186363_P_NODE_36058_length_269_cov_1.193878_g35170_i0 | PRJNA1186363 | 36058 | 269 | 1.193878 | 3.21153182 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 48.5 | 4.31e-4 | NR | MBL8957818.1 | 2484252 | g35170 | i0 | 66.7 | 0.33457249070632 | 30 | 10 | 33.5 | 0 | 1 | 90 | 280 | 309 | MBL8957818.1 isopenicillin N synthase family oxygenase [Myxococcaceae bacterium] | diamond | 90 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32285656 | 32285656 | PRJNA1186363_P_NODE_39399_length_251_cov_0.876404_g38511_i0 | PRJNA1186363 | 39399 | 251 | 0.876404 | 2.19977404 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 72.4 | 1.38e-12 | NR | MEZ4405128.1 | 3034171 | g38511 | i0 | 42.7 | 1.9601593625498 | 82 | 46 | 96.8 | 1 | 245 | 3 | 242 | 323 | MEZ4405128.1 MopE-related protein [Polyangiales bacterium] | diamond | 492 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 32651765 | 32651765 | PRJNA1186363_P_NODE_42900_length_244_cov_0.912281_g42012_i0 | PRJNA1186363 | 42900 | 244 | 0.912281 | 2.22596564 | Bacteria | 2 | Bacteria | Bacteria | 43.1 | 0.0279 | NR | MEZ4267003.1 | 2818507 | g42012 | i0 | 51.6 | 0.811475409836066 | 31 | 15 | 38.1 | 0 | 152 | 244 | 42 | 72 | MEZ4267003.1 serine/threonine-protein kinase [Myxococcota bacterium] | diamond | 198 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32903815 | 32903815 | PRJNA1186363_P_NODE_43660_length_242_cov_0.923077_g42772_i0 | PRJNA1186363 | 43660 | 242 | 0.923077 | 2.23384634 | Bacteria | 2 | Bacteria | Bacteria | 86.7 | 1.29e-17 | NR | MBK6533801.1 | 2026735 | g42772 | i0 | 55 | 3.96694214876033 | 80 | 35 | 99.2 | 1 | 1 | 240 | 393 | 471 | MBK6533801.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 960 | 86.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;