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

12 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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
26680035	26680035	PRJNA1240805_P_NODE_6081_length_185_cov_5.992647_g6032_i0	PRJNA1240805	6081	185	5.992647	11.08639695	Magnoliopsida	3398	Plants	Plants	83.2	9.41e-17	NR	CAL5357323.1	4442	g6032	i0	78.3	2.9027027027027	46	10	74.6	0	160	23	171	216	CAL5357323.1 unnamed protein product [Camellia sinensis]	diamond	537	83.6	0.995215311004785	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
27217862	27217862	PRJNA1240805_P_NODE_3102_length_265_cov_4.564815_g3053_i0	PRJNA1240805	3102	265	4.564815	12.09675975	Eukaryota	2759	Plants	Plants	52.8	1.31e-5	NR	KAJ3695273.1	13579	g3053	i0	64.9	2.33207547169811	37	13	41.9	0	3	113	307	343	KAJ3695273.1 hypothetical protein LUZ60_000650 [Juncus effusus]	diamond	618	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Juncaceae	Juncus	Juncus effusus
27705769	27705769	PRJNA1240805_P_NODE_9084_length_153_cov_2.192308_g9035_i0	PRJNA1240805	9084	153	2.192308	3.35423124	Mikania micrantha	192012	Plants	Plants	55.8	2.52e-7	NR	KAD0280368.1	192012	g9035	i0	63.9	0.705882352941177	36	13	70.6	0	109	2	80	115	KAD0280368.1 hypothetical protein E3N88_44512 [Mikania micrantha]	diamond	108	55.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Mikania	Mikania micrantha
27863169	27863169	PRJNA1240805_P_NODE_4945_length_205_cov_6.775641_g4896_i0	PRJNA1240805	4945	205	6.775641	13.89006405	Dorcoceras hygrometricum	472368	Plants	Plants	75.1	8.45e-14	NR	KZV32988.1	472368	g4896	i0	67.4	1.3609756097561	46	15	67.3	0	21	158	454	499	KZV32988.1 hypothetical protein F511_01499 [Dorcoceras hygrometricum]	diamond	279	75.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Gesneriaceae	Dorcoceras	Dorcoceras hygrometricum
28715841	28715841	PRJNA1240805_P_NODE_5727_length_191_cov_2.577465_g5678_i0	PRJNA1240805	5727	191	2.577465	4.92295815	Morus notabilis	981085	Plants	Plants	99.4	1.3e-22	NR	XP_024022179.1	981085	g5678	i0	82.1	1.75916230366492	56	10	88	0	22	189	384	439	XP_024022179.1 patellin-4 [Morus notabilis]	diamond	336	99.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Morus	Morus notabilis
28747333	28747333	PRJNA1240805_P_NODE_6707_length_177_cov_1.593750_g6658_i0	PRJNA1240805	6707	177	1.59375	2.8209375	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	56.6	1.45e-8	NR	BAJ98972.1	112509	g6658	i0	53.2	0.796610169491525	47	22	79.7	0	28	168	48	94	BAJ98972.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	141	56.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
29000293	29000293	PRJNA1240805_P_NODE_6008_length_186_cov_11.372263_g5959_i0	PRJNA1240805	6008	186	11.372263	21.15240918	Stylosanthes scabra	79078	Plants	Plants	50.1	1.02e-5	NR	MED6117531.1	79078	g5959	i0	46.9	1.56451612903226	49	23	79	1	36	182	4	49	MED6117531.1 hypothetical protein [Stylosanthes scabra]	diamond	291	50.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Stylosanthes	Stylosanthes scabra
29743956	29743956	PRJNA1240805_P_NODE_5690_length_191_cov_6.246479_g5641_i0	PRJNA1240805	5690	191	6.246479	11.93077489	Eukaryota	2759	Plants	Plants	45.4	0.00198	NR	CAA2987847.1	158383	g5641	i0	48.8	4.96335078534031	43	22	67.5	0	26	154	236	278	CAA2987847.1 V-type proton ATPase catalytic subunit A-like [Olea europaea subsp. europaea]	diamond	948	45.8	0.991266375545852	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Oleaceae	Olea	Olea europaea
30673747	30673747	PRJNA1240805_P_NODE_7533_length_168_cov_2.621849_g7484_i0	PRJNA1240805	7533	168	2.621849	4.40470632	Mercurialis annua	3986	Plants	Plants	45.1	4.69e-4	NR	XP_050206635.1	3986	g7484	i0	55.1	0.875	49	13	71.4	1	160	41	55	103	XP_050206635.1 classical arabinogalactan protein 11-like [Mercurialis annua]	diamond	147	45.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Euphorbiaceae	Mercurialis	Mercurialis annua
30989986	30989986	PRJNA1240805_P_NODE_6594_length_178_cov_4.162791_g6545_i0	PRJNA1240805	6594	178	4.162791	7.40976798	Ficus carica	3494	Plants	Plants	90.5	1.38e-19	NR	GMN27810.1	3494	g6545	i0	75	0.876404494382023	52	13	87.6	0	23	178	89	140	GMN27810.1 hypothetical protein TIFTF001_001808 [Ficus carica]	diamond	156	90.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Ficus	Ficus carica
31053309	31053309	PRJNA1240805_P_NODE_6575_length_178_cov_6.658915_g6526_i0	PRJNA1240805	6575	178	6.658915	11.8528687	Nymphaea colorata	210225	Plants	Plants	104	2.6e-25	NR	XP_031472545.1	210225	g6526	i0	100	1.61797752808989	48	0	80.9	0	35	178	151	198	XP_031472545.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116244849 [Nymphaea colorata]	diamond	288	104	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
32886004	32886004	PRJNA1240805_P_NODE_4580_length_214_cov_3.745455_g4531_i0	PRJNA1240805	4580	214	3.745455	8.0152737	Capsella rubella	81985	Plants	Plants	54.3	2.11e-6	NR	XP_023641904.1	81985	g4531	i0	56.1	1.14953271028037	41	18	57.5	0	2	124	389	429	XP_023641904.1 LOW QUALITY PROTEIN: uncharacterized protein LOC17892899 [Capsella rubella]	diamond	246	54.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Capsella	Capsella rubella

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