contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA546018" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4337579 | 4337579 | PRJNA546018_S_NODE_10724_length_525_cov_3.437500_g10401_i0 | PRJNA546018 | 10724 | 525 | 3.4375 | 18.046875 | root | 1 | Root_unresolved | Root_unresolved | 189 | 6.25e-58 | NR | WP_002619414.1 | 41 | g10401 | i0 | 71.1 | 11.1428571428571 | 128 | 36 | 73.1 | 1 | 506 | 123 | 45 | 171 | WP_002619414.1 peptidylprolyl isomerase [Stigmatella aurantiaca] | diamond | 5850 | 190 | 0.994736842105263 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 6888470 | 6888470 | PRJNA546018_S_NODE_23446_length_330_cov_8.197026_g23121_i0 | PRJNA546018 | 23446 | 330 | 8.197026 | 27.0501858 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 55.8 | 2.39e-6 | NR | MEE8474660.1 | 2818507 | g23121 | i0 | 44 | 1.31818181818182 | 75 | 31 | 65.5 | 3 | 305 | 90 | 347 | 413 | MEE8474660.1 sulfotransferase [Myxococcota bacterium] | diamond | 435 | 55.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 8163661 | 8163661 | PRJNA546018_S_NODE_25487_length_315_cov_2.877953_g25162_i0 | PRJNA546018 | 25487 | 315 | 2.877953 | 9.06555195 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 148 | 1.45e-39 | NR | MBM4370444.1 | 2026735 | g25162 | i0 | 75 | 1.75238095238095 | 92 | 23 | 87.6 | 0 | 17 | 292 | 221 | 312 | MBM4370444.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 552 | 148 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 8164143 | 8164143 | PRJNA546018_S_NODE_53807_length_207_cov_2.479452_g53482_i0 | PRJNA546018 | 53807 | 207 | 2.479452 | 5.13246564 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99.4 | 1.2e-23 | NR | MCE9574917.1 | 2026735 | g53482 | i0 | 82 | 6.18840579710145 | 61 | 11 | 88.4 | 0 | 24 | 206 | 122 | 182 | MCE9574917.1 SDR family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 1281 | 99.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 11989702 | 11989702 | PRJNA546018_S_NODE_28970_length_292_cov_8.766234_g28645_i0 | PRJNA546018 | 28970 | 292 | 8.766234 | 25.59740328 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 176 | 1.4e-49 | NR | MBA3451750.1 | 2026735 | g28645 | i0 | 97.7 | 0.893835616438356 | 87 | 2 | 89.4 | 0 | 284 | 24 | 196 | 282 | MBA3451750.1 GAF domain-containing protein [Deltaproteobacteria bacterium] | diamond | 261 | 176 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 23463711 | 23463711 | PRJNA546018_S_NODE_6939_length_679_cov_1.852751_g6651_i0 | PRJNA546018 | 6939 | 679 | 1.852751 | 12.58017929 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 328 | 1.32e-109 | NR | MBL8682022.1 | 2026763 | g6651 | i0 | 72.7 | 3.87481590574374 | 220 | 59 | 96.8 | 1 | 678 | 22 | 112 | 331 | MBL8682022.1 pyruvate dehydrogenase complex E1 component subunit beta [Myxococcales bacterium] | diamond | 2631 | 328 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27962311 | 27962311 | PRJNA546018_S_NODE_26845_length_306_cov_2.665306_g26520_i0 | PRJNA546018 | 26845 | 306 | 2.665306 | 8.15583636 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 131 | 1.81e-33 | NR | MFO0562219.1 | 3034171 | g26520 | i0 | 74.7 | 0.852941176470588 | 87 | 21 | 85.3 | 1 | 283 | 23 | 282 | 367 | MFO0562219.1 hypothetical protein [Polyangiales bacterium] | diamond | 261 | 131 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 28229487 | 28229487 | PRJNA546018_S_NODE_11926_length_493_cov_2.159722_g11602_i0 | PRJNA546018 | 11926 | 493 | 2.159722 | 10.64742946 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.4 | 0.0116 | NR | HEY4179607.1 | 2212474 | g11602 | i0 | 42.6 | 0.967545638945233 | 54 | 31 | 32.9 | 0 | 486 | 325 | 1175 | 1228 | HEY4179607.1 alpha-2-macroglobulin family protein [Kofleriaceae bacterium] | diamond | 477 | 47.8 | 0.99163179916318 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28545734 | 28545734 | PRJNA546018_S_NODE_11807_length_495_cov_14.880184_g11483_i0 | PRJNA546018 | 11807 | 495 | 14.880184 | 73.6569108 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62 | 9.39e-8 | NR | WP_224193614.1 | 889268 | g11483 | i0 | 32.8 | 2.53939393939394 | 119 | 74 | 69.1 | 3 | 47 | 388 | 133 | 250 | WP_224193614.1 WD40 repeat domain-containing protein [Nannocystis pusilla] | diamond | 1257 | 62 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis pusilla | |||
| 28814526 | 28814526 | PRJNA546018_S_NODE_50188_length_214_cov_1.274510_g49863_i0 | PRJNA546018 | 50188 | 214 | 1.27451 | 2.7274514 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 77.4 | 7.48e-16 | NR | MBS2015896.1 | 2026735 | g49863 | i0 | 74.5 | 0.714953271028037 | 51 | 13 | 71.5 | 0 | 153 | 1 | 1 | 51 | MBS2015896.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 153 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29162361 | 29162361 | PRJNA546018_S_NODE_15789_length_416_cov_2.738028_g15464_i0 | PRJNA546018 | 15789 | 416 | 2.738028 | 11.39019648 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 120 | 3.93e-30 | NR | MBN8541789.1 | 2026735 | g15464 | i0 | 46.2 | 0.9375 | 130 | 70 | 93.8 | 0 | 17 | 406 | 87 | 216 | MBN8541789.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 390 | 120 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29730212 | 29730212 | PRJNA546018_S_NODE_29810_length_288_cov_1.444934_g29485_i0 | PRJNA546018 | 29810 | 288 | 1.444934 | 4.16140992 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 159 | 1.02e-44 | NR | HVR21206.1 | 2268199 | g29485 | i0 | 90 | 0.9375 | 90 | 9 | 93.8 | 0 | 270 | 1 | 248 | 337 | HVR21206.1 right-handed parallel beta-helix repeat-containing protein [Polyangiaceae bacterium] | diamond | 270 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30187451 | 30187451 | PRJNA546018_S_NODE_49572_length_215_cov_3.610390_g49247_i0 | PRJNA546018 | 49572 | 215 | 3.61039 | 7.7623385 | Myxococcia | 32015 | Bacteria | Bacteria | 97.1 | 4.69e-22 | NR | WP_293254146.1 | 1962667 | g49247 | i0 | 89.6 | 2.0093023255814 | 48 | 5 | 67 | 0 | 213 | 70 | 290 | 337 | WP_293254146.1 DUF294 nucleotidyltransferase-like domain-containing protein [Nannocystis sp.] | diamond | 432 | 97.8 | 0.992842535787321 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. | |||
| 30235887 | 30235887 | PRJNA546018_S_NODE_9512_length_563_cov_3.049801_g9193_i0 | PRJNA546018 | 9512 | 563 | 3.049801 | 17.17037963 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 90.1 | 1.44e-19 | NR | MEE2828568.1 | 2818507 | g9193 | i0 | 52.8 | 0.474245115452931 | 89 | 42 | 47.4 | 0 | 541 | 275 | 30 | 118 | MEE2828568.1 S-adenosylmethionine decarboxylase [Myxococcota bacterium] | diamond | 267 | 90.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30850995 | 30850995 | PRJNA546018_S_NODE_49714_length_215_cov_1.779221_g49389_i0 | PRJNA546018 | 49714 | 215 | 1.779221 | 3.82532515 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 1.75e-25 | NR | MBN8539685.1 | 2026735 | g49389 | i0 | 82.8 | 1.78604651162791 | 64 | 11 | 89.3 | 0 | 24 | 215 | 458 | 521 | MBN8539685.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium] | diamond | 384 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32575847 | 32575847 | PRJNA546018_S_NODE_48119_length_219_cov_1.746835_g47794_i0 | PRJNA546018 | 48119 | 219 | 1.746835 | 3.82556865 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 107 | 1.75e-25 | NR | HEX6272685.1 | 2268199 | g47794 | i0 | 84.6 | 1.79452054794521 | 65 | 10 | 89 | 0 | 216 | 22 | 324 | 388 | HEX6272685.1 right-handed parallel beta-helix repeat-containing protein [Polyangiaceae bacterium] | diamond | 393 | 107 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32795786 | 32795786 | PRJNA546018_S_NODE_23400_length_331_cov_1.714815_g23075_i0 | PRJNA546018 | 23400 | 331 | 1.714815 | 5.67603765 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 73.2 | 2.21e-12 | NR | HEX4621222.1 | 2484252 | g23075 | i0 | 43.4 | 0.897280966767372 | 99 | 50 | 87 | 2 | 312 | 25 | 161 | 256 | HEX4621222.1 SDR family oxidoreductase [Myxococcaceae bacterium] | diamond | 297 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae 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);;