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

6 rows where analysis = "diamond", bioproject = "PRJNA1040136" 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
6547781	6547781	PRJNA1040136_S_NODE_2506_length_246_cov_0.890173_g2503_i0	PRJNA1040136	2506	246	0.890173	2.18982558	Agaricomycetes	155619	Fungi	Fungi	93.6	4.85e-20	NR	XP_007385161.1	741275	g2503	i0	71.4	2.30487804878049	63	18	76.8	0	245	57	577	639	XP_007385161.1 succinate dehydrogenase [Punctularia strigosozonata HHB-11173 SS5]	diamond	567	94.4	0.991525423728813	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Corticiales	Punctulariaceae	Punctularia	Punctularia strigosozonata
7822344	7822344	PRJNA1040136_S_NODE_1287_length_298_cov_3.702222_g1284_i0	PRJNA1040136	1287	298	3.702222	11.03262156	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	73.2	8.55e-15	NR	EXX72692.1	1432141	g1284	i0	71.2	1.22818791946309	52	15	52.3	0	296	141	1	52	EXX72692.1 ribosomal 60S subunit protein L29 [Rhizophagus irregularis DAOM 197198w]	diamond	366	73.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
21846684	21846684	PRJNA1040136_S_NODE_2198_length_254_cov_1.690608_g2195_i0	PRJNA1040136	2198	254	1.6906080000000001	4.29414432	Opisthokonta	33154	Fungi	Fungi	87	1.11e-17	NR	KAJ3204786.1	109932	g2195	i0	64.1	3.56692913385827	78	26	89.8	1	2	229	45	122	KAJ3204786.1 60S ribosomal protein L34 [Entophlyctis luteolus]	diamond	906	87.8	0.990888382687927	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis luteolus
29182782	29182782	PRJNA1040136_S_NODE_1349_length_295_cov_1.581081_g1346_i0	PRJNA1040136	1349	295	1.581081	4.66418895	Pilaira anomala	64641	Fungi	Fungi	104	2.52e-26	NR	KAI9348827.1	64641	g1346	i0	71.2	0.671186440677966	66	19	67.1	0	1	198	58	123	KAI9348827.1 profilin [Pilaira anomala]	diamond	198	104	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Pilaira	Pilaira anomala
31299092	31299092	PRJNA1040136_S_NODE_775_length_347_cov_1.124088_g772_i0	PRJNA1040136	775	347	1.124088	3.90058536	Meyerozyma sp. JA9	2028340	Fungi	Fungi	53.5	3.53e-6	NR	RLV83189.1	2028340	g772	i0	54	0.873198847262248	50	23	43.2	0	11	160	85	134	RLV83189.1 60S ribosomal protein L14-B [Meyerozyma sp. JA9]	diamond	303	53.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma sp. JA9
31860249	31860249	PRJNA1040136_S_NODE_1837_length_269_cov_1.040816_g1834_i0	PRJNA1040136	1837	269	1.040816	2.79979504	Chytriomycetaceae	1352827	Fungi	Fungi	65.1	6.56e-10	NR	KAJ3025000.1	2723227	g1834	i0	78.8	2.91078066914498	33	7	36.8	0	2	100	382	414	KAJ3025000.1 hypothetical protein HDU68_007572 [Siphonaria sp. JEL0065]	diamond	783	65.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Siphonaria	Siphonaria sp. JEL0065

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