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

12 rows where analysis = "diamond", bioproject = "PRJNA263496" 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
11260394	11260394	PRJNA263496_P_NODE_16049_length_195_cov_1.047945_g15796_i0	PRJNA263496	16049	195	1.047945	2.04349275	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	101	2.88e-24	NR	BAK00797.1	112509	g15796	i0	72.7	1.01538461538462	66	15	96.9	2	194	6	179	244	BAK00797.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	198	101	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
13810647	13810647	PRJNA263496_P_NODE_20651_length_169_cov_1.275000_g20398_i0	PRJNA263496	20651	169	1.275	2.15475	Zingiberales	4618	Plants	Plants	103	3.3400000000000003e-26	NR	WOL05827.1	4628	g20398	i0	82.1	21.8698224852071	56	10	99.4	0	1	168	61	116	WOL05827.1 ras-related protein RABF1-like isoform X2 [Canna indica]	diamond	3696	104	0.990384615384615	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Cannaceae	Canna	Canna indica
21458944	21458944	PRJNA263496_P_NODE_13277_length_215_cov_1.036145_g13024_i0	PRJNA263496	13277	215	1.036145	2.22771175	Eukaryota	2759	Plants	Plants	152	4.53e-44	NR	AFK36075.1	34305	g13024	i0	100	25.7581395348837	71	0	99.1	0	3	215	106	176	AFK36075.1 unknown [Lotus japonicus]	diamond	5538	152	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
26884339	26884339	PRJNA263496_P_NODE_17621_length_185_cov_1.786765_g17368_i0	PRJNA263496	17621	185	1.786765	3.30551525	Humulus lupulus	3486	Plants	Plants	74.3	8.08e-15	NR	XP_062074824.1	3486	g17368	i0	70.8	1.05405405405405	65	15	98.9	1	2	184	92	156	XP_062074824.1 cytosolic calcium-binding protein 2 [Humulus lupulus]	diamond	195	74.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus lupulus
27408066	27408066	PRJNA263496_P_NODE_24483_length_162_cov_1.646018_g24230_i0	PRJNA263496	24483	162	1.646018	2.66654916	Olea	4145	Plants	Plants	63.2	9.92e-12	NR	O24172.1	4146	g24230	i0	53.5	1.59259259259259	43	20	79.6	0	138	10	5	47	O24172.1 RecName: Full=Major pollen allergen Ole e 6; AltName: Allergen=Ole e 6 [Olea europaea]	diamond	258	63.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Olea	Olea europaea
27547927	27547927	PRJNA263496_P_NODE_21984_length_166_cov_0.871795_g21731_i0	PRJNA263496	21984	166	0.871795	1.4471797	Humulus scandens	228586	Plants	Plants	77.4	2.49e-16	NR	AVY54510.1	228586	g21731	i0	62.7	0.921686746987952	51	18	92.2	1	162	10	92	141	AVY54510.1 Hum s 3 allergen [Humulus scandens]	diamond	153	77.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus scandens
29126931	29126931	PRJNA263496_P_NODE_4329_length_410_cov_1.030471_g4076_i0	PRJNA263496	4329	410	1.030471	4.2249311	Mangifera indica	29780	Plants	Plants	67	6.81e-10	NR	XP_044498203.1	29780	g4076	i0	39	0.9	123	73	88.5	2	400	38	267	389	XP_044498203.1 GPN-loop GTPase QQT2 isoform X2 [Mangifera indica]	diamond	369	67	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Anacardiaceae	Mangifera	Mangifera indica
31116439	31116439	PRJNA263496_P_NODE_25015_length_162_cov_0.902655_g24762_i0	PRJNA263496	25015	162	0.902655	1.4623011	Humulus lupulus	3486	Plants	Plants	41.2	0.0428	NR	XP_062118565.1	3486	g24762	i0	50	0.851851851851852	46	20	85.2	1	23	160	190	232	XP_062118565.1 uncharacterized protein LOC133832207 [Humulus lupulus]	diamond	138	41.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus lupulus
31147854	31147854	PRJNA263496_P_NODE_25535_length_161_cov_0.910714_g25282_i0	PRJNA263496	25535	161	0.910714	1.46624954	Oryza brachyantha	4533	Plants	Plants	42	0.0185	NR	XP_006649434.1	4533	g25282	i0	42.2	0.838509316770186	45	25	83.9	1	8	142	82	125	XP_006649434.1 formin-like protein 20 [Oryza brachyantha]	diamond	135	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza brachyantha
31306265	31306265	PRJNA263496_P_NODE_18315_length_181_cov_2.606061_g18062_i0	PRJNA263496	18315	181	2.606061	4.71697041	Musa troglodytarum	320322	Plants	Plants	80.5	1e-16	NR	URD82270.1	320322	g18062	i0	71.7	3.86187845303867	60	17	99.4	0	181	2	146	205	URD82270.1 GRAM domain containing protein [Musa troglodytarum]	diamond	699	80.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Musaceae	Musa	Musa troglodytarum
32097132	32097132	PRJNA263496_P_NODE_12698_length_220_cov_1.093567_g12445_i0	PRJNA263496	12698	220	1.093567	2.4058474	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	119	4.2e-31	NR	BAK00797.1	112509	g12445	i0	76.1	0.913636363636364	67	16	91.4	0	220	20	203	269	BAK00797.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	201	119	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
32209882	32209882	PRJNA263496_P_NODE_22518_length_165_cov_0.879310_g22265_i0	PRJNA263496	22518	165	0.87931	1.4508615	Magnoliopsida	3398	Plants	Plants	43.1	0.00977	NR	XP_010261576.1	4432	g22265	i0	64.1	2.98181818181818	39	9	69.1	2	34	147	86	120	XP_010261576.1 PREDICTED: mitochondrial inner membrane protein OXA1-like [Nelumbo nucifera]	diamond	492	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Proteales	Nelumbonaceae	Nelumbo	Nelumbo nucifera

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