metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1262902" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1262902" 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
1638309	1638309	PRJNA1262902_P_NODE_10782_length_244_cov_0.900585_g10740_i0	PRJNA1262902	10782	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	110	4.18e-26	NR	GEU28402.1	118510	g10740	i0	90.9	5.40983606557377	55	5	67.6	0	79	243	1	55	GEU28402.1 isocitrate lyase [Tanacetum cinerariifolium]	diamond	1320	110	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
6156744	6156744	PRJNA1262902_P_NODE_265_length_766_cov_2.183261_g229_i0	PRJNA1262902	265	766	2.183261	16.72377926	Melia azedarach	155640	Plants	Plants	365	3.05e-120	NR	KAJ4708482.1	155640	g229	i0	68	0.990861618798956	253	79	99.1	2	761	3	133	383	KAJ4708482.1 glyoxal oxidase-related protein [Melia azedarach]	diamond	759	365	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Meliaceae	Melia	Melia azedarach
20180077	20180077	PRJNA1262902_P_NODE_4596_length_284_cov_1.649289_g4554_i0	PRJNA1262902	4596	284	1.649289	4.68398076	Melia azedarach	155640	Plants	Plants	97.4	2.45e-23	NR	KAJ4724695.1	155640	g4554	i0	79.3	0.612676056338028	58	12	61.3	0	284	111	92	149	KAJ4724695.1 Pollen preferential protein [Melia azedarach]	diamond	174	97.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Meliaceae	Melia	Melia azedarach
27073854	27073854	PRJNA1262902_P_NODE_3922_length_296_cov_0.856502_g3880_i0	PRJNA1262902	3922	296	0.856502	2.53524592	Taxus chinensis	29808	Plants	Plants	57.4	2.64e-8	NR	KAH9318761.1	29808	g3880	i0	66.7	0.851351351351351	42	14	42.6	0	97	222	9	50	KAH9318761.1 hypothetical protein KI387_020530, partial [Taxus chinensis]	diamond	252	57.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
27123021	27123021	PRJNA1262902_P_NODE_6502_length_260_cov_1.208556_g6460_i0	PRJNA1262902	6502	260	1.208556	3.1422456	Eukaryota	2759	Plants	Plants	95.9	1.62e-23	NR	KAK4591186.1	3512	g6460	i0	64	2.94230769230769	86	31	99.2	0	2	259	5	90	KAK4591186.1 hypothetical protein RGQ29_021401 [Quercus rubra]	diamond	765	95.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
27200093	27200093	PRJNA1262902_P_NODE_12522_length_236_cov_2.539877_g12480_i0	PRJNA1262902	12522	236	2.539877	5.99410972	Solanum tuberosum	4113	Plants	Plants	97.1	1.93e-24	NR	KAH0717939.1	4113	g12480	i0	97.8	0.584745762711864	46	1	58.5	0	3	140	31	76	KAH0717939.1 hypothetical protein KY285_013970 [Solanum tuberosum]	diamond	138	97.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum tuberosum
28449904	28449904	PRJNA1262902_P_NODE_11646_length_242_cov_0.911243_g11604_i0	PRJNA1262902	11646	242	0.911243	2.20520806	Poaceae	4479	Plants	Plants	70.1	8.64e-12	NR	KAK1603597.1	4521	g11604	i0	42.7	12.1859504132231	82	45	99.2	1	242	3	826	907	KAK1603597.1 hypothetical protein QYE76_016371 [Lolium multiflorum]	diamond	2949	70.5	0.994326241134752	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium multiflorum
29112880	29112880	PRJNA1262902_P_NODE_1268_length_408_cov_1.379104_g1226_i0	PRJNA1262902	1268	408	1.379104	5.62674432	Asteraceae	4210	Plants	Plants	92	1.57e-21	NR	KAI7724547.1	4212	g1226	i0	67.9	4.67647058823529	53	17	39	0	3	161	25	77	KAI7724547.1 hypothetical protein M8C21_017721 [Ambrosia artemisiifolia]	diamond	1908	92.8	0.991379310344828	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Ambrosia	Ambrosia artemisiifolia
29789451	29789451	PRJNA1262902_P_NODE_5631_length_270_cov_1.548223_g5589_i0	PRJNA1262902	5631	270	1.548223	4.1802021	Sphagnum tenellum	128247	Plants	Plants	53.5	8.21e-6	NR	CAM6053934.1	128247	g5589	i0	40.4	0.988888888888889	89	51	98.9	2	268	2	501	587	CAM6053934.1 unnamed protein product [Sphagnum tenellum]	diamond	267	53.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum tenellum
30579176	30579176	PRJNA1262902_P_NODE_10413_length_245_cov_0.895349_g10371_i0	PRJNA1262902	10413	245	0.895349	2.19360505	Arctium lappa	4217	Plants	Plants	61.6	8.24e-9	NR	KAI3729056.1	4217	g10371	i0	35.9	1.1265306122449	92	35	91.8	2	242	18	206	290	KAI3729056.1 hypothetical protein L6452_17703 [Arctium lappa]	diamond	276	61.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Arctium	Arctium lappa
31843792	31843792	PRJNA1262902_P_NODE_5837_length_267_cov_4.144330_g5795_i0	PRJNA1262902	5837	267	4.14433	11.0653611	Mangifera indica	29780	Plants	Plants	47	4.47e-4	NR	XP_044462649.1	29780	g5795	i0	45.1	1.02247191011236	91	32	96.6	2	267	10	3	80	XP_044462649.1 nucleolar protein 56-like [Mangifera indica]	diamond	273	47	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Anacardiaceae	Mangifera	Mangifera indica
32368255	32368255	PRJNA1262902_P_NODE_8539_length_249_cov_0.875000_g8497_i0	PRJNA1262902	8539	249	0.875	2.17875	Eukaryota	2759	Plants	Plants	43.1	0.0072	NR	KAG4965941.1	3847	g8497	i0	50	1.2289156626506	38	19	45.8	0	123	236	38	75	KAG4965941.1 hypothetical protein JHK85_040916 [Glycine max]	diamond	306	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Glycine	Glycine max

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