contig_metadata
13 rows where bioproject = "PRJNA1082072", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26940837 | 26940837 | PRJNA1082072_P_NODE_2622_length_245_cov_0.895349_g2615_i0 | PRJNA1082072 | 2622 | 245 | 0.895349 | 2.19360505 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 47 | 0.00116 | NR | MBI3535551.1 | 2026735 | g2615 | i0 | 45.3 | 0.648979591836735 | 53 | 25 | 60 | 1 | 222 | 76 | 1 | 53 | MBI3535551.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 159 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27383663 | 27383663 | PRJNA1082072_P_NODE_2623_length_245_cov_0.895349_g2616_i0 | PRJNA1082072 | 2623 | 245 | 0.895349 | 2.19360505 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.4 | 7.07e-5 | NR | MBI4412516.1 | 2026735 | g2616 | i0 | 40.5 | 2.55918367346939 | 79 | 39 | 88.2 | 2 | 241 | 26 | 208 | 285 | MBI4412516.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 627 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27699649 | 27699649 | PRJNA1082072_P_NODE_1044_length_337_cov_1.083333_g1037_i0 | PRJNA1082072 | 1044 | 337 | 1.083333 | 3.65083221 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 47.4 | 0.00263 | NR | MCB9541223.1 | 2026763 | g1037 | i0 | 56.8 | 1.3620178041543 | 37 | 15 | 32.9 | 1 | 5 | 115 | 262 | 297 | MCB9541223.1 thrombospondin type 3 repeat-containing protein [Myxococcales bacterium] | diamond | 459 | 47.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27699651 | 27699651 | PRJNA1082072_P_NODE_2904_length_241_cov_1.809524_g2897_i0 | PRJNA1082072 | 2904 | 241 | 1.809524 | 4.36095284 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 67 | 8.45e-11 | NR | MBL8607222.1 | 2026763 | g2897 | i0 | 66.7 | 2.98755186721992 | 57 | 17 | 68.5 | 1 | 207 | 43 | 91 | 147 | MBL8607222.1 hypothetical protein [Myxococcales bacterium] | diamond | 720 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29025749 | 29025749 | PRJNA1082072_P_NODE_2028_length_252_cov_1.290503_g2021_i0 | PRJNA1082072 | 2028 | 252 | 1.290503 | 3.25206756 | Byssovorax sp. | 2927945 | Bacteria | Bacteria | 56.2 | 7.45e-7 | NR | MEP7125925.1 | 2927945 | g2021 | i0 | 47.9 | 2.33333333333333 | 71 | 36 | 84.5 | 1 | 13 | 225 | 487 | 556 | MEP7125925.1 putative metal-binding motif-containing protein [Byssovorax sp.] | diamond | 588 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Byssovorax | Byssovorax sp. | |||
| 29025751 | 29025751 | PRJNA1082072_P_NODE_928_length_349_cov_0.836957_g921_i0 | PRJNA1082072 | 928 | 349 | 0.836957 | 2.92097993 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 47 | 0.00401 | NR | MBN2496246.1 | 2026735 | g921 | i0 | 33 | 0.885386819484241 | 103 | 65 | 85.1 | 3 | 10 | 306 | 77 | 179 | MBN2496246.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 309 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30857319 | 30857319 | PRJNA1082072_P_NODE_1754_length_272_cov_1.256281_g1747_i0 | PRJNA1082072 | 1754 | 272 | 1.256281 | 3.41708432 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 129 | 2.91e-35 | NR | HEY2515554.1 | 2268199 | g1747 | i0 | 74.4 | 1.97426470588235 | 90 | 23 | 99.3 | 0 | 1 | 270 | 80 | 169 | HEY2515554.1 TetR/AcrR family transcriptional regulator [Polyangiaceae bacterium] | diamond | 537 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30983941 | 30983941 | PRJNA1082072_P_NODE_1234_length_312_cov_0.966527_g1227_i0 | PRJNA1082072 | 1234 | 312 | 0.966527 | 3.01556424 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 111 | 5.73e-26 | NR | HEX4312954.1 | 2212474 | g1227 | i0 | 53.8 | 1.97115384615385 | 104 | 48 | 100 | 0 | 312 | 1 | 942 | 1045 | HEX4312954.1 Ig-like domain-containing protein [Kofleriaceae bacterium] | diamond | 615 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31078707 | 31078707 | PRJNA1082072_P_NODE_2815_length_242_cov_1.816568_g2808_i0 | PRJNA1082072 | 2815 | 242 | 1.816568 | 4.39609456 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 73.9 | 3.82e-13 | NR | MBE7447977.1 | 2212474 | g2808 | i0 | 49.4 | 4.94628099173554 | 79 | 37 | 97.9 | 2 | 237 | 1 | 803 | 878 | MBE7447977.1 tandem-95 repeat protein [Kofleriaceae bacterium] | diamond | 1197 | 73.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31331369 | 31331369 | PRJNA1082072_P_NODE_1436_length_289_cov_1.425926_g1429_i0 | PRJNA1082072 | 1436 | 289 | 1.425926 | 4.12092614 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 51.2 | 6.77e-5 | NR | MBU6161104.1 | 2026763 | g1429 | i0 | 36.4 | 0.913494809688581 | 88 | 49 | 91.3 | 2 | 2 | 265 | 439 | 519 | MBU6161104.1 M60 family metallopeptidase [Myxococcales bacterium] | diamond | 264 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31702434 | 31702434 | PRJNA1082072_P_NODE_2397_length_248_cov_0.880000_g2390_i0 | PRJNA1082072 | 2397 | 248 | 0.88 | 2.1824 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 95.5 | 8.1899999999999992e-21 | NR | MBM4252069.1 | 2026735 | g2390 | i0 | 60.5 | 4.92338709677419 | 81 | 32 | 98 | 0 | 6 | 248 | 8 | 88 | MBM4252069.1 argininosuccinate lyase [Deltaproteobacteria bacterium] | diamond | 1221 | 95.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31742514 | 31742514 | PRJNA1082072_P_NODE_1997_length_254_cov_1.701657_g1990_i0 | PRJNA1082072 | 1997 | 254 | 1.701657 | 4.32220878 | Archangium sp. | 1872627 | Bacteria | Bacteria | 60.5 | 1.74e-8 | NR | HYO70690.1 | 1872627 | g1990 | i0 | 54.3 | 0.543307086614173 | 46 | 21 | 54.3 | 0 | 7 | 144 | 236 | 281 | HYO70690.1 hypothetical protein [Archangium sp.] | diamond | 138 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 32303874 | 32303874 | PRJNA1082072_P_NODE_2539_length_246_cov_0.890173_g2532_i0 | PRJNA1082072 | 2539 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 59.7 | 4.15e-8 | NR | MBM4344022.1 | 2026735 | g2532 | i0 | 37.8 | 4.57317073170732 | 82 | 47 | 97.6 | 2 | 5 | 244 | 1364 | 1443 | MBM4344022.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 1125 | 59.7 | 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);;