metadata: contig_metadata: 10 rows where bioproject = "PRJNA690124", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA690124", 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
7048413	7048413	PRJNA690124_P_NODE_6246_length_640_cov_1.121693_g5888_i0	PRJNA690124	6246	640	1.121693	7.1788352	Adineta	104781	Rotifera	other_Eukaryota	302	1.03e-99	NR	UJR30609.1	104782	g5888	i0	69.4	6.103125	186	57	87.2	0	3	560	153	338	UJR30609.1 hypothetical protein I4U23_018134 [Adineta vaga]	diamond	3906	302	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
19795838	19795838	PRJNA690124_P_NODE_17356_length_389_cov_0.987342_g16990_i0	PRJNA690124	17356	389	0.987342	3.84076038	Proales similis	360698	Rotifera	other_Eukaryota	357	7.03e-94	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g16990	i0	83.376	80.2724935732648	391	60	100	5	1	389	12363	11976	Proales similis mitochondrion, complete genome	blastn	31226	357	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
21071441	21071441	PRJNA690124_P_NODE_21557_length_351_cov_0.910072_g21191_i0	PRJNA690124	21557	351	0.910072	3.19435272	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	127	1.0599999999999999e-34	NR	CAF0959978.1	1234261	g21191	i0	56.3	3.7008547008547	112	47	94.9	2	338	6	35	145	CAF0959978.1 unnamed protein product, partial [Didymodactylos carnosus]	diamond	1299	127	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
27240307	27240307	PRJNA690124_P_NODE_24663_length_330_cov_1.821012_g24297_i0	PRJNA690124	24663	330	1.821012	6.0093396	Seison nebaliae	104778	Rotifera	other_Eukaryota	66.6	1.67e-11	NR	KAI3389794.1	104778	g24297	i0	48.5	0.6	66	34	60	0	7	204	1	66	KAI3389794.1 hypothetical protein SNEBB_001940 [Seison nebaliae]	diamond	198	66.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Pararotatoria	Seisonacea	Seisonidae	Seison	Seison nebaliae
28440516	28440516	PRJNA690124_P_NODE_54946_length_243_cov_0.917647_g54580_i0	PRJNA690124	54946	243	0.917647	2.22988221	Adineta steineri	433720	Rotifera	other_Eukaryota	130	4.39e-33	NR	CAF1321227.1	433720	g54580	i0	74.7	7.80246913580247	79	20	97.5	0	238	2	411	489	CAF1321227.1 unnamed protein product [Adineta steineri]	diamond	1896	130	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29292827	29292827	PRJNA690124_P_NODE_31249_length_296_cov_1.399103_g30883_i0	PRJNA690124	31249	296	1.399103	4.14134488	Adineta steineri	433720	Rotifera	other_Eukaryota	43.9	0.0272	NR	CAF1524545.1	433720	g30883	i0	46.3	1.60135135135135	41	22	41.6	0	130	252	177	217	CAF1524545.1 unnamed protein product [Adineta steineri]	diamond	474	43.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29777852	29777852	PRJNA690124_P_NODE_27391_length_315_cov_1.070248_g27025_i0	PRJNA690124	27391	315	1.070248	3.3712812	Eurotatoria	2816136	Rotifera	other_Eukaryota	52	5.01e-5	NR	CAF0784268.1	249248	g27025	i0	37.5	1.76190476190476	64	33	54.3	2	1	171	367	430	CAF0784268.1 unnamed protein product [Adineta ricciae]	diamond	555	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30177055	30177055	PRJNA690124_P_NODE_39052_length_266_cov_1.264249_g38686_i0	PRJNA690124	39052	266	1.264249	3.36290234	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	89.4	4.06e-19	NR	CAF4884261.1	2762511	g38686	i0	64.5	1.3984962406015	62	22	69.9	0	266	81	6	67	CAF4884261.1 unnamed protein product, partial [Rotaria sp. Silwood1]	diamond	372	89.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
31062102	31062102	PRJNA690124_P_NODE_37055_length_273_cov_1.950000_g36689_i0	PRJNA690124	37055	273	1.95	5.3235	Adineta ricciae	249248	Rotifera	other_Eukaryota	63.5	2.41e-9	NR	CAF1591485.1	249248	g36689	i0	40	1.64835164835165	75	45	82.4	0	2	226	81	155	CAF1591485.1 unnamed protein product [Adineta ricciae]	diamond	450	63.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32485387	32485387	PRJNA690124_P_NODE_19219_length_370_cov_1.191919_g18853_i0	PRJNA690124	19219	370	1.191919	4.4101003	Adineta ricciae	249248	Rotifera	other_Eukaryota	65.1	2.43e-9	NR	CAF1270699.1	249248	g18853	i0	63.8	0.762162162162162	47	17	38.1	0	343	203	954	1000	CAF1270699.1 unnamed protein product [Adineta ricciae]	diamond	282	65.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae

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