metadata: contig_metadata: 36 rows where bioproject = "PRJNA543299" and tax

36 rows where bioproject = "PRJNA543299" 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
509603	509603	PRJNA543299_P_NODE_18341_length_175_cov_2.142857_g18184_i0	PRJNA543299	18341	175	2.142857	3.74999975	Clostridium disporicum	84024	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|333830419\|gb\|HM245956.1\|	84024	g18184	i0	98.857	883.068571428571	175	2	100	0	1	175	130	304	Clostridium disporicum strain DSM 5521 23S ribosomal RNA gene, partial sequence	blastn	154537	313	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium disporicum
1118532	1118532	PRJNA543299_P_NODE_10241_length_233_cov_0.880435_g10084_i0	PRJNA543299	10241	233	0.880435	2.05141355	Clostridium	1485	Bacteria	Bacteria	342	1.0999999999999999e-89	NTclustered	gi\|2869643049\|gb\|CP175543.1\|	1502	g10084	i0	93.506	904.922746781116	231	13	99	1	3	233	211405	211633	Clostridium perfringens strain GZ-3 chromosome, complete genome	blastn	210847	344	0.994186046511628	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
1118536	1118536	PRJNA543299_P_NODE_20361_length_167_cov_0.864407_g20204_i0	PRJNA543299	20361	167	0.864407	1.44355969	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	94.7	8.58e-22	NR	MBE6618708.1	2485925	g20204	i0	83.6	0.988023952095808	55	9	98.8	0	166	2	75	129	MBE6618708.1 energy-coupling factor transporter ATPase [Oscillospiraceae bacterium]	diamond	165	94.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
3060664	3060664	PRJNA543299_P_NODE_6023_length_299_cov_1.164000_g5867_i0	PRJNA543299	6023	299	1.164	3.48036	Lysinibacillus fusiformis	28031	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2451318646\|gb\|CP118714.1\|	28031	g5867	i0	100	0.678929765886288	29	0	10	0	213	241	780646	780618	Lysinibacillus fusiformis strain G5.M11b chromosome, complete genome	blastn	203	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus fusiformis
3669943	3669943	PRJNA543299_P_NODE_13743_length_202_cov_1.313725_g13586_i0	PRJNA543299	13743	202	1.313725	2.6537245	Clostridium	1485	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|358250948\|gb\|JN834642.1\|	59620	g13586	i0	100	125.925742574257	202	0	100	0	1	202	225	24	Uncultured Clostridium sp. clone 386E14TEAT 16S ribosomal RNA gene, partial sequence	blastn	25437	374	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
6222261	6222261	PRJNA543299_P_NODE_7625_length_268_cov_1.461187_g7468_i0	PRJNA543299	7625	268	1.461187	3.91598116	Staphylococcus	1279	Bacteria	Bacteria	490	4.39e-134	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g7468	i0	99.627	515.925373134328	268	1	100	0	1	268	383	116	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	138268	490	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
7496787	7496787	PRJNA543299_P_NODE_24406_length_163_cov_0.894737_g24249_i0	PRJNA543299	24406	163	0.894737	1.45842131	Staphylococcus	1279	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g24249	i0	100	99.8711656441718	163	0	100	0	1	163	1558372	1558534	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	16279	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
8771663	8771663	PRJNA543299_P_NODE_3887_length_367_cov_0.874214_g3732_i0	PRJNA543299	3887	367	0.874214	3.20836538	Bacteria	2	Bacteria	Bacteria	667	0	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g3732	i0	99.455	106.615803814714	367	2	100	0	1	367	979	1345	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	39128	673	0.991084695393759	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
8771664	8771664	PRJNA543299_P_NODE_4527_length_342_cov_1.982935_g4372_i0	PRJNA543299	4527	342	1.982935	6.7816377	Staphylococcus	1279	Bacteria	Bacteria	604	1.979999999999999e-168	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g4372	i0	98.538	525.014619883041	342	5	100	0	1	342	2028	2369	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	179555	610	0.99016393442623	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
12597656	12597656	PRJNA543299_P_NODE_8590_length_253_cov_2.941176_g8433_i0	PRJNA543299	8590	253	2.941176	7.44117528	Streptococcus	1301	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1578069334\|emb\|LR216032.1\|	1313	g8433	i0	100	322	253	0	100	0	1	253	23246	23498	Streptococcus pneumoniae strain 2245STDY5775874 genome assembly, chromosome: 1	blastn	81466	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
13872502	13872502	PRJNA543299_P_NODE_14751_length_195_cov_2.671233_g14594_i0	PRJNA543299	14751	195	2.671233	5.20890435	Staphylococcus	1279	Bacteria	Bacteria	353	4.12e-93	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g14594	i0	99.487	516.989743589744	195	0	100	1	1	195	1488	1295	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	100813	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
17696579	17696579	PRJNA543299_P_NODE_15614_length_190_cov_1.085106_g15457_i0	PRJNA543299	15614	190	1.085106	2.0617014	Bacillales	1385	Bacteria	Bacteria	346	6.690000000000001e-91	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g15457	i0	99.474	455.852631578947	190	1	100	0	1	190	772780	772969	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	86612	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
21520693	21520693	PRJNA543299_P_NODE_15557_length_190_cov_1.638298_g15400_i0	PRJNA543299	15557	190	1.638298	3.1127662	Streptococcus	1301	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1438634269\|gb\|CP031248.1\|	1313	g15400	i0	100	325	190	0	100	0	1	190	1467457	1467646	Streptococcus pneumoniae strain M26365 chromosome, complete genome	blastn	61750	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
22795856	22795856	PRJNA543299_P_NODE_20138_length_167_cov_1.728814_g19981_i0	PRJNA543299	20138	167	1.728814	2.88711938	root	1	Root_unresolved	Root_unresolved	309	7.53e-80	NTclustered	gi\|1851774573\|gb\|MT585552.1\|	1304	g19981	i0	100	105	167	0	100	0	1	167	1089	1255	Streptococcus salivarius strain 868 16S ribosomal RNA gene, partial sequence	blastn	17535	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
23461918	23461918	PRJNA543299_P_NODE_24719_length_162_cov_1.185841_g24562_i0	PRJNA543299	24719	162	1.185841	1.92106242	Streptococcus sp. LPB0220	2610896	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|1752759834\|gb\|CP044230.1\|	2610896	g24562	i0	90.798	489.858024691358	163	13	100	2	1	162	449166	449005	Streptococcus sp. LPB0220 chromosome, complete genome	blastn	79357	217	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. LPB0220
25344980	25344980	PRJNA543299_P_NODE_25500_length_161_cov_1.821429_g25343_i0	PRJNA543299	25500	161	1.821429	2.93250069	root	1	Root_unresolved	Root_unresolved	298	1.56e-76	NTclustered	gi\|289541377\|gb\|GU395995.1\|	29394	g25343	i0	100	103	161	0	100	0	1	161	758	598	Dolosigranulum pigrum strain 33929-06 16S ribosomal RNA gene, partial sequence	blastn	16583	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
27046330	27046330	PRJNA543299_P_NODE_22622_length_165_cov_0.879310_g22465_i0	PRJNA543299	22622	165	0.87931	1.4508615	Streptococcus pneumoniae	1313	Bacteria	Bacteria	77.8	3.62e-17	NR	WP_196301265.1	1313	g22465	i0	100	0.672727272727273	37	0	67.3	0	164	54	47	83	WP_196301265.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	111	77.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
27457307	27457307	PRJNA543299_P_NODE_20483_length_167_cov_0.864407_g20326_i0	PRJNA543299	20483	167	0.864407	1.44355969	Bacilli bacterium	1903720	Bacteria	Bacteria	44.3	0.00376	NR	MFA5408643.1	1903720	g20326	i0	74.2	0.55688622754491	31	8	55.7	0	75	167	29	59	MFA5408643.1 hypothetical protein [Bacilli bacterium]	diamond	93	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27583312	27583312	PRJNA543299_P_NODE_25364_length_162_cov_0.893805_g25207_i0	PRJNA543299	25364	162	0.893805	1.4479641	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	112	7.67e-29	NR	MBR3186902.1	1898203	g25207	i0	98.1	0.981481481481482	53	1	98.1	0	160	2	91	143	MBR3186902.1 AmmeMemoRadiSam system radical SAM enzyme [Lachnospiraceae bacterium]	diamond	159	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
27962295	27962295	PRJNA543299_P_NODE_23065_length_164_cov_0.886957_g22908_i0	PRJNA543299	23065	164	0.886957	1.45460948	uncultured Clostridium sp.	59620	Bacteria	Bacteria	82.4	1.34e-17	NR	WP_298842146.1	59620	g22908	i0	68.5	0.98780487804878	54	17	98.8	0	2	163	116	169	WP_298842146.1 recombination protein NinG [uncultured Clostridium sp.]	diamond	162	82.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
28734995	28734995	PRJNA543299_P_NODE_22347_length_165_cov_0.879310_g22190_i0	PRJNA543299	22347	165	0.87931	1.4508615	FCB group	1783270	Bacteria	Bacteria	59.7	2.29e-10	NR	WP_167553110.1	79879	g22190	i0	65	3.56363636363636	40	14	72.7	0	6	125	8	47	WP_167553110.1 hypothetical protein [Evansella clarkii]	diamond	588	59.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella clarkii
28829543	28829543	PRJNA543299_P_NODE_22348_length_165_cov_0.879310_g22191_i0	PRJNA543299	22348	165	0.87931	1.4508615	Bacillati	1783272	Bacteria	Bacteria	50.8	9.56e-6	NR	HLG27589.1	1932001	g22191	i0	46.2	5.72727272727273	52	28	94.5	0	7	162	56	107	HLG27589.1 hypothetical protein [Paenisporosarcina sp.]	diamond	945	50.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Paenisporosarcina	Paenisporosarcina sp.
28972792	28972792	PRJNA543299_P_NODE_22528_length_165_cov_0.879310_g22371_i0	PRJNA543299	22528	165	0.87931	1.4508615	Dialister sp.	1955814	Bacteria	Bacteria	68.9	7.29e-12	NR	MDU7216148.1	1955814	g22371	i0	59.6	0.945454545454545	52	21	94.5	0	158	3	55	106	MDU7216148.1 DEAD/DEAH box helicase family protein [Dialister sp.]	diamond	156	68.9	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Dialister	Dialister sp.
29319923	29319923	PRJNA543299_P_NODE_22549_length_165_cov_0.879310_g22392_i0	PRJNA543299	22549	165	0.87931	1.4508615	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	73.9	1.26e-13	NR	HVI41797.1	3030912	g22392	i0	59.3	0.981818181818182	54	22	98.2	0	164	3	66	119	HVI41797.1 hypothetical protein [Anaerovoracaceae bacterium]	diamond	162	73.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
29383217	29383217	PRJNA543299_P_NODE_22589_length_165_cov_0.879310_g22432_i0	PRJNA543299	22589	165	0.87931	1.4508615	Paenibacillus dakarensis	1527293	Bacteria	Bacteria	79.3	6.88e-17	NR	WP_245640109.1	1527293	g22432	i0	57.4	7.8	54	23	98.2	0	164	3	11	64	WP_245640109.1 dihydrofolate reductase [Paenibacillus dakarensis]	diamond	1287	79.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus dakarensis
29446107	29446107	PRJNA543299_P_NODE_23770_length_163_cov_0.894737_g23613_i0	PRJNA543299	23770	163	0.894737	1.45842131	Streptococcus pneumoniae	1313	Bacteria	Bacteria	62.8	3.55e-11	NR	WP_196301192.1	1313	g23613	i0	57.7	0.957055214723926	52	22	95.7	0	7	162	29	80	WP_196301192.1 hypothetical protein, partial [Streptococcus pneumoniae]	diamond	156	62.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
29983135	29983135	PRJNA543299_P_NODE_23351_length_164_cov_0.886957_g23194_i0	PRJNA543299	23351	164	0.886957	1.45460948	Romboutsia ilealis	1115758	Bacteria	Bacteria	43.5	0.00675	NR	WP_304431170.1	1115758	g23194	i0	68.2	0.402439024390244	22	7	40.2	0	5	70	221	242	WP_304431170.1 NUMOD1 domain-containing DNA-binding protein [Romboutsia ilealis]	diamond	66	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis
30060986	30060986	PRJNA543299_P_NODE_22611_length_165_cov_0.879310_g22454_i0	PRJNA543299	22611	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	90.5	1.56e-19	NR	MBC7074619.1	2093811	g22454	i0	77.8	2.94545454545455	54	12	98.2	0	164	3	137	190	MBC7074619.1 DEAD/DEAH box helicase family protein [Syntrophomonadaceae bacterium]	diamond	486	90.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
30172609	30172609	PRJNA543299_P_NODE_13592_length_203_cov_1.324675_g13435_i0	PRJNA543299	13592	203	1.324675	2.68909025	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	119	9.08e-34	NR	MFK5284285.1	1597	g13435	i0	100	0.842364532019704	57	0	84.2	0	3	173	9	65	MFK5284285.1 hypothetical protein [Lacticaseibacillus paracasei]	diamond	171	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
30962651	30962651	PRJNA543299_P_NODE_26114_length_161_cov_0.910714_g25957_i0	PRJNA543299	26114	161	0.910714	1.46624954	Zhenhengia sp.	2944208	Bacteria	Bacteria	45.1	0.00142	NR	WP_337530740.1	2944208	g25957	i0	51.1	2.72049689440994	45	22	83.9	0	141	7	14	58	WP_337530740.1 NUMOD4 motif-containing HNH endonuclease [Zhenhengia sp.]	diamond	438	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Zhenhengia	Zhenhengia sp.
31120228	31120228	PRJNA543299_P_NODE_17055_length_182_cov_1.150376_g16898_i0	PRJNA543299	17055	182	1.150376	2.09368432	Staphylococcus aureus	1280	Bacteria	Bacteria	58.2	2.67e-9	NR	WP_414058295.1	1280	g16898	i0	65	0.659340659340659	40	14	65.9	0	161	42	1	40	WP_414058295.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	120	58.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31500174	31500174	PRJNA543299_P_NODE_23076_length_164_cov_0.886957_g22919_i0	PRJNA543299	23076	164	0.886957	1.45460948	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	103	2.06e-27	NR	WP_222114585.1	283734	g22919	i0	94.4	0.98780487804878	54	3	98.8	0	1	162	23	76	WP_222114585.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	162	103	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
32291331	32291331	PRJNA543299_P_NODE_23999_length_163_cov_0.894737_g23842_i0	PRJNA543299	23999	163	0.894737	1.45842131	Bacilli bacterium	1903720	Bacteria	Bacteria	80.9	4.26e-16	NR	HOH61224.1	1903720	g23842	i0	66.7	0.993865030674847	54	17	99.4	1	1	162	94	146	HOH61224.1 hypothetical protein [Bacilli bacterium]	diamond	162	80.9	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
32385835	32385835	PRJNA543299_P_NODE_21159_length_166_cov_0.871795_g21002_i0	PRJNA543299	21159	166	0.871795	1.4471797	Clostridia bacterium	2044939	Bacteria	Bacteria	106	1.1500000000000002e-27	NR	NCC44200.1	2044939	g21002	i0	85.5	0.993975903614458	55	8	99.4	0	2	166	15	69	NCC44200.1 site-specific DNA-methyltransferase [Clostridia bacterium]	diamond	165	106	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32449341	32449341	PRJNA543299_P_NODE_17459_length_180_cov_0.847328_g17302_i0	PRJNA543299	17459	180	0.847328	1.5251904	Selenomonas flueggei	135080	Bacteria	Bacteria	42	0.0118	NR	WP_302816168.1	135080	g17302	i0	46.5	0.716666666666667	43	22	70	1	37	162	23	65	WP_302816168.1 hypothetical protein [Selenomonas flueggei]	diamond	129	42	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas flueggei
32764493	32764493	PRJNA543299_P_NODE_23420_length_164_cov_0.886957_g23263_i0	PRJNA543299	23420	164	0.886957	1.45460948	Intestinimonas sp. UBA1698	1946651	Bacteria	Bacteria	51.6	9.12e-6	NR	WP_286735166.1	1946651	g23263	i0	58.3	2.28658536585366	36	15	65.9	0	55	162	93	128	WP_286735166.1 DNA-methyltransferase [Intestinimonas sp. UBA1698]	diamond	375	51.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Intestinimonas	Intestinimonas sp. UBA1698

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