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

9 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
11140542	11140542	PRJNA951810_P_NODE_19489_length_451_cov_2.177249_g19151_i0	PRJNA951810	19489	451	2.177249	9.81939299	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	276	2.38e-69	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g19151	i0	80.267	75.0066518847007	375	66	82	4	11	378	68	441	Aphanomyces astaci polyubiquitin mRNA	blastn	33828	276	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
13690475	13690475	PRJNA951810_P_NODE_191611_length_212_cov_6.712230_g191266_i0	PRJNA951810	191611	212	6.71223	14.2299276	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.11e-4	NTclustered	gi\|2795027206\|ref\|XM_067926235.1\|	4785	g191266	i0	94.737	0.452830188679245	38	2	18	0	134	171	272	235	Phytophthora cinnamomi putative NADPH-cytochrome P450 reductase (IUM83_02325), partial mRNA	blastn	96	60.2	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
13690618	13690618	PRJNA951810_P_NODE_21671_length_430_cov_8.294118_g21333_i0	PRJNA951810	21671	430	8.294118	35.6647074	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	111	6.75e-20	NTclustered	gi\|813110382\|ref\|XM_012339482.1\|	695850	g21333	i0	86.538	22.1395348837209	104	10	24	4	329	430	313	414	Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA	blastn	9520	111	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
16238923	16238923	PRJNA951810_P_NODE_147493_length_260_cov_2.315508_g147148_i0	PRJNA951810	147493	260	2.315508	6.0203208	Phytophthora citrophthora	4793	SAR_Eukaryotes	SAR_Eukaryotes	134	8.23e-27	NTclustered	gi\|2314988661\|ref\|NC_067066.1\|	4793	g147148	i0	80.571	63.7461538461538	175	32	67	2	1	174	12851	13024	Phytophthora citrophthora voucher CBS950_87 mitochondrion, complete genome	blastn	16574	134	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora citrophthora
17514812	17514812	PRJNA951810_P_NODE_183774_length_227_cov_6.779221_g183429_i0	PRJNA951810	183774	227	6.779221	15.38883167	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	187	5.3099999999999984e-43	NTclustered	gi\|813149488\|ref\|XM_012345001.1\|	695850	g183429	i0	84.656	15.5330396475771	189	27	83	2	40	227	419	232	Saprolegnia parasitica CBS 223.65 60S ribosomal protein L11 mRNA	blastn	3526	187	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
17516019	17516019	PRJNA951810_P_NODE_71834_length_300_cov_7.211454_g71490_i0	PRJNA951810	71834	300	7.211454	21.634362	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	87.9	7.65e-13	NTclustered	gi\|2795059860\|ref\|XM_067943008.1\|	4785	g71490	i0	93.22	0.496666666666667	59	4	20	0	100	158	642	584	Phytophthora cinnamomi 40S ribosomal protein S3a (IUM83_18029), partial mRNA	blastn	149	87.9	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
17840616	17840616	PRJNA951810_P_NODE_142494_length_264_cov_1.324607_g142149_i0	PRJNA951810	142494	264	1.324607	3.49696248	Phytophthora	4783	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|2795036352\|ref\|XM_067936476.1\|	4785	g142149	i0	100	1.09848484848485	29	0	11	0	236	264	141	113	Phytophthora cinnamomi ubiquitin-40s ribosomal protein s27a (IUM83_11888), partial mRNA	blastn	290	54.7	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
20390039	20390039	PRJNA951810_P_NODE_32196_length_352_cov_1.974910_g31854_i0	PRJNA951810	32196	352	1.97491	6.9516832	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	220	8.62e-53	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g31854	i0	79.43	22.0113636363636	316	61	89	4	3	316	169	482	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	7748	222	0.990990990990991	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
22613228	22613228	PRJNA951810_P_NODE_151938_length_256_cov_5.251366_g151593_i0	PRJNA951810	151938	256	5.251366	13.44349696	Globisporangium cystogenes	295491	SAR_Eukaryotes	SAR_Eukaryotes	189	1.6999999999999996e-43	NTclustered	gi\|442591591\|gb\|JX115074.1\|	295491	g151593	i0	82.791	1.84765625	215	33	83	4	38	250	828	616	Globisporangium cystogenes voucher CBS:675.85 PF16 gene, partial cds	blastn	473	189	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium cystogenes

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