metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax_phylum = "Basidiomycota"

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
645848	645848	PRJNA675042_P_NODE_120861_length_249_cov_0.875000_g120411_i0	PRJNA675042	120861	249	0.875	2.17875	Tricholomella constricta	117010	Fungi	Fungi	138	8.199999999999999e-36	NR	KAF5386610.1	117010	g120411	i0	91.7	1.81927710843373	72	6	86.7	0	217	2	70	141	KAF5386610.1 hypothetical protein D9615_001930 [Tricholomella constricta]	diamond	453	138	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Tricholomella	Tricholomella constricta
26828851	26828851	PRJNA675042_P_NODE_181941_length_229_cov_4.141026_g181491_i0	PRJNA675042	181941	229	4.141026	9.48294954	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	60.1	1.3e-8	NR	XP_007308664.1	721885	g181491	i0	61.5	0.681222707423581	52	18	68.1	1	55	210	6	55	XP_007308664.1 ICMT-domain-containing protein [Stereum hirsutum FP-91666 SS1]	diamond	156	60.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
27144686	27144686	PRJNA675042_P_NODE_38042_length_349_cov_0.811594_g37592_i0	PRJNA675042	38042	349	0.811594	2.83246306	Polyporus grammocephalus	196234	Fungi	Fungi	41.2	0.049	NR	ACT52857.1	196234	g37592	i0	51.2	0.369627507163324	43	21	37	0	86	214	12	54	ACT52857.1 retrotransposon protein, partial [Polyporus grammocephalus]	diamond	129	41.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Polyporus	Polyporus grammocephalus
29797437	29797437	PRJNA675042_P_NODE_29151_length_375_cov_4.033113_g28701_i0	PRJNA675042	29151	375	4.033113	15.12417375	Malassezia restricta	76775	Fungi	Fungi	116	3.1199999999999997e-31	NR	XP_027485477.1	76775	g28701	i0	70.7	1.192	75	18	56.8	1	280	68	6	80	XP_027485477.1 NADH-ubiquinone oxidoreductase 9.5 kDa subunit [Malassezia restricta]	diamond	447	116	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta

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