contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA485080" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1723982 | 1723982 | PRJNA485080_P_NODE_37982_length_243_cov_1.382353_g37888_i0 | PRJNA485080 | 37982 | 243 | 1.382353 | 3.35911779 | Archangium gephyra | 48 | Bacteria | Bacteria | 305 | 1.52e-78 | NTclustered | gi|827418478|gb|CP011509.1| | 48 | g37888 | i0 | 89.3 | 2.00411522633745 | 243 | 26 | 100 | 0 | 1 | 243 | 8431804 | 8431562 | Archangium gephyra strain DSM 2261, complete genome | blastn | 487 | 305 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 1724112 | 1724112 | PRJNA485080_P_NODE_8002_length_360_cov_1.404181_g7908_i0 | PRJNA485080 | 8002 | 360 | 1.404181 | 5.0550516 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 496 | 1.31e-135 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g7908 | i0 | 91.69 | 155.525 | 361 | 25 | 100 | 3 | 1 | 360 | 7289535 | 7289179 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 55989 | 496 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 8102111 | 8102111 | PRJNA485080_P_NODE_20047_length_259_cov_2.483871_g19953_i0 | PRJNA485080 | 20047 | 259 | 2.483871 | 6.43322589 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 342 | 1.25e-89 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g19953 | i0 | 90.769 | 163.783783783784 | 260 | 18 | 99 | 5 | 3 | 259 | 3941985 | 3942241 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 42420 | 342 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 11300638 | 11300638 | PRJNA485080_P_NODE_21269_length_251_cov_1.808989_g21175_i0 | PRJNA485080 | 21269 | 251 | 1.808989 | 4.54056239 | Pendulispora | 3375062 | Bacteria | Bacteria | 433 | 6.95e-117 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g21175 | i0 | 97.992 | 272.05577689243 | 249 | 5 | 99 | 0 | 3 | 251 | 7287167 | 7287415 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 68286 | 433 | 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);;