metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax_phylum = "Gemmatimonadota"

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
346751	346751	PRJNA1240804_P_NODE_109901_length_169_cov_0.866667_g109535_i0	PRJNA1240804	109901	169	0.866667	1.46466723	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	230	6.0699999999999995e-56	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g109535	i0	94.595	4.89349112426035	148	8	88	0	8	155	1244159	1244012	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	827	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1621441	1621441	PRJNA1240804_P_NODE_106622_length_169_cov_1.475000_g106256_i0	PRJNA1240804	106622	169	1.475	2.49275	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	139	1.05e-28	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g106256	i0	91.919	2.79881656804734	99	8	59	0	53	151	8095095	8094997	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	473	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1621659	1621659	PRJNA1240804_P_NODE_119222_length_167_cov_0.881356_g118856_i0	PRJNA1240804	119222	167	0.881356	1.47186452	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	207	2.83e-49	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g118856	i0	93.525	82.1497005988024	139	9	83	0	15	153	271828	271966	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	13719	207	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
1623760	1623760	PRJNA1240804_P_NODE_84382_length_183_cov_2.350746_g84016_i0	PRJNA1240804	84382	183	2.350746	4.30186518	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	233	5.19e-57	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g84016	i0	91.765	308.021857923497	170	11	92	3	13	181	2958267	2958100	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	56368	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1623926	1623926	PRJNA1240804_P_NODE_92502_length_178_cov_1.472868_g92136_i0	PRJNA1240804	92502	178	1.472868	2.62170504	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	100	5.3e-17	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g92136	i0	83.486	26.6910112359551	109	17	61	1	13	120	5538701	5538593	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	4751	100	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
2325519	2325519	PRJNA1240804_P_NODE_34562_length_251_cov_3.188119_g34196_i0	PRJNA1240804	34562	251	3.188119	8.00217869	Gemmatimonadota	142182	Bacteria	Bacteria	220	5.89e-53	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g34196	i0	86.275	132.988047808765	204	27	81	1	16	219	1903423	1903221	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	33380	222	0.990990990990991	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4176056	4176056	PRJNA1240804_P_NODE_73404_length_191_cov_1.345070_g73038_i0	PRJNA1240804	73404	191	1.34507	2.5690837	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	183	5.5799999999999996e-42	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g73038	i0	87.578	85.4921465968586	161	16	82	4	14	170	171713	171553	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	16329	183	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8000792	8000792	PRJNA1240804_P_NODE_142607_length_163_cov_0.912281_g142241_i0	PRJNA1240804	142607	163	0.912281	1.48701803	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	60.2	8.12e-5	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g142241	i0	92.857	0.865030674846626	42	2	26	1	28	69	7582379	7582339	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	141	60.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8001865	8001865	PRJNA1240804_P_NODE_56207_length_210_cov_1.217391_g55841_i0	PRJNA1240804	56207	210	1.217391	2.5565211	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	198	2.24e-46	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g55841	i0	84.772	1.84285714285714	197	30	94	0	1	197	5100496	5100692	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	387	198	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
9276770	9276770	PRJNA1240804_P_NODE_55508_length_211_cov_1.228395_g55142_i0	PRJNA1240804	55508	211	1.228395	2.59191345	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	196	8.089999999999999e-46	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g55142	i0	84.694	21.9052132701422	196	30	93	0	15	210	1101475	1101670	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	4622	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
10552634	10552634	PRJNA1240804_P_NODE_58589_length_207_cov_1.088608_g58223_i0	PRJNA1240804	58589	207	1.088608	2.25341856	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	246	7.74e-61	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g58223	i0	92.941	10.8405797101449	170	11	82	1	15	183	1553428	1553597	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	2244	246	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
10552642	10552642	PRJNA1240804_P_NODE_5889_length_504_cov_4.716484_g5531_i0	PRJNA1240804	5889	504	4.716484	23.77107936	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	573	8.509999999999999e-159	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g5531	i0	87.719	149.041666666667	513	36	97	17	15	504	1904107	1903599	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	75117	573	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10552712	10552712	PRJNA1240804_P_NODE_62229_length_202_cov_1.431373_g61863_i0	PRJNA1240804	62229	202	1.431373	2.89137346	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	117	6.15e-22	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g61863	i0	88.66	14.8762376237624	97	9	48	2	89	185	2788709	2788803	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	3005	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11825565	11825565	PRJNA1240804_P_NODE_106550_length_169_cov_1.533333_g106184_i0	PRJNA1240804	106550	169	1.533333	2.59133277	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	219	1.3099999999999999e-52	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g106184	i0	92.208	183.520710059172	154	12	91	0	15	168	1902613	1902460	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	31015	219	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11825950	11825950	PRJNA1240804_P_NODE_128870_length_165_cov_1.853448_g128504_i0	PRJNA1240804	128870	165	1.853448	3.0581892	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	183	4.69e-42	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g128504	i0	91.304	352.072727272727	138	7	81	5	1	134	343476	343612	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	58092	183	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11826459	11826459	PRJNA1240804_P_NODE_18530_length_321_cov_1.404412_g18164_i0	PRJNA1240804	18530	321	1.404412	4.50816252	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	250	9.95e-62	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g18164	i0	84.766	82.2803738317757	256	31	79	7	15	266	1102972	1103223	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	26412	250	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
12528966	12528966	PRJNA1240804_P_NODE_71670_length_192_cov_1.440559_g71304_i0	PRJNA1240804	71670	192	1.440559	2.76587328	Gemmatimonas	173479	Bacteria	Bacteria	276	9.01e-70	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g71304	i0	95.402	90.0104166666667	174	7	90	1	6	178	1240	1067	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	17282	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
12528968	12528968	PRJNA1240804_P_NODE_72350_length_192_cov_1.076923_g71984_i0	PRJNA1240804	72350	192	1.076923	2.06769216	Gemmatimonas	173479	Bacteria	Bacteria	252	1.52e-62	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g71984	i0	93.064	121.796875	173	11	90	1	7	178	343215	343387	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	23385	254	0.992125984251969	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14376460	14376460	PRJNA1240804_P_NODE_142052_length_163_cov_0.912281_g141686_i0	PRJNA1240804	142052	163	0.912281	1.48701803	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g141686	i0	100	0.521472392638037	29	0	18	0	58	86	6516685	6516657	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	85	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14376478	14376478	PRJNA1240804_P_NODE_143032_length_163_cov_0.912281_g142666_i0	PRJNA1240804	143032	163	0.912281	1.48701803	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	171	3.59e-38	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g142666	i0	89.051	6.51533742331288	137	15	84	0	9	145	552752	552616	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1062	171	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
14376924	14376924	PRJNA1240804_P_NODE_26272_length_280_cov_1.632035_g25906_i0	PRJNA1240804	26272	280	1.632035	4.569698	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	152	2.4699999999999996e-32	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g25906	i0	81.768	0.646428571428571	181	33	65	0	4	184	228078	227898	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	181	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16352885	16352885	PRJNA1240804_P_NODE_92373_length_178_cov_1.503876_g92007_i0	PRJNA1240804	92373	178	1.503876	2.67689928	Gemmatimonas	173479	Bacteria	Bacteria	222	1.08e-53	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g92007	i0	91.463	64.6011235955056	164	11	91	3	14	175	1559	1721	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	11499	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
16924079	16924079	PRJNA1240804_P_NODE_109454_length_169_cov_0.866667_g109088_i0	PRJNA1240804	109454	169	0.866667	1.46466723	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g109088	i0	88.66	0.57396449704142	97	9	57	2	34	129	3115296	3115391	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	97	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
17628156	17628156	PRJNA1240804_P_NODE_8454_length_437_cov_2.744845_g8092_i0	PRJNA1240804	8454	437	2.744845	11.99497265	Gemmatimonadaceae	219687	Bacteria	Bacteria	453	9.91e-123	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g8092	i0	86.247	101.054919908467	429	45	97	14	2	423	1334	913	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	44161	457	0.991247264770241	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
18198464	18198464	PRJNA1240804_P_NODE_10395_length_402_cov_2.787535_g10032_i0	PRJNA1240804	10395	402	2.787535	11.2058907	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	640	6.47e-179	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g10032	i0	96.392	401.995024875622	388	14	97	0	1	388	1295389	1295002	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	161602	640	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18901386	18901386	PRJNA1240804_P_NODE_111455_length_168_cov_3.310924_g111089_i0	PRJNA1240804	111455	168	3.310924	5.56235232	Gemmatimonas	173479	Bacteria	Bacteria	272	9.95e-69	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g111089	i0	95.833	104.005952380952	168	7	100	0	1	168	1992	2159	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	17473	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
20748978	20748978	PRJNA1240804_P_NODE_144457_length_163_cov_0.912281_g144091_i0	PRJNA1240804	144457	163	0.912281	1.48701803	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2107953857\|gb\|CP070792.1\|	2026742	g144091	i0	92.308	0.239263803680982	39	3	24	0	21	59	1611683	1611645	MAG: Gemmatimonadetes bacterium isolate bin1440 chromosome	blastn	39	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
20749257	20749257	PRJNA1240804_P_NODE_1957_length_761_cov_2.172753_g1655_i0	PRJNA1240804	1957	761	2.172753	16.53465033	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	451	6.44e-122	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1655	i0	85.36	27.580814717477	444	56	95	9	15	454	3042317	3042755	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	20989	451	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20749356	20749356	PRJNA1240804_P_NODE_24197_length_289_cov_5.679167_g23831_i0	PRJNA1240804	24197	289	5.679167	16.41279263	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	375	1.4e-99	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g23831	i0	90.625	420.131487889273	288	20	99	6	5	289	3043235	3042952	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	121418	375	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22024657	22024657	PRJNA1240804_P_NODE_26218_length_280_cov_2.142857_g25852_i0	PRJNA1240804	26218	280	2.142857	5.9999996	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	228	3.9899999999999986e-55	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g25852	i0	83.333	132.578571428571	252	36	90	5	14	264	1904679	1904433	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	37122	228	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24573218	24573218	PRJNA1240804_P_NODE_113240_length_168_cov_0.873950_g112874_i0	PRJNA1240804	113240	168	0.87395	1.468236	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	226	7.859999999999997e-55	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g112874	i0	92.903	0.922619047619048	155	11	92	0	1	155	5502529	5502683	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	155	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24574670	24574670	PRJNA1240804_P_NODE_4840_length_544_cov_1.694949_g4485_i0	PRJNA1240804	4840	544	1.694949	9.22052256	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	630	5.4e-176	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g4485	i0	88.411	58.4136029411765	535	47	97	11	1	530	2076405	2075881	Gemmatimonas phototrophica strain AP64, complete genome	blastn	31777	630	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica

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