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

36 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax_phylum = "Bacillota"

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
395260	395260	PRJNA352850_P_NODE_27721_length_516_cov_5.074946_g24897_i0	PRJNA352850	27721	516	5.074946	26.18672136	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	953	0	NTclustered	gi\|2851146212\|gb\|CP085027.1\|	1283	g24897	i0	100	99.75	516	0	100	0	1	516	2263027	2263542	Staphylococcus haemolyticus strain SLM-175 chromosome, complete genome	blastn	51471	953	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
1671548	1671548	PRJNA352850_P_NODE_80922_length_248_cov_1.045226_g78089_i0	PRJNA352850	80922	248	1.045226	2.59216048	Kineothrix sp. MB12-C1	3070215	Bacteria	Bacteria	381	2.519999999999999e-101	NTclustered	gi\|2567103984\|gb\|CP132957.1\|	3070215	g78089	i0	94.758	386.379032258065	248	8	100	5	1	248	1154629	1154387	Kineothrix sp. MB12-C1 chromosome, complete genome	blastn	95822	381	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Kineothrix	Kineothrix sp. MB12-C1
2347125	2347125	PRJNA352850_P_NODE_77762_length_253_cov_8.338235_g74929_i0	PRJNA352850	77762	253	8.338235	21.09573455	Paenibacillus	44249	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g74929	i0	100	941.490118577075	253	0	100	0	1	253	16594	16846	Paenibacillus sp. FSL R5-0345, complete genome	blastn	238197	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
3622549	3622549	PRJNA352850_P_NODE_87023_length_216_cov_26.497006_g84190_i0	PRJNA352850	87023	216	26.497006	57.23353296	Lactococcus	1357	Bacteria	Bacteria	230	8.199999999999998e-56	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g84190	i0	97.059	62.5787037037037	136	4	63	0	45	180	379460	379325	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	13517	230	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
4899224	4899224	PRJNA352850_P_NODE_48744_length_347_cov_4.073826_g45911_i0	PRJNA352850	48744	347	4.073826	14.13617622	Paenibacillus	44249	Bacteria	Bacteria	636	7.13e-178	NTclustered	gi\|686561105\|gb\|CP009428.1\|	189426	g45911	i0	99.712	1031.19884726225	347	1	100	0	1	347	6130580	6130926	Paenibacillus odorifer strain DSM 15391, complete genome	blastn	357826	636	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus odorifer
4899356	4899356	PRJNA352850_P_NODE_56884_length_311_cov_3.125954_g54051_i0	PRJNA352850	56884	311	3.125954	9.72171694	root	1	Root_unresolved	Root_unresolved	52.8	0.029	NTclustered	gi\|1334413695\|gb\|CP021850.1\|	84032	g54051	i0	100	0.180064308681672	28	0	9	0	22	49	4361112	4361139	Clostridium thermosuccinogenes strain DSM 5807 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium thermosuccinogenes
4899531	4899531	PRJNA352850_P_NODE_68124_length_273_cov_2.718750_g65291_i0	PRJNA352850	68124	273	2.71875	7.4221875	Clostridium	1485	Bacteria	Bacteria	180	1.1e-40	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g65291	i0	79.231	87.4908424908425	260	53	95	1	15	273	3872630	3872889	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	23885	180	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
4899631	4899631	PRJNA352850_P_NODE_74364_length_260_cov_0.966825_g71531_i0	PRJNA352850	74364	260	0.966825	2.513745	Bacilli	91061	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2640416598\|gb\|CP140880.1\|	1254	g71531	i0	100	111.3	260	0	100	0	1	260	3232	2973	Pediococcus acidilactici strain AF2519 extrachromosomal element, complete sequene	blastn	28938	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus acidilactici
4899750	4899750	PRJNA352850_P_NODE_83664_length_243_cov_1.690722_g80831_i0	PRJNA352850	83664	243	1.690722	4.10845446	Streptococcus	1301	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g80831	i0	100	337.078189300412	243	0	100	0	1	243	141004	141246	Streptococcus infantis strain SO chromosome, complete genome	blastn	81910	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
6173785	6173785	PRJNA352850_P_NODE_18825_length_679_cov_6.409524_g16092_i0	PRJNA352850	18825	679	6.409524	43.52066796	Staphylococcus	1279	Bacteria	Bacteria	1210	0	NTclustered	gi\|1785980122\|gb\|CP043847.1\|	1282	g16092	i0	98.822	545.821796759941	679	8	100	0	1	679	1315892	1316570	Staphylococcus epidermidis strain NCCP 16828 chromosome, complete genome	blastn	370613	1210	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7448946	7448946	PRJNA352850_P_NODE_26966_length_526_cov_2.740042_g24143_i0	PRJNA352850	26966	526	2.740042	14.41262092	Streptococcus	1301	Bacteria	Bacteria	773	0	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g24143	i0	93.346	335.996197718631	526	29	99	5	4	526	423978	424500	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	176734	778	0.993573264781491	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
7449081	7449081	PRJNA352850_P_NODE_35146_length_437_cov_3.048969_g32315_i0	PRJNA352850	35146	437	3.048969	13.32399453	Streptococcus	1301	Bacteria	Bacteria	808	0	NTclustered	gi\|1578244976\|emb\|LR216052.1\|	1313	g32315	i0	100	100	437	0	100	0	1	437	1631541	1631977	Streptococcus pneumoniae strain 2245STDY6106751 genome assembly, chromosome: 1	blastn	43700	808	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
7449532	7449532	PRJNA352850_P_NODE_66766_length_277_cov_4.530702_g63933_i0	PRJNA352850	66766	277	4.530702	12.55004454	Staphylococcus	1279	Bacteria	Bacteria	501	2.11e-137	NTclustered	gi\|254803147\|gb\|GQ222240.1\|	1288	g63933	i0	99.278	122	277	2	100	0	1	277	358	82	Staphylococcus xylosus strain 741 16S ribosomal RNA gene, partial sequence	blastn	33794	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
7449656	7449656	PRJNA352850_P_NODE_76686_length_255_cov_2.980583_g73853_i0	PRJNA352850	76686	255	2.980583	7.60048665	Finegoldia	150022	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g73853	i0	100	346.360784313726	255	0	100	0	1	255	163762	164016	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	88322	472	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
8048059	8048059	PRJNA352850_P_NODE_14347_length_828_cov_5.365854_g11768_i0	PRJNA352850	14347	828	5.365854	44.42927112	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006	3077584	Bacteria	Bacteria	1269	0	NTclustered	gi\|2587845447\|gb\|CP135436.1\|	3077584	g11768	i0	94.324	100.080917874396	828	47	100	0	1	828	561152	560325	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006 chromosome, complete genome	blastn	82867	1269	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. DTU_2020_1001019_1_SI_AUS_MUR_006
8049820	8049820	PRJNA352850_P_NODE_71807_length_265_cov_0.944444_g68974_i0	PRJNA352850	71807	265	0.944444	2.5027766	Granulicatella adiacens	46124	Bacteria	Bacteria	483	7.249999999999998e-132	NTclustered	gi\|2315116068\|gb\|CP106751.1\|	46124	g68974	i0	99.621	3.24528301886792	264	1	99	0	1	264	756452	756715	Granulicatella adiacens strain KHUD_009 chromosome, complete genome	blastn	860	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella adiacens
8723962	8723962	PRJNA352850_P_NODE_49907_length_341_cov_4.630137_g47074_i0	PRJNA352850	49907	341	4.630137	15.78876717	Streptococcus	1301	Bacteria	Bacteria	547	3.3699999999999985e-151	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g47074	i0	95.601	98.7360703812317	341	15	100	0	1	341	153198	152858	Streptococcus infantis strain SO chromosome, complete genome	blastn	33669	547	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
9324890	9324890	PRJNA352850_P_NODE_8048_length_1289_cov_2.875806_g5974_i0	PRJNA352850	8048	1289	2.875806	37.06913934	Oceanobacillus iheyensis	182710	Bacteria	Bacteria	2364	0	NTclustered	gi\|42632302\|dbj\|BA000028.3\|	221109	g5974	i0	99.767	100.425911559348	1289	3	100	0	1	1289	145253	146541	Oceanobacillus iheyensis HTE831 DNA, complete genome	blastn	129449	2364	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus iheyensis
11274691	11274691	PRJNA352850_P_NODE_55409_length_317_cov_3.947761_g52576_i0	PRJNA352850	55409	317	3.947761	12.514402370000001	Peribacillus	2675229	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|2511439915\|gb\|CP126112.1\|	1478	g52576	i0	100	1166.40063091483	317	0	100	0	1	317	12634	12950	Peribacillus simplex strain WH6 chromosome, complete genome	blastn	369749	586	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus simplex
13149246	13149246	PRJNA352850_P_NODE_41071_length_392_cov_3.183673_g38239_i0	PRJNA352850	41071	392	3.183673	12.47999816	Streptococcus sp. Marseille-Q3533	2759692	Bacteria	Bacteria	697	0	NTclustered	gi\|2237347942\|emb\|OW724079.1\|	2759692	g38239	i0	98.724	27.0433673469388	392	5	100	0	1	392	151626	152017	Streptococcus sp. Marseille-Q3533 genome assembly, chromosome: contig00001	blastn	10601	697	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q3533
14425691	14425691	PRJNA352850_P_NODE_82812_length_245_cov_0.989796_g79979_i0	PRJNA352850	82812	245	0.989796	2.4250002	Jeotgalicoccus sp. WY2	2708346	Bacteria	Bacteria	313	9.19e-81	NTclustered	gi\|2043521547\|gb\|CP049818.1\|	2708346	g79979	i0	90.083	2.72244897959184	242	23	99	1	1	242	1728646	1728886	Jeotgalicoccus sp. WY2 chromosome, complete genome	blastn	667	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. WY2
15098892	15098892	PRJNA352850_P_NODE_32092_length_466_cov_1.911271_g29262_i0	PRJNA352850	32092	466	1.911271	8.90652286	Exiguobacterium	33986	Bacteria	Bacteria	763	0	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g29262	i0	96.391	775.442060085837	471	3	98	1	1	457	13320	12850	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	361356	763	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
15099670	15099670	PRJNA352850_P_NODE_83652_length_243_cov_1.742268_g80819_i0	PRJNA352850	83652	243	1.742268	4.23371124	Aerococcus	1375	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g80819	i0	100	574.576131687243	243	0	100	0	1	243	17409	17167	Aerococcus viridans strain CCUG4311, complete genome	blastn	139622	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
15698558	15698558	PRJNA352850_P_NODE_49933_length_341_cov_2.979452_g47100_i0	PRJNA352850	49933	341	2.979452	10.15993132	Oceanobacillus iheyensis	182710	Bacteria	Bacteria	630	3.2499999999999986e-176	NTclustered	gi\|42632302\|dbj\|BA000028.3\|	221109	g47100	i0	100	93.5953079178886	341	0	100	0	1	341	1996378	1996718	Oceanobacillus iheyensis HTE831 DNA, complete genome	blastn	31916	630	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus iheyensis
15699265	15699265	PRJNA352850_P_NODE_73353_length_262_cov_0.957746_g70520_i0	PRJNA352850	73353	262	0.957746	2.50929452	Helicovermis profundi	3065157	Bacteria	Bacteria	89.8	1.82e-13	NTclustered	gi\|2557884615\|dbj\|AP028654.1\|	3065157	g70520	i0	83.871	1.03435114503817	93	15	35	0	131	223	1854389	1854481	Clostridia bacterium S502 DNA, complete genome	blastn	271	89.8	1	Bacteria	Bacillati	Bacillota	Clostridia			Helicovermis	Helicovermis profundi
16974239	16974239	PRJNA352850_P_NODE_80974_length_248_cov_1.025126_g78141_i0	PRJNA352850	80974	248	1.025126	2.54231248	Clostridioides difficile	1496	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2706849409\|gb\|CP149653.1\|	1496	g78141	i0	97.059	0.137096774193548	34	0	14	1	194	227	2375930	2375898	Clostridioides difficile strain Z1323HCD0065 chromosome, complete genome	blastn	34	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
18247760	18247760	PRJNA352850_P_NODE_57095_length_311_cov_1.389313_g54262_i0	PRJNA352850	57095	311	1.389313	4.32076343	Trichococcus shcherbakoviae	2094020	Bacteria	Bacteria	403	6.97e-108	NTclustered	gi\|2621704421\|emb\|OY761017.1\|	2094020	g54262	i0	100	4.20578778135048	218	0	70	0	94	311	149908	149691	MAG: Trichococcus shcherbakoviae isolate 89b17532-9bee-499f-becb-1a49c542a750 genome assembly, chromosome: 2	blastn	1308	403	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus shcherbakoviae
18248537	18248537	PRJNA352850_P_NODE_82835_length_245_cov_0.933673_g80002_i0	PRJNA352850	82835	245	0.933673	2.28749885	Streptococcus intermedius	1338	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1109660964\|dbj\|AP014880.1\|	1338	g80002	i0	100	3.99183673469388	245	0	100	0	1	245	85932	86176	Streptococcus intermedius TYG1620 DNA, complete genome	blastn	978	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus intermedius
18922782	18922782	PRJNA352850_P_NODE_45895_length_362_cov_3.492013_g43062_i0	PRJNA352850	45895	362	3.492013	12.64108706	Bacillati	1783272	Bacteria	Bacteria	606	5.839999999999998e-169	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g43062	i0	99.698	497.577348066298	331	1	91	0	32	362	836262	836592	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	180123	606	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21473262	21473262	PRJNA352850_P_NODE_60537_length_298_cov_1.582329_g57704_i0	PRJNA352850	60537	298	1.582329	4.71534042	Bacteria	2	Bacteria	Bacteria	534	2.26e-147	NTclustered	gi\|1663099664\|gb\|CP039167.1\|	1280	g57704	i0	98.993	40.0805369127517	298	3	100	0	1	298	2859372	2859075	Staphylococcus aureus strain R50 chromosome, complete genome	blastn	11944	534	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
21473361	21473361	PRJNA352850_P_NODE_67577_length_275_cov_1.707965_g64744_i0	PRJNA352850	67577	275	1.707965	4.69690375	Lactobacillus	1578	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g64744	i0	100	418.12	275	0	100	0	1	275	90599	90325	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	114983	508	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
22071180	22071180	PRJNA352850_P_NODE_10938_length_1013_cov_3.463693_g8580_i0	PRJNA352850	10938	1013	3.463693	35.08721009	Salimicrobium jeotgali	1230341	Bacteria	Bacteria	1866	0	NTclustered	gi\|1102688036\|gb\|CP011361.3\|	1230341	g8580	i0	99.901	1.11549851924975	1013	1	100	0	1	1013	1709907	1710919	Salimicrobium jeotgali strain MJ3, complete genome	blastn	1130	1866	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salimicrobium	Salimicrobium jeotgali
22071915	22071915	PRJNA352850_P_NODE_33678_length_450_cov_7.152120_g30848_i0	PRJNA352850	33678	450	7.15212	32.18454	Sporosarcina sp. Te-1	2818390	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2013098341\|gb\|CP071798.1\|	2818390	g30848	i0	100	0.0622222222222222	28	0	6	0	421	448	3923879	3923852	Sporosarcina sp. Te-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina sp. Te-1
22748390	22748390	PRJNA352850_P_NODE_55998_length_315_cov_1.879699_g53165_i0	PRJNA352850	55998	315	1.879699	5.92105185	Peptostreptococcaceae	186804	Bacteria	Bacteria	566	8.519999999999997e-157	NTclustered	gi\|1172272411\|emb\|LN555523.1\|	1115758	g53165	i0	99.048	688.015873015873	315	3	100	0	1	315	90351	90665	Romboutsia ilealis strain CRIB genome assembly, chromosome: chr1	blastn	216725	566	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis
24622677	24622677	PRJNA352850_P_NODE_69220_length_270_cov_2.244344_g66387_i0	PRJNA352850	69220	270	2.244344	6.0597288	Oceanobacillus iheyensis	182710	Bacteria	Bacteria	494	3.4199999999999996e-135	NTclustered	gi\|42632302\|dbj\|BA000028.3\|	221109	g66387	i0	99.631	232.074074074074	271	0	100	1	1	270	679703	679433	Oceanobacillus iheyensis HTE831 DNA, complete genome	blastn	62660	494	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus iheyensis
24622810	24622810	PRJNA352850_P_NODE_73120_length_262_cov_1.863850_g70287_i0	PRJNA352850	73120	262	1.86385	4.883287	Carnobacteriaceae bacterium zg-C25	2821731	Bacteria	Bacteria	135	2.31e-27	NTclustered	gi\|2025669399\|gb\|CP072828.1\|	2821731	g70287	i0	76.863	26.8396946564886	255	50	95	7	14	262	51719	51468	Carnobacteriaceae bacterium zg-C25 chromosome, complete genome	blastn	7032	135	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae		Carnobacteriaceae bacterium zg-C25

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