metadata: contig_metadata: 11 rows where bioproject = "PRJNA760904", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA760904", tax_kingdom = "Fungi" and tax_phylum = "Cryptomycota"

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_genus	tax_species
22419533	22419533	PRJNA760904_P_NODE_12358_length_268_cov_1.579487_g12301_i0	PRJNA760904	12358	268	1.579487	4.23302516	Eukaryota	2759	Fungi	Fungi	108	5.61e-28	NR	EPZ31014.1	988480	g12301	i0	79.1	31.1529850746269	67	14	75	0	1	201	39	105	EPZ31014.1 Ribosomal protein L44e domain-containing protein [Rozella allomycis CSF55]	diamond	8349	109	0.990825688073395	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
26704700	26704700	PRJNA760904_P_NODE_11981_length_271_cov_1.368687_g11924_i0	PRJNA760904	11981	271	1.368687	3.70914177	Rozella allomycis CSF55	988480	Fungi	Fungi	49.3	1.83e-4	NR	EPZ34888.1	988480	g11924	i0	33.7	1.98154981549816	89	57	98.5	1	1	267	74	160	EPZ34888.1 Protein kinase, ATP binding site domain-containing protein [Rozella allomycis CSF55]	diamond	537	49.3	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
27337698	27337698	PRJNA760904_P_NODE_17223_length_247_cov_0.885057_g17166_i0	PRJNA760904	17223	247	0.885057	2.18609079	Rozella allomycis CSF55	988480	Fungi	Fungi	71.6	2.59e-12	NR	RKP19638.1	988480	g17166	i0	47.3	0.898785425101215	74	37	89.9	1	223	2	314	385	RKP19638.1 GDP-mannose 4,6-dehydratase [Rozella allomycis CSF55]	diamond	222	71.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
27653533	27653533	PRJNA760904_P_NODE_12364_length_268_cov_1.579487_g12307_i0	PRJNA760904	12364	268	1.579487	4.23302516	Rozella allomycis CSF55	988480	Fungi	Fungi	94.7	1.39e-21	NR	EPZ32997.1	988480	g12307	i0	46.6	1.99253731343284	88	47	98.5	0	265	2	57	144	EPZ32997.1 hypothetical protein O9G_004411 [Rozella allomycis CSF55]	diamond	534	94.7	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
27947273	27947273	PRJNA760904_P_NODE_19745_length_242_cov_1.822485_g19688_i0	PRJNA760904	19745	242	1.822485	4.4104137	Eukaryota	2759	Fungi	Fungi	62.4	2.06e-9	NR	EPZ32997.1	988480	g19688	i0	35.4	1.97107438016529	79	49	95.5	1	232	2	61	139	EPZ32997.1 hypothetical protein O9G_004411 [Rozella allomycis CSF55]	diamond	477	62.8	0.993630573248408	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28127089	28127089	PRJNA760904_P_NODE_21105_length_235_cov_2.098765_g21048_i0	PRJNA760904	21105	235	2.098765	4.93209775	Rozella allomycis CSF55	988480	Fungi	Fungi	58.5	8.98e-8	NR	EPZ35390.1	988480	g21048	i0	53.2	3.99574468085106	47	22	60	0	23	163	292	338	EPZ35390.1 Mg2+, CorA-like/Zinc transporter domain-containing protein [Rozella allomycis CSF55]	diamond	939	58.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28136806	28136806	PRJNA760904_P_NODE_3045_length_470_cov_1.521411_g2988_i0	PRJNA760904	3045	470	1.521411	7.1506317	Fungi	4751	Fungi	Fungi	128	6.31e-34	NR	EPZ35666.1	988480	g2988	i0	66.7	5.22127659574468	90	29	56.8	1	401	135	4	93	EPZ35666.1 MOB kinase activator-like protein [Rozella allomycis CSF55]	diamond	2454	128	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28821298	28821298	PRJNA760904_P_NODE_2308_length_530_cov_1.807440_g2252_i0	PRJNA760904	2308	530	1.80744	9.579432	Rozella allomycis CSF55	988480	Fungi	Fungi	68.6	5.17e-10	NR	RKP21201.1	988480	g2252	i0	28.7	6.06792452830189	174	84	96.2	4	19	528	145	282	RKP21201.1 kinase-like protein [Rozella allomycis CSF55]	diamond	3216	68.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29831954	29831954	PRJNA760904_P_NODE_8511_length_307_cov_1.217949_g8454_i0	PRJNA760904	8511	307	1.217949	3.73910343	Rozella allomycis CSF55	988480	Fungi	Fungi	108	4.21e-25	NR	EPZ31936.1	988480	g8454	i0	48.5	1.97394136807818	101	52	98.7	0	2	304	22	122	EPZ31936.1 Cytochrome P450 domain-containing protein [Rozella allomycis CSF55]	diamond	606	108	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32013007	32013007	PRJNA760904_P_NODE_9358_length_293_cov_2.177273_g9301_i0	PRJNA760904	9358	293	2.177273	6.37940989	Rozella allomycis CSF55	988480	Fungi	Fungi	54.3	5.76e-6	NR	EPZ32202.1	988480	g9301	i0	37.3	0.849829351535836	83	50	84	2	292	47	79	160	EPZ32202.1 hypothetical protein O9G_002554 [Rozella allomycis CSF55]	diamond	249	54.3	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32234752	32234752	PRJNA760904_P_NODE_1158_length_714_cov_2.205928_g1105_i0	PRJNA760904	1158	714	2.205928	15.75032592	Rozella allomycis CSF55	988480	Fungi	Fungi	277	7.66e-91	NR	EPZ35724.1	988480	g1105	i0	60.8	4.52100840336134	212	83	89.1	0	680	45	17	228	EPZ35724.1 Adenylate kinase [Rozella allomycis CSF55]	diamond	3228	277	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis

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