contig_metadata
12 rows where bioproject = "PRJNA751877", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 726275 | 726275 | PRJNA751877_P_NODE_19681_length_267_cov_1.582474_g19559_i0 | PRJNA751877 | 19681 | 267 | 1.582474 | 4.22520558 | Corallococcus coralloides | 184914 | Bacteria | Bacteria | 470 | 5.689999999999999e-128 | NTclustered | gi|2851136330|gb|CP172866.1| | 184914 | g19559 | i0 | 100 | 0.951310861423221 | 254 | 0 | 95 | 0 | 14 | 267 | 7485639 | 7485892 | Corallococcus coralloides strain KYC2213 chromosome, complete genome | blastn | 254 | 470 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus coralloides | ||
| 5830112 | 5830112 | PRJNA751877_P_NODE_29425_length_242_cov_0.911243_g29303_i0 | PRJNA751877 | 29425 | 242 | 0.911243 | 2.20520806 | Anaeromyxobacter sp. K | 447217 | Bacteria | Bacteria | 148 | 2.6999999999999997e-31 | NTclustered | gi|196170270|gb|CP001131.1| | 447217 | g29303 | i0 | 83.03 | 3.17768595041322 | 165 | 26 | 68 | 2 | 17 | 180 | 634480 | 634317 | Anaeromyxobacter sp. K, complete genome | blastn | 769 | 148 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. K | ||
| 8853452 | 8853452 | PRJNA751877_P_NODE_6787_length_394_cov_0.890966_g6665_i0 | PRJNA751877 | 6787 | 394 | 0.890966 | 3.51040604 | Archangium | 47 | Bacteria | Bacteria | 52.8 | 0.038 | NTclustered | gi|2579687829|gb|CP043494.1| | 83450 | g6665 | i0 | 100 | 0.142131979695431 | 28 | 0 | 7 | 0 | 214 | 241 | 7254581 | 7254608 | Archangium minus strain Cbm 6 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium minus | ||
| 11404066 | 11404066 | PRJNA751877_P_NODE_26149_length_246_cov_0.890173_g26027_i0 | PRJNA751877 | 26149 | 246 | 0.890173 | 2.18982558 | Myxococcus | 32 | Bacteria | Bacteria | 455 | 1.4500000000000002e-123 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g26027 | i0 | 100 | 48.4552845528455 | 246 | 0 | 100 | 0 | 1 | 246 | 6441534 | 6441289 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 11920 | 455 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 23679430 | 23679430 | PRJNA751877_P_NODE_28319_length_243_cov_0.905882_g28197_i0 | PRJNA751877 | 28319 | 243 | 0.905882 | 2.20129326 | Myxococcus fulvus | 33 | Bacteria | Bacteria | 411 | 3.14e-110 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g28197 | i0 | 97.119 | 2.96707818930041 | 243 | 7 | 100 | 0 | 1 | 243 | 6169420 | 6169178 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 721 | 411 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 27179011 | 27179011 | PRJNA751877_P_NODE_30162_length_241_cov_0.916667_g30040_i0 | PRJNA751877 | 30162 | 241 | 0.916667 | 2.20916747 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 79.3 | 1.7e-17 | NR | MBT9554500.1 | 2026763 | g30040 | i0 | 64.6 | 1.9792531120332 | 48 | 17 | 59.8 | 0 | 239 | 96 | 6 | 53 | MBT9554500.1 hypothetical protein [Myxococcales bacterium] | diamond | 477 | 79.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28820968 | 28820968 | PRJNA751877_P_NODE_22568_length_251_cov_0.865169_g22446_i0 | PRJNA751877 | 22568 | 251 | 0.865169 | 2.17157419 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 125 | 3.8800000000000005e-33 | NR | NOU31425.1 | 2268199 | g22446 | i0 | 75 | 0.908366533864542 | 76 | 19 | 90.8 | 0 | 23 | 250 | 51 | 126 | NOU31425.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 228 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30432326 | 30432326 | PRJNA751877_P_NODE_9613_length_352_cov_0.942652_g9491_i0 | PRJNA751877 | 9613 | 352 | 0.942652 | 3.31813504 | Archangium sp. | 1872627 | Bacteria | Bacteria | 77.8 | 6.43e-14 | NR | HZI02469.1 | 1872627 | g9491 | i0 | 40 | 8.73579545454546 | 110 | 66 | 93.8 | 0 | 350 | 21 | 482 | 591 | HZI02469.1 ABC transporter ATP-binding protein [Archangium sp.] | diamond | 3075 | 77.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 30495240 | 30495240 | PRJNA751877_P_NODE_29853_length_241_cov_0.916667_g29731_i0 | PRJNA751877 | 29853 | 241 | 0.916667 | 2.20916747 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 122 | 1.04e-31 | NR | HRE91594.1 | 2818507 | g29731 | i0 | 75 | 0.995850622406639 | 80 | 20 | 99.6 | 0 | 241 | 2 | 35 | 114 | HRE91594.1 acyl-CoA desaturase [Myxococcota bacterium] | diamond | 240 | 122 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31095360 | 31095360 | PRJNA751877_P_NODE_26835_length_245_cov_1.029070_g26713_i0 | PRJNA751877 | 26835 | 245 | 1.02907 | 2.5212215 | Haliangium sp. UPWRP_2 | 1931276 | Bacteria | Bacteria | 63.5 | 1.75e-9 | NR | WP_106525676.1 | 1931276 | g26713 | i0 | 43.8 | 0.979591836734694 | 80 | 42 | 95.5 | 2 | 235 | 2 | 363 | 441 | WP_106525676.1 M12 family metallopeptidase [Haliangium sp. UPWRP_2] | diamond | 240 | 63.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. UPWRP_2 | |||
| 31390073 | 31390073 | PRJNA751877_P_NODE_20636_length_261_cov_1.537234_g20514_i0 | PRJNA751877 | 20636 | 261 | 1.537234 | 4.01218074 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 105 | 2.4399999999999997e-24 | NR | WP_043399270.1 | 83451 | g20514 | i0 | 56.1 | 19.0689655172414 | 82 | 36 | 94.3 | 0 | 3 | 248 | 310 | 391 | WP_043399270.1 dipeptidase [Archangium violaceum] | diamond | 4977 | 106 | 0.990566037735849 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 32012653 | 32012653 | PRJNA751877_P_NODE_23418_length_250_cov_0.870056_g23296_i0 | PRJNA751877 | 23418 | 250 | 0.870056 | 2.17514 | Anaeromyxobacter sp. | 1872521 | Bacteria | Bacteria | 43.1 | 0.0214 | NR | HEY6100889.1 | 1872521 | g23296 | i0 | 43.5 | 0.744 | 62 | 34 | 74.4 | 1 | 48 | 233 | 49 | 109 | HEY6100889.1 RNA 2',3'-cyclic phosphodiesterase [Anaeromyxobacter sp.] | diamond | 186 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter 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);;