metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1174770" 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
6694248	6694248	PRJNA1174770_P_NODE_8526_length_168_cov_0.865546_g8437_i0	PRJNA1174770	8526	168	0.865546	1.45411728	Pleosporaceae	28556	Fungi	Fungi	79.3	1.28e-15	NR	XP_065965936.1	45151	g8437	i0	92.5	4.96428571428571	40	3	71.4	0	2	121	7	46	XP_065965936.1 hypothetical protein PtrM4_026720 [Pyrenophora tritici-repentis]	diamond	834	79.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Pyrenophora	Pyrenophora tritici-repentis
10519930	10519930	PRJNA1174770_P_NODE_6349_length_186_cov_1.357664_g6260_i0	PRJNA1174770	6349	186	1.357664	2.52525504	Cladosporium halotolerans	1052096	Fungi	Fungi	75.9	2.58e-14	NR	XP_069227632.1	1052096	g6260	i0	68.3	0.967741935483871	60	19	96.8	0	185	6	148	207	XP_069227632.1 uncharacterized protein WHR41_07081 [Cladosporium halotolerans]	diamond	180	75.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
26629014	26629014	PRJNA1174770_P_NODE_10921_length_164_cov_0.895652_g10832_i0	PRJNA1174770	10921	164	0.895652	1.46886928	Exophiala spinifera	91928	Fungi	Fungi	42	0.0244	NR	XP_016230830.1	91928	g10832	i0	45.5	0.804878048780488	44	24	80.5	0	154	23	1038	1081	XP_016230830.1 uncharacterized protein PV08_11578 [Exophiala spinifera]	diamond	132	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Exophiala	Exophiala spinifera
27754983	27754983	PRJNA1174770_P_NODE_12204_length_162_cov_0.911504_g12115_i0	PRJNA1174770	12204	162	0.911504	1.47663648	Hypocreales	5125	Fungi	Fungi	58.2	4.44e-8	NR	XP_018178140.2	33203	g12115	i0	60.4	6.14814814814815	53	20	98.1	1	161	3	218	269	XP_018178140.2 uncharacterized protein PLICBS_003176 [Purpureocillium lilacinum]	diamond	996	58.5	0.994871794871795	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium lilacinum
29144290	29144290	PRJNA1174770_P_NODE_11569_length_163_cov_0.903509_g11480_i0	PRJNA1174770	11569	163	0.903509	1.47271967	Didymosphaeriaceae	221678	Fungi	Fungi	99	1.92e-22	NR	KAF2451586.1	1392251	g11480	i0	92.5	13.6564417177914	53	4	97.5	0	3	161	790	842	KAF2451586.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Karstenula rhodostoma CBS 690.94]	diamond	2226	99	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymosphaeriaceae	Karstenula	Karstenula rhodostoma
30135058	30135058	PRJNA1174770_P_NODE_12352_length_162_cov_0.902655_g12263_i0	PRJNA1174770	12352	162	0.902655	1.4623011	Cladosporium halotolerans	1052096	Fungi	Fungi	89	6.6e-19	NR	XP_069231601.1	1052096	g12263	i0	81.1	0.981481481481482	53	10	98.1	0	162	4	118	170	XP_069231601.1 uncharacterized protein WHR41_02876 [Cladosporium halotolerans]	diamond	159	89	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
31589375	31589375	PRJNA1174770_P_NODE_6696_length_181_cov_2.068182_g6607_i0	PRJNA1174770	6696	181	2.068182	3.74340942	Hypoxylon rubiginosum	110542	Fungi	Fungi	109	4.29e-26	NR	KAI4865926.1	110542	g6607	i0	93.3	0.994475138121547	60	4	99.4	0	181	2	863	922	KAI4865926.1 nuclear protein 96-domain-containing protein [Hypoxylon rubiginosum]	diamond	180	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Hypoxylon	Hypoxylon rubiginosum
31652255	31652255	PRJNA1174770_P_NODE_5957_length_191_cov_1.387324_g5868_i0	PRJNA1174770	5957	191	1.387324	2.64978884	Xylariaceae sp. FL	1881983	Fungi	Fungi	83.2	1.05e-16	NR	KAI0483099.1	2663375	g5868	i0	65.4	3.47120418848168	52	18	81.7	0	190	35	789	840	KAI0483099.1 canalicular multispecific organic anion transporter 1 [Xylariaceae sp. FL0804]	diamond	663	83.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae		Xylariaceae sp. FL0804
31734702	31734702	PRJNA1174770_P_NODE_7957_length_169_cov_0.866667_g7868_i0	PRJNA1174770	7957	169	0.866667	1.46466723	Hypocreales	5125	Fungi	Fungi	90.9	1.52e-19	NR	KAK4070240.1	33203	g7868	i0	83.9	1.98816568047337	56	9	99.4	0	1	168	409	464	KAK4070240.1 hypothetical protein Purlil1_13536 [Purpureocillium lilacinum]	diamond	336	91.3	0.995618838992333	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium lilacinum
31778876	31778876	PRJNA1174770_P_NODE_9057_length_167_cov_0.872881_g8968_i0	PRJNA1174770	9057	167	0.872881	1.45771127	Cladosporium halotolerans	1052096	Fungi	Fungi	86.3	5.91e-18	NR	XP_069229693.1	1052096	g8968	i0	86.8	0.952095808383233	53	7	95.2	0	161	3	42	94	XP_069229693.1 uncharacterized protein WHR41_05321 [Cladosporium halotolerans]	diamond	159	86.3	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);;