contig_metadata
7 rows where bioproject = "PRJNA900999" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 878128 | 878128 | PRJNA900999_S_NODE_5601_length_187_cov_7.962025_g5545_i0 | PRJNA900999 | 5601 | 187 | 7.962025 | 14.88898675 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 213 | 6.94e-51 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g5545 | i0 | 96.85 | 80.7754010695187 | 127 | 4 | 70 | 0 | 35 | 161 | 7409374 | 7409500 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 15105 | 213 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 10174562 | 10174562 | PRJNA900999_S_NODE_2668_length_248_cov_5.780822_g2612_i0 | PRJNA900999 | 2668 | 248 | 5.780822 | 14.33643856 | Sorangium | 39643 | Bacteria | Bacteria | 326 | 1.2e-84 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g2612 | i0 | 93.243 | 126.064516129032 | 222 | 14 | 89 | 1 | 28 | 248 | 3448863 | 3449084 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 31264 | 326 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 12357062 | 12357062 | PRJNA900999_S_NODE_5810_length_185_cov_3.858974_g5754_i0 | PRJNA900999 | 5810 | 185 | 3.858974 | 7.1391019 | uncultured Haliangium sp. | 373538 | Bacteria | Bacteria | 200 | 5.329999999999998e-47 | NTclustered | gi|310755276|gb|HQ213166.1| | 373538 | g5754 | i0 | 93.939 | 157.924324324324 | 132 | 8 | 71 | 0 | 24 | 155 | 947 | 1078 | Uncultured Haliangium sp. clone 3_E01 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 29216 | 200 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | uncultured Haliangium sp. | |||
| 16548537 | 16548537 | PRJNA900999_S_NODE_673_length_387_cov_236.846369_g618_i0 | PRJNA900999 | 673 | 387 | 236.846369 | 916.59544802999994 | Polyangiaceae | 49 | Bacteria | Bacteria | 364 | 4.179999999999998e-96 | NTclustered | gi|908353314|gb|CP012159.1| | 52 | g618 | i0 | 86.93 | 136.793281653747 | 329 | 38 | 84 | 5 | 3 | 328 | 1431070 | 1431396 | Chondromyces crocatus strain Cm c5, complete genome | blastn | 52939 | 366 | 0.994535519125683 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 22923679 | 22923679 | PRJNA900999_S_NODE_3958_length_214_cov_9.697297_g3902_i0 | PRJNA900999 | 3958 | 214 | 9.697297 | 20.75221558 | Polyangiaceae | 49 | Bacteria | Bacteria | 239 | 1.35e-58 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g3902 | i0 | 87.204 | 365.528037383178 | 211 | 26 | 98 | 1 | 1 | 210 | 3689442 | 3689652 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 78223 | 239 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 24197508 | 24197508 | PRJNA900999_S_NODE_2719_length_246_cov_11.230415_g2663_i0 | PRJNA900999 | 2719 | 246 | 11.230415 | 27.6268209 | Corallococcus | 83461 | Bacteria | Bacteria | 220 | 5.76e-53 | NTclustered | gi|1561763003|gb|CP034669.1| | 184914 | g2663 | i0 | 85.253 | 185.243902439024 | 217 | 29 | 87 | 3 | 5 | 219 | 142631 | 142416 | Corallococcus coralloides strain B035 chromosome, complete genome | blastn | 45570 | 220 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus coralloides | ||
| 26960736 | 26960736 | PRJNA900999_S_NODE_6482_length_177_cov_3.662162_g6426_i0 | PRJNA900999 | 6482 | 177 | 3.662162 | 6.48202674 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 59.3 | 2.14e-8 | NR | MBK8257436.1 | 2268199 | g6426 | i0 | 56.8 | 0.745762711864407 | 44 | 19 | 74.6 | 0 | 157 | 26 | 507 | 550 | MBK8257436.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 132 | 59.3 | 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);;