contig_metadata
9 rows where bioproject = "PRJNA1192965", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5423634 | 5423634 | PRJNA1192965_P_NODE_1905_length_306_cov_1.321888_g1886_i0 | PRJNA1192965 | 1905 | 306 | 1.321888 | 4.04497728 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g1886 | i0 | 100 | 0.0947712418300654 | 29 | 0 | 9 | 0 | 112 | 140 | 9099141 | 9099169 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 23272681 | 23272681 | PRJNA1192965_P_NODE_3419_length_251_cov_0.865169_g3400_i0 | PRJNA1192965 | 3419 | 251 | 0.865169 | 2.17157419 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 159 | 1.81e-44 | NR | MBI1947140.1 | 2026735 | g3400 | i0 | 89.2 | 12.8964143426295 | 83 | 9 | 99.2 | 0 | 251 | 3 | 379 | 461 | MBI1947140.1 NADP-dependent isocitrate dehydrogenase [Deltaproteobacteria bacterium] | diamond | 3237 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27565142 | 27565142 | PRJNA1192965_P_NODE_4204_length_246_cov_0.890173_g4185_i0 | PRJNA1192965 | 4204 | 246 | 0.890173 | 2.18982558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.7 | 0.0286 | NR | MBW1824299.1 | 2026735 | g4185 | i0 | 55.9 | 1.13414634146341 | 34 | 12 | 41.5 | 1 | 174 | 73 | 27 | 57 | MBW1824299.1 DUF4203 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 279 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28051467 | 28051467 | PRJNA1192965_P_NODE_2805_length_266_cov_1.378238_g2786_i0 | PRJNA1192965 | 2805 | 266 | 1.378238 | 3.66611308 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42 | 0.0348 | NR | MFT4624923.1 | 2818507 | g2786 | i0 | 43.1 | 0.81203007518797 | 72 | 33 | 78.9 | 4 | 56 | 265 | 5 | 70 | MFT4624923.1 ubiquinone/menaquinone biosynthesis C-methylase UbiE [Myxococcota bacterium] | diamond | 216 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28808952 | 28808952 | PRJNA1192965_P_NODE_3608_length_249_cov_5.227273_g3589_i0 | PRJNA1192965 | 3608 | 249 | 5.227273 | 13.01590977 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 49.3 | 1.35e-4 | NR | MCA9634375.1 | 2026763 | g3589 | i0 | 49.1 | 0.686746987951807 | 57 | 28 | 67.5 | 1 | 82 | 249 | 57 | 113 | MCA9634375.1 hypothetical protein [Myxococcales bacterium] | diamond | 171 | 49.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28999087 | 28999087 | PRJNA1192965_P_NODE_5208_length_241_cov_0.916667_g5189_i0 | PRJNA1192965 | 5208 | 241 | 0.916667 | 2.20916747 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.1 | 9.77e-5 | NR | MDX9722326.1 | 2818507 | g5189 | i0 | 37.6 | 1.05809128630705 | 85 | 42 | 95.9 | 4 | 4 | 234 | 700 | 781 | MDX9722326.1 hypothetical protein [Myxococcota bacterium] | diamond | 255 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30514692 | 30514692 | PRJNA1192965_P_NODE_2473_length_279_cov_1.412621_g2454_i0 | PRJNA1192965 | 2473 | 279 | 1.412621 | 3.94121259 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 76.6 | 6.73e-14 | NR | MFO0649778.1 | 3034171 | g2454 | i0 | 46 | 0.935483870967742 | 87 | 47 | 93.5 | 0 | 261 | 1 | 165 | 251 | MFO0649778.1 TlpA disulfide reductase family protein [Polyangiales bacterium] | diamond | 261 | 76.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 31526241 | 31526241 | PRJNA1192965_P_NODE_1396_length_344_cov_1.055351_g1377_i0 | PRJNA1192965 | 1396 | 344 | 1.055351 | 3.63040744 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 89.7 | 3.52e-18 | NR | MBL8606644.1 | 2026763 | g1377 | i0 | 44.8 | 1.71802325581395 | 105 | 57 | 90.7 | 1 | 338 | 27 | 330 | 434 | MBL8606644.1 hypothetical protein [Myxococcales bacterium] | diamond | 591 | 89.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32538713 | 32538713 | PRJNA1192965_P_NODE_4479_length_245_cov_0.866279_g4460_i0 | PRJNA1192965 | 4479 | 245 | 0.866279 | 2.12238355 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 124 | 7.43e-34 | NR | RYZ16037.1 | 2484252 | g4460 | i0 | 74.1 | 0.991836734693878 | 81 | 21 | 99.2 | 0 | 1 | 243 | 50 | 130 | RYZ16037.1 MAG: formate--tetrahydrofolate ligase [Myxococcaceae bacterium] | diamond | 243 | 124 | 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);;