contig_metadata
7 rows where bioproject = "PRJNA1148965" and tax_kingdom = "Bacillati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8689605 | 8689605 | PRJNA1148965_S_NODE_707_length_253_cov_0.866667_g704_i0 | PRJNA1148965 | 707 | 253 | 0.866667 | 2.19266751 | Bacillati | 1783272 | Bacteria | Bacteria | 377 | 3.33e-100 | NTclustered | gi|2179631034|gb|CP090928.1| | 1282 | g704 | i0 | 98.592 | 147.343873517787 | 213 | 3 | 84 | 0 | 17 | 229 | 1105 | 893 | Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence | blastn | 37278 | 377 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus epidermidis | ||
| 9964720 | 9964720 | PRJNA1148965_S_NODE_48_length_568_cov_1.331313_g46_i0 | PRJNA1148965 | 48 | 568 | 1.331313 | 7.56185784 | Bacillus | 1386 | Bacteria | Bacteria | 459 | 2.8199999999999996e-124 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g46 | i0 | 100 | 43.6619718309859 | 248 | 0 | 44 | 0 | 321 | 568 | 3965601 | 3965354 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 24800 | 459 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 11239853 | 11239853 | PRJNA1148965_S_NODE_669_length_257_cov_0.891304_g666_i0 | PRJNA1148965 | 669 | 257 | 0.891304 | 2.29065128 | Bacillus | 1386 | Bacteria | Bacteria | 470 | 5.45e-128 | NTclustered | gi|984728683|gb|CP014179.1| | 1392 | g666 | i0 | 99.611 | 100 | 257 | 1 | 100 | 0 | 1 | 257 | 3949950 | 3949694 | Bacillus anthracis strain Stendal chromosome, complete genome | blastn | 25700 | 470 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 11239854 | 11239854 | PRJNA1148965_S_NODE_89_length_465_cov_1.724490_g86_i0 | PRJNA1148965 | 89 | 465 | 1.72449 | 8.0188785 | Bacillus | 1386 | Bacteria | Bacteria | 710 | 0 | NTclustered | gi|984728683|gb|CP014179.1| | 1392 | g86 | i0 | 99.742 | 1043.69677419355 | 387 | 1 | 83 | 0 | 59 | 445 | 13087 | 12701 | Bacillus anthracis strain Stendal chromosome, complete genome | blastn | 485319 | 710 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 11239855 | 11239855 | PRJNA1148965_S_NODE_9_length_942_cov_2.235903_g7_i0 | PRJNA1148965 | 9 | 942 | 2.235903 | 21.06220626 | Bacillus | 1386 | Bacteria | Bacteria | 872 | 0 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g7 | i0 | 99.789 | 93.8460721868365 | 475 | 1 | 94 | 0 | 62 | 536 | 3972107 | 3972581 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 88403 | 872 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 15064239 | 15064239 | PRJNA1148965_S_NODE_12_length_897_cov_11.253641_g10_i0 | PRJNA1148965 | 12 | 897 | 11.253641 | 100.94515977 | Bacillus | 1386 | Bacteria | Bacteria | 1447 | 0 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g10 | i0 | 99.747 | 87.8472686733556 | 789 | 2 | 88 | 0 | 33 | 821 | 3357929 | 3357141 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 78799 | 1447 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis | ||
| 17614297 | 17614297 | PRJNA1148965_S_NODE_34_length_613_cov_1.590741_g32_i0 | PRJNA1148965 | 34 | 613 | 1.590741 | 9.75124233 | Bacillus | 1386 | Bacteria | Bacteria | 1127 | 0 | NTclustered | gi|2257786247|gb|CP085402.1| | 1392 | g32 | i0 | 99.837 | 99.8613376835237 | 613 | 1 | 100 | 0 | 1 | 613 | 3357108 | 3356496 | Bacillus anthracis strain CMF9 chromosome, complete genome | blastn | 61215 | 1127 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus anthracis |
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);;