metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA725806" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA725806" and tax_clade = "Sar"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
711837	711837	PRJNA725806_P_NODE_28221_length_291_cov_7.456693_g27924_i0	PRJNA725806	28221	291	7.456693	21.69897663	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|1620166059\|ref\|XM_028680908.1\|	880535	g27924	i0	100	0.0996563573883162	29	0	10	0	185	213	6463	6491	Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_0617300), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
711977	711977	PRJNA725806_P_NODE_78601_length_214_cov_26.536723_g78300_i0	PRJNA725806	78601	214	26.536723	56.78858722	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.019	NTclustered	gi\|829186784\|ref\|XM_001031547.2\|	312017	g78300	i0	94.286	0.163551401869159	35	1	16	1	34	68	3900	3867	Tetrahymena thermophila SB210 chromo(CHRromatin organization modifier) domain protein partial mRNA	blastn	35	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
1987814	1987814	PRJNA725806_P_NODE_155722_length_166_cov_2.379845_g155420_i0	PRJNA725806	155722	166	2.379845	3.9505427	Blastocystis hominis	12968	SAR_Eukaryotes	SAR_Eukaryotes	60.2	8.31e-5	NTclustered	gi\|855300242\|ref\|XM_013038211.1\|	12968	g155420	i0	97.143	0.210843373493976	35	1	21	0	1	35	298	332	Blastocystis hominis mRNA	blastn	35	60.2	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis
1987949	1987949	PRJNA725806_P_NODE_53842_length_243_cov_2.383495_g53545_i0	PRJNA725806	53842	243	2.383495	5.79189285	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|471227863\|ref\|XM_004034783.1\|	5932	g53545	i0	100	0.11522633744856	28	0	12	0	23	50	66	39	Ichthyophthirius multifiliis coiled-coil domain protein (IMG5_112150) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
1987955	1987955	PRJNA725806_P_NODE_56622_length_239_cov_4.000000_g56325_i0	PRJNA725806	56622	239	4	9.56	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1145260119\|ref\|XM_012908012.2\|	5854	g56325	i0	89.362	4.17991631799163	47	2	18	3	154	197	1216	1262	Plasmodium reichenowi translocon component PTEX88, putative partial mRNA	blastn	999	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
2469631	2469631	PRJNA725806_P_NODE_113442_length_188_cov_3.827815_g113140_i0	PRJNA725806	113442	188	3.827815	7.1962922	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.016	NTclustered	gi\|1084820983\|ref\|XM_018785035.1\|	647221	g113140	i0	100	0.297872340425532	28	0	15	0	147	174	1578	1605	Plasmodium gaboni hypothetical protein partial mRNA	blastn	56	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gaboni
3263289	3263289	PRJNA725806_P_NODE_99183_length_198_cov_1.757764_g98881_i0	PRJNA725806	99183	198	1.757764	3.48037272	Plasmodium vinckei	5860	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.001	NTclustered	gi\|1931716532\|ref\|XM_037634638.1\|	54757	g98881	i0	92.683	0.611111111111111	41	0	21	2	26	66	2024	1987	Plasmodium vinckei vinckei conserved Plasmodium protein, unknown function (PVVCY_1201760), partial mRNA	blastn	121	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vinckei
3746241	3746241	PRJNA725806_P_NODE_49683_length_249_cov_3.155660_g49386_i0	PRJNA725806	49683	249	3.15566	7.8575934	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1145263956\|ref\|XM_012910289.2\|	5854	g49386	i0	100	0.240963855421687	30	0	12	0	35	64	5374	5403	Plasmodium reichenowi hypothetical protein partial mRNA	blastn	60	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
3746298	3746298	PRJNA725806_P_NODE_86343_length_208_cov_2.192982_g86042_i0	PRJNA725806	86343	208	2.192982	4.56140256	root	1	Root_unresolved	Root_unresolved	52.8	0.018	NTclustered	gi\|916510174\|ref\|XM_013499861.1\|	44415	g86042	i0	100	0.538461538461538	28	0	13	0	83	110	1611	1584	Eimeria mitis uncharacterized protein (EMH_0077470), partial mRNA	blastn	112	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
3746318	3746318	PRJNA725806_P_NODE_97483_length_199_cov_2.993827_g97181_i0	PRJNA725806	97483	199	2.993827	5.95771573	root	1	Root_unresolved	Root_unresolved	52.8	0.017	NTclustered	gi\|1844518090\|ref\|XM_034637681.1\|	5861	g97181	i0	100	0.422110552763819	28	0	14	0	67	94	2422	2449	Plasmodium yoelii rhoptry neck protein 2 (PY17X_1319500), partial mRNA	blastn	84	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
5815420	5815420	PRJNA725806_P_NODE_183405_length_154_cov_6.735043_g183103_i0	PRJNA725806	183405	154	6.735043	10.37196622	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	60.2	7.55e-5	NTclustered	gi\|915132043\|ref\|XM_013480210.1\|	5804	g183103	i0	100	0.980519480519481	32	0	21	0	81	112	1363	1332	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	151	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
7090638	7090638	PRJNA725806_P_NODE_39726_length_265_cov_109.144737_g39429_i0	PRJNA725806	39726	265	109.144737	289.23355305	Plasmodium chabaudi	5825	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|1027956598\|ref\|XM_738368.2\|	31271	g39429	i0	96.875	0.120754716981132	32	1	12	0	232	263	148	179	Plasmodium chabaudi chabaudi histone-lysine N-methyltransferase, putative (PCHAS_1131300), partial mRNA	blastn	32	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium chabaudi
7090681	7090681	PRJNA725806_P_NODE_55706_length_240_cov_6.379310_g55409_i0	PRJNA725806	55706	240	6.37931	15.310344	Sundstroemia setigera	3005	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|1418587140\|ref\|NC_037996.1\|	3005	g55409	i0	100	0.820833333333333	29	0	12	0	145	173	47988	47960	Rhizosolenia setigera chloroplast, complete genome	blastn	197	54.7	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Rhizosoleniales	Rhizosoleniaceae	Sundstroemia	Sundstroemia setigera
7090728	7090728	PRJNA725806_P_NODE_73126_length_220_cov_2.732240_g72825_i0	PRJNA725806	73126	220	2.73224	6.010928	Tetrahymena thermophila	5911	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.019	NTclustered	gi\|829099662\|ref\|XM_012795313.1\|	312017	g72825	i0	100	0.127272727272727	28	0	13	0	139	166	214	241	Tetrahymena thermophila SB210 transmembrane protein, putative partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
8365163	8365163	PRJNA725806_P_NODE_26307_length_296_cov_12.528958_g26010_i0	PRJNA725806	26307	296	12.528958	37.08571568	Trochammina sp.	37356	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.008	NTclustered	gi\|773266\|emb\|X86095.1\|	37356	g26010	i0	96.97	0.111486486486486	33	0	11	1	123	155	2427	2396	Trochammina sp. 18S rRNA gene	blastn	33	54.7	1	Eukaryota	Sar	Foraminifera		Textulariida	Trochamminidae	Trochammina	Trochammina sp.
8365202	8365202	PRJNA725806_P_NODE_41347_length_262_cov_12.253333_g41050_i0	PRJNA725806	41347	262	12.253333	32.10373246	Plasmodium gonderi	77519	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1620954971\|ref\|XM_028689546.1\|	77519	g41050	i0	100	0.221374045801527	30	0	11	0	68	97	15782	15753	Plasmodium gonderi dynein heavy chain (PGO_130300), partial mRNA	blastn	58	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gonderi
8365213	8365213	PRJNA725806_P_NODE_47987_length_252_cov_1.255814_g47690_i0	PRJNA725806	47987	252	1.255814	3.16465128	Sphacelaria cirrosa	90014	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|18076383\|emb\|AJ287946.1\|	90014	g47690	i0	96.875	0.126984126984127	32	0	13	1	21	52	94	64	Sphacelaria cirrosa chloroplast rbcL gene, spacer sequence, SGAD-38 (97-38)	blastn	32	52.8	1	Eukaryota	Sar		Phaeophyceae	Sphacelariales	Sphacelariaceae	Sphacelaria	Sphacelaria cirrosa
10915766	10915766	PRJNA725806_P_NODE_107449_length_192_cov_3.322581_g107147_i0	PRJNA725806	107449	192	3.322581	6.37935552	Papenfussiella kuromo	185805	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.017	NTclustered	gi\|2692945203\|ref\|NC_086653.1\|	185805	g107147	i0	100	0.145833333333333	28	0	15	0	70	97	39566	39593	Papenfussiella kuromo chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	Sar		Phaeophyceae	Ectocarpales	Chordariaceae	Papenfussiella	Papenfussiella kuromo
12191216	12191216	PRJNA725806_P_NODE_32870_length_280_cov_4.938272_g32573_i0	PRJNA725806	32870	280	4.938272	13.8271616	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	67.6	9.21e-7	NTclustered	gi\|1145255867\|ref\|XM_012905407.2\|	5854	g32573	i0	95.238	17.5	42	2	15	0	191	232	946	905	Plasmodium reichenowi replication factor c protein, putative partial mRNA	blastn	4900	67.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
12191299	12191299	PRJNA725806_P_NODE_58950_length_236_cov_4.341709_g58653_i0	PRJNA725806	58950	236	4.341709	10.24643324	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	58.4	4.55e-4	NTclustered	gi\|820698309\|tpe\|LN714497.1\|	432359	g58653	i0	94.595	0.317796610169492	37	2	16	0	116	152	1720881	1720845	TPA_asm: Toxoplasma gondii VEG, chromosome chrVIIb, complete genome	blastn	75	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
12191342	12191342	PRJNA725806_P_NODE_82490_length_211_cov_4.275862_g82189_i0	PRJNA725806	82490	211	4.275862	9.02206882	Amicula sp. isolate GU52X-4 cfCalB7	3003489	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.005	NTclustered	gi\|2396590600\|gb\|ON390793.1\|	3003489	g82189	i0	92.105	0.180094786729858	38	3	18	0	45	82	115137	115174	Amicula sp. isolate GU52X-4 cfCalB7 voucher Theriot Lab HK478 plastid, complete genome	blastn	38	54.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Amicula	Amicula sp. isolate GU52X-4 cfCalB7
13465617	13465617	PRJNA725806_P_NODE_20791_length_314_cov_8.740072_g20495_i0	PRJNA725806	20791	314	8.740072	27.44382608	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.029	NTclustered	gi\|1843422941\|dbj\|LC541752.1\|	5823	g20495	i0	100	0.089171974522293	28	0	9	0	139	166	11960	11933	Plasmodium berghei ANKA chromosome 1 telomere region, partial sequence	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
14741043	14741043	PRJNA725806_P_NODE_74732_length_218_cov_6.513812_g74431_i0	PRJNA725806	74732	218	6.513812	14.20011016	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.019	NTclustered	gi\|124506316\|ref\|XM_001351720.1\|	36329	g74431	i0	100	0.128440366972477	28	0	13	0	97	124	988	961	Plasmodium falciparum 3D7 EELM2 domain-containing protein, putative (PF3D7_0519800), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
17289795	17289795	PRJNA725806_P_NODE_148934_length_169_cov_3.340909_g148632_i0	PRJNA725806	148934	169	3.340909	5.64613621	Aureococcus anophagefferens	44056	SAR_Eukaryotes	SAR_Eukaryotes	62.1	2.34e-5	NTclustered	gi\|676397964\|ref\|XM_009044012.1\|	44056	g148632	i0	90	4.15384615384615	50	2	28	1	33	79	2627	2676	Aureococcus anophagefferens hypothetical protein mRNA	blastn	702	62.1	1	Eukaryota	Sar		Pelagophyceae	Pelagomonadales	Pelagomonadaceae	Aureococcus	Aureococcus anophagefferens
17289914	17289914	PRJNA725806_P_NODE_37774_length_270_cov_1.274678_g37477_i0	PRJNA725806	37774	270	1.274678	3.4416306	Plasmodium malariae	5858	SAR_Eukaryotes	SAR_Eukaryotes	63.9	1.14e-5	NTclustered	gi\|1624466605\|ref\|XM_029006960.1\|	5858	g37477	i0	95.122	0.577777777777778	41	0	15	2	112	151	1787	1826	Plasmodium malariae histidine--tRNA ligase, putative (PmUG01_12071900), partial mRNA	blastn	156	63.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium malariae
19838736	19838736	PRJNA725806_P_NODE_149796_length_169_cov_1.333333_g149494_i0	PRJNA725806	149796	169	1.333333	2.25333277	Olivorum cimiterus	2231176	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.014	NTclustered	gi\|1402550497\|gb\|MH488783.1\|	2231176	g149494	i0	100	0.165680473372781	28	0	17	0	142	169	32	5	Olivorum cimiterus isolate UACEM small subunit ribosomal RNA gene, partial sequence	blastn	28	52.8	1	Eukaryota	Sar	Cercozoa				Olivorum	Olivorum cimiterus
19838810	19838810	PRJNA725806_P_NODE_26136_length_297_cov_4.361538_g25839_i0	PRJNA725806	26136	297	4.361538	12.95376786	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	58.4	5.93e-4	NTclustered	gi\|1270520879\|ref\|XM_022956223.1\|	5861	g25839	i0	90.909	0.28956228956229	44	3	15	1	6	49	1920	1878	Plasmodium yoelii endonuclease/exonuclease/phosphatase family protein, putative (PY17X_1015600), partial mRNA	blastn	86	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
19838846	19838846	PRJNA725806_P_NODE_39016_length_267_cov_4.052174_g38719_i0	PRJNA725806	39016	267	4.052174	10.81930458	Plasmodium berghei	5821	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|1843575739\|ref\|XM_034567858.1\|	5823	g38719	i0	100	0.108614232209738	29	0	11	0	42	70	1142	1114	Plasmodium berghei ANKA helicase, putative (PBANKA_1448800), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei
21114616	21114616	PRJNA725806_P_NODE_9857_length_376_cov_9.312684_g9570_i0	PRJNA725806	9857	376	9.312684	35.01569184	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.036	NTclustered	gi\|1145261151\|ref\|XM_012908609.2\|	5854	g9570	i0	100	0.074468085106383	28	0	7	0	288	315	3707	3680	Plasmodium reichenowi formin 2, putative partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
23664700	23664700	PRJNA725806_P_NODE_104639_length_194_cov_2.624204_g104337_i0	PRJNA725806	104639	194	2.624204	5.09095576	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.017	NTclustered	gi\|820693004\|tpe\|LN714485.1\|	572307	g104337	i0	100	0.288659793814433	28	0	14	0	89	116	1132057	1132030	TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome	blastn	56	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
23664765	23664765	PRJNA725806_P_NODE_130659_length_178_cov_4.425532_g130357_i0	PRJNA725806	130659	178	4.425532	7.87744696	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.015	NTclustered	gi\|1620116993\|ref\|XM_028671092.1\|	5849	g130357	i0	100	0.157303370786517	28	0	16	0	105	132	8035	8008	Plasmodium gallinaceum conserved Plasmodium membrane protein, unknown function (PGAL8A_00236200), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
24145973	24145973	PRJNA725806_P_NODE_22719_length_308_cov_2.321033_g22423_i0	PRJNA725806	22719	308	2.321033	7.14878164	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.029	NTclustered	gi\|1145257214\|ref\|XM_012906254.2\|	5854	g22423	i0	100	0.818181818181818	28	0	9	0	161	188	733	760	Plasmodium reichenowi carbon catabolite repressor protein 4, putative partial mRNA	blastn	252	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
24938359	24938359	PRJNA725806_P_NODE_35280_length_275_cov_2.596639_g34983_i0	PRJNA725806	35280	275	2.596639	7.14075725	Blastocystis hominis	12968	SAR_Eukaryotes	SAR_Eukaryotes	69.4	2.51e-7	NTclustered	gi\|855315805\|ref\|XM_013043514.1\|	12968	g34983	i0	97.5	10.5018181818182	40	1	15	0	43	82	1349	1310	Blastocystis hominis mRNA	blastn	2888	69.4	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis hominis

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