metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA312107" 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
377597	377597	PRJNA312107_P_NODE_23161_length_165_cov_0.896552_g22995_i0	PRJNA312107	23161	165	0.896552	1.4793108	Taraxacum kok-saghyz	333970	Plants	Plants	119	1.01e-29	NR	KAL4571224.1	333970	g22995	i0	96.3	0.981818181818182	54	2	98.2	0	164	3	21	74	KAL4571224.1 hypothetical protein LXL04_017977 [Taraxacum kok-saghyz]	diamond	162	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Taraxacum	Taraxacum kok-saghyz
14406574	14406574	PRJNA312107_P_NODE_24212_length_164_cov_0.904348_g24046_i0	PRJNA312107	24212	164	0.904348	1.48313072	Fabaceae	3803	Plants	Plants	107	2.91e-25	NR	RHN78855.1	3880	g24046	i0	92.5	51.0914634146341	53	4	97	0	5	163	646	698	RHN78855.1 putative nucleotidyltransferase, Ribonuclease H [Medicago truncatula]	diamond	8379	107	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Medicago	Medicago truncatula
27800926	27800926	PRJNA312107_P_NODE_25624_length_162_cov_0.920354_g25458_i0	PRJNA312107	25624	162	0.920354	1.49097348	Taxus chinensis	29808	Plants	Plants	65.5	1.16e-10	NR	KAH9295244.1	29808	g25458	i0	60.8	1.88888888888889	51	20	94.4	0	155	3	259	309	KAH9295244.1 hypothetical protein KI387_038832, partial [Taxus chinensis]	diamond	306	65.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
27849763	27849763	PRJNA312107_P_NODE_20704_length_167_cov_0.881356_g20538_i0	PRJNA312107	20704	167	0.881356	1.47186452	Populus	3689	Plants	Plants	67.4	2.66e-11	NR	ABF81447.1	3694	g20538	i0	60	2.96407185628743	55	22	98.8	0	167	3	416	470	ABF81447.1 NBS type disease resistance protein [Populus trichocarpa]	diamond	495	67.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus trichocarpa
28305968	28305968	PRJNA312107_P_NODE_20846_length_167_cov_0.881356_g20680_i0	PRJNA312107	20846	167	0.881356	1.47186452	Sphagnum balticum	128184	Plants	Plants	42.4	0.0185	NR	CAM6004399.1	128184	g20680	i0	45.5	2.7125748502994	44	22	79	1	26	157	574	615	CAM6004399.1 unnamed protein product [Sphagnum balticum]	diamond	453	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
29473916	29473916	PRJNA312107_P_NODE_22510_length_165_cov_0.896552_g22344_i0	PRJNA312107	22510	165	0.896552	1.4793108	Taxus chinensis	29808	Plants	Plants	58.5	3.2e-8	NR	KAH9291640.1	29808	g22344	i0	64.3	0.763636363636364	42	15	76.4	0	38	163	145	186	KAH9291640.1 hypothetical protein KI387_043172, partial [Taxus chinensis]	diamond	126	58.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
29947963	29947963	PRJNA312107_P_NODE_19291_length_169_cov_0.866667_g19125_i0	PRJNA312107	19291	169	0.866667	1.46466723	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	48.1	1.61e-4	NR	BAK03108.1	112509	g19125	i0	50	0.816568047337278	46	22	79.9	1	6	140	195	240	BAK03108.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	138	48.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
29979459	29979459	PRJNA312107_P_NODE_22171_length_166_cov_0.888889_g22005_i0	PRJNA312107	22171	166	0.888889	1.47555574	Taxus chinensis	29808	Plants	Plants	54.7	8.1e-7	NR	KAH9316782.1	29808	g22005	i0	48.8	0.77710843373494	43	22	77.7	0	159	31	285	327	KAH9316782.1 hypothetical protein KI387_044020 [Taxus chinensis]	diamond	129	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
30295848	30295848	PRJNA312107_P_NODE_25152_length_163_cov_0.912281_g24986_i0	PRJNA312107	25152	163	0.912281	1.48701803	Triticum aestivum	4565	Plants	Plants	80.1	8.56e-16	NR	XBI55658.1	4565	g24986	i0	81.5	1.98773006134969	54	10	99.4	0	1	162	513	566	XBI55658.1 hypothetical protein VPH35_037430 [Triticum aestivum]	diamond	324	80.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
30990660	30990660	PRJNA312107_P_NODE_15334_length_187_cov_1.050725_g15168_i0	PRJNA312107	15334	187	1.050725	1.96485575	Vitis vinifera	29760	Plants	Plants	42.4	0.0238	NR	RVW99457.1	29760	g15168	i0	40.4	1.82887700534759	57	26	89.8	2	6	173	229	278	RVW99457.1 Beta-fructofuranosidase, soluble isoenzyme I [Vitis vinifera]	diamond	342	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
31939074	31939074	PRJNA312107_P_NODE_14657_length_191_cov_0.985915_g14491_i0	PRJNA312107	14657	191	0.985915	1.88309765	Panicum miliaceum	4540	Plants	Plants	41.6	0.047	NR	RLN04903.1	4540	g14491	i0	39.7	0.910994764397906	58	33	88	1	21	188	101	158	RLN04903.1 uncharacterized protein C2845_PM13G19490 [Panicum miliaceum]	diamond	174	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Panicum	Panicum miliaceum
31970806	31970806	PRJNA312107_P_NODE_23838_length_164_cov_0.904348_g23672_i0	PRJNA312107	23838	164	0.904348	1.48313072	Heracleum sosnowskyi	360622	Plants	Plants	100	3.0699999999999998e-24	NR	KAK1387176.1	360622	g23672	i0	85.2	4.9390243902439	54	8	98.8	0	2	163	81	134	KAK1387176.1 hypothetical protein POM88_015354 [Heracleum sosnowskyi]	diamond	810	100	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Apiales	Apiaceae	Heracleum	Heracleum sosnowskyi
32192403	32192403	PRJNA312107_P_NODE_21798_length_166_cov_0.888889_g21632_i0	PRJNA312107	21798	166	0.888889	1.47555574	Lolium multiflorum	4521	Plants	Plants	82.4	1.38e-16	NR	KAK1664819.1	4521	g21632	i0	70.9	1.98795180722892	55	14	99.4	1	165	1	1375	1427	KAK1664819.1 hypothetical protein QYE76_052978 [Lolium multiflorum]	diamond	330	82.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium multiflorum
32445678	32445678	PRJNA312107_P_NODE_25779_length_162_cov_0.920354_g25613_i0	PRJNA312107	25779	162	0.920354	1.49097348	Nicotiana tabacum	4097	Plants	Plants	68.9	6.93e-12	NR	XP_016441632.1	4097	g25613	i0	88.9	0.666666666666667	36	4	66.7	0	48	155	355	390	XP_016441632.1 uncharacterized protein [Nicotiana tabacum]	diamond	108	68.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Nicotiana	Nicotiana tabacum
32855289	32855289	PRJNA312107_P_NODE_23580_length_164_cov_0.904348_g23414_i0	PRJNA312107	23580	164	0.904348	1.48313072	Picea sitchensis	3332	Plants	Plants	80.1	2.45e-16	NR	QHR87735.1	3332	g23414	i0	63	1.97560975609756	54	20	98.8	0	164	3	12	65	QHR87735.1 hypothetical protein Q903MT_gene1747 [Picea sitchensis]	diamond	324	80.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis

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