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

7 rows where analysis = "diamond", bioproject = "PRJNA407368" 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
8068451	8068451	PRJNA407368_S_NODE_6907_length_200_cov_3.602339_g6805_i0	PRJNA407368	6907	200	3.602339	7.204678	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	131	3.93e-34	NR	CAI2365993.1	5936	g6805	i0	97	0.99	66	2	99	0	3	200	13	78	CAI2365993.1 unnamed protein product [Moneuplotes crassus]	diamond	198	131	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
26885818	26885818	PRJNA407368_S_NODE_10241_length_154_cov_1.944000_g10139_i0	PRJNA407368	10241	154	1.944	2.99376	Paramecium octaurelia	43137	SAR_Eukaryotes	SAR_Eukaryotes	84	2.15e-17	NR	CAD8145797.1	43137	g10139	i0	76	0.974025974025974	50	12	97.4	0	3	152	133	182	CAD8145797.1 unnamed protein product [Paramecium octaurelia]	diamond	150	84	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium octaurelia
28875490	28875490	PRJNA407368_S_NODE_5488_length_233_cov_3.651961_g5386_i0	PRJNA407368	5488	233	3.651961	8.50906913	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	87.4	3.59e-18	NR	CAI2365923.1	5936	g5386	i0	52.6	0.978540772532189	76	35	96.6	1	227	3	178	253	CAI2365923.1 unnamed protein product [Moneuplotes crassus]	diamond	228	87.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
30580773	30580773	PRJNA407368_S_NODE_5373_length_236_cov_7.449275_g5271_i0	PRJNA407368	5373	236	7.449275	17.580289	Moneuplotes crassus	5936	SAR_Eukaryotes	SAR_Eukaryotes	96.7	3.01e-21	NR	CAI2366155.1	5936	g5271	i0	87.3	1.5635593220339	63	8	80.1	0	219	31	195	257	CAI2366155.1 unnamed protein product [Moneuplotes crassus]	diamond	369	96.7	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
30865263	30865263	PRJNA407368_S_NODE_9494_length_162_cov_2.578947_g9392_i0	PRJNA407368	9494	162	2.578947	4.17789414	Euplotes vannus	5939	SAR_Eukaryotes	SAR_Eukaryotes	72.4	2.61e-14	NR	CAH04404.1	5939	g9392	i0	73.2	0.759259259259259	41	11	75.9	0	123	1	1	41	CAH04404.1 ribosomal protein S13 [Euplotes vannus]	diamond	123	72.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Euplotes	Euplotes vannus
31434216	31434216	PRJNA407368_S_NODE_1936_length_445_cov_14.586538_g1836_i0	PRJNA407368	1936	445	14.586538	64.9100941	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	50.8	4.66e-4	NR	CAG9323633.1	1481888	g1836	i0	42.9	0.330337078651685	49	26	33	1	69	215	118	164	CAG9323633.1 unnamed protein product [Blepharisma stoltei]	diamond	147	50.8	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei
32856497	32856497	PRJNA407368_S_NODE_7820_length_184_cov_2.645161_g7718_i0	PRJNA407368	7820	184	2.645161	4.86709624	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	79	2.96e-15	NR	CAG9323272.1	1481888	g7718	i0	62.3	2.98369565217391	61	23	99.5	0	184	2	780	840	CAG9323272.1 unnamed protein product [Blepharisma stoltei]	diamond	549	79	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Blepharismidae	Blepharisma	Blepharisma stoltei

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