metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA675638" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA675638" 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
27271576	27271576	PRJNA675638_P_NODE_17463_length_171_cov_0.918033_g17266_i0	PRJNA675638	17463	171	0.918033	1.56983643	Tripterygium wilfordii	458696	Plants	Plants	41.6	0.036	NR	XP_038690839.1	458696	g17266	i0	45.9	0.649122807017544	37	16	57.9	1	17	115	439	475	XP_038690839.1 pectinesterase [Tripterygium wilfordii]	diamond	111	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Celastrales	Celastraceae	Tripterygium	Tripterygium wilfordii
27346783	27346783	PRJNA675638_S_NODE_7923_length_166_cov_0.871795_g7861_i0	PRJNA675638	7923	166	0.871795	1.4471797	Pyrus	3766	Plants	Plants	69.3	5.35e-12	NR	XP_068323079.1	23211	g7861	i0	68.3	5.81927710843374	41	13	74.1	0	125	3	841	881	XP_068323079.1 uncharacterized protein [Pyrus communis]	diamond	966	69.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Pyrus	Pyrus communis
27650715	27650715	PRJNA675638_P_NODE_5384_length_292_cov_0.925926_g5187_i0	PRJNA675638	5384	292	0.925926	2.70370392	Genlisea aurea	192259	Plants	Plants	46.6	0.00308	NR	EPS72410.1	192259	g5187	i0	45	0.616438356164384	60	30	58.6	1	289	119	124	183	EPS72410.1 hypothetical protein M569_02332 [Genlisea aurea]	diamond	180	46.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Lentibulariaceae	Genlisea	Genlisea aurea
29197884	29197884	PRJNA675638_P_NODE_22169_length_161_cov_0.910714_g21972_i0	PRJNA675638	22169	161	0.910714	1.46624954	Dipteronia sinensis	43782	Plants	Plants	44.7	0.00215	NR	KAK3222347.1	43782	g21972	i0	55.3	0.708074534161491	38	17	70.8	0	143	30	49	86	KAK3222347.1 hypothetical protein Dsin_009372 [Dipteronia sinensis]	diamond	114	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Dipteronia	Dipteronia sinensis
30018921	30018921	PRJNA675638_P_NODE_14091_length_191_cov_0.753521_g13894_i0	PRJNA675638	14091	191	0.753521	1.43922511	Ilex paraguariensis	185542	Plants	Plants	41.6	0.0412	NR	CAK9164022.1	185542	g13894	i0	30.4	1.44502617801047	46	32	72.3	0	52	189	11	56	CAK9164022.1 unnamed protein product [Ilex paraguariensis]	diamond	276	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Aquifoliales	Aquifoliaceae	Ilex	Ilex paraguariensis
30587314	30587314	PRJNA675638_P_NODE_20853_length_163_cov_0.894737_g20656_i0	PRJNA675638	20853	163	0.894737	1.45842131	Taxus chinensis	29808	Plants	Plants	41.6	0.0331	NR	KAH9301279.1	29808	g20656	i0	52.8	0.662576687116564	36	17	66.3	0	118	11	369	404	KAH9301279.1 hypothetical protein KI387_012862 [Taxus chinensis]	diamond	108	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
31124234	31124234	PRJNA675638_P_NODE_21655_length_162_cov_0.902655_g21458_i0	PRJNA675638	21655	162	0.902655	1.4623011	Rosa chinensis	74649	Plants	Plants	83.2	6.77e-17	NR	XP_024164205.1	74649	g21458	i0	71.7	0.981481481481482	53	15	98.1	0	160	2	711	763	XP_024164205.1 uncharacterized protein LOC112171226 [Rosa chinensis]	diamond	159	83.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Rosa	Rosa chinensis
31504220	31504220	PRJNA675638_S_NODE_4876_length_204_cov_0.845161_g4814_i0	PRJNA675638	4876	204	0.845161	1.72412844	Lactuca sativa	4236	Plants	Plants	44.3	0.00635	NR	XP_023738923.1	4236	g4814	i0	33.3	0.794117647058823	54	33	75	1	48	200	224	277	XP_023738923.1 uncharacterized protein LOC111886920 [Lactuca sativa]	diamond	162	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Lactuca	Lactuca sativa
31820214	31820214	PRJNA675638_P_NODE_12297_length_203_cov_1.214286_g12100_i0	PRJNA675638	12297	203	1.214286	2.46500058	Vigna unguiculata	3917	Plants	Plants	47.4	2.28e-4	NR	QCD80736.1	3917	g12100	i0	46	1.44827586206897	50	26	72.4	1	43	189	67	116	QCD80736.1 hypothetical protein DEO72_LG2g1058 [Vigna unguiculata]	diamond	294	47.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna unguiculata

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