metadata: contig_metadata: 5 rows where bioproject = "PRJNA1242190", tax_phylum = "Rotifera" and tax

5 rows where bioproject = "PRJNA1242190", tax_phylum = "Rotifera" and tax_superkingdom = "Eukaryota"

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
22027678	22027678	PRJNA1242190_S_NODE_6738_length_324_cov_1.689243_g6731_i0	PRJNA1242190	6738	324	1.689243	5.47314732	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	77.8	7.66e-15	NR	CAF2642610.1	2762512	g6731	i0	47.9	2.69444444444444	73	37	66.7	1	322	107	79	151	CAF2642610.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	873	77.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
27326483	27326483	PRJNA1242190_S_NODE_7323_length_313_cov_6.466667_g7316_i0	PRJNA1242190	7323	313	6.466667	20.24066771	Adineta ricciae	249248	Rotifera	other_Eukaryota	67	2.52e-11	NR	CAF0745393.1	249248	g7316	i0	43.9	0.63258785942492	66	37	63.3	0	297	100	22	87	CAF0745393.1 unnamed protein product [Adineta ricciae]	diamond	198	67	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
27989650	27989650	PRJNA1242190_S_NODE_2965_length_448_cov_3.770667_g2958_i0	PRJNA1242190	2965	448	3.770667	16.89258816	Adineta ricciae	249248	Rotifera	other_Eukaryota	148	1.72e-40	NR	CAF1646217.1	249248	g2958	i0	64.1	4.15178571428571	103	37	69	0	376	68	52	154	CAF1646217.1 unnamed protein product, partial [Adineta ricciae]	diamond	1860	148	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30105100	30105100	PRJNA1242190_S_NODE_9952_length_273_cov_3.410000_g9945_i0	PRJNA1242190	9952	273	3.41	9.3093	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	64.3	1.36e-10	NR	CAF1548165.1	2762511	g9945	i0	43.7	3.68131868131868	71	38	75.8	1	265	59	12	82	CAF1548165.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	1005	64.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
30231549	30231549	PRJNA1242190_S_NODE_10292_length_269_cov_2.178571_g10285_i0	PRJNA1242190	10292	269	2.178571	5.86035599	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	43.1	0.0372	NR	CAF2840576.1	2762512	g10285	i0	42.6	0.602230483271376	54	31	60.2	0	259	98	568	621	CAF2840576.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	162	43.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2

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