contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3596752 | 3596752 | PRJNA1218816_P_NODE_21663_length_465_cov_1.002551_g21230_i0 | PRJNA1218816 | 21663 | 465 | 1.002551 | 4.66186215 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 276 | 2.4599999999999997e-69 | NTclustered | gi|2794986241|ref|XM_067853970.1| | 2802991 | g21230 | i0 | 79.449 | 39.5612903225806 | 399 | 74 | 85 | 8 | 52 | 446 | 395 | 1 | Leishmania sp. Namibia uncharacterized protein (JIQ42_05862), partial mRNA | blastn | 18396 | 276 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania sp. Namibia | ||
| 4160580 | 4160580 | PRJNA1218816_P_NODE_60404_length_244_cov_0.900585_g59971_i0 | PRJNA1218816 | 60404 | 244 | 0.900585 | 2.1974274 | Neobodo saliens | 351712 | Euglenozoa | other_Eukaryota | 296 | 9.21e-76 | NTclustered | gi|25986824|gb|AY122626.1| | 351712 | g59971 | i0 | 88.797 | 88.016393442623 | 241 | 27 | 99 | 0 | 3 | 243 | 1804 | 1564 | Bodo saliens strain ATCC 50358 clone 5 heat shock protein 90 (HSP-90) gene, partial cds | blastn | 21476 | 296 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo saliens | |||
| 4160587 | 4160587 | PRJNA1218816_P_NODE_60904_length_243_cov_0.905882_g60471_i0 | PRJNA1218816 | 60904 | 243 | 0.905882 | 2.20129326 | Leishmania major | 5664 | Euglenozoa | other_Eukaryota | 134 | 7.6e-27 | NTclustered | gi|157867286|ref|XM_001682146.1| | 347515 | g60471 | i0 | 85.385 | 5.7119341563786 | 130 | 17 | 53 | 2 | 10 | 138 | 28 | 156 | Leishmania major strain Friedlin putative 60S ribosomal protein L39 partial mRNA | blastn | 1388 | 134 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania major | ||
| 5436698 | 5436698 | PRJNA1218816_P_NODE_51605_length_258_cov_1.627027_g51172_i0 | PRJNA1218816 | 51605 | 258 | 1.627027 | 4.19772966 | Porcisia hertigi | 2761500 | Euglenozoa | other_Eukaryota | 161 | 3.74e-35 | NTclustered | gi|2794831659|ref|XM_067901695.1| | 2761500 | g51172 | i0 | 83.708 | 25.1860465116279 | 178 | 22 | 67 | 6 | 1 | 173 | 430 | 255 | Porcisia hertigi uncharacterized protein (JKF63_05741), partial mRNA | blastn | 6498 | 161 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Porcisia | Porcisia hertigi | ||
| 9261202 | 9261202 | PRJNA1218816_P_NODE_17948_length_533_cov_1.908696_g17519_i0 | PRJNA1218816 | 17948 | 533 | 1.908696 | 10.17334968 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 399 | 1.6199999999999995e-106 | NTclustered | gi|1673141461|ref|XR_003828664.1| | 83891 | g17519 | i0 | 97.046 | 100.37148217636 | 237 | 7 | 78 | 0 | 295 | 531 | 4971 | 5207 | Trypanosoma conorhini 28S ribosomal RNA (Tco025E_06705), rRNA | blastn | 53498 | 399 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 13087101 | 13087101 | PRJNA1218816_P_NODE_42611_length_293_cov_1.759091_g42178_i0 | PRJNA1218816 | 42611 | 293 | 1.759091 | 5.15413663 | Tulamoeba bucina | 1525745 | Heterolobosea | other_Eukaryota | 121 | 7.339999999999999e-23 | NTclustered | gi|667714320|gb|KJ776753.1| | 1525745 | g42178 | i0 | 82.609 | 40.9317406143345 | 138 | 23 | 47 | 1 | 1 | 138 | 429 | 293 | Tulamoeba sp. AGBS-2014a 18S ribosomal RNA gene, partial sequence | blastn | 11993 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Tulamoebidae | Tulamoeba | Tulamoeba bucina | ||||
| 15073852 | 15073852 | PRJNA1218816_P_NODE_49732_length_264_cov_7.670157_g49299_i0 | PRJNA1218816 | 49732 | 264 | 7.670157 | 20.24921448 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 65.8 | 3.1e-6 | NTclustered | gi|38606345|gb|AY376153.1| | 5762 | g49299 | i0 | 97.368 | 6.19318181818182 | 38 | 1 | 14 | 0 | 175 | 212 | 1011 | 1048 | Naegleria gruberi isolate 7860 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 1635 | 65.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 15636473 | 15636473 | PRJNA1218816_P_NODE_57653_length_247_cov_0.885057_g57220_i0 | PRJNA1218816 | 57653 | 247 | 0.885057 | 2.18609079 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 401 | 1.9199999999999992e-107 | NTclustered | gi|59891962|gb|AY753622.1| | 312471 | g57220 | i0 | 95.968 | 96 | 248 | 9 | 100 | 1 | 1 | 247 | 960 | 713 | Neobodo designis isolate Dune 18S ribosomal RNA gene, partial sequence | blastn | 23712 | 401 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 18897754 | 18897754 | PRJNA1218816_P_NODE_33555_length_342_cov_1.092937_g33122_i0 | PRJNA1218816 | 33555 | 342 | 1.092937 | 3.73784454 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 255 | 2.3e-63 | NTclustered | gi|2593260053|emb|OY748516.1| | 5660 | g33122 | i0 | 80.403 | 62.5789473684211 | 347 | 58 | 100 | 10 | 1 | 342 | 907221 | 907562 | Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 30 | blastn | 21402 | 255 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 20734787 | 20734787 | PRJNA1218816_P_NODE_34637_length_335_cov_1.011450_g34204_i0 | PRJNA1218816 | 34637 | 335 | 1.01145 | 3.3883575 | Angomonas deanei | 59799 | Euglenozoa | other_Eukaryota | 322 | 2.18e-83 | NTclustered | gi|242133530|gb|GQ153664.1| | 59799 | g34204 | i0 | 84.735 | 26.2716417910448 | 321 | 49 | 96 | 0 | 1 | 321 | 3262 | 2942 | Crithidia sp. ATCC 30255 clone fosmid 6b12 genomic sequence | blastn | 8801 | 322 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Angomonas | Angomonas deanei | ||
| 23285812 | 23285812 | PRJNA1218816_P_NODE_62039_length_242_cov_0.911243_g61606_i0 | PRJNA1218816 | 62039 | 242 | 0.911243 | 2.20520806 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 224 | 4.369999999999999e-54 | NTclustered | gi|1673134151|ref|XM_029369857.1| | 83891 | g61606 | i0 | 83.402 | 10.8801652892562 | 241 | 40 | 99 | 0 | 1 | 241 | 594 | 834 | Trypanosoma conorhini elongation factor 2 (Tco025E_02934), partial mRNA | blastn | 2633 | 224 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 25272422 | 25272422 | PRJNA1218816_P_NODE_22280_length_455_cov_3.541885_g21847_i0 | PRJNA1218816 | 22280 | 455 | 3.541885 | 16.11557675 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 429 | 1.7399999999999999e-115 | NTclustered | gi|2593250474|emb|OY748421.1| | 5660 | g21847 | i0 | 83.884 | 114.898901098901 | 484 | 43 | 100 | 21 | 1 | 455 | 991046 | 990569 | Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27 | blastn | 52279 | 429 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis |
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);;