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

5 rows where analysis = "blastn", bioproject = "PRJNA940501" 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
4749578	4749578	PRJNA940501_S_NODE_389184_length_151_cov_1.250000_g388366_i0	PRJNA940501	389184	151	1.25	1.8875	Kickxella alabastrina	61397	Fungi	Fungi	76.8	7.31e-10	NTclustered	gi\|2324008204\|ref\|XM_051539520.1\|	61397	g388366	i0	78.632	2.56291390728477	117	23	77	2	33	148	614	729	Kickxella alabastrina ribosomal protein L6, alpha-beta domain-containing protein (BX661DRAFT_85336), mRNA	blastn	387	76.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
11461798	11461798	PRJNA940501_S_NODE_30129_length_324_cov_1.875445_g29311_i0	PRJNA940501	30129	324	1.875445	6.0764418	Fungi	4751	Fungi	Fungi	148	3.77e-31	NTclustered	gi\|358030855\|dbj\|AB609161.1\|	61392	g29311	i0	78.903	28.0617283950617	237	37	72	9	82	313	1694	1466	Coemansia reversa EF2 gene for translation elongation factor 2, partial cds, strain: NRRL 1564	blastn	9092	148	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia reversa
17834854	17834854	PRJNA940501_S_NODE_15734_length_392_cov_4.968481_g14920_i0	PRJNA940501	15734	392	4.968481	19.47644552	Eukaryota	2759	Fungi	Fungi	171	9.92e-38	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g14920	i0	85.89	41.7270408163265	163	20	41	3	1	162	2326	2166	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	16357	171	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
17835648	17835648	PRJNA940501_S_NODE_373094_length_153_cov_2.009091_g372276_i0	PRJNA940501	373094	153	2.009091	3.07390923	Fungi	4751	Fungi	Fungi	176	7.13e-40	NTclustered	gi\|2028311118\|ref\|XM_040890719.1\|	61395	g372276	i0	87.5	91.8235294117647	152	19	99	0	2	153	439	590	Linderina pennispora ribosomal protein S15 (DL89DRAFT_2962), mRNA	blastn	14049	176	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
22596257	22596257	PRJNA940501_S_NODE_221778_length_186_cov_1.972028_g220960_i0	PRJNA940501	221778	186	1.972028	3.66797208	Entomophthora muscae	34485	Fungi	Fungi	333	5.069999999999999e-87	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g220960	i0	98.925	3.36559139784946	186	2	100	0	1	186	1942	1757	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	626	333	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae

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