metadata: contig_metadata: 9 rows where bioproject = "PRJNA893346", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA893346", 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
16171086	16171086	PRJNA893346_P_NODE_3433_length_881_cov_17.569307_g3042_i0	PRJNA893346	3433	881	17.569307	154.78559467	Rotaria sordida	392033	Rotifera	other_Eukaryota	252	1.01e-76	NR	CAF1213640.1	392033	g3042	i0	47.5	8.04653802497162	284	141	94.3	6	50	880	195	477	CAF1213640.1 unnamed protein product [Rotaria sordida]	diamond	7089	252	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
27442910	27442910	PRJNA893346_P_NODE_38263_length_243_cov_0.905882_g37773_i0	PRJNA893346	38263	243	0.905882	2.20129326	Adineta	104781	Rotifera	other_Eukaryota	93.6	3.46e-20	NR	CAF0889629.1	249248	g37773	i0	53.1	5.01234567901235	81	36	100	1	1	243	177	255	CAF0889629.1 unnamed protein product [Adineta ricciae]	diamond	1218	93.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28066286	28066286	PRJNA893346_P_NODE_27125_length_290_cov_0.820276_g26635_i0	PRJNA893346	27125	290	0.820276	2.3788004	Adineta vaga	104782	Rotifera	other_Eukaryota	60.1	1.89e-8	NR	UJR36368.1	104782	g26635	i0	61.9	0.920689655172414	42	16	43.4	0	128	3	64	105	UJR36368.1 hypothetical protein I4U23_029093 [Adineta vaga]	diamond	267	60.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
28603177	28603177	PRJNA893346_P_NODE_27327_length_288_cov_1.534884_g26837_i0	PRJNA893346	27327	288	1.534884	4.42046592	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	117	1.69e-29	NR	CAF0711637.1	104777	g26837	i0	63.2	1.97916666666667	95	34	99	1	3	287	73	166	CAF0711637.1 unnamed protein product [Brachionus calyciflorus]	diamond	570	117	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
29360909	29360909	PRJNA893346_P_NODE_29349_length_276_cov_1.093596_g28859_i0	PRJNA893346	29349	276	1.093596	3.01832496	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	63.5	2.64e-9	NR	CAF2093130.1	392030	g28859	i0	39.6	3.96739130434783	91	55	98.9	0	4	276	186	276	CAF2093130.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	1095	63.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
29707730	29707730	PRJNA893346_P_NODE_35010_length_248_cov_1.577143_g34520_i0	PRJNA893346	35010	248	1.577143	3.91131464	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	73.2	7.36e-13	NR	CAF0900939.1	104777	g34520	i0	46.1	0.919354838709677	76	37	89.5	2	22	243	304	377	CAF0900939.1 unnamed protein product [Brachionus calyciflorus]	diamond	228	73.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
31192652	31192652	PRJNA893346_P_NODE_16615_length_380_cov_2.019544_g16127_i0	PRJNA893346	16615	380	2.019544	7.6742672	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	44.3	0.0426	NR	CAF5123904.1	2762511	g16127	i0	36.6	1.68157894736842	71	45	56.1	0	152	364	156	226	CAF5123904.1 unnamed protein product, partial [Rotaria sp. Silwood1]	diamond	639	44.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
31675119	31675119	PRJNA893346_P_NODE_18217_length_362_cov_1.875433_g17728_i0	PRJNA893346	18217	362	1.875433	6.78906746	Eurotatoria	2816136	Rotifera	other_Eukaryota	87	3.9e-18	NR	UJR20457.1	104782	g17728	i0	66.7	2.9585635359116	57	19	47.2	0	176	6	55	111	UJR20457.1 hypothetical protein I4U23_023586 [Adineta vaga]	diamond	1071	87	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
31825458	31825458	PRJNA893346_P_NODE_34677_length_249_cov_0.875000_g34187_i0	PRJNA893346	34677	249	0.875	2.17875	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	47	4.88e-4	NR	CAF0795827.1	1234261	g34187	i0	34.1	2.13253012048193	85	53	98.8	2	248	3	12	96	CAF0795827.1 unnamed protein product [Didymodactylos carnosus]	diamond	531	47	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus

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