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

35 rows where analysis = "diamond", bioproject = "PRJNA767802" and tax_phylum = "Actinomycetota"

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
745213	745213	PRJNA767802_P_NODE_5821_length_332_cov_2.756184_g5748_i0	PRJNA767802	5821	332	2.756184	9.15053088	Micrococcaceae	1268	Bacteria	Bacteria	184	4.679999999999999e-55	NR	MDI3329116.1	1271	g5748	i0	87.3	4.60843373493976	102	13	92.2	0	3	308	251	352	MDI3329116.1 IS110 family transposase [Micrococcus sp.]	diamond	1530	184	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus sp.
4573418	4573418	PRJNA767802_P_NODE_10884_length_214_cov_2.909091_g10811_i0	PRJNA767802	10884	214	2.909091	6.22545474	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	137	1.33e-38	NR	WP_106121727.1	272918	g10811	i0	100	0.911214953271028	65	0	91.1	0	2	196	155	219	WP_106121727.1 TenA family protein [Nesterenkonia sandarakina]	diamond	195	137	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
4573427	4573427	PRJNA767802_P_NODE_12184_length_200_cov_1.443709_g12111_i0	PRJNA767802	12184	200	1.443709	2.887418	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	72	2.73e-14	NR	WP_181256018.1	272918	g12111	i0	92.3	1.755	39	3	58.5	0	1	117	79	117	WP_181256018.1 transposase, partial [Nesterenkonia sandarakina]	diamond	351	72	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
5848743	5848743	PRJNA767802_P_NODE_3405_length_479_cov_1.527907_g3333_i0	PRJNA767802	3405	479	1.527907	7.31867453	unclassified Nesterenkonia	2629769	Bacteria	Bacteria	142	4.06e-38	NR	WP_241465459.1	2629769	g3333	i0	95.8	0.444676409185804	71	3	44.5	0	265	477	9	79	WP_241465459.1 MULTISPECIES: 1,4-dihydroxy-2-naphthoyl-CoA synthase [unclassified Nesterenkonia]	diamond	213	142	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia
7123920	7123920	PRJNA767802_P_NODE_2366_length_591_cov_1.345018_g2301_i0	PRJNA767802	2366	591	1.345018	7.94905638	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	368	1.5399999999999999e-124	NR	WP_106123611.1	272918	g2301	i0	98.3	0.898477157360406	177	3	89.8	0	1	531	250	426	WP_106123611.1 endo-1,4-beta-xylanase [Nesterenkonia sandarakina]	diamond	531	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
8398425	8398425	PRJNA767802_P_NODE_8867_length_247_cov_1.383838_g8794_i0	PRJNA767802	8867	247	1.383838	3.41807986	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	158	1.03e-42	NR	WP_106121868.1	272918	g8794	i0	97.5	0.983805668016194	81	2	98.4	0	245	3	709	789	WP_106121868.1 ExeM/NucH family extracellular endonuclease [Nesterenkonia sandarakina]	diamond	243	158	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
9673572	9673572	PRJNA767802_P_NODE_11848_length_203_cov_1.662338_g11775_i0	PRJNA767802	11848	203	1.662338	3.37454614	Nesterenkonia sp. Act2	704201	Bacteria	Bacteria	114	1.3800000000000002e-27	NR	WP_218221238.1	1483432	g11775	i0	88.1	0.990147783251232	67	8	99	0	202	2	64	130	WP_218221238.1 ATP-dependent chaperone ClpB [Nesterenkonia sp. Act20]	diamond	201	114	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sp. Act20
10949264	10949264	PRJNA767802_P_NODE_1749_length_692_cov_1.636081_g1691_i0	PRJNA767802	1749	692	1.636081	11.32168052	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	433	3.16e-149	NR	WP_258175011.1	272918	g1691	i0	100	0.997109826589595	230	0	99.7	0	690	1	219	448	WP_258175011.1 TrkH family potassium uptake protein [Nesterenkonia sandarakina]	diamond	690	433	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
12224793	12224793	PRJNA767802_P_NODE_10030_length_226_cov_1.440678_g9957_i0	PRJNA767802	10030	226	1.440678	3.25593228	Nesterenkonia jeotgali	317018	Bacteria	Bacteria	140	6.16e-38	NR	WP_058889510.1	317018	g9957	i0	96	0.995575221238938	75	3	99.6	0	1	225	103	177	WP_058889510.1 TerC family protein [Nesterenkonia jeotgali]	diamond	225	140	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia jeotgali
17323472	17323472	PRJNA767802_P_NODE_13594_length_186_cov_1.649635_g13521_i0	PRJNA767802	13594	186	1.649635	3.0683211	Nesterenkonia sp. LB17	2901230	Bacteria	Bacteria	114	1.46e-27	NR	WP_241463998.1	2901230	g13521	i0	95.1	0.983870967741935	61	3	98.4	0	184	2	175	235	WP_241463998.1 DUF4040 family protein [Nesterenkonia sp. LB17]	diamond	183	114	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sp. LB17
17783664	17783664	PRJNA767802_P_NODE_19094_length_159_cov_2.318182_g19021_i0	PRJNA767802	19094	159	2.318182	3.68590938	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	110	1.11e-26	NR	WP_106124213.1	272918	g19021	i0	100	0.981132075471698	52	0	98.1	0	158	3	124	175	WP_106124213.1 IS21 family transposase [Nesterenkonia sandarakina]	diamond	156	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
21147704	21147704	PRJNA767802_P_NODE_13597_length_186_cov_1.510949_g13524_i0	PRJNA767802	13597	186	1.510949	2.81036514	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	122	1.14e-30	NR	WP_106121868.1	272918	g13524	i0	98.4	1.96774193548387	61	1	98.4	0	3	185	603	663	WP_106121868.1 ExeM/NucH family extracellular endonuclease [Nesterenkonia sandarakina]	diamond	366	122	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
21147785	21147785	PRJNA767802_P_NODE_5737_length_335_cov_2.622378_g5664_i0	PRJNA767802	5737	335	2.622378	8.7849663	Nesterenkonia	57494	Bacteria	Bacteria	94.7	3.69e-21	NR	WP_246310339.1	57494	g5664	i0	86.4	0.788059701492537	88	7	74.3	2	251	3	1	88	WP_246310339.1 MULTISPECIES: fasciclin domain-containing protein [Nesterenkonia]	diamond	264	94.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia
24157756	24157756	PRJNA767802_P_NODE_1579_length_727_cov_1.595870_g1525_i0	PRJNA767802	1579	727	1.59587	11.6019749	Nesterenkonia jeotgali	317018	Bacteria	Bacteria	295	2.31e-95	NR	WP_058889510.1	317018	g1525	i0	95.1	0.676753782668501	164	8	67.7	0	725	234	237	400	WP_058889510.1 TerC family protein [Nesterenkonia jeotgali]	diamond	492	295	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia jeotgali
26778108	26778108	PRJNA767802_P_NODE_6641_length_304_cov_2.537255_g6568_i0	PRJNA767802	6641	304	2.537255	7.7132552	Streptomyces	1883	Bacteria	Bacteria	51.6	2.08e-5	NR	WP_030795273.1	1883	g6568	i0	51.1	0.927631578947368	47	23	46.4	0	23	163	34	80	WP_030795273.1 MULTISPECIES: RICIN domain-containing protein [Streptomyces]	diamond	282	52	0.992307692307692	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
26799985	26799985	PRJNA767802_P_NODE_2481_length_573_cov_2.501908_g2414_i0	PRJNA767802	2481	573	2.501908	14.33593284	Nesterenkonia jeotgali	317018	Bacteria	Bacteria	55.1	4.11e-6	NR	WP_182494631.1	317018	g2414	i0	42.6	0.492146596858639	94	46	45	4	531	274	27	120	WP_182494631.1 hypothetical protein [Nesterenkonia jeotgali]	diamond	282	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia jeotgali
27274513	27274513	PRJNA767802_P_NODE_14463_length_178_cov_1.666667_g14390_i0	PRJNA767802	14463	178	1.666667	2.96666726	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	107	3.2600000000000004e-27	NR	WP_106121727.1	272918	g14390	i0	96.6	1.98876404494382	59	2	99.4	0	1	177	70	128	WP_106121727.1 TenA family protein [Nesterenkonia sandarakina]	diamond	354	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
27558555	27558555	PRJNA767802_P_NODE_14524_length_178_cov_1.186047_g14451_i0	PRJNA767802	14524	178	1.186047	2.11116366	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	112	5.84e-27	NR	WP_106123559.1	272918	g14451	i0	98.2	0.960674157303371	57	1	96.1	0	177	7	102	158	WP_106123559.1 heavy metal translocating P-type ATPase [Nesterenkonia sandarakina]	diamond	171	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
27622041	27622041	PRJNA767802_P_NODE_11204_length_211_cov_1.234568_g11131_i0	PRJNA767802	11204	211	1.234568	2.60493848	Nesterenkonia sp. LB17	2901230	Bacteria	Bacteria	131	1.32e-33	NR	WP_241463998.1	2901230	g11131	i0	98.6	0.995260663507109	70	1	99.5	0	2	211	69	138	WP_241463998.1 DUF4040 family protein [Nesterenkonia sp. LB17]	diamond	210	131	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sp. LB17
28569050	28569050	PRJNA767802_P_NODE_8087_length_264_cov_1.786047_g8014_i0	PRJNA767802	8087	264	1.786047	4.71516408	Cryobacterium sp. TmT2-59	1259264	Bacteria	Bacteria	77	3.94e-14	NR	WP_134434492.1	1259264	g8014	i0	52.9	0.988636363636364	87	39	98.9	1	3	263	20	104	WP_134434492.1 hypothetical protein [Cryobacterium sp. TmT2-59]	diamond	261	77	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Cryobacterium	Cryobacterium sp. TmT2-59
29011505	29011505	PRJNA767802_P_NODE_10748_length_216_cov_1.526946_g10675_i0	PRJNA767802	10748	216	1.526946	3.29820336	Nesterenkonia jeotgali	317018	Bacteria	Bacteria	118	4.72e-32	NR	WP_157075430.1	317018	g10675	i0	72.2	1	72	20	100	0	216	1	28	99	WP_157075430.1 hypothetical protein [Nesterenkonia jeotgali]	diamond	216	118	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia jeotgali
29579238	29579238	PRJNA767802_P_NODE_1150_length_854_cov_2.463354_g1103_i0	PRJNA767802	1150	854	2.463354	21.03704316	Nesterenkonia halotolerans	225325	Bacteria	Bacteria	299	1.62e-98	NR	WP_192591848.1	225325	g1103	i0	94.7	0.526932084309134	150	8	52.7	0	451	2	1	150	WP_192591848.1 TnsA-like heteromeric transposase endonuclease subunit [Nesterenkonia halotolerans]	diamond	450	299	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia halotolerans
29832054	29832054	PRJNA767802_P_NODE_4471_length_400_cov_1.675214_g4398_i0	PRJNA767802	4471	400	1.675214	6.700856	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	248	1.6e-76	NR	WP_181255848.1	272918	g4398	i0	97.7	0.9975	133	3	99.8	0	399	1	258	390	WP_181255848.1 sensor histidine kinase [Nesterenkonia sandarakina]	diamond	399	248	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
29927012	29927012	PRJNA767802_P_NODE_2711_length_547_cov_2.684739_g2643_i0	PRJNA767802	2711	547	2.684739	14.68552233	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	242	2.8000000000000003e-74	NR	WP_106124213.1	272918	g2643	i0	100	0.674588665447898	123	0	67.5	0	371	3	1	123	WP_106124213.1 IS21 family transposase [Nesterenkonia sandarakina]	diamond	369	242	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
30653360	30653360	PRJNA767802_P_NODE_1173_length_845_cov_2.608040_g1126_i0	PRJNA767802	1173	845	2.60804	22.037938	unclassified Nesterenkonia	2629769	Bacteria	Bacteria	359	6.2e-123	NR	WP_207170364.1	2629769	g1126	i0	93.6	0.717159763313609	202	13	71.7	0	9	614	1	202	WP_207170364.1 MULTISPECIES: sigma-70 family RNA polymerase sigma factor [unclassified Nesterenkonia]	diamond	606	359	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia
30685007	30685007	PRJNA767802_P_NODE_1433_length_766_cov_1.806137_g1381_i0	PRJNA767802	1433	766	1.806137	13.83500942	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	450	3.94e-155	NR	WP_106123442.1	272918	g1381	i0	97.2	0.986945169712794	252	7	98.7	0	3	758	227	478	WP_106123442.1 AAA family ATPase [Nesterenkonia sandarakina]	diamond	756	450	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
30906485	30906485	PRJNA767802_P_NODE_3594_length_460_cov_1.489051_g3521_i0	PRJNA767802	3594	460	1.489051	6.8496346	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	230	4.75e-67	NR	WP_106121868.1	272918	g3521	i0	96.8	0.821739130434783	126	4	82.2	0	82	459	896	1021	WP_106121868.1 ExeM/NucH family extracellular endonuclease [Nesterenkonia sandarakina]	diamond	378	230	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
31222037	31222037	PRJNA767802_P_NODE_8195_length_262_cov_1.610329_g8122_i0	PRJNA767802	8195	262	1.610329	4.21906198	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	120	1.63e-29	NR	WP_181255972.1	272918	g8122	i0	95.1	0.698473282442748	61	3	69.8	0	1	183	472	532	WP_181255972.1 FtsK/SpoIIIE domain-containing protein [Nesterenkonia sandarakina]	diamond	183	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
31253861	31253861	PRJNA767802_P_NODE_5235_length_357_cov_1.305195_g5162_i0	PRJNA767802	5235	357	1.305195	4.65954615	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	134	7.18e-34	NR	WP_106123623.1	272918	g5162	i0	98.6	0.605042016806723	72	1	60.5	0	218	3	1	72	WP_106123623.1 helicase-associated domain-containing protein [Nesterenkonia sandarakina]	diamond	216	134	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
31674555	31674555	PRJNA767802_P_NODE_6797_length_299_cov_1.816000_g6724_i0	PRJNA767802	6797	299	1.816	5.4298400000000004	Bacteria	2	Bacteria	Bacteria	50.4	1.03e-5	NR	HYH54002.1	1909295	g6724	i0	63.6	0.672240802675585	33	12	33.1	0	182	280	33	65	HYH54002.1 hypothetical protein [Solirubrobacterales bacterium]	diamond	201	50.8	0.992125984251969	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
31949657	31949657	PRJNA767802_P_NODE_1697_length_701_cov_2.340491_g1640_i0	PRJNA767802	1697	701	2.340491	16.40684191	unclassified Nesterenkonia	2629769	Bacteria	Bacteria	384	3.62e-133	NR	WP_241470427.1	2629769	g1640	i0	88.4	0.885877318116976	207	24	88.6	0	1	621	37	243	WP_241470427.1 MULTISPECIES: Rep family protein [unclassified Nesterenkonia]	diamond	621	384	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia
32139705	32139705	PRJNA767802_P_NODE_998_length_915_cov_1.647806_g953_i0	PRJNA767802	998	915	1.647806	15.0774249	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	587	9.98e-199	NR	WP_181255972.1	272918	g953	i0	97.7	0.99672131147541	304	7	99.7	0	914	3	646	949	WP_181255972.1 FtsK/SpoIIIE domain-containing protein [Nesterenkonia sandarakina]	diamond	912	587	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
32424433	32424433	PRJNA767802_P_NODE_18599_length_161_cov_1.669643_g18526_i0	PRJNA767802	18599	161	1.669643	2.68812523	Nesterenkonia sandarakina	272918	Bacteria	Bacteria	102	3.02e-25	NR	WP_258175010.1	272918	g18526	i0	100	0.987577639751553	53	0	98.8	0	2	160	32	84	WP_258175010.1 potassium channel family protein [Nesterenkonia sandarakina]	diamond	159	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sandarakina
32424435	32424435	PRJNA767802_P_NODE_4919_length_373_cov_3.003086_g4846_i0	PRJNA767802	4919	373	3.003086	11.20151078	Nesterenkonia sp. Act2	704201	Bacteria	Bacteria	177	7.129999999999999e-54	NR	WP_218221829.1	1483432	g4846	i0	88.7	0.780160857908847	97	11	78	0	292	2	1	97	WP_218221829.1 hypothetical protein [Nesterenkonia sp. Act20]	diamond	291	177	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sp. Act20
32519589	32519589	PRJNA767802_P_NODE_10939_length_214_cov_1.212121_g10866_i0	PRJNA767802	10939	214	1.212121	2.59393894	Nesterenkonia sp. AN1	652017	Bacteria	Bacteria	128	8.42e-34	NR	WP_051500751.1	652017	g10866	i0	90.1	1.99065420560748	71	7	99.5	0	213	1	255	325	WP_051500751.1 alkene reductase [Nesterenkonia sp. AN1]	diamond	426	128	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sp. AN1

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