metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1032461" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1032461" 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	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
20568263	20568263	PRJNA1032461_S_NODE_8277_length_210_cov_2.900621_g8179_i0	PRJNA1032461	8277	210	2.900621	6.0913041	Brassica	3705	Plants	Plants	84.7	3.89e-17	NR	CDY19657.1	3708	g8179	i0	88.7	10.1714285714286	62	7	88.6	24	209	699	760	CDY19657.1 BnaC09g29130D [Brassica napus]	diamond	2136	84.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica napus
24393137	24393137	PRJNA1032461_S_NODE_18460_length_165_cov_0.896552_g18362_i0	PRJNA1032461	18460	165	0.896552	1.4793108	Cannabis sativa	3483	Plants	Plants	85.1	1.56e-17	NR	XP_060972445.1	3483	g18362	i0	69.1	1	55	17	100	1	165	1979	2033	XP_060972445.1 uncharacterized protein LOC133038339 [Cannabis sativa]	diamond	165	85.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
27351470	27351470	PRJNA1032461_S_NODE_9603_length_198_cov_1.221477_g9505_i0	PRJNA1032461	9603	198	1.221477	2.41852446	Phtheirospermum japonicum	374723	Plants	Plants	59.7	2.18e-8	NR	GFQ00511.1	374723	g9505	i0	75.7	5.46969696969697	37	9	56.1	88	198	81	117	GFQ00511.1 60S ribosomal protein l12-3 [Phtheirospermum japonicum]	diamond	1083	59.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Orobanchaceae	Phtheirospermum	Phtheirospermum japonicum
27572232	27572232	PRJNA1032461_S_NODE_20464_length_163_cov_0.912281_g20366_i0	PRJNA1032461	20464	163	0.912281	1.48701803	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	94.7	6.16e-21	NR	XP_040245306.1	200361	g20366	i0	79.6	4.96932515337423	54	11	99.4	162	1	858	911	XP_040245306.1 uncharacterized protein LOC120964586 [Aegilops tauschii subsp. strangulata]	diamond	810	94.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii
27911360	27911360	PRJNA1032461_S_NODE_17205_length_166_cov_0.888889_g17107_i0	PRJNA1032461	17205	166	0.888889	1.47555574	Brassica	3705	Plants	Plants	102	1.74e-23	NR	WZZ65928.1	3708	g17107	i0	100	3.97590361445783	55	0	99.4	1	165	825	879	WZZ65928.1 hypothetical protein YC2023_077298 [Brassica napus]	diamond	660	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica napus
28361491	28361491	PRJNA1032461_S_NODE_19446_length_164_cov_0.904348_g19348_i0	PRJNA1032461	19446	164	0.904348	1.48313072	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	75.5	3.63e-14	NR	XP_020195405.1	200361	g19348	i0	77.8	0.98780487804878	54	12	98.8	163	2	625	678	XP_020195405.1 uncharacterized protein LOC109781215 [Aegilops tauschii subsp. strangulata]	diamond	162	75.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii
29395616	29395616	PRJNA1032461_S_NODE_18909_length_164_cov_1.321739_g18811_i0	PRJNA1032461	18909	164	1.321739	2.16765196	Brassicaceae	3700	Plants	Plants	80.5	6.28e-16	NR	KAG7558973.1	1240361	g18811	i0	73.5	6.20121951219512	49	13	89.6	156	10	1177	1225	KAG7558973.1 Endonuclease/exonuclease/phosphatase superfamily [Arabidopsis thaliana x Arabidopsis arenosa]	diamond	1017	80.9	0.995055624227441	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Arabidopsis	Arabidopsis thaliana x Arabidopsis arenosa
29466318	29466318	PRJNA1032461_S_NODE_14150_length_169_cov_1.025000_g14052_i0	PRJNA1032461	14150	169	1.025	1.73225	Sinapis alba	3728	Plants	Plants	67	3.78e-11	NR	KAF8079974.1	3728	g14052	i0	78.8	0.585798816568047	33	7	58.6	2	100	128	160	KAF8079974.1 hypothetical protein N665_0986s0001 [Sinapis alba]	diamond	99	67	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Sinapis	Sinapis alba
29908923	29908923	PRJNA1032461_S_NODE_16391_length_167_cov_0.881356_g16293_i0	PRJNA1032461	16391	167	0.881356	1.47186452	Brassica cretica	69181	Plants	Plants	42.7	0.00667	NR	KAF2588671.1	69181	g16293	i0	66.7	0.431137724550898	24	8	43.1	96	167	30	53	KAF2588671.1 hypothetical protein F2Q70_00041115 [Brassica cretica]	diamond	72	42.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Brassica	Brassica cretica
29940527	29940527	PRJNA1032461_S_NODE_15111_length_168_cov_1.042017_g15013_i0	PRJNA1032461	15111	168	1.042017	1.75058856	Sinapis alba	3728	Plants	Plants	69.3	5.8e-12	NR	KAF8079974.1	3728	g15013	i0	73.8	0.75	42	11	75	168	43	42	83	KAF8079974.1 hypothetical protein N665_0986s0001 [Sinapis alba]	diamond	126	69.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Sinapis	Sinapis alba

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