contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA757618" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3283623 | 3283623 | PRJNA757618_P_NODE_18103_length_285_cov_1.278302_g17051_i0 | PRJNA757618 | 18103 | 285 | 1.278302 | 3.6431607 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 145 | 2.69e-39 | NR | HEX7665344.1 | 2268199 | g17051 | i0 | 76.6 | 4.94736842105263 | 94 | 18 | 98.9 | 1 | 283 | 2 | 147 | 236 | HEX7665344.1 amidophosphoribosyltransferase [Polyangiaceae bacterium] | diamond | 1410 | 145 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 7111046 | 7111046 | PRJNA757618_P_NODE_19646_length_278_cov_1.424390_g18594_i0 | PRJNA757618 | 19646 | 278 | 1.42439 | 3.9598042 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 83.2 | 3.46e-16 | NR | HTQ44961.1 | 2268199 | g18594 | i0 | 45.1 | 1.6294964028777 | 82 | 44 | 88.5 | 1 | 31 | 276 | 655 | 735 | HTQ44961.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 453 | 83.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 10131227 | 10131227 | PRJNA757618_P_NODE_46288_length_243_cov_0.905882_g45236_i0 | PRJNA757618 | 46288 | 243 | 0.905882 | 2.20129326 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 137 | 2.55e-36 | NR | HEX5066081.1 | 2818507 | g45236 | i0 | 87.7 | 1 | 81 | 10 | 100 | 0 | 243 | 1 | 293 | 373 | HEX5066081.1 amino acid permease [Myxococcota bacterium] | diamond | 243 | 137 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 16035391 | 16035391 | PRJNA757618_P_NODE_46953_length_242_cov_0.923077_g45901_i0 | PRJNA757618 | 46953 | 242 | 0.923077 | 2.23384634 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 143 | 3.71e-39 | NR | MDB4989328.1 | 2484252 | g45901 | i0 | 86.3 | 3.96694214876033 | 80 | 11 | 99.2 | 0 | 1 | 240 | 197 | 276 | MDB4989328.1 Alanine racemase [Myxococcaceae bacterium] | diamond | 960 | 143 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 19859458 | 19859458 | PRJNA757618_P_NODE_24596_length_259_cov_1.677419_g23544_i0 | PRJNA757618 | 24596 | 259 | 1.677419 | 4.34451521 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 126 | 1.46e-33 | NR | HET6584870.1 | 2545255 | g23544 | i0 | 68.2 | 1.01930501930502 | 88 | 25 | 98.5 | 1 | 257 | 3 | 174 | 261 | HET6584870.1 hypothetical protein [Nannocystaceae bacterium] | diamond | 264 | 126 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 27147334 | 27147334 | PRJNA757618_P_NODE_29942_length_251_cov_0.870787_g28890_i0 | PRJNA757618 | 29942 | 251 | 0.870787 | 2.18567537 | Byssovorax sp. | 2927945 | Bacteria | Bacteria | 63.9 | 1.4e-9 | NR | MEP7123274.1 | 2927945 | g28890 | i0 | 50.7 | 0.824701195219124 | 69 | 33 | 81.3 | 1 | 211 | 8 | 429 | 497 | MEP7123274.1 serine/threonine-protein kinase [Byssovorax sp.] | diamond | 207 | 63.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Byssovorax | Byssovorax sp. | |||
| 27842470 | 27842470 | PRJNA757618_P_NODE_26644_length_253_cov_0.866667_g25592_i0 | PRJNA757618 | 26644 | 253 | 0.866667 | 2.19266751 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 88.6 | 3.49e-19 | NR | HET6584971.1 | 2545255 | g25592 | i0 | 54.7 | 0.889328063241107 | 75 | 34 | 88.9 | 0 | 1 | 225 | 175 | 249 | HET6584971.1 hypothetical protein [Nannocystaceae bacterium] | diamond | 225 | 88.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 28000734 | 28000734 | PRJNA757618_P_NODE_28645_length_252_cov_0.865922_g27593_i0 | PRJNA757618 | 28645 | 252 | 0.865922 | 2.18212344 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 68.2 | 2.82e-11 | NR | MDJ0867148.1 | 2818507 | g27593 | i0 | 69.6 | 0.952380952380952 | 46 | 14 | 54.8 | 0 | 139 | 2 | 7 | 52 | MDJ0867148.1 alpha/beta fold hydrolase [Myxococcota bacterium] | diamond | 240 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28158626 | 28158626 | PRJNA757618_P_NODE_43645_length_244_cov_0.906433_g42593_i0 | PRJNA757618 | 43645 | 244 | 0.906433 | 2.21169652 | Chondromyces sp. | 3069217 | Bacteria | Bacteria | 84.7 | 6.29e-17 | NR | HSO21983.1 | 3069217 | g42593 | i0 | 46.2 | 1.93032786885246 | 78 | 42 | 95.9 | 0 | 8 | 241 | 25 | 102 | HSO21983.1 AMP-binding protein [Chondromyces sp.] | diamond | 471 | 84.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces sp. | |||
| 28568781 | 28568781 | PRJNA757618_P_NODE_17447_length_288_cov_1.344186_g16395_i0 | PRJNA757618 | 17447 | 288 | 1.344186 | 3.87125568 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 87.8 | 9.07e-18 | NR | MEO7113229.1 | 2268199 | g16395 | i0 | 57.1 | 0.875 | 84 | 36 | 87.5 | 0 | 3 | 254 | 130 | 213 | MEO7113229.1 PAS domain S-box protein [Polyangiaceae bacterium] | diamond | 252 | 87.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28789726 | 28789726 | PRJNA757618_P_NODE_43967_length_244_cov_0.906433_g42915_i0 | PRJNA757618 | 43967 | 244 | 0.906433 | 2.21169652 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 73.2 | 5.12e-13 | NR | MEO8797313.1 | 2268199 | g42915 | i0 | 70.2 | 2.05327868852459 | 57 | 17 | 70.1 | 0 | 238 | 68 | 283 | 339 | MEO8797313.1 PrsW family intramembrane metalloprotease [Polyangiaceae bacterium] | diamond | 501 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28957775 | 28957775 | PRJNA757618_P_NODE_30468_length_251_cov_0.865169_g29416_i0 | PRJNA757618 | 30468 | 251 | 0.865169 | 2.17157419 | Myxococcota | 2818505 | Bacteria | Bacteria | 156 | 3.21e-42 | NR | WP_136936148.1 | 889272 | g29416 | i0 | 85.5 | 12.8844621513944 | 83 | 12 | 99.2 | 0 | 250 | 2 | 397 | 479 | WP_136936148.1 alpha-amylase family glycosyl hydrolase, partial [Polyangium fumosum] | diamond | 3234 | 157 | 0.993630573248408 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium fumosum | |||
| 29642053 | 29642053 | PRJNA757618_P_NODE_35170_length_248_cov_0.891429_g34118_i0 | PRJNA757618 | 35170 | 248 | 0.891429 | 2.21074392 | Enhygromyxa salina | 215803 | Bacteria | Bacteria | 48.9 | 2.53e-4 | NR | WP_146660934.1 | 215803 | g34118 | i0 | 78.6 | 0.338709677419355 | 28 | 6 | 33.9 | 0 | 2 | 85 | 333 | 360 | WP_146660934.1 hypothetical protein [Enhygromyxa salina] | diamond | 84 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa salina | |||
| 29863356 | 29863356 | PRJNA757618_P_NODE_41051_length_245_cov_0.906977_g39999_i0 | PRJNA757618 | 41051 | 245 | 0.906977 | 2.22209365 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 123 | 1.98e-30 | NR | HKY34627.1 | 2268199 | g39999 | i0 | 71.6 | 0.991836734693878 | 81 | 23 | 99.2 | 0 | 245 | 3 | 1378 | 1458 | HKY34627.1 RHS repeat-associated core domain-containing protein [Polyangiaceae bacterium] | diamond | 243 | 123 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29926735 | 29926735 | PRJNA757618_P_NODE_44971_length_243_cov_0.917647_g43919_i0 | PRJNA757618 | 44971 | 243 | 0.917647 | 2.22988221 | Paraliomyxa miuraensis | 376150 | Bacteria | Bacteria | 131 | 4.98e-34 | NR | WP_266215323.1 | 376150 | g43919 | i0 | 71.3 | 2.96296296296296 | 80 | 23 | 98.8 | 0 | 241 | 2 | 226 | 305 | WP_266215323.1 vWA domain-containing protein [Paraliomyxa miuraensis] | diamond | 720 | 131 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Paraliomyxa | Paraliomyxa miuraensis | |||
| 30937766 | 30937766 | PRJNA757618_P_NODE_28794_length_252_cov_0.865922_g27742_i0 | PRJNA757618 | 28794 | 252 | 0.865922 | 2.18212344 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 53.1 | 9.11e-6 | NR | MBS2016299.1 | 2026735 | g27742 | i0 | 41.9 | 0.880952380952381 | 74 | 43 | 88.1 | 0 | 19 | 240 | 168 | 241 | MBS2016299.1 sigma 54-interacting transcriptional regulator [Deltaproteobacteria bacterium] | diamond | 222 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31443387 | 31443387 | PRJNA757618_P_NODE_43816_length_244_cov_0.906433_g42764_i0 | PRJNA757618 | 43816 | 244 | 0.906433 | 2.21169652 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 108 | 5.36e-26 | NR | MBK8257280.1 | 2268199 | g42764 | i0 | 66.3 | 1.95491803278689 | 80 | 27 | 98.4 | 0 | 241 | 2 | 86 | 165 | MBK8257280.1 NADH:flavin oxidoreductase [Polyangiaceae bacterium] | diamond | 477 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31959280 | 31959280 | PRJNA757618_P_NODE_46197_length_243_cov_0.905882_g45145_i0 | PRJNA757618 | 46197 | 243 | 0.905882 | 2.20129326 | Myxococcia | 32015 | Bacteria | Bacteria | 132 | 8.64e-36 | NR | MFO0679721.1 | 2268199 | g45145 | i0 | 80 | 5.92592592592593 | 80 | 16 | 98.8 | 0 | 242 | 3 | 166 | 245 | MFO0679721.1 prolipoprotein diacylglyceryl transferase [Polyangiaceae bacterium] | diamond | 1440 | 133 | 0.992481203007519 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32180947 | 32180947 | PRJNA757618_P_NODE_41098_length_245_cov_0.906977_g40046_i0 | PRJNA757618 | 41098 | 245 | 0.906977 | 2.22209365 | Bacteria | 2 | Bacteria | Bacteria | 100 | 9.67e-23 | NR | MCC6999212.1 | 2026735 | g40046 | i0 | 62.5 | 1.93469387755102 | 80 | 29 | 98 | 1 | 242 | 3 | 41 | 119 | MCC6999212.1 DUF1552 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 474 | 100 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32329544 | 32329544 | PRJNA757618_P_NODE_42859_length_244_cov_0.912281_g41807_i0 | PRJNA757618 | 42859 | 244 | 0.912281 | 2.22596564 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 67.8 | 5.46e-11 | NR | HEX2734568.1 | 2268199 | g41807 | i0 | 96.8 | 3.76229508196721 | 31 | 1 | 38.1 | 0 | 3 | 95 | 565 | 595 | HEX2734568.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 918 | 67.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;