metadata: contig_metadata: 6 rows where bioproject = "PRJNA857143", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA857143", 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
16146695	16146695	PRJNA857143_S_NODE_37133_length_434_cov_6.066482_g36041_i0	PRJNA857143	37133	434	6.066482	26.32853188	Rozella allomycis CSF55	988480	Fungi	Fungi	198	1.52e-60	NR	EPZ34992.1	988480	g36041	i0	74.1	1.85253456221198	135	33	91.9	1	36	434	8	142	EPZ34992.1 60S ribosomal protein L5 [Rozella allomycis CSF55]	diamond	804	198	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
26770222	26770222	PRJNA857143_S_NODE_138641_length_276_cov_0.926108_g137548_i0	PRJNA857143	138641	276	0.926108	2.55605808	Rozella allomycis CSF55	988480	Fungi	Fungi	104	3.48e-25	NR	EPZ36552.1	988480	g137548	i0	50.6	0.967391304347826	89	44	96.7	0	8	274	159	247	EPZ36552.1 Tubulin binding cofactor C domain-containing protein [Rozella allomycis CSF55]	diamond	267	104	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28823287	28823287	PRJNA857143_S_NODE_25348_length_491_cov_8.112440_g24259_i0	PRJNA857143	25348	491	8.11244	39.8320804	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	72.4	8.19e-12	NR	PJF16516.1	1246581	g24259	i0	48.8	0.488798370672098	80	34	44.6	1	2	220	170	249	PJF16516.1 hypothetical protein PSACC_03723 [Paramicrosporidium saccamoebae]	diamond	240	72.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29897226	29897226	PRJNA857143_S_NODE_65731_length_362_cov_2.743945_g64638_i0	PRJNA857143	65731	362	2.743945	9.9330809	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	67.4	3.49e-10	NR	PJF19360.1	1246581	g64638	i0	47.7	0.538674033149171	65	33	53.9	1	96	290	236	299	PJF19360.1 hypothetical protein PSACC_00875 [Paramicrosporidium saccamoebae]	diamond	195	67.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32331705	32331705	PRJNA857143_S_NODE_69619_length_355_cov_2.489362_g68526_i0	PRJNA857143	69619	355	2.489362	8.8372351	Rozella allomycis CSF55	988480	Fungi	Fungi	68.2	1.13e-11	NR	RKP21351.1	988480	g68526	i0	40.3	0.650704225352113	77	39	60	2	311	99	59	134	RKP21351.1 hypothetical protein ROZALSC1DRAFT_11542 [Rozella allomycis CSF55]	diamond	231	68.2	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32867691	32867691	PRJNA857143_S_NODE_62580_length_368_cov_2.511864_g61487_i0	PRJNA857143	62580	368	2.511864	9.24365952	Rozella allomycis CSF55	988480	Fungi	Fungi	134	1.02e-36	NR	EPZ33870.1	988480	g61487	i0	66.7	10.491847826087	99	33	80.7	0	368	72	85	183	EPZ33870.1 60S ribosomal protein L13a [Rozella allomycis CSF55]	diamond	3861	134	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);;