contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942331 | 1942331 | PRJNA685607_P_NODE_55482_length_268_cov_1.030769_g55123_i0 | PRJNA685607 | 55482 | 268 | 1.030769 | 2.76246092 | Rhynchopus sp. ATCC 50230 | 202688 | Euglenozoa | other_Eukaryota | 340 | 4.68e-89 | NTclustered | gi|84105340|gb|DQ295216.1| | 202688 | g55123 | i0 | 94.954 | 100.152985074627 | 218 | 9 | 81 | 2 | 52 | 268 | 1067 | 851 | Rhynchopus sp. ATCC 50230 beta tubulin gene, partial cds | blastn | 26841 | 340 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Rhynchopus | Rhynchopus sp. ATCC 50230 | |||
| 3217131 | 3217131 | PRJNA685607_P_NODE_11203_length_470_cov_1.556675_g10847_i0 | PRJNA685607 | 11203 | 470 | 1.556675 | 7.3163725 | Leishmania braziliensis | 5660 | Euglenozoa | other_Eukaryota | 255 | 3.25e-63 | NTclustered | gi|2593257792|emb|OY748507.1| | 5660 | g10847 | i0 | 82.653 | 14.7276595744681 | 294 | 45 | 62 | 5 | 1 | 291 | 620104 | 620394 | Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 21 | blastn | 6922 | 255 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 4494270 | 4494270 | PRJNA685607_P_NODE_52664_length_273_cov_1.200000_g52305_i0 | PRJNA685607 | 52664 | 273 | 1.2 | 3.276 | Porcisia hertigi | 2761500 | Euglenozoa | other_Eukaryota | 211 | 3.91e-50 | NTclustered | gi|2794833687|ref|XM_067900318.1| | 2761500 | g52305 | i0 | 81.818 | 4.01831501831502 | 253 | 44 | 92 | 2 | 17 | 268 | 286 | 537 | Porcisia hertigi uncharacterized protein (JKF63_04332), partial mRNA | blastn | 1097 | 211 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Porcisia | Porcisia hertigi | ||
| 5769919 | 5769919 | PRJNA685607_P_NODE_38125_length_305_cov_1.318966_g37766_i0 | PRJNA685607 | 38125 | 305 | 1.318966 | 4.0228463 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 235 | 2.6299999999999996e-57 | NTclustered | gi|1002444685|ref|XM_015804414.1| | 157538 | g37766 | i0 | 82.772 | 21.0622950819672 | 267 | 42 | 87 | 4 | 9 | 273 | 1262 | 1526 | Leptomonas pyrrhocoris putative mitochondrial citrate synthase mRNA | blastn | 6424 | 235 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 5769944 | 5769944 | PRJNA685607_P_NODE_50185_length_278_cov_1.117073_g49826_i0 | PRJNA685607 | 50185 | 278 | 1.117073 | 3.10546294 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 291 | 4.98e-74 | NTclustered | gi|1002452915|ref|XM_015800795.1| | 157538 | g49826 | i0 | 87.952 | 6.22302158273381 | 249 | 26 | 89 | 4 | 1 | 247 | 271 | 25 | Leptomonas pyrrhocoris putative Ribosomal protein l3 mRNA | blastn | 1730 | 291 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 8319480 | 8319480 | PRJNA685607_P_NODE_57047_length_265_cov_0.859375_g56688_i0 | PRJNA685607 | 57047 | 265 | 0.859375 | 2.27734375 | Diplonemida sp. | 2015511 | Euglenozoa | other_Eukaryota | 287 | 6.099999999999999e-73 | NTclustered | gi|1214280013|gb|MF422198.1| | 2015511 | g56688 | i0 | 90 | 60.411320754717 | 230 | 12 | 83 | 8 | 46 | 264 | 1745 | 1516 | Diplonemida sp. isolate YPF1523 small subunit ribosomal RNA gene, partial sequence | blastn | 16009 | 287 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemida sp. | |||||
| 8319577 | 8319577 | PRJNA685607_P_NODE_80807_length_246_cov_0.890173_g80448_i0 | PRJNA685607 | 80807 | 246 | 0.890173 | 2.18982558 | Angomonas deanei | 59799 | Euglenozoa | other_Eukaryota | 230 | 9.56e-56 | NTclustered | gi|242133530|gb|GQ153664.1| | 59799 | g80448 | i0 | 84.298 | 6.04878048780488 | 242 | 30 | 97 | 8 | 9 | 246 | 3452 | 3215 | Crithidia sp. ATCC 30255 clone fosmid 6b12 genomic sequence | blastn | 1488 | 230 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Angomonas | Angomonas deanei | ||
| 9594966 | 9594966 | PRJNA685607_P_NODE_63188_length_254_cov_1.038674_g62829_i0 | PRJNA685607 | 63188 | 254 | 1.038674 | 2.63823196 | Rhynchomonas nasuta | 127150 | Euglenozoa | other_Eukaryota | 370 | 5.61e-98 | NTclustered | gi|226347420|gb|FJ807250.1| | 127150 | g62829 | i0 | 92.913 | 96.4606299212598 | 254 | 18 | 100 | 0 | 1 | 254 | 958 | 705 | Rhynchomonas nasuta strain ATCC 50292 elongation factor 1 alpha mRNA, partial cds | blastn | 24501 | 370 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchomonadidae | Rhynchomonas | Rhynchomonas nasuta | ||
| 13420235 | 13420235 | PRJNA685607_P_NODE_27171_length_340_cov_1.456929_g26812_i0 | PRJNA685607 | 27171 | 340 | 1.456929 | 4.9535586 | Leishmania sp. Ghana 2012 LV757 | 2803181 | Euglenozoa | other_Eukaryota | 276 | 1.7499999999999998e-69 | NTclustered | gi|2795001951|ref|XM_067845957.1| | 2803181 | g26812 | i0 | 85.185 | 20.1676470588235 | 270 | 38 | 79 | 2 | 72 | 340 | 7 | 275 | Leishmania sp. Ghana 2012 LV757 uncharacterized protein (GH5_06134), partial mRNA | blastn | 6857 | 276 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania sp. Ghana 2012 LV757 | ||
| 21068760 | 21068760 | PRJNA685607_P_NODE_47357_length_283_cov_1.814286_g46998_i0 | PRJNA685607 | 47357 | 283 | 1.814286 | 5.13442938 | Leishmania tarentolae | 5689 | Euglenozoa | other_Eukaryota | 174 | 5.3399999999999997e-39 | NTclustered | gi|587453|emb|X80231.1| | 5689 | g46998 | i0 | 82.126 | 3.56537102473498 | 207 | 33 | 72 | 4 | 8 | 212 | 211 | 7 | L.tarentolae CAM A gene for calmodulin | blastn | 1009 | 174 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania tarentolae | ||
| 23619100 | 23619100 | PRJNA685607_P_NODE_13459_length_436_cov_2.545455_g13101_i0 | PRJNA685607 | 13459 | 436 | 2.545455 | 11.0981838 | Rhynchopus sp. ATCC 50230 | 202688 | Euglenozoa | other_Eukaryota | 525 | 2.0599999999999998e-144 | NTclustered | gi|84105340|gb|DQ295216.1| | 202688 | g13101 | i0 | 93.948 | 104.970183486239 | 347 | 21 | 80 | 0 | 90 | 436 | 1 | 347 | Rhynchopus sp. ATCC 50230 beta tubulin gene, partial cds | blastn | 45767 | 525 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Rhynchopus | Rhynchopus sp. ATCC 50230 |
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);;