contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA857143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 843976 | 843976 | PRJNA857143_S_NODE_34261_length_446_cov_1.367292_g33169_i0 | PRJNA857143 | 34261 | 446 | 1.367292 | 6.09812232 | Plasmodium fragile | 5857 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.58e-4 | NTclustered | gi|817743955|ref|XM_012481509.1| | 5857 | g33169 | i0 | 94.737 | 0.0852017937219731 | 38 | 2 | 9 | 0 | 399 | 436 | 833 | 870 | Plasmodium fragile prolyl-tRNA synthetase (AK88_03899), partial mRNA | blastn | 38 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile | ||
| 2119581 | 2119581 | PRJNA857143_S_NODE_52262_length_390_cov_4.182965_g51169_i0 | PRJNA857143 | 52262 | 390 | 4.182965 | 16.3135635 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 9.93e-33 | NTclustered | gi|2794952857|ref|XM_067862083.1| | 5871 | g51169 | i0 | 79.821 | 35.9923076923077 | 223 | 35 | 56 | 7 | 166 | 383 | 941 | 1158 | Babesia caballi ATP synthase F1 gamma subunit (BcabD6B2_55510), partial mRNA | blastn | 14037 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 2119726 | 2119726 | PRJNA857143_S_NODE_67082_length_360_cov_1.229965_g65989_i0 | PRJNA857143 | 67082 | 360 | 1.229965 | 4.427874 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.034 | NTclustered | gi|1145256567|ref|XM_012905832.2| | 5854 | g65989 | i0 | 94.286 | 0.0972222222222222 | 35 | 1 | 10 | 1 | 123 | 157 | 885 | 852 | Plasmodium reichenowi peptidase, putative partial mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 3393912 | 3393912 | PRJNA857143_S_NODE_141403_length_273_cov_2.155000_g140310_i0 | PRJNA857143 | 141403 | 273 | 2.155 | 5.88315 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.39e-4 | NTclustered | gi|820698945|tpe|LN714498.1| | 432359 | g140310 | i0 | 100 | 1.40659340659341 | 31 | 0 | 11 | 0 | 208 | 238 | 2293489 | 2293519 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIII, complete genome | blastn | 384 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 7221331 | 7221331 | PRJNA857143_S_NODE_13606_length_607_cov_2.009363_g12569_i0 | PRJNA857143 | 13606 | 607 | 2.009363 | 12.19683341 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.005 | NTclustered | gi|1673111427|ref|XM_029358938.1| | 94643 | g12569 | i0 | 92.5 | 0.0658978583196046 | 40 | 2 | 6 | 1 | 78 | 116 | 417 | 456 | Besnoitia besnoiti uncharacterized protein (BESB_001830), partial mRNA | blastn | 40 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 7222215 | 7222215 | PRJNA857143_S_NODE_42466_length_416_cov_20.769679_g41373_i0 | PRJNA857143 | 42466 | 416 | 20.769679 | 86.40186464 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 2.32e-24 | NTclustered | gi|209881328|ref|XM_002142067.1| | 441375 | g41373 | i0 | 86.207 | 2.65865384615385 | 116 | 16 | 28 | 0 | 1 | 116 | 363 | 478 | Cryptosporidium muris RN66 40s ribosomal protein S14, putative (CMU_006770), mRNA | blastn | 1106 | 126 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 8888312 | 8888312 | PRJNA857143_S_NODE_58707_length_376_cov_1.940594_g57614_i0 | PRJNA857143 | 58707 | 376 | 1.940594 | 7.29663344 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|915000408|ref|XM_013392759.1| | 5801 | g57614 | i0 | 96.97 | 0.789893617021277 | 33 | 1 | 9 | 0 | 283 | 315 | 2499 | 2531 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 297 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 11046943 | 11046943 | PRJNA857143_S_NODE_150529_length_266_cov_1.616580_g149436_i0 | PRJNA857143 | 150529 | 266 | 1.61658 | 4.3001028 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|915125190|ref|XM_013478405.1| | 5804 | g149436 | i0 | 100 | 0.109022556390977 | 29 | 0 | 11 | 0 | 92 | 120 | 3740 | 3712 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 11047686 | 11047686 | PRJNA857143_S_NODE_40349_length_423_cov_5.388571_g39257_i0 | PRJNA857143 | 40349 | 423 | 5.388571 | 22.79365533 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.011 | NTclustered | gi|915129228|ref|XM_013479570.1| | 5804 | g39257 | i0 | 100 | 0.0685579196217494 | 29 | 0 | 7 | 0 | 174 | 202 | 156 | 184 | Eimeria maxima diacylglycerol kinase, putative partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 11439048 | 11439048 | PRJNA857143_S_NODE_201149_length_222_cov_22.362416_g200056_i0 | PRJNA857143 | 201149 | 222 | 22.362416 | 49.64456352 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.39e-46 | NTclustered | gi|7228470|gb|AF092927.1|AF092927 | 42890 | g200056 | i0 | 83.408 | 101.283783783784 | 223 | 27 | 100 | 8 | 1 | 222 | 2568 | 2781 | Sarcocystis neurona 28S large subunit ribosomal RNA gene, complete sequence | blastn | 22485 | 200 | 0.99 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis neurona | ||
| 12323184 | 12323184 | PRJNA857143_S_NODE_33710_length_448_cov_3.424000_g32618_i0 | PRJNA857143 | 33710 | 448 | 3.424 | 15.33952 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.012 | NTclustered | gi|915008181|ref|XM_013395071.1| | 5801 | g32618 | i0 | 96.875 | 0.0714285714285714 | 32 | 1 | 7 | 0 | 384 | 415 | 2087 | 2056 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 12714836 | 12714836 | PRJNA857143_S_NODE_141890_length_273_cov_1.380000_g140797_i0 | PRJNA857143 | 141890 | 273 | 1.38 | 3.7674 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.16e-5 | NTclustered | gi|1620131908|ref|XM_028674299.1| | 5849 | g140797 | i0 | 97.297 | 14.4395604395604 | 37 | 1 | 14 | 0 | 237 | 273 | 3331 | 3367 | Plasmodium gallinaceum chromosome condensation protein, putative (PGAL8A_00030200), partial mRNA | blastn | 3942 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 17421814 | 17421814 | PRJNA857143_S_NODE_179294_length_248_cov_3.377143_g178201_i0 | PRJNA857143 | 179294 | 248 | 3.377143 | 8.37531464 | Theileria parva | 5875 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.6899999999999996e-24 | NTclustered | gi|2626850598|ref|XM_757776.2| | 333668 | g178201 | i0 | 81.529 | 14.2661290322581 | 157 | 24 | 62 | 5 | 4 | 157 | 389 | 543 | Theileria parva strain Muguga ribosomal protein S23 (S12) (RpS23), mRNA | blastn | 3538 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 17422546 | 17422546 | PRJNA857143_S_NODE_77614_length_342_cov_2.044610_g76521_i0 | PRJNA857143 | 77614 | 342 | 2.04461 | 6.9925662 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|921126035|ref|XM_013582173.1| | 51315 | g76521 | i0 | 90.698 | 0.453216374269006 | 43 | 1 | 13 | 3 | 14 | 56 | 765 | 804 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 155 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 17812831 | 17812831 | PRJNA857143_S_NODE_96954_length_316_cov_6.567901_g95861_i0 | PRJNA857143 | 96954 | 316 | 6.567901 | 20.75456716 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.03 | NTclustered | gi|260233916|dbj|AK318321.1| | 5811 | g95861 | i0 | 100 | 0.265822784810127 | 28 | 0 | 9 | 0 | 159 | 186 | 536 | 509 | Toxoplasma gondii cDNA, clone: XTG07019.2, full cDNA, XTG Sugano cDNA library | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 19970857 | 19970857 | PRJNA857143_S_NODE_64916_length_364_cov_1.340206_g63823_i0 | PRJNA857143 | 64916 | 364 | 1.340206 | 4.87834984 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 7.22e-24 | NTclustered | gi|1673125320|ref|XM_029365497.1| | 94643 | g63823 | i0 | 89.109 | 14.3571428571429 | 101 | 10 | 27 | 1 | 16 | 115 | 307 | 407 | Besnoitia besnoiti ribosomal protein RPL11 (BESB_071240), partial mRNA | blastn | 5226 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 21637361 | 21637361 | PRJNA857143_S_NODE_197797_length_235_cov_3.364198_g196704_i0 | PRJNA857143 | 197797 | 235 | 3.364198 | 7.9058653 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|260233916|dbj|AK318321.1| | 5811 | g196704 | i0 | 100 | 0.382978723404255 | 29 | 0 | 12 | 0 | 87 | 115 | 537 | 509 | Toxoplasma gondii cDNA, clone: XTG07019.2, full cDNA, XTG Sugano cDNA library | blastn | 90 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii |
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);;