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

4 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax_phylum = "Ascomycota"

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
18140376	18140376	PRJNA1145574_P_NODE_14535_length_243_cov_0.917647_g14351_i0	PRJNA1145574	14535	243	0.917647	2.22988221	Teratosphaeriaceae sp. CCFEE 6253	2901253	Fungi	Fungi	129	5.01e-34	NR	KAK3116487.1	2901253	g14351	i0	86.1	1.96296296296296	79	11	97.5	0	238	2	267	345	KAK3116487.1 hypothetical protein LTR53_003091 [Teratosphaeriaceae sp. CCFEE 6253]	diamond	477	129	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae		Teratosphaeriaceae sp. CCFEE 6253
29470207	29470207	PRJNA1145574_P_NODE_12030_length_250_cov_0.881356_g11846_i0	PRJNA1145574	12030	250	0.881356	2.20339	Cladosporium halotolerans	1052096	Fungi	Fungi	62.4	5.1e-9	NR	XP_069229049.1	1052096	g11846	i0	73.2	0.492	41	11	49.2	0	127	249	1267	1307	XP_069229049.1 uncharacterized protein WHR41_04738 [Cladosporium halotolerans]	diamond	123	62.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
30090894	30090894	PRJNA1145574_P_NODE_13912_length_245_cov_0.906977_g13728_i0	PRJNA1145574	13912	245	0.906977	2.22209365	Pleosporales	92860	Fungi	Fungi	81.6	7.12e-16	NR	KAH7083079.1	798071	g13728	i0	48.6	1.81224489795918	74	36	88.2	2	243	28	119	192	KAH7083079.1 heterokaryon incompatibility protein-domain-containing protein, partial [Paraphoma chrysanthemicola]	diamond	444	81.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae	Paraphoma	Paraphoma chrysanthemicola
32145920	32145920	PRJNA1145574_P_NODE_12838_length_248_cov_0.891429_g12654_i0	PRJNA1145574	12838	248	0.891429	2.21074392	Debaryomycetaceae	766764	Fungi	Fungi	67.4	8.06e-11	NR	XP_051619817.1	497108	g12654	i0	40	6.15725806451613	75	41	90.7	1	2	226	384	454	XP_051619817.1 DPL1 [Candida jiufengensis]	diamond	1527	67.8	0.994100294985251	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida jiufengensis

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