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

8 rows where analysis = "diamond", bioproject = "PRJNA229468" 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
2331837	2331837	PRJNA229468_S_NODE_722_length_193_cov_2.777778_g709_i0	PRJNA229468	722	193	2.777778	5.36111154	Eukaryota	2759	Fungi	Fungi	90.1	1.72e-19	NR	KAH6661833.1	394676	g709	i0	62.9	8.48704663212435	62	23	96.4	0	188	3	136	197	KAH6661833.1 putative zinc-binding alcohol dehydrogenase [Halenospora varia]	diamond	1638	90.9	0.991199119911991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Tricladiaceae	Halenospora	Halenospora varia
8020690	8020690	PRJNA229468_S_NODE_527_length_219_cov_1.200000_g514_i0	PRJNA229468	527	219	1.2	2.628	Pneumocystis	4753	Fungi	Fungi	70.1	3.79e-13	NR	CCJ30885.1	42068	g514	i0	80	60.7534246575342	40	8	54.8	0	120	1	31	70	CCJ30885.1 unnamed protein product [Pneumocystis jirovecii]	diamond	13305	70.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis jirovecii
24008527	24008527	PRJNA229468_S_NODE_759_length_189_cov_1.457143_g746_i0	PRJNA229468	759	189	1.457143	2.75400027	Eukaryota	2759	Fungi	Fungi	110	4.07e-28	NR	KAI9781418.1	315204	g746	i0	80.6	12.7936507936508	62	12	98.4	0	188	3	143	204	KAI9781418.1 MAG: 60S ribosomal protein L11 [Geoglossum umbratile]	diamond	2418	111	0.990990990990991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Geoglossomycetes	Geoglossales	Geoglossaceae	Geoglossum	Geoglossum umbratile
27516350	27516350	PRJNA229468_S_NODE_283_length_295_cov_2.174797_g270_i0	PRJNA229468	283	295	2.174797	6.41565115	Parachaetomium inaequale	2588326	Fungi	Fungi	89.4	5.32e-20	NR	KAK4040879.1	2588326	g270	i0	46.9	1.95254237288136	96	46	97.6	1	6	293	72	162	KAK4040879.1 Mss4-like protein [Parachaetomium inaequale]	diamond	576	89.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Chaetomiaceae	Parachaetomium	Parachaetomium inaequale
27611200	27611200	PRJNA229468_S_NODE_1224_length_162_cov_0.902655_g1211_i0	PRJNA229468	1224	162	0.902655	1.4623011	Saccharomycopsis crataegensis	43959	Fungi	Fungi	49.7	4.54e-5	NR	XP_064855757.1	43959	g1211	i0	72.7	0.611111111111111	33	9	61.1	0	162	64	194	226	XP_064855757.1 glutamate--cysteine ligase [Saccharomycopsis crataegensis]	diamond	99	49.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Saccharomycopsidaceae	Saccharomycopsis	Saccharomycopsis crataegensis
28274006	28274006	PRJNA229468_S_NODE_1146_length_164_cov_1.330435_g1133_i0	PRJNA229468	1146	164	1.330435	2.1819134	Aspergillus terreus NIH2624	341663	Fungi	Fungi	67	3.09e-11	NR	XP_001216521.1	341663	g1133	i0	64.2	2.92682926829268	53	19	97	0	5	163	289	341	XP_001216521.1 uncharacterized protein ATEG_07900 [Aspergillus terreus NIH2624]	diamond	480	67	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus terreus
31654045	31654045	PRJNA229468_S_NODE_537_length_216_cov_1.221557_g524_i0	PRJNA229468	537	216	1.221557	2.63856312	Pneumocystis oryctolagi	42067	Fungi	Fungi	80.1	4.7e-16	NR	KAG4306012.1	42067	g524	i0	59	2.54166666666667	61	25	84.7	0	26	208	126	186	KAG4306012.1 hypothetical protein PORY_000922 [Pneumocystis oryctolagi]	diamond	549	80.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis oryctolagi
32526588	32526588	PRJNA229468_S_NODE_699_length_196_cov_1.687075_g686_i0	PRJNA229468	699	196	1.687075	3.306667	Ascomycota	4890	Fungi	Fungi	50.8	1.03e-5	NR	KAK0384808.1	5046	g686	i0	38.5	5.60204081632653	65	39	99.5	1	196	2	12	75	KAK0384808.1 hypothetical protein NLU13_7286 [Sarocladium strictum]	diamond	1098	50.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum

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