contig_metadata
15 rows where bioproject = "PRJNA416866", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26648854 | 26648854 | PRJNA416866_P_NODE_4421_length_313_cov_1.523810_g4278_i0 | PRJNA416866 | 4421 | 313 | 1.52381 | 4.7695253 | Haliangium | 162027 | Bacteria | Bacteria | 105 | 1.07e-25 | NR | HEX7837634.1 | 2212474 | g4278 | i0 | 53.5 | 1.88817891373802 | 99 | 33 | 86.3 | 2 | 271 | 2 | 56 | 150 | HEX7837634.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 591 | 105 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27724402 | 27724402 | PRJNA416866_P_NODE_7224_length_241_cov_1.355556_g7080_i0 | PRJNA416866 | 7224 | 241 | 1.355556 | 3.26688996 | Myxococcia | 32015 | Bacteria | Bacteria | 47.8 | 6.06e-4 | NR | MBI4951596.1 | 2026763 | g7080 | i0 | 55.3 | 1.96680497925311 | 47 | 18 | 56 | 2 | 209 | 75 | 544 | 589 | MBI4951596.1 DUF11 domain-containing protein [Myxococcales bacterium] | diamond | 474 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28560037 | 28560037 | PRJNA416866_P_NODE_8247_length_225_cov_0.981707_g8103_i0 | PRJNA416866 | 8247 | 225 | 0.981707 | 2.20884075 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 43.5 | 0.00823 | NR | HTR52097.1 | 2212474 | g8103 | i0 | 61.3 | 0.413333333333333 | 31 | 12 | 41.3 | 0 | 103 | 11 | 39 | 69 | HTR52097.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 93 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28812183 | 28812183 | PRJNA416866_P_NODE_848_length_799_cov_1.623306_g721_i0 | PRJNA416866 | 848 | 799 | 1.623306 | 12.97021494 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 57 | 3.87e-5 | NR | MBK6461975.1 | 2026763 | g721 | i0 | 31.6 | 1.61827284105131 | 171 | 77 | 60.5 | 8 | 240 | 722 | 614 | 754 | MBK6461975.1 DUF11 domain-containing protein [Myxococcales bacterium] | diamond | 1293 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28906979 | 28906979 | PRJNA416866_P_NODE_6108_length_264_cov_0.935961_g5964_i0 | PRJNA416866 | 6108 | 264 | 0.935961 | 2.47093704 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 44.3 | 0.0137 | NR | HET8936208.1 | 3034171 | g5964 | i0 | 50 | 0.613636363636364 | 54 | 25 | 61.4 | 1 | 263 | 102 | 198 | 249 | HET8936208.1 phenylalanine--tRNA ligase subunit beta [Polyangiales bacterium] | diamond | 162 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 29380811 | 29380811 | PRJNA416866_P_NODE_10149_length_207_cov_0.876712_g10005_i0 | PRJNA416866 | 10149 | 207 | 0.876712 | 1.81479384 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 110 | 7.13e-29 | NR | MCL4235509.1 | 2026735 | g10005 | i0 | 75.8 | 1.91304347826087 | 66 | 16 | 95.7 | 0 | 207 | 10 | 86 | 151 | MCL4235509.1 fatty acid desaturase [Deltaproteobacteria bacterium] | diamond | 396 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29633020 | 29633020 | PRJNA416866_P_NODE_970_length_735_cov_1.743323_g835_i0 | PRJNA416866 | 970 | 735 | 1.743323 | 12.81342405 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 55.5 | 8.5e-5 | NR | MBK7064594.1 | 2026735 | g835 | i0 | 37.2 | 1.01224489795918 | 113 | 44 | 41.6 | 7 | 18 | 323 | 15 | 111 | MBK7064594.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 744 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29980825 | 29980825 | PRJNA416866_P_NODE_10531_length_205_cov_1.722222_g10387_i0 | PRJNA416866 | 10531 | 205 | 1.722222 | 3.5305551 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 47.8 | 3.17e-4 | NR | HEX7499693.1 | 3058050 | g10387 | i0 | 45.8 | 0.702439024390244 | 48 | 23 | 65.9 | 1 | 180 | 46 | 183 | 230 | HEX7499693.1 hypothetical protein [Polyangia bacterium] | diamond | 144 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 30201726 | 30201726 | PRJNA416866_P_NODE_6412_length_257_cov_1.306122_g6268_i0 | PRJNA416866 | 6412 | 257 | 1.306122 | 3.35673354 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 42.7 | 0.0433 | NR | HEY0484351.1 | 2212474 | g6268 | i0 | 42.1 | 0.665369649805447 | 57 | 33 | 66.5 | 0 | 38 | 208 | 34 | 90 | HEY0484351.1 cyclic nucleotide-binding domain-containing protein [Kofleriaceae bacterium] | diamond | 171 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30675740 | 30675740 | PRJNA416866_P_NODE_10473_length_206_cov_0.882759_g10329_i0 | PRJNA416866 | 10473 | 206 | 0.882759 | 1.81848354 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42 | 0.0435 | NR | MDI7268090.1 | 2818507 | g10329 | i0 | 42.6 | 0.786407766990291 | 54 | 27 | 72.8 | 2 | 39 | 188 | 415 | 468 | MDI7268090.1 putative metal-binding motif-containing protein [Myxococcota bacterium] | diamond | 162 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30739018 | 30739018 | PRJNA416866_P_NODE_2194_length_463_cov_2.049751_g2051_i0 | PRJNA416866 | 2194 | 463 | 2.049751 | 9.49034713 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 48.5 | 0.00344 | NR | MFO0667317.1 | 2268199 | g2051 | i0 | 31 | 1.10799136069114 | 171 | 92 | 98.5 | 7 | 2 | 457 | 556 | 719 | MFO0667317.1 dickkopf-related protein [Polyangiaceae bacterium] | diamond | 513 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31624161 | 31624161 | PRJNA416866_P_NODE_8096_length_227_cov_1.542169_g7952_i0 | PRJNA416866 | 8096 | 227 | 1.542169 | 3.50072363 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 79.7 | 1.62e-15 | NR | HEY3816582.1 | 2268199 | g7952 | i0 | 64.9 | 4.62555066079295 | 57 | 20 | 75.3 | 0 | 227 | 57 | 281 | 337 | HEY3816582.1 class 1 fructose-bisphosphatase [Polyangiaceae bacterium] | diamond | 1050 | 79.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32257296 | 32257296 | PRJNA416866_P_NODE_5018_length_292_cov_1.939394_g4874_i0 | PRJNA416866 | 5018 | 292 | 1.939394 | 5.66303048 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 94.7 | 1.87e-20 | NR | HVJ19388.1 | 2268199 | g4874 | i0 | 44.2 | 1.06849315068493 | 104 | 51 | 99.7 | 2 | 291 | 1 | 80 | 183 | HVJ19388.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 312 | 94.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32288975 | 32288975 | PRJNA416866_P_NODE_9639_length_209_cov_0.864865_g9495_i0 | PRJNA416866 | 9639 | 209 | 0.864865 | 1.80756785 | Sandaracinaceae bacterium LLY-WYZ-13_1 | 3034333 | Bacteria | Bacteria | 46.6 | 0.00104 | NR | HJL20389.1 | 3034333 | g9495 | i0 | 47.9 | 0.688995215311005 | 48 | 18 | 68.9 | 1 | 16 | 159 | 244 | 284 | HJL20389.1 hypothetical protein [Sandaracinaceae bacterium LLY-WYZ-13_1] | diamond | 144 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium LLY-WYZ-13_1 | ||||
| 32778639 | 32778639 | PRJNA416866_P_NODE_3040_length_387_cov_1.180982_g2897_i0 | PRJNA416866 | 3040 | 387 | 1.180982 | 4.57040034 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.1 | 0.00214 | NR | MCA9493101.1 | 2026763 | g2897 | i0 | 33.8 | 1.25581395348837 | 77 | 48 | 59.7 | 1 | 254 | 24 | 192 | 265 | MCA9493101.1 HAMP domain-containing histidine kinase [Myxococcales bacterium] | diamond | 486 | 48.5 | 0.991752577319588 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;