metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA400391" and tax_clade = "Cyanobacteriota/Melainabacteria group"

31 rows where analysis = "blastn", bioproject = "PRJNA400391" 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
413999	413999	PRJNA400391_S_NODE_2481_length_254_cov_13.009132_g2420_i0	PRJNA400391	2481	254	13.009132	33.04319528	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	390	4.299999999999999e-104	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g2420	i0	94.488	222.055118110236	254	13	100	1	1	254	7	259	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	56402	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
414098	414098	PRJNA400391_S_NODE_841_length_375_cov_11.517647_g780_i0	PRJNA400391	841	375	11.517647	43.19117625	Chamaesiphon minutus	1173032	Bacteria	Bacteria	584	2.8499999999999984e-162	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g780	i0	96.1	223.744	359	13	96	1	1	359	485	842	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	83904	584	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
1688928	1688928	PRJNA400391_S_NODE_502_length_450_cov_5.291566_g442_i0	PRJNA400391	502	450	5.291566	23.812047	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	568	3.499999999999999e-157	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g442	i0	93.931	167.36	379	18	84	3	73	450	3669913	3669539	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	75312	568	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
1688930	1688930	PRJNA400391_S_NODE_5102_length_175_cov_1.535714_g5041_i0	PRJNA400391	5102	175	1.535714	2.6874995	Thalassoporum mexicanum	3457544	Bacteria	Bacteria	82.4	1.88e-11	NTclustered	gi\|427988066\|gb\|CP003592.1\|	82654	g5041	i0	84.27	2.03428571428571	89	9	49	5	4	89	1760370	1760284	Pseudanabaena sp. PCC 7367, complete genome	blastn	356	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Thalassoporaceae	Thalassoporum	Thalassoporum mexicanum
2356443	2356443	PRJNA400391_S_NODE_2122_length_273_cov_16.567227_g2061_i0	PRJNA400391	2122	273	16.567227	45.22852971	Cyanophyceae	3028117	Bacteria	Bacteria	479	9.699999999999996e-131	NTclustered	gi\|321271924\|gb\|HQ419021.1\|	1211	g2061	i0	98.524	100.289377289377	271	4	99	0	1	271	792	522	Uncultured cyanobacterium clone AL66_2CY_12 16S ribosomal RNA gene, partial sequence	blastn	27379	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2964761	2964761	PRJNA400391_S_NODE_1203_length_336_cov_22.840532_g1142_i0	PRJNA400391	1203	336	22.840532	76.74418752	Chamaesiphon minutus	1173032	Bacteria	Bacteria	560	4.26e-155	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1142	i0	96.726	210.16369047619	336	11	100	0	1	336	1063	1398	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	70615	560	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
3631870	3631870	PRJNA400391_S_NODE_4303_length_193_cov_27.917722_g4242_i0	PRJNA400391	4303	193	27.917722	53.88120346	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	346	6.82e-91	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g4242	i0	98.964	99.9222797927461	193	2	100	0	1	193	76	268	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	19285	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3631892	3631892	PRJNA400391_S_NODE_543_length_440_cov_46.733333_g483_i0	PRJNA400391	543	440	46.733333	205.6266652	Chamaesiphon	217161	Bacteria	Bacteria	702	0	NTclustered	gi\|2687960063\|dbj\|LC716659.1\|	2954811	g483	i0	95.465	101.736363636364	441	18	100	2	1	440	860	421	Chamaesiphon bursiformis MF64 gene for 16S rRNA, partial sequence	blastn	44764	702	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon bursiformis
4241103	4241103	PRJNA400391_S_NODE_1604_length_304_cov_6.933086_g1543_i0	PRJNA400391	1604	304	6.933086	21.076581439999998	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	368	2.48e-97	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g1543	i0	88.525	174.207236842105	305	33	100	2	1	304	3669787	3670090	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	52959	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
4909052	4909052	PRJNA400391_S_NODE_544_length_440_cov_33.449383_g484_i0	PRJNA400391	544	440	33.449383	147.1772852	Chamaesiphon	217161	Bacteria	Bacteria	813	0	NTclustered	gi\|2687960063\|dbj\|LC716659.1\|	2954811	g484	i0	100	101.725	440	0	100	0	1	440	421	860	Chamaesiphon bursiformis MF64 gene for 16S rRNA, partial sequence	blastn	44759	813	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon bursiformis
6184130	6184130	PRJNA400391_S_NODE_3605_length_212_cov_20.717514_g3544_i0	PRJNA400391	3605	212	20.717514	43.92112968	root	1	Root_unresolved	Root_unresolved	359	9.81e-95	NTclustered	gi\|195360595\|gb\|EU882171.1\|	1211	g3544	i0	97.17	102.985849056604	212	6	100	0	1	212	291	80	Uncultured cyanobacterium isolate DGGE gel band MB-05-CYA-B2-8 16S ribosomal RNA gene, partial sequence	blastn	21833	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6184145	6184145	PRJNA400391_S_NODE_465_length_458_cov_10.196217_g405_i0	PRJNA400391	465	458	10.196217	46.69867386	Cyanophyceae	3028117	Bacteria	Bacteria	529	1.6799999999999992e-145	NTclustered	gi\|1035493916\|gb\|KT354204.1\|	1858734	g405	i0	88.393	219.445414847162	448	40	97	12	1	442	1158	717	Synechocystis pevalekii SAG 91.79 clone c 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	100506	529	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
8733888	8733888	PRJNA400391_S_NODE_587_length_428_cov_104.656489_g527_i0	PRJNA400391	587	428	104.656489	447.92977292	root	1	Root_unresolved	Root_unresolved	453	9.68e-123	NTclustered	gi\|192763991\|gb\|EU780332.1\|	1211	g527	i0	99.597	67.1144859813084	248	1	58	0	181	428	54	301	Uncultured cyanobacterium clone 1DP2-B8 16S ribosomal RNA gene, partial sequence	blastn	28725	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10009076	10009076	PRJNA400391_S_NODE_1368_length_321_cov_5.006993_g1307_i0	PRJNA400391	1368	321	5.006993	16.07244753	Oscillatoriales	1150	Bacteria	Bacteria	523	5.309999999999998e-144	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g1307	i0	96.805	122.766355140187	313	10	98	0	9	321	2518	2206	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39408	523	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12559752	12559752	PRJNA400391_S_NODE_6330_length_155_cov_1.725000_g6269_i0	PRJNA400391	6330	155	1.725	2.67375	Bacillati	1783272	Bacteria	Bacteria	198	1.5499999999999999e-46	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g6269	i0	89.809	15.658064516129	157	12	100	4	1	155	4827943	4828097	Leptolyngbya sp. 7M chromosome	blastn	2427	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
13167802	13167802	PRJNA400391_S_NODE_1811_length_291_cov_6.343750_g1750_i0	PRJNA400391	1811	291	6.34375	18.4603125	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	279	1.14e-70	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g1750	i0	84.561	337.621993127148	285	41	97	3	4	286	1478508	1478225	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	98248	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
13167829	13167829	PRJNA400391_S_NODE_2791_length_240_cov_2.707317_g2730_i0	PRJNA400391	2791	240	2.707317	6.4975608	Limnothece alkaliphila	3349495	Bacteria	Bacteria	75	4.61e-9	NTclustered	gi\|2522768022\|gb\|OR162557.1\|	3055816	g2730	i0	83.529	2.98333333333333	85	8	34	4	5	85	1947	1865	Limnothece alkaliphila FACHB-3576 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	716	75	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Limnothece	Limnothece alkaliphila
14443004	14443004	PRJNA400391_S_NODE_3332_length_220_cov_26.081081_g3271_i0	PRJNA400391	3332	220	26.081081	57.3783782	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	335	1.7299999999999996e-87	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g3271	i0	94.144	196.831818181818	222	10	100	3	1	220	2834	2614	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43303	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15108776	15108776	PRJNA400391_S_NODE_1932_length_283_cov_111.854839_g1871_i0	PRJNA400391	1932	283	111.854839	316.54919437	root	1	Root_unresolved	Root_unresolved	523	4.5999999999999983e-144	NTclustered	gi\|229562654\|gb\|FJ901413.1\|	1211	g1871	i0	100	112	283	0	100	0	1	283	537	819	Uncultured cyanobacterium clone LP1MB50 16S ribosomal RNA gene, partial sequence	blastn	31696	523	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17658581	17658581	PRJNA400391_S_NODE_2874_length_237_cov_4.717822_g2813_i0	PRJNA400391	2874	237	4.717822	11.18123814	Cyanophyceae	3028117	Bacteria	Bacteria	298	2.47e-76	NTclustered	gi\|2179753748\|gb\|CP071717.1\|	2740837	g2813	i0	89.7	172.409282700422	233	24	98	0	5	237	1169464	1169696	Acaryochloris sp. 'Moss Beach' chromosome, complete genome	blastn	40861	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. 'Moss Beach'
18932581	18932581	PRJNA400391_S_NODE_775_length_386_cov_100.626781_g714_i0	PRJNA400391	775	386	100.626781	388.41937466	root	1	Root_unresolved	Root_unresolved	680	0	NTclustered	gi\|148723931\|gb\|EF520516.1\|	1211	g714	i0	98.446	101.00518134715	386	6	100	0	1	386	545	160	Uncultured cyanobacterium clone ADK-MOe02-64 16S ribosomal RNA gene, partial sequence	blastn	38988	686	0.991253644314869	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19539888	19539888	PRJNA400391_S_NODE_536_length_443_cov_7.409314_g476_i0	PRJNA400391	536	443	7.409314	32.82326102	Pleurocapsa minor	54308	Bacteria	Bacteria	448	4.68e-121	NTclustered	gi\|2717502817\|gb\|PP667998.1\|	3139816	g476	i0	85.194	175.72460496614	439	62	98	3	8	443	2247	2685	Pleurocapsa minor SAG 4.99 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	77846	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
20815795	20815795	PRJNA400391_S_NODE_997_length_358_cov_17.000000_g936_i0	PRJNA400391	997	358	17	60.86	Synechocystis pevalekii	1392622	Bacteria	Bacteria	579	1.2599999999999999e-160	NTclustered	gi\|1035493916\|gb\|KT354204.1\|	1858734	g936	i0	95.822	154.430167597765	359	13	100	2	1	358	1232	875	Synechocystis pevalekii SAG 91.79 clone c 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55286	579	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
22090480	22090480	PRJNA400391_S_NODE_2018_length_279_cov_27.254098_g1957_i0	PRJNA400391	2018	279	27.254098	76.03893342	Chamaesiphon minutus	1173032	Bacteria	Bacteria	505	1.6399999999999995e-138	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1957	i0	99.283	159.688172043011	279	2	100	0	1	279	2223	2501	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	44553	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
22090513	22090513	PRJNA400391_S_NODE_3278_length_222_cov_2.689840_g3217_i0	PRJNA400391	3278	222	2.68984	5.9714448	Aliterella chasmolithica	2739056	Bacteria	Bacteria	340	3.75e-89	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g3217	i0	94.545	133.630630630631	220	12	99	0	1	220	2224	2005	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29666	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
22090535	22090535	PRJNA400391_S_NODE_3978_length_202_cov_3.341317_g3917_i0	PRJNA400391	3978	202	3.341317	6.74946034	Chamaesiphon minutus	1173032	Bacteria	Bacteria	357	3.3299999999999996e-94	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g3917	i0	98.515	4	202	3	100	0	1	202	1428	1629	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	808	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
22090594	22090594	PRJNA400391_S_NODE_6458_length_153_cov_2.152542_g6397_i0	PRJNA400391	6458	153	2.152542	3.29338926	Dolichospermum sp. DL01	2717871	Bacteria	Bacteria	228	1.9399999999999995e-55	NTclustered	gi\|2004368895\|gb\|CP050884.1\|	2717871	g6397	i0	93.464	255.117647058824	153	10	100	0	1	153	980050	980202	MAG: Dolichospermum sp. DL01 chromosome, complete genome	blastn	39033	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. DL01
22757952	22757952	PRJNA400391_S_NODE_1178_length_339_cov_2.878289_g1117_i0	PRJNA400391	1178	339	2.878289	9.75739971	Alkalinema	1620700	Bacteria	Bacteria	333	1.02e-86	NTclustered	gi\|2067595960\|gb\|MZ567048.1\|	2859775	g1117	i0	89.961	157.52802359882	259	25	76	1	1	259	2003	2260	Alkalinema pantanalense DHCY212 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53402	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema pantanalense
24640515	24640515	PRJNA400391_S_NODE_640_length_416_cov_19.721785_g580_i0	PRJNA400391	640	416	19.721785	82.0426256	Chamaesiphon minutus	1173032	Bacteria	Bacteria	614	4.069999999999999e-171	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g580	i0	93.462	219.139423076923	413	27	99	0	4	416	1096	684	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	91162	614	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
24640516	24640516	PRJNA400391_S_NODE_6580_length_151_cov_3.137931_g6519_i0	PRJNA400391	6580	151	3.137931	4.73827581	Synechococcus elongatus	32046	Bacteria	Bacteria	183	4.19e-42	NTclustered	gi\|1540602723\|gb\|CP033061.1\|	2479200	g6519	i0	88.742	103.172185430464	151	16	100	1	1	151	499876	499727	Synechococcus elongatus UTEX 3055 chromosome, complete genome	blastn	15579	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
25307234	25307234	PRJNA400391_S_NODE_6640_length_150_cov_68.565217_g6579_i0	PRJNA400391	6640	150	68.565217	102.8478255	root	1	Root_unresolved	Root_unresolved	272	8.609999999999998e-69	NTclustered	gi\|184190761\|gb\|EU642239.1\|	1211	g6579	i0	99.333	100.006666666667	150	1	100	0	1	150	550	699	Uncultured cyanobacterium clone LW18m-1-76 16S ribosomal RNA gene, partial sequence	blastn	15001	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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