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

10 rows where analysis = "diamond", bioproject = "PRJNA993416" 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
21377951	21377951	PRJNA993416_P_NODE_12597_length_251_cov_0.865169_g12492_i0	PRJNA993416	12597	251	0.865169	2.17157419	Citrus x changshan-huyou	2935761	Plants	Plants	62	2.34e-10	NR	KAK9178132.1	2935761	g12492	i0	83.8	1.44621513944223	37	6	44.2	0	137	247	54	90	KAK9178132.1 hypothetical protein WN943_027322 [Citrus x changshan-huyou]	diamond	363	62	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus x changshan-huyou
26715412	26715412	PRJNA993416_P_NODE_13581_length_248_cov_0.880000_g13476_i0	PRJNA993416	13581	248	0.88	2.1824	Citrus	2706	Plants	Plants	110	1.92e-26	NR	KAH9724974.1	2711	g13476	i0	64.6	1.98387096774194	82	29	99.2	0	2	247	66	147	KAH9724974.1 hypothetical protein KPL70_007691 [Citrus sinensis]	diamond	492	110	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis
26804879	26804879	PRJNA993416_P_NODE_13141_length_249_cov_0.875000_g13036_i0	PRJNA993416	13141	249	0.875	2.17875	Camellia sinensis	4442	Plants	Plants	155	1.08e-42	NR	KAF5944114.1	4442	g13036	i0	97.5	0.975903614457831	81	2	97.6	0	244	2	1	81	KAF5944114.1 hypothetical protein HYC85_018191 [Camellia sinensis]	diamond	243	155	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
28769231	28769231	PRJNA993416_P_NODE_14367_length_246_cov_0.890173_g14262_i0	PRJNA993416	14367	246	0.890173	2.18982558	Citrus	2706	Plants	Plants	133	7.72e-39	NR	GAY53430.1	55188	g14262	i0	93	1.73170731707317	71	5	86.6	0	236	24	9	79	GAY53430.1 hypothetical protein CUMW_149200 [Citrus unshiu]	diamond	426	133	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus unshiu
30879485	30879485	PRJNA993416_P_NODE_12414_length_251_cov_0.865169_g12309_i0	PRJNA993416	12414	251	0.865169	2.17157419	Cucumis melo var. makuwa	1194695	Plants	Plants	73.9	4.08e-13	NR	KAA0062674.1	1194695	g12309	i0	62.9	0.741035856573705	62	23	74.1	0	52	237	420	481	KAA0062674.1 uncharacterized protein E6C27_scaffold79G001940 [Cucumis melo var. makuwa]	diamond	186	73.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucumis	Cucumis melo
31037851	31037851	PRJNA993416_P_NODE_15035_length_244_cov_0.900585_g14930_i0	PRJNA993416	15035	244	0.900585	2.1974274	Citrus sinensis	2711	Plants	Plants	105	2.74e-26	NR	KDO51518.1	2711	g14930	i0	96.2	0.651639344262295	53	2	65.2	0	243	85	160	212	KDO51518.1 hypothetical protein CISIN_1g047158mg [Citrus sinensis]	diamond	159	105	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis
31169555	31169555	PRJNA993416_P_NODE_5155_length_368_cov_1.525424_g5050_i0	PRJNA993416	5155	368	1.525424	5.61356032	root	1	Root_unresolved	Root_unresolved	99.8	2.39e-24	NR	CAK9251252.1	128206	g5050	i0	49.5	1.51630434782609	91	45	74.2	1	74	346	22	111	CAK9251252.1 unnamed protein product [Sphagnum jensenii]	diamond	558	100	0.998	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum jensenii
31606711	31606711	PRJNA993416_P_NODE_15196_length_244_cov_0.877193_g15091_i0	PRJNA993416	15196	244	0.877193	2.14035092	Citrus unshiu	55188	Plants	Plants	61.6	8.08e-9	NR	GAY62633.1	55188	g15091	i0	78.1	0.39344262295082	32	7	39.3	0	12	107	588	619	GAY62633.1 hypothetical protein CUMW_219430, partial [Citrus unshiu]	diamond	96	61.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus unshiu
32023894	32023894	PRJNA993416_P_NODE_8198_length_289_cov_1.828704_g8093_i0	PRJNA993416	8198	289	1.828704	5.28495456	Eukaryota	2759	Plants	Plants	55.8	7.71e-7	NR	XP_008665317.1	4577	g8093	i0	89.7	23.0865051903114	29	3	30.1	0	183	269	20	48	XP_008665317.1 ras-related protein RABE1c [Zea mays]	diamond	6672	55.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Zea	Zea mays
32687572	32687572	PRJNA993416_P_NODE_11520_length_260_cov_0.941176_g11415_i0	PRJNA993416	11520	260	0.941176	2.4470576	Eukaryota	2759	Plants	Plants	93.2	1.39e-21	NR	AAZ95077.1	3884	g11415	i0	57.1	25.6846153846154	84	36	96.9	0	9	260	29	112	AAZ95077.1 actin, partial [Phaseolus lunatus]	diamond	6678	93.6	0.995726495726496	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Phaseolus	Phaseolus lunatus

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