contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28337341 | 28337341 | PRJNA263496_P_NODE_23866_length_163_cov_0.894737_g23613_i0 | PRJNA263496 | 23866 | 163 | 0.894737 | 1.45842131 | Stygiella incarcerata | 1712417 | Root_unresolved | Root_unresolved | 92.8 | 9.4e-22 | NR | ANM86184.1 | 1712417 | g23613 | i0 | 79.6 | 17.8343558282209 | 54 | 11 | 99.4 | 0 | 162 | 1 | 5 | 58 | ANM86184.1 60S ribosomal protein L15-2 [Stygiella incarcerata] | diamond | 2907 | 92.8 | 1 | Eukaryota | Discoba | Jakobida | Stygiellidae | Stygiella | Stygiella incarcerata | ||||
| 28400477 | 28400477 | PRJNA263496_P_NODE_18626_length_180_cov_1.167939_g18373_i0 | PRJNA263496 | 18626 | 180 | 1.167939 | 2.1022902 | Strigomonas culicis | 28005 | Euglenozoa | other_Eukaryota | 55.1 | 2.6e-7 | NR | EPY22881.1 | 28005 | g18373 | i0 | 61.4 | 2.33333333333333 | 44 | 17 | 73.3 | 0 | 132 | 1 | 126 | 169 | EPY22881.1 nascent polypeptide-associated complex subunit alpha [Strigomonas culicis] | diamond | 420 | 55.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Strigomonas | Strigomonas culicis | ||
| 29284337 | 29284337 | PRJNA263496_P_NODE_18109_length_183_cov_1.104478_g17856_i0 | PRJNA263496 | 18109 | 183 | 1.104478 | 2.02119474 | Stygiella incarcerata | 1712417 | Root_unresolved | Root_unresolved | 89 | 8.6e-19 | NR | ANM86867.1 | 1712417 | g17856 | i0 | 70 | 5.9016393442623 | 60 | 18 | 98.4 | 0 | 3 | 182 | 1000 | 1059 | ANM86867.1 pyruvate NADP oxidoreductase [Stygiella incarcerata] | diamond | 1080 | 89 | 1 | Eukaryota | Discoba | Jakobida | Stygiellidae | Stygiella | Stygiella incarcerata | ||||
| 29428316 | 29428316 | PRJNA263496_P_NODE_24689_length_162_cov_0.902655_g24436_i0 | PRJNA263496 | 24689 | 162 | 0.902655 | 1.4623011 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.1 | 0.00906 | NR | XP_002673592.1 | 5762 | g24436 | i0 | 43.4 | 6.07407407407407 | 53 | 30 | 98.1 | 0 | 3 | 161 | 58 | 110 | XP_002673592.1 uncharacterized protein NAEGRDRAFT_71175 [Naegleria gruberi] | diamond | 984 | 43.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31970577 | 31970577 | PRJNA263496_P_NODE_19538_length_175_cov_1.007937_g19285_i0 | PRJNA263496 | 19538 | 175 | 1.007937 | 1.76388975 | Trypanosoma rangeli SC58 | 429131 | Euglenozoa | other_Eukaryota | 41.6 | 0.0313 | NR | ESL05026.1 | 429131 | g19285 | i0 | 68 | 0.428571428571429 | 25 | 8 | 42.9 | 0 | 83 | 157 | 43 | 67 | ESL05026.1 hypothetical protein TRSC58_07379 [Trypanosoma rangeli SC58] | diamond | 75 | 41.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma rangeli |
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);;