metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA694557" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA694557" 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
673350	673350	PRJNA694557_P_NODE_21121_length_269_cov_2.260204_g20901_i0	PRJNA694557	21121	269	2.260204	6.07994876	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	409	1.27e-109	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g20901	i0	96.735	8.24907063197026	245	8	91	0	1	245	1455234	1455478	Calothrix sp. PCC 7716 DNA, complete genome	blastn	2219	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
1949187	1949187	PRJNA694557_P_NODE_15422_length_329_cov_3.796875_g15202_i0	PRJNA694557	15422	329	3.796875	12.49171875	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	555	1.9399999999999994e-153	NTclustered	gi\|225696217\|gb\|FJ805884.1\|	259957	g15202	i0	99.346	57.5075987841945	306	2	93	0	24	329	1341	1036	Uncultured Chroococcidiopsis sp. clone NA4_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18920	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2454750	2454750	PRJNA694557_P_NODE_15402_length_330_cov_1.198444_g15182_i0	PRJNA694557	15402	330	1.198444	3.9548652	Chroococcidiopsis	54298	Bacteria	Bacteria	172	2.2899999999999998e-38	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g15182	i0	90.299	0.812121212121212	134	10	40	3	10	142	4540466	4540597	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	268	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
3224312	3224312	PRJNA694557_P_NODE_22903_length_254_cov_6.066298_g22683_i0	PRJNA694557	22903	254	6.066298	15.40839692	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	427	3.28e-115	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g22683	i0	99.573	226.889763779528	234	1	96	0	21	254	1859336	1859103	Calothrix sp. PCC 7716 DNA, complete genome	blastn	57630	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
3224379	3224379	PRJNA694557_P_NODE_26143_length_237_cov_6.225610_g25923_i0	PRJNA694557	26143	237	6.22561	14.7546957	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	355	1.45e-93	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g25923	i0	96.347	131.898734177215	219	2	90	6	24	237	1845	2062	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31260	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3224493	3224493	PRJNA694557_P_NODE_7503_length_518_cov_116.633708_g7283_i0	PRJNA694557	7503	518	116.633708	604.16260744	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	830	0	NTclustered	gi\|225696217\|gb\|FJ805884.1\|	259957	g7283	i0	96.97	113.223938223938	495	13	95	2	6	499	2054	1561	Uncultured Chroococcidiopsis sp. clone NA4_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	58650	830	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3731478	3731478	PRJNA694557_P_NODE_26843_length_227_cov_2.649351_g26623_i0	PRJNA694557	26843	227	2.649351	6.01402677	Chroococcidiopsis	54298	Bacteria	Bacteria	176	1.15e-39	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g26623	i0	84.066	1.60352422907489	182	29	80	0	3	184	5051792	5051973	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	364	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
8326288	8326288	PRJNA694557_P_NODE_12127_length_382_cov_5.000000_g11907_i0	PRJNA694557	12127	382	5	19.1	Cyanobium sp. M30B3	2831057	Bacteria	Bacteria	244	5.6e-60	NTclustered	gi\|2041287931\|gb\|CP073761.1\|	2831057	g11907	i0	79.943	10.3062827225131	349	56	91	10	17	364	539709	540044	MAG: Cyanobium sp. M30B3 chromosome, complete genome	blastn	3937	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. M30B3
8326534	8326534	PRJNA694557_P_NODE_26147_length_237_cov_4.975610_g25927_i0	PRJNA694557	26147	237	4.97561	11.7921957	Leptolyngbya sp. LEGE 18517	3132512	Bacteria	Bacteria	416	6.5499999999999985e-112	NTclustered	gi\|2697880845\|gb\|PP476846.1\|	3132512	g25927	i0	98.312	106.101265822785	237	4	100	0	1	237	680	444	Leptolyngbya sp. LEGE 18517 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	25146	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. LEGE 18517
9601671	9601671	PRJNA694557_P_NODE_15848_length_324_cov_2.215139_g15628_i0	PRJNA694557	15848	324	2.215139	7.17705036	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.5999999999999996e-114	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g15628	i0	90.244	177.299382716049	328	27	100	5	1	324	1940	1614	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57445	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10877318	10877318	PRJNA694557_P_NODE_18549_length_293_cov_2.100000_g18329_i0	PRJNA694557	18549	293	2.1	6.153	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	337	6.699999999999997e-88	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g18329	i0	87.629	0.993174061433447	291	34	99	2	1	290	4484207	4484496	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	291	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
13427256	13427256	PRJNA694557_P_NODE_7671_length_511_cov_2.890411_g7451_i0	PRJNA694557	7671	511	2.890411	14.77000021	Brasilonema sennae	1397703	Bacteria	Bacteria	507	8.88e-139	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g7451	i0	87.33	8.09197651663405	442	56	89	0	1	442	1347548	1347107	Brasilonema sennae CENA114 chromosome	blastn	4135	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
13933474	13933474	PRJNA694557_P_NODE_18011_length_299_cov_2.296460_g17791_i0	PRJNA694557	18011	299	2.29646	6.8664154	Chroococcidiopsis	54298	Bacteria	Bacteria	250	9.19e-62	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g17791	i0	81.94	2	299	51	99	3	1	298	3192432	3192136	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	598	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
14702466	14702466	PRJNA694557_P_NODE_5352_length_640_cov_2.774250_g5134_i0	PRJNA694557	5352	640	2.77425	17.7552	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	802	0	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g5134	i0	90.113	1.928125	617	61	96	0	24	640	6329183	6329799	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	1234	802	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
14702516	14702516	PRJNA694557_P_NODE_8432_length_480_cov_7.766585_g8212_i0	PRJNA694557	8432	480	7.766585	37.279608	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	501	3.86e-137	NTclustered	gi\|225696214\|gb\|FJ805881.1\|	259957	g8212	i0	86.481	187.535416666667	466	51	96	11	1	461	2071	1613	Uncultured Chroococcidiopsis sp. clone A3_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	90017	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15208112	15208112	PRJNA694557_P_NODE_18912_length_289_cov_4.273148_g18692_i0	PRJNA694557	18912	289	4.273148	12.34939772	Nostoc	1177	Bacteria	Bacteria	62.1	4.44e-5	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g18692	i0	100	2.32525951557093	33	0	11	0	60	92	2043388	2043356	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	672	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
15976294	15976294	PRJNA694557_P_NODE_9593_length_443_cov_2.081081_g9373_i0	PRJNA694557	9593	443	2.081081	9.21918883	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	470	9.98e-128	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g9373	i0	86.62	1.92325056433409	426	55	96	2	19	443	5541379	5540955	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	852	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16482590	16482590	PRJNA694557_P_NODE_6773_length_552_cov_5.160752_g6554_i0	PRJNA694557	6773	552	5.160752	28.48735104	Nostoc	1177	Bacteria	Bacteria	259	2.98e-64	NTclustered	gi\|1349670869\|gb\|CP026692.1\|	1618022	g6554	i0	82.653	2.65217391304348	294	49	53	2	18	309	2137794	2138087	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont' strain 5183 chromosome, complete genome	blastn	1464	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'
18525398	18525398	PRJNA694557_P_NODE_27315_length_196_cov_6.975610_g27095_i0	PRJNA694557	27315	196	6.97561	13.6721956	Phormidium sp. NIES-2115	2510784	Bacteria	Bacteria	257	3.3500000000000004e-64	NTclustered	gi\|1566846238\|dbj\|LC455616.1\|	2510784	g27095	i0	96.178	119.479591836735	157	6	80	0	39	195	16	172	Phormidium sp. NIES-2115 gene for 23S ribosomal RNA, partial sequence	blastn	23418	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2115
18525480	18525480	PRJNA694557_P_NODE_7895_length_500_cov_5.023419_g7675_i0	PRJNA694557	7895	500	5.023419	25.117095	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	846	0	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g7675	i0	97.39	146.58	498	12	99	1	1	497	1245227	1244730	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	73290	846	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
21075755	21075755	PRJNA694557_P_NODE_19897_length_280_cov_2.811594_g19677_i0	PRJNA694557	19897	280	2.811594	7.8724632	Calothrix sp. PCC 7507	99598	Bacteria	Bacteria	171	6.83e-38	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g19677	i0	80	0.821428571428571	230	46	82	0	38	267	5358439	5358210	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	230	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
21581669	21581669	PRJNA694557_P_NODE_13217_length_362_cov_3.508651_g12997_i0	PRJNA694557	13217	362	3.508651	12.70131662	Chroococcidiopsis	54298	Bacteria	Bacteria	448	3.7499999999999997e-121	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g12997	i0	91.212	1.8232044198895	330	28	91	1	26	354	5909831	5910160	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	660	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
21581793	21581793	PRJNA694557_P_NODE_20937_length_271_cov_1.555556_g20717_i0	PRJNA694557	20937	271	1.555556	4.21555676	Chroococcidiopsis	54298	Bacteria	Bacteria	484	2.07e-132	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g20717	i0	98.897	150.523985239852	272	1	100	2	1	271	903	633	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	40792	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
21581994	21581994	PRJNA694557_P_NODE_7757_length_506_cov_25.348730_g7537_i0	PRJNA694557	7757	506	25.34873	128.2645738	Chroococcidiopsis	54298	Bacteria	Bacteria	752	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g7537	i0	94.65	177.579051383399	486	25	96	1	22	506	1931	2416	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	89855	752	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
22856827	22856827	PRJNA694557_P_NODE_13578_length_356_cov_5.063604_g13358_i0	PRJNA694557	13578	356	5.063604	18.02643024	Leptolyngbya	47251	Bacteria	Bacteria	553	7.579999999999998e-153	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g13358	i0	94.678	199.460674157303	357	17	100	2	1	356	247320	246965	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	71008	553	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
22856907	22856907	PRJNA694557_P_NODE_19038_length_288_cov_3.204651_g18818_i0	PRJNA694557	19038	288	3.204651	9.22939488	Chroococcidiopsis	54298	Bacteria	Bacteria	355	1.81e-93	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g18818	i0	90.943	1.84027777777778	265	22	92	2	20	283	1121287	1121024	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	530	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
23626146	23626146	PRJNA694557_P_NODE_26179_length_237_cov_2.615854_g25959_i0	PRJNA694557	26179	237	2.615854	6.19957398	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	281	2.49e-71	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g25959	i0	88.745	128.164556962025	231	24	97	2	1	230	2410	2181	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30375	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
23626263	23626263	PRJNA694557_P_NODE_9239_length_453_cov_5.623684_g9019_i0	PRJNA694557	9239	453	5.623684	25.47528852	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	542	2.14e-149	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g9019	i0	89.81	19.4194260485651	422	43	93	0	23	444	2706359	2705938	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	8797	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
24131261	24131261	PRJNA694557_P_NODE_11499_length_396_cov_1.773994_g11279_i0	PRJNA694557	11499	396	1.773994	7.02501624	Nostoc	1177	Bacteria	Bacteria	361	5.5499999999999996e-95	NTclustered	gi\|1866646741\|gb\|CP040281.1\|	2576903	g11279	i0	84.722	11.6262626262626	360	55	91	0	37	396	2562605	2562964	Nostoc sp. C057 chromosome, complete genome	blastn	4604	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
24899601	24899601	PRJNA694557_P_NODE_18420_length_294_cov_6.171946_g18200_i0	PRJNA694557	18420	294	6.171946	18.14552124	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	497	2.91e-136	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g18200	i0	98.921	141.119047619048	278	3	95	0	17	294	2087	2364	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41489	497	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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