contig_metadata
7 rows where bioproject = "PRJNA922890" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5080226 | 5080226 | PRJNA922890_P_NODE_28104_length_360_cov_0.982818_g27694_i0 | PRJNA922890 | 28104 | 360 | 0.982818 | 3.5381448 | Deinococcus | 1298 | Bacteria | Bacteria | 385 | 2.96e-102 | NTclustered | gi|485099143|ref|NR_102538.1| | 432329 | g27694 | i0 | 87.135 | 106.905555555556 | 342 | 41 | 95 | 3 | 3 | 343 | 1224 | 1563 | Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence | blastn | 38486 | 385 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus peraridilitoris | ||
| 6001837 | 6001837 | PRJNA922890_P_NODE_78245_length_231_cov_0.888889_g77835_i0 | PRJNA922890 | 78245 | 231 | 0.888889 | 2.05333359 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 377 | 3e-100 | NTclustered | gi|1339790003|gb|CP026516.1| | 2080419 | g77835 | i0 | 96.104 | 344.580086580087 | 231 | 9 | 100 | 0 | 1 | 231 | 2417682 | 2417452 | Deinococcus sp. NW-56 chromosome, complete genome | blastn | 79598 | 377 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 12731322 | 12731322 | PRJNA922890_P_NODE_18730_length_441_cov_1.604839_g18320_i0 | PRJNA922890 | 18730 | 441 | 1.604839 | 7.07733999 | Deinococcus | 1298 | Bacteria | Bacteria | 660 | 0 | NTclustered | gi|1028459476|gb|CP011387.1| | 1182568 | g18320 | i0 | 94.614 | 361.573696145125 | 427 | 21 | 96 | 1 | 1 | 425 | 72045 | 71619 | Deinococcus puniceus strain DY1, complete genome | blastn | 159454 | 665 | 0.992481203007519 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus puniceus | ||
| 20378156 | 20378156 | PRJNA922890_P_NODE_10776_length_585_cov_1.315891_g10373_i0 | PRJNA922890 | 10776 | 585 | 1.315891 | 7.69796235 | Deinococcus | 1298 | Bacteria | Bacteria | 760 | 0 | NTclustered | gi|730601855|gb|CP010028.1| | 57497 | g10373 | i0 | 90.119 | 182.468376068376 | 587 | 54 | 100 | 4 | 1 | 585 | 70595 | 70011 | Deinococcus swuensis strain DY59, complete genome | blastn | 106744 | 760 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiopugnans | ||
| 21300686 | 21300686 | PRJNA922890_P_NODE_78437_length_230_cov_1.683230_g78027_i0 | PRJNA922890 | 78437 | 230 | 1.68323 | 3.871429 | Deinococcus gobiensis | 502394 | Bacteria | Bacteria | 375 | 1.07e-99 | NTclustered | gi|379998737|gb|CP002191.1| | 745776 | g78027 | i0 | 96.087 | 215.295652173913 | 230 | 9 | 100 | 0 | 1 | 230 | 111782 | 112011 | Deinococcus gobiensis I-0, complete genome | blastn | 49518 | 375 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 22574526 | 22574526 | PRJNA922890_P_NODE_1338_length_1535_cov_2.828104_g1190_i0 | PRJNA922890 | 1338 | 1535 | 2.828104 | 43.4113964 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 1986 | 0 | NTclustered | gi|2621706202|emb|OY764543.1| | 2026798 | g1190 | i0 | 90.176 | 314.37003257329 | 1537 | 133 | 99 | 14 | 3 | 1525 | 2559155 | 2560687 | MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1 | blastn | 482558 | 1986 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 24203412 | 24203412 | PRJNA922890_P_NODE_15079_length_492_cov_3.078014_g14671_i0 | PRJNA922890 | 15079 | 492 | 3.078014 | 15.14382888 | Truepera | 332248 | Bacteria | Bacteria | 619 | 1.05e-172 | NTclustered | gi|470486385|ref|NR_076754.1| | 332249 | g14671 | i0 | 89.431 | 308.75406504065 | 492 | 50 | 99 | 2 | 2 | 492 | 504 | 14 | Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence | blastn | 151907 | 619 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix |
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);;