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

5 rows where analysis = "diamond", bioproject = "PRJNA656952" 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
14651287	14651287	PRJNA656952_P_NODE_31432_length_251_cov_0.865169_g31245_i0	PRJNA656952	31432	251	0.865169	2.17157419	Malassezia cuniculi	948313	Fungi	Fungi	143	1.34e-37	NR	WFD36085.1	948313	g31245	i0	93.9	0.9800796812749	82	5	98	0	3	248	87	168	WFD36085.1 hypothetical protein MCUN1_002956 [Malassezia cuniculi]	diamond	246	143	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia cuniculi
27366097	27366097	PRJNA656952_P_NODE_41703_length_243_cov_0.905882_g41516_i0	PRJNA656952	41703	243	0.905882	2.20129326	Pleurotus ostreatus PC15	1137138	Fungi	Fungi	62	5.87e-9	NR	KDQ31486.1	1137138	g41516	i0	81.3	2.76543209876543	32	6	39.5	0	241	146	331	362	KDQ31486.1 hypothetical protein PLEOSDRAFT_1036482 [Pleurotus ostreatus PC15]	diamond	672	62	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus ostreatus
28534267	28534267	PRJNA656952_P_NODE_44127_length_241_cov_0.916667_g43940_i0	PRJNA656952	44127	241	0.916667	2.20916747	Hypsizygus marmoreus	39966	Fungi	Fungi	43.5	0.019	NR	RDB25859.1	39966	g43940	i0	39.6	0.659751037344398	53	30	66	1	167	9	558	608	RDB25859.1 hypothetical protein Hypma_006839 [Hypsizygus marmoreus]	diamond	159	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Hypsizygus	Hypsizygus marmoreus
31029446	31029446	PRJNA656952_P_NODE_8915_length_409_cov_1.223214_g8728_i0	PRJNA656952	8915	409	1.223214	5.00294526	Cutaneotrichosporon sp. HIS471	3040995	Fungi	Fungi	45.1	0.0322	NR	BEJ11527.1	3040995	g8728	i0	34.9	0.462102689486553	63	41	46.2	0	37	225	320	382	BEJ11527.1 hypothetical protein CspHIS471_0109490 [Cutaneotrichosporon sp. HIS471]	diamond	189	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Cutaneotrichosporon	Cutaneotrichosporon sp. HIS471
31104496	31104496	PRJNA656952_P_NODE_32035_length_251_cov_0.865169_g31848_i0	PRJNA656952	32035	251	0.865169	2.17157419	Cutaneotrichosporon	1838142	Fungi	Fungi	151	2.14e-40	NR	BEI83023.1	279322	g31848	i0	85.5	1.9840637450199201	83	12	99.2	0	2	250	380	462	BEI83023.1 hypothetical protein CcaverHIS002_0308910 [Cutaneotrichosporon cavernicola]	diamond	498	151	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Cutaneotrichosporon	Cutaneotrichosporon cavernicola

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