metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA316313" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA316313" and tax_clade = "Sar"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26694563	26694563	PRJNA316313_P_NODE_226581_length_187_cov_3.093333_g225195_i0	PRJNA316313	226581	187	3.093333	5.78453271	Hyaloperonospora arabidopsidis Emoy2	559515	SAR_Eukaryotes	SAR_Eukaryotes	56.6	2.05e-7	NR	BAP68992.1	559515	g225195	i0	96	0.401069518716578	25	1	40.1	0	2	76	90	114	BAP68992.1 RxLR effector candidate protein [Hyaloperonospora arabidopsidis Emoy2]	diamond	75	56.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora arabidopsidis
28559008	28559008	PRJNA316313_P_NODE_316887_length_187_cov_2.286667_g315501_i0	PRJNA316313	316887	187	2.286667	4.27606729	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00203	NR	KAL3789508.1	29204	g315501	i0	81	1.01069518716578	21	4	33.7	0	112	174	590	610	KAL3789508.1 hypothetical protein HJC23_009744 [Cyclotella cryptica]	diamond	189	45.4	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
28969354	28969354	PRJNA316313_P_NODE_156968_length_187_cov_4.413333_g155582_i0	PRJNA316313	156968	187	4.413333	8.25293271	Plasmodium vivax	5855	SAR_Eukaryotes	SAR_Eukaryotes	48.1	1.5e-4	NR	CAA63219.1	5855	g155582	i0	59.3	0.946524064171123	59	20	94.7	2	2	178	11	65	CAA63219.1 pva1 [Plasmodium vivax]	diamond	177	48.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium vivax
29680963	29680963	PRJNA316313_P_NODE_229970_length_187_cov_3.053333_g228584_i0	PRJNA316313	229970	187	3.053333	5.70973271	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	56.6	2.23e-7	NR	KAG3038693.1	29920	g228584	i0	88	1.20320855614973	25	3	40.1	0	187	113	277	301	KAG3038693.1 hypothetical protein PC121_g23873 [Phytophthora cactorum]	diamond	225	56.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
29870751	29870751	PRJNA316313_P_NODE_336671_length_185_cov_5.263514_g335285_i0	PRJNA316313	336671	185	5.263514	9.7375009	Stephanodiscaceae	1365474	SAR_Eukaryotes	SAR_Eukaryotes	48.5	1.57e-4	NR	KAL3817785.1	382380	g335285	i0	84	0.810810810810811	25	4	40.5	0	184	110	490	514	KAL3817785.1 hypothetical protein ACHAXA_005818 [Cyclostephanos tholiformis]	diamond	150	48.5	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
31116923	31116923	PRJNA316313_P_NODE_325255_length_187_cov_2.120000_g323869_i0	PRJNA316313	325255	187	2.12	3.9644	Peronospora destructor	86335	SAR_Eukaryotes	SAR_Eukaryotes	61.2	5.18e-9	NR	CAI5731156.1	86335	g323869	i0	48	1.20320855614973	75	26	99.5	1	186	1	139	213	CAI5731156.1 unnamed protein product [Peronospora destructor]	diamond	225	61.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora destructor
31925143	31925143	PRJNA316313_P_NODE_265877_length_187_cov_2.620000_g264491_i0	PRJNA316313	265877	187	2.62	4.8994	Peronosporaceae	4777	SAR_Eukaryotes	SAR_Eukaryotes	48.1	2.15e-4	NR	KAG6970755.1	29920	g264491	i0	95.8	6.36898395721925	24	1	38.5	0	114	185	243	266	KAG6970755.1 hypothetical protein JG687_00002455 [Phytophthora cactorum]	diamond	1191	48.5	0.991752577319588	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum

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