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

5 rows where analysis = "blastn", bioproject = "PRJNA335774" 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
8043276	8043276	PRJNA335774_P_NODE_12907_length_411_cov_1.754438_g12755_i0	PRJNA335774	12907	411	1.754438	7.21074018	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	58.4	8.49e-4	NTclustered	gi\|813110326\|ref\|XM_012339464.1\|	695850	g12755	i0	100	0.827250608272506	31	0	8	0	177	207	1849	1819	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	340	58.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
11869415	11869415	PRJNA335774_P_NODE_48390_length_241_cov_0.916667_g48238_i0	PRJNA335774	48390	241	0.916667	2.20916747	Phytophthora ramorum	164328	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|2794919753\|ref\|XM_067895242.1\|	164328	g48238	i0	100	0.116182572614108	28	0	12	0	30	57	39	66	Phytophthora ramorum Choline transporter-like protein 1 (KRP23_9661), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora ramorum
15693069	15693069	PRJNA335774_P_NODE_28833_length_292_cov_2.000000_g28681_i0	PRJNA335774	28833	292	2	5.84	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	200	9.13e-47	NTclustered	gi\|166035483\|emb\|CU354362.1\|	100861	g28681	i0	85.714	65.9691780821918	189	27	65	0	104	292	473	285	Aphanomyces euteiches cDNA	blastn	19263	200	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
20791971	20791971	PRJNA335774_P_NODE_36097_length_262_cov_1.148148_g35945_i0	PRJNA335774	36097	262	1.148148	3.00814776	Peronospora belbahrii	622444	SAR_Eukaryotes	SAR_Eukaryotes	159	1.37e-34	NTclustered	gi\|1590853183\|gb\|MH620960.1\|	622444	g35945	i0	82.011	33.1641221374046	189	32	72	2	69	256	103	290	Peronospora belbahrii isolate HI01 beta-tubulin mRNA, complete cds	blastn	8689	159	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Peronospora	Peronospora belbahrii
20792087	20792087	PRJNA335774_P_NODE_41237_length_249_cov_0.875000_g41085_i0	PRJNA335774	41237	249	0.875	2.17875	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	167	7.709999999999999e-37	NTclustered	gi\|2795041302\|ref\|XM_067930902.1\|	4785	g41085	i0	80.455	21.4738955823293	220	41	88	2	23	241	1359	1141	Phytophthora cinnamomi CCR4-NOT transcription complex subunit 11 (IUM83_06675), partial mRNA	blastn	5347	167	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi

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