contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4373004 | 4373004 | PRJNA561212_P_NODE_7604_length_398_cov_0.950769_g7393_i0 | PRJNA561212 | 7604 | 398 | 0.950769 | 3.78406062 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.28e-4 | NTclustered | gi|915002923|ref|XM_013393482.1| | 5801 | g7393 | i0 | 100 | 0.0804020100502513 | 32 | 0 | 8 | 0 | 341 | 372 | 2635 | 2666 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 5649264 | 5649264 | PRJNA561212_P_NODE_25165_length_243_cov_1.323529_g24954_i0 | PRJNA561212 | 25165 | 243 | 1.323529 | 3.21617547 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1145258325|ref|XM_012906907.2| | 5854 | g24954 | i0 | 100 | 0.395061728395062 | 30 | 0 | 12 | 0 | 112 | 141 | 4478 | 4507 | Plasmodium reichenowi zinc finger, C3HC4 type, putative partial mRNA | blastn | 96 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 6923530 | 6923530 | PRJNA561212_P_NODE_3646_length_578_cov_3.916832_g3439_i0 | PRJNA561212 | 3646 | 578 | 3.916832 | 22.63928896 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 8.470000000000001e-85 | NTclustered | gi|1843572353|ref|XM_034565981.1| | 5823 | g3439 | i0 | 83.807 | 70.3321799307958 | 352 | 49 | 60 | 8 | 172 | 519 | 348 | 1 | Plasmodium berghei ANKA ubiquitin-60S ribosomal protein L40, putative (PBANKA_1141700), partial mRNA | blastn | 40652 | 327 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 8198379 | 8198379 | PRJNA561212_P_NODE_2707_length_667_cov_12.333333_g2502_i0 | PRJNA561212 | 2707 | 667 | 12.333333 | 82.26333111 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 3.73e-49 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g2502 | i0 | 78.931 | 4.66266866566717 | 318 | 59 | 47 | 8 | 135 | 448 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 3110 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 8783616 | 8783616 | PRJNA561212_P_NODE_22147_length_249_cov_1.227273_g21936_i0 | PRJNA561212 | 22147 | 249 | 1.227273 | 3.05590977 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 2.89e-6 | NTclustered | gi|1624459616|ref|XR_003751929.1| | 5858 | g21936 | i0 | 93.182 | 3.49799196787149 | 44 | 3 | 18 | 0 | 177 | 220 | 2313 | 2356 | Plasmodium malariae rRNA (PmUG01_03032100), rRNA | blastn | 871 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 9474039 | 9474039 | PRJNA561212_P_NODE_2768_length_661_cov_20.168367_g2563_i0 | PRJNA561212 | 2768 | 661 | 20.168367 | 133.31290587 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 1e-64 | NTclustered | gi|2787704165|ref|XM_067344148.1| | 1280935 | g2563 | i0 | 81.081 | 60.3464447806354 | 333 | 57 | 50 | 6 | 133 | 462 | 1 | 330 | Cryptosporidium sp. chipmunk genotype I 60S ribosomal L40 (ELE39_001109), partial mRNA | blastn | 39889 | 261 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I | ||
| 12024423 | 12024423 | PRJNA561212_P_NODE_17290_length_273_cov_1.315000_g17079_i0 | PRJNA561212 | 17290 | 273 | 1.315 | 3.58995 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.39e-4 | NTclustered | gi|1620180995|ref|XM_028684456.1| | 880535 | g17079 | i0 | 100 | 2.12454212454212 | 31 | 0 | 11 | 0 | 235 | 265 | 3758 | 3788 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_1417300), partial mRNA | blastn | 580 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 17123232 | 17123232 | PRJNA561212_P_NODE_6114_length_446_cov_2.865952_g5903_i0 | PRJNA561212 | 6114 | 446 | 2.865952 | 12.78214592 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.44e-56 | NTclustered | gi|1673123994|ref|XM_029360740.1| | 94643 | g5903 | i0 | 78.693 | 48.0134529147982 | 352 | 73 | 79 | 2 | 9 | 359 | 2 | 352 | Besnoitia besnoiti ribosomal-ubiquitin protein RPL40 (BESB_020310), partial mRNA | blastn | 21414 | 233 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 17123236 | 17123236 | PRJNA561212_P_NODE_6414_length_435_cov_1.486188_g6203_i0 | PRJNA561212 | 6414 | 435 | 1.486188 | 6.4649178 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 5.28e-21 | NTclustered | gi|457876620|ref|XM_004224660.1| | 1120755 | g6203 | i0 | 89.888 | 0.655172413793103 | 89 | 9 | 20 | 0 | 307 | 395 | 1012 | 1100 | Plasmodium cynomolgi strain B HORMA domain containing protein (PCYB_141890) mRNA, complete cds | blastn | 285 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 19672080 | 19672080 | PRJNA561212_P_NODE_9296_length_361_cov_1.468750_g9085_i0 | PRJNA561212 | 9296 | 361 | 1.46875 | 5.3021875 | Babesia bovis | 5865 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 9.12e-33 | NTclustered | gi|363586005|gb|JN391431.1| | 5865 | g9085 | i0 | 80.583 | 48.1191135734072 | 206 | 34 | 57 | 6 | 1 | 204 | 2561 | 2360 | Babesia bovis isolate Shanxian 28S ribosomal RNA gene, partial sequence | blastn | 17371 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 23497670 | 23497670 | PRJNA561212_P_NODE_15379_length_287_cov_1.373832_g15168_i0 | PRJNA561212 | 15379 | 287 | 1.373832 | 3.94289784 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.3699999999999998e-109 | NTclustered | gi|134021988|gb|EF023338.1| | 404735 | g15168 | i0 | 93.773 | 84.1393728222996 | 273 | 16 | 95 | 1 | 6 | 278 | 1387 | 1658 | Eimeriidae environmental sample clone Amb_18S_660 18S ribosomal RNA gene, partial sequence | blastn | 24148 | 409 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 23497690 | 23497690 | PRJNA561212_P_NODE_1639_length_844_cov_1.319066_g1452_i0 | PRJNA561212 | 1639 | 844 | 1.319066 | 11.13291704 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 4.279999999999999e-124 | NTclustered | gi|1027960105|ref|XM_016799852.1| | 31271 | g1452 | i0 | 78.158 | 60.1125592417062 | 760 | 139 | 89 | 24 | 10 | 756 | 1037 | 292 | Plasmodium chabaudi chabaudi 26S protease regulatory subunit 8, putative (PCHAS_1464100), partial mRNA | blastn | 50735 | 459 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi |
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);;