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

5 rows where analysis = "diamond", bioproject = "PRJNA1174770" 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
26882504	26882504	PRJNA1174770_P_NODE_8241_length_168_cov_0.873950_g8152_i0	PRJNA1174770	8241	168	0.87395	1.468236	Pluteus cervinus	181527	Fungi	Fungi	44.7	0.0028	NR	TFK62236.1	181527	g8152	i0	39.1	5.92857142857143	46	28	82.1	0	3	140	552	597	TFK62236.1 hypothetical protein BDN72DRAFT_903401 [Pluteus cervinus]	diamond	996	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pluteaceae	Pluteus	Pluteus cervinus
27293441	27293441	PRJNA1174770_P_NODE_8263_length_168_cov_0.873950_g8174_i0	PRJNA1174770	8263	168	0.87395	1.468236	Marasmiellus scandens	2682957	Fungi	Fungi	64.7	9.91e-11	NR	KAK7443235.1	2682957	g8174	i0	60	0.982142857142857	55	16	98.2	1	166	2	38	86	KAK7443235.1 hypothetical protein VKT23_015833 [Marasmiellus scandens]	diamond	165	64.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Marasmiellus	Marasmiellus scandens
29219712	29219712	PRJNA1174770_P_NODE_8289_length_168_cov_0.873950_g8200_i0	PRJNA1174770	8289	168	0.87395	1.468236	Malassezia restricta	76775	Fungi	Fungi	93.6	1.63e-20	NR	XP_027484632.1	76775	g8200	i0	90.7	0.964285714285714	54	5	96.4	0	5	166	32	85	XP_027484632.1 sentrin-specific protease 7 [Malassezia restricta]	diamond	162	93.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30230147	30230147	PRJNA1174770_P_NODE_12212_length_162_cov_0.911504_g12123_i0	PRJNA1174770	12212	162	0.911504	1.47663648	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	67	3.47e-11	NR	XP_007305615.1	721885	g12123	i0	83.3	0.666666666666667	36	6	66.7	0	153	46	210	245	XP_007305615.1 uncharacterized protein STEHIDRAFT_99214 [Stereum hirsutum FP-91666 SS1]	diamond	108	67	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
31987884	31987884	PRJNA1174770_P_NODE_9318_length_166_cov_0.888889_g9229_i0	PRJNA1174770	9318	166	0.888889	1.47555574	Hymenochaetaceae	40424	Fungi	Fungi	52.8	3.88e-6	NR	KAH8094774.1	127956	g9229	i0	75.6	1.68072289156627	41	10	74.1	0	165	43	1308	1348	KAH8094774.1 hypothetical protein DFH11DRAFT_1738329 [Phellopilus nigrolimitatus]	diamond	279	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Phellopilus	Phellopilus nigrolimitatus

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