metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA922890" 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
27568989	27568989	PRJNA922890_P_NODE_71244_length_234_cov_0.884848_g70834_i0	PRJNA922890	71244	234	0.884848	2.07054432	Eurotatoria	2816136	Rotifera	other_Eukaryota	123	3.06e-33	NR	CAF1032429.1	249248	g70834	i0	93	6.42307692307692	71	5	91	0	20	232	1	71	CAF1032429.1 unnamed protein product [Adineta ricciae]	diamond	1503	123	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
27632282	27632282	PRJNA922890_P_NODE_82384_length_228_cov_1.823899_g81974_i0	PRJNA922890	82384	228	1.823899	4.15848972	Adineta	104781	Rotifera	other_Eukaryota	126	3.65e-33	NR	CAF0947129.1	249248	g81974	i0	86.2	3.42105263157895	65	9	85.5	0	197	3	142	206	CAF0947129.1 unnamed protein product [Adineta ricciae]	diamond	780	126	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
27720141	27720141	PRJNA922890_P_NODE_84204_length_228_cov_0.905660_g83794_i0	PRJNA922890	84204	228	0.90566	2.0649048	Adineta vaga	104782	Rotifera	other_Eukaryota	103	6.819999999999999e-24	NR	UJR18211.1	104782	g83794	i0	58.7	1.94736842105263	75	30	97.4	1	1	222	211	285	UJR18211.1 hypothetical protein I4U23_005112 [Adineta vaga]	diamond	444	103	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
28990190	28990190	PRJNA922890_P_NODE_82788_length_228_cov_0.918239_g82378_i0	PRJNA922890	82788	228	0.918239	2.09358492	Rotaria	231623	Rotifera	other_Eukaryota	81.3	8.25e-16	NR	CAF4108630.1	392030	g82378	i0	71.4	4.14473684210526	63	18	82.9	0	39	227	575	637	CAF4108630.1 unnamed protein product [Rotaria magnacalcarata]	diamond	945	81.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
30877727	30877727	PRJNA922890_P_NODE_75354_length_232_cov_0.895706_g74944_i0	PRJNA922890	75354	232	0.895706	2.07803792	Adineta ricciae	249248	Rotifera	other_Eukaryota	50.4	1.11e-5	NR	CAF1330988.1	249248	g74944	i0	88	0.646551724137931	25	3	32.3	0	231	157	92	116	CAF1330988.1 unnamed protein product [Adineta ricciae]	diamond	150	50.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32907612	32907612	PRJNA922890_P_NODE_81160_length_229_cov_0.912500_g80750_i0	PRJNA922890	81160	229	0.9125	2.089625	Eurotatoria	2816136	Rotifera	other_Eukaryota	112	5.05e-30	NR	UJR08324.1	104782	g80750	i0	68.4	6.96943231441048	76	23	99.6	1	1	228	27	101	UJR08324.1 hypothetical protein I4U23_012595 [Adineta vaga]	diamond	1596	112	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga

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