metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax

34 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax_phylum = "Actinomycetota"

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
135284	135284	PRJEB7366_P_NODE_4621_length_427_cov_30.811224_g4189_i0	PRJEB7366	4621	427	30.811224	131.56392648	Pseudonocardia sp. DSM 110487	2865833	Bacteria	Bacteria	89.8	3.140000000000001e-13	NTclustered	gi\|2077468618\|gb\|CP080521.1\|	2865833	g4189	i0	94.737	0.386416861826698	57	3	13	0	115	171	1096945	1097001	Pseudonocardia sp. DSM 110487 chromosome, complete genome	blastn	165	89.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp. DSM 110487
995530	995530	PRJEB7366_P_NODE_13581_length_215_cov_2.838889_g13147_i0	PRJEB7366	13581	215	2.838889	6.10361135	Cutibacterium	1912216	Bacteria	Bacteria	392	9.83e-105	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g13147	i0	99.535	289.544186046512	215	1	100	0	1	215	55738	55952	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	62252	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
995553	995553	PRJEB7366_P_NODE_9001_length_281_cov_2.040650_g8567_i0	PRJEB7366	9001	281	2.04065	5.7342265	Cutibacterium	1912216	Bacteria	Bacteria	496	9.959999999999999e-136	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8567	i0	98.571	267.274021352313	280	4	99	0	2	281	56543	56264	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	75104	496	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
1409846	1409846	PRJEB7366_P_NODE_22942_length_157_cov_1.286885_g22508_i0	PRJEB7366	22942	157	1.286885	2.02040945	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g22508	i0	100	193.407643312102	157	0	100	0	1	157	885788	885944	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	30365	291	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
3961386	3961386	PRJEB7366_P_NODE_5464_length_385_cov_1.688571_g5031_i0	PRJEB7366	5464	385	1.688571	6.50099835	Streptomyces griseoaurantiacus	68213	Bacteria	Bacteria	75	7.84e-9	NTclustered	gi\|2697131811\|gb\|CP146837.1\|	68213	g5031	i0	90.909	1.15844155844156	55	5	14	0	140	194	4286966	4286912	Streptomyces griseoaurantiacus strain XQ-29 chromosome, complete genome	blastn	446	75	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces griseoaurantiacus
4823584	4823584	PRJEB7366_P_NODE_1184_length_903_cov_3.351382_g404_i1	PRJEB7366	1184	903	3.351382	30.26297946	Microbacteriaceae	85023	Bacteria	Bacteria	1229	0	NTclustered	gi\|2667034633\|dbj\|AP029214.1\|	69366	g404	i1	91.4	283.661129568106	907	63	100	8	1	903	1621988	1622883	Microbacterium flavescens JCM 11568 DNA, unplaced contig sequence4	blastn	256146	1229	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium flavescens
6098715	6098715	PRJEB7366_P_NODE_20505_length_168_cov_1.172932_g20071_i0	PRJEB7366	20505	168	1.172932	1.97052576	Tessaracoccus	72763	Bacteria	Bacteria	270	3.5799999999999998e-68	NTclustered	gi\|1146014067\|gb\|CP019607.1\|	399497	g20071	i0	95.833	216.39880952381	168	6	100	1	1	168	2402078	2402244	Tessaracoccus flavescens strain SST-39T chromosome, complete genome	blastn	36355	270	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus flavescens
7787591	7787591	PRJEB7366_P_NODE_11927_length_234_cov_2.301508_g11493_i0	PRJEB7366	11927	234	2.301508	5.38552872	Mycolicibacterium chitae	1792	Bacteria	Bacteria	377	3.04e-100	NTclustered	gi\|1806410789\|dbj\|AP022604.1\|	1792	g11493	i0	96.104	130.91452991453	231	9	99	0	4	234	2903582	2903352	Mycolicibacterium chitae JCM 12403 DNA, nearly complete genome	blastn	30634	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium chitae
7787654	7787654	PRJEB7366_P_NODE_4847_length_415_cov_30.107895_g4414_i0	PRJEB7366	4847	415	30.107895	124.94776425	Pseudonocardia sp. DSM 110487	2865833	Bacteria	Bacteria	71.3	1.1e-7	NTclustered	gi\|2077468618\|gb\|CP080521.1\|	2865833	g4414	i0	95.455	0.308433734939759	44	2	11	0	257	300	1097013	1096970	Pseudonocardia sp. DSM 110487 chromosome, complete genome	blastn	128	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp. DSM 110487
9062501	9062501	PRJEB7366_P_NODE_12028_length_233_cov_1.616162_g11594_i0	PRJEB7366	12028	233	1.616162	3.76565746	Streptomyces sp. NBC_00647	2975796	Bacteria	Bacteria	62.1	3.46e-5	NTclustered	gi\|2657787146\|gb\|CP109040.1\|	2975796	g11594	i0	97.222	13.7124463519313	36	1	15	0	44	79	427997	428032	Streptomyces sp. NBC_00647 chromosome, complete genome	blastn	3195	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00647
9923575	9923575	PRJEB7366_P_NODE_4908_length_412_cov_2.665782_g4475_i0	PRJEB7366	4908	412	2.665782	10.98302184	Cutibacterium	1912216	Bacteria	Bacteria	761	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4475	i0	100	269.293689320388	412	0	100	0	1	412	56593	57004	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	110949	761	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11198827	11198827	PRJEB7366_P_NODE_14029_length_211_cov_1.460227_g13595_i0	PRJEB7366	14029	211	1.460227	3.08107897	Kocuria	57493	Bacteria	Bacteria	379	7.489999999999999e-101	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g13595	i0	99.052	191.739336492891	211	2	100	0	1	211	898078	898288	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	40457	379	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
11198830	11198830	PRJEB7366_P_NODE_15349_length_199_cov_1.969512_g14915_i0	PRJEB7366	15349	199	1.969512	3.91932888	Streptomyces	1883	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1532260613\|gb\|CP020702.1\|	83656	g14915	i0	100	0.291457286432161	29	0	15	0	37	65	20556	20528	Streptomyces tsukubensis strain NRRL 18488 plasmid pSTS2, complete sequence	blastn	58	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces tsukubensis
11198833	11198833	PRJEB7366_P_NODE_1729_length_748_cov_7.305750_g1398_i0	PRJEB7366	1729	748	7.30575	54.64701	Mycobacteriaceae	1762	Bacteria	Bacteria	941	0	NTclustered	gi\|1806367077\|dbj\|AP022595.1\|	1534348	g1398	i0	95.008	151.148395721925	601	27	80	3	1	598	3702575	3703175	Mycolicibacterium sarraceniae JCM 30395 DNA, complete genome	blastn	113059	946	0.994714587737844	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sarraceniae
11198851	11198851	PRJEB7366_P_NODE_6229_length_354_cov_2.702194_g5796_i0	PRJEB7366	6229	354	2.702194	9.56576676	Cutibacterium	1912216	Bacteria	Bacteria	654	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5796	i0	100	251.378531073446	354	0	100	0	1	354	55726	55373	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	88988	654	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11613761	11613761	PRJEB7366_P_NODE_21170_length_164_cov_3.302326_g20736_i0	PRJEB7366	21170	164	3.302326	5.41581464	Mycolicibacterium helvum	1534349	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|1806371971\|dbj\|AP022596.1\|	1534349	g20736	i0	93.902	39.1463414634146	164	10	100	0	1	164	694620	694783	Mycolicibacterium helvum JCM 30396 DNA, complete genome	blastn	6420	248	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium helvum
12474482	12474482	PRJEB7366_P_NODE_1630_length_772_cov_8.457259_g1307_i0	PRJEB7366	1630	772	8.457259	65.29003948	Microbacterium	33882	Bacteria	Bacteria	1330	0	NTclustered	gi\|1081430622\|emb\|LT627736.1\|	912630	g1307	i0	97.917	170.575129533679	768	16	99	0	1	768	559728	560495	Microbacterium sp. LKL04 genome assembly, chromosome: I	blastn	131684	1336	0.995508982035928	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. LKL04
12474492	12474492	PRJEB7366_P_NODE_3770_length_483_cov_2.366071_g3348_i0	PRJEB7366	3770	483	2.366071	11.42812293	Mycobacterium	1763	Bacteria	Bacteria	715	0	NTclustered	gi\|2725797145\|dbj\|AP031386.1\|	154654	g3348	i0	93.737	157.743271221532	479	27	99	3	7	483	4166078	4165601	Mycobacterium montefiorense ATCC BAA-256 DNA, complete genome	blastn	76190	715	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium montefiorense
15023444	15023444	PRJEB7366_P_NODE_1732_length_747_cov_8.120787_g1401_i0	PRJEB7366	1732	747	8.120787	60.66227889	Micrococcaceae	1268	Bacteria	Bacteria	891	0	NTclustered	gi\|2105355783\|gb\|CP084109.1\|	1270	g1401	i0	92.126	259.069611780455	635	45	85	5	115	747	1315513	1314882	Micrococcus luteus strain anQ-m1 chromosome, complete genome	blastn	193525	896	0.994419642857143	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15023461	15023461	PRJEB7366_P_NODE_8672_length_287_cov_6.138889_g8238_i0	PRJEB7366	8672	287	6.138889	17.61861143	Micrococcus	1269	Bacteria	Bacteria	459	1.3399999999999999e-124	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g8238	i0	95.486	317.951219512195	288	11	100	2	1	287	345471	345757	Micrococcus luteus strain V017 chromosome, complete genome	blastn	91252	462	0.993506493506494	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15437721	15437721	PRJEB7366_P_NODE_15653_length_197_cov_1.234568_g15219_i0	PRJEB7366	15653	197	1.234568	2.43209896	Streptomyces anulatus	1892	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2129715290\|gb\|CP086102.1\|	1892	g15219	i0	100	0.142131979695431	28	0	14	0	47	74	836774	836801	Streptomyces anulatus strain YINM00001 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces anulatus
16298196	16298196	PRJEB7366_P_NODE_9553_length_271_cov_1.105932_g9119_i0	PRJEB7366	9553	271	1.105932	2.99707572	Conexibacter	191494	Bacteria	Bacteria	451	2.0999999999999997e-122	NTclustered	gi\|2874253784\|emb\|OY969768.1\|	768556	g9119	i0	96.679	99.7564575645756	271	9	100	0	1	271	633308	633038	MAG: uncultured Solirubrobacterales bacterium isolate MFD05502.bin.1.27 genome assembly, chromosome: 1	blastn	27034	451	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			uncultured Solirubrobacterales bacterium
17573460	17573460	PRJEB7366_P_NODE_9054_length_280_cov_2.044898_g8620_i0	PRJEB7366	9054	280	2.044898	5.7257144	Micrococcaceae	1268	Bacteria	Bacteria	490	4.61e-134	NTclustered	gi\|1883577788\|gb\|CP059343.1\|	1272	g8620	i0	98.214	349.835714285714	280	5	100	0	1	280	1052257	1051978	Kocuria varians strain 80 chromosome, complete genome	blastn	97954	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria varians
17986859	17986859	PRJEB7366_P_NODE_4395_length_442_cov_1.375921_g3966_i0	PRJEB7366	4395	442	1.375921	6.08157082	Micromonospora sp. WMMD1128	3015150	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2418466467\|gb\|CP114902.1\|	3015150	g3966	i0	96.774	0.0701357466063348	31	1	7	0	29	59	5313947	5313977	Micromonospora sp. WMMD1128 chromosome	blastn	31	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. WMMD1128
18847238	18847238	PRJEB7366_P_NODE_1735_length_746_cov_9.129395_g1404_i0	PRJEB7366	1735	746	9.129395	68.1052867	Micrococcus	1269	Bacteria	Bacteria	1074	0	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g1404	i0	97.31	221.138069705094	632	17	85	0	115	746	1627314	1627945	Micrococcus luteus strain ML chromosome, complete genome	blastn	164969	1074	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
18847251	18847251	PRJEB7366_P_NODE_555_length_1263_cov_3.845277_g404_i0	PRJEB7366	555	1263	3.845277	48.56584851	Micrococcus	1269	Bacteria	Bacteria	1406	0	NTclustered	gi\|1004607165\|gb\|KT865873.1\|	1811305	g404	i0	89.367	236.361045130641	1138	93	92	20	1	1128	342	1461	Micrococcus sp. ALBL_223 23S ribosomal RNA gene, partial sequence	blastn	298524	1417	0.992237120677488	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus sp. ALBL_223
18847252	18847252	PRJEB7366_P_NODE_8035_length_302_cov_2.606742_g7601_i0	PRJEB7366	8035	302	2.606742	7.87236084	Cutibacterium	1912216	Bacteria	Bacteria	558	1.36e-154	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7601	i0	100	264.612582781457	302	0	100	0	1	302	57303	57002	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	79913	558	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19260825	19260825	PRJEB7366_P_NODE_13556_length_215_cov_6.788889_g13122_i0	PRJEB7366	13556	215	6.788889	14.59611135	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	276	1.03e-69	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g13122	i0	89.815	217.306976744186	216	20	100	2	1	215	82505	82719	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	46721	276	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
20122054	20122054	PRJEB7366_P_NODE_19876_length_171_cov_1.154412_g19442_i0	PRJEB7366	19876	171	1.154412	1.97404452	Kocuria	57493	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g19442	i0	100	199.614035087719	171	0	100	0	1	171	897895	898065	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	34134	316	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
21397668	21397668	PRJEB7366_P_NODE_1397_length_836_cov_10.067416_g1107_i0	PRJEB7366	1397	836	10.067416	84.16359776	Micrococcus	1269	Bacteria	Bacteria	1371	0	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g1107	i0	96.301	187.230861244019	838	25	100	6	1	836	1627618	1628451	Micrococcus luteus strain ML chromosome, complete genome	blastn	156525	1371	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
21812020	21812020	PRJEB7366_P_NODE_21898_length_161_cov_1.809524_g21464_i0	PRJEB7366	21898	161	1.809524	2.91333364	Mycolicibacterium parafortuitum	39692	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|1806383317\|dbj\|AP022598.1\|	39692	g21464	i0	96.129	165.385093167702	155	6	96	0	1	155	3089518	3089672	Mycolicibacterium parafortuitum JCM 6367 DNA, nearly complete genome	blastn	26627	254	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium parafortuitum
21812065	21812065	PRJEB7366_P_NODE_9798_length_266_cov_1.320346_g9364_i0	PRJEB7366	9798	266	1.320346	3.51212036	Brooklawnia propionicigenes	3041175	Bacteria	Bacteria	195	3.82e-45	NTclustered	gi\|2504553319\|dbj\|AP028056.1\|	3041175	g9364	i0	80.075	109.571428571429	266	49	99	4	1	264	332598	332335	Brooklawnia propionicigenes SH051 DNA, complete genome	blastn	29146	195	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Brooklawnia	Brooklawnia propionicigenes
22672412	22672412	PRJEB7366_P_NODE_11418_length_241_cov_2.033981_g10984_i0	PRJEB7366	11418	241	2.033981	4.90189421	Janibacter	53457	Bacteria	Bacteria	438	1.4299999999999999e-118	NTclustered	gi\|1916684862\|gb\|CP062789.1\|	857417	g10984	i0	99.583	174.406639004149	240	1	99	0	1	240	2130277	2130038	Janibacter indicus strain TT2 chromosome, complete genome	blastn	42032	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter indicus
22672420	22672420	PRJEB7366_P_NODE_16858_length_188_cov_1.941176_g16424_i0	PRJEB7366	16858	188	1.941176	3.64941088	Nocardiaceae	85025	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g16424	i0	100	376.696808510638	188	0	100	0	1	188	1621652	1621465	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	70819	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians

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