contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1263632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8017154 | 8017154 | PRJNA1263632_P_NODE_6547_length_250_cov_1.564972_g6529_i0 | PRJNA1263632 | 6547 | 250 | 1.564972 | 3.91243 | Paratrypanosoma confusum | 1470209 | Euglenozoa | other_Eukaryota | 189 | 1.6499999999999999e-43 | NTclustered | gi|452769044|gb|KC534710.1| | 1470209 | g6529 | i0 | 88.05 | 4.16 | 159 | 19 | 64 | 0 | 1 | 159 | 1018 | 1176 | Trypanosomatidae sp. TS-2013 clone C3829L4899o3 hypothetical protein gene, partial cds | blastn | 1040 | 189 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Paratrypanosoma | Paratrypanosoma confusum | ||
| 11842291 | 11842291 | PRJNA1263632_P_NODE_1670_length_464_cov_1.685422_g1652_i0 | PRJNA1263632 | 1670 | 464 | 1.685422 | 7.82035808 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 767 | 0 | NTclustered | gi|59891960|gb|AY753620.1| | 312471 | g1652 | i0 | 96.552 | 96.3318965517241 | 464 | 15 | 100 | 1 | 1 | 464 | 2084 | 1622 | Neobodo designis isolate TeToto3 18S ribosomal RNA gene, partial sequence | blastn | 44698 | 767 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 12532658 | 12532658 | PRJNA1263632_P_NODE_5450_length_271_cov_1.272727_g5432_i0 | PRJNA1263632 | 5450 | 271 | 1.272727 | 3.44909017 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 268 | 2.2699999999999994e-67 | NTclustered | gi|2593250474|emb|OY748421.1| | 5660 | g5432 | i0 | 95.294 | 86.3284132841328 | 170 | 6 | 62 | 2 | 1 | 169 | 991044 | 990876 | Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27 | blastn | 23395 | 268 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 21455854 | 21455854 | PRJNA1263632_P_NODE_6437_length_251_cov_0.865169_g6419_i0 | PRJNA1263632 | 6437 | 251 | 0.865169 | 2.17157419 | Kinetoplastea | 5653 | Euglenozoa | other_Eukaryota | 464 | 2.47e-126 | NTclustered | gi|59891965|gb|AY753625.1| | 313291 | g6419 | i0 | 100 | 82.7649402390438 | 251 | 0 | 100 | 0 | 1 | 251 | 727 | 977 | Bodonidae sp. Pan2 18S ribosomal RNA gene, partial sequence | blastn | 20774 | 464 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodonidae sp. Pan2 | |||
| 24589937 | 24589937 | PRJNA1263632_P_NODE_1720_length_458_cov_1.703896_g1702_i0 | PRJNA1263632 | 1720 | 458 | 1.703896 | 7.80384368 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 390 | 8.289999999999999e-104 | NTclustered | gi|1002446285|ref|XM_015803935.1| | 157538 | g1702 | i0 | 85.714 | 32.7161572052402 | 371 | 52 | 81 | 1 | 75 | 444 | 426 | 56 | Leptomonas pyrrhocoris putative 40S ribosomal protein S8 mRNA | blastn | 14984 | 390 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 25280111 | 25280111 | PRJNA1263632_P_NODE_7780_length_244_cov_0.900585_g7762_i0 | PRJNA1263632 | 7780 | 244 | 0.900585 | 2.1974274 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 206 | 1.6e-48 | NTclustered | gi|71666481|ref|XM_815106.1| | 5693 | g7762 | i0 | 82.553 | 6.45081967213115 | 235 | 39 | 96 | 2 | 5 | 238 | 7 | 240 | Trypanosoma cruzi 40S ribosomal protein S5, putative (Tc00.1047053506297.150), partial mRNA | blastn | 1574 | 206 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi |
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);;