metadata: contig_metadata: 7 rows where bioproject = "PRJNA285816", tax_clade = "Opisthokonta" and tax

7 rows where bioproject = "PRJNA285816", tax_clade = "Opisthokonta" 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
9300214	9300214	PRJNA285816_S_NODE_688_length_750_cov_24.213980_g626_i0	PRJNA285816	688	750	24.21398	181.60485	Eukaryota	2759	Fungi	Fungi	395	4.01e-137	NR	EPZ33659.1	988480	g626	i0	78	5.784	241	53	96.4	0	26	748	1	241	EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55]	diamond	4338	395	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
27295408	27295408	PRJNA285816_S_NODE_6143_length_281_cov_1.120690_g6041_i0	PRJNA285816	6143	281	1.12069	3.1491389	Rozella allomycis CSF55	988480	Fungi	Fungi	92	1.15e-19	NR	EPZ34508.1	988480	g6041	i0	64.5	1.32384341637011	62	22	66.2	0	281	96	304	365	EPZ34508.1 Vps4 oligomerisation domain-containing protein [Rozella allomycis CSF55]	diamond	372	92	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29884741	29884741	PRJNA285816_S_NODE_11971_length_216_cov_1.652695_g11869_i0	PRJNA285816	11971	216	1.652695	3.5698212	Rozella allomycis CSF55	988480	Fungi	Fungi	70.1	2.23e-12	NR	EPZ34986.1	988480	g11869	i0	47.9	0.986111111111111	71	36	98.6	1	2	214	56	125	EPZ34986.1 hypothetical protein O9G_005594 [Rozella allomycis CSF55]	diamond	213	70.1	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30800716	30800716	PRJNA285816_S_NODE_5314_length_299_cov_2.088000_g5212_i0	PRJNA285816	5314	299	2.088	6.24312	Rozella allomycis CSF55	988480	Fungi	Fungi	62.4	8.46e-9	NR	RKP17874.1	988480	g5212	i0	33.3	0.993311036789298	99	65	99.3	1	3	299	107	204	RKP17874.1 cytochrome P450, partial [Rozella allomycis CSF55]	diamond	297	62.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
31179656	31179656	PRJNA285816_S_NODE_655_length_766_cov_4.101813_g594_i0	PRJNA285816	655	766	4.101813	31.41988758	Rozella allomycis CSF55	988480	Fungi	Fungi	303	9.939999999999998e-101	NR	EPZ35724.1	988480	g594	i0	67.8	1.64490861618799	211	68	82.6	0	56	688	18	228	EPZ35724.1 Adenylate kinase [Rozella allomycis CSF55]	diamond	1260	303	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32603403	32603403	PRJNA285816_S_NODE_6540_length_273_cov_3.504464_g6438_i0	PRJNA285816	6540	273	3.504464	9.56718672	Rozella allomycis CSF55	988480	Fungi	Fungi	115	5.27e-28	NR	EPZ31141.1	988480	g6438	i0	72.6	2.61538461538462	84	18	92.3	2	252	1	3	81	EPZ31141.1 V-type proton ATPase subunit B [Rozella allomycis CSF55]	diamond	714	115	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32792076	32792076	PRJNA285816_S_NODE_5300_length_299_cov_4.092000_g5198_i0	PRJNA285816	5300	299	4.092	12.23508	Rozella allomycis CSF55	988480	Fungi	Fungi	90.1	1.64e-18	NR	EPZ32472.1	988480	g5198	i0	49.5	0.973244147157191	97	46	97.3	1	293	3	551	644	EPZ32472.1 Propionyl-CoA carboxylase alpha chain, mitochondrial [Rozella allomycis CSF55]	diamond	291	90.1	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);;