metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA478247" 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
19573557	19573557	PRJNA478247_P_NODE_1996_length_247_cov_2.123853_g1890_i0	PRJNA478247	1996	247	2.123853	5.24591691	Eurotatoria	2816136	Rotifera	other_Eukaryota	147	2.64e-41	NR	CAF0725690.1	249248	g1890	i0	84.1	12.9230769230769	82	13	99.6	0	2	247	173	254	CAF0725690.1 unnamed protein product [Adineta ricciae]	diamond	3192	148	0.993243243243243	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
26902715	26902715	PRJNA478247_P_NODE_1841_length_261_cov_2.172414_g1735_i0	PRJNA478247	1841	261	2.172414	5.67000054	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87	1.6e-18	NR	RNA15448.1	10195	g1735	i0	58.2	2.33333333333333	67	28	77	0	3	203	189	255	RNA15448.1 fibroblast growth factor receptor-like [Brachionus plicatilis]	diamond	609	87	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
28687144	28687144	PRJNA478247_P_NODE_207_length_1083_cov_2.680266_g153_i0	PRJNA478247	207	1083	2.680266	29.02728078	Rotaria magnacalcarata	392030	Rotifera	other_Eukaryota	132	1.85e-31	NR	CAF1044290.1	392030	g153	i0	46.8	0.390581717451524	141	73	38.5	2	664	1080	218	358	CAF1044290.1 unnamed protein product [Rotaria magnacalcarata]	diamond	423	132	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria magnacalcarata
29129142	29129142	PRJNA478247_P_NODE_3149_length_170_cov_1.787234_g3043_i0	PRJNA478247	3149	170	1.787234	3.0382978	Rotaria sordida	392033	Rotifera	other_Eukaryota	55.1	5.81e-7	NR	CAF1149722.1	392033	g3043	i0	38.9	1.90588235294118	54	31	91.8	1	3	158	32	85	CAF1149722.1 unnamed protein product [Rotaria sordida]	diamond	324	55.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
29902949	29902949	PRJNA478247_P_NODE_2071_length_240_cov_2.796209_g1965_i0	PRJNA478247	2071	240	2.796209	6.7109016	Opisthokonta	33154	Rotifera	other_Eukaryota	100	1.18e-25	NR	UJR16804.1	104782	g1965	i0	60.2	4.3125	93	23	98.8	2	239	3	8	100	UJR16804.1 hypothetical protein I4U23_003703 [Adineta vaga]	diamond	1035	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30676434	30676434	PRJNA478247_P_NODE_1213_length_354_cov_1.603077_g1107_i0	PRJNA478247	1213	354	1.603077	5.67489258	Adineta steineri	433720	Rotifera	other_Eukaryota	53.5	2.7e-6	NR	CAF1161157.1	433720	g1107	i0	41.8	0.466101694915254	55	32	46.6	0	1	165	12	66	CAF1161157.1 unnamed protein product [Adineta steineri]	diamond	165	53.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
31640907	31640907	PRJNA478247_P_NODE_476_length_652_cov_7.224719_g383_i0	PRJNA478247	476	652	7.224719	47.10516788	Rotaria	231623	Rotifera	other_Eukaryota	97.8	4.35e-22	NR	CAF3323269.1	392032	g383	i0	41.4	2.5398773006135	140	63	63	4	482	72	3	126	CAF3323269.1 unnamed protein product [Rotaria socialis]	diamond	1656	98.2	0.995926680244399	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
31735709	31735709	PRJNA478247_P_NODE_2817_length_189_cov_1.781250_g2711_i0	PRJNA478247	2817	189	1.78125	3.3665625	Metazoa	33208	Rotifera	other_Eukaryota	67.4	3.05e-11	NR	CAF4109690.1	392033	g2711	i0	50	6.92063492063492	62	28	98.4	2	3	188	23	81	CAF4109690.1 unnamed protein product, partial [Rotaria sordida]	diamond	1308	67.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sordida
32762896	32762896	PRJNA478247_P_NODE_3400_length_159_cov_1.292308_g3294_i0	PRJNA478247	3400	159	1.292308	2.05476972	Rotaria sordida	392033	Rotifera	other_Eukaryota	55.5	3.78e-7	NR	CAF1276628.1	392033	g3294	i0	42.2	3.39622641509434	45	26	84.9	0	146	12	99	143	CAF1276628.1 unnamed protein product [Rotaria sordida]	diamond	540	55.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);;