metadata: contig_metadata: 8 rows where bioproject = "PRJNA986481" and tax

8 rows where bioproject = "PRJNA986481" 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
25199704	25199704	PRJNA986481_P_NODE_3140_length_848_cov_12.630788_g2780_i0	PRJNA986481	3140	848	12.630788	107.10908224	Eukaryota	2759	Fungi	Fungi	415	2.5199999999999995e-144	NR	EPZ33659.1	988480	g2780	i0	77.9	29.5860849056604	249	55	88.1	0	4	750	2	250	EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55]	diamond	25089	417	0.995203836930456	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
26899938	26899938	PRJNA986481_P_NODE_43561_length_259_cov_10.357143_g43036_i0	PRJNA986481	43561	259	10.357143	26.82500037	Rozella allomycis CSF55	988480	Fungi	Fungi	81.6	1.72e-16	NR	EPZ34692.1	988480	g43036	i0	66.2	3.63706563706564	65	21	74.1	1	206	15	190	254	EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55]	diamond	942	81.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
27247619	27247619	PRJNA986481_P_NODE_19143_length_374_cov_1.864615_g18618_i0	PRJNA986481	19143	374	1.864615	6.9736601	Rozella allomycis CSF55	988480	Fungi	Fungi	85.5	1.46e-16	NR	EPZ35951.1	988480	g18618	i0	41.3	1.53208556149733	104	52	83.4	1	324	13	102	196	EPZ35951.1 Fatty acid desaturase, type 1 domain-containing protein [Rozella allomycis CSF55]	diamond	573	85.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28100160	28100160	PRJNA986481_P_NODE_39225_length_265_cov_0.935185_g38700_i0	PRJNA986481	39225	265	0.935185	2.47824025	Rozella allomycis CSF55	988480	Fungi	Fungi	49.3	2.44e-4	NR	EPZ31654.1	988480	g38700	i0	38.6	0.792452830188679	70	43	79.2	0	53	262	37	106	EPZ31654.1 GPCR, family 3 domain-containing protein [Rozella allomycis CSF55]	diamond	210	49.3	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28352824	28352824	PRJNA986481_P_NODE_27866_length_311_cov_1.156489_g27341_i0	PRJNA986481	27866	311	1.156489	3.59668079	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	75.1	3.55e-13	NR	PJF17455.1	1246581	g27341	i0	50	2.45980707395498	72	36	69.5	0	242	27	82	153	PJF17455.1 Pkinase-domain-containing protein, partial [Paramicrosporidium saccamoebae]	diamond	765	75.1	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31106468	31106468	PRJNA986481_P_NODE_53315_length_248_cov_2.613065_g52790_i0	PRJNA986481	53315	248	2.613065	6.4804012	Fungi	4751	Fungi	Fungi	43.1	0.0143	NR	PJF19843.1	1246581	g52790	i0	60	1.76612903225806	30	12	36.3	0	247	158	121	150	PJF19843.1 EF-Hand 1, calcium-binding site domain-containing protein, partial [Paramicrosporidium saccamoebae]	diamond	438	43.1	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31669803	31669803	PRJNA986481_P_NODE_20117_length_365_cov_3.547468_g19592_i0	PRJNA986481	20117	365	3.547468	12.9482582	Rozella allomycis CSF55	988480	Fungi	Fungi	62.4	1.81e-8	NR	RKP20800.1	988480	g19592	i0	39.5	1.41369863013699	86	49	69	2	312	61	346	430	RKP20800.1 ras GEF [Rozella allomycis CSF55]	diamond	516	62.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32334563	32334563	PRJNA986481_P_NODE_35819_length_273_cov_1.026786_g35294_i0	PRJNA986481	35819	273	1.026786	2.80312578	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	65.9	4.04e-10	NR	PJF19671.1	1246581	g35294	i0	45.2	9.95604395604396	93	48	98.9	3	1	270	581	673	PJF19671.1 Integral membrane protein [Paramicrosporidium saccamoebae]	diamond	2718	65.9	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae

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