metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA681861" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA681861" and tax_clade = "Opisthokonta"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18509645	18509645	PRJNA681861_P_NODE_31535_length_208_cov_1.435754_g29435_i0	PRJNA681861	31535	208	1.435754	2.98636832	Phaffia rhodozyma	264483	Fungi	Fungi	94.4	1.46e-22	NR	CDZ98602.1	264483	g29435	i0	53.7	1.37019230769231	95	17	98.1	1	205	2	43	137	CDZ98602.1 40s ribosomal protein s26 [Phaffia rhodozyma]	diamond	285	94.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
27176656	27176656	PRJNA681861_P_NODE_27422_length_235_cov_2.291262_g25322_i0	PRJNA681861	27422	235	2.291262	5.3844657	Phaffia rhodozyma	264483	Fungi	Fungi	96.3	3.01e-22	NR	CDZ96152.1	264483	g25322	i0	54.3	1.2	94	25	97	1	229	2	33	126	CDZ96152.1 cytochrome c oxidase subunit 2 [Phaffia rhodozyma]	diamond	282	96.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
30935213	30935213	PRJNA681861_P_NODE_41674_length_179_cov_2.673333_g39574_i0	PRJNA681861	41674	179	2.673333	4.78526607	Phaffia rhodozyma	264483	Fungi	Fungi	48.5	1.43e-4	NR	AIP93875.1	264483	g39574	i0	79.3	0.972067039106145	29	6	48.6	0	89	175	53	81	AIP93875.1 cytochrome c oxidase subunit 1 [Phaffia rhodozyma]	diamond	174	48.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
31262827	31262827	PRJNA681861_P_NODE_42855_length_173_cov_15.562500_g40755_i0	PRJNA681861	42855	173	15.5625	26.923125	Serinales	2916678	Fungi	Fungi	45.4	0.00165	NR	QWU89873.1	45357	g40755	i0	62	7.10982658959538	50	17	83.2	1	13	156	195	244	QWU89873.1 hypothetical protein CA3LBN_004221 [Candidozyma haemuli]	diamond	1230	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Candidozyma	Candidozyma haemuli
31357831	31357831	PRJNA681861_P_NODE_22376_length_285_cov_3.785156_g20276_i0	PRJNA681861	22376	285	3.785156	10.7876946	Ascomycota	4890	Fungi	Fungi	48.1	1.19e-4	NR	XP_022675093.1	1003335	g20276	i0	95.7	0.494736842105263	23	1	24.2	0	69	1	19	41	XP_022675093.1 uncharacterized protein KLMA_20782 [Kluyveromyces marxianus DMKU3-1042]	diamond	141	48.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Kluyveromyces	Kluyveromyces marxianus

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