contig_metadata
21 rows where bioproject = "PRJNA792582", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2052758 | 2052758 | PRJNA792582_P_NODE_21702_length_370_cov_0.973064_g20888_i0 | PRJNA792582 | 21702 | 370 | 0.973064 | 3.6003368 | Pajaroellobacter abortibovis | 1882918 | Bacteria | Bacteria | 645 | 1.2699999999999995e-180 | NTclustered | gi|1127377833|gb|CP016908.1| | 1882918 | g20888 | i0 | 98.108 | 134.078378378378 | 370 | 7 | 100 | 0 | 1 | 370 | 1551251 | 1550882 | Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome | blastn | 49609 | 645 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Pajaroellobacter | Pajaroellobacter abortibovis | |||
| 2491055 | 2491055 | PRJNA792582_P_NODE_55422_length_245_cov_0.895349_g54608_i0 | PRJNA792582 | 55422 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 375 | 1.16e-99 | NTclustered | gi|47778677|gb|AY033403.2| | 34 | g54608 | i0 | 93.725 | 24.0081632653061 | 255 | 6 | 100 | 10 | 1 | 245 | 2419 | 2673 | Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds | blastn | 5882 | 377 | 0.994694960212202 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 5880338 | 5880338 | PRJNA792582_P_NODE_28825_length_322_cov_0.763052_g28011_i0 | PRJNA792582 | 28825 | 322 | 0.763052 | 2.45702744 | Myxococcus xanthus | 34 | Bacteria | Bacteria | 586 | 6.699999999999998e-163 | NTclustered | gi|13959812|gb|AY033405.1| | 34 | g28011 | i0 | 99.383 | 100.006211180124 | 324 | 0 | 100 | 2 | 1 | 322 | 476 | 799 | Myxococcus xanthus USC5-1p and USC5-2p genes, complete cds | blastn | 32202 | 586 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 9705341 | 9705341 | PRJNA792582_P_NODE_45248_length_263_cov_2.231579_g44434_i0 | PRJNA792582 | 45248 | 263 | 2.231579 | 5.86905277 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 226 | 1.3399999999999998e-54 | NTclustered | gi|1566495190|gb|CP012670.1| | 56 | g44434 | i0 | 91.018 | 55.9125475285171 | 167 | 15 | 63 | 0 | 97 | 263 | 7711872 | 7711706 | Sorangium cellulosum strain So ceGT47 chromosome, complete genome | blastn | 14705 | 226 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 16518485 | 16518485 | PRJNA792582_P_NODE_55413_length_245_cov_0.895349_g54599_i0 | PRJNA792582 | 55413 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 156 | 1.64e-33 | NTclustered | gi|2621786039|emb|OY782497.1| | 2818507 | g54599 | i0 | 78.862 | 18.1551020408163 | 246 | 40 | 99 | 11 | 3 | 245 | 2487536 | 2487772 | MAG: Myxococcota bacterium isolate 0c961c99-2a7e-4543-b017-306f11f6fc1d genome assembly, chromosome: 1 | blastn | 4448 | 156 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 17355319 | 17355319 | PRJNA792582_P_NODE_42914_length_270_cov_1.284264_g42100_i0 | PRJNA792582 | 42914 | 270 | 1.284264 | 3.4675128 | Pseudomyxococcus hansupus | 1297742 | Bacteria | Bacteria | 169 | 2.36e-37 | NTclustered | gi|891158403|gb|CP012109.1| | 1297742 | g42100 | i0 | 79.916 | 11.1740740740741 | 239 | 41 | 87 | 6 | 37 | 270 | 4240520 | 4240756 | Myxococcus hansupus strain mixupus chromosome, complete genome | blastn | 3017 | 169 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pseudomyxococcus | Pseudomyxococcus hansupus | ||
| 21179595 | 21179595 | PRJNA792582_P_NODE_49357_length_251_cov_2.589888_g48543_i0 | PRJNA792582 | 49357 | 251 | 2.589888 | 6.50061888 | Nannocystis punicea | 2995304 | Bacteria | Bacteria | 200 | 7.679999999999999e-47 | NTclustered | gi|2415023655|gb|CP114040.1| | 2995304 | g48543 | i0 | 82.278 | 90.5697211155378 | 237 | 36 | 94 | 6 | 2 | 235 | 5862918 | 5862685 | Nannocystis poenicansa strain FL3 chromosome, complete genome | blastn | 22733 | 200 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis punicea | |||
| 23730091 | 23730091 | PRJNA792582_P_NODE_56859_length_244_cov_0.900585_g56045_i0 | PRJNA792582 | 56859 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 4.75e-7 | NR | WP_012236970.1 | 56 | g56045 | i0 | 43.8 | 6.70081967213115 | 73 | 41 | 89.8 | 0 | 225 | 7 | 97 | 169 | WP_012236970.1 serine/threonine protein kinase [Sorangium cellulosum] | diamond | 1635 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 25003651 | 25003651 | PRJNA792582_P_NODE_57280_length_243_cov_1.264706_g56466_i0 | PRJNA792582 | 57280 | 243 | 1.264706 | 3.07323558 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 274 | 4.29e-69 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g56466 | i0 | 86.939 | 106.987654320988 | 245 | 30 | 100 | 2 | 1 | 243 | 443435 | 443191 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 25998 | 274 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 26927207 | 26927207 | PRJNA792582_P_NODE_40182_length_277_cov_1.588235_g39368_i0 | PRJNA792582 | 40182 | 277 | 1.588235 | 4.39941095 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 48.5 | 5.45e-5 | NR | MEC8422185.1 | 2818507 | g39368 | i0 | 40.2 | 0.888086642599278 | 82 | 49 | 88.8 | 0 | 26 | 271 | 4 | 85 | MEC8422185.1 hypothetical protein [Myxococcota bacterium] | diamond | 246 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27496228 | 27496228 | PRJNA792582_P_NODE_50423_length_250_cov_1.740113_g49609_i0 | PRJNA792582 | 50423 | 250 | 1.740113 | 4.3502825 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 50.1 | 7.66e-6 | NR | KYF55844.1 | 56 | g49609 | i0 | 52.4 | 0.504 | 42 | 17 | 46.8 | 1 | 2 | 118 | 32 | 73 | KYF55844.1 hypothetical protein BE08_04980 [Sorangium cellulosum] | diamond | 126 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 27780465 | 27780465 | PRJNA792582_P_NODE_51684_length_249_cov_0.875000_g50870_i0 | PRJNA792582 | 51684 | 249 | 0.875 | 2.17875 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 62.4 | 4.67e-9 | NR | HWL88207.1 | 2268199 | g50870 | i0 | 50.9 | 1.26506024096386 | 55 | 27 | 66.3 | 0 | 83 | 247 | 60 | 114 | HWL88207.1 thiamine pyrophosphate-binding protein [Polyangiaceae bacterium] | diamond | 315 | 62.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28885298 | 28885298 | PRJNA792582_P_NODE_22428_length_364_cov_1.202749_g21614_i0 | PRJNA792582 | 22428 | 364 | 1.202749 | 4.37800636 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 69.7 | 6.78e-12 | NR | MRR56327.1 | 2026735 | g21614 | i0 | 69.8 | 1.1043956043956 | 43 | 13 | 35.4 | 0 | 355 | 227 | 138 | 180 | MRR56327.1 peptidoglycan-associated lipoprotein Pal [Deltaproteobacteria bacterium] | diamond | 402 | 69.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29043450 | 29043450 | PRJNA792582_P_NODE_43248_length_269_cov_1.397959_g42434_i0 | PRJNA792582 | 43248 | 269 | 1.397959 | 3.76050971 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 44.3 | 0.0153 | NR | MCA9522042.1 | 2026763 | g42434 | i0 | 34.5 | 1.6728624535316 | 84 | 41 | 87 | 3 | 257 | 24 | 879 | 954 | MCA9522042.1 tetratricopeptide repeat protein [Myxococcales bacterium] | diamond | 450 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29769388 | 29769388 | PRJNA792582_P_NODE_47391_length_257_cov_1.869565_g46577_i0 | PRJNA792582 | 47391 | 257 | 1.869565 | 4.80478205 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.5 | 0.0227 | NR | HEX2870986.1 | 2268199 | g46577 | i0 | 38.5 | 0.75875486381323 | 65 | 34 | 68.9 | 2 | 187 | 11 | 158 | 222 | HEX2870986.1 c-type cytochrome [Polyangiaceae bacterium] | diamond | 195 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30653962 | 30653962 | PRJNA792582_P_NODE_61033_length_210_cov_4.058394_g60219_i0 | PRJNA792582 | 61033 | 210 | 4.058394 | 8.5226274 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 43.1 | 0.0172 | NR | MEO7732607.1 | 2212474 | g60219 | i0 | 45.5 | 0.628571428571429 | 44 | 17 | 62.9 | 2 | 142 | 11 | 338 | 374 | MEO7732607.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 132 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31096333 | 31096333 | PRJNA792582_P_NODE_44895_length_264_cov_2.246073_g44081_i0 | PRJNA792582 | 44895 | 264 | 2.246073 | 5.92963272 | Cystobacter sp. | 1965334 | Bacteria | Bacteria | 42 | 0.0426 | NR | MET0405238.1 | 1965334 | g44081 | i0 | 35.8 | 0.761363636363636 | 67 | 43 | 76.1 | 0 | 52 | 252 | 9 | 75 | MET0405238.1 hypothetical protein [Cystobacter sp.] | diamond | 201 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter sp. | ||
| 31285958 | 31285958 | PRJNA792582_P_NODE_35915_length_288_cov_2.330233_g35101_i0 | PRJNA792582 | 35915 | 288 | 2.330233 | 6.71107104 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.9 | 0.0242 | NR | MEB2310536.1 | 2268199 | g35101 | i0 | 63.9 | 0.375 | 36 | 10 | 36.5 | 2 | 254 | 150 | 187 | 220 | MEB2310536.1 apolipoprotein N-acyltransferase [Polyangiaceae bacterium] | diamond | 108 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31918700 | 31918700 | PRJNA792582_P_NODE_36217_length_288_cov_0.990698_g35403_i0 | PRJNA792582 | 36217 | 288 | 0.990698 | 2.85321024 | Archangium sp. | 1872627 | Bacteria | Bacteria | 44.3 | 0.0167 | NR | WP_414641468.1 | 1872627 | g35403 | i0 | 34.8 | 0.927083333333333 | 89 | 36 | 90.6 | 4 | 272 | 12 | 36 | 104 | WP_414641468.1 RCC1 domain-containing protein, partial [Archangium sp.] | diamond | 267 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 32140244 | 32140244 | PRJNA792582_P_NODE_54518_length_246_cov_0.890173_g53704_i0 | PRJNA792582 | 54518 | 246 | 0.890173 | 2.18982558 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 99 | 4.21e-22 | NR | MCA1826806.1 | 2026763 | g53704 | i0 | 57.3 | 5 | 82 | 35 | 100 | 0 | 1 | 246 | 225 | 306 | MCA1826806.1 2-oxo acid dehydrogenase subunit E2 [Myxococcales bacterium] | diamond | 1230 | 99 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32803412 | 32803412 | PRJNA792582_P_NODE_60620_length_229_cov_2.833333_g59806_i0 | PRJNA792582 | 60620 | 229 | 2.833333 | 6.48833257 | Paraliomyxa miuraensis | 376150 | Bacteria | Bacteria | 125 | 9.74e-34 | NR | WP_266221121.1 | 376150 | g59806 | i0 | 84.2 | 0.995633187772926 | 76 | 12 | 99.6 | 0 | 229 | 2 | 143 | 218 | WP_266221121.1 queuosine precursor transporter [Paraliomyxa miuraensis] | diamond | 228 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Paraliomyxa | Paraliomyxa miuraensis |
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);;