metadata: contig_metadata: 8 rows where bioproject = "PRJNA1192965", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA1192965", tax_clade = "Opisthokonta" 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
7973789	7973789	PRJNA1192965_P_NODE_447_length_543_cov_1.385106_g429_i0	PRJNA1192965	447	543	1.385106	7.52112558	Adineta	104781	Rotifera	other_Eukaryota	233	6.449999999999999e-72	NR	CAF0733640.1	249248	g429	i0	65.7	30	181	61	100	1	543	1	40	219	CAF0733640.1 unnamed protein product [Adineta ricciae]	diamond	16290	234	0.995726495726496	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
24546575	24546575	PRJNA1192965_P_NODE_740_length_437_cov_1.760989_g721_i0	PRJNA1192965	740	437	1.760989	7.69552193	Adineta ricciae	249248	Rotifera	other_Eukaryota	185	1.979999999999999e-55	NR	CAF0890961.1	249248	g721	i0	63.7	4.0091533180778	146	52	99.5	1	3	437	136	281	CAF0890961.1 unnamed protein product [Adineta ricciae]	diamond	1752	185	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
27388605	27388605	PRJNA1192965_P_NODE_1263_length_357_cov_1.535211_g1244_i0	PRJNA1192965	1263	357	1.535211	5.48070327	Adineta vaga	104782	Rotifera	other_Eukaryota	64.7	2.01e-9	NR	UJR15272.1	104782	g1244	i0	38.3	0.789915966386555	94	57	78.2	1	1	279	46	139	UJR15272.1 hypothetical protein I4U23_002226 [Adineta vaga]	diamond	282	64.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
28209189	28209189	PRJNA1192965_P_NODE_2606_length_273_cov_2.465000_g2587_i0	PRJNA1192965	2606	273	2.465	6.72945	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	124	1.7e-32	NR	CAF1052347.1	1234261	g2587	i0	69.2	1	91	27	98.9	1	272	3	8	98	CAF1052347.1 unnamed protein product [Didymodactylos carnosus]	diamond	273	124	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
28462186	28462186	PRJNA1192965_P_NODE_3486_length_250_cov_0.870056_g3467_i0	PRJNA1192965	3486	250	0.870056	2.17514	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	151	1.02e-41	NR	CAF3974781.1	2762512	g3467	i0	90.2	4.92	82	8	98.4	0	2	247	314	395	CAF3974781.1 unnamed protein product, partial [Rotaria sp. Silwood2]	diamond	1230	151	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
31810792	31810792	PRJNA1192965_P_NODE_3877_length_248_cov_0.880000_g3858_i0	PRJNA1192965	3877	248	0.88	2.1824	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	68.6	3.22e-11	NR	CAF3356826.1	2762512	g3858	i0	44.8	5.50403225806452	67	37	81	0	202	2	378	444	CAF3356826.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	1365	68.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
32632834	32632834	PRJNA1192965_P_NODE_2180_length_290_cov_2.105991_g2161_i0	PRJNA1192965	2180	290	2.105991	6.1073739	Adineta steineri	433720	Rotifera	other_Eukaryota	44.3	0.0186	NR	CAF1524545.1	433720	g2161	i0	46.3	1.63448275862069	41	22	42.4	0	142	264	177	217	CAF1524545.1 unnamed protein product [Adineta steineri]	diamond	474	44.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
32759025	32759025	PRJNA1192965_P_NODE_4440_length_245_cov_0.895349_g4421_i0	PRJNA1192965	4440	245	0.895349	2.19360505	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	52.4	7.79e-6	NR	CAF2391505.1	2762512	g4421	i0	42.3	1.75102040816327	71	38	83.3	2	4	207	62	132	CAF2391505.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	429	52.4	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);;