metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA745553" 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
28221179	28221179	PRJNA745553_S_NODE_7326_length_438_cov_2.186301_g7132_i0	PRJNA745553	7326	438	2.186301	9.57599838	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	199	8.58e-63	NR	RNA30453.1	10195	g7132	i0	74.6	0.917808219178082	134	34	91.8	0	437	36	7	140	RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis]	diamond	402	199	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
29673437	29673437	PRJNA745553_S_NODE_21050_length_269_cov_4.596939_g20855_i0	PRJNA745553	21050	269	4.596939	12.36576591	Rotaria socialis	392032	Rotifera	other_Eukaryota	72	1.96e-12	NR	CAF4842423.1	392032	g20855	i0	63.3	1.66171003717472	49	18	54.6	0	240	94	302	350	CAF4842423.1 unnamed protein product [Rotaria socialis]	diamond	447	72	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
29746581	29746581	PRJNA745553_S_NODE_12870_length_342_cov_13.635688_g12675_i0	PRJNA745553	12870	342	13.635688	46.63405296	Adineta	104781	Rotifera	other_Eukaryota	90.1	6.83e-21	NR	UJR10542.1	104782	g12675	i0	63.9	6	83	25	69.3	2	51	287	8	89	UJR10542.1 hypothetical protein I4U23_014742 [Adineta vaga]	diamond	2052	90.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
31474961	31474961	PRJNA745553_S_NODE_24016_length_252_cov_3.005587_g23821_i0	PRJNA745553	24016	252	3.005587	7.57407924	Rotaria sordida	392033	Rotifera	other_Eukaryota	64.3	3.88e-11	NR	CAF0843948.1	392033	g23821	i0	46.5	4.17857142857143	43	23	51.2	0	42	170	35	77	CAF0843948.1 unnamed protein product [Rotaria sordida]	diamond	1053	64.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
31854337	31854337	PRJNA745553_S_NODE_26877_length_240_cov_5.820359_g26682_i0	PRJNA745553	26877	240	5.820359	13.9688616	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	43.5	0.0188	NR	CAF2818043.1	2762512	g26682	i0	31.1	0.7625	61	39	76.3	1	53	235	119	176	CAF2818043.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	183	43.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
32075879	32075879	PRJNA745553_S_NODE_24238_length_251_cov_2.533708_g24043_i0	PRJNA745553	24238	251	2.533708	6.35960708	Rotaria socialis	392032	Rotifera	other_Eukaryota	55.5	1.53e-7	NR	CAF2999011.1	392032	g24043	i0	65	1.31474103585657	40	14	47.8	0	118	237	2	41	CAF2999011.1 unnamed protein product [Rotaria socialis]	diamond	330	55.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
32075882	32075882	PRJNA745553_S_NODE_3958_length_543_cov_3.640426_g3770_i0	PRJNA745553	3958	543	3.640426	19.76751318	Adineta steineri	433720	Rotifera	other_Eukaryota	161	9.07e-45	NR	CAF0719324.1	433720	g3770	i0	56.2	1.76795580110497	162	66	89	4	542	60	205	362	CAF0719324.1 unnamed protein product [Adineta steineri]	diamond	960	161	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
32529020	32529020	PRJNA745553_S_NODE_6459_length_460_cov_3.211886_g6265_i0	PRJNA745553	6459	460	3.211886	14.7746756	Rotaria	231623	Rotifera	other_Eukaryota	123	2.24e-29	NR	CAF3369675.1	2762511	g6265	i0	51.3	4.58478260869565	113	55	73.7	0	460	122	471	583	CAF3369675.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	2109	123	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1

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