contig_metadata
9 rows where bioproject = "PRJNA851399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9767186 | 9767186 | PRJNA851399_P_NODE_11808_length_223_cov_1.959770_g11355_i0 | PRJNA851399 | 11808 | 223 | 1.95977 | 4.3702871 | Deinococcus geothermalis | 68909 | Bacteria | Bacteria | 412 | 7.88e-111 | NTclustered | gi|94554390|gb|CP000359.1| | 319795 | g11355 | i0 | 100 | 217.547085201794 | 223 | 0 | 100 | 0 | 1 | 223 | 2375313 | 2375535 | Deinococcus geothermalis DSM 11300, complete genome | blastn | 48513 | 412 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus geothermalis | ||
| 10162411 | 10162411 | PRJNA851399_P_NODE_19548_length_179_cov_0.915385_g19095_i0 | PRJNA851399 | 19548 | 179 | 0.915385 | 1.63853915 | Allomeiothermus | 2935559 | Bacteria | Bacteria | 324 | 2.91e-84 | NTclustered | gi|470486339|ref|NR_076751.1| | 52022 | g19095 | i0 | 99.438 | 4.2122905027933 | 178 | 1 | 99 | 0 | 2 | 179 | 2236 | 2059 | Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence | blastn | 754 | 324 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 19965893 | 19965893 | PRJNA851399_P_NODE_31656_length_165_cov_0.879310_g31203_i0 | PRJNA851399 | 31656 | 165 | 0.87931 | 1.4508615 | Deinococcus geothermalis | 68909 | Bacteria | Bacteria | 289 | 9.66e-74 | NTclustered | gi|94554390|gb|CP000359.1| | 319795 | g31203 | i0 | 98.182 | 1 | 165 | 3 | 100 | 0 | 1 | 165 | 911807 | 911643 | Deinococcus geothermalis DSM 11300, complete genome | blastn | 165 | 289 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus geothermalis | ||
| 23791530 | 23791530 | PRJNA851399_P_NODE_24479_length_168_cov_1.462185_g24026_i0 | PRJNA851399 | 24479 | 168 | 1.462185 | 2.4564708 | Deinococcus aquaticus | 328692 | Bacteria | Bacteria | 305 | 9.81e-79 | NTclustered | gi|2444120906|gb|CP115165.1| | 328692 | g24026 | i0 | 99.405 | 222.75 | 168 | 1 | 100 | 0 | 1 | 168 | 714825 | 714658 | Deinococcus aquaticus strain PB-314 chromosome, complete genome | blastn | 37422 | 305 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus | ||
| 25065452 | 25065452 | PRJNA851399_P_NODE_23820_length_169_cov_1.700000_g23367_i0 | PRJNA851399 | 23820 | 169 | 1.7 | 2.873 | Deinococcus maricopensis | 309887 | Bacteria | Bacteria | 263 | 5.989999999999999e-66 | NTclustered | gi|319753907|gb|CP002454.1| | 709986 | g23367 | i0 | 94.675 | 37.3491124260355 | 169 | 9 | 100 | 0 | 1 | 169 | 3025062 | 3024894 | Deinococcus maricopensis DSM 21211, complete genome | blastn | 6312 | 263 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus maricopensis | ||
| 29897138 | 29897138 | PRJNA851399_P_NODE_30551_length_165_cov_0.879310_g30098_i0 | PRJNA851399 | 30551 | 165 | 0.87931 | 1.4508615 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 78.6 | 3.04e-15 | NR | CAA9580304.1 | 543023 | g30098 | i0 | 65.5 | 1 | 55 | 19 | 100 | 0 | 1 | 165 | 45 | 99 | CAA9580304.1 MAG: Deoxyribodipyrimidine photolyase, partial [uncultured Truepera sp.] | diamond | 165 | 78.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 32173260 | 32173260 | PRJNA851399_P_NODE_37618_length_162_cov_0.902655_g37165_i0 | PRJNA851399 | 37618 | 162 | 0.902655 | 1.4623011 | Deinococcus sp. S9 | 2545754 | Bacteria | Bacteria | 108 | 3.9e-27 | NR | WP_133010023.1 | 2545754 | g37165 | i0 | 100 | 1 | 54 | 0 | 100 | 0 | 162 | 1 | 57 | 110 | WP_133010023.1 hypothetical protein [Deinococcus sp. S9] | diamond | 162 | 108 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. S9 | ||
| 32299959 | 32299959 | PRJNA851399_P_NODE_15959_length_189_cov_1.457143_g15506_i0 | PRJNA851399 | 15959 | 189 | 1.457143 | 2.75400027 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 64.7 | 3.14e-10 | NR | WP_380075813.1 | 1298767 | g15506 | i0 | 96.8 | 1 | 31 | 1 | 49.2 | 0 | 96 | 188 | 1 | 31 | WP_380075813.1 GH1 family beta-glucosidase [Deinococcus antarcticus] | diamond | 189 | 64.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus | ||
| 32836076 | 32836076 | PRJNA851399_P_NODE_15900_length_189_cov_1.457143_g15447_i0 | PRJNA851399 | 15900 | 189 | 1.457143 | 2.75400027 | Deinococcus soli (ex Cha et al. 2 | 1309411 | Bacteria | Bacteria | 41.6 | 0.0376 | NR | WP_309854091.1 | 1309411 | g15447 | i0 | 47.5 | 0.634920634920635 | 40 | 19 | 63.5 | 1 | 149 | 30 | 154 | 191 | WP_309854091.1 hypothetical protein [Deinococcus soli (ex Cha et al. 2016)] | diamond | 120 | 41.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) |
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);;