metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA784979" 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
26705229	26705229	PRJNA784979_S_NODE_11341_length_165_cov_0.879310_g11299_i0	PRJNA784979	11341	165	0.87931	1.4508615	Cylindrobasidium torrendii FP15	394432	Fungi	Fungi	65.1	1.73e-10	NR	KIY68659.1	1314674	g11299	i0	48.1	0.981818181818182	54	28	98.2	0	4	165	219	272	KIY68659.1 hypothetical protein CYLTODRAFT_489577 [Cylindrobasidium torrendii FP15055 ss-10]	diamond	162	65.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Cylindrobasidium	Cylindrobasidium torrendii
28506419	28506419	PRJNA784979_S_NODE_10507_length_167_cov_0.864407_g10465_i0	PRJNA784979	10507	167	0.864407	1.44355969	Kwoniella heveanensis CBS 569	1296119	Fungi	Fungi	70.5	2.18e-12	NR	OCF42488.1	1296119	g10465	i0	68.6	3.66467065868263	51	16	91.6	0	166	14	585	635	OCF42488.1 CDP-diacylglycerol-glycerol-3-phosphate 3-phosphatidyltransferase [Kwoniella heveanensis CBS 569]	diamond	612	70.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella heveanensis
28916643	28916643	PRJNA784979_S_NODE_1548_length_388_cov_1.905605_g1506_i0	PRJNA784979	1548	388	1.905605	7.3937474	Armillaria gallica	47427	Fungi	Fungi	44.3	0.00544	NR	PBK95230.1	47427	g1506	i0	38	0.548969072164949	71	40	54.9	1	292	80	9	75	PBK95230.1 hypothetical protein ARMGADRAFT_791432 [Armillaria gallica]	diamond	213	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Armillaria	Armillaria gallica
29106417	29106417	PRJNA784979_S_NODE_10948_length_166_cov_0.871795_g10906_i0	PRJNA784979	10948	166	0.871795	1.4471797	Malassezia restricta	76775	Fungi	Fungi	78.6	2.24e-15	NR	XP_027484859.1	76775	g10906	i0	85.5	0.993975903614458	55	8	99.4	0	166	2	137	191	XP_027484859.1 ESCRT-I complex subunit TSG101 [Malassezia restricta]	diamond	165	78.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
32045200	32045200	PRJNA784979_S_NODE_10398_length_167_cov_0.864407_g10356_i0	PRJNA784979	10398	167	0.864407	1.44355969	Cylindrobasidium torrendii FP15	394432	Fungi	Fungi	64.7	2.37e-10	NR	KIY67911.1	1314674	g10356	i0	90.3	0.55688622754491	31	3	55.7	0	2	94	398	428	KIY67911.1 Pkinase-domain-containing protein [Cylindrobasidium torrendii FP15055 ss-10]	diamond	93	64.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Cylindrobasidium	Cylindrobasidium torrendii

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