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

10 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_kingdom = "Fungi"

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
27895301	27895301	PRJNA287283_P_NODE_10425_length_175_cov_0.918033_g10201_i0	PRJNA287283	10425	175	0.918033	1.60655775	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	67.8	2.18e-11	NR	KAH9254411.1	1357716	g10201	i0	55.2	1.98857142857143	58	25	99.4	1	174	1	220	276	KAH9254411.1 protein disulfide-isomerase domain [Batrachochytrium salamandrivorans]	diamond	348	67.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
29428354	29428354	PRJNA287283_P_NODE_8589_length_183_cov_0.861538_g8365_i0	PRJNA287283	8589	183	0.861538	1.57661454	Wallemia	148959	Fungi	Fungi	41.6	0.045	NR	TIA77982.1	245174	g8365	i0	41.4	1.90163934426229	58	33	95.1	1	183	10	328	384	TIA77982.1 hypothetical protein E3P98_04025 [Wallemia ichthyophaga]	diamond	348	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Wallemiomycetes	Wallemiales	Wallemiaceae	Wallemia	Wallemia ichthyophaga
29442284	29442284	PRJNA287283_P_NODE_7890_length_191_cov_1.130435_g7666_i0	PRJNA287283	7890	191	1.130435	2.15913085	Phlyctochytrium planicorne	261098	Fungi	Fungi	43.5	0.01	NR	KAJ3095680.1	261098	g7666	i0	40.5	0.659685863874346	42	25	66	0	165	40	149	190	KAJ3095680.1 hypothetical protein HDU97_006613 [Phlyctochytrium planicorne]	diamond	126	43.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium planicorne
29663197	29663197	PRJNA287283_P_NODE_10390_length_175_cov_0.918033_g10166_i0	PRJNA287283	10390	175	0.918033	1.60655775	Epicoccum nigrum	105696	Fungi	Fungi	66.2	7.75e-11	NR	KAG9196832.1	105696	g10166	i0	56.1	1.95428571428571	57	25	97.7	0	174	4	822	878	KAG9196832.1 hypothetical protein G6514_003939 [Epicoccum nigrum]	diamond	342	66.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Epicoccum	Epicoccum nigrum
29775788	29775788	PRJNA287283_P_NODE_6091_length_234_cov_0.977901_g5867_i0	PRJNA287283	6091	234	0.977901	2.28828834	Agaricomycetes	155619	Fungi	Fungi	114	1.6e-27	NR	KAH9850839.1	5632	g5867	i0	74	2.96153846153846	77	18	98.7	1	2	232	275	349	KAH9850839.1 glycosyl hydrolase family 7-domain-containing protein [Lenzites betulinus]	diamond	693	115	0.991304347826087	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lenzites	Lenzites betulinus
30074010	30074010	PRJNA287283_P_NODE_8572_length_183_cov_0.861538_g8348_i0	PRJNA287283	8572	183	0.861538	1.57661454	Penicillium macrosclerotiorum	303699	Fungi	Fungi	43.9	0.00144	NR	XP_056932175.1	303699	g8348	i0	43.6	1.68852459016393	55	25	90.2	1	182	18	13	61	XP_056932175.1 uncharacterized protein N7462_007787 [Penicillium macrosclerotiorum]	diamond	309	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium macrosclerotiorum
30218104	30218104	PRJNA287283_P_NODE_10412_length_175_cov_0.918033_g10188_i0	PRJNA287283	10412	175	0.918033	1.60655775	Cordycipitaceae	474943	Fungi	Fungi	56.6	1.57e-7	NR	KAJ6782909.1	12942	g10188	i0	73.5	4.04571428571429	34	9	58.3	0	37	138	245	278	KAJ6782909.1 hypothetical protein PWT90_04898 [Aphanocladium album]	diamond	708	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales		Aphanocladium	Aphanocladium album
31116560	31116560	PRJNA287283_P_NODE_6675_length_217_cov_1.024390_g6451_i0	PRJNA287283	6675	217	1.02439	2.2229263	Chytriomyces sp. MP71	1882861	Fungi	Fungi	62	3.99e-9	NR	KAI8616402.1	1882861	g6451	i0	41.7	0.995391705069124	72	41	99.5	1	2	217	161	231	KAI8616402.1 hypothetical protein BC830DRAFT_1118160 [Chytriomyces sp. MP71]	diamond	216	62	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces sp. MP71
31685896	31685896	PRJNA287283_P_NODE_9437_length_179_cov_0.888889_g9213_i0	PRJNA287283	9437	179	0.888889	1.59111131	Linnemannia zychae	979765	Fungi	Fungi	55.1	6.97e-7	NR	KAF9901566.1	979765	g9213	i0	50.9	3.75418994413408	55	26	90.5	1	169	8	384	438	KAF9901566.1 hypothetical protein EC991_006014 [Linnemannia zychae]	diamond	672	55.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Linnemannia	Linnemannia zychae
32823811	32823811	PRJNA287283_P_NODE_5980_length_237_cov_0.847826_g5756_i0	PRJNA287283	5980	237	0.847826	2.00934762	Polyplosphaeria fusca	682080	Fungi	Fungi	45.1	0.0033	NR	KAF2736442.1	682080	g5756	i0	52.9	0.645569620253165	51	19	64.6	2	61	213	121	166	KAF2736442.1 hypothetical protein EJ04DRAFT_159750 [Polyplosphaeria fusca]	diamond	153	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Tetraplosphaeriaceae	Polyplosphaeria	Polyplosphaeria fusca

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