metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1046144" 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
28172219	28172219	PRJNA1046144_P_NODE_63386_length_230_cov_0.894410_g63091_i0	PRJNA1046144	63386	230	0.89441	2.057143	Nosema bombycis CQ1	578461	Fungi	Fungi	145	2.09e-42	NR	EOB12152.1	578461	g63091	i0	100	0.991304347826087	76	0	99.1	0	2	229	93	168	EOB12152.1 Protein transport protein SFT2 [Nosema bombycis CQ1]	diamond	228	145	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
29719151	29719151	PRJNA1046144_P_NODE_57890_length_234_cov_0.872727_g57595_i0	PRJNA1046144	57890	234	0.872727	2.04218118	Nosema granulosis	83296	Fungi	Fungi	157	2.2199999999999998e-43	NR	KAF9764177.1	83296	g57595	i0	92.2	0.987179487179487	77	6	98.7	0	232	2	405	481	KAF9764177.1 Forkhead box protein J1-B [Nosema granulosis]	diamond	231	157	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
31330725	31330725	PRJNA1046144_P_NODE_60856_length_232_cov_0.883436_g60561_i0	PRJNA1046144	60856	232	0.883436	2.04957152	Nosema bombycis CQ1	578461	Fungi	Fungi	55.8	7.69e-7	NR	EOB13963.1	578461	g60561	i0	39.2	0.956896551724138	74	44	94.4	1	2	220	64	137	EOB13963.1 hypothetical protein NBO_48g0013, partial [Nosema bombycis CQ1]	diamond	222	55.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
31362601	31362601	PRJNA1046144_P_NODE_69716_length_226_cov_0.917197_g69421_i0	PRJNA1046144	69716	226	0.917197	2.07286522	Nosema bombycis CQ1	578461	Fungi	Fungi	134	1.27e-37	NR	EOB13857.1	578461	g69421	i0	94.7	0.995575221238938	75	4	99.6	0	225	1	9	83	EOB13857.1 hypothetical protein NBO_54g0003 [Nosema bombycis CQ1]	diamond	225	134	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
31552443	31552443	PRJNA1046144_P_NODE_53476_length_240_cov_1.538012_g53181_i0	PRJNA1046144	53476	240	1.538012	3.6912288	Nosema bombycis CQ1	578461	Fungi	Fungi	108	2.75e-26	NR	B3STN7.1	578461	g53181	i0	65.8	0.9875	79	27	98.8	0	238	2	10	88	B3STN7.1 RecName: Full=Spore wall protein 30; Flags: Precursor [Nosema bombycis CQ1]	diamond	237	108	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
31773531	31773531	PRJNA1046144_P_NODE_70217_length_225_cov_2.403846_g69922_i0	PRJNA1046144	70217	225	2.403846	5.4086535	Nosema pernyi	1112939	Fungi	Fungi	114	6.53e-29	NR	AIA56887.1	1112939	g69922	i0	71.6	1.97333333333333	74	21	98.7	0	224	3	99	172	AIA56887.1 spore wall protein 1 [Nosema pernyi]	diamond	444	114	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema pernyi
32753540	32753540	PRJNA1046144_P_NODE_50080_length_247_cov_2.589888_g49785_i0	PRJNA1046144	50080	247	2.589888	6.39702336	Nosema bombycis CQ1	578461	Fungi	Fungi	70.9	4.59e-12	NR	EOB15199.1	578461	g49785	i0	64.2	0.983805668016194	81	26	98.4	1	245	3	6	83	EOB15199.1 Splicing factor, arginine/serine-rich 10 [Nosema bombycis CQ1]	diamond	243	70.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis

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