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

4 rows where bioproject = "PRJNA1082072", 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
7845855	7845855	PRJNA1082072_P_NODE_1667_length_277_cov_1.436275_g1660_i0	PRJNA1082072	1667	277	1.436275	3.97848175	Plasmodium falciparum	5833	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.025	NTclustered	gi\|296005543\|ref\|XM_002809043.1\|	36329	g1660	i0	100	0.101083032490975	28	0	10	0	91	118	3279	3306	Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1359600), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
30225420	30225420	PRJNA1082072_P_NODE_1572_length_282_cov_1.253589_g1565_i0	PRJNA1082072	1572	282	1.253589	3.53512098	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	51.2	5.9e-5	NR	CAL7858781.1	1344799	g1565	i0	39.1	0.978723404255319	92	50	97.9	3	5	280	152	237	CAL7858781.1 unnamed protein product [Sarcocystis calchasi]	diamond	276	51.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
30754062	30754062	PRJNA1082072_P_NODE_1294_length_305_cov_1.172414_g1287_i0	PRJNA1082072	1294	305	1.172414	3.5758627	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	110	7.46e-29	NR	GFE54039.1	5869	g1287	i0	56.4	14.5475409836066	101	43	98.4	1	5	304	5	105	GFE54039.1 60S ribosomal protein L31 [Babesia ovis]	diamond	4437	110	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovis
30889010	30889010	PRJNA1082072_P_NODE_2234_length_250_cov_0.870056_g2227_i0	PRJNA1082072	2234	250	0.870056	2.17514	Plasmodium cynomolgi strain B	1120755	SAR_Eukaryotes	SAR_Eukaryotes	58.9	8.28e-8	NR	XP_004225034.1	1120755	g2227	i0	35.1	3.696	77	49	91.2	1	244	17	1048	1124	XP_004225034.1 ubiquitin-activating enzyme e1 [Plasmodium cynomolgi strain B]	diamond	924	58.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi

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