metadata: contig_metadata: 10 rows where bioproject = "PRJNA509429", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA509429", tax_clade = "Opisthokonta" 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
1110780	1110780	PRJNA509429_P_NODE_37101_length_191_cov_4.307692_g36273_i0	PRJNA509429	37101	191	4.307692	8.22769172	Eurotatoria	2816136	Rotifera	other_Eukaryota	353	4.02e-93	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g36273	i0	100	97.6544502617801	191	0	100	0	1	191	502	692	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	18652	353	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
1110784	1110784	PRJNA509429_P_NODE_38881_length_185_cov_1.106667_g38053_i0	PRJNA509429	38881	185	1.106667	2.04733395	Rotaria	231623	Rotifera	other_Eukaryota	217	5.29e-52	NTclustered	gi\|109892408\|gb\|DQ656783.1\|	231624	g38053	i0	87.766	86.827027027027	188	19	100	4	1	185	202	388	Rotaria rotatoria isolate IT.6 28S ribosomal RNA gene, partial sequence	blastn	16063	217	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
3036322	3036322	PRJNA509429_P_NODE_36603_length_193_cov_2.974684_g35775_i0	PRJNA509429	36603	193	2.974684	5.74114012	Adineta vaga	104782	Rotifera	other_Eukaryota	302	1.5e-77	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g35775	i0	97.714	2.82901554404145	175	4	91	0	19	193	10398	10224	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	546	302	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
3036362	3036362	PRJNA509429_P_NODE_44723_length_167_cov_1.053030_g43895_i0	PRJNA509429	44723	167	1.05303	1.7585601	Ascomorpha ovalis	360655	Rotifera	other_Eukaryota	187	3.68e-43	NTclustered	gi\|83285183\|gb\|DQ297730.1\|	360655	g43895	i0	86.905	4.80838323353293	168	21	100	1	1	167	471	638	Ascomorpha ovalis 28S ribosomal RNA gene, partial sequence	blastn	803	187	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Gastropidae	Ascomorpha	Ascomorpha ovalis
3662037	3662037	PRJNA509429_P_NODE_39343_length_183_cov_1.986486_g38515_i0	PRJNA509429	39343	183	1.986486	3.63526938	Eurotatoria	2816136	Rotifera	other_Eukaryota	331	1.79e-86	NTclustered	gi\|2537903788\|gb\|KM043253.2\|	104782	g38515	i0	100	80.7486338797814	179	0	98	0	5	183	1	179	Adineta vaga voucher AD006 18S ribosomal RNA gene, partial sequence	blastn	14777	331	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
11964018	11964018	PRJNA509429_P_NODE_43990_length_169_cov_1.156716_g43162_i0	PRJNA509429	43990	169	1.156716	1.95485004	Proales doliaris	360695	Rotifera	other_Eukaryota	141	2.93e-29	NTclustered	gi\|83285206\|gb\|DQ297753.1\|	360695	g43162	i0	81.871	2.0414201183432	171	27	99	3	2	168	50	220	Proales doliaris 28S ribosomal RNA gene, partial sequence	blastn	345	141	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales doliaris
11964050	11964050	PRJNA509429_P_NODE_51130_length_151_cov_2.293103_g50302_i0	PRJNA509429	51130	151	2.293103	3.46258553	Euchlanis alata	338269	Rotifera	other_Eukaryota	239	8.81e-59	NTclustered	gi\|83655555\|gb\|DQ079942.1\|	338269	g50302	i0	97.826	9.49006622516556	138	3	91	0	1	138	430	567	Euchlanis alata 28S ribosomal RNA gene, partial sequence	blastn	1433	239	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Euchlanis	Euchlanis alata
20887344	20887344	PRJNA509429_P_NODE_42157_length_174_cov_2.014388_g41329_i0	PRJNA509429	42157	174	2.014388	3.50503512	Philodina roseola	96448	Rotifera	other_Eukaryota	255	1.04e-63	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g41329	i0	93.143	5.0632183908046	175	11	100	1	1	174	590	416	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	881	255	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
22161969	22161969	PRJNA509429_P_NODE_21818_length_283_cov_5.879032_g20990_i0	PRJNA509429	21818	283	5.879032	16.63766056	Adineta vaga complex sp. B JFF-2016	1813165	Rotifera	other_Eukaryota	507	4.64e-139	NTclustered	gi\|1005055631\|gb\|KU860774.1\|	1813165	g20990	i0	98.94	26.3851590106007	283	3	100	0	1	283	1724	1442	Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence	blastn	7467	507	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga complex sp. B JFF-2016
32889590	32889590	PRJNA509429_P_NODE_33440_length_207_cov_1.459302_g32612_i0	PRJNA509429	33440	207	1.459302	3.02075514	Adineta steineri	433720	Rotifera	other_Eukaryota	42.7	0.0219	NR	CAF4191730.1	433720	g32612	i0	42.5	1.73913043478261	40	22	56.5	1	38	154	207	246	CAF4191730.1 unnamed protein product [Adineta steineri]	diamond	360	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);;