metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax_phylum = "Verrucomicrobiota"

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
230588	230588	PRJNA1118794_P_NODE_31801_length_287_cov_2.023364_g31051_i0	PRJNA1118794	31801	287	2.023364	5.80705468	Pedosphaera parvula	1032527	Bacteria	Bacteria	233	8.829999999999999e-57	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g31051	i0	82.27	101.271777003484	282	38	95	11	6	277	302	23	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	29065	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
230805	230805	PRJNA1118794_P_NODE_48981_length_251_cov_0.865169_g48231_i0	PRJNA1118794	48981	251	0.865169	2.17157419	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	265	2.68e-66	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g48231	i0	87.083	54.2669322709163	240	24	94	6	15	251	1704939	1704704	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	13621	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
230972	230972	PRJNA1118794_P_NODE_63041_length_245_cov_0.895349_g62291_i0	PRJNA1118794	63041	245	0.895349	2.19360505	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	263	9.38e-66	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g62291	i0	90.148	3	203	18	82	2	1	202	308802	308601	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	735	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
1505088	1505088	PRJNA1118794_P_NODE_11042_length_428_cov_1.002817_g10294_i0	PRJNA1118794	11042	428	1.002817	4.29205676	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	579	1.53e-160	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10294	i0	91.121	106.672897196262	428	36	99	2	2	428	1315370	1314944	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	45656	579	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1505138	1505138	PRJNA1118794_P_NODE_14782_length_378_cov_1.996721_g14032_i0	PRJNA1118794	14782	378	1.996721	7.54760538	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	693	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g14032	i0	99.735	284.952380952381	378	1	100	0	1	378	1356	979	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	107712	693	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2781026	2781026	PRJNA1118794_P_NODE_21643_length_329_cov_2.660156_g20893_i0	PRJNA1118794	21643	329	2.660156	8.75191324	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	603	6.819999999999999e-168	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g20893	i0	99.697	198.151975683891	330	0	100	1	1	329	1817	1488	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65192	603	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2781080	2781080	PRJNA1118794_P_NODE_26203_length_308_cov_1.476596_g25453_i0	PRJNA1118794	26203	308	1.476596	4.54791568	Chthoniobacter flavus	191863	Bacteria	Bacteria	442	1.4599999999999994e-119	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g25453	i0	92.787	169.896103896104	305	22	99	0	4	308	1011	707	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	52328	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
4057240	4057240	PRJNA1118794_P_NODE_1804_length_1088_cov_3.335961_g1280_i0	PRJNA1118794	1804	1088	3.335961	36.29525568	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	1541	0	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g1280	i0	92.294	88.2977941176471	1090	77	100	6	1	1088	1405444	1404360	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	96068	1541	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
5333486	5333486	PRJNA1118794_P_NODE_21665_length_329_cov_2.085938_g20915_i0	PRJNA1118794	21665	329	2.085938	6.86273602	Chthoniobacter flavus	191863	Bacteria	Bacteria	459	1.56e-124	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g20915	i0	91.916	186.349544072948	334	17	100	8	1	329	1186	1514	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	61309	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
7883524	7883524	PRJNA1118794_P_NODE_30547_length_290_cov_2.419355_g29797_i0	PRJNA1118794	30547	290	2.419355	7.0161295	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	520	6.119999999999998e-143	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g29797	i0	98.966	178.731034482759	290	3	100	0	1	290	513	802	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	51832	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
7883667	7883667	PRJNA1118794_P_NODE_42567_length_263_cov_1.510526_g41817_i0	PRJNA1118794	42567	263	1.510526	3.97268338	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	387	5.79e-103	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g41817	i0	93.156	117.228136882129	263	18	100	0	1	263	15685	15423	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	30831	387	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
7883706	7883706	PRJNA1118794_P_NODE_45767_length_256_cov_1.759563_g45017_i0	PRJNA1118794	45767	256	1.759563	4.50448128	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	385	2.02e-102	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g45017	i0	93.75	144.578125	256	16	100	0	1	256	3048706	3048451	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	37012	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
8678116	8678116	PRJNA1118794_P_NODE_2027_length_1026_cov_3.000000_g1467_i0	PRJNA1118794	2027	1026	3	30.78	Opitutus	178440	Bacteria	Bacteria	1531	0	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g1467	i0	93.702	474.221247563353	1032	50	99	13	1	1024	10	1034	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	486551	1531	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
9158382	9158382	PRJNA1118794_P_NODE_32588_length_285_cov_2.863208_g31838_i0	PRJNA1118794	32588	285	2.863208	8.1601428	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	464	2.85e-126	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g31838	i0	96.14	275.568421052632	285	10	100	1	1	285	17305	17588	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	78537	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9158416	9158416	PRJNA1118794_P_NODE_35008_length_280_cov_1.144928_g34258_i0	PRJNA1118794	35008	280	1.144928	3.2057984	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g34258	i0	99.643	264.707142857143	280	1	100	0	1	280	2644	2365	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	74118	512	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11228302	11228302	PRJNA1118794_P_NODE_34329_length_281_cov_1.740385_g33579_i0	PRJNA1118794	34329	281	1.740385	4.89048185	Verrucomicrobiota	74201	Bacteria	Bacteria	281	3.04e-71	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g33579	i0	86.09	212.836298932384	266	32	93	4	20	281	2825	2561	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	59807	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
12503754	12503754	PRJNA1118794_P_NODE_13930_length_387_cov_2.901274_g13180_i0	PRJNA1118794	13930	387	2.901274	11.22793038	Opitutaceae	134623	Bacteria	Bacteria	610	4.8599999999999996e-170	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g13180	i0	95.337	103.395348837209	386	15	99	3	1	385	2556184	2556567	Lacunisphaera limnophila strain IG16b, complete genome	blastn	40014	610	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
12984347	12984347	PRJNA1118794_P_NODE_24391_length_316_cov_0.995885_g23641_i0	PRJNA1118794	24391	316	0.995885	3.1469966	Opitutus terrae	107709	Bacteria	Bacteria	285	2.6799999999999996e-72	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g23641	i0	83.758	0.993670886075949	314	37	96	11	3	306	4393555	4393246	Opitutus terrae PB90-1, complete genome	blastn	314	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
12984427	12984427	PRJNA1118794_P_NODE_31371_length_288_cov_3.567442_g30621_i0	PRJNA1118794	31371	288	3.567442	10.27423296	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	520	6.079999999999999e-143	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g30621	i0	99.303	271.475694444444	287	2	99	0	1	287	2412	2126	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	78185	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12984449	12984449	PRJNA1118794_P_NODE_33431_length_283_cov_2.338095_g32681_i0	PRJNA1118794	33431	283	2.338095	6.61680885	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	433	7.98e-117	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g32681	i0	94.346	155.226148409894	283	15	99	1	1	282	2169787	2169505	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	43929	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13778264	13778264	PRJNA1118794_P_NODE_3111_length_823_cov_2.765333_g2436_i0	PRJNA1118794	3111	823	2.765333	22.75869059	Chthoniobacter	295577	Bacteria	Bacteria	1349	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g2436	i0	96.242	225.565006075334	825	28	100	3	1	823	15380	16203	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	185640	1360	0.991911764705882	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14259522	14259522	PRJNA1118794_P_NODE_25912_length_309_cov_3.220339_g25162_i0	PRJNA1118794	25912	309	3.220339	9.95084751	Chthoniobacter sp.	2510640	Bacteria	Bacteria	538	1.8199999999999993e-148	NTclustered	gi\|2552712967\|gb\|OR350667.1\|	2510640	g25162	i0	98.366	99.0938511326861	306	5	99	0	1	306	85	390	Chthoniobacter sp. strain ag1_sv2_13B 16S ribosomal RNA gene, partial sequence	blastn	30620	538	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
15052502	15052502	PRJNA1118794_P_NODE_10312_length_440_cov_1.907357_g9564_i0	PRJNA1118794	10312	440	1.907357	8.3923708	Opitutus	178440	Bacteria	Bacteria	547	4.449999999999999e-151	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g9564	i0	89.189	117.834090909091	444	40	100	7	1	440	532	93	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	51847	547	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
15533263	15533263	PRJNA1118794_P_NODE_34613_length_281_cov_1.110577_g33863_i0	PRJNA1118794	34613	281	1.110577	3.12072137	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	329	1.07e-85	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g33863	i0	88.172	2.96797153024911	279	30	99	3	5	281	1683452	1683729	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	834	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15533546	15533546	PRJNA1118794_P_NODE_57513_length_247_cov_1.735632_g56763_i0	PRJNA1118794	57513	247	1.735632	4.28701104	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	300	7.22e-77	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g56763	i0	88.618	255.445344129555	246	28	99	0	2	247	3048813	3049058	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	63095	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
16807575	16807575	PRJNA1118794_P_NODE_21454_length_330_cov_4.638132_g20704_i0	PRJNA1118794	21454	330	4.638132	15.3058356	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	592	1.4799999999999996e-164	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g20704	i0	99.088	197.254545454545	329	3	99	0	2	330	516	188	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65094	592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
16807609	16807609	PRJNA1118794_P_NODE_24394_length_316_cov_0.975309_g23644_i0	PRJNA1118794	24394	316	0.975309	3.08197644	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	479	1.1499999999999999e-130	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g23644	i0	94.025	218.512658227848	318	15	100	3	1	316	1315739	1316054	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	69050	479	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16807800	16807800	PRJNA1118794_P_NODE_38794_length_271_cov_1.555556_g38044_i0	PRJNA1118794	38794	271	1.555556	4.21555676	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	403	5.96e-108	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g38044	i0	93.985	111.394833948339	266	16	98	0	1	266	1727969	1727704	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	30188	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18082521	18082521	PRJNA1118794_P_NODE_5215_length_618_cov_3.719266_g1467_i1	PRJNA1118794	5215	618	3.719266	22.98506388	Horticoccus luteus	2862869	Bacteria	Bacteria	817	0	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g1467	i1	90.747	540.042071197411	616	51	99	6	6	618	539899	539287	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	333746	817	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
19357033	19357033	PRJNA1118794_P_NODE_8276_length_489_cov_1.713942_g7533_i0	PRJNA1118794	8276	489	1.713942	8.38117638	Fontisphaera persica	2974023	Bacteria	Bacteria	455	3.11e-123	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g7533	i0	86.041	122.255623721881	437	46	87	9	1	423	3861873	3861438	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	59783	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
23182735	23182735	PRJNA1118794_P_NODE_23779_length_318_cov_2.469388_g23029_i0	PRJNA1118794	23779	318	2.469388	7.85265384	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	416	9.169999999999998e-112	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g23029	i0	90.282	235.433962264151	319	30	100	1	1	318	15878	15560	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	74868	416	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23977345	23977345	PRJNA1118794_P_NODE_6119_length_570_cov_1.223340_g5381_i0	PRJNA1118794	6119	570	1.22334	6.973038	Verrucomicrobiota	74201	Bacteria	Bacteria	339	3.8499999999999995e-88	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g5381	i0	77.759	63.759649122807	589	105	100	21	1	570	1655	1074	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	36343	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
24456879	24456879	PRJNA1118794_P_NODE_37080_length_275_cov_1.346535_g36330_i0	PRJNA1118794	37080	275	1.346535	3.70297125	Horticoccus luteus	2862869	Bacteria	Bacteria	283	8.229999999999999e-72	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g36330	i0	85.467	2.92363636363636	289	23	100	14	1	275	2448328	2448611	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	804	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus

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