metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Blastocladiomycota"

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
16367873	16367873	PRJNA315314_S_NODE_26293_length_164_cov_1.688889_g25972_i0	PRJNA315314	26293	164	1.688889	2.76977796	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	60.8	4.93e-9	NR	KNE57402.1	578462	g25972	i0	55.6	0.98780487804878	54	23	98.8	1	164	3	257	309	KNE57402.1 hypothetical protein AMAG_03123 [Allomyces macrogynus ATCC 38327]	diamond	162	60.8	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
22057525	22057525	PRJNA315314_S_NODE_6058_length_328_cov_3.836120_g5737_i0	PRJNA315314	6058	328	3.83612	12.5824736	root	1	Root_unresolved	Root_unresolved	183	7.26e-53	NR	KAJ1506673.1	945690	g5737	i0	77.1	17.8536585365854	109	25	99.7	0	328	2	45	153	KAJ1506673.1 Protein kinase C-like 1 [Coelomomyces lativittatus]	diamond	5856	183	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Coelomomycetaceae	Coelomomyces	Coelomomyces lativittatus
30628738	30628738	PRJNA315314_S_NODE_15513_length_208_cov_2.301676_g15192_i0	PRJNA315314	15513	208	2.301676	4.78748608	Blastocladiales	4805	Fungi	Fungi	62.4	2.63e-10	NR	ORZ39709.1	765915	g15192	i0	49.3	3.95192307692308	69	35	99.5	0	208	2	38	106	ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171]	diamond	822	62.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
32129331	32129331	PRJNA315314_S_NODE_20458_length_183_cov_1.993506_g20137_i0	PRJNA315314	20458	183	1.993506	3.64811598	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	70.1	3.21e-12	NR	KAI9139905.1	1500003	g20137	i0	58.3	0.983606557377049	60	25	98.4	0	182	3	43	102	KAI9139905.1 acyl-CoA dehydrogenase/oxidase C-terminal [Paraphysoderma sedebokerense]	diamond	180	70.1	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense

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