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

5 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
27602183	27602183	PRJEB3181_P_NODE_28264_length_150_cov_1.478992_g27999_i0	PRJEB3181	28264	150	1.478992	2.218488	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	87	1.08e-19	NR	XP_029220420.1	94643	g27999	i0	80	4	50	10	100	0	1	150	130	179	XP_029220420.1 ribosomal protein RPS5 [Besnoitia besnoiti]	diamond	600	87	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
29432997	29432997	PRJEB3181_S_NODE_8590_length_215_cov_2.338889_g8297_i0	PRJEB3181	8590	215	2.338889	5.02861135	Hepatocystis sp. ex Piliocolobus tephrosceles	2600580	SAR_Eukaryotes	SAR_Eukaryotes	98.2	1.0799999999999999e-24	NR	VWU51230.1	2600580	g8297	i0	71.8	1.98139534883721	71	20	99.1	0	215	3	18	88	VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles]	diamond	426	98.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Hepatocystis	Hepatocystis sp. ex Piliocolobus tephrosceles
29559462	29559462	PRJEB3181_P_NODE_16930_length_202_cov_8.292398_g16666_i0	PRJEB3181	16930	202	8.292398	16.75064396	Babesia microti strain RI	1133968	SAR_Eukaryotes	SAR_Eukaryotes	66.2	5.64e-11	NR	XP_012648114.1	1133968	g16666	i0	57.4	6.62376237623762	54	19	80.2	1	3	164	194	243	XP_012648114.1 small subunit ribosomal protein S3Ae [Babesia microti strain RI]	diamond	1338	66.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia microti
30311630	30311630	PRJEB3181_P_NODE_11092_length_255_cov_3.674107_g10828_i0	PRJEB3181	11092	255	3.674107	9.36897285	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	79	7.62e-17	NR	CAL7859112.1	1344799	g10828	i0	64.1	3.02352941176471	64	23	75.3	0	251	60	36	99	CAL7859112.1 unnamed protein product [Sarcocystis calchasi]	diamond	771	79.7	0.991217063989962	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
30563566	30563566	PRJEB3181_P_NODE_12153_length_243_cov_4.825472_g11889_i0	PRJEB3181	12153	243	4.825472	11.72589696	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	80.9	1.64e-16	NR	KAK1936904.1	32595	g11889	i0	77.8	4	54	12	66.7	0	243	82	167	220	KAK1936904.1 putative 40S ribosomal protein S5 [Babesia divergens]	diamond	972	80.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia divergens

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