metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA675331" 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
647612	647612	PRJNA675331_P_NODE_11241_length_300_cov_1.409692_g11069_i0	PRJNA675331	11241	300	1.409692	4.229076	Brachionus ibericus	183141	Rotifera	other_Eukaryota	235	2.5799999999999997e-57	NTclustered	gi\|400179592\|gb\|JX239236.1\|	183141	g11069	i0	81.188	8.58333333333333	303	48	98	1	7	300	941	639	Brachionus ibericus isolate GRKOR003 mate recognition protein motif repeat B (mmr-b) gene, partial cds	blastn	2575	235	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus ibericus
647716	647716	PRJNA675331_P_NODE_601_length_1124_cov_11.695528_g493_i0	PRJNA675331	601	1124	11.695528	131.45773472	Brachionus rubens	392764	Rotifera	other_Eukaryota	1177	0	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g493	i0	86.007	41.5364768683274	1122	130	99	26	4	1114	11833	10728	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	46687	1177	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
1923880	1923880	PRJNA675331_P_NODE_2242_length_613_cov_3.766667_g2076_i0	PRJNA675331	2242	613	3.766667	23.08966871	Brachionus rubens	392764	Rotifera	other_Eukaryota	440	1.1099999999999996e-118	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g2076	i0	80	18.4127243066884	610	110	99	12	2	605	18	621	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	11287	440	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
1923881	1923881	PRJNA675331_P_NODE_22522_length_243_cov_1.811765_g22350_i0	PRJNA675331	22522	243	1.811765	4.40258895	Brachionus angularis	396692	Rotifera	other_Eukaryota	226	1.2199999999999999e-54	NTclustered	gi\|1999716433\|gb\|MT875425.1\|	396692	g22350	i0	84.348	0.946502057613169	230	36	95	0	10	239	248	19	Brachionus angularis chromosome I mitochondrion, complete sequence	blastn	230	226	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
4475786	4475786	PRJNA675331_P_NODE_304_length_1541_cov_11.213215_g229_i0	PRJNA675331	304	1541	11.213215	172.79564315	Brachionus angularis	396692	Rotifera	other_Eukaryota	996	0	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g229	i0	79.451	42.9695003244646	1421	280	92	12	12	1426	28	1442	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	66216	996	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
5751257	5751257	PRJNA675331_P_NODE_1005_length_889_cov_2.634804_g867_i0	PRJNA675331	1005	889	2.634804	23.42340756	Brachionus rubens	392764	Rotifera	other_Eukaryota	390	1.67e-103	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g867	i0	76.75	16.2114735658043	757	141	83	30	150	889	11079	11817	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	14412	390	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
5751272	5751272	PRJNA675331_P_NODE_13885_length_276_cov_2.275862_g13713_i0	PRJNA675331	13885	276	2.275862	6.28137912	Brachionus rubens	392764	Rotifera	other_Eukaryota	326	1.35e-84	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g13713	i0	88.235	70.3297101449275	272	32	99	0	3	274	385	656	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	19411	326	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
7026435	7026435	PRJNA675331_P_NODE_2786_length_558_cov_2.608247_g2618_i0	PRJNA675331	2786	558	2.608247	14.55401826	Brachionus rubens	392764	Rotifera	other_Eukaryota	442	2.789999999999999e-119	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g2618	i0	82.156	47.5448028673835	538	74	94	18	11	537	11309	11835	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	26530	442	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
7026460	7026460	PRJNA675331_P_NODE_7146_length_363_cov_1.296552_g6974_i0	PRJNA675331	7146	363	1.296552	4.70648376	Anuraeopsis fissa	885374	Rotifera	other_Eukaryota	486	7.959999999999998e-133	NTclustered	gi\|308156986\|gb\|GQ890451.1\|	885374	g6974	i0	91.484	60.2038567493113	364	15	100	7	1	363	150	498	Anuraeopsis fissa isolate DNA97 large subunit ribosomal RNA gene, partial sequence	blastn	21854	486	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Anuraeopsis	Anuraeopsis fissa
8301037	8301037	PRJNA675331_P_NODE_1187_length_827_cov_1.805040_g1039_i0	PRJNA675331	1187	827	1.80504	14.9276808	Brachionus rubens	392764	Rotifera	other_Eukaryota	760	0	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g1039	i0	83.353	10.8295042321644	835	125	100	12	1	827	5962	6790	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	8956	760	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
8301095	8301095	PRJNA675331_P_NODE_18807_length_250_cov_0.870056_g18635_i0	PRJNA675331	18807	250	0.870056	2.17514	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	246	9.679999999999999e-61	NTclustered	gi\|1199073741\|gb\|KX119432.1\|	104777	g18635	i0	84.524	1.008	252	35	100	3	1	250	703	454	Brachionus calyciflorus S6 kinase mRNA, complete cds	blastn	252	246	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
9576368	9576368	PRJNA675331_P_NODE_4548_length_445_cov_2.043011_g4376_i0	PRJNA675331	4548	445	2.043011	9.09139895	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	239	3.08e-58	NTclustered	gi\|218117265\|emb\|AM980960.1\|	10195	g4376	i0	79.412	1.42696629213483	340	68	76	2	80	418	13	351	Brachionus plicatilis partial mRNA for 40S ribosomal protein S20, (RPS20 gene)	blastn	635	239	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
9576369	9576369	PRJNA675331_P_NODE_4588_length_444_cov_1.210243_g4416_i0	PRJNA675331	4588	444	1.210243	5.37347892	Brachionus ibericus	183141	Rotifera	other_Eukaryota	274	8.42e-69	NTclustered	gi\|307640114\|gb\|GQ894772.1\|	183141	g4416	i0	81.737	0.752252252252252	334	54	74	6	58	386	152	483	Brachionus ibericus isolate Sm5 ATPase F0 subunit 6 (atp6) gene, partial cds; tRNA-Asp gene, complete sequence; and large ribosomal RNA subunit (rrnL) gene, partial sequence; mitochondrial	blastn	334	274	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus ibericus
11372079	11372079	PRJNA675331_P_NODE_21149_length_246_cov_0.890173_g20977_i0	PRJNA675331	21149	246	0.890173	2.18982558	Brachionus	10194	Rotifera	other_Eukaryota	104	6.05e-18	NTclustered	gi\|2106370087\|gb\|MZ706951.1\|	104777	g20977	i0	77.249	12.1178861788618	189	36	76	6	28	213	7105	7289	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	2981	104	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
11372090	11372090	PRJNA675331_P_NODE_589_length_1136_cov_10.720602_g481_i0	PRJNA675331	589	1136	10.720602	121.78603872	Ploima	84394	Rotifera	other_Eukaryota	390	2.16e-103	NTclustered	gi\|1066800225\|gb\|KX364936.1\|	96890	g481	i0	79.725	35.4850352112676	582	85	50	30	560	1129	9500	10060	Brachionus rotundiformis chromosome I mitochondrion, complete sequence	blastn	40311	390	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
12127052	12127052	PRJNA675331_P_NODE_17630_length_253_cov_1.327778_g17458_i0	PRJNA675331	17630	253	1.327778	3.35927834	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	65.8	2.95e-6	NTclustered	gi\|1143271481\|gb\|KX822781.1\|	104777	g17458	i0	97.368	2.94071146245059	38	1	15	0	177	214	6956	6993	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	744	65.8	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
13401850	13401850	PRJNA675331_P_NODE_21831_length_245_cov_0.895349_g21659_i0	PRJNA675331	21831	245	0.895349	2.19360505	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	292	1.2e-74	NTclustered	gi\|218117242\|emb\|AM980950.1\|	10195	g21659	i0	88.43	0.987755102040816	242	28	99	0	1	242	109	350	Brachionus plicatilis partial mRNA for 60S ribosomal protein L22, (RPL22 gene)	blastn	242	292	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
13401861	13401861	PRJNA675331_P_NODE_311_length_1521_cov_2.898481_g236_i0	PRJNA675331	311	1521	2.898481	44.08589601	Brachionus angularis	396692	Rotifera	other_Eukaryota	1134	0	NTclustered	gi\|1999716438\|gb\|MT875426.1\|	396692	g236	i0	81.254	46.2452333990796	1419	252	93	13	12	1423	28	1439	Brachionus angularis chromosome II mitochondrion, complete sequence	blastn	70339	1134	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus angularis
14676788	14676788	PRJNA675331_P_NODE_10352_length_310_cov_1.949367_g10180_i0	PRJNA675331	10352	310	1.949367	6.0430377	Brachionus falcatus	392765	Rotifera	other_Eukaryota	237	7.450000000000001e-58	NTclustered	gi\|2615504969\|gb\|OR665529.1\|	392765	g10180	i0	81.915	49.4096774193548	282	49	91	2	27	307	7	287	Brachionus falcatus chromosome 2 mitochondrion, complete sequence	blastn	15317	237	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus falcatus
14676846	14676846	PRJNA675331_P_NODE_19492_length_249_cov_0.875000_g19320_i0	PRJNA675331	19492	249	0.875	2.17875	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	270	5.72e-68	NTclustered	gi\|469518013\|gb\|JX156086.1\|	104777	g19320	i0	88.106	5.59839357429719	227	27	91	0	3	229	1042	1268	Brachionus calyciflorus MCM3 (MCM3) gene, partial cds	blastn	1394	270	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
15197046	15197046	PRJNA675331_P_NODE_572_length_1155_cov_187.194085_g464_i0	PRJNA675331	572	1155	187.194085	2162.09168175	Brachionus	10194	Rotifera	other_Eukaryota	425	6.02e-114	NTclustered	gi\|1066800225\|gb\|KX364936.1\|	96890	g464	i0	80.656	34.2623376623377	579	86	49	25	8	578	10060	9500	Brachionus rotundiformis chromosome I mitochondrion, complete sequence	blastn	39573	425	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
15950525	15950525	PRJNA675331_P_NODE_4493_length_447_cov_5.962567_g4321_i0	PRJNA675331	4493	447	5.962567	26.65267449	Lepadella patella	231622	Rotifera	other_Eukaryota	621	2.6299999999999996e-173	NTclustered	gi\|83285192\|gb\|DQ297739.1\|	231622	g4321	i0	91.741	75.6599552572707	448	36	100	1	1	447	289	736	Lepadella patella 28S ribosomal RNA gene, partial sequence	blastn	33820	621	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lepadellidae	Lepadella	Lepadella patella
17225852	17225852	PRJNA675331_P_NODE_594_length_1131_cov_23.933837_g486_i0	PRJNA675331	594	1131	23.933837	270.69169647	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	433	3.519999999999999e-116	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g486	i0	75.461	14.2820512820513	1031	178	88	64	118	1112	1415	2406	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	16153	433	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
18499975	18499975	PRJNA675331_P_NODE_12155_length_291_cov_1.059633_g11983_i0	PRJNA675331	12155	291	1.059633	3.08353203	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	316	8.659999999999998e-82	NTclustered	gi\|484400308\|gb\|KC176715.1\|	104777	g11983	i0	87.636	4.23367697594502	275	31	93	2	20	291	2447	2173	Brachionus calyciflorus heat shock protein 90 (hsp90) mRNA, complete cds	blastn	1232	316	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
18499988	18499988	PRJNA675331_P_NODE_13955_length_276_cov_1.137931_g13783_i0	PRJNA675331	13955	276	1.137931	3.14068956	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	287	6.39e-73	NTclustered	gi\|259479127\|dbj\|AB491766.1\|	10195	g13783	i0	87.755	9.42028985507246	245	30	89	0	31	275	2	246	Brachionus plicatilis 14-3-3 mRNA for 14-3-3 protein, partial cds	blastn	2600	287	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
20294879	20294879	PRJNA675331_P_NODE_20316_length_247_cov_0.885057_g20144_i0	PRJNA675331	20316	247	0.885057	2.18609079	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.2	1.33e-4	NTclustered	gi\|1104767204\|gb\|KT989538.1\|	10195	g20144	i0	97.143	0.522267206477733	35	1	14	0	210	244	35	1	Brachionus plicatilis homeodomain transcription factor Hox2 (Hox2) mRNA, complete cds	blastn	129	60.2	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
21050289	21050289	PRJNA675331_P_NODE_19077_length_249_cov_1.312500_g18905_i0	PRJNA675331	19077	249	1.3125	3.268125	Encentrum astridae	360661	Rotifera	other_Eukaryota	411	3.2299999999999996e-110	NTclustered	gi\|124388846\|gb\|EF151006.1\|	360661	g18905	i0	96.386	89.4417670682731	249	9	100	0	1	249	2018	1770	Encentrum astridae 28S ribosomal RNA gene, partial sequence	blastn	22271	411	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Dicranophoridae	Encentrum	Encentrum astridae
22325126	22325126	PRJNA675331_P_NODE_16558_length_261_cov_1.223404_g16386_i0	PRJNA675331	16558	261	1.223404	3.19308444	Brachionus rotundiformis	96890	Rotifera	other_Eukaryota	171	6.3e-38	NTclustered	gi\|1066800225\|gb\|KX364936.1\|	96890	g16386	i0	79.498	5.55172413793103	239	49	92	0	4	242	7469	7707	Brachionus rotundiformis chromosome I mitochondrion, complete sequence	blastn	1449	171	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rotundiformis
22325188	22325188	PRJNA675331_P_NODE_678_length_1076_cov_5.940179_g564_i0	PRJNA675331	678	1076	5.940179	63.91632604	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	355	7.439999999999999e-93	NTclustered	gi\|170016231\|ref\|NC_010472.1\|	10195	g564	i0	78.909	17.4581784386617	550	96	50	17	533	1074	10365	10902	Brachionus plicatilis mitochondrion part I, complete genome	blastn	18785	355	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
23600619	23600619	PRJNA675331_P_NODE_5159_length_421_cov_0.795977_g4987_i0	PRJNA675331	5159	421	0.795977	3.35106317	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	213	1.76e-50	NTclustered	gi\|218117251\|emb\|AM980954.1\|	10195	g4987	i0	81.111	1.67933491686461	270	47	64	2	69	336	268	1	Brachionus plicatilis partial mRNA for 60S ribosomal protein L37a, (RPL37a gene)	blastn	707	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
24873888	24873888	PRJNA675331_P_NODE_18500_length_250_cov_1.327684_g18328_i0	PRJNA675331	18500	250	1.327684	3.31921	Brachionus koreanus	1199090	Rotifera	other_Eukaryota	257	4.47e-64	NTclustered	gi\|938514293\|gb\|KP405838.1\|	1199090	g18328	i0	85.656	0.976	244	35	98	0	1	244	347	590	Brachionus sp. 'koreanus' Na+/K+-ATPase alpha-subunit mRNA, complete cds	blastn	244	257	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus koreanus
24873925	24873925	PRJNA675331_P_NODE_560_length_1165_cov_17.015568_g453_i0	PRJNA675331	560	1165	17.015568	198.2313672	Brachionus rubens	392764	Rotifera	other_Eukaryota	431	1.31e-115	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g453	i0	80.699	34.3768240343348	601	76	51	24	551	1142	11257	11826	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	40049	431	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens

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