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

4 rows where analysis = "diamond", bioproject = "PRJNA833575" 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
27749852	27749852	PRJNA833575_P_NODE_35424_length_247_cov_1.617978_g35287_i0	PRJNA833575	35424	247	1.617978	3.99640566	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	89	2.78e-19	NR	KAI9142824.1	1500003	g35287	i0	67.1	1.68825910931174	73	23	88.7	1	247	29	59	130	KAI9142824.1 50S ribosomal protein L30e-like protein [Paraphysoderma sedebokerense]	diamond	417	89	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
29810306	29810306	PRJNA833575_P_NODE_20931_length_323_cov_1.507874_g20794_i0	PRJNA833575	20931	323	1.507874	4.87043302	Fungi	4751	Fungi	Fungi	99.8	1.16e-24	NR	KAI9221706.1	64508	g20794	i0	66.7	4.70897832817337	75	24	69.7	1	248	24	6	79	KAI9221706.1 thioredoxin-like protein [Blastocladiella britannica]	diamond	1521	99.8	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
30781296	30781296	PRJNA833575_P_NODE_45734_length_227_cov_0.911392_g45597_i0	PRJNA833575	45734	227	0.911392	2.06885984	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	48.9	1.97e-4	NR	KAI9146521.1	1500003	g45597	i0	46.7	0.79295154185022	60	32	79.3	0	223	44	157	216	KAI9146521.1 Prp18 domain-containing protein [Paraphysoderma sedebokerense]	diamond	180	48.9	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
31887825	31887825	PRJNA833575_P_NODE_42077_length_231_cov_0.888889_g41940_i0	PRJNA833575	42077	231	0.888889	2.05333359	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	48.5	2.4e-4	NR	KAI9138585.1	1500003	g41940	i0	46	1.12987012987013	50	24	64.9	1	222	73	13	59	KAI9138585.1 hypothetical protein BKA69DRAFT_1090754 [Paraphysoderma sedebokerense]	diamond	261	48.5	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);;