metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA532380" 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
504313	504313	PRJNA532380_P_NODE_7301_length_354_cov_1.534426_g6976_i0	PRJNA532380	7301	354	1.534426	5.43186804	Eukaryota	2759	Plants	Plants	191	1.16e-56	NR	DAD18900.1	4432	g6976	i0	73.5	181.389830508475	113	30	95.8	0	15	353	1	113	DAD18900.1 TPA_asm: hypothetical protein HUJ06_020363 [Nelumbo nucifera]	diamond	64212	192	0.994791666666667	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Proteales	Nelumbonaceae	Nelumbo	Nelumbo nucifera
5608040	5608040	PRJNA532380_P_NODE_6565_length_378_cov_3.358663_g6240_i0	PRJNA532380	6565	378	3.358663	12.69574614	Eukaryota	2759	Plants	Plants	212	2.08e-65	NR	XP_022154562.1	3673	g6240	i0	92	1207.8253968254	125	10	99.2	0	3	377	3	127	XP_022154562.1 uncharacterized protein LOC111021800 [Momordica charantia]	diamond	456558	214	0.990654205607477	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Momordica	Momordica charantia
17081324	17081324	PRJNA532380_P_NODE_28634_length_168_cov_0.873950_g28309_i0	PRJNA532380	28634	168	0.87395	1.468236	Eukaryota	2759	Plants	Plants	92	1.4200000000000002e-21	NR	KAG5584562.1	4109	g28309	i0	85.7	56	56	8	100	0	168	1	128	183	KAG5584562.1 hypothetical protein H5410_044996 [Solanum commersonii]	diamond	9408	92.8	0.991379310344828	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Solanum	Solanum commersonii
22181043	22181043	PRJNA532380_P_NODE_8938_length_315_cov_1.030075_g8613_i0	PRJNA532380	8938	315	1.030075	3.24473625	Eukaryota	2759	Plants	Plants	194	3.87e-59	NR	XP_022029438.1	4232	g8613	i0	81.6	431.638095238095	103	19	98.1	0	2	310	123	225	XP_022029438.1 serine/threonine-protein phosphatase PP1 [Helianthus annuus]	diamond	135966	195	0.994871794871795	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asterales	Asteraceae	Helianthus	Helianthus annuus
27250655	27250655	PRJNA532380_P_NODE_1123_length_992_cov_1.360551_g942_i0	PRJNA532380	1123	992	1.360551	13.49666592	Eukaryota	2759	Plants	Plants	80.1	4.14e-13	NR	XP_024376907.1	3218	g942	i0	55.9	5.51612903225806	68	29	20.6	1	10	213	128	194	XP_024376907.1 THO complex subunit 4B-like [Physcomitrium patens]	diamond	5472	80.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Funariales	Funariaceae	Physcomitrium	Physcomitrium patens
28309360	28309360	PRJNA532380_P_NODE_14086_length_241_cov_1.625000_g13761_i0	PRJNA532380	14086	241	1.625	3.91625	Melastoma candidum	119954	Plants	Plants	42.4	0.0463	NR	KAI4369866.1	119954	g13761	i0	37.5	0.896265560165975	72	41	84.6	1	33	236	32	103	KAI4369866.1 hypothetical protein MLD38_018264 [Melastoma candidum]	diamond	216	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Melastomataceae	Melastoma	Melastoma candidum
28640320	28640320	PRJNA532380_P_NODE_3527_length_553_cov_1.956349_g3209_i0	PRJNA532380	3527	553	1.956349	10.81860997	Eukaryota	2759	Plants	Plants	219	7.4e-67	NR	XP_050153624.1	3752	g3209	i0	58.1	76.75226039783	179	73	96.6	2	552	19	198	375	XP_050153624.1 citrate synthase, mitochondrial-like isoform X2 [Malus sylvestris]	diamond	42444	221	0.990950226244344	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Malus	Malus sylvestris
28751333	28751333	PRJNA532380_P_NODE_29607_length_166_cov_1.777778_g29282_i0	PRJNA532380	29607	166	1.777778	2.95111148	Chara braunii	69332	Plants	Plants	62.8	1.12e-9	NR	GBG72451.1	69332	g29282	i0	50.9	1.96987951807229	55	26	99.4	1	166	2	17	70	GBG72451.1 hypothetical protein CBR_g12025 [Chara braunii]	diamond	327	62.8	1	Eukaryota		Viridiplantae	Streptophyta	Charophyceae	Charales	Characeae	Chara	Chara braunii
28892547	28892547	PRJNA532380_P_NODE_14208_length_240_cov_1.628272_g13883_i0	PRJNA532380	14208	240	1.628272	3.9078528	Eukaryota	2759	Plants	Plants	113	3.53e-27	NR	XP_044352331.1	4565	g13883	i0	60.8	4.9375	79	31	98.8	0	2	238	133	211	XP_044352331.1 probable aspartyl aminopeptidase [Triticum aestivum]	diamond	1185	113	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
30677727	30677727	PRJNA532380_P_NODE_3873_length_521_cov_88.063559_g3552_i0	PRJNA532380	3873	521	88.063559	458.81114239	Striga asiatica	4170	Plants	Plants	52	3.2e-5	NR	GER35861.1	4170	g3552	i0	38.2	0.869481765834933	76	35	38.6	3	324	124	35	107	GER35861.1 calmodulin-like protein [Striga asiatica]	diamond	453	52	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Orobanchaceae	Striga	Striga asiatica
32449033	32449033	PRJNA532380_P_NODE_27539_length_169_cov_0.866667_g27214_i0	PRJNA532380	27539	169	0.866667	1.46466723	Carya illinoinensis	32201	Plants	Plants	83.2	8.95e-18	NR	XP_042974939.1	32201	g27214	i0	63.6	0.976331360946746	55	20	97.6	0	3	167	175	229	XP_042974939.1 protein arginine N-methyltransferase 1.5-like [Carya illinoinensis]	diamond	165	83.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Juglandaceae	Carya	Carya illinoinensis
32543949	32543949	PRJNA532380_P_NODE_6299_length_387_cov_16.644970_g5974_i0	PRJNA532380	6299	387	16.64497	64.4160339	Adiantum nelumboides	2759587	Plants	Plants	49.7	6.61e-4	NR	MCO5602366.1	2759587	g5974	i0	36.6	0.992248062015504	71	39	50.4	2	249	55	437	507	MCO5602366.1 hypothetical protein [Adiantum nelumboides]	diamond	384	49.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Polypodiopsida	Polypodiales	Pteridaceae	Adiantum	Adiantum nelumboides

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