metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1199330" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1199330" 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
1600377	1600377	PRJNA1199330_P_NODE_48402_length_309_cov_0.991525_g47703_i0	PRJNA1199330	48402	309	0.991525	3.06381225	Chlorella variabilis	554065	Plants	Plants	351	2.54e-92	NTclustered	gi\|552832044\|ref\|XM_005848193.1\|	554065	g47703	i0	87.46	19.9676375404531	311	31	99	6	2	308	489	795	Chlorella variabilis hypothetical protein (CHLNCDRAFT_35097) mRNA, complete cds	blastn	6170	351	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
4152592	4152592	PRJNA1199330_P_NODE_42484_length_316_cov_0.962963_g41785_i0	PRJNA1199330	42484	316	0.962963	3.04296308	Chlorella ohadii	2649997	Plants	Plants	584	2.359999999999999e-162	NTclustered	gi\|2818376113\|gb\|PQ455547.1\|	2649997	g41785	i0	100	95.2689873417721	316	0	100	0	1	316	604	289	Chlorella ohadii Lhcb chlorophyll a/b-binding protein (Lhcbm) mRNA, complete cds	blastn	30105	584	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
10528786	10528786	PRJNA1199330_P_NODE_109469_length_247_cov_0.896552_g108770_i0	PRJNA1199330	109469	247	0.896552	2.21448344	Chlorella variabilis	554065	Plants	Plants	209	1.25e-49	NTclustered	gi\|552841867\|ref\|XM_005850363.1\|	554065	g108770	i0	95.42	8.17004048582996	131	6	53	0	1	131	182	312	Chlorella variabilis hypothetical protein (CHLNCDRAFT_20596) mRNA, complete cds	blastn	2018	209	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
10529070	10529070	PRJNA1199330_P_NODE_18149_length_480_cov_1.656020_g17455_i0	PRJNA1199330	18149	480	1.65602	7.948896	Chlorella variabilis	554065	Plants	Plants	684	0	NTclustered	gi\|552834565\|ref\|XM_005848699.1\|	554065	g17455	i0	92.469	70.4958333333333	478	36	99	0	3	480	655	178	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59648) mRNA, complete cds	blastn	33838	684	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
13079771	13079771	PRJNA1199330_P_NODE_82871_length_270_cov_1.583756_g82172_i0	PRJNA1199330	82871	270	1.583756	4.2761412	Chlorella variabilis	554065	Plants	Plants	409	1.27e-109	NTclustered	gi\|552813385\|ref\|XM_005843877.1\|	554065	g82172	i0	95	29.3814814814815	260	13	96	0	1	260	1125	1384	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds	blastn	7933	409	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
14355033	14355033	PRJNA1199330_P_NODE_73312_length_279_cov_1.135922_g72613_i0	PRJNA1199330	73312	279	1.135922	3.16922238	Chlorella variabilis	554065	Plants	Plants	335	2.2799999999999993e-87	NTclustered	gi\|552843894\|ref\|XM_005850894.1\|	554065	g72613	i0	88.489	0.996415770609319	278	30	99	2	2	278	257	533	Chlorella variabilis hypothetical protein (CHLNCDRAFT_29874) mRNA, complete cds	blastn	278	335	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
23277241	23277241	PRJNA1199330_P_NODE_116159_length_242_cov_0.923077_g115460_i0	PRJNA1199330	116159	242	0.923077	2.23384634	Chlorella ohadii	2649997	Plants	Plants	235	2.02e-57	NTclustered	gi\|2818374389\|gb\|PQ455546.1\|	2649997	g115460	i0	98.496	0.549586776859504	133	2	55	0	107	239	1	133	Chlorella ohadii PsbO2 (PsbO2) mRNA, complete cds	blastn	133	235	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
25270490	25270490	PRJNA1199330_P_NODE_36440_length_343_cov_1.140741_g35741_i0	PRJNA1199330	36440	343	1.140741	3.91274163	root	1	Root_unresolved	Root_unresolved	634	2.5299999999999996e-177	NTclustered	gi\|669174894\|gb\|KJ742376.1\|	3076	g35741	i0	100	112.743440233236	343	0	100	0	1	343	47148	47490	Chlorella sorokiniana isolate 1230 chloroplast, complete genome	blastn	38671	634	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana

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