metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB83101" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB83101" 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
7794071	7794071	PRJEB83101_P_NODE_35327_length_312_cov_1.966527_g35022_i0	PRJEB83101	35327	312	1.966527	6.13556424	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	166	2.81e-51	NR	KAL0582086.1	65357	g35022	i0	100	0.846153846153846	88	0	84.6	0	265	2	1	88	KAL0582086.1 hypothetical protein ABG067_008272, partial [Albugo candida]	diamond	264	166	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida
27666373	27666373	PRJEB83101_P_NODE_88604_length_235_cov_2.074074_g88299_i0	PRJEB83101	88604	235	2.074074	4.8740739	Globisporangium splendens	82926	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00377	NR	KAF1326870.1	82926	g88299	i0	41.3	1.60851063829787	63	33	75.3	1	188	12	102	164	KAF1326870.1 reverse transcriptase, partial [Globisporangium splendens]	diamond	378	45.4	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Globisporangium	Globisporangium splendens
29710778	29710778	PRJEB83101_P_NODE_73270_length_249_cov_0.886364_g72965_i0	PRJEB83101	73270	249	0.886364	2.20704636	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	73.6	5.41e-13	NR	XP_024571821.1	4781	g72965	i0	52.8	29.9397590361446	72	29	86.7	2	32	247	194	260	XP_024571821.1 -dimethylguanosine trna methyltransferase [Plasmopara halstedii]	diamond	7455	74.3	0.990578734858681	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Plasmopara	Plasmopara halstedii
32152397	32152397	PRJEB83101_P_NODE_33078_length_321_cov_1.741935_g32773_i0	PRJEB83101	33078	321	1.741935	5.59161135	Albugo candida	65357	SAR_Eukaryotes	SAR_Eukaryotes	151	1.68e-45	NR	KAL0570125.1	65357	g32773	i0	90.5	0.785046728971963	84	8	78.5	0	305	54	1	84	KAL0570125.1 hypothetical protein ABG067_009442, partial [Albugo candida]	diamond	252	151	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo candida

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