contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11503357 | 11503357 | PRJEB28062_P_NODE_68730_length_416_cov_5.344023_g66369_i0 | PRJEB28062 | 68730 | 416 | 5.344023 | 22.23113568 | Leptomonas seymouri | 5684 | Euglenozoa | other_Eukaryota | 68.9 | 1.03e-11 | NR | KPI89133.1 | 5684 | g66369 | i0 | 57.6 | 3.13701923076923 | 66 | 25 | 47.6 | 2 | 398 | 201 | 44 | 106 | KPI89133.1 putative RNA binding protein rbp16 [Leptomonas seymouri] | diamond | 1305 | 68.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas seymouri | ||
| 20426160 | 20426160 | PRJEB28062_P_NODE_76657_length_388_cov_7.453968_g74295_i0 | PRJEB28062 | 76657 | 388 | 7.453968 | 28.92139584 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 213 | 1.03e-68 | NR | QLA09569.1 | 3039 | g74295 | i0 | 87.8 | 0.889175257731959 | 115 | 14 | 88.9 | 0 | 373 | 29 | 16 | 130 | QLA09569.1 40S small subunit ribosomal protein uS8 [Euglena gracilis] | diamond | 345 | 213 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 27311454 | 27311454 | PRJEB28062_P_NODE_51503_length_495_cov_13.834123_g49153_i0 | PRJEB28062 | 51503 | 495 | 13.834123 | 68.47890885 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 141 | 9.79e-39 | NR | RNF20249.1 | 5693 | g49153 | i0 | 66.7 | 5.23636363636364 | 120 | 34 | 69.7 | 3 | 445 | 101 | 97 | 215 | RNF20249.1 histone H2A [Trypanosoma cruzi] | diamond | 2592 | 141 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 27570275 | 27570275 | PRJEB28062_P_NODE_137564_length_203_cov_5.230769_g135200_i0 | PRJEB28062 | 137564 | 203 | 5.230769 | 10.61846107 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 43.5 | 0.012 | NR | CAA43633.1 | 3039 | g135200 | i0 | 81.8 | 0.32512315270936 | 22 | 4 | 32.5 | 0 | 191 | 126 | 1034 | 1055 | CAA43633.1 light harvesting chlorophyll a /b binding protein of PSII, partial [Euglena gracilis] | diamond | 66 | 43.5 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 27980833 | 27980833 | PRJEB28062_P_NODE_121725_length_256_cov_4.950820_g119361_i0 | PRJEB28062 | 121725 | 256 | 4.95082 | 12.6740992 | Trypanosoma melophagium | 715481 | Euglenozoa | other_Eukaryota | 68.2 | 1.11e-11 | NR | XP_067190472.1 | 715481 | g119361 | i0 | 46 | 4.6171875 | 87 | 42 | 96.1 | 2 | 7 | 252 | 94 | 180 | XP_067190472.1 uncharacterized protein LSM04_004772 [Trypanosoma melophagium] | diamond | 1182 | 68.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma melophagium | ||
| 28605839 | 28605839 | PRJEB28062_P_NODE_58887_length_457_cov_7.981771_g56528_i0 | PRJEB28062 | 58887 | 457 | 7.981771 | 36.47669347 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.4 | 5.05e-8 | NR | DAA05885.1 | 3039 | g56528 | i0 | 83.3 | 1.4835886214442 | 36 | 4 | 22.3 | 2 | 77 | 178 | 122 | 157 | DAA05885.1 TPA_inf: chloroplast light-harvesting complex II protein precursor Lhcbm5, partial [Euglena gracilis] | diamond | 678 | 62.4 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 28644010 | 28644010 | PRJEB28062_P_NODE_134987_length_225_cov_6.006579_g132623_i0 | PRJEB28062 | 134987 | 225 | 6.006579 | 13.51480275 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 128 | 1.05e-35 | NR | QLA09605.1 | 3039 | g132623 | i0 | 88.2 | 0.906666666666667 | 68 | 8 | 90.7 | 0 | 22 | 225 | 93 | 160 | QLA09605.1 60S large subunit ribosomal protein uL11 [Euglena gracilis] | diamond | 204 | 128 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 28927979 | 28927979 | PRJEB28062_P_NODE_104688_length_301_cov_1.907895_g102325_i0 | PRJEB28062 | 104688 | 301 | 1.907895 | 5.74276395 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 80.5 | 4.48e-17 | NR | QLA09634.1 | 3039 | g102325 | i0 | 84.4 | 0.448504983388704 | 45 | 7 | 44.9 | 0 | 279 | 145 | 51 | 95 | QLA09634.1 60S large subunit ribosomal protein eL33 [Euglena gracilis] | diamond | 135 | 80.5 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 29559381 | 29559381 | PRJEB28062_P_NODE_46910_length_524_cov_7.388027_g44566_i0 | PRJEB28062 | 46910 | 524 | 7.388027 | 38.71326148 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 50.1 | 0.00156 | NR | CUE91196.1 | 75058 | g44566 | i0 | 41.3 | 0.360687022900763 | 63 | 37 | 36.1 | 0 | 511 | 323 | 593 | 655 | CUE91196.1 Hypothetical protein, putative [Bodo saltans] | diamond | 189 | 50.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29653865 | 29653865 | PRJEB28062_P_NODE_92530_length_337_cov_3.064394_g90168_i0 | PRJEB28062 | 92530 | 337 | 3.064394 | 10.32700778 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 147 | 5.229999999999998e-43 | NR | QLA09633.1 | 3039 | g90168 | i0 | 76 | 0.85459940652819 | 96 | 23 | 85.5 | 0 | 314 | 27 | 44 | 139 | QLA09633.1 60S large subunit ribosomal protein eL32 [Euglena gracilis] | diamond | 288 | 147 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 29970010 | 29970010 | PRJEB28062_P_NODE_96591_length_325_cov_2.670635_g94229_i0 | PRJEB28062 | 96591 | 325 | 2.670635 | 8.67956375 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 163 | 4.1100000000000004e-49 | NR | QLA09612.1 | 3039 | g94229 | i0 | 81.9 | 0.867692307692308 | 94 | 17 | 86.8 | 0 | 319 | 38 | 70 | 163 | QLA09612.1 60S large subunit ribosomal protein uL22 [Euglena gracilis] | diamond | 282 | 163 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 30381146 | 30381146 | PRJEB28062_P_NODE_116333_length_269_cov_7.908163_g113970_i0 | PRJEB28062 | 116333 | 269 | 7.908163 | 21.27295847 | Trypanosoma vivax | 5699 | Euglenozoa | other_Eukaryota | 50.1 | 1.31e-4 | NR | KAH8605757.1 | 5699 | g113970 | i0 | 34.1 | 0.91449814126394 | 82 | 50 | 89.2 | 2 | 30 | 269 | 396 | 475 | KAH8605757.1 Protein kinase domain [Trypanosoma vivax] | diamond | 246 | 50.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 32429613 | 32429613 | PRJEB28062_P_NODE_121419_length_257_cov_2.260870_g119055_i0 | PRJEB28062 | 121419 | 257 | 2.26087 | 5.8104359 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 55.5 | 1.32e-6 | NR | XP_067082035.1 | 5694 | g119055 | i0 | 49 | 1.14396887159533 | 49 | 25 | 57.2 | 0 | 15 | 161 | 277 | 325 | XP_067082035.1 NADH-cytochrome b5 reductase, putative [Trypanosoma equiperdum] | diamond | 294 | 55.8 | 0.99462365591397806 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma equiperdum |
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);;