metadata: contig_metadata: 5 rows where bioproject = "PRJNA188516" and tax

5 rows where bioproject = "PRJNA188516" and tax_phylum = "Zoopagomycota"

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
9293878	9293878	PRJNA188516_P_NODE_3048_length_196_cov_1.047619_g2998_i0	PRJNA188516	3048	196	1.047619	2.05333324	Linderina pennispora	61395	Fungi	Fungi	119	1.65e-22	NTclustered	gi\|2028318212\|ref\|XM_040887184.1\|	61395	g2998	i0	93.671	4.43367346938776	79	5	40	0	42	120	940	1018	Linderina pennispora ribosomal protein L18e (DL89DRAFT_266692), mRNA	blastn	869	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
27453359	27453359	PRJNA188516_P_NODE_5523_length_164_cov_0.904348_g5473_i0	PRJNA188516	5523	164	0.904348	1.48313072	Ramicandelaber brevisporus	304332	Fungi	Fungi	44.3	0.00305	NR	KAI8872597.1	304332	g5473	i0	78.1	0.585365853658537	32	7	58.5	0	164	69	154	185	KAI8872597.1 hypothetical protein GQ42DRAFT_161183 [Ramicandelaber brevisporus]	diamond	96	44.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
27597403	27597403	PRJNA188516_P_NODE_1544_length_291_cov_1.128099_g1494_i0	PRJNA188516	1544	291	1.128099	3.28276809	Eukaryota	2759	Fungi	Fungi	43.9	0.0255	NR	KAJ1962482.1	4866	g1494	i0	42	10.3917525773196	50	29	51.5	0	140	289	330	379	KAJ1962482.1 hypothetical protein GGI12_002627 [Dipsacomyces acuminosporus]	diamond	3024	44.3	0.99097065462754	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Dipsacomyces	Dipsacomyces acuminosporus
28937232	28937232	PRJNA188516_P_NODE_1108_length_357_cov_1.909091_g1058_i0	PRJNA188516	1108	357	1.909091	6.81545487	Ramicandelaber brevisporus	304332	Fungi	Fungi	96.7	4.76e-23	NR	KAI8872700.1	304332	g1058	i0	41.1	0.941176470588235	112	58	94.1	1	22	357	13	116	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	336	96.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
32620845	32620845	PRJNA188516_P_NODE_6140_length_162_cov_0.920354_g6090_i0	PRJNA188516	6140	162	0.920354	1.49097348	root	1	Root_unresolved	Root_unresolved	54.3	2.8e-7	NR	KAI9591021.1	1851187	g6090	i0	75	1.18518518518519	32	8	59.3	0	2	97	120	151	KAI9591021.1 ubiquitin-conjugating enzyme/RWD-like protein [Syncephalis fuscata]	diamond	192	54.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis fuscata

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