contig_metadata
8 rows where bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135203 | 135203 | PRJEB73599_P_NODE_721_length_891_cov_4068.633411_g579_i0 | PRJEB73599 | 721 | 891 | 4068.633411 | 36251.52369201 | Deinococcus actinosclerus | 1768108 | Bacteria | Bacteria | 907 | 0 | NTclustered | gi|972944657|gb|CP013910.1| | 1768108 | g579 | i0 | 91.029 | 248.750841750842 | 680 | 49 | 76 | 12 | 218 | 891 | 74386 | 73713 | Deinococcus actinosclerus strain BM2 chromosome, complete genome | blastn | 221637 | 907 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus actinosclerus | ||
| 995517 | 995517 | PRJEB73599_P_NODE_6281_length_241_cov_3.693396_g5994_i0 | PRJEB73599 | 6281 | 241 | 3.693396 | 8.90108436 | Deinococcus | 1298 | Bacteria | Bacteria | 396 | 8.7e-106 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g5994 | i0 | 96.266 | 208.771784232365 | 241 | 9 | 100 | 0 | 1 | 241 | 74120 | 74360 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 50314 | 396 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 3961302 | 3961302 | PRJEB73599_P_NODE_7324_length_209_cov_2.455556_g7037_i0 | PRJEB73599 | 7324 | 209 | 2.455556 | 5.13211204 | Thermus aquaticus | 271 | Bacteria | Bacteria | 377 | 2.66e-100 | NTclustered | gi|939575972|gb|CP010822.1| | 498848 | g7037 | i0 | 99.517 | 147.732057416268 | 207 | 1 | 99 | 0 | 1 | 207 | 44326 | 44532 | Thermus aquaticus Y51MC23, complete genome | blastn | 30876 | 377 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 9062472 | 9062472 | PRJEB73599_P_NODE_7488_length_204_cov_2.394286_g7201_i0 | PRJEB73599 | 7488 | 204 | 2.394286 | 4.88434344 | Deinococcus gobiensis | 502394 | Bacteria | Bacteria | 361 | 2.6e-95 | NTclustered | gi|379998737|gb|CP002191.1| | 745776 | g7201 | i0 | 98.529 | 369.279411764706 | 204 | 3 | 100 | 0 | 1 | 204 | 112036 | 111833 | Deinococcus gobiensis I-0, complete genome | blastn | 75333 | 361 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 17573432 | 17573432 | PRJEB73599_P_NODE_7354_length_208_cov_2.122905_g7067_i0 | PRJEB73599 | 7354 | 208 | 2.122905 | 4.4156424 | Bacteria | 2 | Bacteria | Bacteria | 143 | 1.05e-29 | NTclustered | gi|37223182|gb|AY379549.1| | 274 | g7067 | i0 | 84.459 | 96.7692307692308 | 148 | 19 | 71 | 4 | 56 | 202 | 1465 | 1321 | Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence | blastn | 20128 | 143 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus | ||
| 19260744 | 19260744 | PRJEB73599_P_NODE_1236_length_675_cov_7.148607_g1044_i0 | PRJEB73599 | 1236 | 675 | 7.148607 | 48.25309725 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 968 | 0 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g1044 | i0 | 92.522 | 284.536296296296 | 682 | 41 | 100 | 10 | 1 | 675 | 1637231 | 1637909 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 192062 | 968 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 23948025 | 23948025 | PRJEB73599_P_NODE_8119_length_189_cov_2.243750_g7832_i0 | PRJEB73599 | 8119 | 189 | 2.24375 | 4.2406875 | root | 1 | Root_unresolved | Root_unresolved | 350 | 5.14e-92 | NTclustered | gi|219846310|ref|NR_025900.1| | 271 | g7832 | i0 | 100 | 100.957671957672 | 189 | 0 | 100 | 0 | 1 | 189 | 738 | 550 | Thermus aquaticus strain YT-1 16S ribosomal RNA, partial sequence | blastn | 19081 | 350 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 29268853 | 29268853 | PRJEB73599_P_NODE_5409_length_274_cov_2.232653_g5122_i0 | PRJEB73599 | 5409 | 274 | 2.232653 | 6.11746922 | Bacteria | 2 | Bacteria | Bacteria | 67.4 | 1e-10 | NR | WP_287928134.1 | 275 | g5122 | i0 | 62.3 | 6.86496350364964 | 53 | 20 | 58 | 0 | 115 | 273 | 19 | 71 | WP_287928134.1 oxaloacetate-decarboxylating malate dehydrogenase, partial [Thermus sp.] | diamond | 1881 | 67.8 | 0.994100294985251 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. |
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);;