metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA853194" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA853194" 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
28168692	28168692	PRJNA853194_S_NODE_31705_length_373_cov_1.216667_g30614_i0	PRJNA853194	31705	373	1.216667	4.53816791	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	133	3.86e-35	NR	XP_001452796.1	5888	g30614	i0	53.7	21.6193029490617	123	57	98.9	0	370	2	98	220	XP_001452796.1 uncharacterized protein GSPATT00002799001 [Paramecium tetraurelia]	diamond	8064	134	0.992537313432836	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
28389605	28389605	PRJNA853194_S_NODE_1366_length_1330_cov_13.017502_g919_i1	PRJNA853194	1366	1330	13.017502	173.1327766	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	102	5.1e-19	NR	CDW79198.1	5949	g919	i1	25.4	1.10751879699248	256	179	57.5	4	1263	499	489	733	CDW79198.1 cullin c [Stylonychia lemnae]	diamond	1473	102	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
29644019	29644019	PRJNA853194_S_NODE_14870_length_504_cov_6.561485_g13785_i0	PRJNA853194	14870	504	6.561485	33.0698844	Tetrahymena malaccensis	5901	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.0269	NR	KAL4450420.1	5901	g13785	i0	24.1	0.69047619047619	116	79	64.9	3	422	96	101	214	KAL4450420.1 hypothetical protein ABPG74_019318 [Tetrahymena malaccensis]	diamond	348	46.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
31580341	31580341	PRJNA853194_S_NODE_38956_length_342_cov_4.579926_g37865_i0	PRJNA853194	38956	342	4.579926	15.66334692	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.0121	NR	OMJ88354.1	5963	g37865	i0	48.8	2.81578947368421	41	15	31.6	2	185	292	384	423	OMJ88354.1 hypothetical protein SteCoe_9770 [Stentor coeruleus]	diamond	963	45.4	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
31761750	31761750	PRJNA853194_S_NODE_78957_length_248_cov_1.514286_g77866_i0	PRJNA853194	78957	248	1.514286	3.75542928	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	67.4	8.11e-11	NR	CDW81364.1	5949	g77866	i0	47.8	1.81451612903226	69	36	83.5	0	42	248	385	453	CDW81364.1 kif1-binding protein homolog [Stylonychia lemnae]	diamond	450	67.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
32773103	32773103	PRJNA853194_S_NODE_1100_length_1421_cov_86.551929_g802_i0	PRJNA853194	1100	1421	86.551929	1229.90291109	Paramecium primaurelia	5886	SAR_Eukaryotes	SAR_Eukaryotes	258	2.88e-79	NR	CAD8068969.1	5886	g802	i0	50.2	1.16959887403237	277	130	58.3	4	116	943	2	271	CAD8068969.1 unnamed protein product [Paramecium primaurelia]	diamond	1662	258	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium primaurelia

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