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

9 rows where analysis = "blastn", bioproject = "PRJEB17675" 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
2571574	2571574	PRJEB17675_P_NODE_7383_length_340_cov_1.836066_g7079_i0	PRJEB17675	7383	340	1.836066	6.2426244	Pythium sp. FFM-2010	888549	SAR_Eukaryotes	SAR_Eukaryotes	97.1	1.46e-15	NTclustered	gi\|312165791\|gb\|GU222162.1\|	888549	g7079	i0	88.75	7.5	80	8	24	1	261	340	619	541	Pythium sp. FFM-2010 isolate P8209 cytochrome oxidase subunit 2 (cox2) and cytochrome oxidase subunit 1 (cox1) genes, partial cds; mitochondrial	blastn	2550	97.1	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium sp. FFM-2010
10224413	10224413	PRJEB17675_P_NODE_2129_length_672_cov_3.854003_g1894_i0	PRJEB17675	2129	672	3.854003	25.89890016	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	283	2.18e-71	NTclustered	gi\|2794877204\|ref\|XM_067892388.1\|	164328	g1894	i0	80.052	7.02529761904762	386	73	57	4	118	501	64	447	Phytophthora ramorum 40S ribosomal protein S14 (KRP23_72), partial mRNA	blastn	4721	283	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
13739319	13739319	PRJEB17675_P_NODE_4571_length_455_cov_2.816667_g4274_i0	PRJEB17675	4571	455	2.816667	12.81583485	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	348	5.02e-91	NTclustered	gi\|1938229356\|dbj\|LC595853.1\|	1985165	g4274	i0	83.836	65.1142857142857	365	59	80	0	1	365	365	1	Phytophthora castanetorum CBS 142299 btub gene for beta-tubulin, partial cds	blastn	29627	348	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora castanetorum
18837651	18837651	PRJEB17675_P_NODE_18855_length_181_cov_1.095890_g18551_i0	PRJEB17675	18855	181	1.09589	1.9835609	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	87.9	4.21e-13	NTclustered	gi\|2248512876\|ref\|NC_063791.1\|	29920	g18551	i0	84.27	1.68508287292818	89	14	49	0	72	160	21440	21528	Phytophthora cactorum isolate 10300 mitochondrion, complete genome	blastn	305	87.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cactorum
19147108	19147108	PRJEB17675_P_NODE_13976_length_220_cov_1.945946_g13672_i0	PRJEB17675	13976	220	1.945946	4.2810812	Phytophthora infestans	4787	SAR_Eukaryotes	SAR_Eukaryotes	198	2.36e-46	NTclustered	gi\|301115307\|ref\|XM_002905337.1\|	403677	g13672	i0	86.592	81.3909090909091	179	24	81	0	2	180	742	920	Phytophthora infestans T30-4 translation elongation factor 1-alpha, putative (PITG_04640), partial mRNA	blastn	17906	198	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora infestans
21698379	21698379	PRJEB17675_P_NODE_20618_length_170_cov_1.770370_g20314_i0	PRJEB17675	20618	170	1.77037	3.009629	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	95.3	2.33e-15	NTclustered	gi\|813184937\|ref\|XM_012351251.1\|	695850	g20314	i0	83.178	2.08823529411765	107	14	62	3	8	112	250	146	Saprolegnia parasitica CBS 223.65 40S ribosomal protein S14 mRNA	blastn	355	95.3	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
22973677	22973677	PRJEB17675_P_NODE_6659_length_363_cov_1.536585_g6356_i0	PRJEB17675	6659	363	1.536585	5.57780355	Phytophthora sojae	67593	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.01	NTclustered	gi\|695379224\|ref\|XM_009518191.1\|	67593	g6356	i0	100	0.159779614325069	29	0	8	0	323	351	1863	1835	Phytophthora sojae hypothetical protein partial mRNA	blastn	58	54.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
24247480	24247480	PRJEB17675_P_NODE_19340_length_178_cov_1.118881_g19036_i0	PRJEB17675	19340	178	1.118881	1.99160818	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	135	1.4500000000000002e-27	NTclustered	gi\|698822852\|ref\|XM_009846153.1\|	112090	g19036	i0	81.176	4.73033707865169	170	30	95	2	1	169	615	783	Aphanomyces astaci CK1/CK1/CK1-D protein kinase mRNA	blastn	842	135	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
25211919	25211919	PRJEB17675_P_NODE_3240_length_545_cov_5.815686_g2964_i0	PRJEB17675	3240	545	5.815686	31.6954887	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	152	5.139999999999999e-32	NTclustered	gi\|533310373\|ref\|NC_022179.1\|	74557	g2964	i0	77.007	40.2752293577982	274	57	50	4	275	545	12106	12376	Thraustotheca clavata mitochondrion, complete genome	blastn	21950	152	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata

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