metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1182301" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1182301" and tax_phylum = "Apicomplexa"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28872219	28872219	PRJNA1182301_P_NODE_60988_length_242_cov_2.538462_g60863_i0	PRJNA1182301	60988	242	2.538462	6.14307804	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	55.8	3.67e-7	NR	XP_011134210.1	110365	g60863	i0	50.9	1.31404958677686	53	26	65.7	0	240	82	25	77	XP_011134210.1 hypothetical protein GNI_018460 [Gregarina niphandrodes]	diamond	318	55.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
28967151	28967151	PRJNA1182301_P_NODE_41128_length_260_cov_2.422460_g41003_i0	PRJNA1182301	41128	260	2.42246	6.298396	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	47.4	9.51e-4	NR	XP_011129077.1	110365	g41003	i0	39.1	0.738461538461539	64	34	70.4	2	216	34	7	68	XP_011129077.1 hypothetical protein GNI_027180, partial [Gregarina niphandrodes]	diamond	192	47.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
30546156	30546156	PRJNA1182301_P_NODE_28653_length_277_cov_1.426471_g28528_i0	PRJNA1182301	28653	277	1.426471	3.95132467	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	77.8	2.71e-14	NR	XP_011129760.1	110365	g28528	i0	51.1	2.03610108303249	94	43	99.6	3	2	277	840	932	XP_011129760.1 piwi domain protein [Gregarina niphandrodes]	diamond	564	77.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
31177794	31177794	PRJNA1182301_P_NODE_56115_length_246_cov_0.890173_g55990_i0	PRJNA1182301	56115	246	0.890173	2.18982558	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	62	4.68e-9	NR	XP_011129200.1	110365	g55990	i0	60.4	0.646341463414634	53	20	63.4	1	3	158	53	105	XP_011129200.1 putative RNA-binding nova protein, partial [Gregarina niphandrodes]	diamond	159	62	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes
32538564	32538564	PRJNA1182301_P_NODE_28279_length_277_cov_2.215686_g28154_i0	PRJNA1182301	28279	277	2.215686	6.13745022	Gregarina niphandrodes	110365	SAR_Eukaryotes	SAR_Eukaryotes	81.3	1.6e-15	NR	XP_011132848.1	110365	g28154	i0	44.9	0.963898916967509	89	47	96.4	1	9	275	1226	1312	XP_011132848.1 RNA-directed DNA polymerase [Gregarina niphandrodes]	diamond	267	81.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina niphandrodes

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