metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_phylum = "Ascomycota"

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
6743487	6743487	PRJNA188516_P_NODE_4206_length_169_cov_0.866667_g4156_i0	PRJNA188516	4206	169	0.866667	1.46466723	Fungi	4751	Fungi	Fungi	90.9	1.45e-19	NR	KTA95682.1	5478	g4156	i0	87.3	37.1005917159763	55	6	97.6	1	3	167	814	867	KTA95682.1 40S ribosomal protein S28 [Nakaseomyces glabratus]	diamond	6270	91.3	0.995618838992333	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Nakaseomyces	Nakaseomyces glabratus
26694019	26694019	PRJNA188516_P_NODE_3681_length_176_cov_1.314961_g3631_i0	PRJNA188516	3681	176	1.314961	2.31433136	Schizosaccharomyces cryophilus OY26	653667	Fungi	Fungi	66.2	7.69e-11	NR	XP_013025758.1	653667	g3631	i0	51.7	6.51136363636364	58	27	98.9	1	175	2	190	246	XP_013025758.1 chaperonin-containing T-complex theta subunit Cct8 [Schizosaccharomyces cryophilus OY26]	diamond	1146	66.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces cryophilus
26725345	26725345	PRJNA188516_P_NODE_6121_length_162_cov_0.920354_g6071_i0	PRJNA188516	6121	162	0.920354	1.49097348	Schizothecium vesticola	314040	Fungi	Fungi	41.2	0.0456	NR	KAK0750855.1	314040	g6071	i0	50	0.62962962962963	34	17	63	0	13	114	662	695	KAK0750855.1 hypothetical protein B0T18DRAFT_478029 [Schizothecium vesticola]	diamond	102	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Schizotheciaceae	Schizothecium	Schizothecium vesticola
28621531	28621531	PRJNA188516_P_NODE_4167_length_169_cov_0.866667_g4117_i0	PRJNA188516	4167	169	0.866667	1.46466723	Kuraishia capsulata CBS 1993	1382522	Fungi	Fungi	48.1	2.19e-5	NR	XP_022456377.1	1382522	g4117	i0	61.8	3.44378698224852	34	13	60.4	0	168	67	51	84	XP_022456377.1 uncharacterized protein KUCA_T00000321001 [Kuraishia capsulata CBS 1993]	diamond	582	48.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Kuraishia	Kuraishia capsulata
28860097	28860097	PRJNA188516_P_NODE_4188_length_169_cov_0.866667_g4138_i0	PRJNA188516	4188	169	0.866667	1.46466723	Aspergillus	5052	Fungi	Fungi	71.2	1.22e-12	NR	PLN84339.1	482145	g4138	i0	79.2	3.79881656804734	53	11	94.1	0	10	168	392	444	PLN84339.1 hypothetical protein BDW42DRAFT_45327 [Aspergillus taichungensis]	diamond	642	71.6	0.994413407821229	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus taichungensis
29302266	29302266	PRJNA188516_P_NODE_2469_length_218_cov_1.680473_g2419_i0	PRJNA188516	2469	218	1.680473	3.66343114	root	1	Root_unresolved	Root_unresolved	110	8.45e-29	NR	NP_593900.1	4896	g2419	i0	73.6	29.6834862385321	72	19	99.1	0	216	1	55	126	NP_593900.1 40S ribosomal protein uS15 [Schizosaccharomyces pombe]	diamond	6471	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces pombe
29631482	29631482	PRJNA188516_P_NODE_4730_length_167_cov_0.881356_g4680_i0	PRJNA188516	4730	167	0.881356	1.47186452	Schizothecium vesticola	314040	Fungi	Fungi	73.9	1.31e-13	NR	KAK0750351.1	314040	g4680	i0	69.1	1.97604790419162	55	14	98.8	2	167	3	386	437	KAK0750351.1 FAD binding domain-containing protein [Schizothecium vesticola]	diamond	330	73.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Schizotheciaceae	Schizothecium	Schizothecium vesticola
31640281	31640281	PRJNA188516_P_NODE_5396_length_164_cov_0.904348_g5346_i0	PRJNA188516	5396	164	0.904348	1.48313072	Eukaryota	2759	Fungi	Fungi	49.7	3.38e-5	NR	KAI5289193.1	51565	g5346	i0	54.7	4.77439024390244	53	24	97	0	162	4	159	211	KAI5289193.1 40S ribosomal protein S6 [Ascosphaera acerosa]	diamond	783	50.1	0.992015968063872	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales	Ascosphaeraceae	Ascosphaera	Ascosphaera acerosa
31653989	31653989	PRJNA188516_P_NODE_5077_length_165_cov_1.344828_g5027_i0	PRJNA188516	5077	165	1.344828	2.2189662	Kockiozyma suomiensis	1337062	Fungi	Fungi	82	8.51e-17	NR	XP_066768201.1	1337062	g5027	i0	63	2.96363636363636	54	20	98.2	0	163	2	246	299	XP_066768201.1 uncharacterized protein V2V93DRAFT_332144 [Kockiozyma suomiensis]	diamond	489	82	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Kockiozyma	Kockiozyma suomiensis
32603176	32603176	PRJNA188516_P_NODE_3760_length_174_cov_1.584000_g3710_i0	PRJNA188516	3760	174	1.584	2.75616	Teratosphaeria nubilosa	161662	Fungi	Fungi	56.2	4.33e-8	NR	KAF2765129.1	161662	g3710	i0	49.1	0.982758620689655	57	29	98.3	0	171	1	8	64	KAF2765129.1 hypothetical protein EJ03DRAFT_339308 [Teratosphaeria nubilosa]	diamond	171	56.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Teratosphaeria	Teratosphaeria nubilosa

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