metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA846086" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA846086" 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
2108336	2108336	PRJNA846086_P_NODE_4102_length_247_cov_0.885057_g4036_i0	PRJNA846086	4102	247	0.885057	2.18609079	Eukaryota	2759	Fungi	Fungi	154	5.979999999999998e-42	NR	KAA1088501.1	56615	g4036	i0	87.7	100.2995951417	81	10	98.4	0	3	245	383	463	KAA1088501.1 ATP-dependent RNA helicase [Puccinia graminis f. sp. tritici]	diamond	24774	155	0.993548387096774	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia graminis
25059042	25059042	PRJNA846086_P_NODE_3360_length_250_cov_0.870056_g3294_i0	PRJNA846086	3360	250	0.870056	2.17514	Malassezia	55193	Fungi	Fungi	133	3.23e-34	NR	XP_001731701.1	425265	g3294	i0	78.6	5.988	84	17	99.6	1	1	249	531	614	XP_001731701.1 uncharacterized protein MGL_0969 [Malassezia globosa CBS 7966]	diamond	1497	134	0.992537313432836	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
28917732	28917732	PRJNA846086_P_NODE_3848_length_248_cov_0.880000_g3782_i0	PRJNA846086	3848	248	0.88	2.1824	Fistulina hepatica ATCC 64428	1128425	Fungi	Fungi	45.1	0.00619	NR	KIY51003.1	1128425	g3782	i0	36.4	1.86290322580645	77	48	93.1	1	238	8	861	936	KIY51003.1 hypothetical protein FISHEDRAFT_38185 [Fistulina hepatica ATCC 64428]	diamond	462	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Fistulinaceae	Fistulina	Fistulina hepatica
29991604	29991604	PRJNA846086_P_NODE_1451_length_314_cov_1.904564_g1385_i0	PRJNA846086	1451	314	1.904564	5.98033096	Daedaleopsis nitida	1140402	Fungi	Fungi	44.7	0.0182	NR	KAI0741314.1	1140402	g1385	i0	34.9	0.601910828025478	63	36	60.2	2	305	117	433	490	KAI0741314.1 hypothetical protein C8Q80DRAFT_1273779 [Daedaleopsis nitida]	diamond	189	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Daedaleopsis	Daedaleopsis nitida
31413603	31413603	PRJNA846086_P_NODE_3536_length_249_cov_0.875000_g3470_i0	PRJNA846086	3536	249	0.875	2.17875	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	138	8.28e-36	NR	XP_066826409.1	1397322	g3470	i0	85.4	1.97590361445783	82	12	98.8	0	248	3	85	166	XP_066826409.1 uncharacterized protein P389DRAFT_199966 [Cystobasidium minutum MCA 4210]	diamond	492	138	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
31919687	31919687	PRJNA846086_P_NODE_4077_length_247_cov_0.885057_g4011_i0	PRJNA846086	4077	247	0.885057	2.18609079	Dioszegia hungarica	4972	Fungi	Fungi	101	1.02e-22	NR	XP_052942887.1	4972	g4011	i0	60.3	0.947368421052632	78	31	94.7	0	240	7	65	142	XP_052942887.1 glycoside hydrolase [Dioszegia hungarica]	diamond	234	101	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica

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