metadata: contig_metadata: 31 rows where bioproject = "PRJNA1086823" and tax_clade = "Cyanobacteriota/Melainabacteria group"

31 rows where bioproject = "PRJNA1086823" and tax_clade = "Cyanobacteriota/Melainabacteria 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
193929	193929	PRJNA1086823_P_NODE_7941_length_293_cov_2.590909_g7824_i0	PRJNA1086823	7941	293	2.590909	7.59136337	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	440	4.959999999999998e-119	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g7824	i0	94.138	120.894197952218	290	15	99	2	4	292	1921	1633	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35422	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1468563	1468563	PRJNA1086823_P_NODE_8062_length_292_cov_1.292237_g7945_i0	PRJNA1086823	8062	292	1.292237	3.77333204	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	418	2.3199999999999996e-112	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g7945	i0	92.466	113.900684931507	292	22	100	0	1	292	3117	2826	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33259	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2744626	2744626	PRJNA1086823_P_NODE_7163_length_307_cov_2.205128_g7046_i0	PRJNA1086823	7163	307	2.205128	6.76974296	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	510	3.93e-140	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g7046	i0	96.743	272.882736156352	307	9	100	1	1	307	1858982	1858677	Calothrix sp. PCC 7716 DNA, complete genome	blastn	83775	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
4020422	4020422	PRJNA1086823_P_NODE_2524_length_479_cov_2.352217_g2407_i0	PRJNA1086823	2524	479	2.352217	11.26711943	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	494	6.45e-135	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2407	i0	85.391	125.826722338205	486	59	100	12	1	479	3682000	3682480	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	60271	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
5296632	5296632	PRJNA1086823_P_NODE_4105_length_385_cov_3.160256_g3988_i0	PRJNA1086823	4105	385	3.160256	12.1669856	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	544	4.969999999999998e-150	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g3988	i0	92.408	106.6	382	27	99	2	6	385	1640	2021	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41041	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6571821	6571821	PRJNA1086823_P_NODE_8106_length_291_cov_2.064220_g7989_i0	PRJNA1086823	8106	291	2.06422	6.0068802	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	508	1.33e-139	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g7989	i0	98.282	283.347079037801	291	4	100	1	1	291	1857505	1857794	Calothrix sp. PCC 7716 DNA, complete genome	blastn	82454	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9121283	9121283	PRJNA1086823_P_NODE_1168_length_698_cov_14.227200_g10_i7	PRJNA1086823	1168	698	14.2272	99.305856	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	1155	0	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g10	i7	96.571	119.163323782235	700	18	100	4	1	698	1157	462	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	83176	1155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
11220803	11220803	PRJNA1086823_P_NODE_16929_length_245_cov_1.261628_g16812_i0	PRJNA1086823	16929	245	1.261628	3.0909886	Oscillatoriales	1150	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g16812	i0	98.367	140.240816326531	245	4	100	0	1	245	921	1165	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	34359	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11220827	11220827	PRJNA1086823_P_NODE_5349_length_346_cov_1.142857_g5232_i0	PRJNA1086823	5349	346	1.142857	3.95428522	Synechococcales	1890424	Bacteria	Bacteria	86.1	3.23e-12	NTclustered	gi\|78196017\|gb\|CP000110.1\|	110662	g5232	i0	89.706	17.6416184971098	68	5	19	2	116	181	2191224	2191291	Synechococcus sp. CC9605, complete genome	blastn	6104	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CC9605
12947433	12947433	PRJNA1086823_P_NODE_14551_length_249_cov_0.886364_g14434_i0	PRJNA1086823	14551	249	0.886364	2.20704636	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	144	4.96e-38	NR	HEY9778558.1	3088178	g14434	i0	87.8	0.987951807228916	82	10	98.8	0	247	2	128	209	HEY9778558.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Leptolyngbyaceae cyanobacterium]	diamond	246	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
13770753	13770753	PRJNA1086823_P_NODE_2631_length_470_cov_1.659950_g2514_i0	PRJNA1086823	2631	470	1.65995	7.801765	Chroococcidiopsis	54298	Bacteria	Bacteria	680	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g2514	i0	92.781	205.814893617021	471	33	100	1	1	470	14	484	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	96733	680	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
20143772	20143772	PRJNA1086823_P_NODE_2556_length_476_cov_2.181141_g2439_i0	PRJNA1086823	2556	476	2.181141	10.38223116	Oscillatoriales	1150	Bacteria	Bacteria	830	0	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g2439	i0	98.113	152.163865546218	477	8	100	1	1	476	103585	103109	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	72430	830	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
20594905	20594905	PRJNA1086823_P_NODE_2997_length_441_cov_1.820652_g2880_i0	PRJNA1086823	2997	441	1.820652	8.02907532	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	320	1.06e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2880	i0	80.556	116.142857142857	432	70	96	13	1	422	3681543	3681116	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	51219	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
24419700	24419700	PRJNA1086823_P_NODE_400_length_1145_cov_13.415112_g10_i6	PRJNA1086823	400	1145	13.415112	153.6030324	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1916	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g10	i6	96.859	100.342358078603	1146	34	100	2	1	1145	1576	2720	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	114892	1916	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25243756	25243756	PRJNA1086823_P_NODE_5500_length_342_cov_1.185874_g5383_i0	PRJNA1086823	5500	342	1.185874	4.05568908	Chroococcidiopsis	54298	Bacteria	Bacteria	568	2.6e-157	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g5383	i0	96.512	114.286549707602	344	10	100	2	1	342	4312	3969	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	39086	571	0.994746059544658	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
26814446	26814446	PRJNA1086823_P_NODE_8141_length_291_cov_1.311927_g8024_i0	PRJNA1086823	8141	291	1.311927	3.81770757	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	71.2	1.5e-12	NR	HEY9684379.1	3088181	g8024	i0	97.4	0.391752577319588	38	1	39.2	0	1	114	186	223	HEY9684379.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	114	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27406862	27406862	PRJNA1086823_P_NODE_11163_length_261_cov_1.308511_g11046_i0	PRJNA1086823	11163	261	1.308511	3.41521371	Cyanophyceae	3028117	Bacteria	Bacteria	65.1	6e-10	NR	WP_199245511.1	222819	g11046	i0	50.8	5.5632183908046	63	30	72.4	1	72	260	49	110	WP_199245511.1 CAP domain-containing protein [[Phormidium] sp. ETS-05]	diamond	1452	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Koinonema	[Phormidium] sp. ETS-05
27762751	27762751	PRJNA1086823_P_NODE_18404_length_243_cov_0.917647_g18287_i0	PRJNA1086823	18404	243	0.917647	2.22988221	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	46.6	0.00165	NR	WP_155897956.1	2886352	g18287	i0	66.7	0.444444444444444	36	12	44.4	0	112	5	923	958	WP_155897956.1 CHAT domain-containing protein [Allocoleopsis franciscana]	diamond	108	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
28583562	28583562	PRJNA1086823_P_NODE_12227_length_253_cov_0.866667_g12110_i0	PRJNA1086823	12227	253	0.866667	2.19266751	Geitlerinema sp. PCC 74	3100420	Bacteria	Bacteria	80.9	2.82e-17	NR	WP_015170897.1	1173025	g12110	i0	85.1	0.557312252964427	47	7	55.7	0	1	141	87	133	WP_015170897.1 DUF309 domain-containing protein [Geitlerinema sp. PCC 7407]	diamond	141	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
29057123	29057123	PRJNA1086823_P_NODE_10108_length_271_cov_2.090909_g9991_i0	PRJNA1086823	10108	271	2.090909	5.66636339	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	58.9	7.95e-8	NR	WP_190491935.1	2692827	g9991	i0	43.3	1.43911439114391	67	35	74.2	1	204	4	1	64	WP_190491935.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	390	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
29364322	29364322	PRJNA1086823_P_NODE_12229_length_253_cov_0.866667_g12112_i0	PRJNA1086823	12229	253	0.866667	2.19266751	Cyanophyceae	3028117	Bacteria	Bacteria	111	1.71e-29	NR	WP_106370926.1	2107693	g12112	i0	77.9	2.44268774703557	68	14	79.4	1	206	6	44	111	WP_106370926.1 transposase [Chlorogloea sp. CCALA 695]	diamond	618	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
29562060	29562060	PRJNA1086823_P_NODE_13150_length_251_cov_2.443820_g13033_i0	PRJNA1086823	13150	251	2.44382	6.1339882	Acaryochloridaceae cyanobacterium SU_2_1	2720477	Bacteria	Bacteria	95.9	2.26e-21	NR	NJK40782.1	2720477	g13033	i0	62.2	2.54581673306773	74	28	88.4	0	222	1	8	81	NJK40782.1 FAD-dependent oxidoreductase [Acaryochloridaceae cyanobacterium SU_2_1]	diamond	639	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium SU_2_1
29783171	29783171	PRJNA1086823_P_NODE_6591_length_318_cov_1.273469_g6474_i0	PRJNA1086823	6591	318	1.273469	4.04963142	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	77.8	1.41e-14	NR	HEY9635810.1	3081323	g6474	i0	58.1	1.24528301886792	62	26	58.5	0	291	106	210	271	HEY9635810.1 hypothetical protein [Coleofasciculaceae cyanobacterium]	diamond	396	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
30035971	30035971	PRJNA1086823_P_NODE_19211_length_242_cov_0.923077_g19094_i0	PRJNA1086823	19211	242	0.923077	2.23384634	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	50.8	3.2e-5	NR	PZM77368.1	2053573	g19094	i0	44.4	0.669421487603306	54	30	66.9	0	33	194	152	205	PZM77368.1 MAG: hypothetical protein DKM50_12885 [Candidatus Margulisiibacteriota bacterium]	diamond	162	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
30130345	30130345	PRJNA1086823_P_NODE_13592_length_251_cov_0.876404_g13475_i0	PRJNA1086823	13592	251	0.876404	2.19977404	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	128	2.33e-32	NR	WP_106367765.1	2107693	g13475	i0	79.5	0.99203187250996006	83	17	99.2	0	1	249	1	83	WP_106367765.1 ABC transporter ATP-binding protein [Chlorogloea sp. CCALA 695]	diamond	249	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
30383878	30383878	PRJNA1086823_P_NODE_16233_length_246_cov_1.786127_g16116_i0	PRJNA1086823	16233	246	1.786127	4.39387242	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	89	5.36e-19	NR	HEY9781340.1	3088178	g16116	i0	87.3	0.670731707317073	55	7	67.1	0	244	80	239	293	HEY9781340.1 ABC transporter permease [Leptolyngbyaceae cyanobacterium]	diamond	165	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
30478366	30478366	PRJNA1086823_P_NODE_16013_length_247_cov_0.896552_g15896_i0	PRJNA1086823	16013	247	0.896552	2.21448344	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	169	5.21e-49	NR	HEY9782996.1	3088178	g15896	i0	100	0.983805668016194	81	0	98.4	0	245	3	10	90	HEY9782996.1 FtsW/RodA/SpoVE family cell cycle protein [Leptolyngbyaceae cyanobacterium]	diamond	243	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31236441	31236441	PRJNA1086823_P_NODE_13915_length_250_cov_0.881356_g13798_i0	PRJNA1086823	13915	250	0.881356	2.20339	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	172	1.85e-53	NR	HEY9782956.1	3088178	g13798	i0	95.2	0.996	83	4	99.6	0	2	250	31	113	HEY9782956.1 KGK domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	249	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31584669	31584669	PRJNA1086823_P_NODE_12956_length_252_cov_0.871508_g12839_i0	PRJNA1086823	12956	252	0.871508	2.19620016	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	52.8	1.05e-5	NR	MBF2053141.1	2762020	g12839	i0	36.5	1.97619047619048	85	43	98.8	4	251	3	76	151	MBF2053141.1 S1/P1 nuclease [Candidatus Sericytochromatia bacterium]	diamond	498	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31711048	31711048	PRJNA1086823_P_NODE_2057_length_523_cov_1.755556_g1941_i0	PRJNA1086823	2057	523	1.755556	9.18155788	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	147	4.61e-40	NR	WP_190491935.1	2692827	g1941	i0	50.7	1.73231357552581	150	73	85.5	1	521	75	120	269	WP_190491935.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	906	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
32470560	32470560	PRJNA1086823_P_NODE_9999_length_272_cov_2.351759_g9882_i0	PRJNA1086823	9999	272	2.351759	6.39678448	Microseira wollei	467598	Bacteria	Bacteria	92.8	1.65e-20	NR	WP_226575606.1	467598	g9882	i0	51.8	0.9375	85	33	84.9	1	3	233	12	96	WP_226575606.1 hypothetical protein [Microseira wollei]	diamond	255	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei

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