metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax_phylum = "Ciliophora"

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
28401022	28401022	PRJNA326068_P_NODE_12206_length_267_cov_1.819328_g11243_i0	PRJNA326068	12206	267	1.819328	4.85760576	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	59.7	5.4e-9	NR	CDW74504.1	5949	g11243	i0	64.1	0.876404494382023	39	14	43.8	0	119	3	70	108	CDW74504.1 histone h2b [Stylonychia lemnae]	diamond	234	59.7	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
28559078	28559078	PRJNA326068_P_NODE_6047_length_446_cov_2.007194_g5168_i0	PRJNA326068	6047	446	2.007194	8.95208524	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	115	1.01e-29	NR	KRX01081.1	266149	g5168	i0	45.8	1.76233183856502	142	74	95.5	1	441	16	1	139	KRX01081.1 hypothetical protein PPERSA_02177 [Pseudocohnilembus persalinus]	diamond	786	115	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
29790117	29790117	PRJNA326068_P_NODE_6731_length_417_cov_1.773196_g5812_i0	PRJNA326068	6731	417	1.773196	7.39422732	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	104	2.21e-25	NR	CAI2382183.1	5936	g5812	i0	71.8	1	71	20	51.1	0	214	2	57	127	CAI2382183.1 unnamed protein product [Moneuplotes crassus]	diamond	417	104	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
30264483	30264483	PRJNA326068_P_NODE_14572_length_225_cov_2.714286_g13609_i0	PRJNA326068	14572	225	2.714286	6.1071435	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	68.9	1.11e-12	NR	CAD8206115.1	43137	g13609	i0	54.1	1.97333333333333	74	33	97.3	1	219	1	1	74	CAD8206115.1 unnamed protein product [Paramecium octaurelia]	diamond	444	68.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
31703771	31703771	PRJNA326068_P_NODE_10577_length_303_cov_1.835766_g9616_i0	PRJNA326068	10577	303	1.835766	5.56237098	Spirotrichea	33829	SAR_Eukaryotes	SAR_Eukaryotes	144	6.369999999999998e-42	NR	CAI2382183.1	5936	g9616	i0	73	50.4950495049505	100	26	99	1	301	2	45	143	CAI2382183.1 unnamed protein product [Moneuplotes crassus]	diamond	15300	144	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
32477617	32477617	PRJNA326068_P_NODE_16939_length_199_cov_1.723529_g15976_i0	PRJNA326068	16939	199	1.723529	3.42982271	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	47	2.81e-4	NR	KRW99836.1	266149	g15976	i0	43.6	0.829145728643216	55	30	81.4	1	196	35	56	110	KRW99836.1 hypothetical protein PPERSA_10955 [Pseudocohnilembus persalinus]	diamond	165	47	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
32683902	32683902	PRJNA326068_P_NODE_14640_length_224_cov_4.030769_g13677_i0	PRJNA326068	14640	224	4.030769	9.02892256	Spirotrichea	33829	SAR_Eukaryotes	SAR_Eukaryotes	109	4.41e-29	NR	O97484.1	5936	g13677	i0	63.5	14.8660714285714	74	27	99.1	0	224	3	20	93	O97484.1 RecName: Full=Histone H2B [Moneuplotes crassus]	diamond	3330	109	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus

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