metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB28062" 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
24251269	24251269	PRJEB28062_P_NODE_75500_length_392_cov_3.347962_g73138_i0	PRJEB28062	75500	392	3.347962	13.12401104	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	144	2.1399999999999996e-41	NR	KRX06975.1	266149	g73138	i0	94.7	0.573979591836735	75	4	57.4	0	11	235	69	143	KRX06975.1 Nucleic acid-binding, OB-fold [Pseudocohnilembus persalinus]	diamond	225	144	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
26780086	26780086	PRJEB28062_P_NODE_134761_length_226_cov_3.411765_g132397_i0	PRJEB28062	134761	226	3.411765	7.7105889	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	99	6.619999999999999e-23	NR	CAI2372669.1	5936	g132397	i0	68.4	1.51327433628319	57	18	75.7	0	214	44	242	298	CAI2372669.1 unnamed protein product [Moneuplotes crassus]	diamond	342	99	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
27886063	27886063	PRJEB28062_P_NODE_96425_length_325_cov_14.178571_g94063_i0	PRJEB28062	96425	325	14.178571	46.08035575	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	116	1.1300000000000002e-27	NR	KRX07143.1	266149	g94063	i0	55	0.923076923076923	100	44	91.4	1	323	27	224	323	KRX07143.1 Amidase signature domain [Pseudocohnilembus persalinus]	diamond	300	116	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
31100852	31100852	PRJEB28062_P_NODE_92135_length_338_cov_7.215094_g89773_i0	PRJEB28062	92135	338	7.215094	24.38701772	Tetrahymena	5890	SAR_Eukaryotes	SAR_Eukaryotes	49.7	3.45e-4	NR	XP_001010057.2	312017	g89773	i0	52.5	0.710059171597633	40	19	35.5	0	12	131	253	292	XP_001010057.2 ER lumen protein retaining receptor [Tetrahymena thermophila SB210]	diamond	240	49.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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