metadata: contig_metadata: 4 rows where bioproject = "PRJNA983838", tax_clade = "Sar" and tax

4 rows where bioproject = "PRJNA983838", tax_clade = "Sar" 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
14992764	14992764	PRJNA983838_P_NODE_118212_length_242_cov_1.840237_g115845_i0	PRJNA983838	118212	242	1.840237	4.45337354	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	118	4.19e-29	NR	XP_013247853.1	5801	g115845	i0	71.6	6.21074380165289	81	18	94.2	2	14	241	12	92	XP_013247853.1 dihydrolipoyl dehydrogenase, putative [Eimeria acervulina]	diamond	1503	119	0.991596638655462	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
23917119	23917119	PRJNA983838_P_NODE_100239_length_259_cov_2.129032_g97872_i0	PRJNA983838	100239	259	2.129032	5.51419288	Cryptosporidium hominis TU5	237895	SAR_Eukaryotes	SAR_Eukaryotes	110	1.3e-28	NR	XP_667392.1	353151	g97872	i0	61.2	3.92664092664093	85	33	98.5	0	3	257	6	90	XP_667392.1 translation initiation factor 5A2 [Cryptosporidium hominis TU502]	diamond	1017	110	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
27057944	27057944	PRJNA983838_P_NODE_90882_length_276_cov_1.625616_g88515_i0	PRJNA983838	90882	276	1.625616	4.48670016	Babesia duncani	323732	SAR_Eukaryotes	SAR_Eukaryotes	134	1.0499999999999998e-37	NR	XP_067804708.1	323732	g88515	i0	71.1	1.95652173913043	90	26	97.8	0	273	4	1	90	XP_067804708.1 bifunctional Ribosomal protein S8e/Ribosomal protein S8e [Babesia duncani]	diamond	540	134	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia duncani
31859456	31859456	PRJNA983838_P_NODE_91057_length_276_cov_1.266010_g88690_i0	PRJNA983838	91057	276	1.26601	3.4941876	Cryptosporidium hominis	237895	SAR_Eukaryotes	SAR_Eukaryotes	169	1.19e-47	NR	KAL3126299.1	237895	g88690	i0	82.6	4	92	16	100	0	1	276	197	288	KAL3126299.1 glutamate-tRNA ligase [Cryptosporidium hominis]	diamond	1104	169	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis

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