metadata: contig_metadata: 37 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

37 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax_phylum = "Deinococcota"

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
1020303	1020303	PRJNA1104180_P_NODE_9261_length_327_cov_1.122047_g9119_i0	PRJNA1104180	9261	327	1.122047	3.66909369	Thermus	270	Bacteria	Bacteria	604	1.8799999999999993e-168	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g9119	i0	100	96.605504587156	327	0	100	0	1	327	220617	220943	Thermus thermophilus TF27 DNA, complete genome	blastn	31590	604	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
1486977	1486977	PRJNA1104180_P_NODE_16462_length_269_cov_1.806122_g16320_i0	PRJNA1104180	16462	269	1.806122	4.85846818	Thermus scotoductus	37636	Bacteria	Bacteria	473	4.439999999999999e-129	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g16320	i0	98.513	16.4312267657993	269	3	100	1	1	269	1540827	1541094	Thermus scotoductus SA-01, complete genome	blastn	4420	473	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
1487182	1487182	PRJNA1104180_P_NODE_6202_length_380_cov_2.117264_g6060_i0	PRJNA1104180	6202	380	2.117264	8.0456032	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	617	2.85e-172	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g6060	i0	95.052	61.8657894736842	384	14	100	2	1	380	1670742	1670360	Thermus sp. NEB1569 chromosome, complete genome	blastn	23509	617	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
2295786	2295786	PRJNA1104180_P_NODE_3102_length_504_cov_19.422274_g2961_i0	PRJNA1104180	3102	504	19.422274	97.88826096	Truepera	332248	Bacteria	Bacteria	647	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2961	i0	89.861	271.166666666667	503	51	99	0	2	504	509	7	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	136668	647	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
4848331	4848331	PRJNA1104180_P_NODE_24564_length_244_cov_0.900585_g24421_i0	PRJNA1104180	24564	244	0.900585	2.1974274	Truepera	332248	Bacteria	Bacteria	281	2.58e-71	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g24421	i0	88.136	4.48770491803279	236	28	97	0	1	236	1249592	1249827	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	1095	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
4848399	4848399	PRJNA1104180_P_NODE_904_length_910_cov_8.614098_g618_i1	PRJNA1104180	904	910	8.614098	78.3882918	Deinococcus	1298	Bacteria	Bacteria	1570	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g618	i1	97.807	238.513186813187	912	16	100	3	1	910	1454100	1455009	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	217047	1570	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
7398051	7398051	PRJNA1104180_P_NODE_18366_length_259_cov_1.655914_g18224_i0	PRJNA1104180	18366	259	1.655914	4.28881726	Deinococcus	1298	Bacteria	Bacteria	473	4.25e-129	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g18224	i0	99.614	67.3976833976834	259	1	100	0	1	259	18679	18937	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	17456	473	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8673603	8673603	PRJNA1104180_P_NODE_927_length_895_cov_10.569343_g618_i3	PRJNA1104180	927	895	10.569343	94.59561985	Deinococcus	1298	Bacteria	Bacteria	1583	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g618	i3	99.884	238.900558659218	860	1	96	0	36	895	1454959	1454100	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	213816	1583	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
8673604	8673604	PRJNA1104180_P_NODE_9347_length_326_cov_0.913043_g9205_i0	PRJNA1104180	9347	326	0.913043	2.97652018	Thermus	270	Bacteria	Bacteria	603	6.749999999999998e-168	NTclustered	gi\|1352798305\|gb\|CP020572.1\|	271	g9205	i0	100	48.0122699386503	326	0	100	0	1	326	34208	34533	Thermus aquaticus strain YT-1 plasmid p61, complete sequence	blastn	15652	603	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
9139887	9139887	PRJNA1104180_P_NODE_16648_length_268_cov_2.010256_g16506_i0	PRJNA1104180	16648	268	2.010256	5.38748608	Deinococcus aetherius	200252	Bacteria	Bacteria	412	9.77e-111	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g16506	i0	94.403	86.0559701492537	268	15	100	0	1	268	2660916	2661183	Deinococcus aetherius ST0316 DNA, complete genome	blastn	23063	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
9948554	9948554	PRJNA1104180_P_NODE_7028_length_362_cov_1.065744_g6886_i0	PRJNA1104180	7028	362	1.065744	3.85799328	Thermus	270	Bacteria	Bacteria	664	0	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g6886	i0	99.724	29.7569060773481	362	1	100	0	1	362	1971740	1971379	Thermus scotoductus SA-01, complete genome	blastn	10772	664	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10415692	10415692	PRJNA1104180_P_NODE_15389_length_275_cov_1.648515_g15247_i0	PRJNA1104180	15389	275	1.648515	4.53341625	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	492	1.26e-134	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g15247	i0	98.909	11.76	275	3	100	0	1	275	814249	814523	Thermus sp. NEB1569 chromosome, complete genome	blastn	3234	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
10415786	10415786	PRJNA1104180_P_NODE_21089_length_250_cov_0.870056_g20946_i0	PRJNA1104180	21089	250	0.870056	2.17514	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	455	1.48e-123	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g20946	i0	99.598	44.936	249	1	99	0	1	249	679628	679876	Thermus sp. NEB1569 chromosome, complete genome	blastn	11234	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
11223693	11223693	PRJNA1104180_P_NODE_22249_length_248_cov_0.880000_g22106_i0	PRJNA1104180	22249	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g22106	i0	100	2	248	0	100	0	1	248	2083785	2083538	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	496	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
11223743	11223743	PRJNA1104180_P_NODE_3749_length_467_cov_11.647208_g3607_i0	PRJNA1104180	3749	467	11.647208	54.39246136	Truepera	332248	Bacteria	Bacteria	630	4.579999999999999e-176	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g3607	i0	91.026	607.511777301927	468	40	100	2	1	467	510	44	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	283708	630	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
11691033	11691033	PRJNA1104180_P_NODE_20050_length_251_cov_1.640449_g19907_i0	PRJNA1104180	20050	251	1.640449	4.11752699	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g19907	i0	99.602	2.89243027888446	251	1	100	0	1	251	1125546	1125296	Thermus sp. NEB1569 chromosome, complete genome	blastn	726	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
12499094	12499094	PRJNA1104180_P_NODE_17570_length_263_cov_2.647368_g17428_i0	PRJNA1104180	17570	263	2.647368	6.96257784	Thermus	270	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|1886401075\|gb\|CP053288.1\|	274	g17428	i0	99.62	286.562737642586	263	1	100	0	1	263	90389	90651	Thermus thermophilus strain HB27c plasmid pTT27, complete sequence	blastn	75366	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12966214	12966214	PRJNA1104180_P_NODE_22591_length_247_cov_0.885057_g22448_i0	PRJNA1104180	22591	247	0.885057	2.18609079	Thermus sp. PS18	2849039	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g22448	i0	99.595	2.98785425101215	247	1	100	0	1	247	684277	684523	Thermus sp. PS18 chromosome, complete genome	blastn	738	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
12966359	12966359	PRJNA1104180_P_NODE_7911_length_346_cov_1.432234_g7769_i0	PRJNA1104180	7911	346	1.432234	4.95552964	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	623	5.529999999999999e-174	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g7769	i0	99.133	44.8757225433526	346	3	100	0	1	346	1470308	1470653	Thermus sp. NEB1569 chromosome, complete genome	blastn	15527	623	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
15047901	15047901	PRJNA1104180_P_NODE_10732_length_310_cov_2.476793_g10590_i0	PRJNA1104180	10732	310	2.476793	7.6780583	Deinococcus	1298	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g10590	i0	100	4.54516129032258	150	0	97	0	161	310	2594140	2594289	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	1409	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
15514881	15514881	PRJNA1104180_P_NODE_14193_length_282_cov_1.382775_g14051_i0	PRJNA1104180	14193	282	1.382775	3.8994255	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	444	3.6699999999999996e-120	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g14051	i0	95.035	6.00354609929078	282	14	100	0	1	282	480120	480401	Thermus sp. NEB1569 chromosome, complete genome	blastn	1693	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
18871833	18871833	PRJNA1104180_P_NODE_15255_length_276_cov_1.394089_g15113_i0	PRJNA1104180	15255	276	1.394089	3.84768564	Thermus	270	Bacteria	Bacteria	455	1.66e-123	NTclustered	gi\|333967597\|gb\|CP002778.1\|	762633	g15113	i0	96.377	13.036231884058	276	10	100	0	1	276	54471	54196	Thermus thermophilus SG0.5JP17-16 plasmid pTHTHE1601, complete sequence	blastn	3598	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
18871912	18871912	PRJNA1104180_P_NODE_28055_length_218_cov_8.434483_g27912_i0	PRJNA1104180	28055	218	8.434483	18.38717294	root	1	Root_unresolved	Root_unresolved	399	5.969999999999999e-107	NTclustered	gi\|161513486\|emb\|AM292065.1\|	1299	g27912	i0	100	102.95871559633	216	0	99	0	1	216	478	693	Deinococcus radiodurans partial 16S rRNA gene, isolate zf-69-II	blastn	22445	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
19338085	19338085	PRJNA1104180_P_NODE_14556_length_280_cov_1.280193_g14414_i0	PRJNA1104180	14556	280	1.280193	3.5845404	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g14414	i0	99.643	8.38928571428571	280	1	100	0	1	280	352482	352203	Thermus sp. NEB1569 chromosome, complete genome	blastn	2349	512	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
19338280	19338280	PRJNA1104180_P_NODE_26796_length_239_cov_2.632530_g26653_i0	PRJNA1104180	26796	239	2.63253	6.2917467	Thermus scotoductus	37636	Bacteria	Bacteria	401	1.8499999999999992e-107	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g26653	i0	97.059	7.76150627615063	238	7	99	0	1	238	801331	801568	Thermus scotoductus SA-01, complete genome	blastn	1855	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
19338330	19338330	PRJNA1104180_P_NODE_5636_length_395_cov_2.478261_g5494_i0	PRJNA1104180	5636	395	2.478261	9.78913095	Thermus scotoductus	37636	Bacteria	Bacteria	686	0	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g5494	i0	97.975	41.9544303797468	395	8	100	0	1	395	1936422	1936028	Thermus scotoductus SA-01, complete genome	blastn	16572	686	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
20613404	20613404	PRJNA1104180_P_NODE_12197_length_295_cov_1.378378_g12055_i0	PRJNA1104180	12197	295	1.378378	4.0662151	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g12055	i0	100	10.0101694915254	295	0	100	0	1	295	1211431	1211725	Thermus sp. NEB1569 chromosome, complete genome	blastn	2953	545	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
20613638	20613638	PRJNA1104180_P_NODE_4797_length_421_cov_2.462644_g4655_i0	PRJNA1104180	4797	421	2.462644	10.36773124	Deinococcus aetherius	200252	Bacteria	Bacteria	545	1.53e-150	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g4655	i0	91.041	420.729216152019	413	23	97	13	15	421	822807	823211	Deinococcus aetherius ST0316 DNA, complete genome	blastn	177127	545	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21422209	21422209	PRJNA1104180_P_NODE_10697_length_310_cov_2.725738_g10555_i0	PRJNA1104180	10697	310	2.725738	8.4497878	Thermus	270	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g10555	i0	100	1.93548387096774	150	0	97	0	1	150	1847304	1847453	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	600	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
21422393	21422393	PRJNA1104180_P_NODE_717_length_1017_cov_9.425847_g618_i0	PRJNA1104180	717	1017	9.425847	95.86086399	Deinococcus	1298	Bacteria	Bacteria	1663	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g618	i0	96.184	278.375614552606	1022	29	100	8	1	1017	1454692	1453676	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	283108	1663	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
21422419	21422419	PRJNA1104180_P_NODE_917_length_900_cov_9.120919_g618_i2	PRJNA1104180	917	900	9.120919	82.088271	Deinococcus	1298	Bacteria	Bacteria	1452	0	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g618	i2	95.787	276.253333333333	902	34	100	4	1	900	1454692	1453793	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	248628	1452	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
21889199	21889199	PRJNA1104180_P_NODE_24138_length_244_cov_2.970760_g23995_i0	PRJNA1104180	24138	244	2.97076	7.2486544	Deinococcus aetherius	200252	Bacteria	Bacteria	219	2.05e-52	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g23995	i0	83.133	1.02049180327869	249	32	100	8	1	244	1810259	1810502	Deinococcus aetherius ST0316 DNA, complete genome	blastn	249	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
22697317	22697317	PRJNA1104180_P_NODE_558_length_1154_cov_6.919519_g470_i0	PRJNA1104180	558	1154	6.919519	79.85124926	Truepera	332248	Bacteria	Bacteria	1485	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g470	i0	89.805	305.51733102253	1177	95	100	14	1	1154	727	1901	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	352567	1489	0.997313633310947	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
23164751	23164751	PRJNA1104180_P_NODE_4399_length_438_cov_1.249315_g4257_i0	PRJNA1104180	4399	438	1.249315	5.4719997	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	754	0	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g4257	i0	97.717	17.0936073059361	438	10	100	0	1	438	1611122	1610685	Thermus sp. NEB1569 chromosome, complete genome	blastn	7487	754	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
23972572	23972572	PRJNA1104180_P_NODE_1979_length_615_cov_6.188192_g1838_i0	PRJNA1104180	1979	615	6.188192	38.0573808	Deinococcus	1298	Bacteria	Bacteria	715	0	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g1838	i0	90.459	235.964227642276	545	48	88	4	74	615	97357	97900	Deinococcus sp. AJ005 chromosome, complete genome	blastn	145118	717	0.99721059972106	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
24438178	24438178	PRJNA1104180_P_NODE_15100_length_277_cov_1.176471_g14958_i0	PRJNA1104180	15100	277	1.176471	3.25882467	Deinococcus aetherius	200252	Bacteria	Bacteria	394	3.68e-105	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g14958	i0	92.391	51.8050541516245	276	21	99	0	1	276	506356	506081	Deinococcus aetherius ST0316 DNA, complete genome	blastn	14350	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
25246644	25246644	PRJNA1104180_P_NODE_20080_length_251_cov_1.348315_g19937_i0	PRJNA1104180	20080	251	1.348315	3.38427065	Deinococcus	1298	Bacteria	Bacteria	198	2.76e-46	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g19937	i0	81.405	11.593625498008	242	45	96	0	1	242	1592021	1591780	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	2910	200	0.99	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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