contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1095825" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7853716 | 7853716 | PRJNA1095825_P_NODE_276607_length_244_cov_0.900585_g273544_i0 | PRJNA1095825 | 276607 | 244 | 0.900585 | 2.1974274 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 105 | 2.06e-25 | NR | WP_386843102.1 | 536443 | g273544 | i0 | 90.5 | 1.69672131147541 | 84 | 4 | 98.4 | 1 | 242 | 3 | 43 | 126 | WP_386843102.1 NUDIX domain-containing protein [Deinococcus taklimakanensis] | diamond | 414 | 105 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 27564246 | 27564246 | PRJNA1095825_P_NODE_169104_length_300_cov_1.356828_g166041_i0 | PRJNA1095825 | 169104 | 300 | 1.356828 | 4.070484 | Deinococcus | 1298 | Bacteria | Bacteria | 108 | 8.89e-26 | NR | WP_295816647.1 | 158789 | g166041 | i0 | 50.9 | 5.26 | 106 | 45 | 99 | 2 | 298 | 2 | 211 | 316 | WP_295816647.1 alpha/beta hydrolase [uncultured Deinococcus sp.] | diamond | 1578 | 108 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 27983549 | 27983549 | PRJNA1095825_P_NODE_209205_length_270_cov_1.233503_g206142_i0 | PRJNA1095825 | 209205 | 270 | 1.233503 | 3.3304581 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 158 | 1.1e-42 | NR | WP_104989975.1 | 2080419 | g206142 | i0 | 80 | 2 | 90 | 18 | 100 | 0 | 1 | 270 | 350 | 439 | WP_104989975.1 EcoAI/FtnUII family type I restriction enzme subunit R [Deinococcus sp. NW-56] | diamond | 540 | 158 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 28962644 | 28962644 | PRJNA1095825_P_NODE_221348_length_261_cov_1.638298_g218285_i0 | PRJNA1095825 | 221348 | 261 | 1.638298 | 4.27595778 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 113 | 7.32e-30 | NR | NBC95014.1 | 1913990 | g218285 | i0 | 62.5 | 0.919540229885057 | 80 | 30 | 92 | 0 | 240 | 1 | 1 | 80 | NBC95014.1 DUF4065 domain-containing protein [Deinococcota bacterium] | diamond | 240 | 113 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 29435707 | 29435707 | PRJNA1095825_P_NODE_274530_length_245_cov_0.895349_g271467_i0 | PRJNA1095825 | 274530 | 245 | 0.895349 | 2.19360505 | Deinococcus sp. Leaf326 | 1736338 | Bacteria | Bacteria | 155 | 6.089999999999998e-42 | NR | WP_056299193.1 | 1736338 | g271467 | i0 | 93.8 | 0.991836734693878 | 81 | 5 | 99.2 | 0 | 244 | 2 | 196 | 276 | WP_056299193.1 VirB4 family type IV secretion system protein [Deinococcus sp. Leaf326] | diamond | 243 | 155 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. Leaf326 | ||
| 30667921 | 30667921 | PRJNA1095825_P_NODE_276833_length_244_cov_0.900585_g273770_i0 | PRJNA1095825 | 276833 | 244 | 0.900585 | 2.1974274 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 162 | 1.02e-46 | NR | WP_386842847.1 | 536443 | g273770 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 244 | 2 | 244 | 324 | WP_386842847.1 3-dehydroquinate synthase [Deinococcus taklimakanensis] | diamond | 243 | 162 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 30699419 | 30699419 | PRJNA1095825_P_NODE_192394_length_282_cov_1.287081_g189331_i0 | PRJNA1095825 | 192394 | 282 | 1.287081 | 3.62956842 | Synergistales bacterium | 2268201 | Bacteria | Bacteria | 79.3 | 7.15e-15 | NR | MFA0889601.1 | 2268201 | g189331 | i0 | 66.7 | 1.81914893617021 | 57 | 19 | 60.6 | 0 | 171 | 1 | 1 | 57 | MFA0889601.1 glycine/sarcosine/betaine reductase component B subunit [Synergistales bacterium] | diamond | 513 | 79.3 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium |
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);;