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

4 rows where analysis = "diamond", bioproject = "PRJNA983848" 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
28289517	28289517	PRJNA983848_P_NODE_120866_length_272_cov_2.085427_g114983_i0	PRJNA983848	120866	272	2.085427	5.67236144	Cetraspora pellucida	1433469	Fungi	Fungi	47	0.00169	NR	CAG8512328.1	1433469	g114983	i0	37.7	0.672794117647059	61	38	67.3	0	186	4	434	494	CAG8512328.1 11995_t:CDS:10, partial [Cetraspora pellucida]	diamond	183	47	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Cetraspora	Cetraspora pellucida
29305944	29305944	PRJNA983848_P_NODE_118569_length_275_cov_1.970297_g112686_i0	PRJNA983848	118569	275	1.970297	5.41831675	Eukaryota	2759	Fungi	Fungi	98.6	1.27e-21	NR	KAG9298759.1	50956	g112686	i0	58.9	5.89090909090909	90	34	98.2	2	271	2	528	614	KAG9298759.1 hypothetical protein G9A89_012827 [Geosiphon pyriformis]	diamond	1620	98.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
31194995	31194995	PRJNA983848_P_NODE_93515_length_315_cov_1.289256_g87632_i0	PRJNA983848	93515	315	1.289256	4.0611564	Mortierella alpina	64518	Fungi	Fungi	89	5.25e-18	NR	KAG9320329.1	64518	g87632	i0	55.6	3.41904761904762	72	29	68.6	1	313	98	178	246	KAG9320329.1 hypothetical protein KVV02_008174 [Mortierella alpina]	diamond	1077	89	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella alpina
32750654	32750654	PRJNA983848_P_NODE_96180_length_310_cov_1.316456_g90297_i0	PRJNA983848	96180	310	1.316456	4.0810136	Mucoromycota	1913637	Fungi	Fungi	103	1.09e-24	NR	KAF9404093.1	979699	g90297	i0	62.5	5.02258064516129	72	27	69.7	0	218	3	1	72	KAF9404093.1 Eukaryotic translation initiation factor 6 [Podila epigama]	diamond	1557	103	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila epigama

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