contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA506002" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4310808 | 4310808 | PRJNA506002_S_NODE_30884_length_305_cov_3.271552_g30638_i0 | PRJNA506002 | 30884 | 305 | 3.271552 | 9.9782336 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 209 | 1.59e-49 | NTclustered | gi|1673142225|ref|XM_029373915.1| | 83891 | g30638 | i0 | 85.5 | 0.655737704918033 | 200 | 29 | 66 | 0 | 104 | 303 | 1532 | 1333 | Trypanosoma conorhini ATPase beta subunit (Tco025E_07048), partial mRNA | blastn | 200 | 209 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 6861781 | 6861781 | PRJNA506002_S_NODE_40826_length_280_cov_1.864734_g40580_i0 | PRJNA506002 | 40826 | 280 | 1.864734 | 5.2212552 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 76.8 | 1.53e-9 | NTclustered | gi|1673142105|ref|XM_029373822.1| | 83891 | g40580 | i0 | 92.453 | 0.746428571428571 | 53 | 4 | 19 | 0 | 228 | 280 | 60 | 112 | Trypanosoma conorhini uncharacterized protein (Tco025E_06955), partial mRNA | blastn | 209 | 76.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 13237614 | 13237614 | PRJNA506002_S_NODE_10871_length_401_cov_7.399390_g10625_i0 | PRJNA506002 | 10871 | 401 | 7.39939 | 29.6715539 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 538 | 2.4199999999999995e-148 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g10625 | i0 | 90.754 | 143.01246882793 | 411 | 27 | 100 | 9 | 1 | 401 | 4781 | 4372 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 57348 | 538 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 13238077 | 13238077 | PRJNA506002_S_NODE_61311_length_246_cov_0.890173_g61065_i0 | PRJNA506002 | 61311 | 246 | 0.890173 | 2.18982558 | Trypanosoma grayi | 71804 | Euglenozoa | other_Eukaryota | 156 | 1.65e-33 | NTclustered | gi|686640686|ref|XM_009314514.1| | 71804 | g61065 | i0 | 83.333 | 6.39837398373984 | 168 | 28 | 68 | 0 | 2 | 169 | 478 | 645 | Trypanosoma grayi 60S ribosomal protein L10a partial mRNA | blastn | 1574 | 156 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 15786676 | 15786676 | PRJNA506002_S_NODE_42633_length_276_cov_2.197044_g42387_i0 | PRJNA506002 | 42633 | 276 | 2.197044 | 6.06384144 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 195 | 3.98e-45 | NTclustered | gi|1002453653|ref|XM_015799444.1| | 157538 | g42387 | i0 | 80.784 | 11.8152173913043 | 255 | 43 | 91 | 4 | 25 | 276 | 805 | 554 | Leptomonas pyrrhocoris 40S ribosomal protein S2 mRNA | blastn | 3261 | 195 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 15786725 | 15786725 | PRJNA506002_S_NODE_47333_length_266_cov_2.595855_g47087_i0 | PRJNA506002 | 47333 | 266 | 2.595855 | 6.9049743 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 303 | 6.08e-78 | NTclustered | gi|1002460865|ref|XM_015796485.1| | 157538 | g47087 | i0 | 90.171 | 70.6353383458647 | 234 | 21 | 88 | 2 | 34 | 266 | 795 | 563 | Leptomonas pyrrhocoris putative 60S ribosomal protein L2 putative60S ribosomal protein L8 mRNA | blastn | 18789 | 303 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 18335406 | 18335406 | PRJNA506002_S_NODE_11395_length_397_cov_3.234568_g11149_i0 | PRJNA506002 | 11395 | 397 | 3.234568 | 12.84123496 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 719 | 0 | NTclustered | gi|33317834|gb|AF464896.1| | 312471 | g11149 | i0 | 99.494 | 98.0201511335013 | 395 | 2 | 99 | 0 | 1 | 395 | 1669 | 2063 | Bodo designis strain DH 18S small subunit ribosomal RNA gene, partial sequence | blastn | 38914 | 719 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 18335622 | 18335622 | PRJNA506002_S_NODE_36455_length_290_cov_2.336406_g36209_i0 | PRJNA506002 | 36455 | 290 | 2.336406 | 6.7755774 | Crithidia fasciculata | 5656 | Euglenozoa | other_Eukaryota | 128 | 4.34e-25 | NTclustered | gi|343622|gb|M95682.1|TRFMTOFEAT | 5656 | g36209 | i0 | 88.571 | 1.82413793103448 | 105 | 12 | 36 | 0 | 186 | 290 | 1898 | 1794 | Crithidia fasciculata mitochondrial heat shock protein mRNA sequence | blastn | 529 | 128 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 19609980 | 19609980 | PRJNA506002_S_NODE_44636_length_272_cov_1.296482_g44390_i0 | PRJNA506002 | 44636 | 272 | 1.296482 | 3.52643104 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 195 | 3.92e-45 | NTclustered | gi|1002447734|ref|XM_015802890.1| | 157538 | g44390 | i0 | 81.893 | 30.8051470588235 | 243 | 32 | 87 | 9 | 37 | 272 | 463 | 226 | Leptomonas pyrrhocoris putative 40S ribosomal protein S18 mRNA | blastn | 8379 | 195 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 24709693 | 24709693 | PRJNA506002_S_NODE_15120_length_371_cov_1.731544_g14874_i0 | PRJNA506002 | 15120 | 371 | 1.731544 | 6.42402824 | Leishmania mexicana | 5665 | Euglenozoa | other_Eukaryota | 156 | 2.61e-33 | NTclustered | gi|401419743|ref|XM_003874312.1| | 929439 | g14874 | i0 | 81.221 | 4.75471698113208 | 213 | 23 | 55 | 12 | 161 | 363 | 2538 | 2333 | Leishmania mexicana MHOM/GT/2001/U1103 elongation factor 2 partial mRNA | blastn | 1764 | 156 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania mexicana |
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);;