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

6 rows where analysis = "diamond", bioproject = "PRJEB65099" 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
6508180	6508180	PRJEB65099_P_NODE_6306_length_245_cov_0.906977_g6201_i0	PRJEB65099	6306	245	0.906977	2.22209365	Dothideomycetes	147541	Fungi	Fungi	144	1.74e-40	NR	XP_069228530.1	1052096	g6201	i0	86.4	8.87755102040816	81	11	99.2	0	3	245	174	254	XP_069228530.1 uncharacterized protein WHR41_05639 [Cladosporium halotolerans]	diamond	2175	144	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
27033888	27033888	PRJEB65099_P_NODE_6282_length_245_cov_0.906977_g6177_i0	PRJEB65099	6282	245	0.906977	2.22209365	Ramularia collo-cygni	112498	Fungi	Fungi	142	2.66e-38	NR	XP_023622043.1	112498	g6177	i0	85.2	0.991836734693878	81	12	99.2	0	3	245	100	180	XP_023622043.1 related to oxidase [Ramularia collo-cygni]	diamond	243	142	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Ramularia	Ramularia collo-cygni
32215304	32215304	PRJEB65099_P_NODE_6458_length_244_cov_0.912281_g6353_i0	PRJEB65099	6458	244	0.912281	2.22596564	Neonectria magnoliae	2732573	Fungi	Fungi	43.9	0.0153	NR	KAK7426093.1	2732573	g6353	i0	38.6	1.02049180327869	83	43	99.6	4	243	1	65	141	KAK7426093.1 hypothetical protein QQZ08_007403 [Neonectria magnoliae]	diamond	249	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Neonectria	Neonectria magnoliae
32278711	32278711	PRJEB65099_P_NODE_5659_length_249_cov_0.886364_g5554_i0	PRJEB65099	5659	249	0.886364	2.20704636	Cladosporium halotolerans	1052096	Fungi	Fungi	128	1.77e-32	NR	XP_069233952.1	1052096	g5554	i0	78	0.987951807228916	82	18	98.8	0	3	248	61	142	XP_069233952.1 uncharacterized protein WHR41_00197 [Cladosporium halotolerans]	diamond	246	128	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
32468608	32468608	PRJEB65099_P_NODE_6139_length_246_cov_0.901734_g6034_i0	PRJEB65099	6139	246	0.901734	2.21826564	Aspergillus glaucus CBS 516.65	1160497	Fungi	Fungi	155	9.61e-42	NR	XP_022404618.1	1160497	g6034	i0	95.1	0.98780487804878	81	4	98.8	0	1	243	1204	1284	XP_022404618.1 uncharacterized protein ASPGLDRAFT_79637 [Aspergillus glaucus CBS 516.65]	diamond	243	155	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus glaucus
32689114	32689114	PRJEB65099_P_NODE_6440_length_244_cov_0.912281_g6335_i0	PRJEB65099	6440	244	0.912281	2.22596564	Acrodontium crateriforme	150365	Fungi	Fungi	130	1.7e-34	NR	WPH00996.1	150365	g6335	i0	82.7	0.995901639344262	81	14	99.6	0	243	1	202	282	WPH00996.1 mediator of rna polymerase ii transcription subunit 6 [Acrodontium crateriforme]	diamond	243	130	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Acrodontium	Acrodontium crateriforme

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