metadata: contig_metadata: 36 rows where analysis = "blastn", bioproject = "PRJEB65329" and tax

36 rows where analysis = "blastn", bioproject = "PRJEB65329" and tax_superkingdom = "Bacteria"

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
2269156	2269156	PRJEB65329_S_NODE_8962_length_235_cov_3.383495_g8800_i0	PRJEB65329	8962	235	3.383495	7.95121325	Streptomycetaceae	2062	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1399240079\|gb\|CP029788.1\|	1885	g8800	i0	100	4.40851063829787	28	0	12	0	70	97	5092073	5092046	Streptomyces actuosus strain ATCC 25421 chromosome, complete genome	blastn	1036	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces actuosus
2680368	2680368	PRJEB65329_S_NODE_7423_length_268_cov_5.841004_g7261_i0	PRJEB65329	7423	268	5.841004	15.65389072	uncultured bacterium	77133	Bacteria	Bacteria	446	9.63e-121	NTclustered	gi\|931243133\|gb\|KT772034.1\|	77133	g7261	i0	96.642	121.507462686567	268	9	100	0	1	268	518	251	Uncultured bacterium clone GCSTWT_16S_3688 16S ribosomal RNA gene, partial sequence	blastn	32564	446	1	Bacteria								uncultured bacterium
4821986	4821986	PRJEB65329_S_NODE_9604_length_224_cov_5.876923_g9442_i0	PRJEB65329	9604	224	5.876923	13.16430752	Corynebacterium	1716	Bacteria	Bacteria	364	2.2499999999999993e-96	NTclustered	gi\|2443264930\|gb\|CP063195.1\|	38289	g9442	i0	95.982	431.620535714286	224	9	100	0	1	224	110827	111050	Corynebacterium jeikeium strain DSM 7171 chromosome, complete genome	blastn	96683	364	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium jeikeium
5232609	5232609	PRJEB65329_S_NODE_16845_length_158_cov_2.689922_g16683_i0	PRJEB65329	16845	158	2.689922	4.25007676	Protaetiibacter larvae	2592654	Bacteria	Bacteria	122	9.809999999999999e-24	NTclustered	gi\|1736209585\|gb\|CP043504.1\|	2592654	g16683	i0	84.553	68.2025316455696	123	19	78	0	28	150	544062	543940	Protaetiibacter larvae strain KACC 19322 chromosome, complete genome	blastn	10776	122	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Protaetiibacter	Protaetiibacter larvae
5232763	5232763	PRJEB65329_S_NODE_6325_length_302_cov_3.087912_g6163_i0	PRJEB65329	6325	302	3.087912	9.32549424	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g6163	i0	96.97	0.109271523178808	33	1	11	0	3	35	1389605	1389637	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6097075	6097075	PRJEB65329_S_NODE_17805_length_153_cov_4.733871_g17643_i0	PRJEB65329	17805	153	4.733871	7.24282263	root	1	Root_unresolved	Root_unresolved	283	4.0799999999999995e-72	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g17643	i0	100	55.5751633986928	153	0	100	0	1	153	2681137	2681289	Staphylococcus aureus strain WH3018 chromosome	blastn	8503	283	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
7371412	7371412	PRJEB65329_S_NODE_17866_length_153_cov_2.822581_g17704_i0	PRJEB65329	17866	153	2.822581	4.31854893	root	1	Root_unresolved	Root_unresolved	182	1.53e-41	NTclustered	gi\|2622025017\|gb\|CP138515.1\|	34073	g17704	i0	99.01	126.02614379085	101	1	66	0	1	101	5059574	5059474	Variovorax paradoxus strain 2u118 chromosome, complete genome	blastn	19282	182	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
7782381	7782381	PRJEB65329_S_NODE_12327_length_191_cov_2.339506_g12165_i0	PRJEB65329	12327	191	2.339506	4.46845646	Pseudolabrys sp. FHR47	2562284	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1633220606\|gb\|CP039740.1\|	2562284	g12165	i0	100	0.151832460732984	29	0	15	0	13	41	535520	535492	Pseudolabrys sp. FHR47 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Xanthobacteraceae	Pseudolabrys	Pseudolabrys sp. FHR47
8647006	8647006	PRJEB65329_S_NODE_4767_length_383_cov_7.228814_g4605_i0	PRJEB65329	4767	383	7.228814	27.68635762	Cutibacterium	1912216	Bacteria	Bacteria	520	8.33e-143	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4605	i0	96.519	212.997389033943	316	7	82	4	1	314	55360	55673	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	81578	520	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10333106	10333106	PRJEB65329_S_NODE_17729_length_154_cov_2.072000_g17567_i0	PRJEB65329	17729	154	2.072	3.19088	Streptomyces hygroscopicus	1912	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2209700036\|dbj\|AP025668.1\|	1912	g17567	i0	100	0.181818181818182	28	0	18	0	120	147	5180060	5180033	Streptomyces hygroscopicus HOK021 DNA, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
10333115	10333115	PRJEB65329_S_NODE_18149_length_152_cov_2.292683_g17987_i0	PRJEB65329	18149	152	2.292683	3.48487816	Bdellovibrio sp. KM01	2748865	Bacteria	Bacteria	62.1	2.06e-5	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g17987	i0	97.297	6.65789473684211	37	0	24	1	3	38	248784	248748	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	1012	62.1	1	Bacteria		Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
11197232	11197232	PRJEB65329_S_NODE_13209_length_182_cov_4.666667_g13047_i0	PRJEB65329	13209	182	4.666667	8.49333394	Methylibium	316612	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|124257968\|gb\|CP000555.1\|	420662	g13047	i0	100	242.087912087912	182	0	100	0	1	182	355010	355191	Methylibium petroleiphilum PM1, complete genome	blastn	44060	337	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Methylibium	Methylibium petroleiphilum
11197244	11197244	PRJEB65329_S_NODE_1849_length_740_cov_5.890295_g536_i2	PRJEB65329	1849	740	5.890295	43.588183	Cutibacterium	1912216	Bacteria	Bacteria	1245	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g536	i2	97.027	281.868918918919	740	22	100	0	1	740	608304	609043	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	208583	1245	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11197265	11197265	PRJEB65329_S_NODE_569_length_1251_cov_6.440262_g536_i0	PRJEB65329	569	1251	6.440262	80.56767762	Cutibacterium	1912216	Bacteria	Bacteria	2296	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g536	i0	99.84	276.338129496403	1249	2	99	0	1	1249	609043	607795	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	345699	2296	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11608522	11608522	PRJEB65329_S_NODE_12270_length_191_cov_3.351852_g12108_i0	PRJEB65329	12270	191	3.351852	6.40203732	Undibacterium sp. CCC3.4	3048609	Bacteria	Bacteria	342	8.699999999999999e-90	NTclustered	gi\|2634174434\|gb\|CP133779.1\|	3048609	g12108	i0	98.953	489.523560209424	191	2	100	0	1	191	1461634	1461444	Undibacterium sp. CCC3.4 chromosome, complete genome	blastn	93499	342	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. CCC3.4
11608589	11608589	PRJEB65329_S_NODE_16810_length_158_cov_3.333333_g16648_i0	PRJEB65329	16810	158	3.333333	5.26666614	uncultured delta proteobacterium	34034	Bacteria	Bacteria	58.4	2.81e-4	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g16648	i0	100	0.19620253164557	31	0	20	0	98	128	3349854	3349884	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	delta/epsilon subdivisions			Deltaproteobacteria				uncultured delta proteobacterium
12472852	12472852	PRJEB65329_S_NODE_12730_length_187_cov_2.322785_g12568_i0	PRJEB65329	12730	187	2.322785	4.34360795	Pseudomonas	286	Bacteria	Bacteria	344	2.36e-90	NTclustered	gi\|1190795207\|gb\|KX456245.1\|	114707	g12568	i0	100	135.96256684492	186	0	99	0	1	186	47	232	Uncultured Pseudomonas sp. clone F52 16S ribosomal RNA gene, partial sequence	blastn	25425	344	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	uncultured Pseudomonas sp.
12472859	12472859	PRJEB65329_S_NODE_14810_length_170_cov_3.000000_g14648_i0	PRJEB65329	14810	170	3	5.1	Geobacter	28231	Bacteria	Bacteria	174	2.91e-39	NTclustered	gi\|2891482044\|emb\|OZ219795.1\|	1869227	g14648	i0	85.89	87.9294117647059	163	23	96	0	1	163	221596	221434	MAG: bacterium isolate 516e7cd1-1e5c-4c24-bddd-9676f9194ca4 genome assembly, chromosome: 4	blastn	14948	174	1	Bacteria								bacterium
13747362	13747362	PRJEB65329_S_NODE_5991_length_315_cov_13.821678_g5829_i0	PRJEB65329	5991	315	13.821678	43.5382857	Flavobacterium	237	Bacteria	Bacteria	566	8.519999999999997e-157	NTclustered	gi\|1205803233\|gb\|KX550334.1\|	239	g5829	i0	99.048	109.142857142857	315	3	100	0	1	315	298	612	Flavobacterium sp. strain FLA_E38 16S ribosomal RNA gene, partial sequence	blastn	34380	566	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
13747367	13747367	PRJEB65329_S_NODE_811_length_1082_cov_6.650522_g536_i1	PRJEB65329	811	1082	6.650522	71.95864804	Cutibacterium	1912216	Bacteria	Bacteria	1840	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g536	i1	97.415	277.462107208872	1083	22	99	6	1	1081	57410	56332	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	300214	1840	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14158447	14158447	PRJEB65329_S_NODE_14772_length_170_cov_4.787234_g14610_i0	PRJEB65329	14772	170	4.787234	8.1382978	Actinomadura madurae	1993	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2893341638\|gb\|CP083237.1\|	1993	g14610	i0	96.97	0.547058823529412	33	1	19	0	1	33	9641251	9641219	Actinomadura madurae strain ATCC 19425 chromosome, complete genome	blastn	93	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura madurae
15021811	15021811	PRJEB65329_S_NODE_6232_length_305_cov_3.539855_g6070_i0	PRJEB65329	6232	305	3.539855	10.79655775	Roseateles	93681	Bacteria	Bacteria	470	6.62e-128	NTclustered	gi\|121281912\|gb\|EF157669.1\|	417305	g6070	i0	96.797	307.832786885246	281	9	92	0	25	305	12280	12560	Uncultured beta proteobacterium CBNPD1 BAC clone 578 genomic sequence	blastn	93889	470	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria				uncultured beta proteobacterium CBNPD1 BAC clone 578
15021821	15021821	PRJEB65329_S_NODE_9112_length_232_cov_20.719212_g8950_i0	PRJEB65329	9112	232	20.719212	48.06857184	Enterobacteriaceae	543	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8950	i0	100	669.629310344828	232	0	100	0	1	232	186550	186319	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	155354	429	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
17571761	17571761	PRJEB65329_S_NODE_10894_length_206_cov_8.355932_g10732_i0	PRJEB65329	10894	206	8.355932	17.21321992	Oxalobacteraceae	75682	Bacteria	Bacteria	377	2.62e-100	NTclustered	gi\|482868669\|gb\|KC620609.1\|	77133	g10732	i0	100	99.0339805825243	204	0	99	0	1	204	144	347	Uncultured bacterium clone AMD-A27 16S ribosomal RNA gene, partial sequence	blastn	20401	377	1	Bacteria								uncultured bacterium
17571766	17571766	PRJEB65329_S_NODE_12554_length_188_cov_8.930818_g12392_i0	PRJEB65329	12554	188	8.930818	16.78993784	Corynebacterium	1716	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2182362215\|gb\|CP040520.1\|	1717	g12392	i0	100	125	188	0	100	0	1	188	2405045	2404858	Corynebacterium diphtheriae strain CD1040 chromosome, complete genome	blastn	23500	348	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium diphtheriae
17571781	17571781	PRJEB65329_S_NODE_16874_length_158_cov_2.434109_g16712_i0	PRJEB65329	16874	158	2.434109	3.84589222	Oceanospirillales	135619	Bacteria	Bacteria	254	3.3400000000000003e-63	NTclustered	gi\|470474812\|ref\|NR_076239.1\|	59754	g16712	i0	95.57	474.924050632911	158	7	100	0	1	158	723	880	Alcanivorax borkumensis strain SK2 23S ribosomal RNA gene, complete sequence	blastn	75038	254	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Alcanivoracaceae	Alcanivorax	Alcanivorax borkumensis
17981828	17981828	PRJEB65329_S_NODE_9055_length_233_cov_8.794118_g8893_i0	PRJEB65329	9055	233	8.794118	20.49029494	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|407954676\|dbj\|AB587853.1\|	159447	g8893	i0	100	100	233	0	100	0	1	233	305	73	Uncultured Corynebacterium sp. gene for 16S ribosomal RNA, partial sequence, clone: PT-E1	blastn	23300	431	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
20120461	20120461	PRJEB65329_S_NODE_16396_length_160_cov_11.137405_g16234_i0	PRJEB65329	16396	160	11.137405	17.819848	root	1	Root_unresolved	Root_unresolved	296	5.55e-76	NTclustered	gi\|846470100\|gb\|KP949338.1\|	77133	g16234	i0	100	100.4875	160	0	100	0	1	160	14	173	Uncultured bacterium clone I3Q1XXJ01BE7SF 16S ribosomal RNA gene, partial sequence	blastn	16078	296	1	Bacteria								uncultured bacterium
20120487	20120487	PRJEB65329_S_NODE_6796_length_286_cov_3.587549_g6634_i0	PRJEB65329	6796	286	3.587549	10.26039014	Corynebacterium	1716	Bacteria	Bacteria	496	1.02e-135	NTclustered	gi\|2443264930\|gb\|CP063195.1\|	38289	g6634	i0	97.902	435.636363636364	286	6	100	0	1	286	110192	110477	Corynebacterium jeikeium strain DSM 7171 chromosome, complete genome	blastn	124592	496	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium jeikeium
20531114	20531114	PRJEB65329_S_NODE_3697_length_469_cov_13.227273_g3538_i0	PRJEB65329	3697	469	13.227273	62.03591037	type II methanotrophic bacterium	36494	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2890168929\|dbj\|AP038939.1\|	36494	g3538	i0	100	0.123667377398721	29	0	6	0	233	261	2369312	2369340	Type II methanotrophic bacterium NpR20-75 DNA, complete genome	blastn	58	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylocystaceae		type II methanotrophic bacterium
21806910	21806910	PRJEB65329_S_NODE_3918_length_450_cov_6.648456_g3758_i0	PRJEB65329	3918	450	6.648456	29.918052	uncultured bacterium	77133	Bacteria	Bacteria	826	0	NTclustered	gi\|290681004\|gb\|GU484821.1\|	77133	g3758	i0	99.778	102.008888888889	450	1	100	0	1	450	45	494	Uncultured bacterium clone F1Q32TO05FQ2QS 16S ribosomal RNA gene, partial sequence	blastn	45904	826	1	Bacteria								uncultured bacterium
23082048	23082048	PRJEB65329_S_NODE_2799_length_582_cov_7.104882_g2659_i0	PRJEB65329	2799	582	7.104882	41.35041324	bacterium	1869227	Bacteria	Bacteria	102	5.63e-17	NTclustered	gi\|2921906069\|gb\|CP182804.1\|	1869227	g2659	i0	73.734	2.03951890034364	316	59	52	16	282	582	1505403	1505097	MAG: bacterium isolate amkv25 chromosome, complete genome	blastn	1187	102	1	Bacteria								bacterium
23946352	23946352	PRJEB65329_S_NODE_4699_length_388_cov_14.016713_g4537_i0	PRJEB65329	4699	388	14.016713	54.38484644	Enterobacteriaceae	543	Bacteria	Bacteria	713	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g4537	i0	100	684.345360824742	386	0	99	0	3	388	188191	188576	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	265526	713	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23946356	23946356	PRJEB65329_S_NODE_5559_length_336_cov_3.726384_g5397_i0	PRJEB65329	5559	336	3.726384	12.52065024	Cutibacterium	1912216	Bacteria	Bacteria	475	1.5899999999999995e-129	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g5397	i0	92.492	318.03869047619	333	23	99	2	1	331	609043	608711	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	106861	475	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25220019	25220019	PRJEB65329_S_NODE_17240_length_156_cov_2.700787_g17078_i0	PRJEB65329	17240	156	2.700787	4.21322772	Streptomyces	1883	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2655774549\|gb\|CP109243.1\|	1886	g17078	i0	100	10.0384615384615	29	0	19	0	74	102	5996893	5996921	Streptomyces albidoflavus strain NBC 01661 chromosome, complete genome	blastn	1566	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidoflavus
25220031	25220031	PRJEB65329_S_NODE_4780_length_382_cov_4.881020_g4618_i0	PRJEB65329	4780	382	4.88102	18.6454964	Flavobacterium	237	Bacteria	Bacteria	628	1.3199999999999998e-175	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g4618	i0	96.335	716.717277486911	382	14	100	0	1	382	2900484	2900103	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	273786	628	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis

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