metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA859990" 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
4674375	4674375	PRJNA859990_S_NODE_22284_length_241_cov_0.875000_g22023_i0	PRJNA859990	22284	241	0.875	2.10875	Acer	4022	Plants	Plants	154	2.99e-41	NR	KAK4835556.1	4023	g22023	i0	96.3	33.8589211618257	80	3	99.6	0	240	1	727	806	KAK4835556.1 hypothetical protein QYF36_011335 [Acer negundo]	diamond	8160	154	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Acer	Acer negundo
11049575	11049575	PRJNA859990_S_NODE_21769_length_242_cov_0.911243_g21508_i0	PRJNA859990	21769	242	0.911243	2.20520806	Xanthoceras sorbifolium	99658	Plants	Plants	110	5.39e-26	NR	KAH7571721.1	99658	g21508	i0	96.4	0.681818181818182	55	2	68.2	0	3	167	333	387	KAH7571721.1 hypothetical protein JRO89_XS04G0125500 [Xanthoceras sorbifolium]	diamond	165	110	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Xanthoceras	Xanthoceras sorbifolium
25072041	25072041	PRJNA859990_S_NODE_20880_length_244_cov_0.865497_g20619_i0	PRJNA859990	20880	244	0.865497	2.11181268	Acer	4022	Plants	Plants	162	3.08e-44	NR	KAI9198424.1	4023	g20619	i0	98.8	37.3770491803279	80	1	98.4	0	242	3	528	607	KAI9198424.1 hypothetical protein LWI28_015596 [Acer negundo]	diamond	9120	162	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Acer	Acer negundo
28097332	28097332	PRJNA859990_S_NODE_15005_length_270_cov_0.939086_g14744_i0	PRJNA859990	15005	270	0.939086	2.5355322	Populus alba x Populus x berolinensis	444605	Plants	Plants	42.4	0.0209	NR	KAJ6934225.1	444605	g14744	i0	36.2	0.644444444444444	58	30	64.4	2	68	241	6	56	KAJ6934225.1 hypothetical protein NC651_009310 [Populus alba x Populus x berolinensis]	diamond	174	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus alba x Populus x berolinensis
28168715	28168715	PRJNA859990_S_NODE_19485_length_247_cov_0.885057_g19224_i0	PRJNA859990	19485	247	0.885057	2.18609079	Dipterocarpaceae	40588	Plants	Plants	45.4	0.00245	NR	GLT46258.1	152420	g19224	i0	56.6	1.28744939271255	53	18	58.3	1	12	155	1	53	GLT46258.1 hypothetical protein SLA2020_200290 [Shorea laevis]	diamond	318	45.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Dipterocarpaceae	Shorea	Shorea laevis
28886625	28886625	PRJNA859990_S_NODE_23468_length_219_cov_5.787671_g23207_i0	PRJNA859990	23468	219	5.787671	12.67499949	Vigna unguiculata	3917	Plants	Plants	50.4	5.08e-5	NR	QCD79657.1	3917	g23207	i0	92.3	0.356164383561644	26	2	35.6	0	218	141	8	33	QCD79657.1 hypothetical protein DEO72_LG1g3304 [Vigna unguiculata]	diamond	78	50.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna unguiculata
29076345	29076345	PRJNA859990_S_NODE_22248_length_241_cov_0.904762_g21987_i0	PRJNA859990	22248	241	0.904762	2.18047642	Rubroshorea leprosula	152421	Plants	Plants	44.7	0.00778	NR	GKV02945.1	152421	g21987	i0	44.4	5.37759336099585	54	25	61	1	228	82	464	517	GKV02945.1 hypothetical protein SLEP1_g15319 [Rubroshorea leprosula]	diamond	1296	44.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Dipterocarpaceae	Rubroshorea	Rubroshorea leprosula
30371494	30371494	PRJNA859990_S_NODE_23312_length_224_cov_4.847682_g23051_i0	PRJNA859990	23312	224	4.847682	10.85880768	Trifolium pratense	57577	Plants	Plants	52.4	1.21e-6	NR	CAJ2661155.1	57577	g23051	i0	44.6	0.991071428571429	74	37	96.4	2	1	216	1	72	CAJ2661155.1 unnamed protein product [Trifolium pratense]	diamond	222	52.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Trifolium	Trifolium pratense
30655324	30655324	PRJNA859990_S_NODE_21373_length_243_cov_0.858824_g21112_i0	PRJNA859990	21373	243	0.858824	2.08694232	Solanum tuberosum	4113	Plants	Plants	77.4	2.25e-14	NR	KAH0689089.1	4113	g21112	i0	60.3	1.71604938271605	63	18	69.1	1	242	75	404	466	KAH0689089.1 hypothetical protein KY289_016447 [Solanum tuberosum]	diamond	417	77.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum tuberosum
30971508	30971508	PRJNA859990_S_NODE_20834_length_244_cov_0.888889_g20573_i0	PRJNA859990	20834	244	0.888889	2.16888916	Vigna unguiculata	3917	Plants	Plants	47.8	6.14e-4	NR	XP_027924595.1	3917	g20573	i0	60.6	0.405737704918033	33	13	40.6	0	236	138	161	193	XP_027924595.1 uncharacterized protein LOC114182051 [Vigna unguiculata]	diamond	99	47.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna unguiculata
31034876	31034876	PRJNA859990_S_NODE_14635_length_273_cov_1.085000_g14374_i0	PRJNA859990	14635	273	1.085	2.96205	Acer saccharum	4024	Plants	Plants	102	3.73e-25	NR	KAK0577934.1	4024	g14374	i0	87.5	0.615384615384615	56	7	61.5	0	91	258	103	158	KAK0577934.1 hypothetical protein LWI29_002514 [Acer saccharum]	diamond	168	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Acer	Acer saccharum
31255768	31255768	PRJNA859990_S_NODE_3775_length_490_cov_2.071942_g3516_i0	PRJNA859990	3775	490	2.071942	10.1525158	Vigna unguiculata	3917	Plants	Plants	217	3.3e-70	NR	QCE13674.1	3917	g3516	i0	100	0.685714285714286	112	0	68.6	0	16	351	1	112	QCE13674.1 hypothetical protein DEO72_LG11g669 [Vigna unguiculata]	diamond	336	217	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna unguiculata
31358949	31358949	PRJNA859990_S_NODE_21176_length_243_cov_0.905882_g20915_i0	PRJNA859990	21176	243	0.905882	2.20129326	Vigna	3913	Plants	Plants	65.5	3.58e-10	NR	KOM56062.1	3914	g20915	i0	57.8	6.33333333333333	45	19	55.6	0	176	42	687	731	KOM56062.1 hypothetical protein LR48_Vigan10g195400 [Vigna angularis]	diamond	1539	65.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Vigna	Vigna angularis
31382414	31382414	PRJNA859990_S_NODE_22276_length_241_cov_0.880952_g22015_i0	PRJNA859990	22276	241	0.880952	2.12309432	Acer saccharum	4024	Plants	Plants	96.3	1.39e-21	NR	KAK1550734.1	4024	g22015	i0	81.5	2.01659751037344	54	10	67.2	0	79	240	68	121	KAK1550734.1 hypothetical protein Q3G72_023890 [Acer saccharum]	diamond	486	96.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Acer	Acer saccharum
31920049	31920049	PRJNA859990_S_NODE_17797_length_251_cov_1.258427_g17536_i0	PRJNA859990	17797	251	1.258427	3.15865177	Glycine soja	3848	Plants	Plants	52.8	1.2e-5	NR	XP_028193285.1	3848	g17536	i0	42.2	2.28286852589641	64	36	76.5	1	2	193	122	184	XP_028193285.1 uncharacterized protein LOC114378897 [Glycine soja]	diamond	573	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Glycine	Glycine soja
32458077	32458077	PRJNA859990_S_NODE_21379_length_243_cov_0.858824_g21118_i0	PRJNA859990	21379	243	0.858824	2.08694232	Tanacetum cinerariifolium	118510	Plants	Plants	72.4	5.37e-14	NR	GFA07772.1	118510	g21118	i0	48.7	0.938271604938272	76	39	93.8	0	16	243	37	112	GFA07772.1 hypothetical protein [Tanacetum cinerariifolium]	diamond	228	72.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
32553141	32553141	PRJNA859990_S_NODE_18259_length_250_cov_0.870056_g17998_i0	PRJNA859990	18259	250	0.870056	2.17514	Solanum commersonii	4109	Plants	Plants	61.6	1.7e-9	NR	KAG5605574.1	4109	g17998	i0	60.4	0.636	53	21	63.6	0	85	243	84	136	KAG5605574.1 hypothetical protein H5410_027066 [Solanum commersonii]	diamond	159	61.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum commersonii
32773206	32773206	PRJNA859990_S_NODE_20080_length_245_cov_1.610465_g19819_i0	PRJNA859990	20080	245	1.610465	3.94563925	Citrus sinensis	2711	Plants	Plants	119	1.61e-32	NR	KDO35906.1	2711	g19819	i0	88.6	0.857142857142857	70	8	85.7	0	36	245	1	70	KDO35906.1 hypothetical protein CISIN_1g037050mg, partial [Citrus sinensis]	diamond	210	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis

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