metadata: contig_metadata: 36 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax

36 rows where analysis = "diamond", bioproject = "PRJNA1174770" 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
1590957	1590957	PRJNA1174770_P_NODE_8502_length_168_cov_0.865546_g8413_i0	PRJNA1174770	8502	168	0.865546	1.45411728	Actinomyces oris	544580	Bacteria	Bacteria	103	2.24e-24	NR	WP_075411720.1	544580	g8413	i0	94.5	0.982142857142857	55	3	98.2	0	167	3	353	407	WP_075411720.1 M48 family metallopeptidase [Actinomyces oris]	diamond	165	103	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
11794845	11794845	PRJNA1174770_P_NODE_10970_length_164_cov_0.886957_g10881_i0	PRJNA1174770	10970	164	0.886957	1.45460948	Thermoleophilaceae bacterium	2732252	Bacteria	Bacteria	102	4.74e-26	NR	HVG75058.1	2732252	g10881	i0	87	3.95121951219512	54	7	98.8	0	163	2	9	62	HVG75058.1 hypothetical protein [Thermoleophilaceae bacterium]	diamond	648	102	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Thermoleophilales	Thermoleophilaceae		Thermoleophilaceae bacterium
18167932	18167932	PRJNA1174770_P_NODE_9175_length_167_cov_0.864407_g9086_i0	PRJNA1174770	9175	167	0.864407	1.44355969	Microbacterium azadirachtae	582680	Bacteria	Bacteria	81.3	2.22e-18	NR	WP_091739728.1	582680	g9086	i0	88.6	0.790419161676647	44	5	79	0	133	2	1	44	WP_091739728.1 NUDIX domain-containing protein [Microbacterium azadirachtae]	diamond	132	81.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium azadirachtae
21992923	21992923	PRJNA1174770_P_NODE_9058_length_167_cov_0.872881_g8969_i0	PRJNA1174770	9058	167	0.872881	1.45771127	Corynebacterium otitidis	29321	Bacteria	Bacteria	109	1.81e-26	NR	WP_131652056.1	29321	g8969	i0	100	0.988023952095808	55	0	98.8	0	165	1	288	342	WP_131652056.1 IucA/IucC family protein, partial [Corynebacterium otitidis]	diamond	165	109	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium otitidis
25267292	25267292	PRJNA1174770_P_NODE_9260_length_166_cov_1.675214_g9171_i0	PRJNA1174770	9260	166	1.675214	2.78085524	Agromyces sp. NPDC	51513	Bacteria	Bacteria	106	6.57e-28	NR	WP_376933926.1	3347092	g9171	i0	98.1	0.975903614457831	54	1	97.6	0	164	3	60	113	WP_376933926.1 pyridoxamine 5'-phosphate oxidase family protein [Agromyces sp. NPDC060279]	diamond	162	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces sp. NPDC060279
26838431	26838431	PRJNA1174770_P_NODE_8461_length_168_cov_0.873950_g8372_i0	PRJNA1174770	8461	168	0.87395	1.468236	Streptomyces	1883	Bacteria	Bacteria	42	0.0252	NR	WP_140160867.1	1883	g8372	i0	38.5	2.78571428571429	52	29	87.5	1	2	148	93	144	WP_140160867.1 MULTISPECIES: GMC oxidoreductase [Streptomyces]	diamond	468	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
26850899	26850899	PRJNA1174770_P_NODE_10561_length_164_cov_0.904348_g10472_i0	PRJNA1174770	10561	164	0.904348	1.48313072	Corynebacterium sp. HMSC	1720	Bacteria	Bacteria	106	3.97e-25	NR	WP_070791253.1	1715030	g10472	i0	92.6	0.98780487804878	54	4	98.8	0	163	2	599	652	WP_070791253.1 CRISPR-associated helicase/endonuclease Cas3 [Corynebacterium sp. HMSC074A01]	diamond	162	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. HMSC074A01
27103672	27103672	PRJNA1174770_P_NODE_6722_length_181_cov_1.492424_g6633_i0	PRJNA1174770	6722	181	1.492424	2.70128744	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	120	3.92e-31	NR	WP_303678949.1	1528099	g6633	i0	98.3	0.994475138121547	60	1	99.4	0	1	180	63	122	WP_303678949.1 class II fructose-bisphosphate aldolase [Lawsonella clevelandensis]	diamond	180	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
27767388	27767388	PRJNA1174770_P_NODE_10924_length_164_cov_0.895652_g10835_i0	PRJNA1174770	10924	164	0.895652	1.46886928	Lawsonella	1847725	Bacteria	Bacteria	112	3.36e-27	NR	WP_290598913.1	1847725	g10835	i0	100	0.98780487804878	54	0	98.8	0	164	3	294	347	WP_290598913.1 MULTISPECIES: amino acid ABC transporter ATP-binding/permease protein [Lawsonella]	diamond	162	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
27861758	27861758	PRJNA1174770_P_NODE_11385_length_163_cov_0.912281_g11296_i0	PRJNA1174770	11385	163	0.912281	1.48701803	Rhodococcus rhodochrous	1829	Bacteria	Bacteria	86.3	1.66e-19	NR	WP_217996140.1	1829	g11296	i0	70.4	0.993865030674847	54	16	99.4	0	162	1	78	131	WP_217996140.1 hypothetical protein, partial [Rhodococcus rhodochrous]	diamond	162	86.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus rhodochrous
28272148	28272148	PRJNA1174770_P_NODE_11466_length_163_cov_0.903509_g11377_i0	PRJNA1174770	11466	163	0.903509	1.47271967	Leifsonia shinshuensis	150026	Bacteria	Bacteria	60.1	9.17e-9	NR	WP_241704274.1	150026	g11377	i0	92.7	0.754601226993865	41	2	75.5	1	39	161	1	40	WP_241704274.1 ABC transporter substrate-binding protein [Leifsonia shinshuensis]	diamond	123	60.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
28335472	28335472	PRJNA1174770_P_NODE_10246_length_165_cov_0.887931_g10157_i0	PRJNA1174770	10246	165	0.887931	1.46508615	Lawsonella	1847725	Bacteria	Bacteria	113	1.4700000000000002e-27	NR	WP_290598370.1	1847725	g10157	i0	100	0.981818181818182	54	0	98.2	0	2	163	894	947	WP_290598370.1 MULTISPECIES: bifunctional [glutamine synthetase] adenylyltransferase/[glutamine synthetase]-adenylyl-L-tyrosine phosphorylase [Lawsonella]	diamond	162	113	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28525095	28525095	PRJNA1174770_P_NODE_9487_length_166_cov_0.888889_g9398_i0	PRJNA1174770	9487	166	0.888889	1.47555574	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	111	5.5e-27	NR	WP_306558940.1	1528099	g9398	i0	100	0.993975903614458	55	0	99.4	0	166	2	187	241	WP_306558940.1 L-aspartate oxidase [Lawsonella clevelandensis]	diamond	165	111	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
28556678	28556678	PRJNA1174770_P_NODE_8527_length_168_cov_0.865546_g8438_i0	PRJNA1174770	8527	168	0.865546	1.45411728	Actinomyces oris	544580	Bacteria	Bacteria	99.8	1.1200000000000001e-22	NR	WP_296499893.1	544580	g8438	i0	96.4	1.96428571428571	55	2	98.2	0	167	3	32	86	WP_296499893.1 tetratricopeptide repeat protein [Actinomyces oris]	diamond	330	99.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
28651273	28651273	PRJNA1174770_P_NODE_11247_length_163_cov_0.912281_g11158_i0	PRJNA1174770	11247	163	0.912281	1.48701803	Leifsonia sp. 71-9	1895934	Bacteria	Bacteria	107	7.470000000000001e-26	NR	WP_290471709.1	1895934	g11158	i0	100	0.993865030674847	54	0	99.4	0	163	2	344	397	WP_290471709.1 magnesium transporter MgtE N-terminal domain-containing protein [Leifsonia sp. 71-9]	diamond	162	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. 71-9
28808792	28808792	PRJNA1174770_P_NODE_9548_length_166_cov_0.888889_g9459_i0	PRJNA1174770	9548	166	0.888889	1.47555574	Mycobacterium sp.	1785	Bacteria	Bacteria	94.7	3.2500000000000003e-21	NR	HCA51558.1	1785	g9459	i0	74.5	0.993975903614458	55	14	99.4	0	165	1	65	119	HCA51558.1 hypothetical protein [Mycobacterium sp.]	diamond	165	94.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
29314298	29314298	PRJNA1174770_P_NODE_4149_length_226_cov_2.135593_g4060_i0	PRJNA1174770	4149	226	2.135593	4.82644018	Piscicoccus intestinalis	746033	Bacteria	Bacteria	43.5	0.0155	NR	WP_068430052.1	746033	g4060	i0	46.3	0.544247787610619	41	22	54.4	0	172	50	205	245	WP_068430052.1 universal stress protein [Piscicoccus intestinalis]	diamond	123	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Piscicoccus	Piscicoccus intestinalis
29598124	29598124	PRJNA1174770_P_NODE_10410_length_165_cov_0.870690_g10321_i0	PRJNA1174770	10410	165	0.87069	1.4366385	Leifsonia sp. TF	1870902	Bacteria	Bacteria	115	2.91e-29	NR	WP_208040468.1	2815212	g10321	i0	100	1	55	0	100	0	1	165	269	323	WP_208040468.1 septum formation family protein [Leifsonia sp. TF02-11]	diamond	165	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
29724459	29724459	PRJNA1174770_P_NODE_12110_length_162_cov_0.920354_g12021_i0	PRJNA1174770	12110	162	0.920354	1.49097348	Solirubrobacterales bacterium	1909295	Bacteria	Bacteria	96.7	1.11e-21	NR	HUC08116.1	1909295	g12021	i0	96.3	1	54	2	100	0	162	1	197	250	HUC08116.1 oligosaccharide flippase family protein [Solirubrobacterales bacterium]	diamond	162	96.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
29819272	29819272	PRJNA1174770_P_NODE_8151_length_168_cov_1.739496_g8062_i0	PRJNA1174770	8151	168	1.739496	2.92235328	Lawsonella	1847725	Bacteria	Bacteria	112	3.7e-29	NR	WP_290598776.1	1847725	g8062	i0	100	0.982142857142857	55	0	98.2	0	3	167	98	152	WP_290598776.1 MULTISPECIES: hypothetical protein [Lawsonella]	diamond	165	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
29882850	29882850	PRJNA1174770_P_NODE_9651_length_166_cov_0.880342_g9562_i0	PRJNA1174770	9651	166	0.880342	1.46136772	Actinomycetota bacterium	2900548	Bacteria	Bacteria	47	4.25e-4	NR	MDQ3153603.1	2900548	g9562	i0	43.6	0.993975903614458	55	31	99.4	0	166	2	358	412	MDQ3153603.1 right-handed parallel beta-helix repeat-containing protein [Actinomycetota bacterium]	diamond	165	47	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30072093	30072093	PRJNA1174770_P_NODE_8512_length_168_cov_0.865546_g8423_i0	PRJNA1174770	8512	168	0.865546	1.45411728	Mycolicibacterium sp. lyk4-4	2320850	Bacteria	Bacteria	114	1.15e-29	NR	WP_285029509.1	3040295	g8423	i0	98.2	1	56	1	100	0	1	168	61	116	WP_285029509.1 class I SAM-dependent methyltransferase [Mycolicibacterium sp. lyk4-40-TYG-92]	diamond	168	114	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sp. lyk4-40-TYG-92
30325496	30325496	PRJNA1174770_P_NODE_9792_length_166_cov_0.863248_g9703_i0	PRJNA1174770	9792	166	0.863248	1.43299168	Leifsonia sp. TF	1870902	Bacteria	Bacteria	112	2.92e-28	NR	WP_208040313.1	2815212	g9703	i0	98.2	0.993975903614458	55	1	99.4	0	165	1	127	181	WP_208040313.1 Lrp/AsnC family transcriptional regulator [Leifsonia sp. TF02-11]	diamond	165	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
30798769	30798769	PRJNA1174770_P_NODE_8214_length_168_cov_0.873950_g8125_i0	PRJNA1174770	8214	168	0.87395	1.468236	Leifsonia sp. TF	1870902	Bacteria	Bacteria	68.2	2.55e-12	NR	WP_307794814.1	2815212	g8125	i0	100	0.571428571428571	32	0	57.1	0	3	98	158	189	WP_307794814.1 dihydrofolate reductase family protein [Leifsonia sp. TF02-11]	diamond	96	68.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
30862057	30862057	PRJNA1174770_P_NODE_9134_length_167_cov_0.864407_g9045_i0	PRJNA1174770	9134	167	0.864407	1.44355969	Actinomyces viscosus	1656	Bacteria	Bacteria	112	2.28e-30	NR	WP_003788288.1	1656	g9045	i0	96	0.898203592814371	50	2	89.8	0	167	18	72	121	WP_003788288.1 hypothetical protein [Actinomyces viscosus]	diamond	150	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces viscosus
30944556	30944556	PRJNA1174770_P_NODE_11954_length_162_cov_0.920354_g11865_i0	PRJNA1174770	11954	162	0.920354	1.49097348	Actinomycetes	1760	Bacteria	Bacteria	68.2	4.39e-13	NR	WP_145993087.1	1269	g11865	i0	71.2	3.85185185185185	52	15	96.3	0	2	157	54	105	WP_145993087.1 MULTISPECIES: hypothetical protein [Micrococcus]	diamond	624	68.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus
31114603	31114603	PRJNA1174770_P_NODE_11715_length_163_cov_0.877193_g11626_i0	PRJNA1174770	11715	163	0.877193	1.42982459	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	75.5	3.45e-14	NR	MET0908001.1	2497619	g11626	i0	73.1	0.957055214723926	52	14	95.7	0	161	6	134	185	MET0908001.1 alpha-mannosidase [Ilumatobacteraceae bacterium]	diamond	156	75.5	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
31145996	31145996	PRJNA1174770_P_NODE_10295_length_165_cov_0.887931_g10206_i0	PRJNA1174770	10295	165	0.887931	1.46508615	Lawsonella sp.	2041415	Bacteria	Bacteria	100	9.53e-24	NR	WP_296237200.1	2041415	g10206	i0	98.1	0.963636363636364	53	1	96.4	0	161	3	191	243	WP_296237200.1 RNA polymerase sigma factor SigB [Lawsonella sp.]	diamond	159	100	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella sp.
31304475	31304475	PRJNA1174770_P_NODE_11555_length_163_cov_0.903509_g11466_i0	PRJNA1174770	11555	163	0.903509	1.47271967	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	108	9.89e-27	NR	WP_303678787.1	1528099	g11466	i0	100	0.975460122699387	53	0	97.5	0	3	161	281	333	WP_303678787.1 hypothetical protein [Lawsonella clevelandensis]	diamond	159	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31513714	31513714	PRJNA1174770_P_NODE_11996_length_162_cov_0.920354_g11907_i0	PRJNA1174770	11996	162	0.920354	1.49097348	Actinomycetes	1760	Bacteria	Bacteria	64.3	2.65e-10	NR	MDI3329585.1	1271	g11907	i0	84.2	3.72222222222222	38	6	70.4	0	114	1	6	43	MDI3329585.1 phosphotriesterase [Micrococcus sp.]	diamond	603	64.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus sp.
31778875	31778875	PRJNA1174770_P_NODE_10237_length_165_cov_0.887931_g10148_i0	PRJNA1174770	10237	165	0.887931	1.46508615	Nocardioides plantarum	29299	Bacteria	Bacteria	67	3.5e-11	NR	WP_379141784.1	29299	g10148	i0	78.4	0.927272727272727	51	11	92.7	0	155	3	496	546	WP_379141784.1 hypothetical protein [Nocardioides plantarum]	diamond	153	67	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides plantarum
31842056	31842056	PRJNA1174770_P_NODE_5277_length_202_cov_1.169935_g5188_i0	PRJNA1174770	5277	202	1.169935	2.3632687	Pseudarthrobacter sp. PS3-L1	3046207	Bacteria	Bacteria	42.4	0.0259	NR	WP_283536628.1	3046207	g5188	i0	40	0.816831683168317	55	33	81.7	0	201	37	114	168	WP_283536628.1 ECF transporter S component [Pseudarthrobacter sp. PS3-L1]	diamond	165	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter sp. PS3-L1
31968702	31968702	PRJNA1174770_P_NODE_12258_length_162_cov_0.911504_g12169_i0	PRJNA1174770	12258	162	0.911504	1.47663648	Leifsonia shinshuensis	150026	Bacteria	Bacteria	107	8.33e-26	NR	WP_179607485.1	150026	g12169	i0	96.2	2.94444444444444	53	2	98.1	0	3	161	132	184	WP_179607485.1 homoserine O-acetyltransferase MetX [Leifsonia shinshuensis]	diamond	477	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
32285537	32285537	PRJNA1174770_P_NODE_9599_length_166_cov_0.880342_g9510_i0	PRJNA1174770	9599	166	0.880342	1.46136772	Streptomyces sp. SUK 48	2582831	Bacteria	Bacteria	49.3	2.82e-5	NR	WP_343336046.1	2582831	g9510	i0	57.5	0.72289156626506	40	13	70.5	2	47	163	121	157	WP_343336046.1 hypothetical protein [Streptomyces sp. SUK 48]	diamond	120	49.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. SUK 48
32620464	32620464	PRJNA1174770_P_NODE_9600_length_166_cov_0.880342_g9511_i0	PRJNA1174770	9600	166	0.880342	1.46136772	Mycolicibacterium	1866885	Bacteria	Bacteria	79.7	1.22e-15	NR	WP_142551807.1	49897	g9511	i0	72.7	1.98795180722892	55	10	99.4	1	2	166	692	741	WP_142551807.1 indolepyruvate ferredoxin oxidoreductase family protein [Mycolicibacterium hodleri]	diamond	330	79.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium hodleri
32664245	32664245	PRJNA1174770_P_NODE_7760_length_170_cov_1.363636_g7671_i0	PRJNA1174770	7760	170	1.363636	2.3181812	Lawsonella	1847725	Bacteria	Bacteria	110	6.1e-27	NR	WP_290595217.1	1847725	g7671	i0	98.2	0.988235294117647	56	1	98.8	0	169	2	28	83	WP_290595217.1 MULTISPECIES: hemolysin family protein [Lawsonella]	diamond	168	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella

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