contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8752501 | 8752501 | PRJNA493244_P_NODE_1086887_length_370_cov_4.576052_g1063766_i0 | PRJNA493244 | 1086887 | 370 | 4.576052 | 16.9313924 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 394 | 5.07e-105 | NTclustered | gi|2421781508|ref|XR_008254837.1| | 5693 | g1063766 | i0 | 94.862 | 93.1540540540541 | 253 | 12 | 68 | 1 | 1 | 252 | 316 | 64 | Trypanosoma cruzi ribosomal RNA large subunit beta, 5' partial (Tc00.1047053473001.10), partial rRNA | blastn | 34467 | 394 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 9383450 | 9383450 | PRJNA493244_P_NODE_1375768_length_275_cov_1.644860_g1352643_i0 | PRJNA493244 | 1375768 | 275 | 1.64486 | 4.523365 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 388 | 1.7e-103 | NTclustered | gi|77994632|gb|DQ207570.1| | 75058 | g1352643 | i0 | 94.141 | 93.0763636363636 | 256 | 13 | 92 | 2 | 1 | 254 | 372 | 117 | Bodo saltans strain HFCC13 18S ribosomal RNA gene, partial sequence | blastn | 25596 | 388 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 11302955 | 11302955 | PRJNA493244_P_NODE_1475949_length_248_cov_12.556150_g1452824_i0 | PRJNA493244 | 1475949 | 248 | 12.55615 | 31.139252 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 235 | 2.08e-57 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g1452824 | i0 | 89.005 | 69.5040322580645 | 191 | 20 | 77 | 1 | 1 | 190 | 5067 | 4877 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 17237 | 235 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 13209107 | 13209107 | PRJNA493244_P_NODE_1321151_length_290_cov_4.366812_g1298027_i0 | PRJNA493244 | 1321151 | 290 | 4.366812 | 12.6637548 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 71.3 | 7.41e-8 | NTclustered | gi|1002445629|ref|XM_015803608.1| | 157538 | g1298027 | i0 | 87.302 | 0.651724137931034 | 63 | 6 | 21 | 1 | 23 | 83 | 396 | 458 | Leptomonas pyrrhocoris putative 60S ribosomal protein L17 mRNA | blastn | 189 | 71.3 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 14484823 | 14484823 | PRJNA493244_P_NODE_1628312_length_214_cov_2.758170_g1605187_i0 | PRJNA493244 | 1628312 | 214 | 2.75817 | 5.9024838 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 213 | 8.17e-51 | NTclustered | gi|59891957|gb|AY753617.1| | 312471 | g1605187 | i0 | 100 | 54.7102803738318 | 115 | 0 | 54 | 0 | 1 | 115 | 552 | 666 | Neobodo designis isolate Panama 18S ribosomal RNA gene, partial sequence | blastn | 11708 | 213 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 14486532 | 14486532 | PRJNA493244_P_NODE_931372_length_438_cov_3.891247_g908368_i0 | PRJNA493244 | 931372 | 438 | 3.891247 | 17.04366186 | Leishmania hoogstraali | 63123 | Euglenozoa | other_Eukaryota | 137 | 1.14e-27 | NTclustered | gi|19070302|gb|AF345632.1| | 63123 | g908368 | i0 | 91.346 | 32.7831050228311 | 104 | 3 | 35 | 5 | 341 | 438 | 1339 | 1442 | Leishmania hoogstraali large subunit 24S beta ribosomal RNA gene and ribosomal intergenic spacer region, partial sequence | blastn | 14359 | 137 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania hoogstraali | ||
| 15757998 | 15757998 | PRJNA493244_P_NODE_1302753_length_296_cov_1.634043_g1279629_i0 | PRJNA493244 | 1302753 | 296 | 1.634043 | 4.83676728 | Parabodo caudatus | 351713 | Euglenozoa | other_Eukaryota | 490 | 4.909999999999998e-134 | NTclustered | gi|45739057|gb|AY490215.1| | 351713 | g1279629 | i0 | 96.61 | 71.8648648648649 | 295 | 10 | 99 | 0 | 2 | 296 | 82 | 376 | Bodo caudatus 18S ribosomal RNA gene, partial sequence | blastn | 21272 | 490 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Parabodo | Parabodo caudatus | |||
| 16402276 | 16402276 | PRJNA493244_P_NODE_1338273_length_285_cov_4.964286_g1315149_i0 | PRJNA493244 | 1338273 | 285 | 4.964286 | 14.1482151 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 486 | 6.089999999999999e-133 | NTclustered | gi|2163362298|dbj|LC663794.1| | 351713 | g1315149 | i0 | 100 | 92.7333333333333 | 263 | 0 | 92 | 0 | 1 | 263 | 1692 | 1430 | Parabodo caudatus Flagella An0622B gene for 18S rRNA, partial sequence | blastn | 26429 | 486 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Parabodo | Parabodo caudatus | |||
| 23406986 | 23406986 | PRJNA493244_P_NODE_1000499_length_406_cov_37.840580_g977411_i0 | PRJNA493244 | 1000499 | 406 | 37.84058 | 153.6327548 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 516 | 1.15e-141 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g977411 | i0 | 90.476 | 134.37684729064 | 399 | 26 | 96 | 9 | 18 | 406 | 4390 | 4786 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 54557 | 516 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 25326143 | 25326143 | PRJNA493244_P_NODE_1617940_length_216_cov_37.774194_g1594815_i0 | PRJNA493244 | 1617940 | 216 | 37.774194 | 81.59225904 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 265 | 2.25e-66 | NTclustered | gi|2026667531|dbj|LC618031.1| | 67003 | g1594815 | i0 | 91.623 | 106.842592592593 | 191 | 16 | 88 | 0 | 24 | 214 | 4900 | 5090 | Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence | blastn | 23078 | 267 | 0.99250936329588 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri |
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);;