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

11 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax_phylum = "Basidiomycota"

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
824410	824410	PRJNA833575_P_NODE_35381_length_248_cov_0.932961_g35244_i0	PRJNA833575	35381	248	0.932961	2.31374328	Agaricales	5338	Fungi	Fungi	135	1.12e-35	NR	KAF5370051.1	182062	g35244	i0	81.7	27.7741935483871	82	15	99.2	0	3	248	102	183	KAF5370051.1 hypothetical protein D9758_001127 [Tetrapyrgos nigripes]	diamond	6888	136	0.992647058823529	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Marasmiaceae	Tetrapyrgos	Tetrapyrgos nigripes
5057095	5057095	PRJNA833575_P_NODE_44244_length_228_cov_1.704403_g44107_i0	PRJNA833575	44244	228	1.704403	3.88603884	Fungi	4751	Fungi	Fungi	116	6.56e-29	NR	TFK74285.1	181527	g44107	i0	68.9	18.5	74	23	97.4	0	225	4	267	340	TFK74285.1 phosphoglycerate kinase [Pluteus cervinus]	diamond	4218	116	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pluteaceae	Pluteus	Pluteus cervinus
7607179	7607179	PRJNA833575_P_NODE_7846_length_509_cov_2.045455_g7709_i0	PRJNA833575	7846	509	2.045455	10.41136595	Rhizoctonia solani	456999	Fungi	Fungi	252	3.32e-81	NR	KAJ1304824.1	456999	g7709	i0	77.5	4.36738703339882	169	30	99.6	1	3	509	46	206	KAJ1304824.1 hypothetical protein OPQ81_005959 [Rhizoctonia solani]	diamond	2223	252	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
14852513	14852513	PRJNA833575_P_NODE_41632_length_231_cov_1.333333_g41495_i0	PRJNA833575	41632	231	1.333333	3.07999923	Fungi	4751	Fungi	Fungi	138	3.28e-38	NR	GHJ90305.1	104408	g41495	i0	81.6	37.4805194805195	76	14	98.7	0	3	230	152	227	GHJ90305.1 hypothetical protein NliqN6_6707 [Naganishia liquefaciens]	diamond	8658	138	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens
17806320	17806320	PRJNA833575_P_NODE_20854_length_324_cov_1.125490_g20717_i0	PRJNA833575	20854	324	1.12549	3.6465876	Basidiomycota	5204	Fungi	Fungi	156	9.93e-46	NR	XP_018996939.1	1295533	g20717	i0	68.2	21.787037037037	107	34	99.1	0	323	3	55	161	XP_018996939.1 40S ribosomal protein S4-A, variant 1 [Cryptococcus amylolentus CBS 6039]	diamond	7059	156	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus amylolentus
22501063	22501063	PRJNA833575_P_NODE_27558_length_283_cov_3.261682_g27421_i0	PRJNA833575	27558	283	3.261682	9.23056006	Agaricomycetes	155619	Fungi	Fungi	153	1.16e-45	NR	KAG2039897.1	48561	g27421	i0	78.2	10.1660777385159	87	19	92.2	0	282	22	56	142	KAG2039897.1 ribosomal L37ae protein family-domain-containing protein [Suillus americanus]	diamond	2877	153	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus americanus
27718437	27718437	PRJNA833575_P_NODE_35404_length_247_cov_2.101124_g35267_i0	PRJNA833575	35404	247	2.101124	5.18977628	Puccinia sorghi	27349	Fungi	Fungi	134	1.22e-35	NR	KNZ59519.1	27349	g35267	i0	94.6	0.898785425101215	74	4	89.9	0	3	224	345	418	KNZ59519.1 hypothetical protein VP01_1711g2 [Puccinia sorghi]	diamond	222	134	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia sorghi
28286128	28286128	PRJNA833575_P_NODE_24186_length_302_cov_1.824034_g24049_i0	PRJNA833575	24186	302	1.824034	5.50858268	Suillus lakei	48574	Fungi	Fungi	98.2	2.4300000000000003e-21	NR	KAG1757558.1	48574	g24049	i0	43	0.993377483443709	100	57	99.3	0	300	1	383	482	KAG1757558.1 ARM repeat-containing protein [Suillus lakei]	diamond	300	98.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus lakei
28791398	28791398	PRJNA833575_P_NODE_36067_length_244_cov_1.811429_g35930_i0	PRJNA833575	36067	244	1.811429	4.41988676	Rhodotorula mucilaginosa	5537	Fungi	Fungi	45.4	0.00418	NR	KAG0665845.1	5537	g35930	i0	51.3	0.479508196721311	39	19	48	0	126	242	598	636	KAG0665845.1 H(+)-transporting V1 sector ATPase subunit A [Rhodotorula mucilaginosa]	diamond	117	45.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula mucilaginosa
30054443	30054443	PRJNA833575_P_NODE_46371_length_226_cov_0.917197_g46234_i0	PRJNA833575	46371	226	0.917197	2.07286522	Puccinia graminis f. sp. tritici	56615	Fungi	Fungi	157	2.13e-46	NR	KAA1132188.1	56615	g46234	i0	97.3	2.94690265486726	74	2	98.2	0	224	3	59	132	KAA1132188.1 hypothetical protein PGTUg99_002480 [Puccinia graminis f. sp. tritici]	diamond	666	157	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia graminis
32678110	32678110	PRJNA833575_P_NODE_43580_length_229_cov_0.900000_g43443_i0	PRJNA833575	43580	229	0.9	2.061	Cristinia sonorae	1940300	Fungi	Fungi	95.5	4.13e-21	NR	KAH8104671.1	1940300	g43443	i0	64.5	2.38427947598253	62	22	81.2	0	186	1	5	66	KAH8104671.1 fragmin60 [Cristinia sonorae]	diamond	546	95.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Stephanosporaceae	Cristinia	Cristinia sonorae

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