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

4 rows where analysis = "diamond", bioproject = "PRJNA383995" and tax_phylum = "Streptophyta"

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
29253885	29253885	PRJNA383995_P_NODE_6869_length_244_cov_1.041026_g6770_i0	PRJNA383995	6869	244	1.041026	2.54010344	Tarenaya hassleriana	28532	Plants	Plants	45.8	0.00199	NR	XP_010548418.1	28532	g6770	i0	37.2	0.959016393442623	78	39	92.2	3	237	13	100	170	XP_010548418.1 PREDICTED: protein DCL, chloroplastic-like [Tarenaya hassleriana]	diamond	234	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Cleomaceae	Tarenaya	Tarenaya hassleriana
29411887	29411887	PRJNA383995_P_NODE_17749_length_163_cov_0.894737_g17650_i0	PRJNA383995	17749	163	0.894737	1.45842131	Vitis vinifera	29760	Plants	Plants	63.5	5.8e-10	NR	RVW92637.1	29760	g17650	i0	64.3	5.50306748466258	42	15	77.3	0	1	126	722	763	RVW92637.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Vitis vinifera]	diamond	897	63.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
30265060	30265060	PRJNA383995_P_NODE_12392_length_187_cov_0.978261_g12293_i0	PRJNA383995	12392	187	0.978261	1.82934807	Oryza sativa Japonica Group	39947	Plants	Plants	52.8	5.26e-6	NR	BAF23632.1	39947	g12293	i0	46.8	2.82352941176471	47	25	75.4	0	142	2	286	332	BAF23632.1 Os08g0389500 [Oryza sativa Japonica Group]	diamond	528	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
30391588	30391588	PRJNA383995_P_NODE_15393_length_167_cov_0.864407_g15294_i0	PRJNA383995	15393	167	0.864407	1.44355969	Oryza meyeriana var. granulata	110450	Plants	Plants	41.6	0.014	NR	KAF0896620.1	110450	g15294	i0	46.8	0.844311377245509	47	24	84.4	1	163	23	14	59	KAF0896620.1 hypothetical protein E2562_026320 [Oryza meyeriana var. granulata]	diamond	141	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza meyeriana

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