metadata: contig_metadata: 11 rows where bioproject = "PRJNA1120771", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJNA1120771", 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
1551097	1551097	PRJNA1120771_S_NODE_12762_length_308_cov_4.467925_g12362_i0	PRJNA1120771	12762	308	4.467925	13.761209	Brachionus angularis	396692	Rotifera	other_Eukaryota	121	7.769999999999999e-23	NTclustered	gi\|2029759144\|gb\|MW026576.1\|	396692	g12362	i0	81.944	1	144	24	46	2	166	308	2301	2159	Brachionus angularis ATP-binding cassette transporter Abcb10-like mRNA, complete cds	blastn	308	121	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
5379718	5379718	PRJNA1120771_S_NODE_1725_length_666_cov_38.295345_g1416_i0	PRJNA1120771	1725	666	38.295345	255.0469977	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	1.14e-22	NR	QUF59414.1	396692	g1416	i0	36.5	1.55855855855856	170	92	71.2	4	7	480	30	195	QUF59414.1 glutathione S-transferase GSTS10 [Brachionus angularis]	diamond	1038	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
27006699	27006699	PRJNA1120771_S_NODE_23102_length_247_cov_2.132353_g22702_i0	PRJNA1120771	23102	247	2.132353	5.26691191	Adineta ricciae	249248	Rotifera	other_Eukaryota	55.1	1.29e-6	NR	CAF0820463.1	249248	g22702	i0	42.1	1.44534412955466	57	32	69.2	1	235	65	193	248	CAF0820463.1 unnamed protein product [Adineta ricciae]	diamond	357	55.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28922405	28922405	PRJNA1120771_S_NODE_34148_length_210_cov_2.389222_g33748_i0	PRJNA1120771	34148	210	2.389222	5.0173662	root	1	Root_unresolved	Root_unresolved	79.3	1.02e-16	NR	CAF0758534.1	433720	g33748	i0	76.6	6.08571428571429	47	11	67.1	0	2	142	105	151	CAF0758534.1 unnamed protein product [Adineta steineri]	diamond	1278	79.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29564726	29564726	PRJNA1120771_S_NODE_25790_length_236_cov_2.704663_g25390_i0	PRJNA1120771	25790	236	2.704663	6.38300468	Adineta steineri	433720	Rotifera	other_Eukaryota	43.1	0.0223	NR	CAF1270204.1	433720	g25390	i0	37.7	2.9364406779661	77	39	97.9	2	1	231	168	235	CAF1270204.1 unnamed protein product [Adineta steineri]	diamond	693	43.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29754079	29754079	PRJNA1120771_S_NODE_33671_length_211_cov_3.107143_g33271_i0	PRJNA1120771	33671	211	3.107143	6.55607173	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	104	4.07e-24	NR	RNA19155.1	10195	g33271	i0	66.7	5.90047393364929	69	23	98.1	0	1	207	458	526	RNA19155.1 beta-hexosaminidase subunit alpha-like [Brachionus plicatilis]	diamond	1245	104	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
29869814	29869814	PRJNA1120771_S_NODE_11091_length_324_cov_2.167260_g10691_i0	PRJNA1120771	11091	324	2.16726	7.0219224	Rotifera	10190	Rotifera	other_Eukaryota	114	6.800000000000001e-27	NR	AGK45629.1	104777	g10691	i0	70	3.98148148148148	80	24	74.1	0	1	240	561	640	AGK45629.1 heat shock protein 70 [Brachionus calyciflorus]	diamond	1290	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
30196299	30196299	PRJNA1120771_S_NODE_26372_length_234_cov_1.267016_g25972_i0	PRJNA1120771	26372	234	1.267016	2.96481744	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	48.5	2.37e-4	NR	CAF3326011.1	2762512	g25972	i0	30.6	0.923076923076923	72	47	91	2	220	8	161	230	CAF3326011.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	216	48.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
30891728	30891728	PRJNA1120771_S_NODE_11814_length_317_cov_2.222628_g11414_i0	PRJNA1120771	11814	317	2.222628	7.04573076	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	58.5	4.83e-8	NR	RMZ94228.1	10195	g11414	i0	38.2	2.36593059936909	76	46	71	1	34	258	56	131	RMZ94228.1 leucine-rich repeat-containing 34-like isoform X1 [Brachionus plicatilis]	diamond	750	58.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
30912589	30912589	PRJNA1120771_S_NODE_2694_length_548_cov_3.695050_g2329_i0	PRJNA1120771	2694	548	3.69505	20.248874	Rotaria	231623	Rotifera	other_Eukaryota	52	2.84e-4	NR	CAF5106261.1	392030	g2329	i0	48.8	1.19890510948905	43	22	23.5	0	548	420	204	246	CAF5106261.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	657	52	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
32156687	32156687	PRJNA1120771_S_NODE_35718_length_205_cov_2.685185_g35318_i0	PRJNA1120771	35718	205	2.685185	5.50462925	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	53.1	4.69e-6	NR	RNA14324.1	10195	g35318	i0	59.6	0.760975609756098	52	18	74.6	2	3	155	148	197	RNA14324.1 glycerol kinase 5 [Brachionus plicatilis]	diamond	156	53.1	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);;