RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

36 rows where bioproject = "PRJNA1010662" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 36 ✖

tax_clade 1

bioproject 1

  • PRJNA1010662 · 36 ✖

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
154918 154918 PRJNA1010662_P_NODE_2681_length_314_cov_1.426415_g2622_i0 PRJNA1010662 2681 314 1.426415 4.4789431 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 159 4.1999999999999985e-43   NR AET50612.1 5802 g2622 i0 75 60.515923566879 104 26 99.4 0 3 314 451 554 AET50612.1 hypothetical protein [Eimeria tenella] diamond 19002 160 0.99375 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria tenella
154959 154959 PRJNA1010662_P_NODE_6281_length_219_cov_2.252941_g6222_i0 PRJNA1010662 6281 219 2.252941 4.93394079 Plasmodium gallinaceum 5849 SAR_Eukaryotes SAR_Eukaryotes 117 6.77e-22   NTclustered gi|1620112141|ref|XM_028671477.1| 5849 g6222 i0 82.576 1.92237442922374 132 23 60 0 48 179 133 264 Plasmodium gallinaceum 60S ribosomal protein L15, putative (PGAL8A_00089300), partial mRNA blastn 421 117 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium gallinaceum
1429628 1429628 PRJNA1010662_P_NODE_10762_length_179_cov_1.530769_g10703_i0 PRJNA1010662 10762 179 1.530769 2.74007651 Cryptosporidium ryanae 515981 SAR_Eukaryotes SAR_Eukaryotes 113 1.86e-27   NR XP_067197890.1 515981 g10703 i0 84.7 2.96648044692737 59 9 98.9 0 2 178 192 250 XP_067197890.1 glutamate--tRNA ligase [Cryptosporidium ryanae] diamond 531 113 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium ryanae
3552021 3552021 PRJNA1010662_P_NODE_5843_length_225_cov_2.903409_g5784_i0 PRJNA1010662 5843 225 2.903409 6.53267025 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 207 4.04e-49   NTclustered gi|1620142820|ref|XM_028677298.1| 85471 g5784 i0 83.482 63.4177777777778 224 35 99 2 3 225 228 6 Plasmodium relictum ubiquitin-60S ribosomal protein L40, putative (PRELSG_1104600), partial mRNA blastn 14269 207 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium relictum
6533058 6533058 PRJNA1010662_P_NODE_16166_length_163_cov_0.903509_g16107_i0 PRJNA1010662 16166 163 0.903509 1.47271967 Plasmodium inui 52288 SAR_Eukaryotes SAR_Eukaryotes 95.3 2.23e-15   NTclustered gi|672187452|ref|XM_008816348.1| 1237626 g16107 i0 92.537 2.74233128834356 67 3 40 2 17 82 384 449 Plasmodium inui San Antonio 1 arginyl-tRNA synthetase partial mRNA blastn 447 95.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium inui
7379019 7379019 PRJNA1010662_P_NODE_2826_length_307_cov_1.476744_g2767_i0 PRJNA1010662 2826 307 1.476744 4.53360408 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 139 2.14e-28   NTclustered gi|1976646300|ref|XR_005506384.1| 5851 g2767 i0 88.793 37.9869706840391 116 9 37 4 64 177 2348 2235 Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA blastn 11662 139 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi
7807510 7807510 PRJNA1010662_P_NODE_9567_length_187_cov_2.536232_g9508_i0 PRJNA1010662 9567 187 2.536232 4.74275384 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 102 5.35e-25   NR BAN65202.1 5865 g9508 i0 80.6 19.8930481283422 62 12 99.5 0 187 2 107 168 BAN65202.1 eukaryotic translation initiation factor 4A, putative [Babesia bovis] diamond 3720 102 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bovis
11633438 11633438 PRJNA1010662_P_NODE_10090_length_184_cov_1.155556_g10031_i0 PRJNA1010662 10090 184 1.155556 2.12622304 Eimeria mitis 44415 SAR_Eukaryotes SAR_Eukaryotes 62.1 2.61e-5   NTclustered gi|916516433|ref|XM_013502564.1| 44415 g10031 i0 93.023 0.467391304347826 43 1 23 2 66 108 78 118 Eimeria mitis uncharacterized protein (EMH_0026070), partial mRNA blastn 86 62.1 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria mitis
18006593 18006593 PRJNA1010662_P_NODE_11175_length_176_cov_2.149606_g11116_i0 PRJNA1010662 11175 176 2.149606 3.78330656 Babesia caballi 5871 SAR_Eukaryotes SAR_Eukaryotes 134 5.1500000000000005e-27   NTclustered gi|2794940381|ref|XM_067858927.1| 5871 g11116 i0 83.221 9.26136363636364 149 21 84 3 12 158 1053 907 Babesia caballi 26S protease regulatory subunit 4, putative (BcabD6B2_23940), partial mRNA blastn 1630 134 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi
18006673 18006673 PRJNA1010662_P_NODE_4675_length_246_cov_1.842640_g4616_i0 PRJNA1010662 4675 246 1.84264 4.5328944 Eimeria maxima 5804 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|915122682|ref|XM_013477151.1| 5804 g4616 i0 100 0.252032520325203 30 0 12 0 200 229 443 414 Eimeria maxima hypothetical protein, conserved partial mRNA blastn 62 56.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria maxima
18006701 18006701 PRJNA1010662_P_NODE_7535_length_205_cov_1.666667_g7476_i0 PRJNA1010662 7535 205 1.666667 3.41666735 Babesia ovata 189622 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|1624689154|ref|XM_029009452.1| 189622 g7476 i0 100 0.146341463414634 30 0 15 0 109 138 1153 1182 Babesia ovata decapping 5 (BOVATA_005350), partial mRNA blastn 30 56.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia ovata
19280493 19280493 PRJNA1010662_P_NODE_9116_length_191_cov_1.091549_g9057_i0 PRJNA1010662 9116 191 1.091549 2.08485859 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.92e-23   NR XP_012767301.1 5866 g9057 i0 73.8 7.82198952879581 61 16 95.8 0 185 3 4 64 XP_012767301.1 40S ribosomal subunit protein S9, putative [Babesia bigemina] diamond 1494 97.8 0.992842535787321 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bigemina
21831714 21831714 PRJNA1010662_P_NODE_6818_length_213_cov_1.256098_g6759_i0 PRJNA1010662 6818 213 1.256098 2.67548874 Babesia bovis 5865 SAR_Eukaryotes SAR_Eukaryotes 143 1.08e-29   NTclustered gi|2325211320|ref|XM_001610874.2| 484906 g6759 i0 85 36.5586854460094 140 21 66 0 22 161 2852 2713 Babesia bovis T2Bo HAD ATPase P-type IC family protein (BBOV_IV010020), mRNA blastn 7787 143 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bovis
25227664 25227664 PRJNA1010662_P_NODE_12340_length_169_cov_1.733333_g12281_i0 PRJNA1010662 12340 169 1.733333 2.92933277 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.2 8.43e-5   NTclustered gi|221054465|ref|XM_002258336.1| 5851 g12281 i0 100 6.89349112426035 32 0 19 0 1 32 1628 1659 Plasmodium knowlesi strain H helicase SKI2W, putative (PKNH_0707900), partial mRNA blastn 1165 60.2 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi
26622885 26622885 PRJNA1010662_P_NODE_1121_length_480_cov_5.457077_g1062_i0 PRJNA1010662 1121 480 5.457077 26.1939696 Babesia bovis T2Bo 484906 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.03e-20   NR XP_001610942.1 484906 g1062 i0 54 0.625 100 41 61.3 3 42 335 7 103 XP_001610942.1 putative ribosomal protein S25 [Babesia bovis T2Bo] diamond 300 91.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bovis
26622914 26622914 PRJNA1010662_P_NODE_9581_length_187_cov_1.884058_g9522_i0 PRJNA1010662 9581 187 1.884058 3.52318846 Cryptosporidium ryanae 515981 SAR_Eukaryotes SAR_Eukaryotes 77.8 3.96e-15   NR XP_067198099.1 515981 g9522 i0 74 1.58823529411765 50 13 80.2 0 36 185 18 67 XP_067198099.1 serine/threonine protein phosphatase [Cryptosporidium ryanae] diamond 297 77.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium ryanae
27034513 27034513 PRJNA1010662_P_NODE_9842_length_185_cov_2.705882_g9783_i0 PRJNA1010662 9842 185 2.705882 5.0058817 Gregarina niphandrodes 110365 SAR_Eukaryotes SAR_Eukaryotes 59.3 2.41e-8   NR XP_011130849.1 110365 g9783 i0 53.7 0.875675675675676 54 25 87.6 0 183 22 85 138 XP_011130849.1 seryl-tRNA synthetase [Gregarina niphandrodes] diamond 162 59.3 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Gregarinidae Gregarina Gregarina niphandrodes
27058661 27058661 PRJNA1010662_P_NODE_5022_length_239_cov_1.363158_g4963_i0 PRJNA1010662 5022 239 1.363158 3.25794762 Eucoccidiorida 75739 SAR_Eukaryotes SAR_Eukaryotes 104 1.5999999999999998e-25   NR XP_013432860.1 51315 g4963 i0 67.5 5.79916317991632 77 25 96.7 0 9 239 1 77 XP_013432860.1 40S ribosomal protein S9, putative [Eimeria necatrix] diamond 1386 105 0.990476190476191 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria necatrix
27532579 27532579 PRJNA1010662_P_NODE_1183_length_469_cov_1.419048_g1124_i0 PRJNA1010662 1183 469 1.419048 6.65533512 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.5 0.00329   NR GFE55814.1 5869 g1124 i0 35.4 2.48827292110874 79 48 50.5 1 418 182 352 427 GFE55814.1 Brf1p family protein, putative [Babesia ovis] diamond 1167 48.9 0.991820040899796 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia ovis
27698323 27698323 PRJNA1010662_P_NODE_1184_length_468_cov_10.536993_g1125_i0 PRJNA1010662 1184 468 10.536993 49.31312724 Babesia bovis T2Bo 484906 SAR_Eukaryotes SAR_Eukaryotes 89 1.03e-19   NR XP_001610942.1 484906 g1125 i0 53.5 0.634615384615385 99 41 62.2 3 421 131 7 102 XP_001610942.1 putative ribosomal protein S25 [Babesia bovis T2Bo] diamond 297 89 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bovis
29150721 29150721 PRJNA1010662_P_NODE_16229_length_163_cov_0.894737_g16170_i0 PRJNA1010662 16229 163 0.894737 1.45842131 Besnoitia besnoiti 94643 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00366   NR XP_029216267.1 94643 g16170 i0 67.9 1.17791411042945 28 9 51.5 0 163 80 534 561 XP_029216267.1 hypothetical protein BESB_015760 [Besnoitia besnoiti] diamond 192 44.3 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Besnoitia Besnoitia besnoiti
29245148 29245148 PRJNA1010662_S_NODE_3149_length_190_cov_1.959184_g3104_i0 PRJNA1010662 3149 190 1.959184 3.7224496 Plasmodium falciparum 5833 SAR_Eukaryotes SAR_Eukaryotes 45.4 7.73e-4   NR AIZ73304.1 5833 g3104 i0 62.2 0.58421052631579 37 14 58.4 0 190 80 69 105 AIZ73304.1 erythrocyte membrane protein 1, partial [Plasmodium falciparum] diamond 111 45.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
29308135 29308135 PRJNA1010662_P_NODE_11549_length_174_cov_1.568000_g11490_i0 PRJNA1010662 11549 174 1.568 2.72832 Plasmodium relictum 85471 SAR_Eukaryotes SAR_Eukaryotes 68.2 9.58e-13   NR XP_028533300.1 85471 g11490 i0 57.1 3.86206896551724 56 24 96.6 0 173 6 36 91 XP_028533300.1 60S ribosomal protein L35ae, putative [Plasmodium relictum] diamond 672 68.2 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium relictum
29332330 29332330 PRJNA1010662_P_NODE_15069_length_164_cov_2.460870_g15010_i0 PRJNA1010662 15069 164 2.46087 4.0358268 Eucoccidiorida 75739 SAR_Eukaryotes SAR_Eukaryotes 68.6 3.23e-13   NR OEH74079.1 88456 g15010 i0 85.3 2.48780487804878 34 5 62.2 0 164 63 49 82 OEH74079.1 ribosomal protein rps27 [Cyclospora cayetanensis] diamond 408 68.6 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis
29364037 29364037 PRJNA1010662_P_NODE_9869_length_185_cov_1.985294_g9810_i0 PRJNA1010662 9869 185 1.985294 3.6727939 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.36e-15   NR CAL7861940.1 1344799 g9810 i0 59 9.81081081081081 61 25 98.9 0 184 2 65 125 CAL7861940.1 unnamed protein product [Sarcocystis calchasi] diamond 1815 78.6 0.994910941475827 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Sarcocystis Sarcocystis calchasi
29553069 29553069 PRJNA1010662_P_NODE_15070_length_164_cov_2.408696_g15011_i0 PRJNA1010662 15070 164 2.408696 3.95026144 root 1 Root_unresolved Root_unresolved 48.5 1.16e-4   NR CAL7865926.1 1344799 g15011 i0 50 5.61585365853659 44 22 80.5 0 150 19 338 381 CAL7865926.1 unnamed protein product [Sarcocystis calchasi] diamond 921 48.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Sarcocystis Sarcocystis calchasi
30034631 30034631 PRJNA1010662_P_NODE_17411_length_152_cov_2.213592_g17352_i0 PRJNA1010662 17411 152 2.213592 3.36465984 Hepatocystis sp. ex Piliocolobus tephrosceles 2600580 SAR_Eukaryotes SAR_Eukaryotes 60.5 5.93e-9   NR VWU51921.1 2600580 g17352 i0 54 1.93421052631579 50 23 98.7 0 152 3 755 804 VWU51921.1 ABC1 family, putative [Hepatocystis sp. ex Piliocolobus tephrosceles] diamond 294 60.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Hepatocystis Hepatocystis sp. ex Piliocolobus tephrosceles
30508504 30508504 PRJNA1010662_P_NODE_4613_length_247_cov_2.464646_g4554_i0 PRJNA1010662 4613 247 2.464646 6.08767562 Cryptosporidium parvum Iowa II 353152 SAR_Eukaryotes SAR_Eukaryotes 75.9 2.67e-14   NR XP_625504.1 353152 g4554 i0 52.1 4.36032388663968 73 35 88.7 0 4 222 189 261 XP_625504.1 60S ribosomal protein L7A, partial [Cryptosporidium parvum Iowa II] diamond 1077 75.9 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium parvum
30532520 30532520 PRJNA1010662_P_NODE_8773_length_193_cov_1.798611_g8714_i0 PRJNA1010662 8773 193 1.798611 3.47131923 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00126   NR XP_029215755.1 94643 g8714 i0 37.1 3.82383419689119 70 30 87 2 25 192 54 123 XP_029215755.1 putative suppressor of kinetochore protein 1 [Besnoitia besnoiti] diamond 738 45.8 0.991266375545852 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Besnoitia Besnoitia besnoiti
30690472 30690472 PRJNA1010662_P_NODE_6733_length_214_cov_1.315152_g6674_i0 PRJNA1010662 6733 214 1.315152 2.81442528 root 1 Root_unresolved Root_unresolved 51.2 1.07e-5   NR XP_028862544.1 5858 g6674 i0 41 4.33177570093458 61 34 85.5 1 27 209 5 63 XP_028862544.1 6-pyruvoyltetrahydropterin synthase, putative [Plasmodium malariae] diamond 927 51.6 0.992248062015504 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium malariae
30753761 30753761 PRJNA1010662_P_NODE_10414_length_181_cov_1.962121_g10355_i0 PRJNA1010662 10414 181 1.962121 3.55143901 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.74e-15   NR SCO68544.1 5855 g10355 i0 61.1 6.26519337016575 54 20 89.5 1 177 16 342 394 SCO68544.1 elongation factor 1-gamma, putative [Plasmodium vivax] diamond 1134 79.7 0.994981179422836 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium vivax
31393527 31393527 PRJNA1010662_P_NODE_5876_length_225_cov_1.653409_g5817_i0 PRJNA1010662 5876 225 1.653409 3.72017025 Porospora cf. gigantea B 2853592 SAR_Eukaryotes SAR_Eukaryotes 69.7 8.82e-12   NR XP_068371639.1 2853592 g5817 i0 48.5 3.66666666666667 68 34 90.7 1 2 205 132 198 XP_068371639.1 MAG: uncharacterized protein KVP17_002647 [Porospora cf. gigantea B] diamond 825 69.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Porosporidae Porospora Porospora cf. gigantea B
31670457 31670457 PRJNA1010662_P_NODE_5437_length_232_cov_1.524590_g5378_i0 PRJNA1010662 5437 232 1.52459 3.5370488 Cryptosporidium 5806 SAR_Eukaryotes SAR_Eukaryotes 82.4 8.81e-18   NR KAF7459234.1 83540 g5378 i0 70.4 4.18965517241379 54 14 67.2 1 3 158 96 149 KAF7459234.1 40S ribosomal protein S27a [Cryptosporidium felis] diamond 972 82.4 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium felis
31733594 31733594 PRJNA1010662_P_NODE_12197_length_170_cov_1.628099_g12138_i0 PRJNA1010662 12197 170 1.628099 2.7677683 Theileria 5873 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.63e-9   NR UKJ87753.1 68886 g12138 i0 51.9 1.90588235294118 54 25 95.3 1 5 166 4339 4391 UKJ87753.1 E3 ubiquitin-protein ligase HUWE1 [Theileria orientalis] diamond 324 62.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria orientalis
31899447 31899447 PRJNA1010662_P_NODE_2717_length_312_cov_1.231939_g2658_i0 PRJNA1010662 2717 312 1.231939 3.84364968 Neospora caninum Liverpool 572307 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0101   NR XP_003880389.1 572307 g2658 i0 43.5 0.884615384615385 46 26 44.2 0 309 172 247 292 XP_003880389.1 hypothetical protein NCLIV_008245 [Neospora caninum Liverpool] diamond 276 45.4 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
32650608 32650608 PRJNA1010662_P_NODE_13640_length_167_cov_0.872881_g13581_i0 PRJNA1010662 13640 167 0.872881 1.45771127 root 1 Root_unresolved Root_unresolved 55.5 4.3e-7   NR XP_013247119.1 5801 g13581 i0 46.3 2.98203592814371 54 27 93.4 1 5 160 397 450 XP_013247119.1 regulator of chromosome condensation domain-containing protein, putative [Eimeria acervulina] diamond 498 55.8 0.99462365591397806 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria acervulina

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