metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1088503" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1088503" 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
15497126	15497126	PRJNA1088503_P_NODE_1193_length_828_cov_13751.090113_g1055_i0	PRJNA1088503	1193	828	13751.090113	113859.02613564	Cryptomeria japonica	3369	Plants	Plants	310	2.15e-102	NR	XP_057835526.1	3369	g1055	i0	85.9	0.641304347826087	177	25	64.1	0	794	264	124	300	XP_057835526.1 NADPH-dependent aldehyde reductase 1, chloroplastic isoform X2 [Cryptomeria japonica]	diamond	531	310	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Cupressaceae	Cryptomeria	Cryptomeria japonica
20595558	20595558	PRJNA1088503_P_NODE_1437_length_756_cov_15777.928473_g1271_i0	PRJNA1088503	1437	756	15777.928473	119281.13925588	Magnoliopsida	3398	Plants	Plants	280	2.57e-92	NR	XP_062156494.1	3517	g1271	i0	85.3	5.1984126984127	163	24	64.7	0	721	233	34	196	XP_062156494.1 coatomer subunit zeta-1-like isoform X2 [Alnus glutinosa]	diamond	3930	281	0.99644128113879	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Alnus	Alnus glutinosa
27320481	27320481	PRJNA1088503_P_NODE_6763_length_288_cov_366.521236_g6391_i0	PRJNA1088503	6763	288	366.521236	1055.58115968	Acorus calamus	4465	Plants	Plants	47.8	9.94e-4	NR	KAK1322617.1	4465	g6391	i0	83.3	0.5	24	4	25	0	260	189	294	317	KAK1322617.1 Transcription initiation factor IIB [Acorus calamus]	diamond	144	47.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Acorales	Acoraceae	Acorus	Acorus calamus
28078145	28078145	PRJNA1088503_P_NODE_5105_length_362_cov_32368.846847_g4735_i0	PRJNA1088503	5105	362	32368.846847	117175.22558614	Lupinus luteus	3873	Plants	Plants	48.1	5.29e-4	NR	CAL0323252.1	3873	g4735	i0	67.5	0.331491712707182	40	10	30.7	1	326	216	104	143	CAL0323252.1 unnamed protein product [Lupinus luteus]	diamond	120	48.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lupinus	Lupinus luteus
28235822	28235822	PRJNA1088503_P_NODE_10926_length_167_cov_3951.601449_g10554_i0	PRJNA1088503	10926	167	3951.601449	6599.17441983	Tanacetum cinerariifolium	118510	Plants	Plants	41.6	0.0349	NR	GEW59217.1	118510	g10554	i0	34	0.844311377245509	47	31	84.4	0	163	23	562	608	GEW59217.1 RNA-directed DNA polymerase, eukaryota [Tanacetum cinerariifolium]	diamond	141	41.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Tanacetum	Tanacetum cinerariifolium
28898983	28898983	PRJNA1088503_P_NODE_9448_length_205_cov_61102.329545_g9076_i0	PRJNA1088503	9448	205	61102.329545	125259.77556725	Asparagus officinalis	4686	Plants	Plants	45.8	0.00124	NR	XP_020247367.1	4686	g9076	i0	76.9	0.380487804878049	26	6	38	0	34	111	164	189	XP_020247367.1 ras-related protein RABC1 isoform X2 [Asparagus officinalis]	diamond	78	45.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Asparagaceae	Asparagus	Asparagus officinalis
29688198	29688198	PRJNA1088503_P_NODE_4410_length_406_cov_28593.395225_g4049_i0	PRJNA1088503	4410	406	28593.395225	116089.1846135	Capsella rubella	81985	Plants	Plants	43.9	0.0106	NR	EOA37876.1	81985	g4049	i0	45	1.40394088669951	40	19	27.3	1	101	211	41	80	EOA37876.1 hypothetical protein CARUB_v10011472mg [Capsella rubella]	diamond	570	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Capsella	Capsella rubella
30352431	30352431	PRJNA1088503_P_NODE_10212_length_185_cov_3.807692_g9840_i0	PRJNA1088503	10212	185	3.807692	7.0442302	Shorea laevis	152420	Plants	Plants	131	1.46e-34	NR	GLT53731.1	152420	g9840	i0	98.4	0.989189189189189	61	1	98.9	0	185	3	369	429	GLT53731.1 hypothetical protein SLA2020_269820 [Shorea laevis]	diamond	183	131	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Dipterocarpaceae	Shorea	Shorea laevis

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