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

6 rows where analysis = "diamond", bioproject = "PRJNA685060" 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
27050669	27050669	PRJNA685060_P_NODE_2482_length_628_cov_1.360360_g2393_i0	PRJNA685060	2482	628	1.36036	8.5430608	Helicostylum pulchrum	562976	Fungi	Fungi	66.6	6.71e-9	NR	GAA5806006.1	562976	g2393	i0	40.2	0.535031847133758	112	59	53.5	3	604	269	1	104	GAA5806006.1 hypothetical protein HPULCUR_011534 [Helicostylum pulchrum]	diamond	336	66.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Helicostylum	Helicostylum pulchrum
27851778	27851778	PRJNA685060_P_NODE_12484_length_262_cov_1.465608_g12394_i0	PRJNA685060	12484	262	1.465608	3.83989296	Rhizophagus	295919	Fungi	Fungi	62	3.15e-9	NR	GBC08139.1	94130	g12394	i0	34.8	5.00381679389313	69	44	77.9	1	229	26	109	177	GBC08139.1 hypothetical protein RclHR1_07920014 [Rhizophagus clarus]	diamond	1311	62	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
30240218	30240218	PRJNA685060_P_NODE_12732_length_258_cov_2.362162_g12642_i0	PRJNA685060	12732	258	2.362162	6.09437796	Calcarisporiella thermophila	911321	Fungi	Fungi	47	0.00144	NR	XP_069247853.1	911321	g12642	i0	40.4	0.604651162790698	52	31	60.5	0	44	199	91	142	XP_069247853.1 uncharacterized protein VTP21DRAFT_5772 [Calcarisporiella thermophila]	diamond	156	47	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
30840542	30840542	PRJNA685060_P_NODE_6214_length_383_cov_1.974194_g6124_i0	PRJNA685060	6214	383	1.974194	7.56116302	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	43.1	0.044	NR	EXX62412.1	1432141	g6124	i0	30.2	1.56657963446475	96	63	72.1	2	73	348	39	134	EXX62412.1 hypothetical protein RirG_162000 [Rhizophagus irregularis DAOM 197198w]	diamond	600	43.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
30903781	30903781	PRJNA685060_P_NODE_8354_length_329_cov_1.136719_g8264_i0	PRJNA685060	8354	329	1.136719	3.73980551	Gamsiella multidivaricata	101098	Fungi	Fungi	57.4	7.31e-7	NR	KAG0362196.1	101098	g8264	i0	42.3	1.27659574468085	71	36	64.7	1	329	117	80	145	KAG0362196.1 hypothetical protein BGZ54_008717 [Gamsiella multidivaricata]	diamond	420	57.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
31093254	31093254	PRJNA685060_P_NODE_12215_length_266_cov_1.062176_g12125_i0	PRJNA685060	12215	266	1.062176	2.82538816	Cunninghamella echinulata	76405	Fungi	Fungi	65.9	3.33e-10	NR	KAI9303194.1	76405	g12125	i0	72.5	1.62406015037594	40	11	45.1	0	146	265	1	40	KAI9303194.1 tyrosyl-tRNA synthetase [Cunninghamella echinulata]	diamond	432	65.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata

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