metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA591000" 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
8791428	8791428	PRJNA591000_P_NODE_2887_length_807_cov_6.673522_g2192_i0	PRJNA591000	2887	807	6.673522	53.85532254	Zoopagomycota	1913638	Fungi	Fungi	219	1.05e-62	NR	KAJ1962317.1	4866	g2192	i0	79.3	13.4237918215613	135	28	50.2	0	140	544	368	502	KAJ1962317.1 hypothetical protein GGI12_002719, partial [Dipsacomyces acuminosporus]	diamond	10833	221	0.990950226244344	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Dipsacomyces	Dipsacomyces acuminosporus
26903469	26903469	PRJNA591000_P_NODE_13941_length_395_cov_1.912568_g12346_i0	PRJNA591000	13941	395	1.912568	7.5546436	Hymenoptera	7399	Arthropoda	Arthropoda	50.1	3.56e-4	NR	CAG5103531.1	51543	g12346	i0	100	3.84303797468354	22	0	16.7	0	68	3	155	176	CAG5103531.1 Similar to Tpi: Triosephosphate isomerase (Culex tarsalis) [Cotesia congregata]	diamond	1518	50.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Cotesia	Cotesia congregata
28090317	28090317	PRJNA591000_P_NODE_8965_length_465_cov_4.112385_g7424_i0	PRJNA591000	8965	465	4.112385	19.12259025	Amoeboaphelidium protococcarum	1243177	Root_unresolved	Root_unresolved	129	1.17e-32	NR	KAI3639629.1	1243177	g7424	i0	60.7	0.690322580645161	107	42	69	0	79	399	289	395	KAI3639629.1 hypothetical protein MIR68_002323 [Amoeboaphelidium protococcarum]	diamond	321	129	1	Eukaryota	Opisthokonta			Aphelidea			Amoeboaphelidium	Amoeboaphelidium protococcarum
28847988	28847988	PRJNA591000_P_NODE_5688_length_608_cov_3.174439_g4479_i0	PRJNA591000	5688	608	3.174439	19.30058912	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	138	7.3699999999999995e-34	NR	CAF0863024.1	104777	g4479	i0	58.8	0.730263157894737	148	53	71.5	4	487	53	421	563	CAF0863024.1 unnamed protein product [Brachionus calyciflorus]	diamond	444	138	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
28847989	28847989	PRJNA591000_P_NODE_6888_length_535_cov_2.345850_g5489_i0	PRJNA591000	6888	535	2.34585	12.5502975	Knufia fluminis	191047	Fungi	Fungi	66.6	3.65e-9	NR	KAK5952017.1	191047	g5489	i0	31.9	0.807476635514019	144	85	80.7	1	61	492	304	434	KAK5952017.1 hypothetical protein OHC33_006903 [Knufia fluminis]	diamond	432	66.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia fluminis
30219499	30219499	PRJNA591000_P_NODE_3212_length_780_cov_1.628495_g2470_i0	PRJNA591000	3212	780	1.628495	12.702261	Chytridiomycota	4761	Root_unresolved	Root_unresolved	66.6	1.9e-8	NR	KAI3662610.1	1498855	g2470	i0	56.3	1.58846153846154	64	10	17.7	1	776	639	34	97	KAI3662610.1 hypothetical protein MP638_000720 [Amoeboaphelidium occidentale]	diamond	1239	66.6	1	Eukaryota	Opisthokonta			Aphelidea			Amoeboaphelidium	Amoeboaphelidium occidentale
31388896	31388896	PRJNA591000_P_NODE_10256_length_441_cov_1.300971_g8689_i0	PRJNA591000	10256	441	1.300971	5.73728211	Trichomeriaceae	1233474	Fungi	Fungi	61.2	1.11e-7	NR	XP_064728618.1	1635080	g8689	i0	86.2	0.591836734693878	29	4	19.7	0	88	2	813	841	XP_064728618.1 uncharacterized protein PMZ80_006944 [Knufia obscura]	diamond	261	61.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
31515540	31515540	PRJNA591000_P_NODE_956_length_1151_cov_6.631907_g660_i0	PRJNA591000	956	1151	6.631907	76.33324957	Metazoa	33208	Porifera	other_Eukaryota	57	1.06e-4	NR	XP_062520328.1	121492	g660	i0	51.8	1.07645525629887	56	23	14.1	2	274	435	79	132	XP_062520328.1 WD repeat-containing protein 48-like [Corticium candelabrum]	diamond	1239	57	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32197811	32197811	PRJNA591000_P_NODE_2778_length_816_cov_3.570521_g2097_i0	PRJNA591000	2778	816	3.570521	29.13545136	Egretta garzetta	188379	Chordata	Chordata	52.8	9.87e-4	NR	XP_009643978.1	188379	g2097	i0	62.5	0.117647058823529	32	12	11.8	0	331	426	542	573	XP_009643978.1 integrin beta-2 [Egretta garzetta]	diamond	96	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Pelecaniformes	Ardeidae	Egretta	Egretta garzetta
32514472	32514472	PRJNA591000_P_NODE_8299_length_482_cov_10.165563_g6783_i0	PRJNA591000	8299	482	10.165563	48.99801366	Adineta steineri	433720	Rotifera	other_Eukaryota	64.3	1.26e-8	NR	CAF1511323.1	433720	g6783	i0	64.7	0.317427385892116	51	17	31.7	1	324	476	138	187	CAF1511323.1 unnamed protein product [Adineta steineri]	diamond	153	64.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
32703249	32703249	PRJNA591000_P_NODE_6340_length_566_cov_1.491620_g5016_i0	PRJNA591000	6340	566	1.49162	8.4425692	Funneliformis geosporum	1117311	Fungi	Fungi	48.9	0.00319	NR	CAI2180134.1	1117311	g5016	i0	76	0.132508833922261	25	6	13.3	0	40	114	97	121	CAI2180134.1 14391_t:CDS:2 [Funneliformis geosporum]	diamond	75	48.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis geosporum

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