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

12 rows where analysis = "diamond", bioproject = "PRJNA1123686" 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
2305374	2305374	PRJNA1123686_S_NODE_3382_length_252_cov_43.878924_g3350_i0	PRJNA1123686	3382	252	43.878924	110.57488848	Eukaryota	2759	Plants	Plants	71.2	1.76e-12	NR	AQK63996.1	4577	g3350	i0	70	1.21428571428571	50	15	59.5	0	8	157	175	224	AQK63996.1 Tubulin beta-4 chain [Zea mays]	diamond	306	71.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
27418163	27418163	PRJNA1123686_S_NODE_10523_length_186_cov_9.834395_g10491_i0	PRJNA1123686	10523	186	9.834395	18.2919747	Gossypium hirsutum	3635	Plants	Plants	42.4	0.0227	NR	XP_016679275.1	3635	g10491	i0	35.7	0.903225806451613	56	29	79	1	19	165	8	63	XP_016679275.1 uncharacterized protein [Gossypium hirsutum]	diamond	168	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Gossypium	Gossypium hirsutum
28554745	28554745	PRJNA1123686_S_NODE_167_length_501_cov_27.400424_g142_i0	PRJNA1123686	167	501	27.400424	137.27612424	Zea mays	4577	Plants	Plants	78.2	3.67e-15	NR	ACL53389.1	4577	g142	i0	45.5	0.604790419161677	101	55	60.5	0	389	87	5	105	ACL53389.1 unknown [Zea mays]	diamond	303	78.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
29217836	29217836	PRJNA1123686_S_NODE_349_length_410_cov_107.931759_g319_i0	PRJNA1123686	349	410	107.931759	442.5202119	Medicago truncatula	3880	Plants	Plants	62.4	4.79e-9	NR	AFK49052.1	3880	g319	i0	40.4	1.1780487804878	89	52	65.1	1	269	3	14	101	AFK49052.1 unknown [Medicago truncatula]	diamond	483	62.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Medicago	Medicago truncatula
30418171	30418171	PRJNA1123686_S_NODE_4393_length_236_cov_254.661836_g4361_i0	PRJNA1123686	4393	236	254.661836	601.00193296	Arachis hypogaea	3818	Plants	Plants	43.1	0.0165	NR	XLS47499.1	3818	g4361	i0	65.5	0.36864406779661	29	10	36.9	0	182	96	116	144	XLS47499.1 hypothetical protein HN51_021857, partial [Arachis hypogaea]	diamond	87	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Arachis	Arachis hypogaea
30533278	30533278	PRJNA1123686_S_NODE_973_length_336_cov_28.130293_g941_i0	PRJNA1123686	973	336	28.130293000000002	94.51778448	Solanum	4107	Plants	Plants	46.6	0.00224	NR	NP_001234488.1	4081	g941	i0	54.5	3.92857142857143	55	25	49.1	0	3	167	117	171	NP_001234488.1 peptidyl-prolyl cis-trans isomerase [Solanum lycopersicum]	diamond	1320	47	0.991489361702128	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum lycopersicum
31207222	31207222	PRJNA1123686_S_NODE_17755_length_159_cov_354.292308_g17723_i0	PRJNA1123686	17755	159	354.292308	563.32476972	Cannabis sativa	3483	Plants	Plants	48.9	7.8e-5	NR	KAF4399262.1	3483	g17723	i0	80	3.9622641509434	30	6	56.6	0	66	155	843	872	KAF4399262.1 hypothetical protein G4B88_022345 [Cannabis sativa]	diamond	630	48.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
31302561	31302561	PRJNA1123686_S_NODE_1575_length_303_cov_16.857664_g1543_i0	PRJNA1123686	1575	303	16.857664	51.07872192	Spirodela intermedia	51605	Plants	Plants	53.5	3.72e-6	NR	CAA2625966.1	51605	g1543	i0	41.3	0.792079207920792	80	47	79.2	0	242	3	59	138	CAA2625966.1 unnamed protein product [Spirodela intermedia]	diamond	240	53.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Alismatales	Araceae	Spirodela	Spirodela intermedia
31492519	31492519	PRJNA1123686_S_NODE_1716_length_296_cov_80.958801_g1684_i0	PRJNA1123686	1716	296	80.958801	239.63805096	Chara braunii	69332	Plants	Plants	57.4	5.66e-8	NR	GBG89163.1	69332	g1684	i0	54.8	0.628378378378378	62	23	62.8	2	19	204	46	102	GBG89163.1 hypothetical protein CBR_g48871 [Chara braunii]	diamond	186	57.4	1	Eukaryota		Viridiplantae	Streptophyta	Charophyceae	Charales	Characeae	Chara	Chara braunii
31766101	31766101	PRJNA1123686_S_NODE_2297_length_276_cov_24.805668_g2265_i0	PRJNA1123686	2297	276	24.805668	68.46364368	Eukaryota	2759	Plants	Plants	52	2e-5	NR	CAL0318850.1	3873	g2265	i0	50	2.93478260869565	54	27	58.7	0	4	165	169	222	CAL0318850.1 unnamed protein product [Lupinus luteus]	diamond	810	52.4	0.99236641221374	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lupinus	Lupinus luteus
32536582	32536582	PRJNA1123686_S_NODE_8779_length_196_cov_8.377246_g8747_i0	PRJNA1123686	8779	196	8.377246	16.41940216	Nymphaea thermarum	419125	Plants	Plants	47.8	2.25e-4	NR	KAF3783033.1	419125	g8747	i0	56.5	0.704081632653061	46	20	70.4	0	138	1	77	122	KAF3783033.1 hypothetical protein EJ110_NYTH32983 [Nymphaea thermarum]	diamond	138	47.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea thermarum
32788281	32788281	PRJNA1123686_S_NODE_13880_length_172_cov_3.741259_g13848_i0	PRJNA1123686	13880	172	3.741259	6.43496548	Picea sitchensis	3332	Plants	Plants	69.3	4.62e-13	NR	ABR17445.1	3332	g13848	i0	82.5	0.697674418604651	40	7	69.8	0	4	123	111	150	ABR17445.1 unknown [Picea sitchensis]	diamond	120	69.3	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);;