metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax_clade = "Sar"

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
4498558	4498558	PRJNA690234_P_NODE_9264_length_420_cov_1.853026_g8898_i0	PRJNA690234	9264	420	1.853026	7.7827092	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	54.3	2.1e-5	NR	XP_726170.3	5861	g8898	i0	38.9	2.42857142857143	90	52	64.3	2	276	7	194	280	XP_726170.3 uncharacterized protein PY17X_1233000 [Plasmodium yoelii]	diamond	1020	54.3	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
26797557	26797557	PRJNA690234_P_NODE_6141_length_522_cov_4.730512_g5777_i0	PRJNA690234	6141	522	4.730512	24.69327264	Plasmodium gallinaceum	5849	SAR_Eukaryotes	SAR_Eukaryotes	48.1	0.00781	NR	XP_028526562.1	5849	g5777	i0	25.9	1.32758620689655	147	85	82.2	4	55	483	233	359	XP_028526562.1 conserved Plasmodium protein, unknown function [Plasmodium gallinaceum]	diamond	693	48.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
27303788	27303788	PRJNA690234_P_NODE_20083_length_283_cov_1.485714_g19716_i0	PRJNA690234	20083	283	1.485714	4.20457062	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	116	8.88e-28	NR	MES1908187.1	1215613	g19716	i0	54.3	6.97526501766784	94	43	99.6	0	283	2	655	748	MES1908187.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1974	116	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27788902	27788902	PRJNA690234_P_NODE_31764_length_242_cov_0.923077_g31397_i0	PRJNA690234	31764	242	0.923077	2.23384634	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	101	5.0299999999999995e-25	NR	CAD8123542.1	65129	g31397	i0	56.3	1.95867768595041	80	35	99.2	0	242	3	60	139	CAD8123542.1 unnamed protein product [Paramecium sonneborni]	diamond	474	101	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
31104761	31104761	PRJNA690234_P_NODE_10375_length_396_cov_1.157895_g10009_i0	PRJNA690234	10375	396	1.157895	4.5852642	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	114	1.34e-26	NR	XP_002185733.1	556484	g10009	i0	45.3	4.9469696969697	128	68	95.5	1	378	1	318	445	XP_002185733.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	1959	114	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
31630947	31630947	PRJNA690234_P_NODE_16956_length_308_cov_2.612766_g16589_i0	PRJNA690234	16956	308	2.612766	8.04731928	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.0151	NR	XP_022810716.2	5861	g16589	i0	33.3	0.672077922077922	69	44	65.3	1	220	20	166	234	XP_022810716.2 PIR protein [Plasmodium yoelii]	diamond	207	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
31642324	31642324	PRJNA690234_P_NODE_29736_length_245_cov_0.906977_g29369_i0	PRJNA690234	29736	245	0.906977	2.22209365	Sarcocystidae	5809	SAR_Eukaryotes	SAR_Eukaryotes	83.2	3.87e-17	NR	XP_029219302.1	94643	g29369	i0	48.8	1.95918367346939	80	41	98	0	2	241	93	172	XP_029219302.1 putative adenylate kinase [Besnoitia besnoiti]	diamond	480	83.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
31800400	31800400	PRJNA690234_P_NODE_27537_length_249_cov_0.886364_g27170_i0	PRJNA690234	27537	249	0.886364	2.20704636	Eimeriidae	5799	SAR_Eukaryotes	SAR_Eukaryotes	158	6.079999999999999e-46	NR	XP_013247798.1	5801	g27170	i0	95.2	4	83	4	100	0	249	1	195	277	XP_013247798.1 fibrillarin, putative [Eimeria acervulina]	diamond	996	159	0.993710691823899	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina

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