metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA900999" 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
26683483	26683483	PRJNA900999_S_NODE_6961_length_172_cov_3.776224_g6905_i0	PRJNA900999	6961	172	3.776224	6.49510528	Magnoliopsida	3398	Plants	Plants	43.5	0.00648	NR	KAG9157835.1	34254	g6905	i0	81.8	0.767441860465116	22	4	38.4	0	172	107	188	209	KAG9157835.1 hypothetical protein Leryth_000026 [Lithospermum erythrorhizon]	diamond	132	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Boraginales	Boraginaceae	Lithospermum	Lithospermum erythrorhizon
26802565	26802565	PRJNA900999_S_NODE_2081_length_271_cov_3.231405_g2025_i0	PRJNA900999	2081	271	3.231405	8.75710755	Ensete ventricosum	4639	Plants	Plants	66.2	4.97e-11	NR	KAJ8494155.1	4639	g2025	i0	75.7	1.63837638376384	37	9	41	0	271	161	147	183	KAJ8494155.1 hypothetical protein OPV22_015876 [Ensete ventricosum]	diamond	444	66.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Zingiberales	Musaceae	Ensete	Ensete ventricosum
26866260	26866260	PRJNA900999_S_NODE_4861_length_198_cov_2.852071_g4805_i0	PRJNA900999	4861	198	2.852071	5.64710058	Picea sitchensis	3332	Plants	Plants	102	9.29e-26	NR	ABK25709.1	3332	g4805	i0	73	0.954545454545455	63	17	95.5	0	198	10	95	157	ABK25709.1 unknown [Picea sitchensis]	diamond	189	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis
26992343	26992343	PRJNA900999_S_NODE_5302_length_191_cov_5.543210_g5246_i0	PRJNA900999	5302	191	5.54321	10.5875311	Alnus glutinosa	3517	Plants	Plants	50.1	1.59e-5	NR	XP_062173447.1	3517	g5246	i0	54.7	0.832460732984293	53	10	61.3	2	38	154	95	147	XP_062173447.1 root meristem growth factor 10 [Alnus glutinosa]	diamond	159	50.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Alnus	Alnus glutinosa
27055926	27055926	PRJNA900999_S_NODE_4342_length_207_cov_2.837079_g4286_i0	PRJNA900999	4342	207	2.837079	5.87275353	Picea sitchensis	3332	Plants	Plants	90.5	7.14e-20	NR	ABK24867.1	3332	g4286	i0	88.5	0.753623188405797	52	6	75.4	0	2	157	177	228	ABK24867.1 unknown [Picea sitchensis]	diamond	156	90.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea sitchensis
27782504	27782504	PRJNA900999_S_NODE_3624_length_222_cov_2.901554_g3568_i0	PRJNA900999	3624	222	2.901554	6.44144988	Quercus rubra	3512	Plants	Plants	117	8.190000000000001e-33	NR	KAK4589130.1	3512	g3568	i0	98.3	0.797297297297297	59	1	79.7	0	221	45	14	72	KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra]	diamond	177	117	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
28192623	28192623	PRJNA900999_S_NODE_4366_length_206_cov_4.711864_g4310_i0	PRJNA900999	4366	206	4.711864	9.70643984	Papaver somniferum	3469	Plants	Plants	44.3	0.00668	NR	RZC77225.1	3469	g4310	i0	45.3	0.771844660194175	53	20	69.9	3	3	146	329	377	RZC77225.1 hypothetical protein C5167_001504 [Papaver somniferum]	diamond	159	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Papaver	Papaver somniferum
28255847	28255847	PRJNA900999_S_NODE_3626_length_222_cov_2.694301_g3570_i0	PRJNA900999	3626	222	2.694301	5.98134822	Carpinus fangiana	176857	Plants	Plants	97.4	2.5699999999999997e-24	NR	KAE8010300.1	176857	g3570	i0	91.8	0.662162162162162	49	4	66.2	0	221	75	58	106	KAE8010300.1 hypothetical protein FH972_006682 [Carpinus fangiana]	diamond	147	97.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
29203402	29203402	PRJNA900999_S_NODE_4049_length_213_cov_2.282609_g3993_i0	PRJNA900999	4049	213	2.282609	4.86195717	Castanea mollissima	60419	Plants	Plants	92	2.32e-22	NR	KAF3968001.1	60419	g3993	i0	97.7	1.22535211267606	44	1	62	0	2	133	53	96	KAF3968001.1 hypothetical protein CMV_008061 [Castanea mollissima]	diamond	261	92	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Castanea	Castanea mollissima
29494985	29494985	PRJNA900999_S_NODE_2570_length_252_cov_2.309417_g2514_i0	PRJNA900999	2570	252	2.309417	5.81973084	Streptophyta	35493	Plants	Plants	108	3.28e-26	NR	XP_023530212.1	3664	g2514	i0	57.8	10.9047619047619	83	34	97.6	1	252	7	108	190	XP_023530212.1 shaggy-related protein kinase epsilon-like [Cucurbita pepo subsp. pepo]	diamond	2748	108	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucurbita	Cucurbita pepo
29771373	29771373	PRJNA900999_S_NODE_1331_length_311_cov_4.262411_g1275_i0	PRJNA900999	1331	311	4.262411	13.25609821	Durio zibethinus	66656	Plants	Plants	92.4	1.23e-20	NR	XP_022725095.1	66656	g1275	i0	78.9	1.52411575562701	76	14	73.3	2	9	236	80	153	XP_022725095.1 cilia- and flagella-associated protein 251-like [Durio zibethinus]	diamond	474	92.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Durio	Durio zibethinus
30537371	30537371	PRJNA900999_S_NODE_5573_length_188_cov_2.427673_g5517_i0	PRJNA900999	5573	188	2.427673	4.56402524	Magnoliopsida	3398	Plants	Plants	70.5	1.06e-13	NR	PWA40823.1	35608	g5517	i0	74.5	17.1063829787234	47	12	75	0	141	1	1	47	PWA40823.1 hypothetical protein CTI12_AA515860 [Artemisia annua]	diamond	3216	70.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Artemisia	Artemisia annua
30845758	30845758	PRJNA900999_S_NODE_4994_length_195_cov_497.132530_g4938_i0	PRJNA900999	4994	195	497.13253	969.4084335	Carpinus fangiana	176857	Plants	Plants	79	8.7e-18	NR	KAE8075595.1	176857	g4938	i0	86.7	0.692307692307692	45	6	69.2	0	59	193	1	45	KAE8075595.1 hypothetical protein FH972_014292 [Carpinus fangiana]	diamond	135	79	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
30877272	30877272	PRJNA900999_S_NODE_7374_length_168_cov_3.460432_g7318_i0	PRJNA900999	7374	168	3.460432	5.81352576	Quercus rubra	3512	Plants	Plants	60.8	8.51e-11	NR	KAK4581221.1	3512	g7318	i0	78.4	0.660714285714286	37	7	66.1	1	2	112	9	44	KAK4581221.1 hypothetical protein RGQ29_024765 [Quercus rubra]	diamond	111	60.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Fagaceae	Quercus	Quercus rubra
30940670	30940670	PRJNA900999_S_NODE_2754_length_245_cov_9.587963_g2698_i0	PRJNA900999	2754	245	9.587963	23.49050935	Sphagnum jensenii	128206	Plants	Plants	61.2	7.88e-9	NR	CAK9250564.1	128206	g2698	i0	42.4	0.722448979591837	59	33	71	1	3	176	216	274	CAK9250564.1 unnamed protein product, partial [Sphagnum jensenii]	diamond	177	61.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum jensenii
31232279	31232279	PRJNA900999_S_NODE_7735_length_165_cov_2.029412_g7679_i0	PRJNA900999	7735	165	2.029412	3.3485298	Sapindaceae	23672	Plants	Plants	93.2	2.85e-22	NR	KAK2638788.1	168575	g7679	i0	86.8	3.87272727272727	53	7	96.4	0	161	3	6	58	KAK2638788.1 hypothetical protein Ddye_026583 [Dipteronia dyeriana]	diamond	639	94	0.991489361702128	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Sapindaceae	Dipteronia	Dipteronia dyeriana

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