contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax_phylum = "Apicomplexa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5237859 | 5237859 | PRJEB75017_P_NODE_10825_length_281_cov_1.125000_g10696_i0 | PRJEB75017 | 10825 | 281 | 1.125 | 3.16125 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|1084986293|ref|XM_018780700.1| | 508771 | g10696 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 7 | 34 | 7593 | 7620 | Toxoplasma gondii ME49 hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 6513415 | 6513415 | PRJEB75017_P_NODE_11486_length_274_cov_2.263682_g11357_i0 | PRJEB75017 | 11486 | 274 | 2.263682 | 6.20248868 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.41e-4 | NTclustered | gi|916502880|ref|XM_013496737.1| | 44415 | g11357 | i0 | 89.13 | 0.372262773722628 | 46 | 5 | 17 | 0 | 132 | 177 | 201 | 246 | Eimeria mitis uncharacterized protein (EMH_0004320), partial mRNA | blastn | 102 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 6513431 | 6513431 | PRJEB75017_P_NODE_13226_length_257_cov_2.233696_g13097_i0 | PRJEB75017 | 13226 | 257 | 2.233696 | 5.74059872 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|921132467|ref|XM_013585315.1| | 51315 | g13097 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 57 | 84 | 627 | 654 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 11613816 | 11613816 | PRJEB75017_P_NODE_13510_length_255_cov_1.285714_g13381_i0 | PRJEB75017 | 13510 | 255 | 1.285714 | 3.2785707 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1843423058|dbj|LC541869.1| | 5823 | g13381 | i0 | 100 | 0.117647058823529 | 30 | 0 | 12 | 0 | 28 | 57 | 51179 | 51150 | Plasmodium berghei ANKA chromosome 1 telomere region, partial sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 11613840 | 11613840 | PRJEB75017_P_NODE_16530_length_246_cov_1.352601_g16401_i0 | PRJEB75017 | 16530 | 246 | 1.352601 | 3.32739846 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.27e-34 | NTclustered | gi|82914870|ref|XM_723786.1| | 5861 | g16401 | i0 | 80.383 | 9.24390243902439 | 209 | 41 | 85 | 0 | 37 | 245 | 983 | 775 | Plasmodium yoelii tubulin subunit alpha (PY17X_0420500), partial mRNA | blastn | 2274 | 159 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 12888864 | 12888864 | PRJEB75017_P_NODE_10251_length_286_cov_1.784038_g10122_i0 | PRJEB75017 | 10251 | 286 | 1.784038 | 5.10234868 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.52e-37 | NTclustered | gi|1673125678|ref|XM_029365676.1| | 94643 | g10122 | i0 | 85.714 | 28.3671328671329 | 161 | 21 | 56 | 2 | 48 | 207 | 1255 | 1096 | Besnoitia besnoiti chaperonin protein BiP (BESB_073030), partial mRNA | blastn | 8113 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 12888874 | 12888874 | PRJEB75017_P_NODE_11051_length_279_cov_1.111650_g10922_i0 | PRJEB75017 | 11051 | 279 | 1.11165 | 3.1015035 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 4.27e-5 | NTclustered | gi|916505532|ref|XM_013497862.1| | 44415 | g10922 | i0 | 77.273 | 11.0609318996416 | 132 | 13 | 46 | 14 | 45 | 172 | 323 | 205 | Eimeria mitis uncharacterized protein (EMH_0061120), partial mRNA | blastn | 3086 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 12888921 | 12888921 | PRJEB75017_P_NODE_18271_length_242_cov_1.384615_g18142_i0 | PRJEB75017 | 18271 | 242 | 1.384615 | 3.3507683 | Plasmodium malariae | 5858 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.6999999999999997e-31 | NTclustered | gi|1624466873|ref|XM_029007108.1| | 5858 | g18142 | i0 | 91.667 | 1.58677685950413 | 108 | 7 | 44 | 2 | 42 | 148 | 109 | 215 | Plasmodium malariae eukaryotic translation initiation factor 5A, putative (EIF5A), partial mRNA | blastn | 384 | 148 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 15437800 | 15437800 | PRJEB75017_P_NODE_11453_length_275_cov_1.158416_g11324_i0 | PRJEB75017 | 11453 | 275 | 1.158416 | 3.185644 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 4e-40 | NTclustered | gi|1084839774|ref|XM_018785426.1| | 647221 | g11324 | i0 | 78.571 | 16.2436363636364 | 280 | 53 | 100 | 6 | 1 | 275 | 698 | 975 | Plasmodium gaboni heat shock protein 70 partial mRNA | blastn | 4467 | 178 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 15437914 | 15437914 | PRJEB75017_P_NODE_9793_length_291_cov_1.279817_g9664_i0 | PRJEB75017 | 9793 | 291 | 1.279817 | 3.72426747 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|915013849|ref|XM_013396674.1| | 5801 | g9664 | i0 | 100 | 0.484536082474227 | 29 | 0 | 10 | 0 | 70 | 98 | 2146 | 2174 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 16712003 | 16712003 | PRJEB75017_P_NODE_12974_length_260_cov_1.251337_g12845_i0 | PRJEB75017 | 12974 | 260 | 1.251337 | 3.2534762 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2794943783|ref|XM_067859786.1| | 5871 | g12845 | i0 | 96.97 | 0.773076923076923 | 33 | 1 | 13 | 0 | 133 | 165 | 1719 | 1687 | Babesia caballi phage tail protein (BcabD6B2_32530), partial mRNA | blastn | 201 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 17986903 | 17986903 | PRJEB75017_P_NODE_13555_length_254_cov_2.011050_g13426_i0 | PRJEB75017 | 13555 | 254 | 2.01105 | 5.108067 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.25e-74 | NTclustered | gi|1620122260|ref|XM_028671860.1| | 5849 | g13426 | i0 | 90.222 | 76.9330708661417 | 225 | 20 | 88 | 2 | 1 | 224 | 671 | 894 | Plasmodium gallinaceum serine/threonine protein phosphatase PP1, putative (PGAL8A_00286000), partial mRNA | blastn | 19541 | 292 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum |
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);;