metadata: contig_metadata: 10 rows where bioproject = "PRJNA485080" and tax

10 rows where bioproject = "PRJNA485080" 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
449484	449484	PRJNA485080_P_NODE_7001_length_377_cov_0.983553_g6907_i0	PRJNA485080	7001	377	0.983553	3.70799481	Chlorella variabilis	554065	Plants	Plants	394	5.18e-105	NTclustered	gi\|552833560\|ref\|XM_005848496.1\|	554065	g6907	i0	92.701	65.8461538461538	274	19	73	1	1	274	199	471	Chlorella variabilis hypothetical protein (CHLNCDRAFT_59661) mRNA, complete cds	blastn	24824	394	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
2372903	2372903	PRJNA485080_P_NODE_26542_length_249_cov_0.875000_g26448_i0	PRJNA485080	26542	249	0.875	2.17875	Chlorella variabilis	554065	Plants	Plants	102	1.2299999999999997e-23	NR	XP_005851680.1	554065	g26448	i0	87.9	1.39759036144578	58	7	69.9	0	2	175	360	417	XP_005851680.1 hypothetical protein CHLNCDRAFT_29144 [Chlorella variabilis]	diamond	348	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
4276124	4276124	PRJNA485080_P_NODE_22104_length_251_cov_0.865169_g22010_i0	PRJNA485080	22104	251	0.865169	2.17157419	Pseudopediastrum integrum	271402	Plants	Plants	56.5	0.002	NTclustered	gi\|1418583254\|ref\|NC_037921.1\|	271402	g22010	i0	100	0.119521912350598	30	0	12	0	93	122	13679	13650	Pseudopediastrum integrum voucher ACOI 577 chloroplast, complete genome	blastn	30	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Hydrodictyaceae	Pseudopediastrum	Pseudopediastrum integrum
10653077	10653077	PRJNA485080_P_NODE_44049_length_207_cov_4.873134_g43955_i0	PRJNA485080	44049	207	4.873134	10.08738738	Chlamydomonas reinhardtii	3055	Plants	Plants	130	8.13e-26	NTclustered	gi\|2082241745\|ref\|XM_001697474.2\|	3055	g43955	i0	92.308	43.9661835748792	91	7	44	0	1	91	697	787	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g156900v5), mRNA	blastn	9101	130	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
11927690	11927690	PRJNA485080_P_NODE_18530_length_269_cov_2.219388_g18436_i0	PRJNA485080	18530	269	2.219388	5.97015372	Eukaryota	2759	Plants	Plants	147	6.36e-39	NR	KAI3437883.1	3077	g18436	i0	75	17.7323420074349	88	22	98.1	0	2	265	203	290	KAI3437883.1 hypothetical protein D9Q98_000328 [Chlorella vulgaris]	diamond	4770	148	0.993243243243243	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
15751709	15751709	PRJNA485080_P_NODE_18253_length_271_cov_1.555556_g18159_i0	PRJNA485080	18253	271	1.555556	4.21555676	Chlorella ohadii	2649997	Plants	Plants	158	5.12e-34	NTclustered	gi\|1756037927\|gb\|MK086142.1\|	2649997	g18159	i0	84.713	0.579335793357934	157	24	58	0	115	271	423	267	Chlorella ohadii chloroplast photosystem II 10 kDa protein mRNA, complete cds; nuclear gene for chloroplast product	blastn	157	158	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
24675245	24675245	PRJNA485080_P_NODE_32100_length_246_cov_0.890173_g32006_i0	PRJNA485080	32100	246	0.890173	2.18982558	Chlorella variabilis	554065	Plants	Plants	254	5.68e-63	NTclustered	gi\|552831256\|ref\|XM_005848026.1\|	554065	g32006	i0	85.656	18.3861788617886	244	31	98	4	5	246	445	204	Chlorella variabilis hypothetical protein (CHLNCDRAFT_30965) mRNA, complete cds	blastn	4523	254	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
27060767	27060767	PRJNA485080_P_NODE_30042_length_247_cov_0.885057_g29948_i0	PRJNA485080	30042	247	0.885057	2.18609079	Chlorophyta	3041	Plants	Plants	65.9	2e-10	NR	KAJ9528545.1	44745	g29948	i0	45.5	3.86234817813765	77	41	93.5	1	5	235	54	129	KAJ9528545.1 hypothetical protein QJQ45_020474 [Haematococcus lacustris]	diamond	954	65.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
28323995	28323995	PRJNA485080_P_NODE_37346_length_244_cov_0.900585_g37252_i0	PRJNA485080	37346	244	0.900585	2.1974274	Trebouxia	13786	Plants	Plants	114	1.8e-27	NR	KAL0032166.1	2905653	g37252	i0	74.4	2.87704918032787	78	19	95.9	1	234	1	633	709	KAL0032166.1 hypothetical protein WJX77_008567 [Trebouxia sp. C0004]	diamond	702	114	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
28844602	28844602	PRJNA485080_P_NODE_29288_length_248_cov_0.880000_g29194_i0	PRJNA485080	29288	248	0.88	2.1824	Chlorella variabilis	554065	Plants	Plants	59.3	5.67e-8	NR	XP_005851108.1	554065	g29194	i0	45.1	0.991935483870968	82	39	99.2	2	246	1	397	472	XP_005851108.1 hypothetical protein CHLNCDRAFT_49822 [Chlorella variabilis]	diamond	246	59.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis

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