metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA459724" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA459724" 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
22119588	22119588	PRJNA459724_S_NODE_38_length_414_cov_18.010554_g35_i0	PRJNA459724	38	414	18.010554	74.56369356	Tanacetum cinerariifolium	118510	Plants	Plants	183	1.9099999999999994e-55	NR	GFC09901.1	118510	g35	i0	66.9	1.61594202898551	136	18	98.6	1	6	413	85	193	GFC09901.1 ribosomal protein S3, chloroplastic [Tanacetum cinerariifolium]	diamond	669	183	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
26664340	26664340	PRJNA459724_S_NODE_961_length_203_cov_2.809524_g958_i0	PRJNA459724	961	203	2.809524	5.70333372	Lolium multiflorum	4521	Plants	Plants	46.2	0.00134	NR	KAK1612063.1	4521	g958	i0	31.8	1.95073891625616	66	44	96.1	1	1	195	932	997	KAK1612063.1 hypothetical protein QYE76_035736 [Lolium multiflorum]	diamond	396	46.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium multiflorum
28766008	28766008	PRJNA459724_S_NODE_207_length_279_cov_13.086066_g204_i0	PRJNA459724	207	279	13.086066	36.51012414	Magnoliopsida	3398	Plants	Plants	96.7	4.6200000000000005e-21	NR	KAG9147131.1	34254	g204	i0	67.2	6.17204301075269	61	20	65.6	0	22	204	288	348	KAG9147131.1 hypothetical protein Leryth_005363 [Lithospermum erythrorhizon]	diamond	1722	96.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Boraginales	Boraginaceae	Lithospermum	Lithospermum erythrorhizon
29223703	29223703	PRJNA459724_S_NODE_2389_length_161_cov_2.642857_g2386_i0	PRJNA459724	2389	161	2.642857	4.25499977	Cryptomeria japonica	3369	Plants	Plants	47.4	2.83e-4	NR	XP_059072122.1	3369	g2386	i0	91.7	0.447204968944099	24	2	44.7	0	150	79	383	406	XP_059072122.1 uncharacterized protein LOC131872743 [Cryptomeria japonica]	diamond	72	47.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
29318165	29318165	PRJNA459724_S_NODE_2949_length_152_cov_5.085470_g2946_i0	PRJNA459724	2949	152	5.08547	7.7299144	Magnolia sinica	86752	Plants	Plants	41.6	0.0243	NR	XP_058085871.1	86752	g2946	i0	52.3	0.868421052631579	44	21	86.8	0	151	20	164	207	XP_058085871.1 large ribosomal subunit protein eL13z-like [Magnolia sinica]	diamond	132	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Magnoliales	Magnoliaceae	Magnolia	Magnolia sinica
29791678	29791678	PRJNA459724_S_NODE_91_length_329_cov_4.945578_g88_i0	PRJNA459724	91	329	4.945578	16.27095162	Olea europaea subsp. europaea	158383	Plants	Plants	75.5	4.45e-14	NR	CAA3006499.1	158383	g88	i0	51.6	0.583586626139818	64	31	58.4	0	328	137	145	208	CAA3006499.1 soma ferritin-like [Olea europaea subsp. europaea]	diamond	192	75.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Olea	Olea europaea
30013098	30013098	PRJNA459724_S_NODE_2191_length_164_cov_13.790698_g2188_i0	PRJNA459724	2191	164	13.790698	22.61674472	Capsicum annuum	4072	Plants	Plants	53.1	2.69e-6	NR	KAF3669979.1	4072	g2188	i0	88.5	1.07926829268293	26	3	47.6	0	2	79	128	153	KAF3669979.1 putative glycerol-3-phosphate 2-O-acyltransferase 6-like [Capsicum annuum]	diamond	177	53.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Capsicum	Capsicum annuum

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