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

6 rows where analysis = "diamond", bioproject = "PRJNA396510" and tax_clade = "Embryophyta"

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
26617293	26617293	PRJNA396510_P_NODE_11061_length_182_cov_0.894737_g10992_i0	PRJNA396510	11061	182	0.894737	1.62842134	Magnoliopsida	3398	Plants	Plants	44.3	0.00478	NR	RVW99369.1	29760	g10992	i0	53.2	3.0989010989011	47	22	77.5	0	163	23	530	576	RVW99369.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Vitis vinifera]	diamond	564	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
26917195	26917195	PRJNA396510_P_NODE_5662_length_244_cov_1.041026_g5593_i0	PRJNA396510	5662	244	1.041026	2.54010344	Tarenaya hassleriana	28532	Plants	Plants	45.8	0.00199	NR	XP_010548418.1	28532	g5593	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
29285756	29285756	PRJNA396510_P_NODE_11089_length_181_cov_2.083333_g11020_i0	PRJNA396510	11089	181	2.083333	3.77083273	Adiantum nelumboides	2759587	Plants	Plants	53.9	1.73e-6	NR	MCO5553831.1	2759587	g11020	i0	53.8	16.3259668508287	39	18	64.6	0	119	3	60	98	MCO5553831.1 hypothetical protein [Adiantum nelumboides]	diamond	2955	53.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
30170011	30170011	PRJNA396510_P_NODE_15352_length_163_cov_0.894737_g15283_i0	PRJNA396510	15352	163	0.894737	1.45842131	Vitis vinifera	29760	Plants	Plants	63.5	5.8e-10	NR	RVW92637.1	29760	g15283	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
30801999	30801999	PRJNA396510_P_NODE_6294_length_233_cov_0.804348_g6225_i0	PRJNA396510	6294	233	0.804348	1.87413084	Triticum turgidum subsp. durum	4567	Plants	Plants	43.5	0.0174	NR	VAH95209.1	4567	g6225	i0	45.8	0.618025751072961	48	25	60.5	1	193	53	94	141	VAH95209.1 unnamed protein product [Triticum turgidum subsp. durum]	diamond	144	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum turgidum
32225187	32225187	PRJNA396510_P_NODE_10418_length_187_cov_0.978261_g10349_i0	PRJNA396510	10418	187	0.978261	1.82934807	Oryza sativa Japonica Group	39947	Plants	Plants	52.8	5.26e-6	NR	BAF23632.1	39947	g10349	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

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