contig_metadata
21 rows where bioproject = "PRJNA1255065", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4187102 | 4187102 | PRJNA1255065_P_NODE_130064_length_165_cov_0.896552_g127836_i0 | PRJNA1255065 | 130064 | 165 | 0.896552 | 1.4793108 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 101 | 1.67e-23 | NR | MET0340030.1 | 3034171 | g127836 | i0 | 96.3 | 0.981818181818182 | 54 | 2 | 98.2 | 0 | 164 | 3 | 195 | 248 | MET0340030.1 hemolysin family protein [Polyangiales bacterium] | diamond | 162 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 11838906 | 11838906 | PRJNA1255065_P_NODE_39350_length_360_cov_1.527331_g37129_i0 | PRJNA1255065 | 39350 | 360 | 1.527331 | 5.4983916 | Anaeromyxobacter dehalogenans | 161493 | Bacteria | Bacteria | 228 | 5.279999999999998e-55 | NTclustered | gi|219952977|gb|CP001359.1| | 455488 | g37129 | i0 | 78.963 | 3.7 | 347 | 63 | 94 | 8 | 22 | 360 | 4744921 | 4744577 | Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome | blastn | 1332 | 228 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter dehalogenans | ||
| 15662775 | 15662775 | PRJNA1255065_P_NODE_117553_length_167_cov_0.881356_g115325_i0 | PRJNA1255065 | 117553 | 167 | 0.881356 | 1.47186452 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 189 | 1.0199999999999999e-43 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g115325 | i0 | 89.333 | 0.898203592814371 | 150 | 16 | 90 | 0 | 1 | 150 | 11622952 | 11623101 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 150 | 189 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 16937453 | 16937453 | PRJNA1255065_P_NODE_147974_length_162_cov_1.380531_g145746_i0 | PRJNA1255065 | 147974 | 162 | 1.380531 | 2.23646022 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 200 | 4.549999999999998e-47 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g145746 | i0 | 88.889 | 23.5185185185185 | 162 | 18 | 100 | 0 | 1 | 162 | 3942195 | 3942034 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 3810 | 200 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 20179543 | 20179543 | PRJNA1255065_P_NODE_63036_length_237_cov_1.218085_g60808_i0 | PRJNA1255065 | 63036 | 237 | 1.218085 | 2.88686145 | Myxococcia | 32015 | Bacteria | Bacteria | 363 | 8.65e-96 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g60808 | i0 | 94.142 | 201.679324894515 | 239 | 12 | 100 | 1 | 1 | 237 | 3942449 | 3942211 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 47798 | 363 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 23312000 | 23312000 | PRJNA1255065_P_NODE_109159_length_169_cov_0.866667_g106931_i0 | PRJNA1255065 | 109159 | 169 | 0.866667 | 1.46466723 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 200 | 4.76e-47 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g106931 | i0 | 88.095 | 7.48520710059172 | 168 | 20 | 99 | 0 | 1 | 168 | 955563 | 955396 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 1265 | 200 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 23312019 | 23312019 | PRJNA1255065_P_NODE_111219_length_168_cov_0.873950_g108991_i0 | PRJNA1255065 | 111219 | 168 | 0.87395 | 1.468236 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 172 | 1.04e-38 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g108991 | i0 | 87.417 | 1.06547619047619 | 151 | 17 | 89 | 2 | 2 | 151 | 831279 | 831428 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 179 | 172 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 24005341 | 24005341 | PRJNA1255065_P_NODE_53319_length_273_cov_1.620536_g51092_i0 | PRJNA1255065 | 53319 | 273 | 1.620536 | 4.42406328 | Nannocystis | 53 | Bacteria | Bacteria | 307 | 4.8400000000000005e-79 | NTclustered | gi|2244669|emb|X87286.1| | 54 | g51092 | i0 | 87.179 | 125.14652014652 | 273 | 32 | 99 | 3 | 3 | 273 | 12 | 283 | N.exedens 23S rRNA gene | blastn | 34165 | 307 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis exedens | |||
| 27136602 | 27136602 | PRJNA1255065_P_NODE_135802_length_164_cov_0.904348_g133574_i0 | PRJNA1255065 | 135802 | 164 | 0.904348 | 1.48313072 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.4 | 2.43e-5 | NR | MEJ2429997.1 | 2026735 | g133574 | i0 | 43.8 | 1.75609756097561 | 48 | 27 | 87.8 | 0 | 9 | 152 | 564 | 611 | MEJ2429997.1 GMC family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 288 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27390075 | 27390075 | PRJNA1255065_P_NODE_57803_length_255_cov_0.868932_g55575_i0 | PRJNA1255065 | 57803 | 255 | 0.868932 | 2.2157766 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.3 | 0.0123 | NR | TMQ02292.1 | 2026735 | g55575 | i0 | 37.8 | 2.50588235294118 | 82 | 41 | 85.9 | 4 | 231 | 13 | 32 | 112 | TMQ02292.1 MAG: FecR domain-containing protein, partial [Deltaproteobacteria bacterium] | diamond | 639 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27863403 | 27863403 | PRJNA1255065_P_NODE_114145_length_168_cov_0.873950_g111917_i0 | PRJNA1255065 | 114145 | 168 | 0.87395 | 1.468236 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 41.6 | 0.0149 | NR | MCA9775046.1 | 2026763 | g111917 | i0 | 43.9 | 0.732142857142857 | 41 | 23 | 73.2 | 0 | 2 | 124 | 33 | 73 | MCA9775046.1 hypothetical protein [Myxococcales bacterium] | diamond | 123 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28210626 | 28210626 | PRJNA1255065_P_NODE_119786_length_167_cov_0.881356_g117558_i0 | PRJNA1255065 | 119786 | 167 | 0.881356 | 1.47186452 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 84 | 9.44e-18 | NR | MCA9660203.1 | 2026763 | g117558 | i0 | 76.5 | 4.77844311377245 | 51 | 12 | 91.6 | 0 | 13 | 165 | 97 | 147 | MCA9660203.1 thiolase family protein [Myxococcales bacterium] | diamond | 798 | 84 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28463585 | 28463585 | PRJNA1255065_P_NODE_25166_length_526_cov_9.232704_g1017_i8 | PRJNA1255065 | 25166 | 526 | 9.232704 | 48.56402304 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 46.2 | 0.0208 | NR | HXN81342.1 | 2026763 | g1017 | i8 | 31.7 | 0.593155893536122 | 104 | 65 | 58.7 | 3 | 203 | 511 | 44 | 142 | HXN81342.1 DUF2157 domain-containing protein [Myxococcales bacterium] | diamond | 312 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28684608 | 28684608 | PRJNA1255065_P_NODE_131607_length_165_cov_0.896552_g129379_i0 | PRJNA1255065 | 131607 | 165 | 0.896552 | 1.4793108 | Archangium sp. | 1872627 | Bacteria | Bacteria | 62.4 | 1.54e-9 | NR | MFT3709871.1 | 1872627 | g129379 | i0 | 52.7 | 5.8 | 55 | 26 | 100 | 0 | 1 | 165 | 546 | 600 | MFT3709871.1 ATP-binding protein [Archangium sp.] | diamond | 957 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 30010794 | 30010794 | PRJNA1255065_P_NODE_87091_length_190_cov_1.141844_g84863_i0 | PRJNA1255065 | 87091 | 190 | 1.141844 | 2.1695036 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 87.4 | 3.03e-18 | NR | MBK8251197.1 | 2268199 | g84863 | i0 | 66.1 | 0.978947368421053 | 62 | 21 | 97.9 | 0 | 2 | 187 | 368 | 429 | MBK8251197.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 186 | 87.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30453210 | 30453210 | PRJNA1255065_P_NODE_108593_length_169_cov_0.866667_g106365_i0 | PRJNA1255065 | 108593 | 169 | 0.866667 | 1.46466723 | Cystobacter ferrugineus | 83449 | Bacteria | Bacteria | 84.7 | 8.03e-20 | NR | WP_071900585.1 | 83449 | g106365 | i0 | 67.3 | 0.976331360946746 | 55 | 18 | 97.6 | 0 | 167 | 3 | 4 | 58 | WP_071900585.1 hypothetical protein [Cystobacter ferrugineus] | diamond | 165 | 84.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter ferrugineus | ||
| 30674010 | 30674010 | PRJNA1255065_P_NODE_111313_length_168_cov_0.873950_g109085_i0 | PRJNA1255065 | 111313 | 168 | 0.87395 | 1.468236 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 42.4 | 0.0182 | NR | HEY5242311.1 | 2268199 | g109085 | i0 | 47.1 | 0.607142857142857 | 34 | 18 | 60.7 | 0 | 14 | 115 | 267 | 300 | HEY5242311.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 102 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30674012 | 30674012 | PRJNA1255065_P_NODE_128353_length_165_cov_1.560345_g126125_i0 | PRJNA1255065 | 128353 | 165 | 1.560345 | 2.57456925 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 41.6 | 0.0328 | NR | MFT5359225.1 | 3034171 | g126125 | i0 | 42.6 | 0.854545454545454 | 47 | 26 | 83.6 | 1 | 142 | 5 | 72 | 118 | MFT5359225.1 hypothetical protein [Polyangiales bacterium] | diamond | 141 | 41.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 31369629 | 31369629 | PRJNA1255065_P_NODE_114456_length_168_cov_0.873950_g112228_i0 | PRJNA1255065 | 114456 | 168 | 0.87395 | 1.468236 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 90.5 | 2.07e-19 | NR | MEZ4314835.1 | 2268199 | g112228 | i0 | 78.6 | 2.94642857142857 | 56 | 12 | 100 | 0 | 1 | 168 | 15 | 70 | MEZ4314835.1 serine/threonine-protein kinase [Polyangiaceae bacterium] | diamond | 495 | 90.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31685545 | 31685545 | PRJNA1255065_P_NODE_148537_length_162_cov_0.920354_g146309_i0 | PRJNA1255065 | 148537 | 162 | 0.920354 | 1.49097348 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 40.8 | 0.041 | NR | MEE2644298.1 | 2818507 | g146309 | i0 | 52.4 | 0.777777777777778 | 42 | 17 | 77.8 | 1 | 36 | 161 | 7 | 45 | MEE2644298.1 hypothetical protein [Myxococcota bacterium] | diamond | 126 | 40.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31735063 | 31735063 | PRJNA1255065_P_NODE_107417_length_169_cov_0.866667_g105189_i0 | PRJNA1255065 | 107417 | 169 | 0.866667 | 1.46466723 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.9 | 1.59e-12 | NR | MEO6598261.1 | 2268199 | g105189 | i0 | 64.6 | 1.79289940828402 | 48 | 17 | 85.2 | 0 | 12 | 155 | 430 | 477 | MEO6598261.1 FAD/NAD(P)-binding protein [Polyangiaceae bacterium] | diamond | 303 | 71.6 | 0.990223463687151 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;