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

5 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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
278503	278503	PRJNA1123309_P_NODE_47581_length_253_cov_0.866667_g47201_i0	PRJNA1123309	47581	253	0.866667	2.19266751	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	78.7	3.79e-10	NTclustered	gi\|673049422\|ref\|XM_008880450.1\|	157072	g47201	i0	95.833	2.32411067193676	48	2	19	0	27	74	3218	3171	Aphanomyces invadans hypothetical protein, variant 2 mRNA	blastn	588	78.7	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
6656442	6656442	PRJNA1123309_P_NODE_63026_length_244_cov_0.912281_g62646_i0	PRJNA1123309	63026	244	0.912281	2.22596564	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	65.8	2.83e-6	NTclustered	gi\|698810207\|ref\|XM_009839831.1\|	112090	g62646	i0	93.182	0.180327868852459	44	3	18	0	16	59	1642	1685	Aphanomyces astaci hypothetical protein mRNA	blastn	44	65.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
13032336	13032336	PRJNA1123309_P_NODE_9211_length_495_cov_39.061611_g8837_i0	PRJNA1123309	9211	495	39.061611	193.35497445	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	281	5.66e-71	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g8837	i0	80.533	68.3393939393939	375	65	74	4	80	447	441	68	Aphanomyces astaci polyubiquitin mRNA	blastn	33828	281	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
16855347	16855347	PRJNA1123309_P_NODE_19334_length_358_cov_4.831579_g18955_i0	PRJNA1123309	19334	358	4.831579	17.29705282	Saprolegnia parasitica	101203	SAR_Eukaryotes	SAR_Eukaryotes	211	5.29e-50	NTclustered	gi\|813133999\|ref\|XM_012342618.1\|	695850	g18955	i0	82.573	7.03351955307263	241	40	67	2	117	356	324	85	Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA	blastn	2518	211	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia parasitica
18880667	18880667	PRJNA1123309_P_NODE_6395_length_584_cov_6.921722_g6037_i0	PRJNA1123309	6395	584	6.921722	40.42285648	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	488	3.7099999999999986e-133	NTclustered	gi\|9858457\|gb\|AF085344.1\|AF085344	82926	g6037	i0	86.057	76.0753424657534	459	59	78	4	79	535	28	483	Pythium splendens calmodulin mRNA, complete cds	blastn	44428	492	0.991869918699187	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens

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