contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370025 | 370025 | PRJNA270367_P_NODE_28121_length_213_cov_0.951220_g27916_i0 | PRJNA270367 | 28121 | 213 | 0.95122 | 2.0260986 | Trypanosoma grayi | 71804 | Euglenozoa | other_Eukaryota | 235 | 1.7299999999999998e-57 | NTclustered | gi|686630350|ref|XM_009309346.1| | 71804 | g27916 | i0 | 87.624 | 23.4741784037559 | 202 | 25 | 95 | 0 | 12 | 213 | 585 | 786 | Trypanosoma grayi ribosomal protein L13 partial mRNA | blastn | 5000 | 235 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma grayi | ||
| 4886278 | 4886278 | PRJNA270367_P_NODE_43864_length_165_cov_0.896552_g43659_i0 | PRJNA270367 | 43864 | 165 | 0.896552 | 1.4793108 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 108 | 2.9e-19 | NTclustered | gi|9864198|gb|AF291716.1|AF291716 | 5660 | g43659 | i0 | 79.503 | 2.87878787878788 | 161 | 25 | 95 | 8 | 9 | 165 | 2340 | 2184 | Leishmania braziliensis heat shock protein 70 (hsp70) gene, complete cds | blastn | 475 | 108 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 6747823 | 6747823 | PRJNA270367_P_NODE_39786_length_169_cov_0.866667_g39581_i0 | PRJNA270367 | 39786 | 169 | 0.866667 | 1.46466723 | Leishmania mexicana | 5665 | Euglenozoa | other_Eukaryota | 154 | 3.76e-33 | NTclustered | gi|401422019|ref|XM_003875449.1| | 929439 | g39581 | i0 | 86.111 | 9.8698224852071 | 144 | 18 | 85 | 2 | 19 | 161 | 390 | 248 | Leishmania mexicana MHOM/GT/2001/U1103 putative 40S ribosomal protein S15 partial mRNA | blastn | 1668 | 154 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania mexicana | ||
| 8023625 | 8023625 | PRJNA270367_P_NODE_9467_length_434_cov_2.574026_g9266_i0 | PRJNA270367 | 9467 | 434 | 2.574026 | 11.17127284 | Trypanosoma vivax | 5699 | Euglenozoa | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|340056612|emb|HE573026.1| | 1055687 | g9266 | i0 | 100 | 1.31797235023041 | 31 | 0 | 7 | 0 | 65 | 95 | 2877724 | 2877694 | Trypanosoma vivax Y486 annotated genomic contig, chromosome 10 | blastn | 572 | 58.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 13123903 | 13123903 | PRJNA270367_P_NODE_34611_length_185_cov_1.514706_g34406_i0 | PRJNA270367 | 34611 | 185 | 1.514706 | 2.8022061 | Angomonas deanei | 59799 | Euglenozoa | other_Eukaryota | 204 | 4.119999999999999e-48 | NTclustered | gi|242133530|gb|GQ153664.1| | 59799 | g34406 | i0 | 86.486 | 28.8432432432432 | 185 | 25 | 100 | 0 | 1 | 185 | 2974 | 3158 | Crithidia sp. ATCC 30255 clone fosmid 6b12 genomic sequence | blastn | 5336 | 204 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Angomonas | Angomonas deanei | ||
| 15672835 | 15672835 | PRJNA270367_P_NODE_38793_length_171_cov_0.836066_g38588_i0 | PRJNA270367 | 38793 | 171 | 0.836066 | 1.42967286 | Rhynchomonas nasuta | 127150 | Euglenozoa | other_Eukaryota | 283 | 4.67e-72 | NTclustered | gi|84105380|gb|DQ295211.1| | 127150 | g38588 | i0 | 96.491 | 101.994152046784 | 171 | 6 | 100 | 0 | 1 | 171 | 771 | 941 | Rhynchomonas nasuta alpha tubulin 1 gene, partial cds | blastn | 17441 | 283 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchomonadidae | Rhynchomonas | Rhynchomonas nasuta | ||
| 19496002 | 19496002 | PRJNA270367_P_NODE_31136_length_199_cov_1.040000_g30931_i0 | PRJNA270367 | 31136 | 199 | 1.04 | 2.0696 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 213 | 7.49e-51 | NTclustered | gi|301014698|gb|GQ377700.1| | 75058 | g30931 | i0 | 85.93 | 11.78391959799 | 199 | 28 | 100 | 0 | 1 | 199 | 406 | 208 | Bodo saltans ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 2345 | 213 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 23322001 | 23322001 | PRJNA270367_P_NODE_24479_length_233_cov_1.695652_g24274_i0 | PRJNA270367 | 24479 | 233 | 1.695652 | 3.95086916 | Porcisia hertigi | 2761500 | Euglenozoa | other_Eukaryota | 135 | 2.0100000000000003e-27 | NTclustered | gi|2794833687|ref|XM_067900318.1| | 2761500 | g24274 | i0 | 82.692 | 33.9484978540773 | 156 | 23 | 66 | 4 | 1 | 154 | 245 | 398 | Porcisia hertigi uncharacterized protein (JKF63_04332), partial mRNA | blastn | 7910 | 135 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Porcisia | Porcisia hertigi |
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);;