contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28244244 | 28244244 | PRJNA436017_P_NODE_3166_length_526_cov_2.370143_g2890_i0 | PRJNA436017 | 3166 | 526 | 2.370143 | 12.46695218 | Leishmania tarentolae | 5689 | Euglenozoa | other_Eukaryota | 59.7 | 4.86e-7 | NR | GET93831.1 | 5689 | g2890 | i0 | 32.8 | 2.15589353612167 | 125 | 76 | 66.7 | 4 | 159 | 509 | 50 | 174 | GET93831.1 elongation factor 1-gamma, putative [Leishmania tarentolae] | diamond | 1134 | 59.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania tarentolae | ||
| 28781019 | 28781019 | PRJNA436017_P_NODE_21847_length_175_cov_1.130435_g21549_i0 | PRJNA436017 | 21847 | 175 | 1.130435 | 1.97826125 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 87 | 1.19e-20 | NR | KAJ9458068.1 | 91374 | g21549 | i0 | 86 | 0.737142857142857 | 43 | 6 | 73.7 | 0 | 173 | 45 | 49 | 91 | KAJ9458068.1 60S ribosomal protein L37a [Diplonema papillatum] | diamond | 129 | 87 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 29128724 | 29128724 | PRJNA436017_P_NODE_14769_length_216_cov_2.039106_g14471_i0 | PRJNA436017 | 14769 | 216 | 2.039106 | 4.40446896 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 51.6 | 3.49e-6 | NR | KAL0490923.1 | 1008807 | g14471 | i0 | 41 | 1.76388888888889 | 61 | 28 | 84.7 | 1 | 183 | 1 | 13 | 65 | KAL0490923.1 ribosomal protein S20 [Acrasis kona] | diamond | 381 | 51.6 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29791344 | 29791344 | PRJNA436017_P_NODE_15771_length_208_cov_1.584795_g15473_i0 | PRJNA436017 | 15771 | 208 | 1.584795 | 3.2963736 | Porcisia hertigi | 2761500 | Euglenozoa | other_Eukaryota | 76.6 | 2.72e-14 | NR | XP_067753604.1 | 2761500 | g15473 | i0 | 49.3 | 1.97596153846154 | 69 | 35 | 99.5 | 0 | 2 | 208 | 137 | 205 | XP_067753604.1 hypothetical protein JKF63_01400 [Porcisia hertigi] | diamond | 411 | 76.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Porcisia | Porcisia hertigi | ||
| 31324525 | 31324525 | PRJNA436017_P_NODE_16735_length_201_cov_1.658537_g16437_i0 | PRJNA436017 | 16735 | 201 | 1.658537 | 3.33365937 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.6 | 2.58e-15 | NR | XP_011776787.1 | 679716 | g16437 | i0 | 66.7 | 1.46268656716418 | 48 | 16 | 71.6 | 0 | 144 | 1 | 2 | 49 | XP_011776787.1 mitochondrial carrier protein, putative [Trypanosoma brucei gambiense DAL972] | diamond | 294 | 79.3 | 0.991172761664565 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 32320835 | 32320835 | PRJNA436017_P_NODE_20979_length_178_cov_4.148936_g20681_i0 | PRJNA436017 | 20979 | 178 | 4.148936 | 7.38510608 | Stygiella incarcerata | 1712417 | Root_unresolved | Root_unresolved | 97.1 | 4.76e-22 | NR | ANM86194.1 | 1712417 | g20681 | i0 | 69.5 | 2.98314606741573 | 59 | 18 | 99.4 | 0 | 177 | 1 | 50 | 108 | ANM86194.1 60S ribosomal protein L3-2 [Stygiella incarcerata] | diamond | 531 | 97.1 | 1 | Eukaryota | Discoba | Jakobida | Stygiellidae | Stygiella | Stygiella incarcerata | ||||
| 32699399 | 32699399 | PRJNA436017_P_NODE_19320_length_186_cov_1.563758_g19022_i0 | PRJNA436017 | 19320 | 186 | 1.563758 | 2.90858988 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 45.1 | 0.0027 | NR | XP_044547693.1 | 51637 | g19022 | i0 | 44.4 | 6.14516129032258 | 45 | 24 | 71 | 1 | 133 | 2 | 1708 | 1752 | XP_044547693.1 uncharacterized protein C9374_005806 [Naegleria lovaniensis] | diamond | 1143 | 45.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 32793721 | 32793721 | PRJNA436017_P_NODE_5740_length_375_cov_2.991124_g5444_i0 | PRJNA436017 | 5740 | 375 | 2.991124 | 11.216715 | Andalucia godoyi | 505711 | Root_unresolved | Root_unresolved | 58.9 | 2.87e-7 | NR | KAF0852606.1 | 505711 | g5444 | i0 | 45.3 | 0.512 | 64 | 34 | 51.2 | 1 | 163 | 354 | 6 | 68 | KAF0852606.1 60S large subunit ribosomal protein uL0 (rpP0) [Andalucia godoyi] | diamond | 192 | 58.9 | 1 | Eukaryota | Discoba | Jakobida | Andaluciidae | Andalucia | Andalucia godoyi |
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);;