contig_metadata
8 rows where bioproject = "PRJNA846086" and tax_phylum = "Deinococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2108308 | 2108308 | PRJNA846086_P_NODE_2502_length_265_cov_1.604167_g2436_i0 | PRJNA846086 | 2502 | 265 | 1.604167 | 4.25104255 | Deinococcus | 1298 | Bacteria | Bacteria | 152 | 2.8999999999999996e-42 | NR | WP_189642579.1 | 394230 | g2436 | i0 | 87.5 | 2.98867924528302 | 88 | 11 | 99.6 | 0 | 2 | 265 | 124 | 211 | WP_189642579.1 aspartate--tRNA(Asn) ligase [Deinococcus piscis] | diamond | 792 | 152 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus piscis | ||
| 12311983 | 12311983 | PRJNA846086_P_NODE_1010_length_366_cov_1.576792_g944_i0 | PRJNA846086 | 1010 | 366 | 1.576792 | 5.77105872 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 671 | 0 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g944 | i0 | 99.727 | 213.18306010929 | 366 | 1 | 100 | 0 | 1 | 366 | 1637230 | 1637595 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 78025 | 671 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 13586520 | 13586520 | PRJNA846086_P_NODE_4231_length_246_cov_0.890173_g4165_i0 | PRJNA846086 | 4231 | 246 | 0.890173 | 2.18982558 | Deinococcus aquaticus | 328692 | Bacteria | Bacteria | 283 | 7.239999999999999e-72 | NTclustered | gi|2444120906|gb|CP115165.1| | 328692 | g4165 | i0 | 87.449 | 2.1260162601626 | 247 | 29 | 100 | 2 | 1 | 246 | 2676319 | 2676564 | Deinococcus aquaticus strain PB-314 chromosome, complete genome | blastn | 523 | 283 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus | ||
| 14860758 | 14860758 | PRJNA846086_P_NODE_2792_length_258_cov_1.351351_g2726_i0 | PRJNA846086 | 2792 | 258 | 1.351351 | 3.48648558 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 477 | 3.2699999999999985e-130 | NTclustered | gi|2905211496|gb|CP179945.1| | 3385567 | g2726 | i0 | 100 | 2 | 258 | 0 | 100 | 0 | 1 | 258 | 399432 | 399175 | Deinococcus sp. VB343 chromosome 1, complete sequence | blastn | 516 | 477 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 20357549 | 20357549 | PRJNA846086_P_NODE_1816_length_287_cov_1.598131_g1750_i0 | PRJNA846086 | 1816 | 287 | 1.598131 | 4.58663597 | Deinococcus | 1298 | Bacteria | Bacteria | 520 | 6.049999999999999e-143 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g1750 | i0 | 99.303 | 182.344947735192 | 287 | 2 | 100 | 0 | 1 | 287 | 74285 | 74571 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 52333 | 525 | 0.990476190476191 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 24182823 | 24182823 | PRJNA846086_P_NODE_4459_length_245_cov_0.895349_g4393_i0 | PRJNA846086 | 4459 | 245 | 0.895349 | 2.19360505 | Deinococcus | 1298 | Bacteria | Bacteria | 174 | 4.52e-39 | NTclustered | gi|2706840606|gb|CP149783.1| | 3112952 | g4393 | i0 | 79.592 | 10.8571428571429 | 245 | 48 | 99 | 2 | 2 | 245 | 335379 | 335136 | Deinococcus sp. VB142 chromosome 2, complete sequence | blastn | 2660 | 174 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 24182829 | 24182829 | PRJNA846086_P_NODE_5159_length_243_cov_0.870588_g5093_i0 | PRJNA846086 | 5159 | 243 | 0.870588 | 2.11552884 | Deinococcus | 1298 | Bacteria | Bacteria | 316 | 7.03e-82 | NTclustered | gi|2890653062|gb|CP177252.1| | 367282 | g5093 | i0 | 90.535 | 210.59670781893 | 243 | 17 | 99 | 6 | 1 | 238 | 2671897 | 2672138 | Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome | blastn | 51175 | 316 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus yunweiensis | ||
| 27316231 | 27316231 | PRJNA846086_P_NODE_5403_length_242_cov_0.911243_g5337_i0 | PRJNA846086 | 5403 | 242 | 0.911243 | 2.20520806 | Meiothermus | 65551 | Bacteria | Bacteria | 120 | 3.18e-32 | NR | MDQ3397725.1 | 1913990 | g5337 | i0 | 68.8 | 2.00826446280992 | 80 | 22 | 99.2 | 1 | 2 | 241 | 32 | 108 | MDQ3397725.1 Uma2 family endonuclease [Deinococcota bacterium] | diamond | 486 | 120 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota 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);;