metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_clade = "core chlorophytes"

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
7301170	7301170	PRJNA942359_P_NODE_4286_length_392_cov_2.294671_g4171_i0	PRJNA942359	4286	392	2.294671	8.99511032	Eukaryota	2759	Plants	Plants	217	1.8099999999999999e-62	NR	RMZ52643.1	3075	g4171	i0	86.9	219.313775510204	130	17	99.5	0	392	3	5	134	RMZ52643.1 hypothetical protein APUTEX25_000762, partial [Auxenochlorella protothecoides]	diamond	85971	217	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
8576023	8576023	PRJNA942359_P_NODE_5447_length_356_cov_1.197880_g5332_i0	PRJNA942359	5447	356	1.19788	4.2644528	Scenedesmus sp. PABB	2909984	Plants	Plants	229	5.89e-67	NR	KAF8071362.1	2742167	g5332	i0	95.7	4.8623595505618	116	5	97.8	0	352	5	2446	2561	KAF8071362.1 ABCC1 [Scenedesmus sp. PABB004]	diamond	1731	229	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
21325232	21325232	PRJNA942359_P_NODE_7457_length_314_cov_1.294606_g7342_i0	PRJNA942359	7457	314	1.294606	4.06506284	Scenedesmus	3087	Plants	Plants	203	1.66e-61	NR	KAF6266554.1	2650976	g7342	i0	93.3	1.98726114649682	104	7	99.4	0	313	2	159	262	KAF6266554.1 limiting CO2 inducible protein [Scenedesmus sp. NREL 46B-D3]	diamond	624	203	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
26961819	26961819	PRJNA942359_P_NODE_9202_length_289_cov_1.069444_g9087_i0	PRJNA942359	9202	289	1.069444	3.09069316	Scenedesmus sp. PABB	2909984	Plants	Plants	152	2.09e-40	NR	KAF8071362.1	2742167	g9087	i0	83.2	1.97231833910035	95	16	98.6	0	288	4	1729	1823	KAF8071362.1 ABCC1 [Scenedesmus sp. PABB004]	diamond	570	152	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
27379954	27379954	PRJNA942359_P_NODE_15823_length_249_cov_0.886364_g15708_i0	PRJNA942359	15823	249	0.886364	2.20704636	Trebouxia	13786	Plants	Plants	82.8	3.14e-16	NR	KAA6417838.1	2608996	g15708	i0	49.4	3.74698795180723	77	39	92.8	0	236	6	285	361	KAA6417838.1 MAG: anaphase-promoting complex subunit 2-like [Trebouxia sp. A1-2]	diamond	933	83.6	0.990430622009569	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
27404681	27404681	PRJNA942359_P_NODE_9383_length_287_cov_1.261682_g9268_i0	PRJNA942359	9383	287	1.261682	3.62102734	Scenedesmus sp. PABB	2909984	Plants	Plants	60.1	5.25e-8	NR	KAF8065444.1	2742167	g9268	i0	41.4	0.731707317073171	70	39	73.2	2	210	1	761	828	KAF8065444.1 40S ribosomal protein S3a [Scenedesmus sp. PABB004]	diamond	210	60.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
27467789	27467789	PRJNA942359_P_NODE_13683_length_252_cov_0.871508_g13568_i0	PRJNA942359	13683	252	0.871508	2.19620016	Chlorella variabilis	554065	Plants	Plants	66.2	1.05e-11	NR	XP_005843190.1	554065	g13568	i0	57.7	1.86904761904762	52	22	61.9	0	179	24	1	52	XP_005843190.1 hypothetical protein CHLNCDRAFT_141477 [Chlorella variabilis]	diamond	471	66.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
28105844	28105844	PRJNA942359_P_NODE_17065_length_247_cov_0.896552_g16950_i0	PRJNA942359	17065	247	0.896552	2.21448344	Chlorella	3071	Plants	Plants	46.6	0.00163	NR	PRW56026.1	3076	g16950	i0	39.5	1.84615384615385	76	41	86.2	2	16	228	57	132	PRW56026.1 methanol dehydrogenase [Chlorella sorokiniana]	diamond	456	46.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
28951867	28951867	PRJNA942359_P_NODE_19168_length_243_cov_1.435294_g19053_i0	PRJNA942359	19168	243	1.435294	3.48776442	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	73.9	2.89e-13	NR	KAF6266555.1	2650976	g19053	i0	75	0.592592592592593	48	12	59.3	0	243	100	304	351	KAF6266555.1 low-CO2-inducible chloroplast envelope protein [Scenedesmus sp. NREL 46B-D3]	diamond	144	73.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
29614370	29614370	PRJNA942359_P_NODE_7830_length_308_cov_1.991489_g7715_i0	PRJNA942359	7830	308	1.991489	6.13378612	Scenedesmus sp. PABB	2909984	Plants	Plants	200	5.129999999999999e-57	NR	KAF8059733.1	2742167	g7715	i0	96.1	1.98701298701299	102	4	99.4	0	306	1	81	182	KAF8059733.1 Slc25a29 [Scenedesmus sp. PABB004]	diamond	612	200	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
30183223	30183223	PRJNA942359_P_NODE_17372_length_246_cov_0.901734_g17257_i0	PRJNA942359	17372	246	0.901734	2.21826564	Scenedesmus sp. PABB	2909984	Plants	Plants	57	3.82e-7	NR	KAF8057672.1	2742167	g17257	i0	58.3	1.5609756097561	60	25	73.2	0	67	246	1124	1183	KAF8057672.1 Chlorophyll a-b binding protein of LHCII type I [Scenedesmus sp. PABB004]	diamond	384	57	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
31068101	31068101	PRJNA942359_P_NODE_19415_length_243_cov_0.917647_g19300_i0	PRJNA942359	19415	243	0.917647	2.22988221	Scenedesmus sp. PABB	2909984	Plants	Plants	95.9	7.45e-21	NR	KAF8061089.1	2742167	g19300	i0	77	0.91358024691358	74	16	91.4	1	20	241	1	73	KAF8061089.1 petC [Scenedesmus sp. PABB004]	diamond	222	95.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
31289044	31289044	PRJNA942359_P_NODE_8835_length_292_cov_1.748858_g8720_i0	PRJNA942359	8835	292	1.748858	5.10666536	Tetradesmus obliquus	3088	Plants	Plants	98.6	1.08e-21	NR	WIA16228.1	3088	g8720	i0	57.8	1.70547945205479	83	34	84.2	1	43	288	227	309	WIA16228.1 hypothetical protein OEZ85_012939 [Tetradesmus obliquus]	diamond	498	98.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
32680336	32680336	PRJNA942359_P_NODE_16300_length_248_cov_0.891429_g16185_i0	PRJNA942359	16300	248	0.891429	2.21074392	[Myrmecia] bisecta	41462	Plants	Plants	88.6	1.84e-19	NR	KAK9818236.1	41462	g16185	i0	52.4	0.991935483870968	82	39	99.2	0	248	3	47	128	KAK9818236.1 hypothetical protein WJX72_009208 [[Myrmecia] bisecta]	diamond	246	88.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta

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