contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2749846 | 2749846 | PRJNA1093380_P_NODE_1723_length_428_cov_2.030986_g1617_i0 | PRJNA1093380 | 1723 | 428 | 2.030986 | 8.69262008 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 446 | 1.62e-120 | NTclustered | gi|908353314|gb|CP012159.1| | 52 | g1617 | i0 | 85.584 | 145.014018691589 | 437 | 49 | 100 | 13 | 1 | 428 | 1431422 | 1430991 | Chondromyces crocatus strain Cm c5, complete genome | blastn | 62066 | 446 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 6577140 | 6577140 | PRJNA1093380_P_NODE_66_length_1686_cov_4.172970_g45_i0 | PRJNA1093380 | 66 | 1686 | 4.17297 | 70.3562742 | Minicystis rosea | 888845 | Bacteria | Bacteria | 2054 | 0 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g45 | i0 | 88.68 | 188.622775800712 | 1705 | 165 | 100 | 27 | 1 | 1686 | 13716766 | 13715071 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 318018 | 2054 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 10402450 | 10402450 | PRJNA1093380_P_NODE_3049_length_345_cov_1.750000_g2943_i0 | PRJNA1093380 | 3049 | 345 | 1.75 | 6.0375 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 566 | 9.429999999999997e-157 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g2943 | i0 | 96.232 | 146.365217391304 | 345 | 13 | 100 | 0 | 1 | 345 | 7090220 | 7089876 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 50496 | 566 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 16776243 | 16776243 | PRJNA1093380_P_NODE_1814_length_420_cov_3.544669_g1708_i0 | PRJNA1093380 | 1814 | 420 | 3.544669 | 14.8876098 | Anaeromyxobacter paludicola | 2918171 | Bacteria | Bacteria | 89.8 | 3.08e-13 | NTclustered | gi|2199271117|dbj|AP025592.1| | 2918171 | g1708 | i0 | 94.737 | 4.87380952380952 | 57 | 3 | 14 | 0 | 361 | 417 | 1383558 | 1383614 | Anaeromyxobacter paludicola DNA, complete genome | blastn | 2047 | 89.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter paludicola | ||
| 16776282 | 16776282 | PRJNA1093380_P_NODE_4814_length_295_cov_1.387387_g4708_i0 | PRJNA1093380 | 4814 | 295 | 1.387387 | 4.09279165 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 302 | 2.46e-77 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g4708 | i0 | 86.411 | 94.9152542372881 | 287 | 25 | 95 | 12 | 17 | 295 | 1510 | 1790 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 28000 | 302 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 16776291 | 16776291 | PRJNA1093380_P_NODE_5574_length_288_cov_1.074419_g5468_i0 | PRJNA1093380 | 5574 | 288 | 1.074419 | 3.09432672 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 405 | 1.78e-108 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g5468 | i0 | 92.014 | 145.427083333333 | 288 | 23 | 100 | 0 | 1 | 288 | 7090153 | 7090440 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 41883 | 405 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 23971550 | 23971550 | PRJNA1093380_P_NODE_539_length_765_cov_3.822254_g444_i0 | PRJNA1093380 | 539 | 765 | 3.822254 | 29.2402431 | Myxococcia | 32015 | Bacteria | Bacteria | 996 | 0 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g444 | i0 | 90.196 | 141.473202614379 | 765 | 73 | 100 | 2 | 1 | 765 | 443423 | 444185 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 108227 | 1003 | 0.993020937188435 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum |
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);;