contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2230002 | 2230002 | PRJNA980585_P_NODE_24602_length_298_cov_1.280000_g24348_i0 | PRJNA980585 | 24602 | 298 | 1.28 | 3.8144 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 5.87e-14 | NTclustered | gi|2794948076|ref|XR_010957801.1| | 5871 | g24348 | i0 | 82.407 | 35.7281879194631 | 108 | 16 | 36 | 3 | 193 | 298 | 3455 | 3349 | Babesia caballi 28S ribosomal RNA (BcabD6B2_91120), rRNA | blastn | 10647 | 91.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 2230395 | 2230395 | PRJNA980585_P_NODE_49942_length_246_cov_2.589595_g49688_i0 | PRJNA980585 | 49942 | 246 | 2.589595 | 6.3704037 | Plasmodium knowlesi | 5850 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2555522192|gb|OQ817792.1| | 5850 | g49688 | i0 | 100 | 0.345528455284553 | 29 | 0 | 12 | 0 | 140 | 168 | 237 | 265 | Plasmodium knowlesi isolate BS2019_0017-C07 serine repeat antigen 3 antigen 2 gene, partial cds | blastn | 85 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 2230531 | 2230531 | PRJNA980585_P_NODE_59822_length_241_cov_0.916667_g59568_i0 | PRJNA980585 | 59822 | 241 | 0.916667 | 2.20916747 | Stylocephalidae sp. ex Blaps parvicollis | 3045166 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.0599999999999997e-37 | NTclustered | gi|2501226455|gb|OQ940287.1| | 3045166 | g59568 | i0 | 88.571 | 58.5269709543568 | 140 | 14 | 58 | 2 | 102 | 241 | 2406 | 2269 | Stylocephalidae sp. ex Blaps parvicollis isolate Ch small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 14105 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Stylocephalidae | Stylocephalidae sp. ex Blaps parvicollis | |||
| 6057741 | 6057741 | PRJNA980585_P_NODE_14865_length_361_cov_1.333333_g14611_i0 | PRJNA980585 | 14865 | 361 | 1.333333 | 4.81333213 | Cryptosporidium meleagridis | 93969 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.4699999999999995e-55 | NTclustered | gi|18152888|gb|AF221537.2|AF221537 | 93969 | g14611 | i0 | 80.317 | 70.4016620498615 | 315 | 52 | 86 | 10 | 1 | 310 | 1230 | 1539 | Cryptosporidium meleagridis heat shock protein 70 (HSP70) gene, partial cds | blastn | 25415 | 230 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium meleagridis | ||
| 6058127 | 6058127 | PRJNA980585_P_NODE_36765_length_261_cov_1.228723_g36511_i0 | PRJNA980585 | 36765 | 261 | 1.228723 | 3.20696703 | Eimeria rutili | 947531 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.93e-36 | NTclustered | gi|324022094|gb|GU593711.1| | 947531 | g36511 | i0 | 93.043 | 43.9348659003831 | 115 | 5 | 43 | 3 | 147 | 259 | 618 | 731 | Eimeria rutili strain 12 28S ribosomal RNA gene, partial sequence | blastn | 11467 | 165 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria rutili | ||
| 7332285 | 7332285 | PRJNA980585_P_NODE_19346_length_327_cov_2.763780_g19092_i0 | PRJNA980585 | 19346 | 327 | 2.76378 | 9.0375606 | Babesia bovis | 5865 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 8.139999999999999e-38 | NTclustered | gi|156087706|ref|XM_001611210.1| | 484906 | g19092 | i0 | 78.148 | 32.3853211009174 | 270 | 57 | 82 | 2 | 53 | 321 | 376 | 108 | Babesia bovis T2Bo putative 40S ribosomal protein S17 (BBOV_III001250), mRNA | blastn | 10590 | 171 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 9883385 | 9883385 | PRJNA980585_P_NODE_9488_length_432_cov_1.924791_g9234_i0 | PRJNA980585 | 9488 | 432 | 1.924791 | 8.31509712 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.042 | NTclustered | gi|124808974|ref|XM_001348420.1| | 36329 | g9234 | i0 | 88.636 | 0.101851851851852 | 44 | 4 | 10 | 1 | 347 | 390 | 5576 | 5534 | Plasmodium falciparum 3D7 acid phosphatase, putative (PF3D7_1430300), partial mRNA | blastn | 44 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 11473148 | 11473148 | PRJNA980585_P_NODE_34309_length_268_cov_0.974359_g34055_i0 | PRJNA980585 | 34309 | 268 | 0.974359 | 2.61128212 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|914999573|ref|XM_013392485.1| | 5801 | g34055 | i0 | 100 | 4.57462686567164 | 30 | 0 | 11 | 0 | 179 | 208 | 5926 | 5955 | Eimeria acervulina protein arginine n-methyltransferase, putative partial mRNA | blastn | 1226 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 12434142 | 12434142 | PRJNA980585_P_NODE_42990_length_250_cov_0.870056_g42736_i0 | PRJNA980585 | 42990 | 250 | 0.870056 | 2.17514 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.22e-17 | NTclustered | gi|833493338|ref|XM_012914580.1| | 5866 | g42736 | i0 | 83.962 | 17.348 | 106 | 17 | 42 | 0 | 11 | 116 | 1893 | 1788 | Babesia bigemina protein phosphatase B regulatory subunit, putative partial mRNA | blastn | 4337 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 13707980 | 13707980 | PRJNA980585_P_NODE_11151_length_404_cov_1.492447_g10897_i0 | PRJNA980585 | 11151 | 404 | 1.492447 | 6.02948588 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 2.17e-49 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g10897 | i0 | 78.931 | 7.38366336633663 | 318 | 59 | 78 | 8 | 9 | 322 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2983 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 13708114 | 13708114 | PRJNA980585_P_NODE_18631_length_332_cov_1.189189_g18377_i0 | PRJNA980585 | 18631 | 332 | 1.189189 | 3.94810748 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 4.91e-45 | NTclustered | gi|1673116849|ref|XM_029363787.1| | 94643 | g18377 | i0 | 78.065 | 2.52710843373494 | 310 | 66 | 93 | 2 | 24 | 332 | 456 | 148 | Besnoitia besnoiti ribosomal protein RPS13 (BESB_053520), partial mRNA | blastn | 839 | 195 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 13708513 | 13708513 | PRJNA980585_P_NODE_40571_length_251_cov_0.865169_g40317_i0 | PRJNA980585 | 40571 | 251 | 0.865169 | 2.17157419 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|457874700|ref|XM_004227696.1| | 1120755 | g40317 | i0 | 94.444 | 0.143426294820717 | 36 | 1 | 14 | 1 | 182 | 216 | 409 | 444 | Plasmodium cynomolgi strain B CYIR protein (PCYB_002750) mRNA, complete cds | blastn | 36 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 21356868 | 21356868 | PRJNA980585_P_NODE_38037_length_257_cov_1.673913_g37783_i0 | PRJNA980585 | 38037 | 257 | 1.673913 | 4.30195641 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|916498159|ref|XM_013494445.1| | 44415 | g37783 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 5 | 32 | 1109 | 1082 | Eimeria mitis uncharacterized protein (EMH_0030750), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 23907193 | 23907193 | PRJNA980585_P_NODE_28359_length_284_cov_1.459716_g28105_i0 | PRJNA980585 | 28359 | 284 | 1.459716 | 4.14559344 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|1843574336|ref|XM_034567080.1| | 5823 | g28105 | i0 | 96.875 | 0.112676056338028 | 32 | 1 | 11 | 0 | 227 | 258 | 51 | 20 | Plasmodium berghei ANKA CTLH domain-containing protein, putative (PBANKA_1345500), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 23907650 | 23907650 | PRJNA980585_P_NODE_57839_length_242_cov_1.360947_g57585_i0 | PRJNA980585 | 57839 | 242 | 1.360947 | 3.29349174 | Sarcocystis asinus | 2925352 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 7.68e-17 | NTclustered | gi|2206936641|gb|OM971683.1| | 2925352 | g57585 | i0 | 80.435 | 36.7066115702479 | 138 | 22 | 57 | 5 | 105 | 242 | 1576 | 1708 | Sarcocystis asinus isolate YDDSa1 large subunit ribosomal RNA gene, partial sequence | blastn | 8883 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis asinus | ||
| 23907663 | 23907663 | PRJNA980585_P_NODE_59019_length_242_cov_0.911243_g58765_i0 | PRJNA980585 | 59019 | 242 | 0.911243 | 2.20520806 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|749163406|ref|XM_011135030.1| | 110365 | g58765 | i0 | 88 | 0.471074380165289 | 50 | 2 | 19 | 2 | 163 | 209 | 158 | 110 | Gregarina niphandrodes putative fibrillarin partial mRNA | blastn | 114 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes |
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);;