metadata: contig_metadata: 8 rows where bioproject = "PRJNA1137393", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA1137393", 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
4111889	4111889	PRJNA1137393_P_NODE_8604_length_284_cov_1.395745_g8088_i0	PRJNA1137393	8604	284	1.395745	3.9639158	Pythium insidiosum	114742	SAR_Eukaryotes	SAR_Eukaryotes	207	5.29e-49	NTclustered	gi\|2020025744\|dbj\|LC553017.1\|	114742	g8088	i0	79.93	90.2992957746479	284	55	99	2	2	284	360	642	Pythium insidiosum Pi32 mitochondrial coxI gene for cytochrome c oxidase subunit I, partial cds	blastn	25645	207	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
9212840	9212840	PRJNA1137393_P_NODE_7348_length_311_cov_3.908397_g6832_i0	PRJNA1137393	7348	311	3.908397	12.15511467	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	547	3.0399999999999987e-151	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g6832	i0	98.392	15.427652733119	311	5	100	0	1	311	1243	1553	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	4798	547	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
10488227	10488227	PRJNA1137393_P_NODE_25709_length_188_cov_1.733813_g25193_i0	PRJNA1137393	25709	188	1.733813	3.25956844	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	257	3.1800000000000004e-64	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g25193	i0	91.935	1.22340425531915	186	11	98	4	1	184	513	696	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	230	257	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
10488243	10488243	PRJNA1137393_P_NODE_30469_length_181_cov_1.075758_g29953_i0	PRJNA1137393	30469	181	1.075758	1.94712198	Hyaloperonospora parasitica	123356	SAR_Eukaryotes	SAR_Eukaryotes	137	4.13e-28	NTclustered	gi\|58042871\|gb\|AY785311.1\|	123356	g29953	i0	81.395	67.6740331491713	172	28	94	4	5	174	1333	1502	Hyaloperonospora parasitica isolate Hind4 PPAT5 (Ppat5) gene, complete cds	blastn	12249	137	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Hyaloperonospora	Hyaloperonospora parasitica
14313698	14313698	PRJNA1137393_P_NODE_5012_length_394_cov_32.014493_g4496_i0	PRJNA1137393	5012	394	32.014493	126.13710242	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	91.6	7.99e-14	NTclustered	gi\|325194684\|emb\|FR825494.1\|	890382	g4496	i0	77.439	0.916243654822335	164	30	41	7	234	394	202	43	Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331	blastn	361	91.6	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
20686113	20686113	PRJNA1137393_P_NODE_2957_length_554_cov_2.831683_g2453_i0	PRJNA1137393	2957	554	2.831683	15.68752382	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	296	2.28e-75	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g2453	i0	78.233	0.922382671480144	464	99	84	2	3	465	463	1	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	511	296	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
23236990	23236990	PRJNA1137393_P_NODE_2759_length_576_cov_3.104364_g2256_i0	PRJNA1137393	2759	576	3.104364	17.88113664	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	664	0	NTclustered	gi\|325194231\|emb\|FR825088.1\|	890382	g2256	i0	87.586	1.1875	580	63	100	9	1	576	1244	670	Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85	blastn	684	664	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
29501810	29501810	PRJNA1137393_P_NODE_39630_length_169_cov_0.866667_g39114_i0	PRJNA1137393	39630	169	0.866667	1.46466723	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	39.3	0.0482	NR	RHZ01083.1	112090	g39114	i0	61.5	0.461538461538462	26	10	46.2	0	2	79	40	65	RHZ01083.1 hypothetical protein DYB35_007189 [Aphanomyces astaci]	diamond	78	39.3	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci

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