contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA719595" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1985512 | 1985512 | PRJNA719595_P_NODE_7262_length_250_cov_0.881356_g7227_i0 | PRJNA719595 | 7262 | 250 | 0.881356 | 2.20339 | Herpetomonas muscarum | 5718 | Euglenozoa | other_Eukaryota | 270 | 5.74e-68 | NTclustered | gi|529495907|gb|KC503386.1| | 5718 | g7227 | i0 | 87.029 | 6.348 | 239 | 31 | 96 | 0 | 2 | 240 | 260 | 22 | Herpetomonas muscarum clone H1_2.5.1.6 methionine adenosyltransferase gene, complete cds | blastn | 1587 | 270 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Herpetomonas | Herpetomonas muscarum | ||
| 14738434 | 14738434 | PRJNA719595_P_NODE_4432_length_300_cov_1.374449_g4397_i0 | PRJNA719595 | 4432 | 300 | 1.374449 | 4.123347 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 538 | 1.76e-148 | NTclustered | gi|225216795|gb|FJ176710.1| | 312471 | g4397 | i0 | 99 | 102.416666666667 | 300 | 3 | 100 | 0 | 1 | 300 | 917 | 618 | Neobodo designis HFCC95 28S ribosomal RNA gene, partial sequence | blastn | 30725 | 538 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 22386901 | 22386901 | PRJNA719595_P_NODE_7218_length_250_cov_0.881356_g7183_i0 | PRJNA719595 | 7218 | 250 | 0.881356 | 2.20339 | Trypanosoma melophagium | 715481 | Euglenozoa | other_Eukaryota | 185 | 2.14e-42 | NTclustered | gi|2787710155|ref|XM_067331174.1| | 715481 | g7183 | i0 | 80.08 | 32.808 | 251 | 48 | 100 | 2 | 1 | 250 | 406 | 157 | Trypanosoma melophagium Ribosomal protein L19/L19e (LSM04_007600), partial mRNA | blastn | 8202 | 185 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma melophagium | ||
| 23662390 | 23662390 | PRJNA719595_P_NODE_2919_length_359_cov_1.090909_g2884_i0 | PRJNA719595 | 2919 | 359 | 1.090909 | 3.91636331 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 252 | 3.1199999999999997e-62 | NTclustered | gi|1002457625|ref|XM_015799400.1| | 157538 | g2884 | i0 | 81.329 | 72.1559888579387 | 316 | 53 | 87 | 6 | 41 | 354 | 445 | 134 | Leptomonas pyrrhocoris putative 40S ribosomal protein S13 mRNA | blastn | 25904 | 252 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris |
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);;