metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA450343" 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
15741722	15741722	PRJNA450343_P_NODE_7573_length_196_cov_1.387755_g7505_i0	PRJNA450343	7573	196	1.387755	2.7199998	Orbilia brochopaga	3140254	Fungi	Fungi	102	1.1e-26	NR	KAF3921331.1	3140254	g7505	i0	74.6	3.9030612244898	63	16	96.4	0	189	1	18	80	KAF3921331.1 Triakontatetraneuropeptide [Orbilia brochopaga]	diamond	765	102	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Orbilia	Orbilia brochopaga
27945207	27945207	PRJNA450343_P_NODE_5265_length_231_cov_1.681319_g5197_i0	PRJNA450343	5265	231	1.681319	3.88384689	Botryosphaeriales	451869	Fungi	Fungi	103	2.0199999999999998e-24	NR	OMP84831.1	420778	g5197	i0	60	5.84415584415584	75	30	97.4	0	225	1	1	75	OMP84831.1 Guanine nucleotide-binding protein subunit beta-like protein, partial [Diplodia seriata]	diamond	1350	103	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Botryosphaeriales	Botryosphaeriaceae	Diplodia	Diplodia seriata
28134754	28134754	PRJNA450343_P_NODE_5165_length_233_cov_2.586957_g5097_i0	PRJNA450343	5165	233	2.586957	6.02760981	Eukaryota	2759	Fungi	Fungi	92.8	1.13e-22	NR	XP_047761105.1	5499	g5097	i0	66.2	13.9957081545064	68	23	87.6	0	217	14	1	68	XP_047761105.1 60S ribosomal protein L38 [Fulvia fulva]	diamond	3261	93.6	0.991452991452991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Fulvia	Fulvia fulva
29018973	29018973	PRJNA450343_P_NODE_4008_length_266_cov_0.930876_g3940_i0	PRJNA450343	4008	266	0.930876	2.47613016	Opisthokonta	33154	Fungi	Fungi	63.5	1.05e-10	NR	KAJ5740150.1	1324776	g3940	i0	54.4	3.5187969924812	57	26	64.3	0	76	246	6	62	KAJ5740150.1 Thioredoxin [Penicillium malachiteum]	diamond	936	63.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium malachiteum
29334418	29334418	PRJNA450343_P_NODE_7989_length_191_cov_1.880282_g7921_i0	PRJNA450343	7989	191	1.880282	3.59133862	Sordariomycetes	147550	Fungi	Fungi	80.9	2.2e-18	NR	KAH7367311.1	40658	g7921	i0	58.7	15.8167539267016	63	26	99	0	3	191	2	64	KAH7367311.1 hypothetical protein B0T11DRAFT_221777, partial [Plectosphaerella cucumerina]	diamond	3021	81.6	0.991421568627451	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Plectosphaerellaceae	Plectosphaerella	Plectosphaerella cucumerina
30186995	30186995	PRJNA450343_P_NODE_5432_length_228_cov_1.139665_g5364_i0	PRJNA450343	5432	228	1.139665	2.5984362	Fungi	4751	Fungi	Fungi	81.3	8.51e-16	NR	KAF3925796.1	47266	g5364	i0	59.7	12.5921052631579	67	26	88.2	1	228	28	327	392	KAF3925796.1 hypothetical protein ABW20_dc0101935 [Dactylellina cionopaga]	diamond	2871	81.6	0.996323529411765	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Dactylellina	Dactylellina cionopaga
31118475	31118475	PRJNA450343_P_NODE_12215_length_164_cov_0.886957_g12147_i0	PRJNA450343	12215	164	0.886957	1.45460948	Aspergillus glaucus CBS 516.65	1160497	Fungi	Fungi	62	1.98e-9	NR	XP_022395580.1	1160497	g12147	i0	77.8	0.658536585365854	36	8	65.9	0	3	110	108	143	XP_022395580.1 uncharacterized protein ASPGLDRAFT_62203 [Aspergillus glaucus CBS 516.65]	diamond	108	62	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus glaucus
32699634	32699634	PRJNA450343_P_NODE_10180_length_170_cov_1.685950_g10112_i0	PRJNA450343	10180	170	1.68595	2.866115	Maudiozyma barnettii	61262	Fungi	Fungi	64.7	6.37e-12	NR	XP_041408628.1	61262	g10112	i0	63	0.811764705882353	46	17	81.2	0	4	141	37	82	XP_041408628.1 long-chain fatty acid transporter ACB1 [Maudiozyma barnettii]	diamond	138	64.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Maudiozyma	Maudiozyma barnettii

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