metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB11523" 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
13719	13719	PRJEB11523_P_NODE_2361_length_343_cov_5.653061_g2283_i0	PRJEB11523	2361	343	5.653061	19.38999923	Tetrahymena utriculariae	2486642	SAR_Eukaryotes	SAR_Eukaryotes	82.4	1.51e-15	NR	KAL4506716.1	2486642	g2283	i0	81.3	0.419825072886297	48	9	42	0	156	13	422	469	KAL4506716.1 hypothetical protein ABPG72_000287 [Tetrahymena utriculariae]	diamond	144	82.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena utriculariae
15315954	15315954	PRJEB11523_P_NODE_2493_length_332_cov_1.441696_g2415_i0	PRJEB11523	2493	332	1.441696	4.78643072	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	117	9.33e-28	NR	TNV86781.1	5974	g2415	i0	84.7	1.0933734939759	59	9	53.3	0	12	188	673	731	TNV86781.1 hypothetical protein FGO68_gene10147 [Halteria grandinella]	diamond	363	117	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
26652602	26652602	PRJEB11523_P_NODE_5121_length_206_cov_21.089172_g5043_i0	PRJEB11523	5121	206	21.089172	43.44369432	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	47.8	3.96e-4	NR	XP_001018217.2	312017	g5043	i0	47.8	0.669902912621359	46	21	64.1	2	73	204	381	425	XP_001018217.2 transmembrane protein, putative [Tetrahymena thermophila SB210]	diamond	138	47.8	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
26747449	26747449	PRJEB11523_P_NODE_5601_length_196_cov_8.244898_g5523_i0	PRJEB11523	5601	196	8.244898	16.16000008	Uronema marinum	35107	SAR_Eukaryotes	SAR_Eukaryotes	87	4.01e-18	NR	YP_009512651.1	35107	g5523	i0	73.6	0.811224489795918	53	14	81.1	0	192	34	377	429	YP_009512651.1 NADH dehydrogenase subunit 7 [Uronema marinum]	diamond	159	87	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Uronematidae	Uronema	Uronema marinum
26969365	26969365	PRJEB11523_P_NODE_3482_length_263_cov_2.887850_g3404_i0	PRJEB11523	3482	263	2.88785	7.5950455	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	64.3	6.86e-10	NR	CAI2375198.1	5936	g3404	i0	50	2.34980988593156	66	31	75.3	1	239	42	93	156	CAI2375198.1 unnamed protein product [Moneuplotes crassus]	diamond	618	64.3	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
28991026	28991026	PRJEB11523_P_NODE_6848_length_175_cov_4.476190_g6770_i0	PRJEB11523	6848	175	4.47619	7.8333325	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	48.9	9.78e-5	NR	KAL4490488.1	5901	g6770	i0	46	3.73714285714286	50	25	84	2	27	173	188	236	KAL4490488.1 hypothetical protein ABPG73_009465 [Tetrahymena malaccensis]	diamond	654	49.3	0.991886409736308	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
30569621	30569621	PRJEB11523_P_NODE_233_length_1227_cov_78.300509_g196_i0	PRJEB11523	233	1227	78.300509	960.74724543	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	144	6.459999999999999e-37	NR	OMJ91231.1	5963	g196	i0	54.3	0.342298288508557	140	62	34.2	1	1001	582	64	201	OMJ91231.1 hypothetical protein SteCoe_6303 [Stentor coeruleus]	diamond	420	144	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
31075519	31075519	PRJEB11523_P_NODE_5215_length_204_cov_10.890323_g5137_i0	PRJEB11523	5215	204	10.890323	22.21625892	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	92.8	4.75e-20	NR	OMJ82622.1	5963	g5137	i0	78.6	0.823529411764706	56	12	82.4	0	187	20	477	532	OMJ82622.1 hypothetical protein SteCoe_16600 [Stentor coeruleus]	diamond	168	92.8	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
31865787	31865787	PRJEB11523_P_NODE_1217_length_531_cov_2.962656_g1140_i0	PRJEB11523	1217	531	2.962656	15.73170336	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	107	1.69e-23	NR	CDW90426.1	5949	g1140	i0	67.2	0.361581920903955	64	21	36.2	0	24	215	753	816	CDW90426.1 transforming growth factor beta regulator 1 [Stylonychia lemnae]	diamond	192	107	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae

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