metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA767802" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA767802" 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
26799986	26799986	PRJNA767802_P_NODE_6901_length_296_cov_1.522267_g6828_i0	PRJNA767802	6901	296	1.522267	4.50591032	Riccia sorocarpa	122646	Plants	Plants	115	5.569999999999999e-28	NR	KAL3683056.1	122646	g6828	i0	70.1	0.679054054054054	67	20	67.9	0	201	1	358	424	KAL3683056.1 hypothetical protein R1sor_001078 [Riccia sorocarpa]	diamond	201	115	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Marchantiopsida	Marchantiales	Ricciaceae	Riccia	Riccia sorocarpa
27062788	27062788	PRJNA767802_P_NODE_6722_length_301_cov_3.087302_g6649_i0	PRJNA767802	6722	301	3.087302	9.29277902	Eukaryota	2759	Plants	Plants	44.7	0.00601	NR	XP_010693960.2	3555	g6649	i0	39.1	10.0166112956811	64	39	63.8	0	44	235	7	70	XP_010693960.2 probable calcium-binding protein CML18 [Beta vulgaris subsp. vulgaris]	diamond	3015	45.1	0.991130820399113	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Caryophyllales	Chenopodiaceae	Beta	Beta vulgaris
27284105	27284105	PRJNA767802_P_NODE_7703_length_272_cov_5.695067_g7630_i0	PRJNA767802	7703	272	5.695067	15.49058224	Eukaryota	2759	Plants	Plants	91.7	1.17e-21	NR	RXH75839.1	3750	g7630	i0	60.6	5.28308823529412	66	26	72.8	0	250	53	42	107	RXH75839.1 hypothetical protein DVH24_042626 [Malus domestica]	diamond	1437	91.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus domestica
27306220	27306220	PRJNA767802_P_NODE_3543_length_464_cov_2.530120_g3470_i0	PRJNA767802	3543	464	2.53012	11.7397568	Camellia sinensis	4442	Plants	Plants	64.3	1.23e-9	NR	XP_028125933.1	4442	g3470	i0	30.7	0.885775862068966	137	86	84.7	4	446	54	13	146	XP_028125933.1 putative phosphatidylglycerol/phosphatidylinositol transfer protein DDB_G0282179 isoform X2 [Camellia sinensis]	diamond	411	64.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
28063878	28063878	PRJNA767802_P_NODE_15845_length_167_cov_1.728814_g15772_i0	PRJNA767802	15845	167	1.728814	2.88711938	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	87.8	7.17e-19	NR	BAK05870.1	112509	g15772	i0	63.6	10.9940119760479	55	20	98.8	0	165	1	284	338	BAK05870.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	1836	87.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
28158897	28158897	PRJNA767802_P_NODE_5305_length_353_cov_4.555921_g5232_i0	PRJNA767802	5305	353	4.555921	16.08240113	Nymphaea colorata	210225	Plants	Plants	52.4	4.16e-6	NR	VVW89553.1	210225	g5232	i0	41.7	1.21529745042493	60	29	45.9	1	260	99	3	62	VVW89553.1 unnamed protein product, partial [Nymphaea colorata]	diamond	429	52.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
28799508	28799508	PRJNA767802_P_NODE_14367_length_179_cov_1.523077_g14294_i0	PRJNA767802	14367	179	1.523077	2.72630783	Eukaryota	2759	Plants	Plants	63.5	1.96e-10	NR	CAM5863361.1	13385	g14294	i0	55.3	21.9385474860335	47	21	78.8	0	165	25	147	193	CAM5863361.1 unnamed protein product [Calluna vulgaris]	diamond	3927	63.9	0.993740219092332	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Ericaceae	Calluna	Calluna vulgaris
28916192	28916192	PRJNA767802_P_NODE_19208_length_152_cov_2.145631_g19135_i0	PRJNA767802	19208	152	2.145631	3.26135912	Cryptomeria japonica	3369	Plants	Plants	79	3.21e-17	NR	XP_057861572.1	3369	g19135	i0	71.4	0.967105263157895	49	14	96.7	0	151	5	70	118	XP_057861572.1 uncharacterized protein LOC131070035 [Cryptomeria japonica]	diamond	147	79	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
29326792	29326792	PRJNA767802_P_NODE_9829_length_229_cov_3.594444_g9756_i0	PRJNA767802	9829	229	3.594444	8.23127676	Glycine max	3847	Plants	Plants	92.8	3.06e-20	NR	NP_001242584.2	3847	g9756	i0	61	6.05240174672489	77	25	98.3	3	225	1	260	333	NP_001242584.2 cysteine proteinase RD21a-like precursor [Glycine max]	diamond	1386	92.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Glycine	Glycine max
30116289	30116289	PRJNA767802_P_NODE_4072_length_425_cov_5.776596_g3999_i0	PRJNA767802	4072	425	5.776596	24.550533	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	106	2.34e-26	NR	BAJ99260.1	112509	g3999	i0	39.5	0.875294117647059	124	75	87.5	0	6	377	6	129	BAJ99260.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	372	106	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
30621812	30621812	PRJNA767802_P_NODE_13353_length_188_cov_2.784173_g13280_i0	PRJNA767802	13353	188	2.784173	5.23424524	Sphagnum balticum	128184	Plants	Plants	40.4	0.0454	NR	CAM6001122.1	128184	g13280	i0	40.7	0.861702127659574	54	31	86.2	1	2	163	61	113	CAM6001122.1 unnamed protein product [Sphagnum balticum]	diamond	162	40.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
30969666	30969666	PRJNA767802_P_NODE_4734_length_384_cov_3.492537_g4661_i0	PRJNA767802	4734	384	3.492537	13.41134208	Nymphaea colorata	210225	Plants	Plants	186	4.63e-53	NR	XP_031505757.1	210225	g4661	i0	79	0.96875	124	20	92.2	1	362	9	512	635	XP_031505757.1 LOW QUALITY PROTEIN: V-type proton ATPase catalytic subunit A-like [Nymphaea colorata]	diamond	372	186	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Nymphaeales	Nymphaeaceae	Nymphaea	Nymphaea colorata
30979271	30979271	PRJNA767802_P_NODE_11474_length_207_cov_4.759494_g11401_i0	PRJNA767802	11474	207	4.759494	9.85215258	Eukaryota	2759	Plants	Plants	70.1	1.31e-12	NR	2ACT_A	3625	g11401	i0	61.2	7.91304347826087	49	16	71	1	20	166	165	210	2ACT_A Chain A, ACTINIDIN PRECURSOR [Actinidia chinensis]	diamond	1638	70.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Actinidiaceae	Actinidia	Actinidia chinensis
31136775	31136775	PRJNA767802_P_NODE_9475_length_235_cov_2.241935_g9402_i0	PRJNA767802	9475	235	2.241935	5.26854725	Stephania	147243	Plants	Plants	83.2	9.09e-19	NR	KAK9157353.1	152367	g9402	i0	51.5	2.52765957446808	66	32	84.3	0	225	28	24	89	KAK9157353.1 hypothetical protein Scep_003927 [Stephania cephalantha]	diamond	594	84	0.990476190476191	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Menispermaceae	Stephania	Stephania cephalantha
31326726	31326726	PRJNA767802_P_NODE_12295_length_199_cov_1.353333_g12222_i0	PRJNA767802	12295	199	1.353333	2.69313267	Magnoliopsida	3398	Plants	Plants	99	1.53e-22	NR	KAI7754696.1	4212	g12222	i0	68.9	8.30653266331658	61	17	92	1	197	15	245	303	KAI7754696.1 hypothetical protein M8C21_005315, partial [Ambrosia artemisiifolia]	diamond	1653	100	0.99	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Ambrosia	Ambrosia artemisiifolia
32171466	32171466	PRJNA767802_P_NODE_8378_length_257_cov_4.600962_g8305_i0	PRJNA767802	8378	257	4.600962	11.82447234	Sphagnum balticum	128184	Plants	Plants	47.8	4.18e-4	NR	CAM6000962.1	128184	g8305	i0	54.5	0.513618677042802	44	20	51.4	0	251	120	28	71	CAM6000962.1 unnamed protein product [Sphagnum balticum]	diamond	132	47.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
32307780	32307780	PRJNA767802_P_NODE_9139_length_241_cov_3.614583_g9066_i0	PRJNA767802	9139	241	3.614583	8.71114503	root	1	Root_unresolved	Root_unresolved	95.5	7.37e-21	NR	KAJ3695967.1	13579	g9066	i0	56	7.21991701244813	75	30	93.4	2	12	236	267	338	KAJ3695967.1 hypothetical protein LUZ60_001344 [Juncus effusus]	diamond	1740	95.9	0.995828988529718	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Juncaceae	Juncus	Juncus effusus
32560821	32560821	PRJNA767802_P_NODE_5219_length_357_cov_4.480519_g5146_i0	PRJNA767802	5219	357	4.480519	15.99545283	Eukaryota	2759	Plants	Plants	65.9	1.12e-9	NR	XP_025812550.1	206008	g5146	i0	37.8	5.10924369747899	98	52	74.8	2	15	281	1293	1390	XP_025812550.1 ARF guanine-nucleotide exchange factor GNOM-like [Panicum hallii]	diamond	1824	65.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Panicum	Panicum hallii
32623469	32623469	PRJNA767802_P_NODE_12380_length_198_cov_1.342282_g12307_i0	PRJNA767802	12380	198	1.342282	2.65771836	Eukaryota	2759	Plants	Plants	73.6	2.65e-13	NR	NP_566633.1	3702	g12307	i0	58.2	14.2272727272727	67	25	98.5	2	3	197	244	309	NP_566633.1 Granulin repeat cysteine protease family protein [Arabidopsis thaliana]	diamond	2817	74.3	0.990578734858681	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Arabidopsis	Arabidopsis thaliana

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