contig_metadata
12 rows where bioproject = "PRJNA485080", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1723982 | 1723982 | PRJNA485080_P_NODE_37982_length_243_cov_1.382353_g37888_i0 | PRJNA485080 | 37982 | 243 | 1.382353 | 3.35911779 | Archangium gephyra | 48 | Bacteria | Bacteria | 305 | 1.52e-78 | NTclustered | gi|827418478|gb|CP011509.1| | 48 | g37888 | i0 | 89.3 | 2.00411522633745 | 243 | 26 | 100 | 0 | 1 | 243 | 8431804 | 8431562 | Archangium gephyra strain DSM 2261, complete genome | blastn | 487 | 305 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 1724112 | 1724112 | PRJNA485080_P_NODE_8002_length_360_cov_1.404181_g7908_i0 | PRJNA485080 | 8002 | 360 | 1.404181 | 5.0550516 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 496 | 1.31e-135 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g7908 | i0 | 91.69 | 155.525 | 361 | 25 | 100 | 3 | 1 | 360 | 7289535 | 7289179 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 55989 | 496 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 8102111 | 8102111 | PRJNA485080_P_NODE_20047_length_259_cov_2.483871_g19953_i0 | PRJNA485080 | 20047 | 259 | 2.483871 | 6.43322589 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 342 | 1.25e-89 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g19953 | i0 | 90.769 | 163.783783783784 | 260 | 18 | 99 | 5 | 3 | 259 | 3941985 | 3942241 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 42420 | 342 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 11300638 | 11300638 | PRJNA485080_P_NODE_21269_length_251_cov_1.808989_g21175_i0 | PRJNA485080 | 21269 | 251 | 1.808989 | 4.54056239 | Pendulispora | 3375062 | Bacteria | Bacteria | 433 | 6.95e-117 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g21175 | i0 | 97.992 | 272.05577689243 | 249 | 5 | 99 | 0 | 3 | 251 | 7287167 | 7287415 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 68286 | 433 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 17675031 | 17675031 | PRJNA485080_P_NODE_31514_length_247_cov_0.885057_g31420_i0 | PRJNA485080 | 31514 | 247 | 0.885057 | 2.18609079 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 156 | 5.31e-45 | NR | HEX7703479.1 | 2212474 | g31420 | i0 | 96.3 | 1.9919028340081 | 82 | 3 | 99.6 | 0 | 247 | 2 | 59 | 140 | HEX7703479.1 malate dehydrogenase [Kofleriaceae bacterium] | diamond | 492 | 156 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28339604 | 28339604 | PRJNA485080_P_NODE_28386_length_248_cov_0.880000_g28292_i0 | PRJNA485080 | 28386 | 248 | 0.88 | 2.1824 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 43.5 | 0.0215 | NR | GMV44267.1 | 2026763 | g28292 | i0 | 33.8 | 0.82258064516129 | 68 | 35 | 77.4 | 2 | 243 | 52 | 597 | 658 | GMV44267.1 MAG: hypothetical protein AMXMBFR64_59830 [Myxococcales bacterium] | diamond | 204 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28592281 | 28592281 | PRJNA485080_P_NODE_18647_length_269_cov_1.112245_g18553_i0 | PRJNA485080 | 18647 | 269 | 1.112245 | 2.99193905 | Archangium sp. | 1872627 | Bacteria | Bacteria | 45.4 | 0.00566 | NR | WP_407755685.1 | 1872627 | g18553 | i0 | 47.7 | 0.490706319702602 | 44 | 17 | 43.5 | 2 | 52 | 168 | 9 | 51 | WP_407755685.1 DUF6311 domain-containing protein [Archangium sp.] | diamond | 132 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28812877 | 28812877 | PRJNA485080_P_NODE_32988_length_246_cov_0.890173_g32894_i0 | PRJNA485080 | 32988 | 246 | 0.890173 | 2.18982558 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.5 | 0.0198 | NR | MBI5827122.1 | 2026735 | g32894 | i0 | 34.6 | 0.634146341463415 | 52 | 25 | 52.4 | 1 | 20 | 148 | 140 | 191 | MBI5827122.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 156 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29113551 | 29113551 | PRJNA485080_P_NODE_24148_length_250_cov_0.870056_g24054_i0 | PRJNA485080 | 24148 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 91.3 | 7.91e-20 | NR | MBS1151255.1 | 2484252 | g24054 | i0 | 65.2 | 7.608 | 66 | 23 | 79.2 | 0 | 53 | 250 | 9 | 74 | MBS1151255.1 oxidoreductase [Myxococcaceae bacterium] | diamond | 1902 | 91.7 | 0.995637949836423 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 30613303 | 30613303 | PRJNA485080_P_NODE_17453_length_276_cov_1.492611_g17359_i0 | PRJNA485080 | 17453 | 276 | 1.492611 | 4.11960636 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 43.1 | 0.0429 | NR | WP_169507605.1 | 2567896 | g17359 | i0 | 35.2 | 0.58695652173913 | 54 | 24 | 46.7 | 2 | 10 | 138 | 868 | 921 | WP_169507605.1 MopE-related protein [Polyangium aurulentum] | diamond | 162 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 31403682 | 31403682 | PRJNA485080_P_NODE_30236_length_247_cov_0.885057_g30142_i0 | PRJNA485080 | 30236 | 247 | 0.885057 | 2.18609079 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 48.1 | 4.55e-4 | NR | HEY8206058.1 | 2484252 | g30142 | i0 | 37.8 | 0.995951417004049 | 82 | 42 | 92.3 | 2 | 9 | 236 | 139 | 217 | HEY8206058.1 M35 family metallo-endopeptidase [Myxococcaceae bacterium] | diamond | 246 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32258023 | 32258023 | PRJNA485080_P_NODE_10118_length_334_cov_1.180077_g10024_i0 | PRJNA485080 | 10118 | 334 | 1.180077 | 3.94145718 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 84 | 3.64e-16 | NR | MBL8787667.1 | 2026735 | g10024 | i0 | 40.2 | 1.82335329341317 | 102 | 59 | 90.7 | 2 | 1 | 303 | 162 | 262 | MBL8787667.1 FAD-binding oxidoreductase [Deltaproteobacteria bacterium] | diamond | 609 | 84 | 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);;