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

5 rows where analysis = "blastn", bioproject = "PRJNA596870" 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
5672520	5672520	PRJNA596870_P_NODE_7845_length_443_cov_1.248649_g7712_i0	PRJNA596870	7845	443	1.248649	5.53151507	Gamsiella multidivaricata	101098	Fungi	Fungi	316	1.38e-81	NTclustered	gi\|2323774625\|ref\|XM_051561400.1\|	101098	g7712	i0	87.546	61.2595936794582	273	34	62	0	1	273	883	611	Gamsiella multidivaricata ribosomal protein S12/S23-domain-containing protein (BC939DRAFT_527136), partial mRNA	blastn	27138	316	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
7518268	7518268	PRJNA596870_P_NODE_19546_length_302_cov_1.222707_g19413_i0	PRJNA596870	19546	302	1.222707	3.69257514	Glomeromycetes	214506	Fungi	Fungi	204	7.34e-48	NTclustered	gi\|52626567\|emb\|AJ717308.1\|	4876	g19413	i0	79	44.7913907284768	300	61	99	2	4	302	842	544	Glomus intraradices partial atub gene for alpha-tubulin, exons 1-2	blastn	13527	204	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus intraradices
8221352	8221352	PRJNA596870_P_NODE_14727_length_340_cov_1.153558_g14594_i0	PRJNA596870	14727	340	1.153558	3.9220972	Umbelopsis ramanniana	41833	Fungi	Fungi	207	6.48e-49	NTclustered	gi\|2323685615\|ref\|XM_051587928.1\|	1314678	g14594	i0	82.627	43.5382352941176	236	39	69	2	106	340	554	320	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_234486), mRNA	blastn	14803	207	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
16443333	16443333	PRJNA596870_P_NODE_8873_length_420_cov_1.553314_g8740_i0	PRJNA596870	8873	420	1.553314	6.5239188	Fungi	4751	Fungi	Fungi	289	2.83e-73	NTclustered	gi\|2323770244\|ref\|XM_051552033.1\|	101098	g8740	i0	80.362	2.78809523809524	387	70	91	6	28	411	786	403	Gamsiella multidivaricata 6-phosphogluconate dehydrogenase (BC939DRAFT_392545), partial mRNA	blastn	1171	289	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
19694999	19694999	PRJNA596870_P_NODE_36776_length_244_cov_0.900585_g36643_i0	PRJNA596870	36776	244	0.900585	2.1974274	Rhizophagus irregularis	588596	Fungi	Fungi	139	1.64e-28	NTclustered	gi\|2749809531\|ref\|XM_025317930.2\|	588596	g36643	i0	85.185	2.88934426229508	135	20	55	0	110	244	308	442	Rhizophagus irregularis ADP-ribosylation factor Arf Arf6 (OCT59_010408), mRNA	blastn	705	139	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis

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