metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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
168854	168854	PRJNA1035005_P_NODE_4501_length_503_cov_1.444186_g4102_i0	PRJNA1035005	4501	503	1.444186	7.26425558	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	416	1.51e-111	NTclustered	gi\|166044823\|emb\|CU351082.1\|	100861	g4102	i0	82.737	58.8667992047714	475	74	94	7	13	483	84	554	Aphanomyces euteiches cDNA	blastn	29610	416	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
1007774	1007774	PRJNA1035005_P_NODE_2241_length_780_cov_2.274399_g1869_i0	PRJNA1035005	2241	780	2.274399	17.7403122	Oomycota	4762	SAR_Eukaryotes	SAR_Eukaryotes	422	5.18e-113	NTclustered	gi\|166303\|gb\|J05116.1\|ACKCAL	4767	g1869	i0	83.937	54.6102564102564	442	69	57	2	248	688	946	506	A.klebsiana calmodulin gene, complete cds	blastn	42596	425	0.992941176470588	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya klebsiana
1443382	1443382	PRJNA1035005_P_NODE_15282_length_321_cov_4.217742_g14876_i0	PRJNA1035005	15282	321	4.217742	13.53895182	Achlya bisexualis	4766	SAR_Eukaryotes	SAR_Eukaryotes	272	2.12e-68	NTclustered	gi\|2289\|emb\|X59936.1\|	4766	g14876	i0	87.342	71.6386292834891	237	30	74	0	1	237	237	1	A.bisexualis gene for actin	blastn	22996	272	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya bisexualis
1443677	1443677	PRJNA1035005_P_NODE_56082_length_252_cov_1.307263_g55676_i0	PRJNA1035005	56082	252	1.307263	3.29430276	Saprolegnia diclina	112098	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|669141085\|ref\|XM_008607883.1\|	1156394	g55676	i0	100	0.111111111111111	28	0	11	0	114	141	355	382	Saprolegnia diclina VS20 hypothetical protein mRNA	blastn	28	52.8	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Saprolegniaceae	Saprolegnia	Saprolegnia diclina
7821828	7821828	PRJNA1035005_P_NODE_90607_length_199_cov_4.190476_g90200_i0	PRJNA1035005	90607	199	4.190476	8.33904724	Pseudoperonospora cubensis	143453	SAR_Eukaryotes	SAR_Eukaryotes	115	2.17e-21	NTclustered	gi\|565813531\|gb\|KF679519.1\|	143453	g90200	i0	93.506	0.708542713567839	77	5	39	0	1	77	1085	1161	Pseudoperonospora cubensis cytochrome b (cytb) gene, complete cds; mitochondrial	blastn	141	115	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Pseudoperonospora	Pseudoperonospora cubensis
12486735	12486735	PRJNA1035005_P_NODE_49230_length_258_cov_1.394595_g48824_i0	PRJNA1035005	49230	258	1.394595	3.5980551	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	152	2.2499999999999995e-32	NTclustered	gi\|673014099\|ref\|XM_008862789.1\|	157072	g48824	i0	84.868	21.6317829457364	152	21	59	2	29	179	94	244	Aphanomyces invadans hypothetical protein mRNA	blastn	5581	152	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces invadans
22684560	22684560	PRJNA1035005_P_NODE_1178_length_1224_cov_2.408341_g913_i0	PRJNA1035005	1178	1224	2.408341	29.47809384	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	811	0	NTclustered	gi\|325053422\|dbj\|AB512821.1\|	241406	g913	i0	83	71.7745098039216	900	150	73	3	316	1213	1247	349	Pythium attrantheridium gene for beta-tubulin, partial cds, strain: DAOM 230385	blastn	87852	815	0.995092024539877	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium attrantheridium

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