metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA692200" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA692200" 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
21075325	21075325	PRJNA692200_S_NODE_4157_length_307_cov_1427.116279_g4100_i0	PRJNA692200	4157	307	1427.116279	4381.24697653	Fungi	4751	Fungi	Fungi	106	2.63e-24	NR	KAL0140232.1	29924	g4100	i0	67.1	13.6807817589577	70	22	68.4	1	3	212	241	309	KAL0140232.1 protein phosphatase 2A [Mucor lusitanicus]	diamond	4200	106	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
27156752	27156752	PRJNA692200_S_NODE_14362_length_191_cov_2.387324_g14305_i0	PRJNA692200	14362	191	2.387324	4.55978884	Opisthokonta	33154	Fungi	Fungi	97.4	6.9e-22	NR	ORY97875.1	13706	g14305	i0	71	20.3403141361257	62	18	97.4	0	188	3	336	397	ORY97875.1 hypothetical protein BCR43DRAFT_438610 [Syncephalastrum racemosum]	diamond	3885	98.2	0.991853360488798	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
29146897	29146897	PRJNA692200_S_NODE_7909_length_245_cov_2.596939_g7852_i0	PRJNA692200	7909	245	2.596939	6.36250055	Mucorales	4827	Fungi	Fungi	64.3	4.98e-10	NR	XP_051378904.1	90255	g7852	i0	42	11.7551020408163	81	47	99.2	0	243	1	100	180	XP_051378904.1 40S ribosomal protein S1 [Cokeromyces recurvatus]	diamond	2880	64.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
29293037	29293037	PRJNA692200_S_NODE_16589_length_180_cov_1.587786_g16532_i0	PRJNA692200	16589	180	1.587786	2.8580148	Cunninghamella echinulata	76405	Fungi	Fungi	43.5	0.00866	NR	KAI9304575.1	76405	g16532	i0	42.5	1.11666666666667	40	23	66.7	0	175	56	1921	1960	KAI9304575.1 poly polymerase catalytic domain-containing protein [Cunninghamella echinulata]	diamond	201	43.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata
31611006	31611006	PRJNA692200_S_NODE_8136_length_242_cov_179.352332_g8079_i0	PRJNA692200	8136	242	179.352332	434.03264344	Mortierellaceae	4854	Fungi	Fungi	45.8	0.00299	NR	KAG0249275.1	41804	g8079	i0	41	0.966942148760331	39	23	48.3	0	19	135	114	152	KAG0249275.1 hypothetical protein BG011_009446 [Mortierella polycephala]	diamond	234	45.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella polycephala

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