contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA835051" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8478923 | 8478923 | PRJNA835051_S_NODE_4127_length_412_cov_2.252033_g3834_i0 | PRJNA835051 | 4127 | 412 | 2.252033 | 9.27837596 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 52.8 | 0.04 | NTclustered | gi|71655353|ref|XM_811181.1| | 5693 | g3834 | i0 | 100 | 0.0679611650485437 | 28 | 0 | 7 | 0 | 53 | 80 | 692 | 719 | Trypanosoma cruzi uncharacterized protein (Tc00.1047053510861.60), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 21227411 | 21227411 | PRJNA835051_S_NODE_104677_length_166_cov_1.552846_g104381_i0 | PRJNA835051 | 104677 | 166 | 1.552846 | 2.57772436 | Pharyngomonas kirbyi | 63601 | Heterolobosea | other_Eukaryota | 62.1 | 2.31e-5 | NTclustered | gi|328551513|gb|HQ898858.1| | 63601 | g104381 | i0 | 97.297 | 19.2951807228916 | 37 | 0 | 22 | 1 | 1 | 36 | 455 | 491 | Heterolobosea sp. AGBS-2011 strain SD1A 18S ribosomal RNA gene, partial sequence | blastn | 3203 | 62.1 | 1 | Eukaryota | Discoba | Heterolobosea | Pharyngomonas | Pharyngomonas kirbyi | |||||
| 23778048 | 23778048 | PRJNA835051_S_NODE_14939_length_296_cov_2.284585_g14643_i0 | PRJNA835051 | 14939 | 296 | 2.284585 | 6.7623716 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|1002446498|ref|XM_015803211.1| | 157538 | g14643 | i0 | 94.286 | 0.11824324324324299 | 35 | 2 | 12 | 0 | 224 | 258 | 926 | 892 | Leptomonas pyrrhocoris hypothetical protein mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 24181139 | 24181139 | PRJNA835051_S_NODE_49179_length_218_cov_1.382857_g48883_i0 | PRJNA835051 | 49179 | 218 | 1.382857 | 3.01462826 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.019 | NTclustered | gi|340053499|emb|HE573021.1| | 1055687 | g48883 | i0 | 100 | 0.256880733944954 | 28 | 0 | 13 | 0 | 41 | 68 | 1057489 | 1057516 | Trypanosoma vivax Y486 annotated genomic contig, chromosome 5 | blastn | 56 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax |
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);;