metadata: contig_metadata: 7 rows where bioproject = "PRJEB14664" and tax

7 rows where bioproject = "PRJEB14664" 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
8948247	8948247	PRJEB14664_P_NODE_548_length_1208_cov_3.213129_g494_i0	PRJEB14664	548	1208	3.213129	38.81459832	Rozella allomycis CSF55	988480	Fungi	Fungi	340	1.1099999999999999e-110	NR	EPZ31166.1	988480	g494	i0	79.8	5.16307947019868	203	41	50.4	0	16	624	1	203	EPZ31166.1 60S ribosomal protein L3 [Rozella allomycis CSF55]	diamond	6237	340	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
10223991	10223991	PRJEB14664_P_NODE_4469_length_411_cov_2.640957_g4341_i0	PRJEB14664	4469	411	2.6409570000000002	10.85433327	Eukaryota	2759	Fungi	Fungi	232	5.619999999999998e-69	NR	RKP16771.1	988480	g4341	i0	80	11.8248175182482	135	27	98.5	0	406	2	309	443	RKP16771.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Rozella allomycis CSF55]	diamond	4860	232	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
24247117	24247117	PRJEB14664_P_NODE_7900_length_284_cov_2.341365_g7770_i0	PRJEB14664	7900	284	2.341365	6.6494766	Fungi	4751	Fungi	Fungi	120	1.7499999999999998e-30	NR	EPZ31990.1	988480	g7770	i0	69.5	1.95422535211268	95	28	99.3	1	283	2	6	100	EPZ31990.1 Fructose-bisphosphate aldolase A [Rozella allomycis CSF55]	diamond	555	120	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
25211806	25211806	PRJEB14664_P_NODE_13640_length_195_cov_1.231250_g13510_i0	PRJEB14664	13640	195	1.23125	2.4009375	Rozella allomycis CSF55	988480	Fungi	Fungi	116	4.77e-29	NR	RKP21759.1	988480	g13510	i0	84.6	2	65	10	100	0	195	1	315	379	RKP21759.1 cytoplasmic protein, partial [Rozella allomycis CSF55]	diamond	390	116	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
27343011	27343011	PRJEB14664_P_NODE_20203_length_151_cov_1.034483_g20073_i0	PRJEB14664	20203	151	1.034483	1.56206933	root	1	Root_unresolved	Root_unresolved	68.2	1.14e-11	NR	PJF18441.1	1246581	g20073	i0	68.2	1.78807947019868	44	14	87.4	0	151	20	1680	1723	PJF18441.1 hypothetical protein PSACC_01746 [Paramicrosporidium saccamoebae]	diamond	270	68.2	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
28612171	28612171	PRJEB14664_P_NODE_18287_length_160_cov_0.960000_g18157_i0	PRJEB14664	18287	160	0.96	1.536	Rozella allomycis CSF55	988480	Fungi	Fungi	74.7	5.6e-14	NR	EPZ33916.1	988480	g18157	i0	74.4	0.80625	43	11	80.6	0	7	135	184	226	EPZ33916.1 PAK-box/P21-Rho-binding domain-containing protein [Rozella allomycis CSF55]	diamond	129	74.7	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29149288	29149288	PRJEB14664_P_NODE_18809_length_157_cov_1.311475_g18679_i0	PRJEB14664	18809	157	1.311475	2.05901575	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	62.8	9.86e-10	NR	PJF17397.1	1246581	g18679	i0	51.9	1.98726114649682	52	25	99.4	0	156	1	284	335	PJF17397.1 Sup35p [Paramicrosporidium saccamoebae]	diamond	312	62.8	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);;