contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 664887 | 664887 | PRJNA683669_P_NODE_14421_length_341_cov_1.432836_g14190_i0 | PRJNA683669 | 14421 | 341 | 1.432836 | 4.88597076 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 60.2 | 1.93e-4 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g14190 | i0 | 100 | 0.524926686217009 | 32 | 0 | 9 | 0 | 135 | 166 | 5501220 | 5501189 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 179 | 60.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 664899 | 664899 | PRJNA683669_P_NODE_16621_length_318_cov_0.942857_g16390_i0 | PRJNA683669 | 16621 | 318 | 0.942857 | 2.99828526 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 58.4 | 6.41e-4 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g16390 | i0 | 83.077 | 0.20440251572327 | 65 | 9 | 20 | 2 | 226 | 289 | 1416866 | 1416929 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 65 | 58.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 1941040 | 1941040 | PRJNA683669_P_NODE_4182_length_638_cov_1.380531_g3958_i0 | PRJNA683669 | 4182 | 638 | 1.380531 | 8.80778778 | Stigmatella aurantiaca | 41 | Bacteria | Bacteria | 75 | 1.35e-8 | NTclustered | gi|309390350|gb|CP002271.1| | 378806 | g3958 | i0 | 97.674 | 0.27115987460815 | 43 | 1 | 7 | 0 | 99 | 141 | 5286039 | 5285997 | Stigmatella aurantiaca DW4/3-1, complete genome | blastn | 173 | 75 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 3215947 | 3215947 | PRJNA683669_P_NODE_6923_length_486_cov_0.932203_g6692_i0 | PRJNA683669 | 6923 | 486 | 0.932203 | 4.53050658 | Archangium violaceum | 83451 | Bacteria | Bacteria | 58.4 | 0.001 | NTclustered | gi|2619762464|gb|CP137851.1| | 83451 | g6692 | i0 | 100 | 0.0637860082304527 | 31 | 0 | 6 | 0 | 133 | 163 | 7027566 | 7027596 | Archangium violaceum strain KYC5002 chromosome, complete genome | blastn | 31 | 58.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum |
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);;