contig_metadata
15 rows where bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4511168 | 4511168 | PRJNA700095_P_NODE_25944_length_337_cov_1.166667_g24680_i0 | PRJNA700095 | 25944 | 337 | 1.166667 | 3.93166779 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 3.89e-41 | NTclustered | gi|1620128357|ref|XM_028673401.1| | 5849 | g24680 | i0 | 83.417 | 5.12166172106825 | 199 | 29 | 58 | 4 | 139 | 335 | 266 | 70 | Plasmodium gallinaceum 40S ribosomal protein S17, putative (PGAL8A_00463400), partial mRNA | blastn | 1726 | 182 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 4511227 | 4511227 | PRJNA700095_P_NODE_35464_length_288_cov_1.065116_g34200_i0 | PRJNA700095 | 35464 | 288 | 1.065116 | 3.06753408 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 5.41e-44 | NTclustered | gi|1084774101|ref|XM_018783944.1| | 647221 | g34200 | i0 | 80.8 | 5.25347222222222 | 250 | 43 | 86 | 5 | 1 | 247 | 1860 | 1613 | Plasmodium gaboni putative splicing factor 3B subunit 1 partial mRNA | blastn | 1513 | 191 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 7562124 | 7562124 | PRJNA700095_P_NODE_4786_length_902_cov_2.780458_g3830_i0 | PRJNA700095 | 4786 | 902 | 2.780458 | 25.07973116 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 5.44e-4 | NTclustered | gi|221059494|ref|XM_002260357.1| | 5851 | g3830 | i0 | 100 | 1.08869179600887 | 32 | 0 | 4 | 0 | 364 | 395 | 1720 | 1751 | Plasmodium knowlesi strain H U3 small nucleolar RNA-associated protein 12, putative (PKNH_1234100), partial mRNA | blastn | 982 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 11387723 | 11387723 | PRJNA700095_P_NODE_20829_length_385_cov_3.298077_g19565_i0 | PRJNA700095 | 20829 | 385 | 3.298077 | 12.69759645 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 1.67e-15 | NTclustered | gi|1976646300|ref|XR_005506384.1| | 5851 | g19565 | i0 | 90.541 | 19.379220779220802 | 74 | 5 | 19 | 2 | 313 | 385 | 2235 | 2307 | Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA | blastn | 7461 | 97.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 12162433 | 12162433 | PRJNA700095_P_NODE_49050_length_255_cov_1.692308_g47786_i0 | PRJNA700095 | 49050 | 255 | 1.692308 | 4.3153854 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.98e-4 | NTclustered | gi|1620177738|ref|XM_028684073.1| | 880535 | g47786 | i0 | 100 | 0.12156862745098 | 31 | 0 | 12 | 0 | 3 | 33 | 66 | 36 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_1351000), partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 18534963 | 18534963 | PRJNA700095_P_NODE_24815_length_345_cov_3.786765_g23551_i0 | PRJNA700095 | 24815 | 345 | 3.786765 | 13.06433925 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.033 | NTclustered | gi|1620167184|ref|XM_028681527.1| | 880535 | g23551 | i0 | 100 | 0.0811594202898551 | 28 | 0 | 8 | 0 | 141 | 168 | 1713 | 1686 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_0818200), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 18535181 | 18535181 | PRJNA700095_P_NODE_67775_length_233_cov_2.256250_g66510_i0 | PRJNA700095 | 67775 | 233 | 2.25625 | 5.2570625 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 2.03e-22 | NTclustered | gi|1027957925|ref|XM_732147.2| | 31271 | g66510 | i0 | 78.421 | 26.0214592274678 | 190 | 36 | 81 | 5 | 41 | 229 | 762 | 577 | Plasmodium chabaudi chabaudi heat shock protein 90, putative (PCHAS_1311000), partial mRNA | blastn | 6063 | 119 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 21085579 | 21085579 | PRJNA700095_P_NODE_34037_length_292_cov_3.378995_g32773_i0 | PRJNA700095 | 34037 | 292 | 3.378995 | 9.8666654 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.62e-4 | NTclustered | gi|2785764582|ref|XM_067217315.1| | 5824 | g32773 | i0 | 92.857 | 1.31164383561644 | 42 | 2 | 14 | 1 | 109 | 149 | 401 | 442 | Plasmodium brasilianum sporozoite protein essential for cell traversal (MKS88_004162), partial mRNA | blastn | 383 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 23636295 | 23636295 | PRJNA700095_P_NODE_7079_length_749_cov_1.276627_g5957_i0 | PRJNA700095 | 7079 | 749 | 1.276627 | 9.56193623 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.021 | NTclustered | gi|2785761570|ref|XM_067215664.1| | 5824 | g5957 | i0 | 100 | 0.0387182910547397 | 29 | 0 | 4 | 0 | 647 | 675 | 281 | 253 | Plasmodium brasilianum uncharacterized protein (MKS88_002638), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 24909509 | 24909509 | PRJNA700095_P_NODE_33920_length_293_cov_1.400000_g32656_i0 | PRJNA700095 | 33920 | 293 | 1.4 | 4.102 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.84e-4 | NTclustered | gi|1620131118|ref|XM_028673862.1| | 5849 | g32656 | i0 | 97.059 | 1.27303754266212 | 34 | 1 | 12 | 0 | 68 | 101 | 5262 | 5229 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00504500), partial mRNA | blastn | 373 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 28693567 | 28693567 | PRJNA700095_P_NODE_48867_length_255_cov_4.708791_g47603_i0 | PRJNA700095 | 48867 | 255 | 4.708791 | 12.00741705 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 5.7299999999999996e-24 | NR | XP_067803689.1 | 323732 | g47603 | i0 | 58.4 | 1.82352941176471 | 77 | 32 | 90.6 | 0 | 234 | 4 | 8 | 84 | XP_067803689.1 bifunctional RNA recognition motif domain/RNA-binding domain superfamily/Nucleotide-binding alpha-beta plait domain superfamily [Babesia duncani] | diamond | 465 | 99.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 28862263 | 28862263 | PRJNA700095_P_NODE_27988_length_322_cov_1.843373_g26724_i0 | PRJNA700095 | 27988 | 322 | 1.843373 | 5.93566106 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 1.44e-10 | NR | KAF8821376.1 | 476202 | g26724 | i0 | 34.9 | 3.64285714285714 | 106 | 65 | 96 | 2 | 8 | 316 | 4 | 108 | KAF8821376.1 3' exoribonuclease family, domain 1 domain-containing protein [Cardiosporidium cionae] | diamond | 1173 | 67.8 | 0.994100294985251 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 30462337 | 30462337 | PRJNA700095_P_NODE_60673_length_244_cov_0.900585_g59409_i0 | PRJNA700095 | 60673 | 244 | 0.900585 | 2.1974274 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 8.47e-4 | NR | XP_012647374.1 | 1133968 | g59409 | i0 | 40 | 0.737704918032787 | 60 | 36 | 73.8 | 0 | 191 | 12 | 326 | 385 | XP_012647374.1 conserved Plasmodium membrane protein, unknown function [Babesia microti strain RI] | diamond | 180 | 47.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 30746254 | 30746254 | PRJNA700095_P_NODE_39434_length_277_cov_1.867647_g38170_i0 | PRJNA700095 | 39434 | 277 | 1.867647 | 5.17338219 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0205 | NR | KAF7458112.1 | 83540 | g38170 | i0 | 43.1 | 0.552346570397112 | 51 | 26 | 55.2 | 1 | 163 | 11 | 145 | 192 | KAF7458112.1 nuclear movement family protein [Cryptosporidium felis] | diamond | 153 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 31694592 | 31694592 | PRJNA700095_P_NODE_28517_length_319_cov_0.930894_g27253_i0 | PRJNA700095 | 28517 | 319 | 0.930894 | 2.96955186 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00708 | NR | KAF8820158.1 | 476202 | g27253 | i0 | 32.4 | 0.667711598746082 | 71 | 47 | 66.8 | 1 | 3 | 215 | 457 | 526 | KAF8820158.1 hypothetical protein IE077_003488 [Cardiosporidium cionae] | diamond | 213 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae |
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);;