metadata: contig_metadata: 15 rows where bioproject = "PRJNA1233465", tax_kingdom = "Metazoa" and tax

15 rows where bioproject = "PRJNA1233465", 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
32933774	32933774	PRJNA1233465f_S_NODE_129961_length_213_cov_1.786585_g127681_i0	PRJNA1233465	129961	213	1.786585	3.80542605	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	63.9	3.71e-10	NR	RNA00284.1	10195	g127681	i0	59.6	0.802816901408451	57	23	80.3	0	8	178	124	180	RNA00284.1 beta [Brachionus plicatilis]	diamond	171	63.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32933925	32933925	PRJNA1233465f_S_NODE_175625_length_188_cov_0.863309_g173345_i0	PRJNA1233465	175625	188	0.863309	1.62302092	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	47	5.6e-4	NR	CAF1023833.1	1234261	g173345	i0	54.4	0.909574468085106	57	26	91	0	15	185	70	126	CAF1023833.1 unnamed protein product [Didymodactylos carnosus]	diamond	171	47	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
32934249	32934249	PRJNA1233465f_S_NODE_43233_length_341_cov_2.476027_g40953_i0	PRJNA1233465	43233	341	2.476027	8.44325207	Rotaria sp. Silwood1	2762511	Rotifera	other_Eukaryota	63.2	5.88e-9	NR	CAF3933222.1	2762511	g40953	i0	58.7	10.0645161290323	104	43	91.5	0	340	29	113	216	CAF3933222.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	3432	63.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
32940956	32940956	PRJNA1233465e_S_NODE_128889_length_174_cov_1.144000_g127579_i0	PRJNA1233465	128889	174	1.144	1.99056	Metazoa	33208	Rotifera	other_Eukaryota	54.3	6.32e-8	NR	RNA22471.1	10195	g127579	i0	57.1	1.68965517241379	49	21	84.5	0	26	172	1	49	RNA22471.1 hypothetical protein BpHYR1_008317 [Brachionus plicatilis]	diamond	294	54.7	0.992687385740402	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32950555	32950555	PRJNA1233465e_S_NODE_16946_length_409_cov_1.630556_g15644_i0	PRJNA1233465	16946	409	1.630556	6.66897404	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	85.9	1.93e-17	NR	RNA00284.1	10195	g15644	i0	59.8	0.601466992665037	82	33	60.1	0	113	358	99	180	RNA00284.1 beta [Brachionus plicatilis]	diamond	246	85.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32985212	32985212	PRJNA1233465f_S_NODE_13843_length_539_cov_2.740816_g11752_i0	PRJNA1233465	13843	539	2.740816	14.77299824	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	61.2	1.99e-7	NR	RNA22549.1	10195	g11752	i0	36.4	0.979591836734694	176	100	91.3	3	1	492	117	292	RNA22549.1 hypothetical protein BpHYR1_030886 [Brachionus plicatilis]	diamond	528	61.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
32985420	32985420	PRJNA1233465f_S_NODE_20499_length_461_cov_3.902913_g18274_i0	PRJNA1233465	20499	461	3.902913	17.99242893	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	77	7.56e-14	NR	RNA00284.1	10195	g18274	i0	56	0.546637744034707	84	37	54.7	0	130	381	97	180	RNA00284.1 beta [Brachionus plicatilis]	diamond	252	77	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
33069991	33069991	PRJNA1233465e_S_NODE_4725_length_677_cov_2.471338_g3676_i0	PRJNA1233465	4725	677	2.471338	16.73095826	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	74.3	4.67e-12	NR	RNA00284.1	10195	g3676	i0	58.1	0.327917282127031	74	31	32.8	0	437	658	99	172	RNA00284.1 beta [Brachionus plicatilis]	diamond	222	74.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
33085531	33085531	PRJNA1233465a_S_NODE_61598_length_274_cov_1.288889_g60324_i0	PRJNA1233465	61598	274	1.288889	3.53155586	Rotaria sp. Silwood2	2762512	Rotifera	other_Eukaryota	44.7	0.0117	NR	CAF2864394.1	2762512	g60324	i0	32.1	0.886861313868613	81	39	82.1	2	10	234	695	765	CAF2864394.1 unnamed protein product [Rotaria sp. Silwood2]	diamond	243	44.7	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood2
33086464	33086464	PRJNA1233465d_S_NODE_22142_length_345_cov_2.675676_g21031_i0	PRJNA1233465	22142	345	2.675676	9.2310822	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	76.6	3.01e-14	NR	RNA00284.1	10195	g21031	i0	56	0.730434782608696	84	37	73	0	54	305	97	180	RNA00284.1 beta [Brachionus plicatilis]	diamond	252	76.6	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
33111524	33111524	PRJNA1233465e_S_NODE_16494_length_413_cov_19.560440_g15192_i0	PRJNA1233465	16494	413	19.56044	80.7846172	Metazoa	33208	Rotifera	other_Eukaryota	44.3	0.0364	NR	RNA44825.1	10195	g15192	i0	57.6	2.42615012106538	59	25	42.9	0	92	268	125	183	RNA44825.1 40S ribosomal S9 [Brachionus plicatilis]	diamond	1002	44.3	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
33120374	33120374	PRJNA1233465d_S_NODE_110215_length_175_cov_2.317460_g109104_i0	PRJNA1233465	110215	175	2.31746	4.055555	Seison nebaliae	104778	Rotifera	other_Eukaryota	42.4	0.00924	NR	KAI3383784.1	104778	g109104	i0	90.5	11.5371428571429	21	2	36	0	175	113	32	52	KAI3383784.1 hypothetical protein SNEBB_008091 [Seison nebaliae]	diamond	2019	42.4	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Pararotatoria	Seisonacea	Seisonidae	Seison	Seison nebaliae
33120843	33120843	PRJNA1233465d_S_NODE_8551_length_506_cov_1.940919_g7491_i0	PRJNA1233465	8551	506	1.940919	9.82105014	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	45.8	0.0134	NR	RNA15979.1	10195	g7491	i0	41.7	0.355731225296443	60	35	35.6	0	173	352	85	144	RNA15979.1 hypothetical protein BpHYR1_050970 [Brachionus plicatilis]	diamond	180	45.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
33121488	33121488	PRJNA1233465f_S_NODE_104239_length_235_cov_1.086022_g101959_i0	PRJNA1233465	104239	235	1.086022	2.5521517	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	77	5.69e-15	NR	RNA00284.1	10195	g101959	i0	58.2	0.85531914893617	67	28	85.5	0	35	235	99	165	RNA00284.1 beta [Brachionus plicatilis]	diamond	201	77	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
33172443	33172443	PRJNA1233465e_S_NODE_27744_length_331_cov_4.280142_g26434_i0	PRJNA1233465	27744	331	4.280142	14.16727002	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	77	1.87e-14	NR	RNA00284.1	10195	g26434	i0	56	0.761329305135952	84	37	76.1	0	52	303	97	180	RNA00284.1 beta [Brachionus plicatilis]	diamond	252	77	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis

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