contig_metadata
24 rows where bioproject = "PRJNA785164", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27338252 | 27338252 | PRJNA785164_P_NODE_60643_length_242_cov_0.911243_g60178_i0 | PRJNA785164 | 60643 | 242 | 0.911243 | 2.20520806 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 54.3 | 3.04e-6 | NR | MBI3769051.1 | 2026735 | g60178 | i0 | 39.5 | 2.00826446280992 | 81 | 39 | 93 | 3 | 228 | 4 | 278 | 354 | MBI3769051.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 486 | 54.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27568337 | 27568337 | PRJNA785164_P_NODE_7444_length_852_cov_3.861361_g7042_i0 | PRJNA785164 | 7444 | 852 | 3.861361 | 32.89879572 | root | 1 | Root_unresolved | Root_unresolved | 178 | 3.369999999999999e-52 | NR | TLM66027.1 | 2026735 | g7042 | i0 | 62 | 1.36971830985915 | 129 | 48 | 45.4 | 1 | 3 | 389 | 31 | 158 | TLM66027.1 MAG: adenine methyltransferase [Deltaproteobacteria bacterium] | diamond | 1167 | 178 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27622499 | 27622499 | PRJNA785164_P_NODE_64184_length_226_cov_2.686275_g63719_i0 | PRJNA785164 | 64184 | 226 | 2.686275 | 6.0709815 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 54.3 | 2.59e-6 | NR | MCG6910469.1 | 2026735 | g63719 | i0 | 45.2 | 1.9646017699115 | 73 | 32 | 96.9 | 3 | 7 | 225 | 984 | 1048 | MCG6910469.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 444 | 54.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28642122 | 28642122 | PRJNA785164_P_NODE_58587_length_244_cov_0.900585_g58122_i0 | PRJNA785164 | 58587 | 244 | 0.900585 | 2.1974274 | Myxococcia | 32015 | Bacteria | Bacteria | 133 | 1.7e-34 | NR | HMY17652.1 | 57 | g58122 | i0 | 72.8 | 10.9549180327869 | 81 | 22 | 99.6 | 0 | 243 | 1 | 355 | 435 | HMY17652.1 amidohydrolase family protein [Polyangium sp.] | diamond | 2673 | 133 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 28821838 | 28821838 | PRJNA785164_P_NODE_35508_length_304_cov_1.000000_g35043_i0 | PRJNA785164 | 35508 | 304 | 1 | 3.04 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 90.1 | 1.71e-18 | NR | HNC96677.1 | 2818507 | g35043 | i0 | 53.1 | 0.799342105263158 | 81 | 38 | 79.9 | 0 | 269 | 27 | 294 | 374 | HNC96677.1 DUF3987 domain-containing protein [Myxococcota bacterium] | diamond | 243 | 90.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29011930 | 29011930 | PRJNA785164_P_NODE_44508_length_270_cov_1.228426_g44043_i0 | PRJNA785164 | 44508 | 270 | 1.228426 | 3.3167502 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 83.6 | 2.15e-16 | NR | NQW45591.1 | 2026735 | g44043 | i0 | 44.3 | 1.8 | 88 | 49 | 97.8 | 0 | 266 | 3 | 355 | 442 | NQW45591.1 FAD-dependent oxidoreductase [Deltaproteobacteria bacterium] | diamond | 486 | 83.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29043340 | 29043340 | PRJNA785164_P_NODE_47908_length_260_cov_1.080214_g47443_i0 | PRJNA785164 | 47908 | 260 | 1.080214 | 2.8085564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 46.2 | 0.0011 | NR | NIS77788.1 | 2026735 | g47443 | i0 | 44.6 | 0.75 | 65 | 31 | 69.2 | 3 | 81 | 260 | 75 | 139 | NIS77788.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 195 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29043346 | 29043346 | PRJNA785164_P_NODE_54728_length_248_cov_0.880000_g54263_i0 | PRJNA785164 | 54728 | 248 | 0.88 | 2.1824 | Myxococcus virescens | 83456 | Bacteria | Bacteria | 63.2 | 2.31e-10 | NR | WP_090487439.1 | 83456 | g54263 | i0 | 41 | 1.00403225806452 | 83 | 48 | 99.2 | 1 | 247 | 2 | 33 | 115 | WP_090487439.1 hypothetical protein [Myxococcus virescens] | diamond | 249 | 63.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus virescens | ||
| 29201200 | 29201200 | PRJNA785164_P_NODE_61109_length_242_cov_0.911243_g60644_i0 | PRJNA785164 | 61109 | 242 | 0.911243 | 2.20520806 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 99.4 | 4.149999999999999e-23 | NR | MBW2035729.1 | 2026735 | g60644 | i0 | 62.5 | 0.991735537190083 | 80 | 29 | 99.2 | 1 | 3 | 242 | 186 | 264 | MBW2035729.1 terminase family protein [Deltaproteobacteria bacterium] | diamond | 240 | 99.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29263994 | 29263994 | PRJNA785164_P_NODE_62249_length_241_cov_0.916667_g61784_i0 | PRJNA785164 | 62249 | 241 | 0.916667 | 2.20916747 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 45.8 | 0.00273 | NR | WP_394847423.1 | 2905690 | g61784 | i0 | 37.3 | 0.734439834024896 | 59 | 37 | 73.4 | 0 | 237 | 61 | 210 | 268 | WP_394847423.1 hypothetical protein [Pendulispora brunnea] | diamond | 177 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 29674318 | 29674318 | PRJNA785164_P_NODE_51890_length_250_cov_1.672316_g51425_i0 | PRJNA785164 | 51890 | 250 | 1.672316 | 4.18079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 72.8 | 2.58e-13 | NR | NJK32591.1 | 2026735 | g51425 | i0 | 50 | 0.936 | 78 | 37 | 91.2 | 1 | 2 | 229 | 16 | 93 | NJK32591.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 234 | 72.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29705781 | 29705781 | PRJNA785164_P_NODE_63490_length_232_cov_2.396226_g63025_i0 | PRJNA785164 | 63490 | 232 | 2.396226 | 5.55924432 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 110 | 2.4e-28 | NR | HWO13585.1 | 2268199 | g63025 | i0 | 68.8 | 0.995689655172414 | 77 | 23 | 99.6 | 1 | 231 | 1 | 43 | 118 | HWO13585.1 molybdopterin cofactor-binding domain-containing protein [Polyangiaceae bacterium] | diamond | 231 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30338472 | 30338472 | PRJNA785164_P_NODE_53192_length_249_cov_0.875000_g52727_i0 | PRJNA785164 | 53192 | 249 | 0.875 | 2.17875 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 119 | 3.56e-30 | NR | MEI7672950.1 | 2026735 | g52727 | i0 | 67.5 | 2.91566265060241 | 80 | 26 | 96.4 | 0 | 247 | 8 | 48 | 127 | MEI7672950.1 transposase [Deltaproteobacteria bacterium] | diamond | 726 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30464807 | 30464807 | PRJNA785164_P_NODE_49133_length_256_cov_1.497268_g48668_i0 | PRJNA785164 | 49133 | 256 | 1.497268 | 3.83300608 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 98.2 | 1.3700000000000002e-21 | NR | HNC96677.1 | 2818507 | g48668 | i0 | 66.7 | 0.7734375 | 66 | 22 | 77.3 | 0 | 199 | 2 | 454 | 519 | HNC96677.1 DUF3987 domain-containing protein [Myxococcota bacterium] | diamond | 198 | 98.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30527533 | 30527533 | PRJNA785164_P_NODE_54573_length_248_cov_0.880000_g54108_i0 | PRJNA785164 | 54573 | 248 | 0.88 | 2.1824 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 46.2 | 0.0014 | NR | MBE7413838.1 | 2026735 | g54108 | i0 | 41.8 | 0.810483870967742 | 67 | 39 | 81 | 0 | 10 | 210 | 116 | 182 | MBE7413838.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 201 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31064976 | 31064976 | PRJNA785164_P_NODE_53635_length_249_cov_0.875000_g53170_i0 | PRJNA785164 | 53635 | 249 | 0.875 | 2.17875 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 92.4 | 1.3400000000000002e-21 | NR | HEY1536102.1 | 2268199 | g53170 | i0 | 69.6 | 0.831325301204819 | 69 | 21 | 83.1 | 0 | 3 | 209 | 85 | 153 | HEY1536102.1 DUF5655 domain-containing protein [Polyangiaceae bacterium] | diamond | 207 | 92.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31539156 | 31539156 | PRJNA785164_P_NODE_56416_length_246_cov_0.890173_g55951_i0 | PRJNA785164 | 56416 | 246 | 0.890173 | 2.18982558 | Polyangium sp. 15x6 | 3042687 | Bacteria | Bacteria | 51.6 | 2.74e-5 | NR | WP_282424953.1 | 3042687 | g55951 | i0 | 35.3 | 0.829268292682927 | 68 | 44 | 82.9 | 0 | 6 | 209 | 173 | 240 | WP_282424953.1 peptidoglycan-binding domain-containing protein [Polyangium sp. 15x6] | diamond | 204 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. 15x6 | |||
| 31633835 | 31633835 | PRJNA785164_P_NODE_58976_length_244_cov_0.900585_g58511_i0 | PRJNA785164 | 58976 | 244 | 0.900585 | 2.1974274 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 86.7 | 1.32e-17 | NR | MBI3554690.1 | 2026735 | g58511 | i0 | 55.6 | 0.995901639344262 | 81 | 34 | 99.6 | 2 | 244 | 2 | 163 | 241 | MBI3554690.1 primary-amine oxidase [Deltaproteobacteria bacterium] | diamond | 243 | 86.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32045217 | 32045217 | PRJNA785164_P_NODE_54838_length_248_cov_0.880000_g54373_i0 | PRJNA785164 | 54838 | 248 | 0.88 | 2.1824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 120 | 4.589999999999999e-31 | NR | HET9958005.1 | 2268199 | g54373 | i0 | 64.6 | 1.98387096774194 | 82 | 29 | 99.2 | 0 | 3 | 248 | 32 | 113 | HET9958005.1 amino acid--[acyl-carrier-protein] ligase [Polyangiaceae bacterium] | diamond | 492 | 120 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32108419 | 32108419 | PRJNA785164_P_NODE_61918_length_241_cov_0.916667_g61453_i0 | PRJNA785164 | 61918 | 241 | 0.916667 | 2.20916747 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.4 | 0.0477 | NR | MBN8540815.1 | 2026735 | g61453 | i0 | 41.7 | 0.597510373443983 | 48 | 28 | 59.8 | 0 | 62 | 205 | 164 | 211 | MBN8540815.1 fatty acid desaturase [Deltaproteobacteria bacterium] | diamond | 144 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32140137 | 32140137 | PRJNA785164_P_NODE_54218_length_248_cov_0.880000_g53753_i0 | PRJNA785164 | 54218 | 248 | 0.88 | 2.1824 | Haliangium sp. | 2663208 | Bacteria | Bacteria | 57 | 3.68e-7 | NR | HWN67418.1 | 2663208 | g53753 | i0 | 64.4 | 0.544354838709677 | 45 | 16 | 54.4 | 0 | 141 | 7 | 320 | 364 | HWN67418.1 hypothetical protein [Haliangium sp.] | diamond | 135 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. | |||
| 32339402 | 32339402 | PRJNA785164_P_NODE_47199_length_262_cov_1.222222_g46734_i0 | PRJNA785164 | 47199 | 262 | 1.222222 | 3.20222164 | Bacteria | 2 | Bacteria | Bacteria | 120 | 3.96e-30 | NR | HTR49814.1 | 2212474 | g46734 | i0 | 68.7 | 4.68320610687023 | 83 | 26 | 95 | 0 | 2 | 250 | 305 | 387 | HTR49814.1 IS3 family transposase [Kofleriaceae bacterium] | diamond | 1227 | 120 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32645626 | 32645626 | PRJNA785164_P_NODE_54380_length_248_cov_0.880000_g53915_i0 | PRJNA785164 | 54380 | 248 | 0.88 | 2.1824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 115 | 1.0500000000000001e-30 | NR | MBK9260809.1 | 2268199 | g53915 | i0 | 72.7 | 0.931451612903226 | 77 | 21 | 93.1 | 0 | 233 | 3 | 7 | 83 | MBK9260809.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 231 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32708836 | 32708836 | PRJNA785164_P_NODE_55600_length_247_cov_0.885057_g55135_i0 | PRJNA785164 | 55600 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 73.2 | 4.2e-13 | NR | HAR97047.1 | 2026735 | g55135 | i0 | 50.7 | 0.910931174089069 | 75 | 36 | 89.9 | 1 | 2 | 223 | 231 | 305 | HAR97047.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 225 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;