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

6 rows where analysis = "diamond", bioproject = "PRJNA771359" 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
9675456	9675456	PRJNA771359_S_NODE_1688_length_258_cov_2.235294_g1605_i0	PRJNA771359	1688	258	2.235294	5.76705852	Eukaryota	2759	Plants	Plants	104	3.41e-25	NR	RMZ56279.1	3075	g1605	i0	64.7	4.01162790697674	85	24	98.8	1	257	3	111	189	RMZ56279.1 hypothetical protein APUTEX25_002469, partial [Auxenochlorella protothecoides]	diamond	1035	104	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
17325336	17325336	PRJNA771359_S_NODE_1114_length_315_cov_2.629496_g1031_i0	PRJNA771359	1114	315	2.629496	8.2829124	Eukaryota	2759	Plants	Plants	145	1.12e-41	NR	KAK2079457.1	3111	g1031	i0	75.6	7.71428571428571	90	22	85.7	0	2	271	115	204	KAK2079457.1 60S ribosomal protein L15-2 [Prototheca wickerhamii]	diamond	2430	146	0.993150684931507	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
28357560	28357560	PRJNA771359_S_NODE_3446_length_181_cov_1.590278_g3363_i0	PRJNA771359	3446	181	1.590278	2.87840318	Eukaryota	2759	Plants	Plants	101	1.11e-25	NR	PRW56328.1	3076	g3363	i0	87	3.58011049723757	54	7	89.5	0	181	20	97	150	PRW56328.1 cyclophilin [Chlorella sorokiniana]	diamond	648	102	0.990196078431373	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
30284446	30284446	PRJNA771359_S_NODE_2692_length_204_cov_2.712575_g2609_i0	PRJNA771359	2692	204	2.712575	5.533653	Eukaryota	2759	Plants	Plants	85.1	5.6e-18	NR	CAG9462634.1	765719	g2609	i0	60.6	1.94117647058824	66	26	97.1	0	199	2	187	252	CAG9462634.1 unnamed protein product [Pedinophyceae sp. YPF-701]	diamond	396	85.9	0.990686845168801	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				Pedinophyceae sp. YPF-701
31706334	31706334	PRJNA771359_S_NODE_2377_length_217_cov_2.805556_g2294_i0	PRJNA771359	2377	217	2.805556	6.08805652	Chlorellaceae	35461	Plants	Plants	106	3.35e-25	NR	RMZ52209.1	3075	g2294	i0	68.6	4.83870967741935	70	22	96.8	0	212	3	40	109	RMZ52209.1 hypothetical protein APUTEX25_001599 [Auxenochlorella protothecoides]	diamond	1050	107	0.990654205607477	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
32276062	32276062	PRJNA771359_S_NODE_2538_length_210_cov_2.456647_g2455_i0	PRJNA771359	2538	210	2.456647	5.1589587	Chlorophyceae	3166	Plants	Plants	102	2.23e-24	NR	AEO44580.1	3046	g2455	i0	64.3	4	70	22	100	1	1	210	138	204	AEO44580.1 receptor for activated C kinase 1 [Dunaliella salina]	diamond	840	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina

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