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

10 rows where analysis = "diamond", bioproject = "PRJNA890871" 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
5968234	5968234	PRJNA890871_P_NODE_65225_length_250_cov_0.870056_g65090_i0	PRJNA890871	65225	250	0.870056	2.17514	Magnoliopsida	3398	Plants	Plants	130	8.82e-34	NR	KAK9134561.1	152371	g65090	i0	73.5	11.88	83	22	99.6	0	2	250	224	306	KAK9134561.1 hypothetical protein Syun_013891 [Stephania yunnanensis]	diamond	2970	130	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Menispermaceae	Stephania	Stephania yunnanensis
26897460	26897460	PRJNA890871_P_NODE_22401_length_348_cov_3.432727_g22266_i0	PRJNA890871	22401	348	3.432727	11.94588996	Adiantum nelumboides	2759587	Plants	Plants	57	1.17e-6	NR	MCO5564312.1	2759587	g22266	i0	45.2	0.53448275862069	62	30	50	1	346	173	383	444	MCO5564312.1 hypothetical protein [Adiantum nelumboides]	diamond	186	57	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides
27568814	27568814	PRJNA890871_P_NODE_68404_length_249_cov_0.875000_g68269_i0	PRJNA890871	68404	249	0.875	2.17875	Magnoliopsida	3398	Plants	Plants	48.1	2.47e-4	NR	XP_062164987.1	3517	g68269	i0	56.8	1.1566265060241	37	16	44.6	0	111	1	34	70	XP_062164987.1 uncharacterized protein LOC133871574 [Alnus glutinosa]	diamond	288	48.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Alnus	Alnus glutinosa
28855454	28855454	PRJNA890871_P_NODE_86468_length_241_cov_0.916667_g86333_i0	PRJNA890871	86468	241	0.916667	2.20916747	Trema orientale	63057	Plants	Plants	54.7	1.84e-6	NR	PON81789.1	63057	g86333	i0	54.3	0.572614107883817	46	19	54.8	1	50	181	19	64	PON81789.1 hypothetical protein TorRG33x02_224000 [Trema orientale]	diamond	138	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Trema	Trema orientale
28887097	28887097	PRJNA890871_P_NODE_78188_length_244_cov_1.567251_g78053_i0	PRJNA890871	78188	244	1.567251	3.82409244	Taxus chinensis	29808	Plants	Plants	57.4	2.62e-7	NR	KAH9302361.1	29808	g78053	i0	57.1	0.688524590163934	56	24	68.9	0	241	74	18	73	KAH9302361.1 hypothetical protein KI387_013944, partial [Taxus chinensis]	diamond	168	57.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
28982128	28982128	PRJNA890871_P_NODE_54808_length_260_cov_1.647059_g54673_i0	PRJNA890871	54808	260	1.647059	4.2823534	Parasponia andersonii	3476	Plants	Plants	54.7	2.05e-6	NR	PON73138.1	3476	g54673	i0	85.2	0.311538461538462	27	4	31.2	0	259	179	174	200	PON73138.1 Cytokinin riboside 5'-monophosphate phosphoribohydrolase, partial [Parasponia andersonii]	diamond	81	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Parasponia	Parasponia andersonii
29462968	29462968	PRJNA890871_P_NODE_83530_length_242_cov_0.911243_g83395_i0	PRJNA890871	83530	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	50.1	8.52e-5	NR	CAD6342903.1	422564	g83395	i0	33.3	1.78512396694215	72	43	83.1	1	202	2	166	237	CAD6342903.1 unnamed protein product [Miscanthus lutarioriparius]	diamond	432	50.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Miscanthus	Miscanthus lutarioriparius
32332167	32332167	PRJNA890871_P_NODE_47919_length_269_cov_2.362245_g47784_i0	PRJNA890871	47919	269	2.362245	6.35443905	Corchorus olitorius	93759	Plants	Plants	70.9	5.63e-12	NR	OMP13600.1	93759	g47784	i0	40.5	0.825278810408922	74	44	82.5	0	225	4	240	313	OMP13600.1 hypothetical protein COLO4_01328, partial [Corchorus olitorius]	diamond	222	70.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Corchorus	Corchorus olitorius
32332195	32332195	PRJNA890871_P_NODE_82859_length_242_cov_1.639053_g82724_i0	PRJNA890871	82859	242	1.639053	3.96650826	Parasponia andersonii	3476	Plants	Plants	56.2	6.46e-7	NR	PON52132.1	3476	g82724	i0	70	0.495867768595041	40	11	49.6	1	122	3	1	39	PON52132.1 Tetratricopeptide-like helical domain containing protein [Parasponia andersonii]	diamond	120	56.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Parasponia	Parasponia andersonii
32395237	32395237	PRJNA890871_P_NODE_88699_length_236_cov_2.214724_g88564_i0	PRJNA890871	88699	236	2.214724	5.22674864	Trema orientale	63057	Plants	Plants	77.8	9.7e-16	NR	PON68471.1	63057	g88564	i0	60	1.39830508474576	55	22	69.9	0	33	197	122	176	PON68471.1 Ulp1 protease family, C-terminal catalytic domain containing protein [Trema orientale]	diamond	330	77.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Trema	Trema orientale

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