metadata: contig_metadata: 4 rows where bioproject = "PRJNA1248424", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA1248424", tax_clade = "Sar" 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
4180135	4180135	PRJNA1248424_P_NODE_55124_length_288_cov_1.209302_g49056_i0	PRJNA1248424	55124	288	1.209302	3.48278976	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	230	1.1499999999999995e-55	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g49056	i0	84.956	103.777777777778	226	34	78	0	1	226	74	299	Aphanomyces astaci polyubiquitin mRNA	blastn	29888	230	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
6730757	6730757	PRJNA1248424_P_NODE_60086_length_275_cov_1.910891_g54018_i0	PRJNA1248424	60086	275	1.910891	5.25495025	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.51e-4	NTclustered	gi\|675177482\|ref\|XM_008899378.1\|	761204	g54018	i0	97.143	0.254545454545455	35	1	13	0	223	257	470	436	Phytophthora parasitica INRA-310 hypothetical protein mRNA	blastn	70	60.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
24579314	24579314	PRJNA1248424_P_NODE_58660_length_279_cov_1.388350_g52592_i0	PRJNA1248424	58660	279	1.38835	3.8734965	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	507	4.56e-139	NTclustered	gi\|301092521\|ref\|XM_002997070.1\|	403677	g52592	i0	99.639	0.992831541218638	277	1	99	0	1	277	545	821	Phytophthora infestans T30-4 uncharacterized protein (PITG_19046), mRNA	blastn	277	507	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
30453003	30453003	PRJNA1248424_P_NODE_14933_length_1235_cov_10.693632_g10494_i0	PRJNA1248424	14933	1235	10.693632	132.0663552	Aphanomyces cochlioides	112091	SAR_Eukaryotes	SAR_Eukaryotes	48.1	0.0217	NR	KAG9410614.1	112091	g10494	i0	32.1	0.25748987854251	106	67	25.7	3	1023	706	24	124	KAG9410614.1 hypothetical protein AC1031_018638 [Aphanomyces cochlioides]	diamond	318	48.1	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces cochlioides

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