contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27277152 | 27277152 | PRJNA900028_P_NODE_132343_length_166_cov_0.871795_g131594_i0 | PRJNA900028 | 132343 | 166 | 0.871795 | 1.4471797 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 90.9 | 1.37e-19 | NR | CUG91310.1 | 75058 | g131594 | i0 | 81.5 | 0.975903614457831 | 54 | 10 | 97.6 | 0 | 164 | 3 | 243 | 296 | CUG91310.1 phosphomannomutase-like protein, putative [Bodo saltans] | diamond | 162 | 90.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27348090 | 27348090 | PRJNA900028_P_NODE_101423_length_175_cov_1.436508_g100674_i0 | PRJNA900028 | 101423 | 175 | 1.436508 | 2.513889 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 53.5 | 2.38e-6 | NR | XP_067696061.1 | 5663 | g100674 | i0 | 50 | 8.00571428571429 | 52 | 25 | 89.1 | 1 | 159 | 4 | 294 | 344 | XP_067696061.1 hypothetical protein CUR178_08407 [Leishmania enriettii] | diamond | 1401 | 53.9 | 0.992578849721707 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania enriettii | ||
| 27656206 | 27656206 | PRJNA900028_P_NODE_193564_length_161_cov_0.910714_g192815_i0 | PRJNA900028 | 193564 | 161 | 0.910714 | 1.46624954 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 70.9 | 1.46e-12 | NR | CUG62842.1 | 75058 | g192815 | i0 | 87.8 | 0.763975155279503 | 41 | 5 | 76.4 | 0 | 39 | 161 | 1 | 41 | CUG62842.1 chaperonin mitochondrial precursor, putative [Bodo saltans] | diamond | 123 | 70.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27940317 | 27940317 | PRJNA900028_P_NODE_170045_length_163_cov_0.894737_g169296_i0 | PRJNA900028 | 170045 | 163 | 0.894737 | 1.45842131 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 105 | 1.2699999999999999e-24 | NR | CUG89797.1 | 75058 | g169296 | i0 | 94.4 | 0.993865030674847 | 54 | 3 | 99.4 | 0 | 2 | 163 | 376 | 429 | CUG89797.1 signal recognition particle receptor, putative [Bodo saltans] | diamond | 162 | 105 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 28350607 | 28350607 | PRJNA900028_P_NODE_166646_length_163_cov_0.894737_g165897_i0 | PRJNA900028 | 166646 | 163 | 0.894737 | 1.45842131 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 77.8 | 5.55e-15 | NR | CUG82080.1 | 75058 | g165897 | i0 | 72 | 0.920245398773006 | 50 | 14 | 92 | 0 | 160 | 11 | 521 | 570 | CUG82080.1 ATP-dependent zinc metallopeptidase, putative [Bodo saltans] | diamond | 150 | 77.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29423957 | 29423957 | PRJNA900028_P_NODE_138189_length_166_cov_0.871795_g137440_i0 | PRJNA900028 | 138189 | 166 | 0.871795 | 1.4471797 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 46.2 | 8.09e-4 | NR | CUE73353.1 | 75058 | g137440 | i0 | 63.6 | 1.12048192771084 | 33 | 12 | 59.6 | 0 | 1 | 99 | 1255 | 1287 | CUE73353.1 membrane-associated protein, putative [Bodo saltans] | diamond | 186 | 46.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30245554 | 30245554 | PRJNA900028_P_NODE_181112_length_162_cov_0.902655_g180363_i0 | PRJNA900028 | 181112 | 162 | 0.902655 | 1.4623011 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 62 | 2.03e-9 | NR | CUF54747.1 | 75058 | g180363 | i0 | 51.9 | 1 | 54 | 26 | 100 | 0 | 162 | 1 | 707 | 760 | CUF54747.1 dynein heavy chain, putative [Bodo saltans] | diamond | 162 | 62 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30750957 | 30750957 | PRJNA900028_P_NODE_190254_length_161_cov_0.910714_g189505_i0 | PRJNA900028 | 190254 | 161 | 0.910714 | 1.46624954 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 92 | 5.09e-20 | NR | CUG93502.1 | 75058 | g189505 | i0 | 75.5 | 0.987577639751553 | 53 | 13 | 98.8 | 0 | 160 | 2 | 85 | 137 | CUG93502.1 ATP-dependent DEAD/DEAH box RNA helicase, putative [Bodo saltans] | diamond | 159 | 92 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30845703 | 30845703 | PRJNA900028_P_NODE_127794_length_167_cov_0.864407_g127045_i0 | PRJNA900028 | 127794 | 167 | 0.864407 | 1.44355969 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 88.6 | 9.26e-19 | NR | CUG51259.1 | 75058 | g127045 | i0 | 73.2 | 1.0059880239521 | 56 | 14 | 98.8 | 1 | 167 | 3 | 179 | 234 | CUG51259.1 Hypothetical protein, putative [Bodo saltans] | diamond | 168 | 88.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31035537 | 31035537 | PRJNA900028_P_NODE_156735_length_164_cov_0.886957_g155986_i0 | PRJNA900028 | 156735 | 164 | 0.886957 | 1.45460948 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 89.7 | 3.46e-19 | NR | CUG93535.1 | 75058 | g155986 | i0 | 77.8 | 0.98780487804878 | 54 | 12 | 98.8 | 0 | 163 | 2 | 150 | 203 | CUG93535.1 Hypothetical protein, putative [Bodo saltans] | diamond | 162 | 89.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31098304 | 31098304 | PRJNA900028_P_NODE_54155_length_203_cov_1.324675_g53406_i0 | PRJNA900028 | 54155 | 203 | 1.324675 | 2.68909025 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 43.5 | 0.0114 | NR | CUE69003.1 | 75058 | g53406 | i0 | 38.8 | 0.724137931034483 | 49 | 30 | 72.4 | 0 | 57 | 203 | 112 | 160 | CUE69003.1 Hypothetical protein, putative [Bodo saltans] | diamond | 147 | 43.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32332376 | 32332376 | PRJNA900028_P_NODE_169779_length_163_cov_0.894737_g169030_i0 | PRJNA900028 | 169779 | 163 | 0.894737 | 1.45842131 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 97.4 | 2.99e-22 | NR | CUG86086.1 | 75058 | g169030 | i0 | 77.8 | 0.993865030674847 | 54 | 12 | 99.4 | 0 | 1 | 162 | 73 | 126 | CUG86086.1 Hypothetical protein, putative [Bodo saltans] | diamond | 162 | 97.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans |
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);;