metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA763243" 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
5846949	5846949	PRJNA763243_P_NODE_44365_length_266_cov_3.145078_g44019_i0	PRJNA763243	44365	266	3.145078	8.36590748	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	139	9.749999999999999e-40	NR	RNA13848.1	10195	g44019	i0	74.1	0.913533834586466	81	20	91.4	1	8	250	85	164	RNA13848.1 peptidyl-prolyl cis-trans isomerase [Brachionus plicatilis]	diamond	243	139	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
18594610	18594610	PRJNA763243_P_NODE_26855_length_314_cov_2.307054_g26509_i0	PRJNA763243	26855	314	2.307054	7.24414956	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	88.2	9.36e-18	NR	CAF2139880.1	392030	g26509	i0	46.9	0.936305732484076	98	50	93.6	2	16	309	29	124	CAF2139880.1 unnamed protein product [Rotaria magnacalcarata]	diamond	294	88.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
27947289	27947289	PRJNA763243_P_NODE_68185_length_228_cov_2.077419_g67839_i0	PRJNA763243	68185	228	2.077419	4.73651532	Eurotatoria	2816136	Rotifera	other_Eukaryota	99	4.2099999999999996e-23	NR	CAF0784306.1	249248	g67839	i0	69.7	4.38157894736842	66	20	86.8	0	223	26	26	91	CAF0784306.1 unnamed protein product [Adineta ricciae]	diamond	999	100	0.99	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
28095435	28095435	PRJNA763243_P_NODE_38405_length_281_cov_1.394231_g38059_i0	PRJNA763243	38405	281	1.394231	3.91778911	Adineta steineri	433720	Rotifera	other_Eukaryota	50.8	8.78e-5	NR	CAF3813850.1	433720	g38059	i0	45.7	2.59430604982206	81	41	83.3	3	42	275	1949	2029	CAF3813850.1 unnamed protein product [Adineta steineri]	diamond	729	50.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29042853	29042853	PRJNA763243_P_NODE_49288_length_256_cov_1.207650_g48942_i0	PRJNA763243	49288	256	1.20765	3.091584	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	69.3	1.86e-11	NR	CAF4294673.1	2762512	g48942	i0	48.6	3.36328125	72	36	83.2	1	233	21	314	385	CAF4294673.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	861	69.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
29683481	29683481	PRJNA763243_P_NODE_70890_length_216_cov_4.825175_g70544_i0	PRJNA763243	70890	216	4.825175	10.422378	Eurotatoria	2816136	Rotifera	other_Eukaryota	48.9	1.65e-4	NR	CAF0858903.1	392033	g70544	i0	48	2.86111111111111	50	24	69.4	1	164	15	10	57	CAF0858903.1 unnamed protein product [Rotaria sordida]	diamond	618	48.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
29800362	29800362	PRJNA763243_P_NODE_47731_length_259_cov_1.494624_g47385_i0	PRJNA763243	47731	259	1.494624	3.87107616	Adineta steineri	433720	Rotifera	other_Eukaryota	66.6	1.33e-10	NR	CAF4273345.1	433720	g47385	i0	72.1	0.498069498069498	43	12	49.8	0	256	128	1	43	CAF4273345.1 unnamed protein product, partial [Adineta steineri]	diamond	129	66.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
30621767	30621767	PRJNA763243_P_NODE_65593_length_236_cov_2.748466_g65247_i0	PRJNA763243	65593	236	2.748466	6.48637976	Adineta steineri	433720	Rotifera	other_Eukaryota	51.2	8.99e-6	NR	CAF1525794.1	433720	g65247	i0	51.1	0.572033898305085	45	22	57.2	0	161	27	31	75	CAF1525794.1 unnamed protein product, partial [Adineta steineri]	diamond	135	51.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
32234785	32234785	PRJNA763243_P_NODE_11218_length_451_cov_3.582011_g10875_i0	PRJNA763243	11218	451	3.582011	16.15486961	Adineta ricciae	249248	Rotifera	other_Eukaryota	96.7	5.53e-20	NR	CAF1108276.1	249248	g10875	i0	56.5	1.68292682926829	85	36	55.9	1	271	20	2	86	CAF1108276.1 unnamed protein product, partial [Adineta ricciae]	diamond	759	96.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
32551198	32551198	PRJNA763243_P_NODE_35539_length_289_cov_1.384259_g35193_i0	PRJNA763243	35539	289	1.384259	4.00050851	Rotaria sordida	392033	Rotifera	other_Eukaryota	70.5	1.17e-11	NR	CAF1119553.1	392033	g35193	i0	45.2	3.86159169550173	93	46	96.5	2	4	282	11	98	CAF1119553.1 unnamed protein product [Rotaria sordida]	diamond	1116	70.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida

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