metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA930380" 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
14937272	14937272	PRJNA930380_P_NODE_12952_length_246_cov_0.890173_g12899_i0	PRJNA930380	12952	246	0.890173	2.18982558	Podosphaera aphanis	79252	Fungi	Fungi	170	8.62e-51	NR	KAI1000974.1	79252	g12899	i0	100	0.98780487804878	81	0	98.8	0	3	245	92	172	KAI1000974.1 F-actin-capping protein subunit beta [Podosphaera aphanis]	diamond	243	170	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Podosphaera	Podosphaera aphanis
27088273	27088273	PRJNA930380_P_NODE_9482_length_274_cov_1.532338_g9429_i0	PRJNA930380	9482	274	1.532338	4.19860612	Trichophyton interdigitale H6	1215336	Fungi	Fungi	43.1	0.0375	NR	EZF32639.1	1215336	g9429	i0	44	0.547445255474453	50	25	54.7	1	82	231	91	137	EZF32639.1 hypothetical protein H101_03765 [Trichophyton interdigitale H6]	diamond	150	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Onygenales	Arthrodermataceae	Trichophyton	Trichophyton interdigitale
28635841	28635841	PRJNA930380_P_NODE_12727_length_247_cov_0.885057_g12674_i0	PRJNA930380	12727	247	0.885057	2.18609079	Emericellopsis atlantica	2614577	Fungi	Fungi	113	1.02e-27	NR	XP_046115883.1	2614577	g12674	i0	79.1	0.813765182186235	67	14	81.4	0	202	2	1	67	XP_046115883.1 uncharacterized protein F5Z01DRAFT_682998 [Emericellopsis atlantica]	diamond	201	113	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Emericellopsis	Emericellopsis atlantica
29298690	29298690	PRJNA930380_P_NODE_12889_length_246_cov_0.890173_g12836_i0	PRJNA930380	12889	246	0.890173	2.18982558	Watsoniomyces obsoletus	2796175	Fungi	Fungi	167	2.0499999999999998e-47	NR	KAI9885714.1	2796175	g12836	i0	92.6	0.98780487804878	81	6	98.8	0	245	3	351	431	KAI9885714.1 MAG: hypothetical protein M1823_002479 [Watsoniomyces obsoletus]	diamond	243	167	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lichinomycetes	Lichinales	Porocyphaceae	Watsoniomyces	Watsoniomyces obsoletus
30498921	30498921	PRJNA930380_P_NODE_11393_length_251_cov_0.865169_g11340_i0	PRJNA930380	11393	251	0.865169	2.17157419	Sarocladium strictum	5046	Fungi	Fungi	147	5.08e-41	NR	KAK0383465.1	5046	g11340	i0	85.9	1.01593625498008	85	10	99.2	1	251	3	90	174	KAK0383465.1 hypothetical protein NLU13_9376 [Sarocladium strictum]	diamond	255	147	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
32396182	32396182	PRJNA930380_P_NODE_13399_length_244_cov_0.900585_g13346_i0	PRJNA930380	13399	244	0.900585	2.1974274	Podospora didyma	330526	Fungi	Fungi	43.9	0.0137	NR	KAK3394802.1	330526	g13346	i0	37.5	0.688524590163934	56	35	68.9	0	236	69	110	165	KAK3394802.1 UbiA prenyltransferase family-domain-containing protein [Podospora didyma]	diamond	168	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Podosporaceae	Podospora	Podospora didyma

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