contig_metadata
11 rows where bioproject = "PRJNA781196", tax_clade = "Discoba" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759138 | 759138 | PRJNA781196_P_NODE_29561_length_322_cov_1.253012_g29184_i0 | PRJNA781196 | 29561 | 322 | 1.253012 | 4.03469864 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 568 | 2.4299999999999993e-157 | NTclustered | gi|77994631|gb|DQ207569.1| | 75058 | g29184 | i0 | 98.447 | 100.217391304348 | 322 | 5 | 100 | 0 | 1 | 322 | 920 | 1241 | Bodo saltans strain HFCC12 18S ribosomal RNA gene, partial sequence | blastn | 32270 | 568 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 759472 | 759472 | PRJNA781196_P_NODE_51401_length_252_cov_0.871508_g51024_i0 | PRJNA781196 | 51401 | 252 | 0.871508 | 2.19620016 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 160 | 9.85e-47 | NR | RNC32962.1 | 5693 | g51024 | i0 | 96.4 | 12 | 84 | 3 | 100 | 0 | 252 | 1 | 115 | 198 | RNC32962.1 nucleolar protein, partial [Trypanosoma cruzi] | diamond | 3024 | 160 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 8864266 | 8864266 | PRJNA781196_P_NODE_16827_length_405_cov_2.114458_g16450_i0 | PRJNA781196 | 16827 | 405 | 2.114458 | 8.5635549 | Leptomonas | 5683 | Euglenozoa | other_Eukaryota | 329 | 1.5999999999999996e-85 | NTclustered | gi|1002432462|ref|XM_015809846.1| | 157538 | g16450 | i0 | 82.278 | 102.264197530864 | 395 | 56 | 95 | 12 | 21 | 405 | 835 | 445 | Leptomonas pyrrhocoris elongation factor 1-alpha mRNA | blastn | 41417 | 329 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 10963780 | 10963780 | PRJNA781196_P_NODE_6049_length_631_cov_1.543011_g5680_i0 | PRJNA781196 | 6049 | 631 | 1.543011 | 9.73639941 | Euglena hiemalis | 392896 | Euglenozoa | other_Eukaryota | 569 | 1.3999999999999997e-157 | NTclustered | gi|1109178390|gb|KU375784.1| | 392896 | g5680 | i0 | 83.123 | 74.70206022187 | 634 | 97 | 99 | 10 | 1 | 629 | 754 | 1382 | Euglena hiemalis plastid glutamate 1-semialdehyde 2,1-aminotransferase mRNA, partial cds; nuclear gene for plastid product | blastn | 47137 | 569 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena hiemalis | ||
| 17337828 | 17337828 | PRJNA781196_P_NODE_58034_length_248_cov_0.891429_g57657_i0 | PRJNA781196 | 58034 | 248 | 0.891429 | 2.21074392 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 93.2 | 3.83e-20 | NR | KAJ9458341.1 | 91374 | g57657 | i0 | 54.9 | 0.991935483870968 | 82 | 37 | 99.2 | 0 | 1 | 246 | 192 | 273 | KAJ9458341.1 12-oxophytodienoate reductase 1 [Diplonema papillatum] | diamond | 246 | 93.2 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 19886511 | 19886511 | PRJNA781196_P_NODE_61956_length_245_cov_0.906977_g61579_i0 | PRJNA781196 | 61956 | 245 | 0.906977 | 2.22209365 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 70.5 | 1.29e-12 | NR | XP_029226282.1 | 83891 | g61579 | i0 | 52.1 | 0.869387755102041 | 71 | 34 | 86.9 | 0 | 216 | 4 | 1 | 71 | XP_029226282.1 60S acidic ribosomal protein P2 [Trypanosoma conorhini] | diamond | 213 | 70.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 26736574 | 26736574 | PRJNA781196_P_NODE_56201_length_249_cov_0.886364_g55824_i0 | PRJNA781196 | 56201 | 249 | 0.886364 | 2.20704636 | Trypanosoma cruzi Dm28c | 1416333 | Euglenozoa | other_Eukaryota | 46.2 | 0.00238 | NR | ESS67798.1 | 1416333 | g55824 | i0 | 36 | 0.903614457831325 | 75 | 47 | 89.2 | 1 | 247 | 26 | 690 | 764 | ESS67798.1 beta-adaptin [Trypanosoma cruzi Dm28c] | diamond | 225 | 46.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 28727330 | 28727330 | PRJNA781196_P_NODE_52147_length_252_cov_0.871508_g51770_i0 | PRJNA781196 | 52147 | 252 | 0.871508 | 2.19620016 | Novymonas esmeraldas | 1808958 | Euglenozoa | other_Eukaryota | 42.7 | 0.0386 | NR | KAK7195120.1 | 1808958 | g51770 | i0 | 25 | 1.19047619047619 | 100 | 57 | 98.8 | 3 | 2 | 250 | 47 | 145 | KAK7195120.1 C2 domain containing protein [Novymonas esmeraldas] | diamond | 300 | 42.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Novymonas | Novymonas esmeraldas | ||
| 29147502 | 29147502 | PRJNA781196_P_NODE_39989_length_283_cov_1.347619_g39612_i0 | PRJNA781196 | 39989 | 283 | 1.347619 | 3.81376177 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 129 | 7.25e-36 | NR | XP_815664.1 | 5693 | g39612 | i0 | 79 | 2.54416961130742 | 81 | 17 | 85.9 | 0 | 251 | 9 | 17 | 97 | XP_815664.1 ribosomal protein L27, putative [Trypanosoma cruzi] | diamond | 720 | 130 | 0.992307692307692 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 30496013 | 30496013 | PRJNA781196_P_NODE_62653_length_245_cov_0.906977_g62276_i0 | PRJNA781196 | 62653 | 245 | 0.906977 | 2.22209365 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 73.9 | 3.56e-13 | NR | CUG91657.1 | 75058 | g62276 | i0 | 44.7 | 1.15102040816327 | 94 | 36 | 98 | 4 | 5 | 244 | 212 | 303 | CUG91657.1 Hypothetical protein, putative, partial [Bodo saltans] | diamond | 282 | 73.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32203254 | 32203254 | PRJNA781196_P_NODE_59038_length_247_cov_0.896552_g58661_i0 | PRJNA781196 | 59038 | 247 | 0.896552 | 2.21448344 | Bodo sp. ATCC 5 | 2486707 | Euglenozoa | other_Eukaryota | 63.5 | 3.8e-10 | NR | AXL08267.1 | 155205 | g58661 | i0 | 53.6 | 5.89068825910931 | 56 | 26 | 68 | 0 | 241 | 74 | 67 | 122 | AXL08267.1 p23B protein, partial [Bodo sp. ATCC 50149] | diamond | 1455 | 63.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo sp. ATCC 50149 |
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);;