contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA890871" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3415777 | 3415777 | PRJNA890871_P_NODE_69603_length_248_cov_0.880000_g69468_i0 | PRJNA890871 | 69603 | 248 | 0.88 | 2.1824 | Myxococcus sp. MH1 | 2982796 | Bacteria | Bacteria | 448 | 2.4499999999999996e-121 | NTclustered | gi|2321229309|dbj|AP026947.1| | 2982796 | g69468 | i0 | 99.194 | 9.01612903225806 | 248 | 2 | 100 | 0 | 1 | 248 | 2007542 | 2007295 | Myxococcus sp. MH1 DNA, complete genome | blastn | 2236 | 448 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. MH1 | ||
| 11067147 | 11067147 | PRJNA890871_P_NODE_13129_length_434_cov_2.404432_g12994_i0 | PRJNA890871 | 13129 | 434 | 2.404432 | 10.43523488 | Minicystis rosea | 888845 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g12994 | i0 | 89.362 | 0.108294930875576 | 47 | 2 | 11 | 3 | 10 | 56 | 8188742 | 8188785 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 47 | 56.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 12343159 | 12343159 | PRJNA890871_P_NODE_26130_length_328_cov_1.780392_g25995_i0 | PRJNA890871 | 26130 | 328 | 1.780392 | 5.83968576 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 213 | 1.34e-50 | NTclustered | gi|1566495190|gb|CP012670.1| | 56 | g25995 | i0 | 79.245 | 3.72560975609756 | 318 | 57 | 96 | 9 | 7 | 321 | 8092981 | 8092670 | Sorangium cellulosum strain So ceGT47 chromosome, complete genome | blastn | 1222 | 213 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 12344480 | 12344480 | PRJNA890871_P_NODE_90670_length_230_cov_3.770701_g90535_i0 | PRJNA890871 | 90670 | 230 | 3.770701 | 8.6726123 | Myxococcus fulvus | 33 | Bacteria | Bacteria | 355 | 1.4e-93 | NTclustered | gi|817709775|gb|CP006003.1| | 1334629 | g90535 | i0 | 94.737 | 0.991304347826087 | 228 | 12 | 99 | 0 | 1 | 228 | 8644336 | 8644109 | Myxococcus fulvus 124B02, complete genome | blastn | 228 | 355 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 18716344 | 18716344 | PRJNA890871_P_NODE_65535_length_250_cov_0.870056_g65400_i0 | PRJNA890871 | 65535 | 250 | 0.870056 | 2.17514 | Archangium violaceum | 83451 | Bacteria | Bacteria | 209 | 1.27e-49 | NTclustered | gi|2579675135|gb|CP043493.1| | 83451 | g65400 | i0 | 82.787 | 48.692 | 244 | 32 | 96 | 8 | 1 | 239 | 3185382 | 3185620 | Archangium violaceum strain Cbvi 34 chromosome, complete genome | blastn | 12173 | 209 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 19990542 | 19990542 | PRJNA890871_P_NODE_21836_length_352_cov_2.645161_g21701_i0 | PRJNA890871 | 21836 | 352 | 2.645161 | 9.31096672 | Stigmatella aurantiaca | 41 | Bacteria | Bacteria | 113 | 1.5e-20 | NTclustered | gi|309390350|gb|CP002271.1| | 378806 | g21701 | i0 | 84.348 | 12.1960227272727 | 115 | 18 | 33 | 0 | 3 | 117 | 19328 | 19214 | Stigmatella aurantiaca DW4/3-1, complete genome | blastn | 4293 | 113 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 19991444 | 19991444 | PRJNA890871_P_NODE_57876_length_256_cov_2.125683_g57741_i0 | PRJNA890871 | 57876 | 256 | 2.125683 | 5.44174848 | Archangium violaceum | 83451 | Bacteria | Bacteria | 226 | 1.3e-54 | NTclustered | gi|1985695619|gb|CP069396.1| | 83451 | g57741 | i0 | 87 | 74.13671875 | 200 | 26 | 78 | 0 | 57 | 256 | 5433486 | 5433287 | Archangium violaceum strain SDU8 chromosome, complete genome | blastn | 18979 | 226 | 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);;