contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA886442" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3412589 | 3412589 | PRJNA886442_P_NODE_11043_length_251_cov_1.544944_g10879_i0 | PRJNA886442 | 11043 | 251 | 1.544944 | 3.87780944 | Myxococcia | 32015 | Bacteria | Bacteria | 61.2 | 9.94e-10 | NR | MBN9167310.1 | 2026763 | g10879 | i0 | 66.7 | 1.97211155378486 | 42 | 14 | 50.2 | 0 | 250 | 125 | 81 | 122 | MBN9167310.1 NAD(+) kinase [Myxococcales bacterium] | diamond | 495 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 11065552 | 11065552 | PRJNA886442_P_NODE_9_length_13403_cov_5.153938_g1_i3 | PRJNA886442 | 9 | 13403 | 5.153938 | 690.78231014 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 388 | 9.839999999999998e-118 | NR | RJO66932.1 | 2026763 | g1 | i3 | 63.6 | 0.0738640602850108 | 330 | 108 | 7.3 | 6 | 5773 | 6750 | 6 | 327 | RJO66932.1 MAG: hypothetical protein C4523_10580 [Myxococcales bacterium] | diamond | 990 | 388 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26928924 | 26928924 | PRJNA886442_P_NODE_13222_length_246_cov_0.901734_g13058_i0 | PRJNA886442 | 13222 | 246 | 0.901734 | 2.21826564 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 124 | 3.659999999999999e-31 | NR | MCW5831902.1 | 1971228 | g13058 | i0 | 70.7 | 1.85365853658537 | 82 | 24 | 100 | 0 | 1 | 246 | 301 | 382 | MCW5831902.1 SDR family oxidoreductase [Labilithrix sp.] | diamond | 456 | 124 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 27149836 | 27149836 | PRJNA886442_P_NODE_11382_length_251_cov_0.876404_g11218_i0 | PRJNA886442 | 11382 | 251 | 0.876404 | 2.19977404 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 147 | 4.63e-39 | NR | MBX3225638.1 | 1971228 | g11218 | i0 | 86.7 | 0.99203187250996006 | 83 | 11 | 99.2 | 0 | 2 | 250 | 166 | 248 | MBX3225638.1 pyruvate, phosphate dikinase [Labilithrix sp.] | diamond | 249 | 147 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 27434920 | 27434920 | PRJNA886442_P_NODE_13543_length_246_cov_0.901734_g13379_i0 | PRJNA886442 | 13543 | 246 | 0.901734 | 2.21826564 | Myxococcales bacterium 68-2 | 2026763 | Bacteria | Bacteria | 102 | 2.1699999999999994e-24 | NR | OJY28166.1 | 1895795 | g13379 | i0 | 69.4 | 0.75609756097561 | 62 | 19 | 75.6 | 0 | 243 | 58 | 158 | 219 | OJY28166.1 MAG: hypothetical protein BGO98_21730 [Myxococcales bacterium 68-20] | diamond | 186 | 102 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium 68-20 | ||||
| 28066138 | 28066138 | PRJNA886442_P_NODE_13345_length_246_cov_0.901734_g13181_i0 | PRJNA886442 | 13345 | 246 | 0.901734 | 2.21826564 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 61.2 | 3.72e-9 | NR | MBX3200493.1 | 1971228 | g13181 | i0 | 50.7 | 2.59756097560976 | 71 | 35 | 86.6 | 0 | 244 | 32 | 126 | 196 | MBX3200493.1 hypothetical protein [Labilithrix sp.] | diamond | 639 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29076691 | 29076691 | PRJNA886442_P_NODE_11648_length_250_cov_0.881356_g11484_i0 | PRJNA886442 | 11648 | 250 | 0.881356 | 2.20339 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 111 | 7.190000000000001e-27 | NR | MFO0658708.1 | 2268199 | g11484 | i0 | 65.1 | 0.996 | 83 | 29 | 99.6 | 0 | 1 | 249 | 189 | 271 | MFO0658708.1 phosphopantothenoylcysteine decarboxylase [Polyangiaceae bacterium] | diamond | 249 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29644462 | 29644462 | PRJNA886442_P_NODE_10790_length_252_cov_0.871508_g10626_i0 | PRJNA886442 | 10790 | 252 | 0.871508 | 2.19620016 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 102 | 2.51e-23 | NR | HSO35440.1 | 1971228 | g10626 | i0 | 71.6 | 1.5952380952381 | 67 | 19 | 79.8 | 0 | 2 | 202 | 470 | 536 | HSO35440.1 AgmX/PglI C-terminal domain-containing protein [Labilithrix sp.] | diamond | 402 | 102 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 29644474 | 29644474 | PRJNA886442_P_NODE_9750_length_259_cov_1.430108_g9586_i0 | PRJNA886442 | 9750 | 259 | 1.430108 | 3.70397972 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 75.1 | 3.76e-14 | NR | HMR10672.1 | 2268199 | g9586 | i0 | 53.5 | 1.74903474903475 | 71 | 32 | 82.2 | 1 | 222 | 10 | 73 | 142 | HMR10672.1 SDR family NAD(P)-dependent oxidoreductase [Polyangiaceae bacterium] | diamond | 453 | 75.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30118534 | 30118534 | PRJNA886442_P_NODE_15072_length_242_cov_0.923077_g14908_i0 | PRJNA886442 | 15072 | 242 | 0.923077 | 2.23384634 | Sandaracinaceae bacterium | 2510337 | Bacteria | Bacteria | 44.3 | 0.00503 | NR | MBK6578172.1 | 2510337 | g14908 | i0 | 37.5 | 0.892561983471074 | 72 | 40 | 83.1 | 1 | 33 | 233 | 15 | 86 | MBK6578172.1 hypothetical protein [Sandaracinaceae bacterium] | diamond | 216 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium | ||||
| 30213298 | 30213298 | PRJNA886442_P_NODE_6412_length_308_cov_2.872340_g6248_i0 | PRJNA886442 | 6412 | 308 | 2.87234 | 8.8468072 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 82.8 | 9.29e-18 | NR | MBX3207856.1 | 1971228 | g6248 | i0 | 43.1 | 1.60714285714286 | 116 | 48 | 97.4 | 2 | 3 | 302 | 2 | 115 | MBX3207856.1 hypothetical protein [Labilithrix sp.] | diamond | 495 | 82.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 30308708 | 30308708 | PRJNA886442_P_NODE_6992_length_298_cov_1.302222_g6828_i0 | PRJNA886442 | 6992 | 298 | 1.302222 | 3.88062156 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 44.3 | 0.0197 | NR | MEO6772471.1 | 2212474 | g6828 | i0 | 41.9 | 0.432885906040268 | 43 | 25 | 43.3 | 0 | 104 | 232 | 148 | 190 | MEO6772471.1 DUF1266 domain-containing protein [Kofleriaceae bacterium] | diamond | 129 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30655700 | 30655700 | PRJNA886442_P_NODE_14093_length_244_cov_0.912281_g13929_i0 | PRJNA886442 | 14093 | 244 | 0.912281 | 2.22596564 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 98.2 | 4.76e-22 | NR | HXS16031.1 | 2268199 | g13929 | i0 | 67.1 | 3.45491803278689 | 70 | 19 | 86.1 | 1 | 244 | 35 | 38 | 103 | HXS16031.1 glycosyltransferase [Polyangiaceae bacterium] | diamond | 843 | 98.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30971867 | 30971867 | PRJNA886442_P_NODE_8034_length_282_cov_1.444976_g7870_i0 | PRJNA886442 | 8034 | 282 | 1.444976 | 4.07483232 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 131 | 4.66e-33 | NR | HVJ91548.1 | 1971228 | g7870 | i0 | 73.1 | 2.90425531914894 | 93 | 25 | 98.9 | 0 | 3 | 281 | 428 | 520 | HVJ91548.1 ATP-dependent chaperone ClpB [Labilithrix sp.] | diamond | 819 | 131 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. |
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);;