metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA453111" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA453111" 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
26823072	26823072	PRJNA453111_P_NODE_5401_length_348_cov_1.120000_g5309_i0	PRJNA453111	5401	348	1.12	3.8976	Triticum aestivum	4565	Plants	Plants	132	2.77e-35	NR	KAF7093009.1	4565	g5309	i0	62.1	2	116	29	94.8	2	2	331	171	277	KAF7093009.1 hypothetical protein CFC21_095447 [Triticum aestivum]	diamond	696	132	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
27076098	27076098	PRJNA453111_P_NODE_7902_length_288_cov_0.972093_g7810_i0	PRJNA453111	7902	288	0.972093	2.79962784	Zea mays	4577	Plants	Plants	54.7	2.24e-7	NR	ACG36876.1	4577	g7810	i0	56.3	0.5	48	21	50	0	117	260	12	59	ACG36876.1 40S ribosomal protein S29 [Zea mays]	diamond	144	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
27202324	27202324	PRJNA453111_P_NODE_11382_length_247_cov_0.885057_g11290_i0	PRJNA453111	11382	247	0.885057	2.18609079	Triticum aestivum	4565	Plants	Plants	57.4	2.93e-8	NR	XBI49792.1	4565	g11290	i0	65.1	1.06882591093117	43	15	52.2	0	69	197	26	68	XBI49792.1 hypothetical protein VPH35_113299 [Triticum aestivum]	diamond	264	57.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
27202326	27202326	PRJNA453111_P_NODE_12502_length_243_cov_0.905882_g12410_i0	PRJNA453111	12502	243	0.905882	2.20129326	Adiantum nelumboides	2759587	Plants	Plants	62	3.31e-10	NR	MCO5551981.1	2759587	g12410	i0	78.9	0.469135802469136	38	8	46.9	0	239	126	71	108	MCO5551981.1 hypothetical protein [Adiantum nelumboides]	diamond	114	62	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
27423977	27423977	PRJNA453111_P_NODE_12743_length_242_cov_0.911243_g12651_i0	PRJNA453111	12743	242	0.911243	2.20520806	Alopecurus aequalis	114194	Plants	Plants	119	5.750000000000001e-29	NR	CAM0954217.1	114194	g12651	i0	67.1	0.979338842975207	79	26	97.9	0	239	3	5	83	CAM0954217.1 unnamed protein product [Alopecurus aequalis]	diamond	237	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Alopecurus	Alopecurus aequalis
27960476	27960476	PRJNA453111_P_NODE_8985_length_268_cov_1.558974_g8893_i0	PRJNA453111	8985	268	1.558974	4.17805032	Camellia sinensis	4442	Plants	Plants	105	7.130000000000001e-27	NR	KAF5949990.1	4442	g8893	i0	100	0.638059701492537	57	0	63.8	0	2	172	54	110	KAF5949990.1 hypothetical protein HYC85_011983 [Camellia sinensis]	diamond	171	105	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
28212830	28212830	PRJNA453111_P_NODE_10686_length_249_cov_0.875000_g10594_i0	PRJNA453111	10686	249	0.875	2.17875	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	76.6	4.86e-14	NR	BAK02651.1	112509	g10594	i0	69.2	0.783132530120482	65	16	78.3	2	201	7	1338	1398	BAK02651.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	195	76.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
28655211	28655211	PRJNA453111_P_NODE_8147_length_284_cov_1.018957_g8055_i0	PRJNA453111	8147	284	1.018957	2.89383788	Cajanus cajan	3821	Plants	Plants	46.6	0.00269	NR	XP_020212151.1	3821	g8055	i0	43.5	1.90140845070423	62	27	64.4	3	191	9	699	753	XP_020212151.1 DEAD-box ATP-dependent RNA helicase 3, chloroplastic [Cajanus cajan]	diamond	540	46.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Cajanus	Cajanus cajan
29097274	29097274	PRJNA453111_P_NODE_12308_length_244_cov_0.900585_g12216_i0	PRJNA453111	12308	244	0.900585	2.1974274	Spirodela intermedia	51605	Plants	Plants	44.3	0.0111	NR	CAA7408040.1	51605	g12216	i0	65.6	0.39344262295082	32	11	39.3	0	86	181	11	42	CAA7408040.1 unnamed protein product [Spirodela intermedia]	diamond	96	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Alismatales	Araceae	Spirodela	Spirodela intermedia
29412767	29412767	PRJNA453111_P_NODE_12289_length_244_cov_0.900585_g12197_i0	PRJNA453111	12289	244	0.900585	2.1974274	Camellia sinensis var. sinensis	542762	Plants	Plants	105	8.27e-28	NR	GMP72624.1	542762	g12197	i0	96.6	0.713114754098361	58	1	71.3	1	207	34	1	57	GMP72624.1 hypothetical protein CsSME_00030579 [Camellia sinensis var. sinensis]	diamond	174	105	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
30424031	30424031	PRJNA453111_P_NODE_10693_length_249_cov_0.875000_g10601_i0	PRJNA453111	10693	249	0.875	2.17875	Nicotiana attenuata	49451	Plants	Plants	77.4	5.41e-16	NR	OIS97416.1	49451	g10601	i0	92.3	0.469879518072289	39	3	47	0	17	133	92	130	OIS97416.1 hypothetical protein A4A49_09147 [Nicotiana attenuata]	diamond	117	77.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Nicotiana	Nicotiana attenuata
30865897	30865897	PRJNA453111_P_NODE_11614_length_246_cov_0.890173_g11522_i0	PRJNA453111	11614	246	0.890173	2.18982558	Nicotiana attenuata	49451	Plants	Plants	135	1.0299999999999998e-37	NR	OIT40487.1	49451	g11522	i0	84.5	1.02439024390244	84	7	95.1	1	235	2	30	113	OIT40487.1 hypothetical protein A4A49_26701 [Nicotiana attenuata]	diamond	252	135	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Nicotiana	Nicotiana attenuata
31149889	31149889	PRJNA453111_P_NODE_10295_length_250_cov_0.870056_g10203_i0	PRJNA453111	10295	250	0.870056	2.17514	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	117	1.67e-28	NR	BAK02651.1	112509	g10203	i0	68.3	0.984	82	26	98.4	0	250	5	1074	1155	BAK02651.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	246	117	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
31229573	31229573	PRJNA453111_P_NODE_11655_length_246_cov_0.890173_g11563_i0	PRJNA453111	11655	246	0.890173	2.18982558	Camellia	4441	Plants	Plants	87.8	4.48e-18	NR	CAL5333442.1	4442	g11563	i0	100	2.24390243902439	46	0	56.1	0	107	244	1	46	CAL5333442.1 unnamed protein product [Camellia sinensis]	diamond	552	87.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
31767422	31767422	PRJNA453111_P_NODE_12997_length_241_cov_0.916667_g12905_i0	PRJNA453111	12997	241	0.916667	2.20916747	Vigna	3913	Plants	Plants	55.1	1.65e-6	NR	KAG2409670.1	3914	g12905	i0	37.7	2.81327800829876	77	48	95.9	0	240	10	420	496	KAG2409670.1 LRR receptor-like serine/threonine-protein [Vigna angularis]	diamond	678	55.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna angularis
31782700	31782700	PRJNA453111_P_NODE_10377_length_250_cov_0.870056_g10285_i0	PRJNA453111	10377	250	0.870056	2.17514	Lolium perenne	4522	Plants	Plants	110	5.27e-26	NR	XP_051201072.1	4522	g10285	i0	63.8	0.96	80	28	94.8	1	239	3	346	425	XP_051201072.1 uncharacterized protein LOC127314607 [Lolium perenne]	diamond	240	110	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium perenne

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