contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA758770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3292061 | 3292061 | PRJNA758770_S_NODE_32083_length_243_cov_0.911765_g31957_i0 | PRJNA758770 | 32083 | 243 | 0.911765 | 2.21558895 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 129 | 5.5800000000000005e-33 | NR | MCA9593138.1 | 2026763 | g31957 | i0 | 78.8 | 0.987654320987654 | 80 | 17 | 98.8 | 0 | 241 | 2 | 120 | 199 | MCA9593138.1 protein kinase [Myxococcales bacterium] | diamond | 240 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 4569098 | 4569098 | PRJNA758770_S_NODE_29464_length_246_cov_0.901734_g29338_i0 | PRJNA758770 | 29464 | 246 | 0.901734 | 2.21826564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 164 | 9.72e-50 | NR | MBN8540170.1 | 2026735 | g29338 | i0 | 95.1 | 1 | 82 | 4 | 100 | 0 | 246 | 1 | 21 | 102 | MBN8540170.1 inorganic diphosphatase [Deltaproteobacteria bacterium] | diamond | 246 | 164 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 18592506 | 18592506 | PRJNA758770_S_NODE_32895_length_242_cov_0.905325_g32769_i0 | PRJNA758770 | 32895 | 242 | 0.905325 | 2.1908865 | Anaeromyxobacter dehalogenans 2CP-1 | 455488 | Bacteria | Bacteria | 67 | 7.42e-11 | NR | ACL64142.1 | 455488 | g32769 | i0 | 50 | 0.892561983471074 | 72 | 36 | 89.3 | 0 | 27 | 242 | 157 | 228 | ACL64142.1 conserved hypothetical protein [Anaeromyxobacter dehalogenans 2CP-1] | diamond | 216 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter dehalogenans | ||
| 21606909 | 21606909 | PRJNA758770_S_NODE_25337_length_251_cov_0.876404_g25211_i0 | PRJNA758770 | 25337 | 251 | 0.876404 | 2.19977404 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 149 | 1.09e-40 | NR | MBN8540051.1 | 2026735 | g25211 | i0 | 91.6 | 0.99203187250996006 | 83 | 7 | 99.2 | 0 | 251 | 3 | 420 | 502 | MBN8540051.1 bifunctional phosphoribosylaminoimidazolecarboxamide formyltransferase/IMP cyclohydrolase [Deltaproteobacteria bacterium] | diamond | 249 | 149 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27021479 | 27021479 | PRJNA758770_S_NODE_17642_length_286_cov_1.023474_g17516_i0 | PRJNA758770 | 17642 | 286 | 1.023474 | 2.92713564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 144 | 5.289999999999999e-40 | NR | MBN8539208.1 | 2026735 | g17516 | i0 | 80 | 0.996503496503496 | 95 | 19 | 99.7 | 0 | 285 | 1 | 40 | 134 | MBN8539208.1 peptidylprolyl isomerase [Deltaproteobacteria bacterium] | diamond | 285 | 144 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27274389 | 27274389 | PRJNA758770_S_NODE_24203_length_252_cov_0.871508_g24077_i0 | PRJNA758770 | 24203 | 252 | 0.871508 | 2.19620016 | Haliangium ochraceum | 80816 | Bacteria | Bacteria | 57 | 4.11e-7 | NR | WP_012826750.1 | 80816 | g24077 | i0 | 45.5 | 0.785714285714286 | 66 | 34 | 76.2 | 1 | 249 | 58 | 369 | 434 | WP_012826750.1 HAD-IA family hydrolase [Haliangium ochraceum] | diamond | 198 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 27590402 | 27590402 | PRJNA758770_S_NODE_25804_length_250_cov_0.881356_g25678_i0 | PRJNA758770 | 25804 | 250 | 0.881356 | 2.20339 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 163 | 9.81e-46 | NR | MCU0676092.1 | 2818507 | g25678 | i0 | 95.2 | 0.996 | 83 | 4 | 99.6 | 0 | 1 | 249 | 377 | 459 | MCU0676092.1 hypothetical protein [Myxococcota bacterium] | diamond | 249 | 163 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28411235 | 28411235 | PRJNA758770_S_NODE_23346_length_253_cov_0.866667_g23220_i0 | PRJNA758770 | 23346 | 253 | 0.866667 | 2.19266751 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 90.5 | 1.59e-20 | NR | MBN8541970.1 | 2026735 | g23220 | i0 | 51.2 | 0.99604743083004 | 84 | 41 | 99.6 | 0 | 2 | 253 | 10 | 93 | MBN8541970.1 TlpA family protein disulfide reductase [Deltaproteobacteria bacterium] | diamond | 252 | 90.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29547608 | 29547608 | PRJNA758770_S_NODE_32610_length_242_cov_0.923077_g32484_i0 | PRJNA758770 | 32610 | 242 | 0.923077 | 2.23384634 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 58.9 | 6.92e-8 | NR | MCB9604609.1 | 2024858 | g32484 | i0 | 92.9 | 0.347107438016529 | 28 | 2 | 34.7 | 0 | 84 | 1 | 1 | 28 | MCB9604609.1 acyl-CoA dehydrogenase family protein [Sandaracinus sp.] | diamond | 84 | 58.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 29895254 | 29895254 | PRJNA758770_S_NODE_32331_length_242_cov_0.923077_g32205_i0 | PRJNA758770 | 32331 | 242 | 0.923077 | 2.23384634 | Anaeromyxobacter dehalogenans 2CP-1 | 455488 | Bacteria | Bacteria | 64.7 | 4.05e-10 | NR | ACL64143.1 | 455488 | g32205 | i0 | 52.2 | 0.830578512396694 | 67 | 32 | 83.1 | 0 | 203 | 3 | 100 | 166 | ACL64143.1 conserved hypothetical protein [Anaeromyxobacter dehalogenans 2CP-1] | diamond | 201 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter dehalogenans | ||
| 30306347 | 30306347 | PRJNA758770_S_NODE_31652_length_243_cov_0.917647_g31526_i0 | PRJNA758770 | 31652 | 243 | 0.917647 | 2.22988221 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 157 | 2.67e-44 | NR | MBN8540168.1 | 2026735 | g31526 | i0 | 91.3 | 0.987654320987654 | 80 | 7 | 98.8 | 0 | 3 | 242 | 24 | 103 | MBN8540168.1 LLM class flavin-dependent oxidoreductase [Deltaproteobacteria bacterium] | diamond | 240 | 157 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31221904 | 31221904 | PRJNA758770_S_NODE_25895_length_250_cov_0.881356_g25769_i0 | PRJNA758770 | 25895 | 250 | 0.881356 | 2.20339 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 142 | 7.58e-40 | NR | MBN8539473.1 | 2026735 | g25769 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 249 | 1 | 72 | 154 | MBN8539473.1 flagellin FliC [Deltaproteobacteria bacterium] | diamond | 249 | 142 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31253745 | 31253745 | PRJNA758770_S_NODE_27015_length_249_cov_0.886364_g26889_i0 | PRJNA758770 | 27015 | 249 | 0.886364 | 2.20704636 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 136 | 4.2199999999999996e-38 | NR | MBP8807158.1 | 2212474 | g26889 | i0 | 92.1 | 1.83132530120482 | 76 | 6 | 91.6 | 0 | 230 | 3 | 1 | 76 | MBP8807158.1 sigma-70 family RNA polymerase sigma factor [Kofleriaceae bacterium] | diamond | 456 | 136 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31348789 | 31348789 | PRJNA758770_S_NODE_25996_length_250_cov_0.881356_g25870_i0 | PRJNA758770 | 25996 | 250 | 0.881356 | 2.20339 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 158 | 1.07e-44 | NR | MBN8542189.1 | 2026735 | g25870 | i0 | 86.7 | 0.996 | 83 | 11 | 99.6 | 0 | 1 | 249 | 121 | 203 | MBN8542189.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 249 | 158 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31642873 | 31642873 | PRJNA758770_S_NODE_31176_length_244_cov_0.912281_g31050_i0 | PRJNA758770 | 31176 | 244 | 0.912281 | 2.22596564 | PVC group | 1783257 | Bacteria | Bacteria | 76.6 | 3.83e-14 | NR | MBC8394130.1 | 2026735 | g31050 | i0 | 71.4 | 2.38524590163934 | 49 | 14 | 60.2 | 0 | 149 | 3 | 365 | 413 | MBC8394130.1 CoB--CoM heterodisulfide reductase iron-sulfur subunit A family protein [Deltaproteobacteria bacterium] | diamond | 582 | 77 | 0.994805194805195 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31674528 | 31674528 | PRJNA758770_S_NODE_27557_length_248_cov_0.891429_g27431_i0 | PRJNA758770 | 27557 | 248 | 0.891429 | 2.21074392 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 135 | 1.19e-37 | NR | MBN8541601.1 | 2026735 | g27431 | i0 | 79.3 | 1.98387096774194 | 82 | 17 | 99.2 | 0 | 247 | 2 | 118 | 199 | MBN8541601.1 ATP-binding cassette domain-containing protein [Deltaproteobacteria bacterium] | diamond | 492 | 135 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32234742 | 32234742 | PRJNA758770_S_NODE_30658_length_244_cov_0.912281_g30532_i0 | PRJNA758770 | 30658 | 244 | 0.912281 | 2.22596564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 59.7 | 1.3e-8 | NR | MBW2648103.1 | 2026735 | g30532 | i0 | 54.7 | 0.651639344262295 | 53 | 23 | 63.9 | 1 | 157 | 2 | 3 | 55 | MBW2648103.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 159 | 59.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32298086 | 32298086 | PRJNA758770_S_NODE_17399_length_287_cov_1.420561_g17273_i0 | PRJNA758770 | 17399 | 287 | 1.420561 | 4.07701007 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 156 | 5.85e-42 | NR | MBN8541475.1 | 2026735 | g17273 | i0 | 75.8 | 0.993031358885017 | 95 | 23 | 99.3 | 0 | 2 | 286 | 207 | 301 | MBN8541475.1 DUF3516 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 285 | 156 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32551136 | 32551136 | PRJNA758770_S_NODE_32599_length_242_cov_0.923077_g32473_i0 | PRJNA758770 | 32599 | 242 | 0.923077 | 2.23384634 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 114 | 1.9999999999999997e-28 | NR | MBN8540238.1 | 2026735 | g32473 | i0 | 66.3 | 1.97107438016529 | 80 | 27 | 99.2 | 0 | 2 | 241 | 141 | 220 | MBN8540238.1 DUF4421 family protein [Deltaproteobacteria bacterium] | diamond | 477 | 114 | 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);;