metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA893346" 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
3795135	3795135	PRJNA893346_P_NODE_17943_length_365_cov_1.729452_g17454_i0	PRJNA893346	17943	365	1.729452	6.3124998	Saprolegnia	4769	SAR_Eukaryotes	SAR_Eukaryotes	267	1.14e-66	NTclustered	gi\|813139567\|ref\|XM_012343453.1\|	695850	g17454	i0	80.165	96.1013698630137	363	66	99	6	4	363	1594	1235	Saprolegnia parasitica CBS 223.65 hsp70-like protein mRNA	blastn	35077	267	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
7246467	7246467	PRJNA893346_P_NODE_32806_length_253_cov_2.844444_g32316_i0	PRJNA893346	32806	253	2.844444	7.19644332	Achlya bisexualis	4766	SAR_Eukaryotes	SAR_Eukaryotes	246	9.81e-61	NTclustered	gi\|2289\|emb\|X59936.1\|	4766	g32316	i0	85.185	87.5375494071146	243	33	95	3	1	240	243	1	A.bisexualis gene for actin	blastn	22147	246	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya bisexualis
9796527	9796527	PRJNA893346_P_NODE_8288_length_552_cov_1.411273_g7807_i0	PRJNA893346	8288	552	1.411273	7.79022696	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	348	6.19e-91	NTclustered	gi\|2795023784\|ref\|XM_067929914.1\|	4785	g7807	i0	79.331	78.286231884058	508	95	91	9	45	547	1538	1036	Phytophthora cinnamomi hsp70-like protein (IUM83_05758), partial mRNA	blastn	43214	348	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
11071460	11071460	PRJNA893346_P_NODE_15589_length_394_cov_0.716511_g15101_i0	PRJNA893346	15589	394	0.716511	2.82305334	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	267	1.2399999999999998e-66	NTclustered	gi\|813138586\|ref\|XM_012343406.1\|	695850	g15101	i0	80.58	36.2918781725888	345	67	88	0	30	374	575	231	Saprolegnia parasitica CBS 223.65 tubulin alpha chain mRNA	blastn	14299	267	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
13997173	13997173	PRJNA893346_P_NODE_38731_length_243_cov_0.858824_g38241_i0	PRJNA893346	38731	243	0.858824	2.08694232	Albugo	65356	SAR_Eukaryotes	SAR_Eukaryotes	174	4.48e-39	NTclustered	gi\|325181694\|emb\|FR824064.1\|	890382	g38241	i0	82.266	25.7530864197531	203	34	83	2	1	202	12505	12706	Albugo laibachii Nc14, genomic contig CONTIG_19_NC14_v4_197315_238	blastn	6258	174	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
19994484	19994484	PRJNA893346_P_NODE_13576_length_424_cov_1.068376_g13090_i0	PRJNA893346	13576	424	1.068376	4.52991424	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	283	1.33e-71	NTclustered	gi\|166043006\|emb\|CU355697.1\|	100861	g13090	i0	82.335	55.811320754717	334	51	78	6	2	331	364	693	Aphanomyces euteiches cDNA	blastn	23664	283	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
21269781	21269781	PRJNA893346_P_NODE_15157_length_399_cov_3.984663_g14669_i0	PRJNA893346	15157	399	3.984663	15.89880537	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	303	9.56e-78	NTclustered	gi\|673041888\|ref\|XM_008876683.1\|	157072	g14669	i0	80.556	97.5714285714286	396	75	99	2	2	396	329	723	Aphanomyces invadans elongation factor 1-alpha mRNA	blastn	38931	303	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
24194756	24194756	PRJNA893346_P_NODE_15639_length_393_cov_0.962500_g15151_i0	PRJNA893346	15639	393	0.9625	3.782625	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	379	1.52e-100	NTclustered	gi\|2795048880\|ref\|XM_067943659.1\|	4785	g15151	i0	84.675	66.6488549618321	385	53	97	6	1	382	402	21	Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA	blastn	26193	379	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);;