metadata: contig_metadata: 10 rows where bioproject = "PRJNA558770", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA558770", tax_kingdom = "Metazoa" 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
3681120	3681120	PRJNA558770_P_NODE_378343_length_224_cov_5.910053_g376338_i0	PRJNA558770	378343	224	5.910053	13.23851872	Rotaria	231623	Rotifera	other_Eukaryota	407	3.69e-109	NTclustered	gi\|2537903863\|gb\|KF561105.2\|	392034	g376338	i0	99.552	99.5714285714286	223	1	99	0	1	223	757	535	Rotaria tardigrada isolate A535_RT1 18S ribosomal RNA gene, partial sequence	blastn	22304	407	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria tardigrada
11333063	11333063	PRJNA558770_P_NODE_391629_length_171_cov_3.147059_g389624_i0	PRJNA558770	391629	171	3.147059	5.38147089	Eurotatoria	2816136	Rotifera	other_Eukaryota	305	9.96e-79	NTclustered	gi\|2537903787\|gb\|KM043252.2\|	104782	g389624	i0	98.83	92.2456140350877	171	2	100	0	1	171	218	48	Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence	blastn	15774	305	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
24081833	24081833	PRJNA558770_P_NODE_395359_length_159_cov_2.766129_g393354_i0	PRJNA558770	395359	159	2.766129	4.39814511	Brachionidae	10193	Rotifera	other_Eukaryota	158	2.71e-34	NTclustered	gi\|308156997\|gb\|GQ890462.1\|	204742	g393354	i0	85.161	22.0754716981132	155	21	97	2	1	155	618	466	Keratella quadrata isolate DNA198 large subunit ribosomal RNA gene, partial sequence	blastn	3510	158	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Keratella	Keratella quadrata
28292983	28292983	PRJNA558770_P_NODE_268706_length_234_cov_1.934673_g266701_i0	PRJNA558770	268706	234	1.934673	4.52713482	Eurotatoria	2816136	Rotifera	other_Eukaryota	60.8	1.37e-8	NR	CAF0932393.1	249248	g266701	i0	52.2	7.07692307692308	69	8	88.5	1	208	2	833	876	CAF0932393.1 unnamed protein product [Adineta ricciae]	diamond	1656	60.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
29005679	29005679	PRJNA558770_P_NODE_258328_length_234_cov_2.130653_g256323_i0	PRJNA558770	258328	234	2.130653	4.98572802	Adineta ricciae	249248	Rotifera	other_Eukaryota	50.1	9.1e-5	NR	CAF0991433.1	249248	g256323	i0	91.7	1.84615384615385	24	2	30.8	0	4	75	758	781	CAF0991433.1 unnamed protein product [Adineta ricciae]	diamond	432	50.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
29131716	29131716	PRJNA558770_P_NODE_285829_length_234_cov_1.643216_g283824_i0	PRJNA558770	285829	234	1.643216	3.84512544	Adineta steineri	433720	Rotifera	other_Eukaryota	43.1	0.0221	NR	CAF3927617.1	433720	g283824	i0	79.2	0.923076923076923	24	5	30.8	0	232	161	208	231	CAF3927617.1 unnamed protein product [Adineta steineri]	diamond	216	43.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta steineri
29320913	29320913	PRJNA558770_P_NODE_190389_length_234_cov_4.170854_g188384_i0	PRJNA558770	190389	234	4.170854	9.75979836	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	42	0.0359	NR	CAF5028870.1	2762511	g188384	i0	72	0.320512820512821	25	7	32.1	0	75	1	102	126	CAF5028870.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	75	42	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
30268798	30268798	PRJNA558770_P_NODE_230652_length_234_cov_2.783920_g228647_i0	PRJNA558770	230652	234	2.78392	6.5143728	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	51.6	2.6e-5	NR	CAF0736138.1	104777	g228647	i0	72	0.320512820512821	25	7	32.1	0	1	75	1532	1556	CAF0736138.1 unnamed protein product [Brachionus calyciflorus]	diamond	75	51.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
31610007	31610007	PRJNA558770_P_NODE_187836_length_234_cov_4.276382_g185831_i0	PRJNA558770	187836	234	4.276382	10.00673388	root	1	Root_unresolved	Root_unresolved	48.9	2.19e-4	NR	CAF0875192.1	104777	g185831	i0	87.5	9.28205128205128	24	3	30.8	0	3	74	201	224	CAF0875192.1 unnamed protein product [Brachionus calyciflorus]	diamond	2172	48.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
32576763	32576763	PRJNA558770_P_NODE_109739_length_234_cov_10.623116_g107734_i0	PRJNA558770	109739	234	10.623116	24.85809144	Adineta steineri	433720	Rotifera	other_Eukaryota	42.7	0.0247	NR	CAF4377476.1	433720	g107734	i0	72	0.320512820512821	25	7	32.1	0	233	159	11	35	CAF4377476.1 unnamed protein product, partial [Adineta steineri]	diamond	75	42.7	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);;