metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax

23 rows where analysis = "blastn", bioproject = "PRJEB2925" 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
1300301	1300301	PRJEB2925_P_NODE_10622_length_348_cov_2.293930_g9350_i0	PRJEB2925	10622	348	2.29393	7.9828764	Adineta ricciae	249248	Rotifera	other_Eukaryota	555	2.0599999999999994e-153	NTclustered	gi\|62362191\|gb\|AY942835.1\|	249248	g9350	i0	95.402	1.35344827586207	348	16	100	0	1	348	221	568	Adineta ricciae ribosomal protein L18a-like protein mRNA, complete cds	blastn	471	555	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
1300343	1300343	PRJEB2925_P_NODE_1482_length_1565_cov_23.488889_g1092_i0	PRJEB2925	1482	1565	23.488889	367.60111285	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	1216	0	NTclustered	gi\|2778092484\|gb\|PP988072.1\|	3231738	g1092	i0	81.039	50.9725239616613	1540	280	98	10	14	1544	25	1561	Asplanchna sp. chromosome II mitochondrion, complete sequence	blastn	79772	1216	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
1300456	1300456	PRJEB2925_P_NODE_9882_length_370_cov_2.982090_g8610_i0	PRJEB2925	9882	370	2.98209	11.033733	Adineta vaga	104782	Rotifera	other_Eukaryota	359	1.85e-94	NTclustered	gi\|187233667\|gb\|EU643500.1\|	104782	g8610	i0	85.965	5.86216216216216	342	40	91	8	3	337	341	1	Adineta vaga ribosomal protein L11 mRNA, partial cds	blastn	2169	359	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
3852268	3852268	PRJEB2925_P_NODE_3664_length_743_cov_15.579096_g2817_i0	PRJEB2925	3664	743	15.579096	115.75268328	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	769	0	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g2817	i0	85.389	18.9179004037685	746	103	100	6	1	743	25	767	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	14056	769	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
6404338	6404338	PRJEB2925_P_NODE_4006_length_701_cov_3.662162_g3114_i0	PRJEB2925	4006	701	3.662162	25.67175562	Adineta ricciae	249248	Rotifera	other_Eukaryota	1197	0	NTclustered	gi\|62362195\|gb\|AY942837.1\|	249248	g3114	i0	98.954	0.95435092724679	669	7	95	0	33	701	683	15	Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds	blastn	669	1197	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
7678288	7678288	PRJEB2925_P_NODE_10487_length_352_cov_2.340694_g9215_i0	PRJEB2925	10487	352	2.340694	8.23924288	Adineta ricciae	249248	Rotifera	other_Eukaryota	316	1.0699999999999999e-81	NTclustered	gi\|37675448\|gb\|AY394701.1\|	249248	g9215	i0	93.81	42.2613636363636	210	13	60	0	141	350	396	605	Adineta ricciae 82kD heat-shock protein gene (hsp82), partial sequence	blastn	14876	316	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
8953058	8953058	PRJEB2925_P_NODE_11468_length_325_cov_3.062069_g10193_i0	PRJEB2925	11468	325	3.062069	9.95172425	Adineta vaga	104782	Rotifera	other_Eukaryota	230	1.3099999999999995e-55	NTclustered	gi\|187936040\|gb\|EU652315.1\|	104782	g10193	i0	95.172	6.23384615384615	145	7	72	0	181	325	17445	17301	Adineta vaga speckle-type POZ protein gene, partial cds; and adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, arginine vasopressin receptor, filament protein, and nucleolar complex associated-like protein genes, complete cds	blastn	2026	230	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
8953141	8953141	PRJEB2925_P_NODE_5348_length_581_cov_26.258242_g4312_i0	PRJEB2925	5348	581	26.258242	152.56038602	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	538	3.61e-148	NTclustered	gi\|402761729\|gb\|JX183996.1\|	104788	g4312	i0	84.888	2.12908777969019	536	77	92	3	2	535	97	630	Macrotrachela quadricornifera isolate CR ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial	blastn	1237	538	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
11504186	11504186	PRJEB2925_P_NODE_3830_length_724_cov_195.296081_g2959_i0	PRJEB2925	3830	724	195.296081	1413.94362644	Philodina citrina	468664	Rotifera	other_Eukaryota	721	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2959	i0	85.434	21.4972375690608	714	80	97	21	21	724	2393	1694	Philodina citrina complete mitochondrial genome	blastn	15564	721	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
12779605	12779605	PRJEB2925_P_NODE_1171_length_2068_cov_10.296606_g882_i0	PRJEB2925	1171	2068	10.296606	212.93381208	Brachionus rubens	392764	Rotifera	other_Eukaryota	652	0	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g882	i0	80.322	20.4555125725338	869	165	42	5	293	1158	866	1	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	42302	652	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
13741568	13741568	PRJEB2925_P_NODE_3411_length_781_cov_13.040214_g2613_i0	PRJEB2925	3411	781	13.040214	101.84407134	Eurotatoria	2816136	Rotifera	other_Eukaryota	678	0	NTclustered	gi\|402761803\|gb\|JX184033.1\|	104782	g2613	i0	82.94	14.4878361075544	762	120	97	9	25	781	1	757	Adineta vaga NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	11315	680	0.997058823529412	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
13741573	13741573	PRJEB2925_P_NODE_3871_length_719_cov_16.619883_g2998_i0	PRJEB2925	3871	719	16.619883	119.49695877	Adineta	104781	Rotifera	other_Eukaryota	1301	0	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g2998	i0	99.305	47.2461752433936	719	5	100	0	1	719	2241	1523	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	33970	1301	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
14054235	14054235	PRJEB2925_P_NODE_1532_length_1503_cov_21.588556_g1131_i0	PRJEB2925	1532	1503	21.588556	324.47599668	Brachionus rubens	392764	Rotifera	other_Eukaryota	673	0	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g1131	i0	75.408	13.6926147704591	1472	319	96	37	14	1461	5618	7070	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	20580	673	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
14054303	14054303	PRJEB2925_P_NODE_6212_length_526_cov_5.099796_g5106_i0	PRJEB2925	6212	526	5.099796	26.82492696	Adineta vaga	104782	Rotifera	other_Eukaryota	586	1.1399999999999995e-162	NTclustered	gi\|189313895\|gb\|EU637017.1\|	104782	g5106	i0	87.189	8.23574144486692	523	57	98	7	1	515	35534	36054	Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds	blastn	4332	586	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
14054318	14054318	PRJEB2925_P_NODE_7532_length_459_cov_4.903302_g6341_i0	PRJEB2925	7532	459	4.903302	22.50615618	Adineta ricciae	249248	Rotifera	other_Eukaryota	396	1.79e-105	NTclustered	gi\|62362193\|gb\|AY942836.1\|	249248	g6341	i0	87.906	0.738562091503268	339	38	73	2	1	336	21	359	Adineta ricciae 60S ribosomal protein L37-like protein mRNA, complete cds	blastn	339	396	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
14054322	14054322	PRJEB2925_P_NODE_7812_length_448_cov_3.394673_g6603_i0	PRJEB2925	7812	448	3.394673	15.20813504	Adineta vaga	104782	Rotifera	other_Eukaryota	387	1.05e-102	NTclustered	gi\|1277393744\|gb\|MF448337.1\|	104782	g6603	i0	88.037	1.30803571428571	326	39	73	0	1	326	721	1046	Adineta vaga omega-3 desaturase-like 1 mRNA, complete cds	blastn	586	387	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
19151711	19151711	PRJEB2925_P_NODE_8956_length_402_cov_3.277929_g7695_i0	PRJEB2925	8956	402	3.277929	13.17727458	Adineta vaga	104782	Rotifera	other_Eukaryota	326	2.0599999999999997e-84	NTclustered	gi\|1277393744\|gb\|MF448337.1\|	104782	g7695	i0	91.525	1.17412935323383	236	20	59	0	167	402	956	721	Adineta vaga omega-3 desaturase-like 1 mRNA, complete cds	blastn	472	326	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
19151719	19151719	PRJEB2925_P_NODE_9576_length_380_cov_7.805797_g8305_i0	PRJEB2925	9576	380	7.805797	29.6620286	Adineta vaga	104782	Rotifera	other_Eukaryota	678	0	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g8305	i0	99.464	4.69736842105263	373	2	98	0	8	380	10398	10026	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	1785	678	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
20426796	20426796	PRJEB2925_P_NODE_15657_length_252_cov_3.497696_g14379_i0	PRJEB2925	15657	252	3.497696	8.81419392	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	296	9.56e-76	NTclustered	gi\|1899127713\|gb\|MT965963.1\|	231624	g14379	i0	99.387	64.6626984126984	163	1	65	0	1	163	267	429	Rotaria rotatoria isolate WX19_1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, region	blastn	16295	296	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
21702854	21702854	PRJEB2925_P_NODE_3418_length_780_cov_3.942282_g2620_i0	PRJEB2925	3418	780	3.942282	30.7497996	Adineta vaga	104782	Rotifera	other_Eukaryota	608	3.699999999999998e-169	NTclustered	gi\|187233667\|gb\|EU643500.1\|	104782	g2620	i0	87.013	10.1948717948718	539	70	69	0	83	621	91	629	Adineta vaga ribosomal protein L11 mRNA, partial cds	blastn	7952	608	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
22978124	22978124	PRJEB2925_P_NODE_4799_length_623_cov_5.093537_g3817_i0	PRJEB2925	4799	623	5.093537	31.73273551	Adineta vaga	104782	Rotifera	other_Eukaryota	715	0	NTclustered	gi\|187233665\|gb\|EU643499.1\|	104782	g3817	i0	95.526	0.717495987158908	447	20	72	0	169	615	447	1	Adineta vaga ribosomal protein L26 mRNA, partial cds	blastn	447	715	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
24251931	24251931	PRJEB2925_P_NODE_4600_length_640_cov_12.056198_g3643_i0	PRJEB2925	4600	640	12.056198	77.1596672	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	651	0	NTclustered	gi\|402761761\|gb\|JX184012.1\|	104788	g3643	i0	85.285	26.5265625	632	91	99	2	2	632	21	651	Macrotrachela quadricornifera isolate CR cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	16977	651	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
25214162	25214162	PRJEB2925_P_NODE_2380_length_1022_cov_15.707194_g1766_i0	PRJEB2925	2380	1022	15.707194	160.52752268	Eurotatoria	2816136	Rotifera	other_Eukaryota	1077	0	NTclustered	gi\|402761787\|gb\|JX184025.1\|	104782	g1766	i0	85.841	23.7671232876712	1017	140	99	4	1	1015	72	1086	Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	24290	1077	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga

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