metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1002816" 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
7805410	7805410	PRJNA1002816_P_NODE_17127_length_255_cov_1.269231_g16967_i0	PRJNA1002816	17127	255	1.269231	3.23653905	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|187468407\|emb\|CU855855.1\|	123356	g16967	i0	100	0.109803921568627	28	0	11	0	176	203	107949	107976	H.parasitica DNA sequence from clone HpEmoy2-17E12, complete sequence	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
16729668	16729668	PRJNA1002816_P_NODE_10954_length_336_cov_1.266160_g10794_i0	PRJNA1002816	10954	336	1.26616	4.2542976	Phytophthora palmivora	4796	SAR_Eukaryotes	SAR_Eukaryotes	243	1.75e-59	NTclustered	gi\|2026389858\|gb\|MT032128.1\|	4796	g10794	i0	80.122	70.2440476190476	327	63	97	2	1	326	13682	14007	Phytophthora palmivora mitochondrion, complete genome	blastn	23602	243	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora palmivora
16729748	16729748	PRJNA1002816_P_NODE_14894_length_282_cov_1.162679_g14734_i0	PRJNA1002816	14894	282	1.162679	3.27875478	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	254	6.64e-63	NTclustered	gi\|698815387\|ref\|XM_009842421.1\|	112090	g14734	i0	87.054	71.3794326241135	224	29	79	0	59	282	64	287	Aphanomyces astaci actin mRNA	blastn	20129	254	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
18004666	18004666	PRJNA1002816_P_NODE_20735_length_241_cov_1.035714_g20575_i0	PRJNA1002816	20735	241	1.035714	2.49607074	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	93.5	1.28e-14	NTclustered	gi\|813156946\|ref\|XM_012346432.1\|	695850	g20575	i0	93.548	35.850622406639	62	4	26	0	15	76	136	75	Saprolegnia parasitica CBS 223.65 histone H2B partial mRNA	blastn	8640	93.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
25227076	25227076	PRJNA1002816_P_NODE_15120_length_279_cov_1.490291_g14960_i0	PRJNA1002816	15120	279	1.490291	4.15791189	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	159	1.47e-34	NTclustered	gi\|813156379\|ref\|XM_012346149.1\|	695850	g14960	i0	83.237	3.56989247311828	173	29	62	0	107	279	439	267	Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA	blastn	996	159	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);;