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

6 rows where analysis = "diamond", bioproject = "PRJNA1134759" 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
14313115	14313115	PRJNA1134759_P_NODE_50152_length_251_cov_0.876404_g49976_i0	PRJNA1134759	50152	251	0.876404	2.19977404	Cladosporium halotolerans	1052096	Fungi	Fungi	154	1.58e-41	NR	XP_069228679.1	1052096	g49976	i0	88	0.99203187250996006	83	10	99.2	0	3	251	1	83	XP_069228679.1 Glutamate--cysteine ligase [Cladosporium halotolerans]	diamond	249	154	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
24510140	24510140	PRJNA1134759_P_NODE_53500_length_246_cov_0.901734_g53324_i0	PRJNA1134759	53500	246	0.901734	2.21826564	Mycosphaerellales	2726947	Fungi	Fungi	130	1.42e-33	NR	XP_016763528.1	692275	g53324	i0	77.5	6.90243902439024	80	18	97.6	0	3	242	76	155	XP_016763528.1 candidapepsin-4 precursor [Sphaerulina musiva SO2202]	diamond	1698	130	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Sphaerulina	Sphaerulina musiva
26817372	26817372	PRJNA1134759_P_NODE_57841_length_233_cov_2.350000_g57665_i0	PRJNA1134759	57841	233	2.35	5.4755	Venturia nashicola	86259	Fungi	Fungi	60.5	1.42e-8	NR	TLD11469.1	86259	g57665	i0	78.4	1.57081545064378	37	8	47.6	0	231	121	174	210	TLD11469.1 hypothetical protein E2P81_ATG10180 [Venturia nashicola]	diamond	366	60.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Venturiales	Venturiaceae	Venturia	Venturia nashicola
30153927	30153927	PRJNA1134759_P_NODE_54212_length_245_cov_0.906977_g54036_i0	PRJNA1134759	54212	245	0.906977	2.22209365	Teratosphaeriaceae	668547	Fungi	Fungi	43.5	0.0181	NR	KAK4541236.1	1507867	g54036	i0	91.3	0.844897959183673	23	2	28.2	0	3	71	230	252	KAK4541236.1 hypothetical protein LTR36_008152 [Oleoguttula mirabilis]	diamond	207	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Oleoguttula	Oleoguttula mirabilis
31050131	31050131	PRJNA1134759_P_NODE_9955_length_493_cov_3.638095_g9779_i0	PRJNA1134759	9955	493	3.638095	17.93580835	Cladosporium herbarum	29918	Fungi	Fungi	125	8.78e-34	NR	Q8NIN9.1	29918	g9779	i0	73.3	0.456389452332657	75	20	45.6	0	124	348	31	105	Q8NIN9.1 RecName: Full=Hydrophobin-1; AltName: Allergen=Cla h ?; Flags: Precursor [Cladosporium herbarum]	diamond	225	125	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium herbarum
32283629	32283629	PRJNA1134759_P_NODE_48819_length_253_cov_0.866667_g48643_i0	PRJNA1134759	48819	253	0.866667	2.19266751	Cladosporium halotolerans	1052096	Fungi	Fungi	57.4	2.91e-7	NR	XP_069226551.1	1052096	g48643	i0	66.2	0.770750988142292	65	17	73.5	3	3	188	1522	1584	XP_069226551.1 uncharacterized protein WHR41_07572 [Cladosporium halotolerans]	diamond	195	57.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans

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