contig_metadata
21 rows where bioproject = "PRJNA976345", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3498346 | 3498346 | PRJNA976345_P_NODE_121503_length_178_cov_2.391608_g119895_i0 | PRJNA976345 | 121503 | 178 | 2.391608 | 4.25706224 | Myxococcus stipitatus | 83455 | Bacteria | Bacteria | 52.8 | 0.015 | NTclustered | gi|441484664|gb|CP004025.1| | 1278073 | g119895 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 19 | 46 | 3245473 | 3245446 | Myxococcus stipitatus DSM 14675, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 13701399 | 13701399 | PRJNA976345_P_NODE_122311_length_178_cov_2.293706_g120703_i0 | PRJNA976345 | 122311 | 178 | 2.293706 | 4.08279668 | Myxococcus sp. SDU36 | 2831967 | Bacteria | Bacteria | 60.2 | 9e-5 | NTclustered | gi|2513984958|gb|CP077414.1| | 2831967 | g120703 | i0 | 97.143 | 0.376404494382022 | 35 | 1 | 20 | 0 | 40 | 74 | 1506014 | 1506048 | Myxococcus sp. SDU36 chromosome, complete genome | blastn | 67 | 60.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. SDU36 | ||
| 22624792 | 22624792 | PRJNA976345_P_NODE_121178_length_178_cov_2.433566_g119570_i0 | PRJNA976345 | 121178 | 178 | 2.433566 | 4.33174748 | Haliangium ochraceum | 80816 | Bacteria | Bacteria | 52.8 | 0.015 | NTclustered | gi|262076673|gb|CP001804.1| | 502025 | g119570 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 2 | 29 | 5422861 | 5422888 | Haliangium ochraceum DSM 14365, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 22625251 | 22625251 | PRJNA976345_P_NODE_196978_length_150_cov_3.234783_g195370_i0 | PRJNA976345 | 196978 | 150 | 3.234783 | 4.8521745 | Pyxidicoccus parkwayensis | 2813578 | Bacteria | Bacteria | 110 | 7.15e-20 | NTclustered | gi|1998505907|gb|CP071090.1| | 2813578 | g195370 | i0 | 94.366 | 6.50666666666667 | 71 | 4 | 47 | 0 | 2 | 72 | 5214977 | 5215047 | Pyxidicoccus parkwaysis strain SCPEA02 chromosome | blastn | 976 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus parkwayensis | ||
| 26740777 | 26740777 | PRJNA976345_P_NODE_92901_length_195_cov_1.487500_g91293_i0 | PRJNA976345 | 92901 | 195 | 1.4875 | 2.900625 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 75.9 | 4.06e-14 | NR | MBV8361473.1 | 2026735 | g91293 | i0 | 67.9 | 0.815384615384615 | 53 | 17 | 81.5 | 0 | 11 | 169 | 625 | 677 | MBV8361473.1 type IV secretory system conjugative DNA transfer family protein [Deltaproteobacteria bacterium] | diamond | 159 | 75.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27026010 | 27026010 | PRJNA976345_P_NODE_154922_length_164_cov_2.031008_g153314_i0 | PRJNA976345 | 154922 | 164 | 2.031008 | 3.33085312 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 63.5 | 5.79e-10 | NR | MCZ6806484.1 | 2026735 | g153314 | i0 | 53.7 | 0.98780487804878 | 54 | 25 | 98.8 | 0 | 3 | 164 | 199 | 252 | MCZ6806484.1 HD domain-containing protein [Deltaproteobacteria bacterium] | diamond | 162 | 63.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27089356 | 27089356 | PRJNA976345_P_NODE_129442_length_176_cov_1.113475_g127834_i0 | PRJNA976345 | 129442 | 176 | 1.113475 | 1.959716 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 47.8 | 2.57e-4 | NR | WP_242516015.1 | 56 | g127834 | i0 | 47.1 | 0.869318181818182 | 51 | 26 | 85.2 | 1 | 157 | 8 | 412 | 462 | WP_242516015.1 hypothetical protein [Sorangium cellulosum] | diamond | 153 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 27373991 | 27373991 | PRJNA976345_P_NODE_122763_length_178_cov_2.237762_g121155_i0 | PRJNA976345 | 122763 | 178 | 2.237762 | 3.98321636 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 48.5 | 1.42e-4 | NR | MBX3260983.1 | 1971228 | g121155 | i0 | 49 | 2.02247191011236 | 49 | 24 | 82.6 | 1 | 31 | 177 | 31 | 78 | MBX3260983.1 N-acetyl sugar amidotransferase [Labilithrix sp.] | diamond | 360 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 27531566 | 27531566 | PRJNA976345_P_NODE_148303_length_167_cov_1.598485_g146695_i0 | PRJNA976345 | 148303 | 167 | 1.598485 | 2.66946995 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 41.2 | 0.0474 | NR | MBN1255368.1 | 2026735 | g146695 | i0 | 44 | 0.898203592814371 | 50 | 25 | 84.4 | 1 | 159 | 19 | 323 | 372 | MBN1255368.1 N-6 DNA methylase [Deltaproteobacteria bacterium] | diamond | 150 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28478831 | 28478831 | PRJNA976345_P_NODE_105806_length_186_cov_1.549669_g104198_i0 | PRJNA976345 | 105806 | 186 | 1.549669 | 2.88238434 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52 | 2.26e-6 | NR | MBW1799201.1 | 2026735 | g104198 | i0 | 41.7 | 1.79032258064516 | 60 | 33 | 93.5 | 1 | 8 | 181 | 47 | 106 | MBW1799201.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 333 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29205178 | 29205178 | PRJNA976345_P_NODE_118049_length_179_cov_1.458333_g116441_i0 | PRJNA976345 | 118049 | 179 | 1.458333 | 2.61041607 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 41.6 | 0.0404 | NR | MBP1735216.1 | 2026735 | g116441 | i0 | 72 | 0.418994413407821 | 25 | 7 | 41.9 | 0 | 179 | 105 | 294 | 318 | MBP1735216.1 acetyl-CoA hydrolase/transferase [Deltaproteobacteria bacterium] | diamond | 75 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29274212 | 29274212 | PRJNA976345_P_NODE_167189_length_160_cov_1.224000_g165581_i0 | PRJNA976345 | 167189 | 160 | 1.224 | 1.9584 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 92.4 | 4.1700000000000006e-21 | NR | MDJ0789865.1 | 2818507 | g165581 | i0 | 90.4 | 3.9 | 52 | 5 | 97.5 | 0 | 160 | 5 | 188 | 239 | MDJ0789865.1 hypothetical protein [Myxococcota bacterium] | diamond | 624 | 92.8 | 0.995689655172414 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29369146 | 29369146 | PRJNA976345_P_NODE_47229_length_253_cov_2.788991_g45621_i0 | PRJNA976345 | 47229 | 253 | 2.788991 | 7.05614723 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.1 | 0.0162 | NR | MCH9682027.1 | 2026735 | g45621 | i0 | 39.1 | 1.10276679841897 | 46 | 25 | 51 | 1 | 215 | 87 | 68 | 113 | MCH9682027.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 279 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29520737 | 29520737 | PRJNA976345_P_NODE_179630_length_155_cov_289.858333_g178022_i0 | PRJNA976345 | 179630 | 155 | 289.858333 | 449.28041615 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42 | 0.02 | NR | MBR56548.1 | 2026763 | g178022 | i0 | 63 | 0.52258064516129 | 27 | 10 | 52.3 | 0 | 92 | 12 | 202 | 228 | MBR56548.1 hypothetical protein [Myxococcales bacterium] | diamond | 81 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30026173 | 30026173 | PRJNA976345_P_NODE_103731_length_187_cov_2.190789_g102123_i0 | PRJNA976345 | 103731 | 187 | 2.190789 | 4.09677543 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 87 | 4.44e-18 | NR | WP_146651704.1 | 1391654 | g102123 | i0 | 79.3 | 1.90909090909091 | 58 | 12 | 93 | 0 | 175 | 2 | 596 | 653 | WP_146651704.1 PD40 domain-containing protein [Labilithrix luteola] | diamond | 357 | 87 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 30057484 | 30057484 | PRJNA976345_P_NODE_121391_length_178_cov_2.405594_g119783_i0 | PRJNA976345 | 121391 | 178 | 2.405594 | 4.28195732 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 53.5 | 6e-7 | NR | RYE86195.1 | 2026763 | g119783 | i0 | 96 | 0.421348314606742 | 25 | 1 | 42.1 | 0 | 104 | 178 | 17 | 41 | RYE86195.1 MAG: hypothetical protein EOO75_16025 [Myxococcales bacterium] | diamond | 75 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30095323 | 30095323 | PRJNA976345_P_NODE_161792_length_162_cov_0.944882_g160184_i0 | PRJNA976345 | 161792 | 162 | 0.944882 | 1.53070884 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 82.8 | 7.55e-17 | NR | HEX9576391.1 | 2026763 | g160184 | i0 | 91.5 | 13.2222222222222 | 47 | 4 | 87 | 0 | 142 | 2 | 1 | 47 | HEX9576391.1 RNA polymerase sigma factor [Myxococcales bacterium] | diamond | 2142 | 82.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31890917 | 31890917 | PRJNA976345_P_NODE_181377_length_155_cov_1.658333_g179769_i0 | PRJNA976345 | 181377 | 155 | 1.658333 | 2.57041615 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 75.5 | 2.95e-14 | NR | MEO8183369.1 | 2026735 | g179769 | i0 | 77.3 | 0.851612903225806 | 44 | 10 | 85.2 | 0 | 23 | 154 | 7 | 50 | MEO8183369.1 sigma-70 family RNA polymerase sigma factor [Deltaproteobacteria bacterium] | diamond | 132 | 75.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32207442 | 32207442 | PRJNA976345_P_NODE_94658_length_193_cov_225.145570_g93050_i0 | PRJNA976345 | 94658 | 193 | 225.14557 | 434.5309501 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 41.6 | 0.0445 | NR | MBR56548.1 | 2026763 | g93050 | i0 | 63 | 0.419689119170984 | 27 | 10 | 42 | 0 | 102 | 182 | 202 | 228 | MBR56548.1 hypothetical protein [Myxococcales bacterium] | diamond | 81 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32213679 | 32213679 | PRJNA976345_P_NODE_95878_length_193_cov_1.259494_g94270_i0 | PRJNA976345 | 95878 | 193 | 1.259494 | 2.43082342 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.4 | 0.0254 | NR | MBL8742302.1 | 2026763 | g94270 | i0 | 53.7 | 1.47668393782383 | 41 | 15 | 63.7 | 1 | 164 | 42 | 199 | 235 | MBL8742302.1 serine/threonine protein kinase [Myxococcales bacterium] | diamond | 285 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32870308 | 32870308 | PRJNA976345_P_NODE_69780_length_216_cov_291.591160_g68172_i0 | PRJNA976345 | 69780 | 216 | 291.59116 | 629.8369056 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42.7 | 0.0232 | NR | MBR56548.1 | 2026763 | g68172 | i0 | 63 | 0.375 | 27 | 10 | 37.5 | 0 | 125 | 205 | 202 | 228 | MBR56548.1 hypothetical protein [Myxococcales bacterium] | diamond | 81 | 42.7 | 1 | 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);;