metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA683902" 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
5768897	5768897	PRJNA683902_S_NODE_24485_length_206_cov_1.319527_g24041_i0	PRJNA683902	24485	206	1.319527	2.71822562	Chlorophyta	3041	Plants	Plants	97.8	4e-23	NR	KAF6263477.1	2650976	g24041	i0	67.6	2.97087378640777	68	22	99	0	205	2	164	231	KAF6263477.1 60S ribosomal protein L7 [Scenedesmus sp. NREL 46B-D3]	diamond	612	97.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
14694318	14694318	PRJNA683902_S_NODE_33192_length_167_cov_3.123077_g32748_i0	PRJNA683902	33192	167	3.123077	5.21553859	Chlamydomonadales	3042	Plants	Plants	75.9	1.96e-14	NR	KXZ53664.1	33097	g32748	i0	71.1	4.63473053892216	45	13	80.8	0	165	31	263	307	KXZ53664.1 hypothetical protein GPECTOR_6g581 [Gonium pectorale]	diamond	774	76.3	0.99475753604194	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale
27788846	27788846	PRJNA683902_S_NODE_31144_length_174_cov_2.357664_g30700_i0	PRJNA683902	31144	174	2.357664	4.10233536	Eukaryota	2759	Plants	Plants	44.3	0.00192	NR	PRW34016.1	3076	g30700	i0	79.2	4.94827586206897	24	5	41.4	0	172	101	120	143	PRW34016.1 60S ribosomal L23A [Chlorella sorokiniana]	diamond	861	44.7	0.991051454138702	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
28609696	28609696	PRJNA683902_S_NODE_27667_length_188_cov_5.834437_g27223_i0	PRJNA683902	27667	188	5.834437	10.96874156	Chlamydomonas	3052	Plants	Plants	47	5.8e-4	NR	XP_042923264.1	3055	g27223	i0	40.4	1.81914893617021	57	32	91	1	3	173	566	620	XP_042923264.1 uncharacterized protein CHLRE_07g358001v5 [Chlamydomonas reinhardtii]	diamond	342	47	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
29556741	29556741	PRJNA683902_S_NODE_37290_length_156_cov_1.966387_g36846_i0	PRJNA683902	37290	156	1.966387	3.06756372	Eukaryota	2759	Plants	Plants	46.2	5.59e-4	NR	KAF5836938.1	3046	g36846	i0	51	6.26923076923077	49	22	90.4	1	150	10	7	55	KAF5836938.1 ribosomal protein L10a component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina]	diamond	978	46.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
31104709	31104709	PRJNA683902_S_NODE_8795_length_531_cov_2.619433_g8372_i0	PRJNA683902	8795	531	2.619433	13.90918923	Chlorophyta	3041	Plants	Plants	231	1.74e-66	NR	PRW20811.1	3076	g8372	i0	69.6	7.41242937853107	148	45	83.6	0	529	86	172	319	PRW20811.1 Receptor of activated kinase C component of 40S small ribosomal subunit isoform C [Chlorella sorokiniana]	diamond	3936	232	0.995689655172414	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);;