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

8 rows where analysis = "diamond", bioproject = "PRJNA807685" 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
28064881	28064881	PRJNA807685_P_NODE_61825_length_156_cov_1.621849_g60752_i0	PRJNA807685	61825	156	1.621849	2.53008444	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	44.7	0.00248	NR	CAF0969125.1	1234261	g60752	i0	36	2.82692307692308	50	32	96.2	0	4	153	37	86	CAF0969125.1 unnamed protein product [Didymodactylos carnosus]	diamond	441	44.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
28326183	28326183	PRJNA807685_P_NODE_24226_length_272_cov_2.127660_g23153_i0	PRJNA807685	24226	272	2.12766	5.7872352	Metazoa	33208	Rotifera	other_Eukaryota	85.1	6.57e-17	NR	CAF1649129.1	392030	g23153	i0	43.7	1.95220588235294	87	48	94.9	1	10	267	492	578	CAF1649129.1 unnamed protein product [Rotaria magnacalcarata]	diamond	531	85.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
28601760	28601760	PRJNA807685_P_NODE_50387_length_172_cov_1.355556_g49314_i0	PRJNA807685	50387	172	1.355556	2.33155632	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	50.4	2.75e-5	NR	CAF3306315.1	2762512	g49314	i0	52.2	0.802325581395349	46	22	80.2	0	138	1	344	389	CAF3306315.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	138	50.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
29715302	29715302	PRJNA807685_P_NODE_26530_length_255_cov_2.178899_g25457_i0	PRJNA807685	26530	255	2.178899	5.55619245	Eurotatoria	2816136	Rotifera	other_Eukaryota	59.3	6e-8	NR	CAF1507876.1	249248	g25457	i0	44.3	10.4588235294118	70	38	82.4	1	1	210	164	232	CAF1507876.1 unnamed protein product [Adineta ricciae]	diamond	2667	59.7	0.993299832495812	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30126023	30126023	PRJNA807685_P_NODE_40332_length_193_cov_2.480769_g39259_i0	PRJNA807685	40332	193	2.480769	4.78788417	Adineta	104781	Rotifera	other_Eukaryota	42.4	0.0148	NR	CAF1196226.1	249248	g39259	i0	39.1	3.01554404145078	64	37	96.4	1	6	191	23	86	CAF1196226.1 unnamed protein product [Adineta ricciae]	diamond	582	42.7	0.992974238875878	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
30568277	30568277	PRJNA807685_P_NODE_50433_length_172_cov_1.162963_g49360_i0	PRJNA807685	50433	172	1.162963	2.00029636	Eurotatoria	2816136	Rotifera	other_Eukaryota	52	7.86e-6	NR	CAF1272202.1	249248	g49360	i0	49.1	4.98837209302326	57	23	97.7	2	168	1	563	614	CAF1272202.1 unnamed protein product [Adineta ricciae]	diamond	858	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
31855759	31855759	PRJNA807685_P_NODE_50237_length_172_cov_1.740741_g49164_i0	PRJNA807685	50237	172	1.740741	2.99407452	Adineta vaga	104782	Rotifera	other_Eukaryota	51.2	1.35e-5	NR	UJR21359.1	104782	g49164	i0	70.4	0.47093023255814	27	8	47.1	0	172	92	57	83	UJR21359.1 hypothetical protein I4U23_024451 [Adineta vaga]	diamond	81	51.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
32646085	32646085	PRJNA807685_P_NODE_37120_length_203_cov_1.789157_g36047_i0	PRJNA807685	37120	203	1.789157	3.63198871	Adineta steineri	433720	Rotifera	other_Eukaryota	52.4	8.84e-6	NR	CAF1222037.1	433720	g36047	i0	46.3	0.990147783251232	67	31	99	2	1	201	327	388	CAF1222037.1 unnamed protein product [Adineta steineri]	diamond	201	52.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri

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