metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJDB4470" and tax

5 rows where analysis = "diamond", bioproject = "PRJDB4470" 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
27348758	27348758	PRJDB4470_P_NODE_55023_length_268_cov_1.922374_g53868_i0	PRJDB4470	55023	268	1.922374	5.15196232	Paramecium sonneborni	65129	SAR_Eukaryotes	SAR_Eukaryotes	89.7	6.16e-19	NR	CAD8092539.1	65129	g53868	i0	58.6	0.783582089552239	70	29	78.4	0	3	212	257	326	CAD8092539.1 unnamed protein product [Paramecium sonneborni]	diamond	210	89.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium sonneborni
28637427	28637427	PRJDB4470_P_NODE_53147_length_276_cov_1.145374_g51992_i0	PRJDB4470	53147	276	1.145374	3.16123224	Paramecium	5884	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.021	NR	CAD8148685.1	43138	g51992	i0	38.4	1.58695652173913	73	39	79.3	1	275	57	363	429	CAD8148685.1 unnamed protein product [Paramecium pentaurelia]	diamond	438	43.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium pentaurelia
29937809	29937809	PRJDB4470_P_NODE_81031_length_197_cov_1.405405_g79876_i0	PRJDB4470	81031	197	1.405405	2.76864785	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00117	NR	XP_001446247.1	5888	g79876	i0	48.8	0.654822335025381	43	22	65.5	0	32	160	194	236	XP_001446247.1 uncharacterized protein GSPATT00001891001 [Paramecium tetraurelia]	diamond	129	46.2	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
32087236	32087236	PRJDB4470_P_NODE_62638_length_241_cov_2.046875_g61483_i0	PRJDB4470	62638	241	2.046875	4.93296875	Halteria grandinella	5974	SAR_Eukaryotes	SAR_Eukaryotes	67.4	2.53e-11	NR	TNV71297.1	5974	g61483	i0	71.4	0.522821576763486	42	12	52.3	0	25	150	144	185	TNV71297.1 hypothetical protein FGO68_gene13476 [Halteria grandinella]	diamond	126	67.4	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
32719280	32719280	PRJDB4470_P_NODE_124540_length_162_cov_0.893805_g123385_i0	PRJDB4470	124540	162	0.893805	1.4479641	Blepharisma stoltei	1481888	SAR_Eukaryotes	SAR_Eukaryotes	55.1	3.05e-7	NR	CAG9335420.1	1481888	g123385	i0	45.1	1.90740740740741	51	28	94.4	0	158	6	26	76	CAG9335420.1 unnamed protein product [Blepharisma stoltei]	diamond	309	55.1	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);;