contig_metadata
12 rows where bioproject = "PRJNA640143", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 609609 | 609609 | PRJNA640143_S_NODE_11861_length_251_cov_12.836449_g11651_i0 | PRJNA640143 | 11861 | 251 | 12.836449 | 32.21948699 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 281 | 2.66e-71 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g11651 | i0 | 90 | 197.362549800797 | 220 | 18 | 87 | 2 | 1 | 218 | 7089179 | 7088962 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 49538 | 281 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 13909336 | 13909336 | PRJNA640143_S_NODE_16951_length_212_cov_5.097143_g16741_i0 | PRJNA640143 | 16951 | 212 | 5.097143 | 10.80594316 | Myxococcia | 32015 | Bacteria | Bacteria | 165 | 2.29e-36 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g16741 | i0 | 83.516 | 76.7216981132076 | 182 | 25 | 84 | 3 | 34 | 212 | 3941790 | 3941969 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 16265 | 165 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 22286721 | 22286721 | PRJNA640143_S_NODE_11618_length_254_cov_1.764977_g11408_i0 | PRJNA640143 | 11618 | 254 | 1.764977 | 4.48304158 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 403 | 5.53e-108 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g11408 | i0 | 95.276 | 143.484251968504 | 254 | 12 | 100 | 0 | 1 | 254 | 7089451 | 7089198 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 36445 | 403 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 27302396 | 27302396 | PRJNA640143_S_NODE_2943_length_462_cov_1.623529_g2755_i0 | PRJNA640143 | 2943 | 462 | 1.623529 | 7.50070398 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 48.1 | 0.0049 | NR | MBI3182495.1 | 2026763 | g2755 | i0 | 39.7 | 0.376623376623377 | 58 | 35 | 37.7 | 0 | 31 | 204 | 993 | 1050 | MBI3182495.1 hypothetical protein [Myxococcales bacterium] | diamond | 174 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28186200 | 28186200 | PRJNA640143_S_NODE_9746_length_275_cov_51.777311_g9536_i0 | PRJNA640143 | 9746 | 275 | 51.777311 | 142.38760525 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52 | 3.1e-5 | NR | MCX5876336.1 | 2026735 | g9536 | i0 | 35.4 | 0.861818181818182 | 79 | 49 | 84 | 2 | 231 | 1 | 142 | 220 | MCX5876336.1 AAA domain-containing protein [Deltaproteobacteria bacterium] | diamond | 237 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29051594 | 29051594 | PRJNA640143_S_NODE_30228_length_157_cov_2.716667_g30018_i0 | PRJNA640143 | 30228 | 157 | 2.716667 | 4.26516719 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.1 | 5.16e-7 | NR | MBW2466913.1 | 2026735 | g30018 | i0 | 66.7 | 1.35668789808917 | 36 | 12 | 68.8 | 0 | 35 | 142 | 457 | 492 | MBW2466913.1 GAF domain-containing protein [Deltaproteobacteria bacterium] | diamond | 213 | 55.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30681105 | 30681105 | PRJNA640143_S_NODE_5573_length_351_cov_3.238854_g5363_i0 | PRJNA640143 | 5573 | 351 | 3.238854 | 11.36837754 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 53.1 | 2.79e-5 | NR | HEX4516707.1 | 2268199 | g5363 | i0 | 66.7 | 0.256410256410256 | 30 | 10 | 25.6 | 0 | 238 | 327 | 421 | 450 | HEX4516707.1 glycoside hydrolase family 43 protein [Polyangiaceae bacterium] | diamond | 90 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30776218 | 30776218 | PRJNA640143_S_NODE_14894_length_226_cov_1.719577_g14684_i0 | PRJNA640143 | 14894 | 226 | 1.719577 | 3.88624402 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 78.6 | 7.08e-15 | NR | MSP61786.1 | 2026763 | g14684 | i0 | 63.3 | 0.650442477876106 | 49 | 18 | 65 | 0 | 32 | 178 | 380 | 428 | MSP61786.1 argininosuccinate lyase [Myxococcales bacterium] | diamond | 147 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32135936 | 32135936 | PRJNA640143_S_NODE_23478_length_182_cov_1.441379_g23268_i0 | PRJNA640143 | 23478 | 182 | 1.441379 | 2.62330978 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 57.4 | 1.12e-7 | NR | HXW60618.1 | 2818507 | g23268 | i0 | 50.8 | 0.972527472527473 | 59 | 29 | 97.3 | 0 | 182 | 6 | 433 | 491 | HXW60618.1 methylmalonyl-CoA mutase family protein [Myxococcota bacterium] | diamond | 177 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32388933 | 32388933 | PRJNA640143_S_NODE_24039_length_180_cov_1.363636_g23829_i0 | PRJNA640143 | 24039 | 180 | 1.363636 | 2.4545448 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 58.9 | 3.05e-8 | NR | MBK6921759.1 | 2026735 | g23829 | i0 | 49.1 | 3.6 | 57 | 28 | 95 | 1 | 8 | 178 | 496 | 551 | MBK6921759.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 648 | 58.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32830684 | 32830684 | PRJNA640143_S_NODE_23740_length_181_cov_1.625000_g23530_i0 | PRJNA640143 | 23740 | 181 | 1.625 | 2.94125 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 73.6 | 1.58e-13 | NR | GMV42498.1 | 2026763 | g23530 | i0 | 59.3 | 16.1602209944751 | 59 | 24 | 97.8 | 0 | 181 | 5 | 281 | 339 | GMV42498.1 MAG: hypothetical protein AMXMBFR64_42140 [Myxococcales bacterium] | diamond | 2925 | 73.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32893469 | 32893469 | PRJNA640143_S_NODE_6440_length_329_cov_4.181507_g6230_i0 | PRJNA640143 | 6440 | 329 | 4.181507 | 13.75715803 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 90.9 | 1.75e-19 | NR | MBK8241707.1 | 2026735 | g6230 | i0 | 51.3 | 0.711246200607903 | 78 | 38 | 71.1 | 0 | 298 | 65 | 191 | 268 | MBK8241707.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 234 | 90.9 | 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);;