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

6 rows where analysis = "diamond", bioproject = "PRJNA637219" 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
1885049	1885049	PRJNA637219_S_NODE_62_length_1214_cov_7.116738_g49_i0	PRJNA637219	62	1214	7.116738	86.39719932	Opisthokonta	33154	Fungi	Fungi	361	7.71e-120	NR	CED82942.1	264483	g49	i0	65.6	22.4036243822076	311	105	76.9	1	1180	248	29	337	CED82942.1 G protein beta subunit-like protein [Phaffia rhodozyma]	diamond	27198	363	0.994490358126722	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
21011168	21011168	PRJNA637219_S_NODE_1417_length_368_cov_6.460815_g1372_i0	PRJNA637219	1417	368	6.460815	23.7757992	Austropuccinia psidii	181123	Fungi	Fungi	157	2.79e-47	NR	MBW0489473.1	1389203	g1372	i0	85.7	2.83695652173913	84	12	68.5	0	357	106	1	84	MBW0489473.1 hypothetical protein [Austropuccinia psidii MF-1]	diamond	1044	157	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Sphaerophragmiaceae	Austropuccinia	Austropuccinia psidii
27124732	27124732	PRJNA637219_S_NODE_6142_length_204_cov_1.645161_g6097_i0	PRJNA637219	6142	204	1.645161	3.35612844	root	1	Root_unresolved	Root_unresolved	47.8	3.7e-4	NR	CDZ97993.1	264483	g6097	i0	50	1.41176470588235	48	24	70.6	0	3	146	165	212	CDZ97993.1 actin actin-like protein [Phaffia rhodozyma]	diamond	288	47.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
27807747	27807747	PRJNA637219_S_NODE_11484_length_166_cov_1.000000_g11439_i0	PRJNA637219	11484	166	1	1.66	Mycena olivaceomarginata	230810	Fungi	Fungi	48.5	1.16e-4	NR	KAJ7830642.1	230810	g11439	i0	72.4	0.524096385542169	29	8	52.4	0	157	71	265	293	KAJ7830642.1 peptidase S8/S53 domain-containing protein [Mycena olivaceomarginata]	diamond	87	48.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena olivaceomarginata
29606872	29606872	PRJNA637219_S_NODE_15930_length_162_cov_0.902655_g15885_i0	PRJNA637219	15930	162	0.902655	1.4623011	Rhodotorula graminis WP1	578459	Fungi	Fungi	46.6	5.64e-4	NR	XP_018269449.1	578459	g15885	i0	96.3	0.5	27	0	50	1	153	73	2030	2055	XP_018269449.1 uncharacterized protein RHOBADRAFT_55149 [Rhodotorula graminis WP1]	diamond	81	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula graminis
31863345	31863345	PRJNA637219_S_NODE_15917_length_162_cov_0.902655_g15872_i0	PRJNA637219	15917	162	0.902655	1.4623011	Agaricomycetes	155619	Fungi	Fungi	74.7	6.76e-14	NR	KAJ3518016.1	84603	g15872	i0	66	12.7592592592593	53	18	98.1	0	4	162	397	449	KAJ3518016.1 hypothetical protein NLJ89_g136 [Agrocybe chaxingu]	diamond	2067	74.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Agrocybe	Agrocybe chaxingu

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