contig_metadata
9 rows where bioproject = "PRJNA782235" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9691583 | 9691583 | PRJNA782235_P_NODE_10148_length_288_cov_1.869767_g9959_i0 | PRJNA782235 | 10148 | 288 | 1.869767 | 5.38492896 | Vahlkampfia sp. | 1874882 | Heterolobosea | other_Eukaryota | 337 | 6.57e-88 | NTclustered | gi|2651357786|gb|PP174301.1| | 1874882 | g9959 | i0 | 96.552 | 54.0729166666667 | 203 | 7 | 70 | 0 | 20 | 222 | 2907 | 2705 | Vahlkampfia sp. isolate 24M small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15573 | 337 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Vahlkampfia | Vahlkampfia sp. | ||||
| 17790068 | 17790068 | PRJNA782235_P_NODE_26634_length_242_cov_0.911243_g26445_i0 | PRJNA782235 | 26634 | 242 | 0.911243 | 2.20520806 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 98.2 | 1.3299999999999995e-23 | NR | EPY27003.1 | 28005 | g26445 | i0 | 66.7 | 7.11570247933884 | 63 | 21 | 78.1 | 0 | 189 | 1 | 31 | 93 | EPY27003.1 small subunit ribosomal protein S18e [Strigomonas culicis] | diamond | 1722 | 98.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Strigomonas | Strigomonas culicis | ||
| 20338735 | 20338735 | PRJNA782235_P_NODE_15016_length_258_cov_1.372973_g14827_i0 | PRJNA782235 | 15016 | 258 | 1.372973 | 3.54227034 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 89.4 | 1.38e-18 | NR | XP_028887504.1 | 67003 | g14827 | i0 | 78.4 | 2.58139534883721 | 51 | 11 | 59.3 | 0 | 101 | 253 | 110 | 160 | XP_028887504.1 putative vacuolar protein sorting-associated protein 4 [Trypanosoma theileri] | diamond | 666 | 89.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 26958465 | 26958465 | PRJNA782235_P_NODE_14442_length_261_cov_1.638298_g14253_i0 | PRJNA782235 | 14442 | 261 | 1.638298 | 4.27595778 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 68.6 | 3.85e-11 | NR | XP_015660251.1 | 157538 | g14253 | i0 | 43.4 | 3.83908045977011 | 83 | 45 | 93.1 | 1 | 255 | 13 | 470 | 552 | XP_015660251.1 putative GTPase activating protein [Leptomonas pyrrhocoris] | diamond | 1002 | 68.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 27717403 | 27717403 | PRJNA782235_P_NODE_21324_length_247_cov_0.885057_g21135_i0 | PRJNA782235 | 21324 | 247 | 0.885057 | 2.18609079 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 47.8 | 5.51e-4 | NR | CUG93042.1 | 75058 | g21135 | i0 | 40.7 | 0.65587044534413 | 54 | 31 | 65.6 | 1 | 168 | 7 | 101 | 153 | CUG93042.1 membrane-associated protein, putative [Bodo saltans] | diamond | 162 | 47.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 27852532 | 27852532 | PRJNA782235_P_NODE_21464_length_247_cov_0.885057_g21275_i0 | PRJNA782235 | 21464 | 247 | 0.885057 | 2.18609079 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 73.2 | 6.59e-13 | NR | XP_003872957.1 | 929439 | g21275 | i0 | 49.4 | 4.76113360323887 | 79 | 40 | 96 | 0 | 11 | 247 | 145 | 223 | XP_003872957.1 flagellar protofilament ribbon protein-like protein [Leishmania mexicana MHOM/GT/2001/U1103] | diamond | 1176 | 73.6 | 0.994565217391304 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania mexicana | ||
| 31159073 | 31159073 | PRJNA782235_P_NODE_17135_length_251_cov_0.865169_g16946_i0 | PRJNA782235 | 17135 | 251 | 0.865169 | 2.17157419 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 105 | 3.53e-27 | NR | CUG87252.1 | 75058 | g16946 | i0 | 68.4 | 193.051792828685 | 79 | 25 | 94.4 | 0 | 13 | 249 | 33 | 111 | CUG87252.1 histone H3, putative [Bodo saltans] | diamond | 48456 | 105 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31570786 | 31570786 | PRJNA782235_P_NODE_25616_length_243_cov_0.905882_g25427_i0 | PRJNA782235 | 25616 | 243 | 0.905882 | 2.20129326 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 101 | 3.59e-23 | NR | XP_002677877.1 | 5762 | g25427 | i0 | 66.3 | 0.987654320987654 | 80 | 24 | 98.8 | 1 | 240 | 1 | 179 | 255 | XP_002677877.1 uncharacterized protein NAEGRDRAFT_66823 [Naegleria gruberi] | diamond | 240 | 101 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32623575 | 32623575 | PRJNA782235_P_NODE_13780_length_265_cov_1.604167_g13591_i0 | PRJNA782235 | 13780 | 265 | 1.604167 | 4.25104255 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 124 | 1.06e-32 | NR | KAH8614074.1 | 5699 | g13591 | i0 | 69 | 5.67169811320755 | 87 | 24 | 98.5 | 1 | 4 | 264 | 29 | 112 | KAH8614074.1 putative Ribosomal protein L7Ae L30e S12e Gadd45 family [Trypanosoma vivax] | diamond | 1503 | 124 | 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);;