metadata: contig_metadata: 35 rows where bioproject = "PRJNA1197996" and tax

35 rows where bioproject = "PRJNA1197996" and tax_phylum = "Bacillota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
324383	324383	PRJNA1197996_S_NODE_9541_length_339_cov_2.127820_g9487_i0	PRJNA1197996	9541	339	2.12782	7.2133098	Candidatus Scatomonas sp.	3048880	Bacteria	Bacteria	233	1.07e-56	NTclustered	gi\|2729058667\|emb\|OZ006967.1\|	3048880	g9487	i0	83.74	143.17994100295	246	40	73	0	1	246	643607	643362	MAG: Candidatus Scatomonas sp. isolate 6732_HOM_VAC_s127.ctg000167c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	48538	233	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Scatomonas	Candidatus Scatomonas sp.
2318968	2318968	PRJNA1197996_S_NODE_20902_length_262_cov_2.407407_g20848_i0	PRJNA1197996	20902	262	2.407407	6.30740634	Lactobacillus	1578	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g20848	i0	99.618	380.576335877863	262	1	100	0	1	262	89318	89579	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	99711	479	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
2318996	2318996	PRJNA1197996_S_NODE_25862_length_246_cov_1.173410_g25808_i0	PRJNA1197996	25862	246	1.17341	2.8865886	Lactobacillus	1578	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g25808	i0	100	413.020325203252	246	0	100	0	1	246	1145018	1145263	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	101603	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
2875075	2875075	PRJNA1197996_S_NODE_6083_length_390_cov_3.842271_g6029_i0	PRJNA1197996	6083	390	3.842271	14.9848569	Paenibacillus sp. FSL H8-0548	1920422	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2723733183\|gb\|CP152049.1\|	1920422	g6029	i0	100	0.0717948717948718	28	0	7	0	119	146	4341323	4341350	Paenibacillus sp. FSL H8-0548 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H8-0548
4150799	4150799	PRJNA1197996_S_NODE_15824_length_289_cov_1.069444_g15770_i0	PRJNA1197996	15824	289	1.069444	3.09069316	Weissella soli	155866	Bacteria	Bacteria	529	1.01e-145	NTclustered	gi\|1079463558\|gb\|CP017326.1\|	155866	g15770	i0	99.654	2	289	1	100	0	1	289	958300	958588	Weissella soli strain KACC 11848 chromosome, complete genome	blastn	578	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella soli
4150854	4150854	PRJNA1197996_S_NODE_17804_length_278_cov_1.126829_g17750_i0	PRJNA1197996	17804	278	1.126829	3.13258462	Hathewaya histolytica	1498	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g17750	i0	100	1	278	0	100	0	1	278	2703139	2702862	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	278	514	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
4871727	4871727	PRJNA1197996_S_NODE_22904_length_253_cov_1.711111_g22850_i0	PRJNA1197996	22904	253	1.711111	4.32911083	Staphylococcus	1279	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g22850	i0	100	99.901185770751	253	0	100	0	1	253	692176	691924	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	25275	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
4871776	4871776	PRJNA1197996_S_NODE_29464_length_227_cov_2.025974_g29410_i0	PRJNA1197996	29464	227	2.025974	4.59896098	Lactobacillus	1578	Bacteria	Bacteria	407	3.7499999999999994e-109	NTclustered	gi\|2787301591\|gb\|PQ186954.1\|	1596	g29410	i0	99.552	101.202643171806	223	1	98	0	1	223	582	804	Lactobacillus gasseri strain GHM-LG1707 16S ribosomal RNA gene, partial sequence	blastn	22973	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus gasseri
6701940	6701940	PRJNA1197996_S_NODE_22886_length_253_cov_2.127778_g22832_i0	PRJNA1197996	22886	253	2.127778	5.38327834	[Eubacterium] siraeum	39492	Bacteria	Bacteria	361	3.36e-95	NTclustered	gi\|291529795\|emb\|FP929044.1\|	657319	g22832	i0	92.52	235.308300395257	254	16	100	2	1	253	2941742	2941993	Eubacterium siraeum 70/3 draft genome	blastn	59533	361	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		[Eubacterium] siraeum
8696596	8696596	PRJNA1197996_S_NODE_19007_length_271_cov_2.227273_g18953_i0	PRJNA1197996	19007	271	2.227273	6.03590983	Paenibacillus	44249	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|686561105\|gb\|CP009428.1\|	189426	g18953	i0	100	989.339483394834	271	0	100	0	1	271	14924	14654	Paenibacillus odorifer strain DSM 15391, complete genome	blastn	268111	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus odorifer
9251754	9251754	PRJNA1197996_S_NODE_13068_length_307_cov_1.303419_g13014_i0	PRJNA1197996	13068	307	1.303419	4.00149633	Enterococcus	1350	Bacteria	Bacteria	169	3.61e-49	NR	WP_413133017.1	37734	g13014	i0	72.5	1.99348534201954	102	28	99.7	0	307	2	168	269	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	612	169	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
9971758	9971758	PRJNA1197996_S_NODE_4548_length_427_cov_2.000000_g4494_i0	PRJNA1197996	4548	427	2	8.54	Paenibacillus	44249	Bacteria	Bacteria	789	0	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g4494	i0	100	960.365339578454	427	0	100	0	1	427	15463	15037	Paenibacillus sp. FSL R5-0345, complete genome	blastn	410076	789	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
10527818	10527818	PRJNA1197996_S_NODE_21509_length_260_cov_1.037433_g21455_i0	PRJNA1197996	21509	260	1.037433	2.6973258	Exiguobacterium mexicanum	340146	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2844360308\|gb\|CP172296.1\|	340146	g21455	i0	100	650.257692307692	260	0	100	0	1	260	63900	63641	Exiguobacterium mexicanum strain MM chromosome, complete genome	blastn	169067	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium mexicanum
11246892	11246892	PRJNA1197996_S_NODE_14949_length_294_cov_2.040724_g14895_i0	PRJNA1197996	14949	294	2.040724	5.99972856	Lysinibacillus	400634	Bacteria	Bacteria	193	1.54e-44	NTclustered	gi\|2805671158\|gb\|CP167122.1\|	3242678	g14895	i0	85.792	8.27891156462585	183	25	70	1	1	182	2011451	2011269	Lysinibacillus sp. RS10 chromosome, complete genome	blastn	2434	193	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. RS10
13077375	13077375	PRJNA1197996_S_NODE_1171_length_676_cov_2.069652_g1127_i0	PRJNA1197996	1171	676	2.069652	13.99084752	Staphylococcus hominis	1290	Bacteria	Bacteria	1066	0	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g1127	i0	95.14	498.644970414201	679	28	100	5	1	676	714402	713726	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	337084	1066	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
13077429	13077429	PRJNA1197996_S_NODE_13491_length_304_cov_1.584416_g13437_i0	PRJNA1197996	13491	304	1.584416	4.81662464	Hungatella hathewayi	154046	Bacteria	Bacteria	392	1.4699999999999995e-104	NTclustered	gi\|1672835132\|gb\|CP040506.1\|	742737	g13437	i0	90.878	404.532894736842	296	22	97	5	11	304	2443689	2443397	Hungatella hathewayi WAL-18680 chromosome, complete genome	blastn	122978	392	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Hungatella	Hungatella hathewayi
13077442	13077442	PRJNA1197996_S_NODE_14011_length_300_cov_3.766520_g13957_i0	PRJNA1197996	14011	300	3.76652	11.29956	Aeribacillus composti	1868734	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2579540796\|gb\|CP134501.1\|	1868734	g13957	i0	100	0.0966666666666667	29	0	10	0	158	186	1458133	1458161	Aeribacillus composti strain HB-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Aeribacillus	Aeribacillus composti
13796958	13796958	PRJNA1197996_S_NODE_14931_length_294_cov_2.773756_g14877_i0	PRJNA1197996	14931	294	2.773756	8.15484264	Clostridia	186801	Bacteria	Bacteria	320	6.77e-83	NTclustered	gi\|2852972075\|gb\|CP173382.1\|	39490	g14877	i0	88.931	435.472789115646	262	25	88	4	35	294	2852759	2852500	Eubacterium ramulus strain JCM 31335 chromosome, complete genome	blastn	128029	322	0.993788819875776	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium ramulus
14352943	14352943	PRJNA1197996_S_NODE_17112_length_281_cov_3.240385_g17058_i0	PRJNA1197996	17112	281	3.240385	9.10548185	Ureibacillus chungkukjangi	1202712	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2851175656\|gb\|CP085009.1\|	1202712	g17058	i0	100	0.099644128113879	28	0	10	0	44	71	753584	753557	Ureibacillus chungkukjangi strain SLM-173 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Ureibacillus	Ureibacillus chungkukjangi
15626871	15626871	PRJNA1197996_S_NODE_23573_length_251_cov_0.865169_g23519_i0	PRJNA1197996	23573	251	0.865169	2.17157419	Eubacterium limosum	1736	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1576727518\|emb\|LR215983.1\|	1736	g23519	i0	100	0.111553784860558	28	0	11	0	163	190	996586	996613	Eubacterium limosum isolate Eubacterium limosum 81C1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium limosum
18895175	18895175	PRJNA1197996_S_NODE_5155_length_410_cov_3.139466_g5101_i0	PRJNA1197996	5155	410	3.139466	12.8718106	Clostridiaceae	31979	Bacteria	Bacteria	691	0	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g5101	i0	99.474	170.926829268293	380	2	93	0	1	380	9349	8970	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	70080	691	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
20169958	20169958	PRJNA1197996_S_NODE_7296_length_369_cov_1.364865_g7242_i0	PRJNA1197996	7296	369	1.364865	5.03635185	Kineothrix	2163168	Bacteria	Bacteria	322	2.42e-83	NTclustered	gi\|1708008652\|gb\|CP041667.1\|	2594789	g7242	i0	82.927	425.289972899729	369	51	100	6	1	369	660673	660317	Lachnospiraceae bacterium KGMB03038 chromosome, complete genome	blastn	156932	324	0.993827160493827	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium KGMB03038
20725373	20725373	PRJNA1197996_S_NODE_217_length_1223_cov_6.174783_g197_i0	PRJNA1197996	217	1223	6.174783	75.51759609	Enterococcus casseliflavus	37734	Bacteria	Bacteria	382	1.19e-127	NR	WP_413133017.1	37734	g197	i0	54.2	1.61651676206051	349	147	82.4	2	1088	81	17	365	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	1977	382	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
22000722	22000722	PRJNA1197996_S_NODE_19418_length_269_cov_1.913265_g19364_i0	PRJNA1197996	19418	269	1.913265	5.14668285	Oscillospiraceae bacterium NTUH-002-81	3079882	Bacteria	Bacteria	385	2.14e-102	NTclustered	gi\|2592042920\|gb\|CP136052.1\|	3079882	g19364	i0	92.857	473.182156133829	266	17	98	1	1	264	31507	31242	Oscillospiraceae bacterium NTUH-002-81 chromosome, complete genome	blastn	127286	385	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium NTUH-002-81
22000785	22000785	PRJNA1197996_S_NODE_21958_length_257_cov_4.510870_g21904_i0	PRJNA1197996	21958	257	4.51087	11.5929359	Hathewaya histolytica	1498	Bacteria	Bacteria	429	9.24e-116	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g21904	i0	100	88.5447470817121	232	0	90	0	1	232	40581	40350	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	22756	429	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
22000793	22000793	PRJNA1197996_S_NODE_22298_length_256_cov_1.262295_g22244_i0	PRJNA1197996	22298	256	1.262295	3.2314752	Blautia parvula	2877527	Bacteria	Bacteria	182	2.84e-41	NTclustered	gi\|2777543384\|dbj\|AP031413.1\|	2877527	g22244	i0	79.923	292.265625	259	42	100	9	1	256	14168	14419	Blautia parvula f21 DNA, complete genome	blastn	74820	182	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia parvula
22720428	22720428	PRJNA1197996_S_NODE_11518_length_320_cov_1.380567_g11464_i0	PRJNA1197996	11518	320	1.380567	4.4178144	Lactococcus	1357	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2571117238\|gb\|CP133260.1\|	1358	g11464	i0	100	0.875	28	0	9	0	23	50	1521787	1521814	Lactococcus lactis strain DRD-49 chromosome	blastn	280	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
25269826	25269826	PRJNA1197996_S_NODE_18300_length_275_cov_1.529703_g18246_i0	PRJNA1197996	18300	275	1.529703	4.20668325	Peptostreptococcales	3082720	Bacteria	Bacteria	191	5.13e-44	NTclustered	gi\|470487422\|ref\|NR_076817.1\|	143361	g18246	i0	83.495	175.723636363636	206	33	75	1	56	261	1419	1215	Filifactor alocis strain ATCC 35896 23S ribosomal RNA gene, complete sequence	blastn	48324	191	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Filifactor	Filifactor alocis
26755804	26755804	PRJNA1197996_S_NODE_23841_length_250_cov_1.435028_g23787_i0	PRJNA1197996	23841	250	1.435028	3.58757	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	42.4	0.0351	NR	MBS3811332.1	2094029	g23787	i0	37.1	0.744	62	37	73.2	2	31	213	89	149	MBS3811332.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Halanaerobiales bacterium]	diamond	186	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
27198720	27198720	PRJNA1197996_S_NODE_6502_length_382_cov_1.834951_g6448_i0	PRJNA1197996	6502	382	1.834951	7.00951282	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	44.7	0.0338	NR	MDY2879560.1	2054177	g6448	i0	31.2	0.604712041884817	77	48	58.1	3	252	31	385	459	MDY2879560.1 MATE family efflux transporter [Christensenellaceae bacterium]	diamond	231	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
27293763	27293763	PRJNA1197996_S_NODE_7463_length_366_cov_3.464164_g7409_i0	PRJNA1197996	7463	366	3.464164	12.67884024	Clostridium cochlearium	1494	Bacteria	Bacteria	43.1	0.0308	NR	WP_171302903.1	1494	g7409	i0	32.2	0.737704918032787	90	43	68.9	3	34	285	40	117	WP_171302903.1 hypothetical protein [Clostridium cochlearium]	diamond	270	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium cochlearium
28335785	28335785	PRJNA1197996_S_NODE_10026_length_334_cov_1.521073_g9972_i0	PRJNA1197996	10026	334	1.521073	5.08038382	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	44.3	0.0268	NR	MDD2958078.1	1898203	g9972	i0	30	0.988023952095808	110	69	98.8	3	333	4	121	222	MDD2958078.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	330	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30072444	30072444	PRJNA1197996_S_NODE_252_length_1166_cov_4.238792_g230_i0	PRJNA1197996	252	1166	4.238792	49.42431472	Melissococcus plutonius	33970	Bacteria	Bacteria	283	9.31e-89	NR	WP_231849637.1	33970	g230	i0	45.7	0.87221269296741	339	169	83.6	4	1009	35	35	372	WP_231849637.1 pectate lyase family protein [Melissococcus plutonius]	diamond	1017	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius
30925831	30925831	PRJNA1197996_S_NODE_16994_length_282_cov_1.593301_g16940_i0	PRJNA1197996	16994	282	1.593301	4.49310882	Eubacteriales bacterium	2831996	Bacteria	Bacteria	46.6	0.00255	NR	MBS7228452.1	2831996	g16940	i0	39	0.627659574468085	59	35	62.8	1	89	265	506	563	MBS7228452.1 hypothetical protein [Eubacteriales bacterium]	diamond	177	46.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
32412188	32412188	PRJNA1197996_S_NODE_16259_length_286_cov_2.417840_g16205_i0	PRJNA1197996	16259	286	2.41784	6.9150224	Paenibacillus sp. OSY-SE	1196323	Bacteria	Bacteria	139	4.01e-36	NR	WP_036702797.1	1196323	g16205	i0	69.6	0.965034965034965	92	28	96.5	0	285	10	229	320	WP_036702797.1 open beta-sheet domain-containing protein, partial [Paenibacillus sp. OSY-SE]	diamond	276	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. OSY-SE

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