metadata: contig_metadata: 32 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax

32 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax_phylum = "Cyanobacteriota"

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
22768869	22768869	PRJNA446034_S_NODE_44238_length_189_cov_1.256579_g44201_i0	PRJNA446034	44238	189	1.256579	2.37493431	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	120	4.89e-32	NR	MBW4638703.1	2839657	g44201	i0	98.3	0.952380952380952	60	1	95.2	0	187	8	140	199	MBW4638703.1 SDR family NAD(P)-dependent oxidoreductase [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	180	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
26664217	26664217	PRJNA446034_S_NODE_67741_length_171_cov_1.410448_g67704_i0	PRJNA446034	67741	171	1.410448	2.41186608	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	82.8	9.72e-19	NR	WP_009632921.1	927677	g67704	i0	95.8	0.842105263157895	48	2	84.2	0	27	170	1	48	WP_009632921.1 phage holin family protein [Synechocystis sp. PCC 7509]	diamond	144	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
26727420	26727420	PRJNA446034_S_NODE_33281_length_202_cov_1.387879_g33244_i0	PRJNA446034	33281	202	1.387879	2.80351558	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	63.5	8.45e-11	NR	MBW4638413.1	2839657	g33244	i0	100	0.49009900990099	33	0	49	0	102	200	1	33	MBW4638413.1 AbrB family transcriptional regulator [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	99	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
26791304	26791304	PRJNA446034_S_NODE_57321_length_178_cov_1.205674_g57284_i0	PRJNA446034	57321	178	1.205674	2.14609972	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	121	2.95e-30	NR	MBW4639861.1	2839657	g57284	i0	98.3	0.99438202247191	59	1	99.4	0	1	177	62	120	MBW4639861.1 PAS domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	177	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
27012695	27012695	PRJNA446034_S_NODE_29182_length_208_cov_1.333333_g29145_i0	PRJNA446034	29182	208	1.333333	2.77333264	Xenococcaceae cyanobacterium MO_188.B29	3036639	Bacteria	Bacteria	102	2.32e-23	NR	MDJ0633547.1	3036639	g29145	i0	71.9	0.923076923076923	64	17	90.9	1	1	189	281	344	MDJ0633547.1 NACHT domain-containing NTPase [Xenococcaceae cyanobacterium MO_188.B29]	diamond	192	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_188.B29
27076000	27076000	PRJNA446034_S_NODE_103442_length_154_cov_2.470085_g103405_i0	PRJNA446034	103442	154	2.470085	3.8039309	Calothrix rhizosoleniae	888997	Bacteria	Bacteria	57.4	1.82e-9	NR	WP_200817728.1	888997	g103405	i0	80	0.779220779220779	40	6	77.9	1	153	34	15	52	WP_200817728.1 hypothetical protein [Calothrix rhizosoleniae]	diamond	120	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix rhizosoleniae
27392246	27392246	PRJNA446034_S_NODE_116283_length_150_cov_1.345133_g116246_i0	PRJNA446034	116283	150	1.345133	2.0176995	Aliterella atlantica	1827278	Bacteria	Bacteria	75.1	3.66e-14	NR	WP_045057285.1	1827278	g116246	i0	90.2	0.82	41	4	82	0	26	148	1	41	WP_045057285.1 sensor histidine kinase [Aliterella atlantica]	diamond	123	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
27392259	27392259	PRJNA446034_S_NODE_44823_length_188_cov_3.390728_g44786_i0	PRJNA446034	44823	188	3.390728	6.37456864	Stigonema ocellatum	221293	Bacteria	Bacteria	57	1.39e-7	NR	MBR8832579.1	221294	g44786	i0	82.1	4.53191489361702	28	5	44.7	0	87	4	1	28	MBR8832579.1 alpha/beta hydrolase [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	852	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
27661129	27661129	PRJNA446034_S_NODE_105844_length_153_cov_3.034483_g105807_i0	PRJNA446034	105844	153	3.034483	4.64275899	Coleofasciculus	669368	Bacteria	Bacteria	52.4	4.25e-6	NR	MCA1991135.1	2876727	g105807	i0	49	5.70588235294118	49	25	96.1	0	5	151	714	762	MCA1991135.1 PAS domain S-box protein [Coleofasciculus sp. S288]	diamond	873	52.8	0.992424242424242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. S288
28150025	28150025	PRJNA446034_S_NODE_55965_length_179_cov_1.281690_g55928_i0	PRJNA446034	55965	179	1.28169	2.2942251	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	85.9	9.21e-19	NR	HCF26718.1	2055787	g55928	i0	66.1	0.988826815642458	59	20	98.9	0	1	177	160	218	HCF26718.1 hypothetical protein [Cyanobacteria bacterium UBA11049]	diamond	177	85.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
28339353	28339353	PRJNA446034_S_NODE_68286_length_170_cov_4.924812_g68249_i0	PRJNA446034	68286	170	4.924812	8.3721804	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	101	5.619999999999999e-24	NR	WP_106370080.1	2107693	g68249	i0	96.4	0.988235294117647	56	2	98.8	0	169	2	47	102	WP_106370080.1 phenylalanine--tRNA ligase subunit alpha [Chlorogloea sp. CCALA 695]	diamond	168	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28402478	28402478	PRJNA446034_S_NODE_34706_length_200_cov_1.631902_g34669_i0	PRJNA446034	34706	200	1.631902	3.263804	Aphanothece sp. CMT-3BRIN-NPC111	2839655	Bacteria	Bacteria	42.4	0.0269	NR	MBW4576709.1	2839655	g34669	i0	77.3	0.33	22	5	33	0	133	198	4	25	MBW4576709.1 Mut7-C ubiquitin/RNAse domain-containing protein [Aphanothece sp. CMT-3BRIN-NPC111]	diamond	66	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sp. CMT-3BRIN-NPC111
28545278	28545278	PRJNA446034_S_NODE_100747_length_155_cov_2.305085_g100710_i0	PRJNA446034	100747	155	2.305085	3.57288175	Nostocales	1161	Bacteria	Bacteria	100	2.25e-26	NR	WP_390625548.1	1177	g100710	i0	86.3	8.88387096774194	51	7	98.7	0	3	155	8	58	WP_390625548.1 MULTISPECIES: hypothetical protein [Nostoc]	diamond	1377	101	0.99009900990099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc
28655112	28655112	PRJNA446034_S_NODE_34987_length_199_cov_5.277778_g34950_i0	PRJNA446034	34987	199	5.277778	10.50277822	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	98.6	4.0799999999999996e-23	NR	WP_202807208.1	927677	g34950	i0	76.6	1.92964824120603	64	15	96.5	0	195	4	130	193	WP_202807208.1 IS5 family transposase [Synechocystis sp. PCC 7509]	diamond	384	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28860668	28860668	PRJNA446034_S_NODE_49408_length_184_cov_2.795918_g49371_i0	PRJNA446034	49408	184	2.795918	5.14448912	Cyanophyceae	3028117	Bacteria	Bacteria	107	1.03e-25	NR	WP_263744514.1	945768	g49371	i0	92.5	1.72826086956522	53	4	86.4	0	24	182	1	53	WP_263744514.1 glycosyltransferase family 4 protein [Plectonema radiosum]	diamond	318	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
29349767	29349767	PRJNA446034_S_NODE_109749_length_152_cov_1.643478_g109712_i0	PRJNA446034	109749	152	1.643478	2.49808656	Cyanobacteria bacterium SZAS LIN-2	2807731	Bacteria	Bacteria	58.5	2.72e-8	NR	MBS1999057.1	2807731	g109712	i0	58.1	0.848684210526316	43	18	84.9	0	5	133	310	352	MBS1999057.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-2]	diamond	129	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2
29475698	29475698	PRJNA446034_S_NODE_24870_length_215_cov_2.971910_g24833_i0	PRJNA446034	24870	215	2.97191	6.3896065	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	152	2.7599999999999998e-43	NR	MBW4639149.1	2839657	g24833	i0	98.6	0.990697674418605	71	1	99.1	0	214	2	91	161	MBW4639149.1 glycosyltransferase family 4 protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	213	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
29539049	29539049	PRJNA446034_S_NODE_9330_length_266_cov_9.419214_g9293_i0	PRJNA446034	9330	266	9.419214	25.05510924	Calothrix sp. HK-	1187	Bacteria	Bacteria	64.3	9.98e-10	NR	OKH45464.1	1137096	g9293	i0	78.9	1.71428571428571	38	8	42.9	0	115	2	2	39	OKH45464.1 glycosyl transferase family A [Calothrix sp. HK-06]	diamond	456	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. HK-06
30012992	30012992	PRJNA446034_S_NODE_97551_length_156_cov_3.554622_g97514_i0	PRJNA446034	97551	156	3.554622	5.54521032	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	94	2.19e-21	NR	MBW4637118.1	2839657	g97514	i0	96.1	0.980769230769231	51	2	98.1	0	3	155	213	263	MBW4637118.1 phosphate ABC transporter permease subunit PstC [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	153	94	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30107515	30107515	PRJNA446034_S_NODE_103452_length_154_cov_2.452991_g103415_i0	PRJNA446034	103452	154	2.452991	3.77760614	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	102	6.0699999999999986e-24	NR	MBW4640975.1	2839657	g103415	i0	94.1	0.993506493506494	51	3	99.4	0	154	2	28	78	MBW4640975.1 PDZ domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	153	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30170693	30170693	PRJNA446034_S_NODE_55612_length_179_cov_2.492958_g55575_i0	PRJNA446034	55612	179	2.492958	4.46239482	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	48.1	1.98e-4	NR	MBW4638282.1	2839657	g55575	i0	95.7	0.385474860335196	23	1	38.5	0	53	121	1	23	MBW4638282.1 methyl-accepting chemotaxis protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	69	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30644598	30644598	PRJNA446034_S_NODE_87933_length_160_cov_3.520325_g87896_i0	PRJNA446034	87933	160	3.520325	5.63252	Nostoc punctiforme	272131	Bacteria	Bacteria	77.4	6.24e-15	NR	WP_012413062.1	272131	g87896	i0	76.9	1.95	52	12	97.5	0	158	3	211	262	WP_012413062.1 IS701 family transposase [Nostoc punctiforme]	diamond	312	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
30992387	30992387	PRJNA446034_S_NODE_108534_length_152_cov_3.356522_g108497_i0	PRJNA446034	108534	152	3.356522	5.10191344	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	77.8	2.57e-15	NR	WP_250122994.1	155894	g108497	i0	69.4	0.967105263157895	49	15	96.7	0	150	4	184	232	WP_250122994.1 ChaN family lipoprotein [Chroococcidiopsis sp. CCMEE 29]	diamond	147	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
31213028	31213028	PRJNA446034_S_NODE_56535_length_178_cov_4.283688_g56498_i0	PRJNA446034	56535	178	4.283688	7.62496464	Scytonema millei	1245922	Bacteria	Bacteria	72.8	2.67e-13	NR	WP_039716083.1	1245922	g56498	i0	75.4	0.960674157303371	57	14	96.1	0	172	2	134	190	WP_039716083.1 hypothetical protein [Scytonema millei]	diamond	171	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema millei
31245064	31245064	PRJNA446034_S_NODE_78395_length_165_cov_1.468750_g78358_i0	PRJNA446034	78395	165	1.46875	2.4234375	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	92	2.8100000000000003e-21	NR	MBW4663393.1	2499659	g78358	i0	90.2	2.78181818181818	51	5	92.7	0	4	156	10	60	MBW4663393.1 aquaporin [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	459	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
31356416	31356416	PRJNA446034_S_NODE_21816_length_221_cov_4.668478_g21779_i0	PRJNA446034	21816	221	4.668478	10.31733638	Cyanophyceae	3028117	Bacteria	Bacteria	140	7.619999999999999e-38	NR	WP_263744300.1	945768	g21779	i0	97.3	4.95475113122172	73	2	99.1	0	1	219	31	103	WP_263744300.1 peptidoglycan-binding protein [Plectonema radiosum]	diamond	1095	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
32162619	32162619	PRJNA446034_S_NODE_95238_length_157_cov_2.916667_g95201_i0	PRJNA446034	95238	157	2.916667	4.57916719	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	61.6	2.42e-9	NR	MBW4639893.1	2839657	g95201	i0	96.7	1.14649681528662	30	1	57.3	0	92	3	1	30	MBW4639893.1 acetate--CoA ligase [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	180	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32320999	32320999	PRJNA446034_S_NODE_104799_length_153_cov_7.620690_g104762_i0	PRJNA446034	104799	153	7.62069	11.6596557	Aliterella atlantica	1827278	Bacteria	Bacteria	89	8.03e-20	NR	WP_045054931.1	1827278	g104762	i0	88	1.96078431372549	50	6	98	0	151	2	22	71	WP_045054931.1 class I SAM-dependent methyltransferase [Aliterella atlantica]	diamond	300	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32447481	32447481	PRJNA446034_S_NODE_559_length_532_cov_5.632323_g532_i0	PRJNA446034	559	532	5.632323	29.96395836	Fischerella sp.	1191	Bacteria	Bacteria	80.5	2.25e-16	NR	MCX7592427.1	1191	g532	i0	47.3	0.823308270676692	74	39	41.7	0	5	226	1	74	MCX7592427.1 glutaredoxin [Fischerella sp.]	diamond	438	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
32447488	32447488	PRJNA446034_S_NODE_74599_length_167_cov_1.500000_g74562_i0	PRJNA446034	74599	167	1.5	2.505	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	92.4	3.4e-20	NR	WP_015188183.1	1173026	g74562	i0	79.6	1.94011976047904	54	11	97	0	164	3	207	260	WP_015188183.1 aspartate ammonia-lyase [Gloeocapsa sp. PCC 7428]	diamond	324	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
32558705	32558705	PRJNA446034_S_NODE_95359_length_157_cov_2.683333_g95322_i0	PRJNA446034	95359	157	2.683333	4.21283281	Cyanophyceae	3028117	Bacteria	Bacteria	84.3	8.12e-18	NR	WP_190487569.1	2692827	g95322	i0	76.9	12.8789808917197	52	12	99.4	0	1	156	52	103	WP_190487569.1 ABC transporter permease [Microcoleus sp. FACHB-831]	diamond	2022	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
32684285	32684285	PRJNA446034_S_NODE_22920_length_219_cov_2.401099_g22883_i0	PRJNA446034	22920	219	2.401099	5.25840681	Cyanophyceae	3028117	Bacteria	Bacteria	69.3	5.89e-13	NR	NJM76362.1	2720443	g22883	i0	56.7	2.23287671232877	60	21	75.3	1	1	165	71	130	NJM76362.1 general secretion pathway protein GspF [Acaryochloridaceae cyanobacterium RU_4_10]	diamond	489	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium RU_4_10

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