RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 24 ✖

tax_clade 1

bioproject 1

  • PRJEB2368 · 24 ✖

analysis 1

  • diamond · 24 ✖

tax_kingdom 0

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
2572799 2572799 PRJEB2368_P_NODE_583_length_1116_cov_4.632067_g444_i0 PRJEB2368 583 1116 4.632067 51.69386772 Plasmodium falciparum IGH-CR14 580059 SAR_Eukaryotes SAR_Eukaryotes 88.6 1.23e-15   NR KNG78278.1 580059 g444 i0 93.3 0.120967741935484 45 3 12.1 0 12 146 1 45 KNG78278.1 hypothetical protein PFMG_04496, partial [Plasmodium falciparum IGH-CR14] diamond 135 88.6 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
11500926 11500926 PRJEB2368_P_NODE_6030_length_311_cov_5.562044_g5712_i0 PRJEB2368 6030 311 5.562044 17.29795684 Plasmodium falciparum Palo Alto/Uganda 57270 SAR_Eukaryotes SAR_Eukaryotes 79.3 4.11e-16   NR ETW51988.1 57270 g5712 i0 93.6 0.453376205787781 47 3 45.3 0 311 171 28 74 ETW51988.1 hypothetical protein PFUGPA_06004 [Plasmodium falciparum Palo Alto/Uganda] diamond 141 79.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
21699624 21699624 PRJEB2368_P_NODE_1938_length_624_cov_4.587734_g444_i3 PRJEB2368 1938 624 4.587734 28.62746016 Plasmodium falciparum IGH-CR14 580059 SAR_Eukaryotes SAR_Eukaryotes 88.6 5.95e-17   NR KNG78278.1 580059 g444 i3 93.3 0.216346153846154 45 3 21.6 0 12 146 1 45 KNG78278.1 hypothetical protein PFMG_04496, partial [Plasmodium falciparum IGH-CR14] diamond 135 88.6 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
26709844 26709844 PRJEB2368_P_NODE_9281_length_287_cov_1.432000_g8963_i0 PRJEB2368 9281 287 1.432 4.10984 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.73e-4   NR SOV75877.1 5854 g8963 i0 100 1.56794425087108 25 0 26.1 0 212 286 684 708 SOV75877.1 valine--tRNA ligase, putative [Plasmodium reichenowi] diamond 450 50.1 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium reichenowi
26716203 26716203 PRJEB2368_P_NODE_6681_length_294_cov_1.322957_g6363_i0 PRJEB2368 6681 294 1.322957 3.88949358 Plasmodium falciparum Tanzania (2 5833 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.28e-6   NR ETW33051.1 1036725 g6363 i0 96 0.255102040816327 25 1 25.5 0 2 76 1592 1616 ETW33051.1 hypothetical protein PFTANZ_06229 [Plasmodium falciparum Tanzania (2000708)] diamond 75 55.1 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
27159327 27159327 PRJEB2368_P_NODE_8722_length_287_cov_1.536000_g8404_i0 PRJEB2368 8722 287 1.536 4.40832 Plasmodium falciparum Tanzania (2 5833 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0113   NR ETW34062.1 1036725 g8404 i0 100 0.229965156794425 22 0 23 0 285 220 9 30 ETW34062.1 hypothetical protein PFTANZ_05227 [Plasmodium falciparum Tanzania (2000708)] diamond 66 42.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
27343045 27343045 PRJEB2368_P_NODE_9403_length_287_cov_1.412000_g9085_i0 PRJEB2368 9403 287 1.412 4.05244 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 54.3 5.59e-6   NR ETW58851.1 5835 g9085 i0 100 0.501742160278746 24 0 25.1 0 3 74 581 604 ETW58851.1 hypothetical protein PFMC_05263, partial [Plasmodium falciparum CAMP/Malaysia] diamond 144 54.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
27696953 27696953 PRJEB2368_P_NODE_8164_length_287_cov_1.712000_g7846_i0 PRJEB2368 8164 287 1.712 4.91344 Plasmodium gaboni 647221 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.00111   NR SOV16511.1 647221 g7846 i0 100 0.261324041811847 25 0 26.1 0 287 213 184 208 SOV16511.1 CG2-related protein, putative [Plasmodium gaboni] diamond 75 47.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium gaboni
27886015 27886015 PRJEB2368_P_NODE_11985_length_227_cov_4.231579_g11666_i0 PRJEB2368 11985 227 4.231579 9.60568433 Plasmodium falciparum 7G8 57266 SAR_Eukaryotes SAR_Eukaryotes 116 5.73e-30   NR EUR73457.1 57266 g11666 i0 82.7 0.991189427312775 75 13 99.1 0 2 226 1 75 EUR73457.1 hypothetical protein PFBG_01948 [Plasmodium falciparum 7G8] diamond 225 116 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
28321590 28321590 PRJEB2368_P_NODE_8606_length_287_cov_1.572000_g8288_i0 PRJEB2368 8606 287 1.572 4.51164 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.79e-17   NR ETW53637.1 57270 g8288 i0 50.5 2.97909407665505 95 13 99.3 1 287 3 54 114 ETW53637.1 hypothetical protein PFUGPA_03511 [Plasmodium falciparum Palo Alto/Uganda] diamond 855 82.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
28770042 28770042 PRJEB2368_P_NODE_15327_length_155_cov_2.703390_g15008_i0 PRJEB2368 15327 155 2.70339 4.1902545 Plasmodium falciparum MaliPS 5833 SAR_Eukaryotes SAR_Eukaryotes 73.9 2.97e-15   NR ETW50352.1 1036727 g15008 i0 78 0.967741935483871 50 11 96.8 0 3 152 39 88 ETW50352.1 hypothetical protein PFMALIP_01610 [Plasmodium falciparum MaliPS096_E11] diamond 150 73.9 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
28927963 28927963 PRJEB2368_P_NODE_9428_length_287_cov_1.412000_g9110_i0 PRJEB2368 9428 287 1.412 4.05244 Plasmodium falciparum RAJ116 580058 SAR_Eukaryotes SAR_Eukaryotes 50.4 1.29e-4   NR KNC35295.1 580058 g9110 i0 92 0.261324041811847 25 2 26.1 0 287 213 5 29 KNC35295.1 hypothetical protein PFLG_00313 [Plasmodium falciparum RAJ116] diamond 75 50.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
28991453 28991453 PRJEB2368_P_NODE_6128_length_309_cov_2.283088_g5810_i0 PRJEB2368 6128 309 2.283088 7.05474192 Plasmodium falciparum HB3 137071 SAR_Eukaryotes SAR_Eukaryotes 62.8 7.32e-9   NR KOB58726.1 137071 g5810 i0 100 0.281553398058252 29 0 28.2 0 308 222 287 315 KOB58726.1 hypothetical protein PFHG_00473 [Plasmodium falciparum HB3] diamond 87 62.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
29086017 29086017 PRJEB2368_P_NODE_10788_length_286_cov_1.819277_g10470_i0 PRJEB2368 10788 286 1.819277 5.20313222 Plasmodium falciparum 5833 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00149   NR ANJ20942.1 5833 g10470 i0 87.5 0.251748251748252 24 3 25.2 0 284 213 1570 1593 ANJ20942.1 erythrocyte membrane protein 1, partial [Plasmodium falciparum] diamond 72 47.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
29212326 29212326 PRJEB2368_P_NODE_6169_length_308_cov_1.568266_g5851_i0 PRJEB2368 6169 308 1.568266 4.83025928 Plasmodium falciparum UGT5.1 1237627 SAR_Eukaryotes SAR_Eukaryotes 56.2 1.52e-6   NR EWC75342.1 1237627 g5851 i0 96.6 0.282467532467532 29 1 28.2 0 220 306 286 314 EWC75342.1 hypothetical protein C923_04017 [Plasmodium falciparum UGT5.1] diamond 87 56.2 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
29615864 29615864 PRJEB2368_P_NODE_7730_length_287_cov_1.892000_g7412_i0 PRJEB2368 7730 287 1.892 5.43004 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.33e-9   NR KNG74286.1 580059 g7412 i0 100 0.522648083623693 25 0 26.1 0 3 77 6 30 KNG74286.1 hypothetical protein PFMG_00539 [Plasmodium falciparum IGH-CR14] diamond 150 59.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
29647355 29647355 PRJEB2368_P_NODE_3430_length_437_cov_2.050000_g3124_i0 PRJEB2368 3430 437 2.05 8.9585 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.28e-10   NR KNC36371.1 580058 g3124 i0 100 0.480549199084668 35 0 24 0 435 331 552 586 KNC36371.1 hypothetical protein PFLG_01685 [Plasmodium falciparum RAJ116] diamond 210 69.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
30222683 30222683 PRJEB2368_P_NODE_7752_length_287_cov_1.884000_g7434_i0 PRJEB2368 7752 287 1.884 5.40708 Plasmodium falciparum NF135/5.C1 5833 SAR_Eukaryotes SAR_Eukaryotes 61.6 6.19e-9   NR ETW41242.1 1036726 g7434 i0 45.7 0.961672473867596 92 3 96.2 1 276 1 91 135 ETW41242.1 hypothetical protein PFNF135_04384 [Plasmodium falciparum NF135/5.C10] diamond 276 61.6 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
30381132 30381132 PRJEB2368_P_NODE_4093_length_391_cov_1.641243_g3781_i0 PRJEB2368 4093 391 1.641243 6.41726013 Cyclospora cayetanensis 88456 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.026   NR OEH78494.1 88456 g3781 i0 53.7 0.629156010230179 41 18 31.5 1 136 14 290 329 OEH78494.1 microneme protein [Cyclospora cayetanensis] diamond 246 45.1 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis
30854611 30854611 PRJEB2368_P_NODE_7754_length_287_cov_1.880000_g7436_i0 PRJEB2368 7754 287 1.88 5.3956 Plasmodium falciparum Santa Lucia 478859 SAR_Eukaryotes SAR_Eukaryotes 90.5 1.07e-18   NR EUT75061.1 478859 g7436 i0 51.6 0.993031358885017 95 11 99.3 1 2 286 1212 1271 EUT75061.1 hypothetical protein PFAG_06011, partial [Plasmodium falciparum Santa Lucia] diamond 285 90.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
31613388 31613388 PRJEB2368_P_NODE_14776_length_160_cov_3.422764_g14457_i0 PRJEB2368 14776 160 3.422764 5.4764224 Plasmodium falciparum IGH-CR14 580059 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00219   NR KNG74082.1 580059 g14457 i0 63.2 0.7125 38 14 71.3 0 1 114 45 82 KNG74082.1 hypothetical protein PFMG_00278, partial [Plasmodium falciparum IGH-CR14] diamond 114 44.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
31796532 31796532 PRJEB2368_P_NODE_9757_length_287_cov_1.360000_g9439_i0 PRJEB2368 9757 287 1.36 3.9032 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00535   NR EWC88831.1 5843 g9439 i0 100 1.00348432055749 24 0 25.1 0 74 3 830 853 EWC88831.1 hypothetical protein PFNF54_02344 [Plasmodium falciparum NF54] diamond 288 45.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
32119708 32119708 PRJEB2368_P_NODE_9098_length_287_cov_1.464000_g8780_i0 PRJEB2368 9098 287 1.464 4.20168 Plasmodium falciparum Tanzania (2 5833 SAR_Eukaryotes SAR_Eukaryotes 87.8 9.44e-18   NR ETW32663.1 1036725 g8780 i0 50.5 0.993031358885017 95 44 99.3 1 2 286 1474 1565 ETW32663.1 hypothetical protein PFTANZ_06617, partial [Plasmodium falciparum Tanzania (2000708)] diamond 285 87.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
32524791 32524791 PRJEB2368_P_NODE_12519_length_203_cov_2.307229_g12200_i0 PRJEB2368 12519 203 2.307229 4.68367487 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 80.9 3.03e-18   NR ETW51968.1 57270 g12200 i0 84 2.95566502463054 50 8 73.9 0 53 202 26 75 ETW51968.1 hypothetical protein PFUGPA_06024 [Plasmodium falciparum Palo Alto/Uganda] diamond 600 81.6 0.991421568627451 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;