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

6 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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
27291406	27291406	PRJNA1120586_P_NODE_16883_length_317_cov_1.120968_g16692_i0	PRJNA1120586	16883	317	1.120968	3.55346856	Nosema granulosis	83296	Fungi	Fungi	81.3	2.3e-16	NR	KAF9761595.1	83296	g16692	i0	48	0.946372239747634	100	48	90.9	1	14	301	55	154	KAF9761595.1 hypothetical protein NGRA_2537 [Nosema granulosis]	diamond	300	81.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
27954534	27954534	PRJNA1120586_P_NODE_38305_length_238_cov_1.704142_g38114_i0	PRJNA1120586	38305	238	1.704142	4.05585796	Nosema granulosis	83296	Fungi	Fungi	62	2.56e-9	NR	KAF9764754.1	83296	g38114	i0	39.7	0.983193277310924	78	47	98.3	0	235	2	11	88	KAF9764754.1 Spore wall protein [Nosema granulosis]	diamond	234	62	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
30164664	30164664	PRJNA1120586_P_NODE_43952_length_232_cov_0.883436_g43761_i0	PRJNA1120586	43952	232	0.883436	2.04957152	Nosema granulosis	83296	Fungi	Fungi	120	2.5199999999999997e-30	NR	KAF9764715.1	83296	g43761	i0	77.9	0.995689655172414	77	17	99.6	0	2	232	148	224	KAF9764715.1 Inositol-1,4,5-trisphosphate 5-phosphatase 1 [Nosema granulosis]	diamond	231	120	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
32536399	32536399	PRJNA1120586_P_NODE_50679_length_227_cov_0.911392_g50488_i0	PRJNA1120586	50679	227	0.911392	2.06885984	Nosema granulosis	83296	Fungi	Fungi	81.6	4.32e-16	NR	KAF9761675.1	83296	g50488	i0	56	0.991189427312775	75	33	99.1	0	3	227	27	101	KAF9761675.1 Chitin synthase regulatory factor 3 [Nosema granulosis]	diamond	225	81.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema granulosis
32725325	32725325	PRJNA1120586_P_NODE_54280_length_216_cov_2.612245_g54089_i0	PRJNA1120586	54280	216	2.612245	5.6424492	Nosema bombycis CQ1	578461	Fungi	Fungi	58.9	2.77e-9	NR	EOB12412.1	578461	g54089	i0	54.8	1.16666666666667	84	14	83.3	2	1	180	9	92	EOB12412.1 hypothetical protein NBO_447g0004 [Nosema bombycis CQ1]	diamond	252	58.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Nosema	Nosema bombycis
32788119	32788119	PRJNA1120586_P_NODE_52880_length_226_cov_0.917197_g52689_i0	PRJNA1120586	52880	226	0.917197	2.07286522	Nosema bombycis CQ1	578461	Fungi	Fungi	153	1.03e-41	NR	EOB14883.1	578461	g52689	i0	93.3	0.995575221238938	75	5	99.6	0	1	225	9	83	EOB14883.1 Signal recognition particle SEC65 subunit, partial [Nosema bombycis CQ1]	diamond	225	153	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);;