metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA922890" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA922890" 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
4726252	4726252	PRJNA922890_P_NODE_26664_length_369_cov_1.226667_g26254_i0	PRJNA922890	26664	369	1.226667	4.52640123	Gilbertella persicaria	101096	Fungi	Fungi	302	3.15e-77	NTclustered	gi\|2323766513\|ref\|XM_051583483.1\|	101096	g26254	i0	82.535	102.016260162602	355	50	95	12	20	368	22	370	Gilbertella persicaria ubiquitin-60S ribosomal protein L40 (B0P05DRAFT_629030), mRNA	blastn	37644	302	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
4727221	4727221	PRJNA922890_P_NODE_80164_length_230_cov_0.894410_g79754_i0	PRJNA922890	80164	230	0.89441	2.057143	Gamsiella multidivaricata	101098	Fungi	Fungi	143	1.18e-29	NTclustered	gi\|2323771861\|ref\|XM_051554187.1\|	101098	g79754	i0	79.227	43.3260869565217	207	41	90	2	10	215	877	672	Gamsiella multidivaricata 14-3-3 domain-containing protein (BC939DRAFT_441198), mRNA	blastn	9965	143	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
18750161	18750161	PRJNA922890_P_NODE_72455_length_233_cov_1.701220_g72045_i0	PRJNA922890	72455	233	1.70122	3.9638426	Lichtheimia ornata	688661	Fungi	Fungi	132	2.6e-26	NTclustered	gi\|2553605659\|ref\|XM_058491849.1\|	688661	g72045	i0	78.302	9.64377682403433	212	41	89	4	1	208	554	764	Lichtheimia ornata ADP,ATP carrier protein, mitochondrial (O0I10_011890), partial mRNA	blastn	2247	132	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
21300136	21300136	PRJNA922890_P_NODE_47657_length_282_cov_1.976526_g47247_i0	PRJNA922890	47657	282	1.976526	5.57380332	Phycomyces blakesleeanus	4837	Fungi	Fungi	183	8.84e-42	NTclustered	gi\|1069959123\|ref\|XM_018429712.1\|	763407	g47247	i0	78.671	13.4397163120567	286	53	100	7	1	282	341	60	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	3790	183	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
22575098	22575098	PRJNA922890_P_NODE_44158_length_293_cov_1.125000_g43748_i0	PRJNA922890	44158	293	1.125	3.29625	Phycomyces blakesleeanus	4837	Fungi	Fungi	115	3.42e-21	NTclustered	gi\|1069954644\|ref\|XM_018439372.1\|	763407	g43748	i0	95.775	2.2901023890785	71	3	24	0	1	71	264	334	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein partial mRNA	blastn	671	115	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus

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