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

7 rows where analysis = "diamond", bioproject = "PRJNA682078" and tax_phylum = "Rotifera"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
662125	662125	PRJNA682078_P_NODE_284261_length_242_cov_0.911243_g282484_i0	PRJNA682078	284261	242	0.911243	2.20520806	Rotaria	231623	Rotifera	other_Eukaryota	157	5.77e-45	NR	CAF5178728.1	392030	g282484	i0	92.5	23.801652892562	80	6	99.2	0	242	3	257	336	CAF5178728.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	5760	157	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
28072799	28072799	PRJNA682078_P_NODE_289665_length_241_cov_0.916667_g287888_i0	PRJNA682078	289665	241	0.916667	2.20916747	Rotaria	231623	Rotifera	other_Eukaryota	60.5	2.06e-8	NR	CAF2109629.1	392030	g287888	i0	43	5.02904564315353	79	30	98.3	1	3	239	2386	2449	CAF2109629.1 unnamed protein product [Rotaria magnacalcarata]	diamond	1212	60.8	0.995065789473684	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
29071761	29071761	PRJNA682078_P_NODE_276328_length_243_cov_0.905882_g274551_i0	PRJNA682078	276328	243	0.905882	2.20129326	Adineta steineri	433720	Rotifera	other_Eukaryota	48.5	3.31e-4	NR	CAF1016098.1	433720	g274551	i0	52.1	1.18518518518519	48	22	58	1	2	142	170	217	CAF1016098.1 unnamed protein product [Adineta steineri]	diamond	288	48.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29702641	29702641	PRJNA682078_P_NODE_221870_length_251_cov_1.179775_g220093_i0	PRJNA682078	221870	251	1.179775	2.96123525	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	66.2	4.32e-11	NR	CAF2998091.1	2762512	g220093	i0	47	0.788844621513944	66	35	78.9	0	202	5	20	85	CAF2998091.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	198	66.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
30208179	30208179	PRJNA682078_P_NODE_249152_length_247_cov_0.885057_g247375_i0	PRJNA682078	249152	247	0.885057	2.18609079	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	50.8	3.64e-5	NR	CAF3750527.1	2762511	g247375	i0	40.3	0.813765182186235	67	40	81.4	0	45	245	152	218	CAF3750527.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	201	50.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
30713943	30713943	PRJNA682078_P_NODE_246274_length_247_cov_3.344828_g244497_i0	PRJNA682078	246274	247	3.344828	8.26172516	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	40.8	0.0495	NR	CAF4346029.1	392030	g244497	i0	70.4	0.327935222672065	27	7	31.6	1	243	166	8	34	CAF4346029.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	81	40.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
31946886	31946886	PRJNA682078_P_NODE_84157_length_379_cov_1.542484_g82382_i0	PRJNA682078	84157	379	1.542484	5.84601436	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	119	2.05e-30	NR	CAF1015630.1	1234261	g82382	i0	58	2.13720316622691	88	37	69.7	0	378	115	89	176	CAF1015630.1 unnamed protein product [Didymodactylos carnosus]	diamond	810	119	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus

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