metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA484127" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA484127" 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
17025988	17025988	PRJNA484127_P_NODE_38314_length_242_cov_2.579882_g38165_i0	PRJNA484127	38314	242	2.579882	6.24331444	root	1	Root_unresolved	Root_unresolved	122	1.93e-30	NR	XP_067925722.1	483139	g38165	i0	77.5	10.6487603305785	71	16	88	0	215	3	102	172	XP_067925722.1 isocitrate dehydrogenase [Cystoisospora suis]	diamond	2577	123	0.991869918699187	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
27629634	27629634	PRJNA484127_P_NODE_34104_length_247_cov_1.793103_g33955_i0	PRJNA484127	34104	247	1.793103	4.42896441	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	91.3	1.26e-20	NR	XP_002259675.1	5851	g33955	i0	53.7	34.8097165991903	82	37	99.6	1	246	1	19	99	XP_002259675.1 ras-related protein Rab-1A, putative [Plasmodium knowlesi strain H]	diamond	8598	91.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
29113548	29113548	PRJNA484127_P_NODE_30528_length_252_cov_0.871508_g30379_i0	PRJNA484127	30528	252	0.871508	2.19620016	Eucoccidiorida	75739	SAR_Eukaryotes	SAR_Eukaryotes	127	1.5499999999999998e-35	NR	XP_013228494.1	5802	g30379	i0	77.8	3.85714285714286	81	18	96.4	0	245	3	1	81	XP_013228494.1 40S ribosomal protein S18, putative [Eimeria tenella]	diamond	972	128	0.9921875	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
31356485	31356485	PRJNA484127_P_NODE_34476_length_247_cov_0.896552_g34327_i0	PRJNA484127	34476	247	0.896552	2.21448344	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	94.4	6.65e-21	NR	XP_012650249.1	1133968	g34327	i0	59.5	2.72064777327935	74	23	81.4	1	242	42	248	321	XP_012650249.1 guanine nucleotide-binding protein subunit beta-2-like 1 protein [Babesia microti strain RI]	diamond	672	94.7	0.996832101372756	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti

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