metadata: contig_metadata: 13 rows where bioproject = "PRJEB83101", tax_clade = "core chlorophytes" and tax

13 rows where bioproject = "PRJEB83101", tax_clade = "core chlorophytes" and tax_phylum = "Chlorophyta"

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
3969226	3969226	PRJEB83101_P_NODE_84224_length_243_cov_0.917647_g83919_i0	PRJEB83101	84224	243	0.917647	2.22988221	Stichococcus bacillaris	37433	Plants	Plants	392	1.14e-104	NTclustered	gi\|371782093\|emb\|HE610125.1\|	37433	g83919	i0	95.082	16.9259259259259	244	11	100	1	1	243	7265	7022	Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2	blastn	4113	392	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Stichococcus	Stichococcus bacillaris
3969373	3969373	PRJEB83101_P_NODE_90064_length_229_cov_2.153846_g89759_i0	PRJEB83101	90064	229	2.153846	4.93230734	Chlorella variabilis	554065	Plants	Plants	318	1.82e-82	NTclustered	gi\|552825898\|ref\|XM_005846851.1\|	554065	g89759	i0	91.703	1	229	19	100	0	1	229	2530	2302	Chlorella variabilis hypothetical protein (CHLNCDRAFT_31463) mRNA, complete cds	blastn	229	318	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
15444683	15444683	PRJEB83101_P_NODE_47613_length_280_cov_1.531401_g47308_i0	PRJEB83101	47613	280	1.531401	4.2879228	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	194	8.47e-58	NR	KAG7670001.1	1650286	g47308	i0	96.7	0.985714285714286	92	3	98.6	0	3	278	275	366	KAG7670001.1 hypothetical protein KSW81_008141 [Chlorella desiccata (nom. nud.)]	diamond	276	194	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
20543173	20543173	PRJEB83101_P_NODE_50657_length_275_cov_1.361386_g50352_i0	PRJEB83101	50657	275	1.361386	3.7438115	Chlorella variabilis	554065	Plants	Plants	387	6.1e-103	NTclustered	gi\|552846103\|ref\|XM_005851468.1\|	554065	g50352	i0	92	96.2654545454545	275	22	100	0	1	275	1086	1360	Chlorella variabilis hypothetical protein (CHLNCDRAFT_55979) mRNA, complete cds	blastn	26473	387	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
26932081	26932081	PRJEB83101_P_NODE_64522_length_253_cov_1.877778_g64217_i0	PRJEB83101	64522	253	1.877778	4.75077834	Chlorella	3071	Plants	Plants	145	2.32e-38	NR	PRW59149.1	3076	g64217	i0	96.3	1.92094861660079	81	3	96	0	245	3	348	428	PRW59149.1 eukaryotic translation initiation factor 3 subunit A-like [Chlorella sorokiniana]	diamond	486	145	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
27666366	27666366	PRJEB83101_P_NODE_80664_length_245_cov_0.906977_g80359_i0	PRJEB83101	80664	245	0.906977	2.22209365	Micractinium conductrix	554055	Plants	Plants	70.9	4.73e-12	NR	PSC74655.1	554055	g80359	i0	75	1.44489795918367	40	10	49	0	245	126	673	712	PSC74655.1 abhydrolase domain-containing [Micractinium conductrix]	diamond	354	70.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium conductrix
27753772	27753772	PRJEB83101_P_NODE_37484_length_304_cov_1.350649_g37179_i0	PRJEB83101	37484	304	1.350649	4.10597296	Chlorellaceae	35461	Plants	Plants	45.8	0.00625	NR	PRW33194.1	3076	g37179	i0	94.7	1.32236842105263	19	1	18.8	0	57	1	550	568	PRW33194.1 hypothetical protein C2E21_7888 [Chlorella sorokiniana]	diamond	402	45.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
28708260	28708260	PRJEB83101_P_NODE_45087_length_285_cov_1.160377_g44782_i0	PRJEB83101	45087	285	1.160377	3.30707445	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	128	6.01e-32	NR	KAG7669556.1	1650286	g44782	i0	65.2	2.90526315789474	92	30	96.8	1	277	2	397	486	KAG7669556.1 hypothetical protein KSW81_007707 [Chlorella desiccata (nom. nud.)]	diamond	828	128	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
28802591	28802591	PRJEB83101_P_NODE_69688_length_250_cov_2.446328_g69383_i0	PRJEB83101	69688	250	2.446328	6.11582	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	44.3	0.0119	NR	KAG7670149.1	1650286	g69383	i0	87.1	0.744	31	3	37.2	1	64	156	610	639	KAG7670149.1 hypothetical protein KSW81_008286 [Chlorella desiccata (nom. nud.)]	diamond	186	44.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
30602924	30602924	PRJEB83101_P_NODE_73873_length_248_cov_1.531429_g73568_i0	PRJEB83101	73873	248	1.531429	3.79794392	Chlorella sorokiniana	3076	Plants	Plants	52.4	1.62e-5	NR	PRW20828.1	3076	g73568	i0	74.7	1.00403225806452	83	19	98	2	4	246	233	315	PRW20828.1 hypothetical protein C2E21_8674 [Chlorella sorokiniana]	diamond	249	52.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31488286	31488286	PRJEB83101_P_NODE_90156_length_228_cov_3.006452_g89851_i0	PRJEB83101	90156	228	3.006452	6.85471056	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	47	9.95e-4	NR	KAH7622039.1	1650286	g89851	i0	61	0.539473684210526	41	7	42.1	1	96	1	26	66	KAH7622039.1 putative Aspartokinase 1, chloroplastic [Chlorella desiccata (nom. nud.)]	diamond	123	47	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
32152406	32152406	PRJEB83101_P_NODE_79878_length_245_cov_0.906977_g79573_i0	PRJEB83101	79878	245	0.906977	2.22209365	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	53.5	5.64e-6	NR	KAL4523041.1	1650286	g79573	i0	70.3	0.453061224489796	37	11	45.3	0	120	10	313	349	KAL4523041.1 hypothetical protein Ndes2526A_g07758 [Chlorella desiccata (nom. nud.)]	diamond	111	53.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
32532249	32532249	PRJEB83101_P_NODE_42259_length_290_cov_1.456221_g41954_i0	PRJEB83101	42259	290	1.456221	4.2230409	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	60.1	5.15e-8	NR	KAG7672101.1	1650286	g41954	i0	48.6	1.53103448275862	74	24	73.4	4	29	241	490	552	KAG7672101.1 hypothetical protein KSW81_004984 [Chlorella desiccata (nom. nud.)]	diamond	444	60.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'

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