metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA534016" 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
18969776	18969776	PRJNA534016_P_NODE_15355_length_247_cov_1.804598_g15265_i0	PRJNA534016	15355	247	1.804598	4.45735706	Micractinium conductrix	554055	Plants	Plants	105	4.55e-24	NR	PSC76970.1	554055	g15265	i0	65.9	0.995951417004049	82	27	99.6	1	2	247	456	536	PSC76970.1 sodium phosphate symporter [Micractinium conductrix]	diamond	246	105	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium conductrix
27804498	27804498	PRJNA534016_P_NODE_17604_length_242_cov_1.822485_g17514_i0	PRJNA534016	17604	242	1.822485	4.4104137	Trebouxia sp. A1-2	2608996	Plants	Plants	135	1.2899999999999998e-35	NR	KAA6418338.1	2608996	g17514	i0	75	0.991735537190083	80	20	99.2	0	241	2	344	423	KAA6418338.1 MAG: cystathionine gamma-synthase [Trebouxia sp. A1-2]	diamond	240	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
28703418	28703418	PRJNA534016_P_NODE_14527_length_249_cov_1.375000_g14437_i0	PRJNA534016	14527	249	1.375	3.42375	Chlorophyceae	3166	Plants	Plants	125	4.32e-31	NR	XP_042915459.1	3055	g14437	i0	70.7	4.93975903614458	82	24	98.8	0	248	3	410	491	XP_042915459.1 uncharacterized protein CHLRE_16g652150v5 [Chlamydomonas reinhardtii]	diamond	1230	125	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
29113876	29113876	PRJNA534016_P_NODE_19248_length_216_cov_4.426573_g19158_i0	PRJNA534016	19248	216	4.426573	9.56139768	root	1	Root_unresolved	Root_unresolved	63.5	1.19e-9	NR	WIA19435.1	3088	g19158	i0	45.6	2.79166666666667	68	37	94.4	0	12	215	648	715	WIA19435.1 hypothetical protein OEZ85_004052 [Tetradesmus obliquus]	diamond	603	63.9	0.993740219092332	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
30488570	30488570	PRJNA534016_P_NODE_16013_length_246_cov_0.890173_g15923_i0	PRJNA534016	16013	246	0.890173	2.18982558	Raphidocelis subcapitata	307507	Plants	Plants	50.1	6.94e-5	NR	GBF91575.1	307507	g15923	i0	41	1.01219512195122	83	30	98.8	3	244	2	23	88	GBF91575.1 60S ribosomal protein L6 [Raphidocelis subcapitata]	diamond	249	50.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
30724599	30724599	PRJNA534016_P_NODE_8214_length_296_cov_1.035874_g8124_i0	PRJNA534016	8214	296	1.035874	3.06618704	Eukaryota	2759	Plants	Plants	140	1.97e-39	NR	GAX80988.1	1157962	g8124	i0	66.3	2.95945945945946	98	30	99.3	1	2	295	84	178	GAX80988.1 hypothetical protein CEUSTIGMA_g8423.t1 [Chlamydomonas eustigma]	diamond	876	140	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
31025763	31025763	PRJNA534016_P_NODE_16715_length_244_cov_2.140351_g16625_i0	PRJNA534016	16715	244	2.140351	5.22245644	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	87.8	5.37e-18	NR	KAG1668955.1	1653778	g16625	i0	59.2	1.86885245901639	76	27	93.4	2	240	13	535	606	KAG1668955.1 hypothetical protein FOA52_000999 [Chlamydomonas sp. UWO 241]	diamond	456	87.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241

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