metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_phylum = "Microsporidia"

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_family	tax_genus	tax_species
32929157	32929157	PRJEB6584h_S_NODE_6153_length_231_cov_2.836735_g6091_i0	PRJEB6584	6153	231	2.836735	6.55285785	Vavraia culicis subsp. floridensis	948595	Fungi	Fungi	72	1.52e-12	NR	XP_008073558.1	948595	g6091	i0	55	0.779220779220779	60	27	77.9	0	2	181	593	652	XP_008073558.1 uncharacterized protein VCUG_00538 [Vavraia culicis subsp. floridensis]	diamond	180	72	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Vavraia	Vavraia culicis
32929161	32929161	PRJEB6584h_S_NODE_73865_length_156_cov_1.446281_g73803_i0	PRJEB6584	73865	156	1.446281	2.25619836	Pseudoloma neurophilia	146866	Fungi	Fungi	49.7	3.94e-5	NR	KRH93450.1	146866	g73803	i0	59.5	2.46153846153846	42	16	78.8	1	9	131	109	150	KRH93450.1 RRM domain protein [Pseudoloma neurophilia]	diamond	384	49.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
32963460	32963460	PRJEB6584h_S_NODE_53354_length_163_cov_2.750000_g53292_i0	PRJEB6584	53354	163	2.75	4.4825	Trachipleistophora hominis	72359	Fungi	Fungi	59.7	1.31e-8	NR	ELQ76698.1	72359	g53292	i0	72	1.76687116564417	50	10	84.7	2	162	25	423	472	ELQ76698.1 Translation elongation factor EF-1 alpha/Tu [Trachipleistophora hominis]	diamond	288	59.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Trachipleistophora	Trachipleistophora hominis
32963465	32963465	PRJEB6584h_S_NODE_78674_length_154_cov_1.344538_g78612_i0	PRJEB6584	78674	154	1.344538	2.07058852	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	59.3	1.38e-8	NR	XP_007604187.1	993615	g78612	i0	60	0.974025974025974	50	20	97.4	0	152	3	144	193	XP_007604187.1 uncharacterized protein VICG_00736 [Vittaforma corneae ATCC 50505]	diamond	150	59.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
33048562	33048562	PRJEB6584h_S_NODE_5365_length_241_cov_1.946602_g5303_i0	PRJEB6584	5365	241	1.946602	4.69131082	Vavraia culicis subsp. floridensis	948595	Fungi	Fungi	49.7	1.27e-4	NR	XP_008073558.1	948595	g5303	i0	51.9	0.647302904564315	52	23	62.2	1	239	90	171	222	XP_008073558.1 uncharacterized protein VCUG_00538 [Vavraia culicis subsp. floridensis]	diamond	156	49.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Vavraia	Vavraia culicis
33150981	33150981	PRJEB6584h_S_NODE_49552_length_164_cov_2.170543_g49490_i0	PRJEB6584	49552	164	2.170543	3.55969052	Pseudoloma neurophilia	146866	Fungi	Fungi	89.7	4.15e-21	NR	KRH93328.1	146866	g49490	i0	66.7	1.97560975609756	54	18	98.8	0	164	3	95	148	KRH93328.1 Ubiquitin/40S ribosomal protein S27a fusion [Pseudoloma neurophilia]	diamond	324	89.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia

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