metadata: contig_metadata: 5 rows where bioproject = "PRJNA1095825", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA1095825", tax_kingdom = "Fungi" and tax_phylum = "Chytridiomycota"

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_class	tax_order	tax_family	tax_genus	tax_species
5302356	5302356	PRJNA1095825_P_NODE_100285_length_380_cov_1.459283_g97222_i0	PRJNA1095825	100285	380	1.459283	5.5452754	Polychytrium aggregatum	110093	Fungi	Fungi	62.1	6.02e-5	NTclustered	gi\|2432167402\|ref\|XM_053106443.1\|	110093	g97222	i0	100	0.160526315789474	33	0	9	0	330	362	531	563	Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_217064), mRNA	blastn	61	62.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
13772783	13772783	PRJNA1095825_P_NODE_199491_length_277_cov_1.161765_g196428_i0	PRJNA1095825	199491	277	1.161765	3.21808905	Fimicolochytrium	1396492	Fungi	Fungi	486	5.9e-133	NTclustered	gi\|1866582573\|gb\|MT730748.1\|	1396493	g196428	i0	98.551	99.6895306859206	276	3	99	1	3	277	4415	4140	Fimicolochytrium jonesii isolate JEL0569 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	27614	486	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
27762880	27762880	PRJNA1095825_P_NODE_4504_length_2852_cov_7.066931_g3584_i0	PRJNA1095825	4504	2852	7.066931	201.54887212	Powellomyces hirtus	109895	Fungi	Fungi	64.7	1.38e-6	NR	QCQ69130.1	109895	g3584	i0	35.9	0.108345021037868	103	62	10.6	3	1214	912	277	377	QCQ69130.1 RNA-dependent DNA polymerase [Powellomyces hirtus]	diamond	309	64.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus
29593488	29593488	PRJNA1095825_P_NODE_240770_length_250_cov_1.740113_g237707_i0	PRJNA1095825	240770	250	1.740113	4.3502825	Lobulomyces angularis	109889	Fungi	Fungi	42.7	0.0407	NR	KAJ3387467.1	109889	g237707	i0	39.4	0.792	66	33	72	3	225	46	420	484	KAJ3387467.1 hypothetical protein HDU92_001936 [Lobulomyces angularis]	diamond	198	42.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Lobulomycetales	Lobulomycetaceae	Lobulomyces	Lobulomyces angularis
31078848	31078848	PRJNA1095825_P_NODE_70015_length_452_cov_3.472296_g66952_i0	PRJNA1095825	70015	452	3.472296	15.69477792	Chytridium lagenaria	64509	Fungi	Fungi	135	9.75e-38	NR	KAI8853126.1	64509	g66952	i0	47.8	1.67920353982301	136	70	90.3	1	29	436	5	139	KAI8853126.1 40S ribosomal protein S19-A [Chytridium lagenaria]	diamond	759	135	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Chytridium	Chytridium lagenaria

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