metadata: contig_metadata: 6 rows where bioproject = "PRJNA404067", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA404067", 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
1689592	1689592	PRJNA404067_P_NODE_35402_length_204_cov_1.083916_g35015_i0	PRJNA404067	35402	204	1.083916	2.21118864	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	130	7.99e-26	NTclustered	gi\|325195237\|emb\|FR826032.1\|	890382	g35015	i0	86.777	49.9950980392157	121	11	58	3	5	122	1	119	Albugo laibachii Nc14, genomic contig CONTIG_3119_NC14_v4_456_35141	blastn	10199	130	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
5518685	5518685	PRJNA404067_P_NODE_9065_length_372_cov_6.858521_g8681_i0	PRJNA404067	9065	372	6.858521	25.51369812	Aphanomyces invadans	157072	SAR_Eukaryotes	SAR_Eukaryotes	93.5	2.08e-14	NTclustered	gi\|673039884\|ref\|XM_008875681.1\|	157072	g8681	i0	86.905	0.443548387096774	84	9	22	2	121	203	377	459	Aphanomyces invadans 60S ribosomal protein mRNA	blastn	165	93.5	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
15717121	15717121	PRJNA404067_P_NODE_15613_length_262_cov_30.850746_g15226_i0	PRJNA404067	15613	262	30.850746	80.82895452	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	202	2.24e-47	NTclustered	gi\|675205768\|ref\|XM_008913521.1\|	761204	g15226	i0	83.645	1.63358778625954	214	35	82	0	49	262	1649	1436	Phytophthora parasitica INRA-310 hypothetical protein, variant mRNA	blastn	428	202	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
26758808	26758808	PRJNA404067_P_NODE_43641_length_176_cov_3.295359_g43254_i0	PRJNA404067	43641	176	3.295359	5.79983184	Plasmopara halstedii	4781	SAR_Eukaryotes	SAR_Eukaryotes	110	1.51e-26	NR	XP_024573346.1	4781	g43254	i0	91.2	4.85795454545455	57	5	97.2	0	173	3	352	408	XP_024573346.1 nadhubiquinone oxidoreductase [Plasmopara halstedii]	diamond	855	110	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
27154945	27154945	PRJNA404067_P_NODE_31082_length_209_cov_1.391892_g30695_i0	PRJNA404067	31082	209	1.391892	2.90905428	Peronosporomycetes	3418804	SAR_Eukaryotes	SAR_Eukaryotes	79	4.2e-15	NR	KAF1334479.1	82926	g30695	i0	89.7	23.511961722488	39	4	56	0	2	118	740	778	KAF1334479.1 Pol protein, partial [Globisporangium splendens]	diamond	4914	79.3	0.996216897856242	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
31672330	31672330	PRJNA404067_P_NODE_20217_length_236_cov_1.611429_g19830_i0	PRJNA404067	20217	236	1.611429	3.80297244	Aphanomyces	100860	SAR_Eukaryotes	SAR_Eukaryotes	112	5.95e-30	NR	KAF0738771.1	100861	g19830	i0	71.2	10.2076271186441	73	21	92.8	0	10	228	36	108	KAF0738771.1 hypothetical protein Ae201684_005384 [Aphanomyces euteiches]	diamond	2409	112	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches

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