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

7 rows where analysis = "diamond", bioproject = "PRJNA1074408" 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
7394258	7394258	PRJNA1074408_S_NODE_4446_length_220_cov_2.192090_g4316_i0	PRJNA1074408	4446	220	2.19209	4.822598	Quercus rubra	3512	Plants	Plants	105	4.9000000000000005e-27	NR	KAK4594626.1	3512	g4316	i0	79.4	0.927272727272727	68	14	92.7	0	12	215	78	145	KAK4594626.1 hypothetical protein RGQ29_018347 [Quercus rubra]	diamond	204	105	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
23143230	23143230	PRJNA1074408_S_NODE_1959_length_326_cov_1.356890_g1829_i0	PRJNA1074408	1959	326	1.35689	4.4234614	Xanthoceras sorbifolium	99658	Plants	Plants	197	9.24e-63	NR	KAH7571896.1	99658	g1829	i0	89	3.67177914110429	100	11	92	0	1	300	47	146	KAH7571896.1 hypothetical protein JRO89_XS04G0163900 [Xanthoceras sorbifolium]	diamond	1197	197	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Xanthoceras	Xanthoceras sorbifolium
26972452	26972452	PRJNA1074408_S_NODE_9562_length_153_cov_0.872727_g9432_i0	PRJNA1074408	9562	153	0.872727	1.33527231	Miscanthus lutarioriparius	422564	Plants	Plants	56.6	1.09e-8	NR	CAD6333030.1	422564	g9432	i0	90.3	0.607843137254902	31	2	60.8	1	27	119	72	101	CAD6333030.1 unnamed protein product [Miscanthus lutarioriparius]	diamond	93	56.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Miscanthus	Miscanthus lutarioriparius
29972648	29972648	PRJNA1074408_S_NODE_9771_length_152_cov_0.880734_g9641_i0	PRJNA1074408	9771	152	0.880734	1.33871568	Quercus rubra	3512	Plants	Plants	72.4	1.33e-14	NR	KAK4591633.1	3512	g9641	i0	80	0.986842105263158	50	10	98.7	0	3	152	6	55	KAK4591633.1 hypothetical protein RGQ29_016173 [Quercus rubra]	diamond	150	72.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
30667747	30667747	PRJNA1074408_S_NODE_1653_length_353_cov_2.322581_g1523_i0	PRJNA1074408	1653	353	2.322581	8.19871093	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	182	1.09e-50	NR	BAJ93702.1	112509	g1523	i0	73.5	0.994334277620397	117	30	98.6	1	1	348	712	828	BAJ93702.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	351	182	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
30730935	30730935	PRJNA1074408_S_NODE_6494_length_183_cov_1.028571_g6364_i0	PRJNA1074408	6494	183	1.028571	1.88228493	Castanea mollissima	60419	Plants	Plants	106	2.16e-25	NR	KAF3955261.1	60419	g6364	i0	98.2	0.934426229508197	57	1	93.4	0	183	13	373	429	KAF3955261.1 hypothetical protein CMV_019505 [Castanea mollissima]	diamond	171	106	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Castanea	Castanea mollissima
32027339	32027339	PRJNA1074408_S_NODE_9758_length_152_cov_0.880734_g9628_i0	PRJNA1074408	9758	152	0.880734	1.33871568	Oryza meyeriana var. granulata	110450	Plants	Plants	58.2	1.7e-8	NR	KAF0906313.1	110450	g9628	i0	58.1	2.38815789473684	43	18	84.9	0	8	136	126	168	KAF0906313.1 hypothetical protein E2562_009683 [Oryza meyeriana var. granulata]	diamond	363	58.2	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);;