contig_metadata
24 rows where bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144562 | 144562 | PRJEB83711_P_NODE_69121_length_247_cov_0.896552_g68855_i0 | PRJEB83711 | 69121 | 247 | 0.896552 | 2.21448344 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 424 | 4.1099999999999996e-114 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g68855 | i0 | 97.571 | 141.923076923077 | 247 | 6 | 100 | 0 | 1 | 247 | 3942662 | 3942416 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 35055 | 424 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 2693968 | 2693968 | PRJEB83711_P_NODE_36503_length_300_cov_1.030837_g36237_i0 | PRJEB83711 | 36503 | 300 | 1.030837 | 3.092511 | Myxococcus stipitatus | 83455 | Bacteria | Bacteria | 331 | 3.2e-86 | NTclustered | gi|2722781719|gb|CP102770.1| | 83455 | g36237 | i0 | 91.057 | 33.7066666666667 | 246 | 20 | 99 | 2 | 55 | 299 | 8475741 | 8475985 | Myxococcus stipitatus strain YRE12 chromosome, complete genome | blastn | 10112 | 331 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 3549487 | 3549487 | PRJEB83711_P_NODE_74383_length_244_cov_0.912281_g74117_i0 | PRJEB83711 | 74383 | 244 | 0.912281 | 2.22596564 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 71.6 | 2.41e-12 | NR | MFO0575828.1 | 3058050 | g74117 | i0 | 43.2 | 0.995901639344262 | 81 | 46 | 99.6 | 0 | 243 | 1 | 12 | 92 | MFO0575828.1 AAA-like domain-containing protein [Polyangia bacterium] | diamond | 243 | 71.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 3970236 | 3970236 | PRJEB83711_P_NODE_44324_length_279_cov_1.145631_g44058_i0 | PRJEB83711 | 44324 | 279 | 1.145631 | 3.19631049 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 91.6 | 5.45e-14 | NTclustered | gi|161158851|emb|AM746676.1| | 448385 | g44058 | i0 | 76.667 | 1.93906810035842 | 180 | 32 | 63 | 8 | 95 | 269 | 4987441 | 4987615 | Sorangium cellulosum 'So ce 56' complete genome | blastn | 541 | 91.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 7797220 | 7797220 | PRJEB83711_P_NODE_78387_length_242_cov_0.923077_g78121_i0 | PRJEB83711 | 78387 | 242 | 0.923077 | 2.23384634 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 246 | 9.32e-61 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g78121 | i0 | 85.417 | 369.648760330579 | 240 | 32 | 98 | 3 | 1 | 238 | 9038215 | 9037977 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 89455 | 246 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 10347749 | 10347749 | PRJEB83711_P_NODE_74849_length_244_cov_0.912281_g74583_i0 | PRJEB83711 | 74849 | 244 | 0.912281 | 2.22596564 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 58.4 | 4.73e-4 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g74583 | i0 | 89.583 | 0.19672131147541 | 48 | 2 | 20 | 3 | 23 | 70 | 7085005 | 7085049 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 48 | 58.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 11623264 | 11623264 | PRJEB83711_P_NODE_74890_length_244_cov_0.912281_g74624_i0 | PRJEB83711 | 74890 | 244 | 0.912281 | 2.22596564 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 230 | 9.47e-56 | NTclustered | gi|2183633570|gb|CP070225.1| | 927083 | g74624 | i0 | 84.146 | 97.8606557377049 | 246 | 29 | 99 | 10 | 4 | 244 | 3641588 | 3641348 | Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence | blastn | 23878 | 230 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 15447101 | 15447101 | PRJEB83711_P_NODE_61293_length_251_cov_0.876404_g61027_i0 | PRJEB83711 | 61293 | 251 | 0.876404 | 2.19977404 | Archangium gephyra | 48 | Bacteria | Bacteria | 291 | 4.43e-74 | NTclustered | gi|2809295724|gb|CP102578.1| | 48 | g61027 | i0 | 87.649 | 91.1195219123506 | 251 | 29 | 99 | 2 | 2 | 251 | 4305531 | 4305780 | Archangium gephyra strain SDU49 chromosome, complete genome | blastn | 22871 | 291 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 18850538 | 18850538 | PRJEB83711_P_NODE_68195_length_247_cov_1.586207_g67929_i0 | PRJEB83711 | 68195 | 247 | 1.586207 | 3.91793129 | Myxococcaceae | 31 | Bacteria | Bacteria | 407 | 4.14e-109 | NTclustered | gi|441484664|gb|CP004025.1| | 1278073 | g67929 | i0 | 96.356 | 49.6842105263158 | 247 | 9 | 100 | 0 | 1 | 247 | 2041026 | 2040780 | Myxococcus stipitatus DSM 14675, complete genome | blastn | 12272 | 411 | 0.990267639902676 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 27097497 | 27097497 | PRJEB83711_P_NODE_70502_length_246_cov_0.901734_g70236_i0 | PRJEB83711 | 70502 | 246 | 0.901734 | 2.21826564 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 64.3 | 4.75e-10 | NR | MBN9165273.1 | 2026763 | g70236 | i0 | 90.3 | 0.378048780487805 | 31 | 3 | 37.8 | 0 | 2 | 94 | 216 | 246 | MBN9165273.1 HAD-IA family hydrolase [Myxococcales bacterium] | diamond | 93 | 64.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27279945 | 27279945 | PRJEB83711_P_NODE_66743_length_248_cov_0.891429_g66477_i0 | PRJEB83711 | 66743 | 248 | 0.891429 | 2.21074392 | Anaeromyxobacter | 161492 | Bacteria | Bacteria | 79.3 | 3.53e-16 | NR | WP_012632676.1 | 161493 | g66477 | i0 | 71.4 | 3.61693548387097 | 63 | 12 | 71.4 | 2 | 246 | 70 | 127 | 187 | WP_012632676.1 J domain-containing protein [Anaeromyxobacter dehalogenans] | diamond | 897 | 79.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter dehalogenans | ||
| 28392390 | 28392390 | PRJEB83711_P_NODE_39546_length_290_cov_1.437788_g39280_i0 | PRJEB83711 | 39546 | 290 | 1.437788 | 4.1695852 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 108 | 3.63e-25 | NR | HTV22624.1 | 2268199 | g39280 | i0 | 63 | 0.951724137931034 | 92 | 34 | 95.2 | 0 | 290 | 15 | 1220 | 1311 | HTV22624.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 276 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28582003 | 28582003 | PRJEB83711_P_NODE_73247_length_245_cov_0.906977_g72981_i0 | PRJEB83711 | 73247 | 245 | 0.906977 | 2.22209365 | Myxococcales bacterium 68-2 | 2026763 | Bacteria | Bacteria | 109 | 7.99e-26 | NR | OJY29499.1 | 1895795 | g72981 | i0 | 80 | 0.73469387755102 | 60 | 12 | 73.5 | 0 | 3 | 182 | 486 | 545 | OJY29499.1 MAG: hypothetical protein BGO98_47465 [Myxococcales bacterium 68-20] | diamond | 180 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium 68-20 | ||||
| 28739737 | 28739737 | PRJEB83711_P_NODE_76107_length_243_cov_1.282353_g75841_i0 | PRJEB83711 | 76107 | 243 | 1.282353 | 3.11611779 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 72.8 | 9.77e-13 | NR | HSO31499.1 | 1971228 | g75841 | i0 | 58.9 | 1.38271604938272 | 56 | 23 | 69.1 | 0 | 168 | 1 | 15 | 70 | HSO31499.1 serine/threonine-protein kinase [Labilithrix sp.] | diamond | 336 | 72.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 28865976 | 28865976 | PRJEB83711_P_NODE_77008_length_243_cov_0.917647_g76742_i0 | PRJEB83711 | 77008 | 243 | 0.917647 | 2.22988221 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.4 | 0.0409 | NR | MBA3501149.1 | 2026735 | g76742 | i0 | 38.8 | 0.827160493827161 | 67 | 40 | 82.7 | 1 | 201 | 1 | 106 | 171 | MBA3501149.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 201 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29268905 | 29268905 | PRJEB83711_P_NODE_55169_length_257_cov_1.505435_g54903_i0 | PRJEB83711 | 55169 | 257 | 1.505435 | 3.86896795 | Minicystis | 1649470 | Bacteria | Bacteria | 87.4 | 6.16e-18 | NR | APR78285.1 | 888845 | g54903 | i0 | 83 | 1.09727626459144 | 47 | 8 | 54.9 | 0 | 255 | 115 | 375 | 421 | APR78285.1 Putative Co/Zn/Cd efflux system membrane fusion protein [Minicystis rosea] | diamond | 282 | 88.2 | 0.99092970521542 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 29686637 | 29686637 | PRJEB83711_P_NODE_67770_length_248_cov_0.891429_g67504_i0 | PRJEB83711 | 67770 | 248 | 0.891429 | 2.21074392 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 110 | 5.17e-26 | NR | MFO0645555.1 | 3034171 | g67504 | i0 | 68.3 | 3.96774193548387 | 82 | 26 | 99.2 | 0 | 248 | 3 | 294 | 375 | MFO0645555.1 SpoIIE family protein phosphatase [Polyangiales bacterium] | diamond | 984 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30065826 | 30065826 | PRJEB83711_P_NODE_59972_length_252_cov_0.871508_g59706_i0 | PRJEB83711 | 59972 | 252 | 0.871508 | 2.19620016 | Minicystis sp. | 1971901 | Bacteria | Bacteria | 100 | 2.62e-22 | NR | MFT3772735.1 | 1971901 | g59706 | i0 | 59 | 4.92857142857143 | 83 | 34 | 98.8 | 0 | 251 | 3 | 459 | 541 | MFT3772735.1 hypothetical protein [Minicystis sp.] | diamond | 1242 | 100 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis sp. | |||
| 30508304 | 30508304 | PRJEB83711_P_NODE_79193_length_242_cov_0.923077_g78927_i0 | PRJEB83711 | 79193 | 242 | 0.923077 | 2.23384634 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 58.9 | 2.06e-8 | NR | MBK6515057.1 | 2268199 | g78927 | i0 | 90.9 | 0.409090909090909 | 33 | 3 | 40.9 | 0 | 144 | 242 | 1 | 33 | MBK6515057.1 DNA-binding response regulator [Polyangiaceae bacterium] | diamond | 99 | 58.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31101072 | 31101072 | PRJEB83711_P_NODE_47555_length_272_cov_1.241206_g47289_i0 | PRJEB83711 | 47555 | 272 | 1.241206 | 3.37608032 | Myxococcia | 32015 | Bacteria | Bacteria | 102 | 3.05e-25 | NR | MBP7681287.1 | 2026735 | g47289 | i0 | 63.2 | 4.19117647058824 | 76 | 28 | 83.8 | 0 | 229 | 2 | 1 | 76 | MBP7681287.1 phenylalanine--tRNA ligase subunit beta [Deltaproteobacteria bacterium] | diamond | 1140 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31424731 | 31424731 | PRJEB83711_P_NODE_41196_length_286_cov_1.314554_g40930_i0 | PRJEB83711 | 41196 | 286 | 1.314554 | 3.75962444 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 109 | 1.5800000000000002e-27 | NR | HKQ68454.1 | 2268199 | g40930 | i0 | 76.7 | 0.765734265734266 | 73 | 17 | 76.6 | 0 | 1 | 219 | 128 | 200 | HKQ68454.1 SRPBCC family protein [Polyangiaceae bacterium] | diamond | 219 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32120865 | 32120865 | PRJEB83711_P_NODE_26598_length_346_cov_0.930403_g26332_i0 | PRJEB83711 | 26598 | 346 | 0.930403 | 3.21919438 | unclassified Anaeromyxobacter | 2620896 | Bacteria | Bacteria | 44.7 | 0.00967 | NR | WP_242352140.1 | 2620896 | g26332 | i0 | 33.8 | 0.589595375722543 | 68 | 41 | 59 | 2 | 98 | 301 | 50 | 113 | WP_242352140.1 MULTISPECIES: very short patch repair endonuclease [unclassified Anaeromyxobacter] | diamond | 204 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | |||
| 32215728 | 32215728 | PRJEB83711_P_NODE_45078_length_277_cov_1.372549_g44812_i0 | PRJEB83711 | 45078 | 277 | 1.372549 | 3.80196073 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 49.7 | 1.83e-4 | NR | MDF3066778.1 | 2268199 | g44812 | i0 | 34.4 | 2.07942238267148 | 61 | 40 | 66.1 | 0 | 32 | 214 | 227 | 287 | MDF3066778.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 576 | 49.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32721168 | 32721168 | PRJEB83711_P_NODE_66260_length_248_cov_1.720000_g65994_i0 | PRJEB83711 | 66260 | 248 | 1.72 | 4.2656 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 109 | 5.06e-28 | NR | MCK6571765.1 | 2818507 | g65994 | i0 | 64.6 | 0.991935483870968 | 82 | 29 | 99.2 | 0 | 246 | 1 | 63 | 144 | MCK6571765.1 hypothetical protein [Myxococcota bacterium] | diamond | 246 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota 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);;