metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA771359" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA771359" 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
8400292	8400292	PRJNA771359_S_NODE_4927_length_154_cov_0.982906_g4844_i0	PRJNA771359	4927	154	0.982906	1.51367524	Eurotatoria	2816136	Rotifera	other_Eukaryota	99.4	1.66e-24	NR	CAF5053526.1	392030	g4844	i0	88.2	6.95454545454545	51	6	99.4	0	1	153	109	159	CAF5053526.1 unnamed protein product, partial [Rotaria magnacalcarata]	diamond	1071	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
28063958	28063958	PRJNA771359_S_NODE_4365_length_162_cov_1.552000_g4282_i0	PRJNA771359	4365	162	1.552	2.51424	Adineta ricciae	249248	Rotifera	other_Eukaryota	92.4	3.82e-20	NR	CAF1063687.1	249248	g4282	i0	100	0.851851851851852	46	0	85.2	0	23	160	1	46	CAF1063687.1 unnamed protein product [Adineta ricciae]	diamond	138	92.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28736626	28736626	PRJNA771359_S_NODE_5267_length_150_cov_1.035398_g5184_i0	PRJNA771359	5267	150	1.035398	1.553097	Adineta	104781	Rotifera	other_Eukaryota	102	7.13e-24	NR	UJR15252.1	104782	g5184	i0	87.8	4.9	49	6	98	0	148	2	834	882	UJR15252.1 hypothetical protein I4U23_002207 [Adineta vaga]	diamond	735	102	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
28916266	28916266	PRJNA771359_S_NODE_2748_length_202_cov_2.339394_g2665_i0	PRJNA771359	2748	202	2.339394	4.72557588	Adineta ricciae	249248	Rotifera	other_Eukaryota	88.2	1.8e-18	NR	CAF1006388.1	249248	g2665	i0	86	1.48514851485149	50	7	74.3	0	200	51	341	390	CAF1006388.1 unnamed protein product [Adineta ricciae]	diamond	300	88.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
29642388	29642388	PRJNA771359_S_NODE_4930_length_154_cov_0.965812_g4847_i0	PRJNA771359	4930	154	0.965812	1.48735048	Adineta ricciae	249248	Rotifera	other_Eukaryota	80.9	3.64e-16	NR	CAF1014340.1	249248	g4847	i0	84.3	0.993506493506494	51	8	99.4	0	154	2	89	139	CAF1014340.1 unnamed protein product [Adineta ricciae]	diamond	153	80.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31412161	31412161	PRJNA771359_S_NODE_1076_length_320_cov_1.650177_g993_i0	PRJNA771359	1076	320	1.650177	5.2805664	Adineta ricciae	249248	Rotifera	other_Eukaryota	197	6.15e-59	NR	CAF1006388.1	249248	g993	i0	94.3	0.99375	106	6	99.4	0	320	3	56	161	CAF1006388.1 unnamed protein product [Adineta ricciae]	diamond	318	197	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32108036	32108036	PRJNA771359_S_NODE_2918_length_196_cov_1.861635_g2835_i0	PRJNA771359	2918	196	1.861635	3.6488046	Rotaria sordida	392033	Rotifera	other_Eukaryota	55.1	1.46e-7	NR	CAF3862678.1	392033	g2835	i0	74.5	0.780612244897959	51	9	71.9	2	196	56	79	129	CAF3862678.1 unnamed protein product [Rotaria sordida]	diamond	153	55.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
32708468	32708468	PRJNA771359_S_NODE_5180_length_151_cov_1.298246_g5097_i0	PRJNA771359	5180	151	1.298246	1.96035146	Adineta ricciae	249248	Rotifera	other_Eukaryota	70.1	3.07e-14	NR	CAF1125922.1	249248	g5097	i0	70	1.98675496688742	50	15	99.3	0	2	151	10	59	CAF1125922.1 unnamed protein product [Adineta ricciae]	diamond	300	70.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);;