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

5 rows where analysis = "blastn", bioproject = "PRJNA473641" 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
5548696	5548696	PRJNA473641_P_NODE_2225_length_564_cov_1.602851_g2143_i0	PRJNA473641	2225	564	1.602851	9.04007964	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	427	7.91e-115	NTclustered	gi\|166043465\|emb\|CU359703.1\|	100861	g2143	i0	83.058	69.7978723404255	484	68	85	12	44	520	529	53	Aphanomyces euteiches cDNA	blastn	39366	427	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
6822885	6822885	PRJNA473641_P_NODE_6026_length_378_cov_1.570492_g5943_i0	PRJNA473641	6026	378	1.570492	5.93645976	Aphanomyces euteiches	100861	SAR_Eukaryotes	SAR_Eukaryotes	154	9.6e-33	NTclustered	gi\|166036439\|emb\|CU349481.1\|	100861	g5943	i0	80.905	6.48412698412698	199	34	52	2	3	199	558	754	Aphanomyces euteiches cDNA	blastn	2451	154	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces euteiches
9372620	9372620	PRJNA473641_P_NODE_14368_length_273_cov_1.570000_g14285_i0	PRJNA473641	14368	273	1.57	4.2861	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	243	1.39e-59	NTclustered	gi\|698785784\|ref\|XM_009827634.1\|	112090	g14285	i0	86.425	95.1648351648352	221	30	81	0	26	246	163	383	Aphanomyces astaci histone H3 partial mRNA	blastn	25980	243	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
11298704	11298704	PRJNA473641_P_NODE_3669_length_459_cov_5.196891_g3586_i0	PRJNA473641	3669	459	5.196891	23.85372969	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	235	4.12e-57	NTclustered	gi\|698807229\|ref\|XM_009838342.1\|	112090	g3586	i0	84.979	68.3050108932462	233	34	51	1	226	457	299	67	Aphanomyces astaci polyubiquitin mRNA	blastn	31352	235	1	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Verrucalvaceae	Aphanomyces	Aphanomyces astaci
18296464	18296464	PRJNA473641_P_NODE_14175_length_275_cov_1.500000_g14092_i0	PRJNA473641	14175	275	1.5	4.125	Aphanomyces astaci	112090	SAR_Eukaryotes	SAR_Eukaryotes	158	5.21e-34	NTclustered	gi\|698810055\|ref\|XM_009839755.1\|	112090	g14092	i0	77.407	1.82909090909091	270	58	98	3	1	269	1106	839	Aphanomyces astaci transitional endoplasmic reticulum ATPase mRNA	blastn	503	158	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);;