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

5 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax_phylum = "Zoopagomycota"

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
312131	312131	PRJNA1166865_P_NODE_12361_length_607_cov_2.028090_g12127_i0	PRJNA1166865	12361	607	2.02809	12.3105063	Linderina pennispora	61395	Fungi	Fungi	250	1.99e-61	NTclustered	gi\|2028323432\|ref\|XM_040888084.1\|	61395	g12127	i0	78.723	36.2817133443163	376	78	62	2	224	598	1029	655	Linderina pennispora 40S ribosomal protein S5 (DL89DRAFT_268926), mRNA	blastn	22023	250	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
3590022	3590022	PRJNA1166865_P_NODE_12343_length_607_cov_8.426966_g12109_i0	PRJNA1166865	12343	607	8.426966	51.15168362	Eukaryota	2759	Fungi	Fungi	248	7.14e-61	NTclustered	gi\|2028319846\|ref\|XM_040887474.1\|	61395	g12109	i0	80.415	9.00329489291598	337	57	55	8	109	439	122	455	Linderina pennispora uncharacterized protein (DL89DRAFT_267368), mRNA	blastn	5465	250	0.992	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
4139124	4139124	PRJNA1166865_P_NODE_19224_length_490_cov_1.107914_g18983_i0	PRJNA1166865	19224	490	1.107914	5.4287786	Linderina pennispora	61395	Fungi	Fungi	252	4.39e-62	NTclustered	gi\|2028327618\|ref\|XM_040892304.1\|	61395	g18983	i0	78.571	11.2183673469388	392	76	79	8	101	488	893	506	Linderina pennispora uncharacterized protein (DL89DRAFT_97138), mRNA	blastn	5497	252	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
7417448	7417448	PRJNA1166865_P_NODE_29046_length_399_cov_2.527607_g28805_i0	PRJNA1166865	29046	399	2.527607	10.08515193	Fungi	4751	Fungi	Fungi	265	4.51e-66	NTclustered	gi\|2028315654\|ref\|XM_040889154.1\|	61395	g28805	i0	80.747	75.5989974937343	348	59	86	8	3	346	353	10	Linderina pennispora hsp71-like protein (DL89DRAFT_274197), partial mRNA	blastn	30164	265	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
10516475	10516475	PRJNA1166865_P_NODE_40669_length_342_cov_1.144981_g40428_i0	PRJNA1166865	40669	342	1.144981	3.91583502	Linderina pennispora	61395	Fungi	Fungi	95.3	5.3e-15	NTclustered	gi\|2028320758\|ref\|XM_040890372.1\|	61395	g40428	i0	84.946	4.90350877192982	93	14	27	0	250	342	416	324	Linderina pennispora Mal s 6 allergen (DL89DRAFT_293224), partial mRNA	blastn	1677	95.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora

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