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

6 rows where analysis = "diamond", bioproject = "PRJNA1253698" 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
14388771	14388771	PRJNA1253698_S_NODE_18412_length_168_cov_1.285714_g18046_i0	PRJNA1253698	18412	168	1.285714	2.15999952	Phaffia rhodozyma	264483	Fungi	Fungi	93.6	1.13e-21	NR	CDZ98713.1	264483	g18046	i0	88.5	0.928571428571429	52	6	92.9	0	11	166	127	178	CDZ98713.1 60s ribosomal protein l18 [Phaffia rhodozyma]	diamond	156	93.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
28337123	28337123	PRJNA1253698_S_NODE_10686_length_211_cov_1.432099_g10320_i0	PRJNA1253698	10686	211	1.432099	3.02172889	Agrocybe pediades	84607	Fungi	Fungi	48.9	2.97e-5	NR	KAF9546597.1	84607	g10320	i0	55	0.568720379146919	40	16	56.9	2	195	76	72	109	KAF9546597.1 hypothetical protein CPC08DRAFT_715971 [Agrocybe pediades]	diamond	120	48.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Agrocybe	Agrocybe pediades
30231781	30231781	PRJNA1253698_S_NODE_20172_length_166_cov_0.888889_g19806_i0	PRJNA1253698	20172	166	0.888889	1.47555574	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	70.1	2.98e-12	NR	XP_007304038.1	721885	g19806	i0	100	0.560240963855422	31	0	56	0	94	2	210	240	XP_007304038.1 DNA ligase/mRNA capping enzyme, partial [Stereum hirsutum FP-91666 SS1]	diamond	93	70.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
31703581	31703581	PRJNA1253698_S_NODE_21177_length_165_cov_0.887931_g20811_i0	PRJNA1253698	21177	165	0.887931	1.46508615	Kwoniella	490731	Fungi	Fungi	50.8	1.76e-5	NR	XP_062789706.1	564305	g20811	i0	61	2.43636363636364	41	16	74.5	0	125	3	171	211	XP_062789706.1 uncharacterized protein IL334_001907 [Kwoniella shivajii]	diamond	402	51.2	0.9921875	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella shivajii
32002047	32002047	PRJNA1253698_S_NODE_19178_length_167_cov_1.296610_g18812_i0	PRJNA1253698	19178	167	1.29661	2.1653387	Plicaturopsis crispa FD-325 SS-3	944288	Fungi	Fungi	103	4.98e-24	NR	KII92484.1	944288	g18812	i0	98.1	0.970059880239521	54	1	97	0	4	165	541	594	KII92484.1 hypothetical protein PLICRDRAFT_695837 [Plicaturopsis crispa FD-325 SS-3]	diamond	162	103	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Amylocorticiales	Amylocorticiaceae	Plicatura	Plicatura crispa
32476800	32476800	PRJNA1253698_S_NODE_19259_length_167_cov_0.881356_g18893_i0	PRJNA1253698	19259	167	0.881356	1.47186452	Taiwanofungus camphoratus	2696576	Fungi	Fungi	68.9	7.61e-12	NR	KAI0941631.1	2696576	g18893	i0	74.4	5.60479041916168	39	10	70.1	0	42	158	500	538	KAI0941631.1 hypothetical protein AcW1_003472 [Taiwanofungus camphoratus]	diamond	936	68.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Taiwanofungaceae	Taiwanofungus	Taiwanofungus camphoratus

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