metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA724039" 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
711008	711008	PRJNA724039_S_NODE_10301_length_202_cov_2.230303_g10094_i0	PRJNA724039	10301	202	2.230303	4.50521206	[Myrmecia] bisecta	41462	Plants	Plants	93.6	9.53e-22	NR	KAK9817689.1	41462	g10094	i0	80	1.67821782178218	55	11	81.7	0	21	185	154	208	KAK9817689.1 hypothetical protein WJX72_000657 [[Myrmecia] bisecta]	diamond	339	93.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
29147175	29147175	PRJNA724039_S_NODE_10749_length_197_cov_1.943750_g10542_i0	PRJNA724039	10749	197	1.94375	3.8291875	Cladophorales	3183	Plants	Plants	92	1.68e-21	NR	ADB77798.1	34128	g10542	i0	66.7	2.86294416243655	63	21	95.9	0	195	7	67	129	ADB77798.1 40S ribosomal protein S9, partial [Cladophora coelothrix]	diamond	564	92	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Cladophorales	Cladophoraceae	Cladophora	Cladophora coelothrix
29367909	29367909	PRJNA724039_S_NODE_10969_length_195_cov_1.411392_g10762_i0	PRJNA724039	10969	195	1.411392	2.7522144	Eukaryota	2759	Plants	Plants	82	6.98e-17	NR	RMZ56279.1	3075	g10762	i0	64.7	26.3538461538462	68	20	98.5	1	194	3	85	152	RMZ56279.1 hypothetical protein APUTEX25_002469, partial [Auxenochlorella protothecoides]	diamond	5139	82.4	0.995145631067961	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
29494138	29494138	PRJNA724039_S_NODE_16530_length_157_cov_1.208333_g16323_i0	PRJNA724039	16530	157	1.208333	1.89708281	Eukaryota	2759	Plants	Plants	80.9	2.85e-17	NR	XP_011397165.1	3075	g16323	i0	78	5.48407643312102	50	11	95.5	0	156	7	137	186	XP_011397165.1 40S ribosomal protein S8 [Auxenochlorella protothecoides]	diamond	861	80.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides

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