metadata: contig_metadata: 5 rows where bioproject = "PRJNA600413", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA600413", tax_kingdom = "Fungi" and tax_phylum = "Mucoromycota"

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
1142656	1142656	PRJNA600413_P_NODE_85921_length_176_cov_1.606299_g85220_i0	PRJNA600413	85921	176	1.606299	2.82708624	Opisthokonta	33154	Fungi	Fungi	56.5	0.001	NTclustered	gi\|2324052519\|ref\|XM_051531099.1\|	90255	g85220	i0	94.595	0.715909090909091	37	1	20	1	30	65	839	803	Cokeromyces recurvatus Alpha/Beta hydrolase protein (BX663DRAFT_548763), partial mRNA	blastn	126	56.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
27237883	27237883	PRJNA600413_P_NODE_107223_length_167_cov_0.864407_g106522_i0	PRJNA600413	107223	167	0.864407	1.44355969	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	102	5.3999999999999985e-25	NR	EXX77063.1	1432141	g106522	i0	83.6	0.988023952095808	55	9	98.8	0	167	3	173	227	EXX77063.1 hypothetical protein RirG_027250 [Rhizophagus irregularis DAOM 197198w]	diamond	165	102	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
28514398	28514398	PRJNA600413_P_NODE_131107_length_163_cov_0.894737_g130406_i0	PRJNA600413	131107	163	0.894737	1.45842131	Mucorales	4827	Fungi	Fungi	61.6	2.65e-9	NR	ORZ02622.1	13706	g130406	i0	96.2	1.98773006134969	26	1	47.9	0	3	80	802	827	ORZ02622.1 SacI homology domain-domain-containing protein [Syncephalastrum racemosum]	diamond	324	61.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
29985172	29985172	PRJNA600413_P_NODE_150731_length_161_cov_0.910714_g150030_i0	PRJNA600413	150731	161	0.910714	1.46624954	Glomus cerebriforme	658196	Fungi	Fungi	42.7	0.0124	NR	RIA95452.1	658196	g150030	i0	39.5	5.49689440993789	43	26	80.1	0	148	20	358	400	RIA95452.1 hypothetical protein C1645_872777 [Glomus cerebriforme]	diamond	885	42.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus cerebriforme
32071409	32071409	PRJNA600413_P_NODE_135938_length_163_cov_0.894737_g135237_i0	PRJNA600413	135938	163	0.894737	1.45842131	Absidia repens	90262	Fungi	Fungi	63.9	4.21e-10	NR	ORZ10888.1	90262	g135237	i0	54.7	1.85889570552147	53	22	97.5	1	2	160	300	350	ORZ10888.1 kinase-like domain-containing protein [Absidia repens]	diamond	303	63.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia repens

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