contig_metadata
15 rows where bioproject = "PRJDB9741", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8938008 | 8938008 | PRJDB9741_P_NODE_4388_length_310_cov_2.214559_g4072_i0 | PRJDB9741 | 4388 | 310 | 2.214559 | 6.8651329 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 7.43e-16 | NR | UKK02333.1 | 68886 | g4072 | i0 | 66.7 | 0.493548387096774 | 51 | 17 | 49.4 | 0 | 308 | 156 | 156 | 206 | UKK02333.1 60S ribosomal protein L10 [Theileria orientalis] | diamond | 153 | 80.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 12764616 | 12764616 | PRJDB9741_P_NODE_5531_length_268_cov_2.004566_g5215_i0 | PRJDB9741 | 5531 | 268 | 2.004566 | 5.37223688 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.339999999999997e-42 | NTclustered | gi|833483999|ref|XM_012911664.1| | 5866 | g5215 | i0 | 83.938 | 51.9440298507463 | 193 | 29 | 72 | 2 | 32 | 223 | 234 | 43 | Babesia bigemina 60S ribosomal protein L44 protein, putative partial mRNA | blastn | 13921 | 183 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 15313232 | 15313232 | PRJDB9741_P_NODE_4373_length_311_cov_1.122137_g4057_i0 | PRJDB9741 | 4373 | 311 | 1.122137 | 3.48984607 | Babesia major | 127461 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.6799999999999999e-29 | NTclustered | gi|363586012|gb|JN391438.1| | 127461 | g4057 | i0 | 91.346 | 32.8553054662379 | 104 | 9 | 33 | 0 | 8 | 111 | 1202 | 1099 | Babesia major isolate Yili 28S ribosomal RNA gene, partial sequence | blastn | 10218 | 143 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia major | ||
| 18833578 | 18833578 | PRJDB9741_P_NODE_22735_length_173_cov_2.274194_g22418_i0 | PRJDB9741 | 22735 | 173 | 2.274194 | 3.93435562 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 3.61e-83 | NTclustered | gi|260232156|dbj|AK318155.1| | 5811 | g22418 | i0 | 100 | 4.01734104046243 | 173 | 0 | 100 | 0 | 1 | 173 | 527 | 699 | Toxoplasma gondii cDNA, clone: XTG05903.2, full cDNA, XTG Sugano cDNA library | blastn | 695 | 320 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 20411647 | 20411647 | PRJDB9741_P_NODE_38057_length_162_cov_0.902655_g37740_i0 | PRJDB9741 | 38057 | 162 | 0.902655 | 1.4623011 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.73e-6 | NTclustered | gi|1673122061|ref|XM_029366880.1| | 94643 | g37740 | i0 | 93.182 | 2.66049382716049 | 44 | 3 | 27 | 0 | 118 | 161 | 571 | 614 | Besnoitia besnoiti nuclear factor NF3 (BESB_085300), partial mRNA | blastn | 431 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 27380404 | 27380404 | PRJDB9741_P_NODE_28443_length_167_cov_0.864407_g28126_i0 | PRJDB9741 | 28443 | 167 | 0.864407 | 1.44355969 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.69e-11 | NR | CAL7857990.1 | 1344799 | g28126 | i0 | 72.7 | 4.67065868263473 | 44 | 12 | 79 | 0 | 133 | 2 | 3 | 46 | CAL7857990.1 unnamed protein product [Sarcocystis calchasi] | diamond | 780 | 65.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 27500712 | 27500712 | PRJDB9741_P_NODE_30423_length_166_cov_0.871795_g30106_i0 | PRJDB9741 | 30423 | 166 | 0.871795 | 1.4471797 | Theileria | 5873 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00957 | NR | XP_954264.1 | 5874 | g30106 | i0 | 45.7 | 3.03614457831325 | 46 | 25 | 83.1 | 0 | 165 | 28 | 197 | 242 | XP_954264.1 ribosomal protein s12, putative [Theileria annulata] | diamond | 504 | 43.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 28700476 | 28700476 | PRJDB9741_P_NODE_32647_length_165_cov_0.879310_g32330_i0 | PRJDB9741 | 32647 | 165 | 0.87931 | 1.4508615 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 3.09e-19 | NR | XP_067805129.1 | 323732 | g32330 | i0 | 72.2 | 14.7272727272727 | 54 | 15 | 98.2 | 0 | 2 | 163 | 38 | 91 | XP_067805129.1 bifunctional Ribosomal protein L13/Ribosomal protein L13 [Babesia duncani] | diamond | 2430 | 87 | 0.991954022988506 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 29369403 | 29369403 | PRJDB9741_P_NODE_12809_length_191_cov_1.429577_g12492_i0 | PRJDB9741 | 12809 | 191 | 1.429577 | 2.73049207 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 1.87e-5 | NR | SBT56993.1 | 864142 | g12492 | i0 | 100 | 0.329842931937173 | 21 | 0 | 33 | 0 | 177 | 115 | 393 | 413 | SBT56993.1 hypothetical protein POVWA1_079480 [Plasmodium ovale wallikeri] | diamond | 63 | 51.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30406119 | 30406119 | PRJDB9741_P_NODE_25513_length_169_cov_2.125000_g25196_i0 | PRJDB9741 | 25513 | 169 | 2.125 | 3.59125 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 3.82e-14 | NR | XP_013229778.1 | 5802 | g25196 | i0 | 66.7 | 2.87573964497041 | 54 | 18 | 95.9 | 0 | 1 | 162 | 39 | 92 | XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella] | diamond | 486 | 70.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 30695944 | 30695944 | PRJDB9741_P_NODE_30894_length_165_cov_1.913793_g30577_i0 | PRJDB9741 | 30894 | 165 | 1.913793 | 3.15775845 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.66e-8 | NR | UVC54537.1 | 68886 | g30577 | i0 | 58 | 0.909090909090909 | 50 | 21 | 90.9 | 0 | 154 | 5 | 166 | 215 | UVC54537.1 60S ribosomal L1/L10a protein [Theileria orientalis] | diamond | 150 | 58.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 31037935 | 31037935 | PRJDB9741_P_NODE_30475_length_166_cov_0.871795_g30158_i0 | PRJDB9741 | 30475 | 166 | 0.871795 | 1.4471797 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.78e-5 | NR | XP_026192373.1 | 88456 | g30158 | i0 | 53.7 | 3.74096385542169 | 41 | 19 | 74.1 | 0 | 164 | 42 | 301 | 341 | XP_026192373.1 uncharacterized protein LOC34620337 [Cyclospora cayetanensis] | diamond | 621 | 51.2 | 0.9921875 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31675882 | 31675882 | PRJDB9741_P_NODE_37617_length_162_cov_0.902655_g37300_i0 | PRJDB9741 | 37617 | 162 | 0.902655 | 1.4623011 | Babesia ovis | 5869 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 5.98e-11 | NR | GFE55439.1 | 5869 | g37300 | i0 | 55.8 | 2.88888888888889 | 52 | 23 | 96.3 | 0 | 161 | 6 | 149 | 200 | GFE55439.1 60S ribosomal protein L34 [Babesia ovis] | diamond | 468 | 65.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 31891449 | 31891449 | PRJDB9741_P_NODE_6757_length_241_cov_2.973958_g6440_i0 | PRJDB9741 | 6757 | 241 | 2.973958 | 7.16723878 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 5.22e-19 | NR | XP_625504.1 | 353152 | g6440 | i0 | 61 | 5.86307053941909 | 77 | 30 | 95.9 | 0 | 8 | 238 | 182 | 258 | XP_625504.1 60S ribosomal protein L7A, partial [Cryptosporidium parvum Iowa II] | diamond | 1413 | 89 | 0.991011235955056 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 32087278 | 32087278 | PRJDB9741_P_NODE_14778_length_187_cov_1.471014_g14461_i0 | PRJDB9741 | 14778 | 187 | 1.471014 | 2.75079618 | Plasmodium coatneyi | 208452 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 1.48e-18 | NR | XP_019915441.1 | 208452 | g14461 | i0 | 64.3 | 3.65775401069519 | 56 | 20 | 89.8 | 0 | 3 | 170 | 108 | 163 | XP_019915441.1 60S ribosomal protein L12 [Plasmodium coatneyi] | diamond | 684 | 84 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium coatneyi |
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);;