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

10 rows where analysis = "diamond", bioproject = "PRJNA724039" 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
26894238	26894238	PRJNA724039_S_NODE_10461_length_200_cov_3.153374_g10254_i0	PRJNA724039	10461	200	3.153374	6.306748	Metschnikowia bicuspidata var. bicuspidata NRRL YB-4993	869754	Fungi	Fungi	42.7	0.00198	NR	XP_018709241.1	869754	g10254	i0	73.3	0.45	30	8	45	0	2	91	1	30	XP_018709241.1 hypothetical protein METBIDRAFT_17449, partial [Metschnikowia bicuspidata var. bicuspidata NRRL YB-4993]	diamond	90	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia bicuspidata
26999119	26999119	PRJNA724039_S_NODE_18102_length_150_cov_1.787611_g17895_i0	PRJNA724039	18102	150	1.787611	2.6814165	Ascomycota	4890	Fungi	Fungi	55.5	2.31e-7	NR	KAI9666927.1	91480	g17895	i0	66	1.96	50	15	96	1	149	6	159	208	KAI9666927.1 MAG: 40S ribosomal protein S6 [Alyxoria varia]	diamond	294	55.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Arthoniomycetes	Arthoniales	Lecanographaceae	Alyxoria	Alyxoria varia
27820846	27820846	PRJNA724039_S_NODE_16924_length_155_cov_1.720339_g16717_i0	PRJNA724039	16924	155	1.720339	2.66652545	Ascomycota	4890	Fungi	Fungi	55.1	4.96e-7	NR	CZR50630.1	576137	g16717	i0	51	14.8064516129032	51	25	98.7	0	154	2	817	867	CZR50630.1 related to VPS33-vacuolar sorting protein [Phialocephala subalpina]	diamond	2295	55.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Mollisiaceae	Phialocephala	Phialocephala subalpina
28230907	28230907	PRJNA724039_S_NODE_13026_length_177_cov_3.285714_g12819_i0	PRJNA724039	13026	177	3.285714	5.81571378	Fungi	4751	Fungi	Fungi	62	4.8e-10	NR	GMG40445.1	43982	g12819	i0	53.8	2.8135593220339	52	24	88.1	0	173	18	85	136	GMG40445.1 unnamed protein product [Ambrosiozyma monospora]	diamond	498	62.4	0.993589743589744	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ambrosiozyma	Ambrosiozyma monospora
28283726	28283726	PRJNA724039_S_NODE_16406_length_157_cov_2.416667_g16199_i0	PRJNA724039	16406	157	2.416667	3.79416719	Ascobolus immersus RN42	1160509	Fungi	Fungi	72.8	3.57e-14	NR	RPA76833.1	1160509	g16199	i0	67.3	0.993630573248408	52	17	99.4	0	157	2	28	79	RPA76833.1 60S ribosomal protein L17 [Ascobolus immersus RN42]	diamond	156	72.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Ascobolaceae	Ascobolus	Ascobolus immersus
28757490	28757490	PRJNA724039_S_NODE_14487_length_167_cov_10.407692_g14280_i0	PRJNA724039	14487	167	10.407692	17.38084564	Hyaloscypha bicolor E	1095630	Fungi	Fungi	39.3	0.0312	NR	PMD52568.1	1095630	g14280	i0	62.1	0.520958083832335	29	11	52.1	0	160	74	10	38	PMD52568.1 hypothetical protein K444DRAFT_543211 [Hyaloscypha bicolor E]	diamond	87	39.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Hyaloscyphaceae	Hyaloscypha	Hyaloscypha bicolor
28883802	28883802	PRJNA724039_S_NODE_7928_length_236_cov_1.577889_g7721_i0	PRJNA724039	7928	236	1.577889	3.72381804	Lipomyces kononenkoae	34357	Fungi	Fungi	48.1	4.1e-4	NR	KAK9236995.1	34357	g7721	i0	32.5	2.54237288135593	77	49	96.6	2	8	235	243	317	KAK9236995.1 zinc-binding loop region of homing endonuclease-domain-containing protein [Lipomyces kononenkoae]	diamond	600	48.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Lipomyces	Lipomyces kononenkoae
31326489	31326489	PRJNA724039_S_NODE_16775_length_156_cov_0.974790_g16568_i0	PRJNA724039	16775	156	0.97479	1.5206724	Ascomycota	4890	Fungi	Fungi	96.7	7.91e-22	NR	NP_013625.1	559292	g16568	i0	82.4	11.9423076923077	51	9	98.1	0	153	1	60	110	NP_013625.1 alpha-tubulin TUB1 [Saccharomyces cerevisiae S288C]	diamond	1863	96.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
31948670	31948670	PRJNA724039_S_NODE_15017_length_165_cov_0.906250_g14810_i0	PRJNA724039	15017	165	0.90625	1.4953125	Gomphillus americanus	1940652	Fungi	Fungi	63.5	5.78e-10	NR	CAF9931583.1	1940652	g14810	i0	59.3	0.981818181818182	54	22	98.2	0	164	3	265	318	CAF9931583.1 MAG: Nucleolar GTP-binding protein 1 [Gomphillus americanus]	diamond	162	63.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Ostropales	Graphidaceae	Gomphillus	Gomphillus americanus
32433993	32433993	PRJNA724039_S_NODE_17639_length_152_cov_1.660870_g17432_i0	PRJNA724039	17639	152	1.66087	2.5245224	Orbiliaceae	47021	Fungi	Fungi	50.4	2.04e-5	NR	KAJ6258373.1	74499	g17432	i0	67.4	2.46710526315789	43	14	84.9	0	152	24	1317	1359	KAJ6258373.1 Serine/threonine-protein kinase [Drechslerella dactyloides]	diamond	375	50.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Drechslerella	Drechslerella dactyloides

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