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

10 rows where bioproject = "PRJNA1002816", 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
10356118	10356118	PRJNA1002816_P_NODE_20689_length_241_cov_1.488095_g20529_i0	PRJNA1002816	20689	241	1.488095	3.58630895	Metazoa	33208	Rotifera	other_Eukaryota	134	3.12e-34	NR	CAF3719033.1	392033	g20529	i0	76.3	2.98755186721992	80	19	99.6	0	241	2	222	301	CAF3719033.1 unnamed protein product, partial [Rotaria sordida]	diamond	720	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
20554095	20554095	PRJNA1002816_P_NODE_19177_length_246_cov_0.890173_g19017_i0	PRJNA1002816	19177	246	0.890173	2.18982558	Adineta ricciae	249248	Rotifera	other_Eukaryota	132	5.89e-36	NR	CAF0922267.1	249248	g19017	i0	97.5	0.98780487804878	81	2	98.8	0	245	3	59	139	CAF0922267.1 unnamed protein product [Adineta ricciae]	diamond	243	132	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
26622819	26622819	PRJNA1002816_P_NODE_13301_length_302_cov_1.729258_g13141_i0	PRJNA1002816	13301	302	1.729258	5.22235916	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	43.9	0.0269	NR	CAF2385174.1	2762512	g13141	i0	35.8	0.665562913907285	67	40	63.6	1	47	238	232	298	CAF2385174.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	201	43.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
26812933	26812933	PRJNA1002816_P_NODE_11741_length_323_cov_3.192000_g11581_i0	PRJNA1002816	11741	323	3.192	10.31016	Seison nebaliae	104778	Rotifera	other_Eukaryota	166	6.13e-50	NR	KAI3387873.1	104778	g11581	i0	73.6	3.89164086687307	106	28	98.5	0	319	2	32	137	KAI3387873.1 hypothetical protein SNEBB_008664 [Seison nebaliae]	diamond	1257	166	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Pararotatoria	Seisonacea	Seisonidae	Seison	Seison nebaliae
27192340	27192340	PRJNA1002816_P_NODE_6242_length_454_cov_1.837270_g6082_i0	PRJNA1002816	6242	454	1.83727	8.3412058	Adineta steineri	433720	Rotifera	other_Eukaryota	61.2	1.37e-7	NR	CAF0726212.1	433720	g6082	i0	38.2	2.51101321585903	76	46	50.2	1	17	244	1395	1469	CAF0726212.1 unnamed protein product [Adineta steineri]	diamond	1140	61.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
27974600	27974600	PRJNA1002816_P_NODE_18525_length_248_cov_0.880000_g18365_i0	PRJNA1002816	18525	248	0.88	2.1824	Adineta	104781	Rotifera	other_Eukaryota	83.2	4.9e-17	NR	UJR22668.1	104782	g18365	i0	48.8	10.8629032258065	82	39	95.6	2	239	3	109	190	UJR22668.1 hypothetical protein I4U23_025707 [Adineta vaga]	diamond	2694	83.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
28171440	28171440	PRJNA1002816_P_NODE_11566_length_326_cov_1.584980_g11406_i0	PRJNA1002816	11566	326	1.58498	5.1670348	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	79.3	1.39e-14	NR	CAF0758546.1	104777	g11406	i0	38	0.993865030674847	108	66	98.5	1	321	1	261	368	CAF0758546.1 unnamed protein product [Brachionus calyciflorus]	diamond	324	79.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
28234380	28234380	PRJNA1002816_P_NODE_14606_length_285_cov_1.566038_g14446_i0	PRJNA1002816	14606	285	1.566038	4.4632083	Rotaria socialis	392032	Rotifera	other_Eukaryota	51.6	4.84e-5	NR	CAF3340476.1	392032	g14446	i0	54.8	0.884210526315789	42	19	44.2	0	2	127	43	84	CAF3340476.1 unnamed protein product [Rotaria socialis]	diamond	252	51.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
28360792	28360792	PRJNA1002816_P_NODE_20546_length_242_cov_0.911243_g20386_i0	PRJNA1002816	20546	242	0.911243	2.20520806	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	58.5	9.98e-8	NR	CAF4297060.1	2762512	g20386	i0	54.7	3.17355371900826	64	18	70.7	2	227	57	512	571	CAF4297060.1 unnamed protein product, partial [Rotaria sp. Silwood2]	diamond	768	58.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
31765310	31765310	PRJNA1002816_P_NODE_14757_length_283_cov_1.900000_g14597_i0	PRJNA1002816	14757	283	1.9	5.377	Metazoa	33208	Rotifera	other_Eukaryota	51.6	1.85e-5	NR	RMZ95943.1	10195	g14597	i0	75.8	1.43109540636042	33	8	35	0	113	15	31	63	RMZ95943.1 partner of Y14 and mago [Brachionus plicatilis]	diamond	405	51.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis

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