metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA290839" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA290839" and tax_clade = "FCB group"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8026192	8026192	PRJNA290839_P_NODE_1107_length_251_cov_0.876404_g1086_i0	PRJNA290839	1107	251	0.876404	2.19977404	Alloprevotella sp. Lung23	1872471	Bacteria	Bacteria	157	5.0699999999999996e-46	NR	WP_187547528.1	2766595	g1086	i0	93.7	0.944223107569721	79	5	94.4	0	238	2	1	79	WP_187547528.1 30S ribosomal protein S3 [Alloprevotella sp. Lung230]	diamond	237	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. Lung230
8026199	8026199	PRJNA290839_P_NODE_1647_length_242_cov_0.911243_g1626_i0	PRJNA290839	1647	242	0.911243	2.20520806	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	157	1.2199999999999999e-42	NR	MBF1068738.1	2049047	g1626	i0	100	1.98347107438017	80	0	99.2	0	240	1	207	286	MBF1068738.1 ATP-dependent chaperone ClpB [Prevotellaceae bacterium]	diamond	480	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
9300971	9300971	PRJNA290839_P_NODE_1248_length_249_cov_0.875000_g1227_i0	PRJNA290839	1248	249	0.875	2.17875	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	120	4.57e-31	NR	NBO61270.1	2044941	g1227	i0	88.3	0.72289156626506	60	7	72.3	0	2	181	260	319	NBO61270.1 hypothetical protein [Flavobacteriia bacterium]	diamond	180	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
15675633	15675633	PRJNA290839_P_NODE_193_length_638_cov_1.343363_g172_i0	PRJNA290839	193	638	1.343363	8.57065594	Bacteroidota bacterium	1898104	Bacteria	Bacteria	357	1.68e-123	NR	MBL0342960.1	1898104	g172	i0	94.1	0.869905956112853	185	11	87	0	84	638	1	185	MBL0342960.1 GTP-binding protein [Bacteroidota bacterium]	diamond	555	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
18910932	18910932	PRJNA290839_P_NODE_1415_length_246_cov_0.895954_g1394_i0	PRJNA290839	1415	246	0.895954	2.20404684	Alloprevotella sp. oral taxon 473	712469	Bacteria	Bacteria	141	6.79e-40	NR	WP_009437572.1	712469	g1394	i0	88.9	1.97560975609756	81	9	98.8	0	2	244	2	82	WP_009437572.1 3-oxoacyl-[acyl-carrier-protein] reductase [Alloprevotella sp. oral taxon 473]	diamond	486	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. oral taxon 473
20774372	20774372	PRJNA290839_P_NODE_1537_length_243_cov_0.917647_g1516_i0	PRJNA290839	1537	243	0.917647	2.22988221	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	111	7.839999999999999e-30	NR	MBF1066130.1	2049047	g1516	i0	100	0.666666666666667	54	0	66.7	0	162	1	1	54	MBF1066130.1 thioredoxin [Prevotellaceae bacterium]	diamond	162	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
22049326	22049326	PRJNA290839_P_NODE_1198_length_249_cov_0.886364_g1177_i0	PRJNA290839	1198	249	0.886364	2.20704636	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	90.5	1.54e-19	NR	MBF1075294.1	2049047	g1177	i0	100	0.566265060240964	47	0	56.6	0	1	141	263	309	MBF1075294.1 cysteine synthase A [Prevotellaceae bacterium]	diamond	141	90.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
26947510	26947510	PRJNA290839_P_NODE_1582_length_243_cov_0.911765_g1561_i0	PRJNA290839	1582	243	0.911765	2.21558895	Chitinophaga sp.	1869181	Bacteria	Bacteria	129	4.26e-33	NR	MBA4197283.1	1869181	g1561	i0	100	0.790123456790123	64	0	79	0	2	193	453	516	MBA4197283.1 alpha-N-arabinofuranosidase [Chitinophaga sp.]	diamond	192	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp.
27232198	27232198	PRJNA290839_P_NODE_1103_length_251_cov_0.876404_g1082_i0	PRJNA290839	1103	251	0.876404	2.19977404	Fibrobacter sp.	35828	Bacteria	Bacteria	57.4	2.75e-7	NR	WP_290926195.1	35828	g1082	i0	43.2	0.884462151394422	74	32	83.7	2	246	37	57	124	WP_290926195.1 PLAT/LH2 domain-containing protein [Fibrobacter sp.]	diamond	222	57.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
27453621	27453621	PRJNA290839_P_NODE_1023_length_253_cov_0.866667_g1002_i0	PRJNA290839	1023	253	0.866667	2.19266751	Bacteroidota bacterium	1898104	Bacteria	Bacteria	155	5.6e-42	NR	MBS1636709.1	1898104	g1002	i0	82.1	0.99604743083004	84	15	99.6	0	252	1	520	603	MBS1636709.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium]	diamond	252	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27548079	27548079	PRJNA290839_P_NODE_464_length_380_cov_1.260586_g443_i0	PRJNA290839	464	380	1.260586	4.7902268	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	70.9	2.62e-11	NR	MBL0024111.1	2202734	g443	i0	38.8	0.955263157894737	121	63	94.7	5	20	379	1111	1221	MBL0024111.1 gliding motility-associated C-terminal domain-containing protein [Saprospiraceae bacterium]	diamond	363	70.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
27724004	27724004	PRJNA290839_P_NODE_1424_length_246_cov_0.890173_g1403_i0	PRJNA290839	1424	246	0.890173	2.18982558	Porphyromonas	836	Bacteria	Bacteria	122	2.74e-34	NR	GGM55857.1	1583331	g1403	i0	93.5	1.51219512195122	62	4	75.6	0	187	2	1	62	GGM55857.1 hypothetical protein GCM10007088_13390 [Porphyromonas pasteri]	diamond	372	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pasteri
27863773	27863773	PRJNA290839_P_NODE_1105_length_251_cov_0.876404_g1084_i0	PRJNA290839	1105	251	0.876404	2.19977404	Bacteroidota bacterium	1898104	Bacteria	Bacteria	140	1.26e-39	NR	MES2765126.1	1898104	g1084	i0	84.6	0.932270916334661	78	12	93.2	0	1	234	151	228	MES2765126.1 toll/interleukin-1 receptor domain-containing protein [Bacteroidota bacterium]	diamond	234	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28590248	28590248	PRJNA290839_P_NODE_407_length_404_cov_0.939577_g386_i0	PRJNA290839	407	404	0.939577	3.79589108	Sinomicrobium oceani	1150368	Bacteria	Bacteria	160	8e-46	NR	WP_245776963.1	1150368	g386	i0	58	2.04950495049505	138	53	99.5	2	403	2	6	142	WP_245776963.1 M12 family metallopeptidase, partial [Sinomicrobium oceani]	diamond	828	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Sinomicrobium	Sinomicrobium oceani
29032349	29032349	PRJNA290839_P_NODE_1568_length_243_cov_0.911765_g1547_i0	PRJNA290839	1568	243	0.911765	2.21558895	Porphyromonadaceae bacterium	2049046	Bacteria	Bacteria	147	6.85e-44	NR	MBF1314773.1	2049046	g1547	i0	98.8	1.97530864197531	80	1	98.8	0	3	242	34	113	MBF1314773.1 tetratricopeptide repeat protein [Porphyromonadaceae bacterium]	diamond	480	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		Porphyromonadaceae bacterium
29095401	29095401	PRJNA290839_P_NODE_1608_length_242_cov_0.923077_g1587_i0	PRJNA290839	1608	242	0.923077	2.23384634	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	165	3.71e-45	NR	MBF1068559.1	2049047	g1587	i0	98.8	0.991735537190083	80	1	99.2	0	3	242	84	163	MBF1068559.1 hypothetical protein [Prevotellaceae bacterium]	diamond	240	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
29127083	29127083	PRJNA290839_P_NODE_1089_length_251_cov_1.432584_g1068_i0	PRJNA290839	1089	251	1.432584	3.59578584	Bacteroidia bacterium	2044936	Bacteria	Bacteria	54.7	2.5e-6	NR	GHT13257.1	2044936	g1068	i0	41.1	0.872509960159363	73	41	86.1	2	245	30	496	567	GHT13257.1 hypothetical protein FACS189426_17900 [Bacteroidia bacterium]	diamond	219	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
29127084	29127084	PRJNA290839_P_NODE_1569_length_243_cov_0.911765_g1548_i0	PRJNA290839	1569	243	0.911765	2.21558895	Alloprevotella sp. oral taxon 473 str. F	1872471	Bacteria	Bacteria	90.1	6.35e-22	NR	EKX87631.1	1035197	g1548	i0	97.6	0.518518518518518	42	1	51.9	0	126	1	1	42	EKX87631.1 hypothetical protein HMPREF9999_02245 [Alloprevotella sp. oral taxon 473 str. F0040]	diamond	126	90.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. oral taxon 473
29252881	29252881	PRJNA290839_P_NODE_349_length_452_cov_1.617414_g328_i0	PRJNA290839	349	452	1.617414	7.31071128	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	60.8	1.68e-7	NR	MCI5080337.1	2202734	g328	i0	31.7	0.962389380530973	145	86	94.9	6	5	433	499	632	MCI5080337.1 hypothetical protein [Saprospiraceae bacterium]	diamond	435	60.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
29284507	29284507	PRJNA290839_P_NODE_1209_length_249_cov_0.886364_g1188_i0	PRJNA290839	1209	249	0.886364	2.20704636	Alloprevotella sp. oral taxon 473	712469	Bacteria	Bacteria	176	5.89e-52	NR	WP_009436195.1	712469	g1188	i0	100	1.97590361445783	82	0	98.8	0	248	3	100	181	WP_009436195.1 DUF4876 domain-containing protein [Alloprevotella sp. oral taxon 473]	diamond	492	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. oral taxon 473
29347919	29347919	PRJNA290839_P_NODE_1029_length_253_cov_0.866667_g1008_i0	PRJNA290839	1029	253	0.866667	2.19266751	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	43.9	0.014	NR	HRD07832.1	2202734	g1008	i0	55.3	1.35177865612648	38	11	37.9	2	147	242	32	69	HRD07832.1 hypothetical protein [Saprospiraceae bacterium]	diamond	342	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
29379420	29379420	PRJNA290839_P_NODE_1509_length_244_cov_0.912281_g1488_i0	PRJNA290839	1509	244	0.912281	2.22596564	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	160	7.48e-47	NR	MBF1066118.1	2049047	g1488	i0	100	0.971311475409836	79	0	97.1	0	242	6	209	287	MBF1066118.1 energy transducer TonB [Prevotellaceae bacterium]	diamond	237	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
29491713	29491713	PRJNA290839_P_NODE_350_length_452_cov_0.823219_g329_i0	PRJNA290839	350	452	0.823219	3.72094988	Bacteroidota	976	Bacteria	Bacteria	82.4	2.83e-15	NR	WP_072995414.1	192903	g329	i0	37	2.5287610619469	127	73	80.3	4	443	81	192	317	WP_072995414.1 M12 family metallopeptidase [Pseudozobellia thermophila]	diamond	1143	83.2	0.990384615384615	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pseudozobellia	Pseudozobellia thermophila
29600188	29600188	PRJNA290839_P_NODE_1610_length_242_cov_0.923077_g1589_i0	PRJNA290839	1610	242	0.923077	2.23384634	Porphyromonadaceae bacterium	2049046	Bacteria	Bacteria	155	3.2e-45	NR	MBF1309288.1	2049046	g1589	i0	95	0.991735537190083	80	4	99.2	0	1	240	27	106	MBF1309288.1 hypothetical protein [Porphyromonadaceae bacterium]	diamond	240	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		Porphyromonadaceae bacterium
29712394	29712394	PRJNA290839_P_NODE_1150_length_250_cov_0.881356_g1129_i0	PRJNA290839	1150	250	0.881356	2.20339	Bacteroidota	976	Bacteria	Bacteria	147	9.45e-41	NR	MBS1634649.1	1898104	g1129	i0	81.9	7.968	83	15	99.6	0	249	1	74	156	MBS1634649.1 pyridoxal phosphate-dependent aminotransferase [Bacteroidota bacterium]	diamond	1992	148	0.993243243243243	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30123270	30123270	PRJNA290839_P_NODE_432_length_394_cov_1.380062_g411_i0	PRJNA290839	432	394	1.380062	5.43744428	Bacteroidota	976	Bacteria	Bacteria	98.6	6.3200000000000005e-21	NR	WP_379941899.1	881009	g411	i0	47.7	3.22081218274112	109	49	82.2	3	1	324	1310	1411	WP_379941899.1 gliding motility-associated C-terminal domain-containing protein [Mariniflexile aquimaris]	diamond	1269	98.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Mariniflexile	Mariniflexile aquimaris
31085265	31085265	PRJNA290839_P_NODE_1095_length_251_cov_0.876404_g1074_i0	PRJNA290839	1095	251	0.876404	2.19977404	Sphingobacteriia bacterium	2035813	Bacteria	Bacteria	93.6	2.83e-21	NR	MBN8835903.1	2035813	g1074	i0	97.7	0.525896414342629	44	1	52.6	0	134	3	1	44	MBN8835903.1 hypothetical protein [Sphingobacteriia bacterium]	diamond	132	93.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia				Sphingobacteriia bacterium
31243187	31243187	PRJNA290839_P_NODE_1555_length_243_cov_0.917647_g1534_i0	PRJNA290839	1555	243	0.917647	2.22988221	Chlorobi bacterium OLB4	1617411	Bacteria	Bacteria	68.2	3.44e-11	NR	KXK06264.1	1617411	g1534	i0	46.7	2.81481481481481	60	32	74.1	0	62	241	274	333	KXK06264.1 MAG: aminomethyltransferase [Chlorobi bacterium OLB4]	diamond	684	68.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Candidatus Tepidiaquacellales			Candidatus Tepidiaquacellales bacterium OLB4/UTCHB1
31861698	31861698	PRJNA290839_P_NODE_1397_length_246_cov_0.895954_g1376_i0	PRJNA290839	1397	246	0.895954	2.20404684	Bacteria	2	Bacteria	Bacteria	134	3.4399999999999997e-37	NR	MEW6468442.1	1898104	g1376	i0	81.5	3.91463414634146	81	15	98.8	0	2	244	151	231	MEW6468442.1 SDR family oxidoreductase [Bacteroidota bacterium]	diamond	963	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31970732	31970732	PRJNA290839_P_NODE_678_length_310_cov_1.316456_g657_i0	PRJNA290839	678	310	1.316456	4.0810136	Candidatus Pullibacteroides excrementavium	2840905	Bacteria	Bacteria	68.9	1.38e-11	NR	MBO8432334.1	2840905	g657	i0	40.6	0.97741935483871	101	55	97.7	2	310	8	107	202	MBO8432334.1 CAP domain-containing protein [Candidatus Pullibacteroides excrementavium]	diamond	303	68.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales		Candidatus Pullibacteroides	Candidatus Pullibacteroides excrementavium
32178446	32178446	PRJNA290839_P_NODE_1598_length_242_cov_2.076923_g1577_i0	PRJNA290839	1598	242	2.076923	5.02615366	Mucilaginibacter	423349	Bacteria	Bacteria	62.8	2.37e-9	NR	MDB5018708.1	1882438	g1577	i0	48.5	1.71074380165289	66	32	81.8	2	199	2	24	87	MDB5018708.1 hypothetical protein [Mucilaginibacter sp.]	diamond	414	62.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp.
32255948	32255948	PRJNA290839_P_NODE_1398_length_246_cov_0.895954_g1377_i0	PRJNA290839	1398	246	0.895954	2.20404684	Bacteroidia bacterium	2044936	Bacteria	Bacteria	153	1.2e-42	NR	MBP7808758.1	2044936	g1377	i0	95.1	4	82	4	100	0	1	246	57	138	MBP7808758.1 adenylosuccinate synthase [Bacteroidia bacterium]	diamond	984	153	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
32319156	32319156	PRJNA290839_P_NODE_579_length_337_cov_0.875000_g558_i0	PRJNA290839	579	337	0.875	2.94875	Alloprevotella sp. oral taxon 473	712469	Bacteria	Bacteria	128	6.99e-32	NR	WP_009436722.1	712469	g558	i0	59.8	0.997032640949555	112	42	98.8	3	5	337	333	442	WP_009436722.1 Mfa1 family fimbria major subunit [Alloprevotella sp. oral taxon 473]	diamond	336	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. oral taxon 473
32823844	32823844	PRJNA290839_P_NODE_1620_length_242_cov_0.923077_g1599_i0	PRJNA290839	1620	242	0.923077	2.23384634	Bacteroidota bacterium	1898104	Bacteria	Bacteria	138	1.79e-39	NR	MBI3521443.1	1898104	g1599	i0	80	2.97520661157025	80	16	99.2	0	2	241	7	86	MBI3521443.1 lipoprotein signal peptidase [Bacteroidota bacterium]	diamond	720	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32886602	32886602	PRJNA290839_P_NODE_1380_length_246_cov_0.901734_g1359_i0	PRJNA290839	1380	246	0.901734	2.21826564	Bergeyella cardium	1585976	Bacteria	Bacteria	151	1.4e-40	NR	WP_120489559.1	1585976	g1359	i0	88.9	0.98780487804878	81	9	98.8	0	2	244	70	150	WP_120489559.1 TonB-dependent receptor plug domain-containing protein [Bergeyella cardium]	diamond	243	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium

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