metadata: contig_metadata: 5 rows where bioproject = "PRJNA1196384", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1196384", tax_kingdom = "Metazoa" 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
28240825	28240825	PRJNA1196384_S_NODE_1266_length_344_cov_1.713355_g1202_i0	PRJNA1196384	1266	344	1.713355	5.8939412	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	92.8	3.53e-19	NR	CAF3543268.1	2762511	g1202	i0	56.8	1.93604651162791	111	48	96.8	0	339	7	3009	3119	CAF3543268.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	666	92.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
28891282	28891282	PRJNA1196384_S_NODE_4368_length_191_cov_2.733766_g4304_i0	PRJNA1196384	4368	191	2.733766	5.22149306	Brachionus	10194	Rotifera	other_Eukaryota	65.9	1.09e-11	NR	RNA30453.1	10195	g4304	i0	72.3	2.95287958115183	47	11	70.7	1	191	57	90	136	RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis]	diamond	564	65.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
28999169	28999169	PRJNA1196384_S_NODE_4188_length_194_cov_4.114650_g4124_i0	PRJNA1196384	4188	194	4.11465	7.982421	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	87.4	1.99e-20	NR	CAF3440507.1	2762512	g4124	i0	63.5	0.974226804123711	63	23	97.4	0	194	6	7	69	CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	189	87.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
29062090	29062090	PRJNA1196384_S_NODE_5768_length_172_cov_1.688889_g5704_i0	PRJNA1196384	5768	172	1.688889	2.90488908	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	79.7	7.78e-16	NR	CAF0896518.1	1234261	g5704	i0	71.4	0.976744186046512	56	16	97.7	0	3	170	146	201	CAF0896518.1 unnamed protein product [Didymodactylos carnosus]	diamond	168	79.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
32443947	32443947	PRJNA1196384_S_NODE_1919_length_282_cov_6.346939_g1855_i0	PRJNA1196384	1919	282	6.346939	17.89836798	Rotaria sordida	392033	Rotifera	other_Eukaryota	72.4	1.47e-12	NR	CAF3569982.1	392033	g1855	i0	91.4	1.86170212765957	35	3	37.2	0	281	177	299	333	CAF3569982.1 unnamed protein product [Rotaria sordida]	diamond	525	72.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida

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