metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax

12 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_kingdom = "Fungi"

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
8930975	8930975	PRJDB12578_S_NODE_198108_length_167_cov_1.313559_g175050_i0	PRJDB12578	198108	167	1.313559	2.19364353	Ascomycota	4890	Fungi	Fungi	103	1.84e-26	NR	GMF83095.1	5477	g175050	i0	90.6	13.3652694610778	53	5	95.2	0	2	160	73	125	GMF83095.1 unnamed protein product [[Candida] boidinii]	diamond	2232	104	0.990384615384615	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ogataea	[Candida] boidinii
26715436	26715436	PRJDB12578_S_NODE_144541_length_209_cov_0.968750_g121483_i0	PRJDB12578	144541	209	0.96875	2.0246875	Torulaspora globosa	48254	Fungi	Fungi	45.1	0.00364	NR	QLQ82424.1	48254	g121483	i0	37.5	0.688995215311005	48	30	68.9	0	38	181	403	450	QLQ82424.1 hypothetical protein HG537_0H01860 [Torulaspora globosa]	diamond	144	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Torulaspora	Torulaspora globosa
27532094	27532094	PRJDB12578_S_NODE_200703_length_166_cov_1.333333_g177645_i0	PRJDB12578	200703	166	1.333333	2.21333278	Opisthokonta	33154	Fungi	Fungi	66.2	6.51e-11	NR	KAI8397459.1	5507	g177645	i0	53.8	13.1385542168675	52	24	94	0	158	3	987	1038	KAI8397459.1 hypothetical protein FOFC_20731 [Fusarium oxysporum]	diamond	2181	66.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
28074617	28074617	PRJDB12578_S_NODE_104125_length_279_cov_1.356522_g81067_i0	PRJDB12578	104125	279	1.356522	3.78469638	Fusarium oxysporum f. sp. cepae	396571	Fungi	Fungi	43.1	0.0343	NR	RKK14334.1	396571	g81067	i0	31.2	0.827956989247312	77	53	82.8	0	37	267	22	98	RKK14334.1 hypothetical protein BFJ65_g10899 [Fusarium oxysporum f. sp. cepae]	diamond	231	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
28548521	28548521	PRJDB12578_S_NODE_132807_length_223_cov_0.896552_g109749_i0	PRJDB12578	132807	223	0.896552	1.99931096	Paxillus ammoniavirescens	1132860	Fungi	Fungi	42	0.0254	NR	KAF8843422.1	1132860	g109749	i0	25	0.860986547085202	64	48	86.1	0	192	1	70	133	KAF8843422.1 hypothetical protein BDN67DRAFT_964545 [Paxillus ammoniavirescens]	diamond	192	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Paxillaceae	Paxillus	Paxillus ammoniavirescens
29779681	29779681	PRJDB12578_S_NODE_174891_length_181_cov_6.674242_g151833_i0	PRJDB12578	174891	181	6.674242	12.08037802	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	44.7	0.00227	NR	KAH9262945.1	1357716	g151833	i0	80.8	0.861878453038674	26	5	43.1	0	38	115	51	76	KAH9262945.1 hypothetical protein BASA82_000043 [Batrachochytrium salamandrivorans]	diamond	156	44.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
30790658	30790658	PRJDB12578_S_NODE_174254_length_182_cov_1.526316_g151196_i0	PRJDB12578	174254	182	1.526316	2.77789512	Austropuccinia psidii	181123	Fungi	Fungi	43.9	0.00641	NR	MBW0511442.1	1389203	g151196	i0	44.9	0.807692307692308	49	25	77.5	1	27	167	359	407	MBW0511442.1 hypothetical protein [Austropuccinia psidii MF-1]	diamond	147	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Sphaerophragmiaceae	Austropuccinia	Austropuccinia psidii
31296237	31296237	PRJDB12578_S_NODE_144335_length_209_cov_1.281250_g121277_i0	PRJDB12578	144335	209	1.28125	2.6778125	Sparassis crispa	139825	Fungi	Fungi	55.1	1.08e-6	NR	XP_027620327.1	139825	g121277	i0	58.5	2.35406698564593	41	17	58.9	0	123	1	1347	1387	XP_027620327.1 hypothetical protein SCP_1600760 [Sparassis crispa]	diamond	492	55.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Sparassidaceae	Sparassis	Sparassis crispa
31359728	31359728	PRJDB12578_S_NODE_183836_length_175_cov_1.238095_g160778_i0	PRJDB12578	183836	175	1.238095	2.16666625	Geotrichum candidum	1173061	Fungi	Fungi	43.1	0.0113	NR	KAF5106743.1	1173061	g160778	i0	40	0.942857142857143	55	33	94.3	0	166	2	933	987	KAF5106743.1 hypothetical protein DV453_003703 [Geotrichum candidum]	diamond	165	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Dipodascaceae	Geotrichum	Geotrichum candidum
32213783	32213783	PRJDB12578_S_NODE_158758_length_195_cov_1.068493_g135700_i0	PRJDB12578	158758	195	1.068493	2.08356135	Sphaerobolus stellatus SS14	990650	Fungi	Fungi	43.1	0.0145	NR	KIJ25936.1	990650	g135700	i0	43.9	0.630769230769231	41	23	63.1	0	135	13	278	318	KIJ25936.1 hypothetical protein M422DRAFT_273077 [Sphaerobolus stellatus SS14]	diamond	123	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Geastrales	Sphaerobolaceae	Sphaerobolus	Sphaerobolus stellatus
32397823	32397823	PRJDB12578_S_NODE_148039_length_205_cov_1.333333_g124981_i0	PRJDB12578	148039	205	1.333333	2.73333265	Opisthokonta	33154	Fungi	Fungi	48.1	2.77e-4	NR	XP_070059957.1	5467	g124981	i0	57.9	2.85365853658537	38	12	55.6	1	27	140	321	354	XP_070059957.1 reverse transcriptase domain protein [Colletotrichum truncatum]	diamond	585	48.5	0.991752577319588	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum truncatum
32687606	32687606	PRJDB12578_S_NODE_91940_length_322_cov_4.300366_g68882_i0	PRJDB12578	91940	322	4.300366	13.84717852	Powellomyces hirtus	109895	Fungi	Fungi	44.3	0.0273	NR	TPX59904.1	109895	g68882	i0	40.7	0.503105590062112	54	32	50.3	0	165	4	68	121	TPX59904.1 hypothetical protein PhCBS80983_g02099 [Powellomyces hirtus]	diamond	162	44.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus

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