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

5 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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
1473771	1473771	PRJNA1093380_P_NODE_5922_length_286_cov_1.084507_g5816_i0	PRJNA1093380	5922	286	1.084507	3.10169002	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	213	1.15e-50	NTclustered	gi\|2795040101\|ref\|XM_067937224.1\|	4785	g5816	i0	85.366	295.524475524476	205	30	72	0	79	283	683	479	Phytophthora cinnamomi Polyubiquitin (IUM83_12589), partial mRNA	blastn	84520	213	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
4025914	4025914	PRJNA1093380_P_NODE_9704_length_264_cov_1.209424_g9598_i0	PRJNA1093380	9704	264	1.209424	3.19287936	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	148	2.9899999999999995e-31	NTclustered	gi\|166043101\|emb\|CU357747.1\|	100861	g9598	i0	84.314	3.92045454545455	153	22	58	2	16	167	742	893	Aphanomyces euteiches cDNA	blastn	1035	148	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
14227843	14227843	PRJNA1093380_P_NODE_17032_length_241_cov_0.916667_g16926_i0	PRJNA1093380	17032	241	0.916667	2.20916747	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	156	1.6100000000000002e-33	NTclustered	gi\|813142527\|ref\|XM_012343931.1\|	695850	g16926	i0	79.452	98.6721991701245	219	45	91	0	1	219	441	659	Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA	blastn	23780	156	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
14227915	14227915	PRJNA1093380_P_NODE_6832_length_280_cov_1.487923_g6726_i0	PRJNA1093380	6832	280	1.487923	4.1661844	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	230	1.1099999999999995e-55	NTclustered	gi\|813102101\|ref\|XM_012338325.1\|	695850	g6726	i0	83.27	62.4535714285714	263	30	91	10	1	256	516	261	Saprolegnia parasitica CBS 223.65 ATP synthase subunit beta partial mRNA	blastn	17487	230	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
23151461	23151461	PRJNA1093380_P_NODE_3439_length_330_cov_2.311284_g3333_i0	PRJNA1093380	3439	330	2.311284	7.6272372	Aphanomyces sinensis	1125843	SAR_Eukaryotes	SAR_Eukaryotes	283	1.01e-71	NTclustered	gi\|2813228406\|dbj\|LC754346.1\|	1125843	g3333	i0	82.335	94.0272727272727	334	51	100	7	1	330	513	184	Aphanomyces sinensis NBRC 106581 btub gene for beta-tubulin, partial cds	blastn	31029	283	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces sinensis

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