metadata: contig_metadata: 7 rows where bioproject = "PRJNA289590", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA289590", tax_clade = "Sar" 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
372835	372835	PRJNA289590_P_NODE_7601_length_344_cov_4.576271_g7377_i0	PRJNA289590	7601	344	4.576271	15.74237224	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	239	2.33e-58	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g7377	i0	79.37	98.0755813953488	349	64	99	4	1	342	415	68	Aphanomyces astaci polyubiquitin mRNA	blastn	33738	239	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
9300356	9300356	PRJNA289590_P_NODE_10928_length_278_cov_1.799127_g10704_i0	PRJNA289590	10928	278	1.799127	5.00157306	Saprolegniales	4763	SAR_Eukaryotes	SAR_Eukaryotes	145	7.42e-40	NR	OQS04692.1	74557	g10704	i0	83.5	6.49640287769784	85	14	91.7	0	22	276	1	85	OQS04692.1 aspartyl/Asparaginyl beta-hydroxylase [Thraustotheca clavata]	diamond	1806	145	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
14401407	14401407	PRJNA289590_P_NODE_17872_length_212_cov_1.595092_g17648_i0	PRJNA289590	17872	212	1.595092	3.38159504	Achlya bisexualis	4766	SAR_Eukaryotes	SAR_Eukaryotes	222	1.34e-53	NTclustered	gi\|2289\|emb\|X59936.1\|	4766	g17648	i0	88.172	81.0754716981132	186	22	88	0	27	212	1	186	A.bisexualis gene for actin	blastn	17188	222	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya bisexualis
20774238	20774238	PRJNA289590_P_NODE_4557_length_472_cov_1.855792_g4337_i0	PRJNA289590	4557	472	1.855792	8.75933824	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	243	2.54e-59	NTclustered	gi\|673019759\|ref\|XM_008865619.1\|	157072	g4337	i0	79.05	16.7902542372881	358	71	75	4	60	415	127	482	Aphanomyces invadans 40S ribosomal protein S23 mRNA	blastn	7925	243	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
29379401	29379401	PRJNA289590_P_NODE_26109_length_169_cov_0.866667_g25885_i0	PRJNA289590	26109	169	0.866667	1.46466723	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0194	NR	OQR99308.1	74557	g25885	i0	44.7	0.834319526627219	47	26	83.4	0	165	25	165	211	OQR99308.1 WD repeat protein 35 [Thraustotheca clavata]	diamond	141	42.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata
31211138	31211138	PRJNA289590_P_NODE_21875_length_189_cov_1.157143_g21651_i0	PRJNA289590	21875	189	1.157143	2.18700027	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	110	9.85e-27	NR	KAH9108398.1	100861	g21651	i0	82.5	3	63	11	100	0	189	1	410	472	KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches]	diamond	567	110	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
31274833	31274833	PRJNA289590_P_NODE_22855_length_184_cov_1.511111_g22631_i0	PRJNA289590	22855	184	1.511111	2.78044424	Thraustotheca clavata	74557	SAR_Eukaryotes	SAR_Eukaryotes	42.4	0.0228	NR	OQS01009.1	74557	g22631	i0	57.1	0.798913043478261	49	21	79.9	0	36	182	568	616	OQS01009.1 hypothetical protein THRCLA_21647, partial [Thraustotheca clavata]	diamond	147	42.4	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Thraustotheca	Thraustotheca clavata

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