contig_metadata
11 rows where bioproject = "PRJEB12296", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985651 | 985651 | PRJEB12296_P_NODE_81_length_376_cov_4.265130_g73_i0 | PRJEB12296 | 81 | 376 | 4.26513 | 16.0368888 | Sorangium | 39643 | Bacteria | Bacteria | 202 | 3.36e-47 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g73 | i0 | 99.107 | 40.5265957446809 | 112 | 1 | 46 | 0 | 243 | 354 | 3448970 | 3448859 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 15238 | 202 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 25606804 | 25606804 | PRJEB12296_S_NODE_11209_length_168_cov_5.511278_g11177_i0 | PRJEB12296 | 11209 | 168 | 5.511278 | 9.25894704 | Sorangium | 39643 | Bacteria | Bacteria | 289 | 9.879999999999999e-74 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g11177 | i0 | 97.619 | 284.785714285714 | 168 | 4 | 100 | 0 | 1 | 168 | 3692230 | 3692397 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 47844 | 289 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 25636545 | 25636545 | PRJEB12296_S_NODE_2722_length_266_cov_1.584416_g2690_i0 | PRJEB12296 | 2722 | 266 | 1.584416 | 4.21454656 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 411 | 3.4799999999999996e-110 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g2690 | i0 | 94.737 | 150.65037593985 | 266 | 11 | 99 | 3 | 2 | 266 | 9037318 | 9037581 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 40073 | 411 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 25636688 | 25636688 | PRJEB12296_S_NODE_7674_length_185_cov_1.900000_g7642_i0 | PRJEB12296 | 7674 | 185 | 1.9 | 3.515 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 167 | 5.41e-37 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g7642 | i0 | 89.922 | 20.9081081081081 | 129 | 13 | 70 | 0 | 17 | 145 | 7290015 | 7289887 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 3868 | 167 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 25878817 | 25878817 | PRJEB12296_S_NODE_2283_length_283_cov_38.915323_g2251_i0 | PRJEB12296 | 2283 | 283 | 38.915323 | 110.13036409 | Polyangiaceae | 49 | Bacteria | Bacteria | 455 | 1.7e-123 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g2251 | i0 | 95.745 | 194.583038869258 | 282 | 12 | 99 | 0 | 1 | 282 | 771668 | 771387 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 55067 | 455 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 25878884 | 25878884 | PRJEB12296_S_NODE_91_length_713_cov_13.952802_g78_i0 | PRJEB12296 | 91 | 713 | 13.952802 | 99.48347826 | Polyangiaceae | 49 | Bacteria | Bacteria | 915 | 0 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g78 | i0 | 94.167 | 123.844319775596 | 600 | 35 | 84 | 0 | 114 | 713 | 1950 | 2549 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 88301 | 915 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 25908849 | 25908849 | PRJEB12296_S_NODE_156_length_627_cov_40.356419_g137_i0 | PRJEB12296 | 156 | 627 | 40.356419 | 253.03474713 | Minicystis rosea | 888845 | Bacteria | Bacteria | 843 | 0 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g137 | i0 | 91.79 | 134.958532695375 | 609 | 45 | 97 | 5 | 1 | 606 | 13715642 | 13715036 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 84619 | 843 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 26287267 | 26287267 | PRJEB12296_S_NODE_2486_length_274_cov_696.682008_g2454_i0 | PRJEB12296 | 2486 | 274 | 696.682008 | 1908.90870192 | Corallococcus | 83461 | Bacteria | Bacteria | 222 | 1.81e-53 | NTclustered | gi|1561763003|gb|CP034669.1| | 184914 | g2454 | i0 | 84.821 | 173.496350364963 | 224 | 31 | 82 | 3 | 15 | 236 | 142638 | 142416 | Corallococcus coralloides strain B035 chromosome, complete genome | blastn | 47538 | 222 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus coralloides | ||
| 26317026 | 26317026 | PRJEB12296_S_NODE_743_length_398_cov_912.300275_g712_i0 | PRJEB12296 | 743 | 398 | 912.300275 | 3630.9550945 | Minicystis rosea | 888845 | Bacteria | Bacteria | 508 | 1.8799999999999998e-139 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g712 | i0 | 94.048 | 98.8969849246231 | 336 | 19 | 84 | 1 | 64 | 398 | 770472 | 770137 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 39361 | 508 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 26453059 | 26453059 | PRJEB12296_S_NODE_1024_length_362_cov_26328.678899_g992_i0 | PRJEB12296 | 1024 | 362 | 26328.678899 | 95309.81761438 | Sorangium cellulosum So ce56 | 448385 | Bacteria | Bacteria | 383 | 1.0699999999999995e-101 | NTclustered | gi|161158851|emb|AM746676.1| | 448385 | g992 | i0 | 96.17 | 121.831491712707 | 235 | 8 | 65 | 1 | 22 | 255 | 3488019 | 3488253 | Sorangium cellulosum 'So ce 56' complete genome | blastn | 44103 | 383 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 26559210 | 26559210 | PRJEB12296_S_NODE_3160_length_250_cov_2485.320930_g3128_i0 | PRJEB12296 | 3160 | 250 | 2485.32093 | 6213.302325 | root | 1 | Root_unresolved | Root_unresolved | 244 | 3.48e-60 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g3128 | i0 | 87.324 | 114.988 | 213 | 27 | 85 | 0 | 36 | 248 | 7290015 | 7289803 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 28747 | 244 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella |
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);;