metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB50332" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB50332" 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
119529	119529	PRJEB50332_P_NODE_8081_length_235_cov_1.494253_g7999_i0	PRJEB50332	8081	235	1.494253	3.51149455	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	424	3.87e-114	NTclustered	gi\|166044499\|emb\|CU367408.1\|	100861	g7999	i0	99.149	1	235	2	100	0	1	235	683	449	Aphanomyces euteiches cDNA	blastn	235	424	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
5221873	5221873	PRJEB50332_P_NODE_2165_length_382_cov_2.570093_g2084_i0	PRJEB50332	2165	382	2.570093	9.81775526	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	206	2.6399999999999994e-48	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g2084	i0	79.795	57.9607329842932	292	51	75	4	98	382	441	151	Aphanomyces astaci polyubiquitin mRNA	blastn	22141	206	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
6497724	6497724	PRJEB50332_P_NODE_6546_length_245_cov_1.766304_g6464_i0	PRJEB50332	6546	245	1.766304	4.3274448	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	448	2.41e-121	NTclustered	gi\|166046682\|emb\|CU367792.1\|	100861	g6464	i0	99.592	98.6775510204082	245	1	100	0	1	245	674	430	Aphanomyces euteiches cDNA	blastn	24176	448	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
9046718	9046718	PRJEB50332_P_NODE_5428_length_264_cov_1.280788_g5346_i0	PRJEB50332	5428	264	1.280788	3.38128032	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	195	3.79e-45	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g5346	i0	80.62	23.3219696969697	258	45	97	5	10	264	207	462	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	6157	195	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
10322466	10322466	PRJEB50332_P_NODE_9869_length_225_cov_1.585366_g9787_i0	PRJEB50332	9869	225	1.585366	3.5670735	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	416	6.159999999999998e-112	NTclustered	gi\|166044636\|emb\|CU367545.1\|	100861	g9787	i0	100	42.4888888888889	225	0	100	0	1	225	268	492	Aphanomyces euteiches cDNA	blastn	9560	416	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
16696017	16696017	PRJEB50332_P_NODE_11434_length_216_cov_2.509677_g11352_i0	PRJEB50332	11434	216	2.509677	5.42090232	Achlya bisexualis	4766	SAR_Eukaryotes	SAR_Eukaryotes	204	4.9699999999999994e-48	NTclustered	gi\|2289\|emb\|X59936.1\|	4766	g11352	i0	88.235	76.1527777777778	170	20	79	0	7	176	170	1	A.bisexualis gene for actin	blastn	16449	204	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya bisexualis
24345302	24345302	PRJEB50332_P_NODE_18040_length_200_cov_3.424460_g17958_i0	PRJEB50332	18040	200	3.42446	6.84892	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	370	4.22e-98	NTclustered	gi\|166046668\|emb\|CU367778.1\|	100861	g17958	i0	100	43.875	200	0	100	0	1	200	287	88	Aphanomyces euteiches cDNA	blastn	8775	370	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
24345333	24345333	PRJEB50332_P_NODE_4800_length_277_cov_1.601852_g4718_i0	PRJEB50332	4800	277	1.601852	4.43713004	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	322	1.76e-83	NTclustered	gi\|698823278\|ref\|XM_009846366.1\|	112090	g4718	i0	87.681	24.2166064981949	276	34	99	0	1	276	314	39	Aphanomyces astaci 60S ribosomal protein mRNA	blastn	6708	322	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci

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