metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA934332" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA934332" and tax_phylum = "Oomycota"

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
3461467	3461467	PRJNA934332_P_NODE_10583_length_243_cov_0.905882_g10496_i0	PRJNA934332	10583	243	0.905882	2.20129326	Plectospira myriandra	100863	SAR_Eukaryotes	SAR_Eukaryotes	182	2.68e-41	NTclustered	gi\|57903345\|gb\|AY729823.1\|	100863	g10496	i0	82.297	86.1069958847737	209	37	86	0	13	221	694	902	Plectospira myriandra beta-tubulin gene, partial cds	blastn	20924	182	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Plectospira	Plectospira myriandra
3807474	3807474	PRJNA934332_P_NODE_9483_length_246_cov_0.890173_g9396_i0	PRJNA934332	9483	246	0.890173	2.18982558	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	163	9.84e-36	NTclustered	gi\|2795045662\|ref\|XM_067939157.1\|	4785	g9396	i0	92.174	38.6666666666667	115	9	47	0	132	246	23	137	Phytophthora cinnamomi ribonucleoprotein-associated protein (IUM83_14412), partial mRNA	blastn	9512	163	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
6013877	6013877	PRJNA934332_P_NODE_6865_length_262_cov_1.322751_g6778_i0	PRJNA934332	6865	262	1.322751	3.46560762	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	172	1.76e-38	NTclustered	gi\|675199790\|ref\|XM_008910532.1\|	761204	g6778	i0	82.653	0.748091603053435	196	32	74	2	2	196	1081	1275	Phytophthora parasitica INRA-310 T-complex protein 1, epsilon subunit mRNA	blastn	196	172	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
7288692	7288692	PRJNA934332_P_NODE_10066_length_244_cov_0.900585_g9979_i0	PRJNA934332	10066	244	0.900585	2.1974274	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	165	2.71e-36	NTclustered	gi\|2795040748\|ref\|XM_067932530.1\|	4785	g9979	i0	79.654	10.4139344262295	231	45	94	2	1	230	2	231	Phytophthora cinnamomi ABC transporter E family member 2 (IUM83_08175), partial mRNA	blastn	2541	165	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
7633545	7633545	PRJNA934332_P_NODE_11446_length_236_cov_2.361963_g11359_i0	PRJNA934332	11446	236	2.361963	5.57423268	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	139	1.58e-28	NTclustered	gi\|23394393\|gb\|AF424661.1\|	4787	g11359	i0	83.553	2.8135593220339	152	21	64	4	48	197	139	288	Phytophthora infestans clone MY-10-D-12 cystathionine beta-synthase mRNA, complete cds	blastn	664	139	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
9838582	9838582	PRJNA934332_P_NODE_2208_length_416_cov_2.402332_g2121_i0	PRJNA934332	2208	416	2.402332	9.99370112	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	237	1.03e-57	NTclustered	gi\|813142527\|ref\|XM_012343931.1\|	695850	g2121	i0	77.358	26.3581730769231	424	81	99	15	1	415	654	237	Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA	blastn	10965	237	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
12734854	12734854	PRJNA934332_P_NODE_750_length_693_cov_2.129032_g670_i0	PRJNA934332	750	693	2.129032	14.75419176	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	326	3.69e-84	NTclustered	gi\|156987613\|gb\|EU079765.1\|	67594	g670	i0	78.302	62.8917748917749	530	94	75	16	124	641	821	301	Phytophthora syringae isolate PD_00013(P10332) translation elongation factor 1-alpha (EF1A) gene, partial cds	blastn	43584	326	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora syringae
14938520	14938520	PRJNA934332_P_NODE_4312_length_317_cov_0.946721_g4225_i0	PRJNA934332	4312	317	0.946721	3.00110557	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	165	3.66e-36	NTclustered	gi\|2794920874\|ref\|XM_067880626.1\|	164328	g4225	i0	78.439	85.3186119873817	269	46	84	10	48	313	1257	998	Phytophthora ramorum Adenosylhomocysteinase (KRP23_10205), partial mRNA	blastn	27046	165	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
22587575	22587575	PRJNA934332_P_NODE_2018_length_432_cov_1.175487_g1931_i0	PRJNA934332	2018	432	1.175487	5.07810384	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	291	8.12e-74	NTclustered	gi\|813142527\|ref\|XM_012343931.1\|	695850	g1931	i0	79.446	24.9930555555556	433	72	98	16	2	424	207	632	Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA	blastn	10797	291	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica

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