metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax

28 rows where analysis = "blastn", bioproject = "PRJEB14664" 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
1295351	1295351	PRJEB14664_P_NODE_142_length_2030_cov_4.596491_g127_i0	PRJEB14664	142	2030	4.596491	93.3087673	Philodina roseola	96448	Rotifera	other_Eukaryota	2004	0	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g127	i0	84.665	78.0911330049261	2028	291	99	15	1	2024	25981	27992	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	158525	2004	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
1295356	1295356	PRJEB14664_P_NODE_14882_length_184_cov_1.234899_g14752_i0	PRJEB14664	14882	184	1.234899	2.27221416	Philodina roseola	96448	Rotifera	other_Eukaryota	110	9.18e-20	NTclustered	gi\|183178964\|gb\|EU432549.1\|	96448	g14752	i0	88.043	1	92	11	50	0	90	181	1148	1239	Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_3), 7 transmembrane receptor (rhodopsin family) B (7tmrB_3), transmembrane receptor (rhodopsin family) C (7tmrC_3), 7 transmembrane receptor (rhodopsin family) D (7tmrD_3), myosin essential light chain (MELC_3), ArkA_3 (arkA_3), ArkB_3 (arkB_3), ArkC_3 (arkC_3), TRPA_3 (TPRA_3), 82 kDa heat shock protein (hsp82_3), LicD_3 (LicD_3), low density lipoprotein receptor (LDL_3), Zn carboxypeptidase gene (Zncarb_3), phosphoribosylaminoimidazole carboxylase (PAICS_3), unknown (PrPCG0002_3), lung-like 7 transmembrane receptor (lung_3), and phosphoglycerate-bisphosphoglycerate mutase (PGAM_3) genes, complete cds	blastn	184	110	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
3847487	3847487	PRJEB14664_P_NODE_6404_length_325_cov_5.634483_g6274_i0	PRJEB14664	6404	325	5.634483	18.31206975	Philodina roseola	96448	Rotifera	other_Eukaryota	241	6.070000000000001e-59	NTclustered	gi\|146157253\|gb\|EF484997.1\|	96448	g6274	i0	91.765	2.00923076923077	170	14	77	0	86	255	170	1	Philodina roseola clone Pr_TEL_B telomeric repeat and subterminal DNA junction	blastn	653	241	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
5123594	5123594	PRJEB14664_P_NODE_1645_length_720_cov_15.632117_g1545_i0	PRJEB14664	1645	720	15.632117	112.5512424	Philodina citrina	468664	Rotifera	other_Eukaryota	880	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1545	i0	88.828	23.5486111111111	725	69	99	10	2	720	2392	1674	Philodina citrina complete mitochondrial genome	blastn	16955	880	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
5123637	5123637	PRJEB14664_P_NODE_2285_length_607_cov_2.643357_g2173_i0	PRJEB14664	2285	607	2.643357	16.04517699	Philodina citrina	468664	Rotifera	other_Eukaryota	311	8.98e-80	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2173	i0	90.948	1.61779242174629	232	20	38	1	368	599	3538	3768	Philodina citrina complete mitochondrial genome	blastn	982	311	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
5123643	5123643	PRJEB14664_P_NODE_2945_length_528_cov_7.679513_g2825_i0	PRJEB14664	2945	528	7.679513	40.54782864	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	595	1.9099999999999994e-165	NTclustered	gi\|62362199\|gb\|AY942839.1\|	317012	g2825	i0	87.945	20.9299242424242	506	53	95	5	1	499	19	523	Philodina sp. NPS-2005 S14e ribosomal protein-like protein mRNA, complete cds	blastn	11051	595	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
6399289	6399289	PRJEB14664_P_NODE_12926_length_202_cov_1.700599_g12796_i0	PRJEB14664	12926	202	1.700599	3.43520998	Adineta ricciae	249248	Rotifera	other_Eukaryota	261	2.68e-65	NTclustered	gi\|403492560\|gb\|JX193019.1\|	249248	g12796	i0	96.226	18.7376237623762	159	6	100	0	1	159	862	1020	Adineta ricciae isolate AU.1.2 alpha tubulin gene, partial cds	blastn	3785	261	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
6399382	6399382	PRJEB14664_P_NODE_2766_length_546_cov_3.984344_g2649_i0	PRJEB14664	2766	546	3.984344	21.75451824	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	442	2.729999999999999e-119	NTclustered	gi\|62362199\|gb\|AY942839.1\|	317012	g2649	i0	85.246	2.25091575091575	427	63	78	0	1	427	97	523	Philodina sp. NPS-2005 S14e ribosomal protein-like protein mRNA, complete cds	blastn	1229	442	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
6399421	6399421	PRJEB14664_P_NODE_626_length_1143_cov_6.647112_g566_i0	PRJEB14664	626	1143	6.647112	75.97649016	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	828	0	NTclustered	gi\|62362203\|gb\|AY942841.1\|	317012	g566	i0	90.806	2.56342957130359	620	55	54	2	525	1143	639	21	Philodina sp. NPS-2005 guanine nucleotide binding protein beta polypeptide 2-like 1 mRNA, partial cds	blastn	2930	828	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
7673388	7673388	PRJEB14664_P_NODE_15087_length_182_cov_1.564626_g14957_i0	PRJEB14664	15087	182	1.564626	2.84761932	Adineta vaga	104782	Rotifera	other_Eukaryota	135	1.4900000000000002e-27	NTclustered	gi\|402761803\|gb\|JX184033.1\|	104782	g14957	i0	81.437	0.917582417582418	167	30	91	1	17	182	30	196	Adineta vaga NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial	blastn	167	135	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
11499222	11499222	PRJEB14664_P_NODE_16950_length_168_cov_1.714286_g16820_i0	PRJEB14664	16950	168	1.714286	2.88000048	Philodina sp. NPS-2005	317012	Rotifera	other_Eukaryota	233	4.7e-57	NTclustered	gi\|62362201\|gb\|AY942840.1\|	317012	g16820	i0	91.667	1	168	14	100	0	1	168	246	413	Philodina sp. NPS-2005 fba1-like protein mRNA, partial cds	blastn	168	233	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina sp. NPS-2005
12774879	12774879	PRJEB14664_P_NODE_8811_length_264_cov_1.567686_g8681_i0	PRJEB14664	8811	264	1.567686	4.13869104	Adineta vaga	104782	Rotifera	other_Eukaryota	270	6.119999999999999e-68	NTclustered	gi\|187233667\|gb\|EU643500.1\|	104782	g8681	i0	87.029	6.04545454545455	239	31	91	0	1	239	391	629	Adineta vaga ribosomal protein L11 mRNA, partial cds	blastn	1596	270	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
14049376	14049376	PRJEB14664_P_NODE_312_length_1500_cov_7.324915_g277_i0	PRJEB14664	312	1500	7.324915	109.873725	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	1807	0	NTclustered	gi\|402761741\|gb\|JX184002.1\|	104786	g277	i0	88.408	48.3313333333333	1501	172	100	2	1	1500	26	1525	Habrotrocha constricta cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial	blastn	72497	1807	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
15323450	15323450	PRJEB14664_P_NODE_6653_length_318_cov_1.664311_g6523_i0	PRJEB14664	6653	318	1.664311	5.29250898	Adineta ricciae	249248	Rotifera	other_Eukaryota	366	9.37e-97	NTclustered	gi\|62362193\|gb\|AY942836.1\|	249248	g6523	i0	87.898	1.9748427672956	314	35	98	2	1	311	46	359	Adineta ricciae 60S ribosomal protein L37-like protein mRNA, complete cds	blastn	628	366	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
16597988	16597988	PRJEB14664_P_NODE_14194_length_190_cov_1.548387_g14064_i0	PRJEB14664	14194	190	1.548387	2.9419353	Adineta vaga	104782	Rotifera	other_Eukaryota	252	1.4999999999999998e-62	NTclustered	gi\|402761787\|gb\|JX184025.1\|	104782	g14064	i0	90.526	1	190	18	100	0	1	190	71	260	Adineta vaga cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	190	252	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
16598042	16598042	PRJEB14664_P_NODE_1874_length_674_cov_4.366197_g1767_i0	PRJEB14664	1874	674	4.366197	29.42816778	Philodina roseola	96448	Rotifera	other_Eukaryota	702	0	NTclustered	gi\|183178964\|gb\|EU432549.1\|	96448	g1767	i0	91.313	3.22255192878338	518	39	99	4	4	518	20065	19551	Philodina roseola 7 transmembrane receptor (rhodopsin family) A (7tmrA_3), 7 transmembrane receptor (rhodopsin family) B (7tmrB_3), transmembrane receptor (rhodopsin family) C (7tmrC_3), 7 transmembrane receptor (rhodopsin family) D (7tmrD_3), myosin essential light chain (MELC_3), ArkA_3 (arkA_3), ArkB_3 (arkB_3), ArkC_3 (arkC_3), TRPA_3 (TPRA_3), 82 kDa heat shock protein (hsp82_3), LicD_3 (LicD_3), low density lipoprotein receptor (LDL_3), Zn carboxypeptidase gene (Zncarb_3), phosphoribosylaminoimidazole carboxylase (PAICS_3), unknown (PrPCG0002_3), lung-like 7 transmembrane receptor (lung_3), and phosphoglycerate-bisphosphoglycerate mutase (PGAM_3) genes, complete cds	blastn	2172	702	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
17872752	17872752	PRJEB14664_P_NODE_11215_length_223_cov_2.558511_g11085_i0	PRJEB14664	11215	223	2.558511	5.70547953	Philodina roseola	96448	Rotifera	other_Eukaryota	206	1.44e-48	NTclustered	gi\|209867673\|gb\|EU637021.1\|	96448	g11085	i0	86.631	0.838565022421525	187	24	84	1	35	221	32678	32863	Philodina roseola hypothetical proteins, CNNOS1-like protein, hypothetical protein, MyoD-like protein, hypothetical protein, YTH domain family member 1-like protein, hypothetical protein, cell division cycle protein 123-like protein, hypothetical protein, Hox-6a, ubiquinol-cytochrome c reductase-like protein, hypothetical protein, G protein-coupled receptor-like protein, hypothetical protein, TPR repeat containing protein-like protein, hypothetical protein, exportin 5-like protein, zinc finger protein Cezanne-like protein, hypothetical protein, StAR-related lipid transfer (START) domain containing protein-like protein, and hypothetical protein genes, complete cds; and unknown gene	blastn	187	206	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
17872844	17872844	PRJEB14664_P_NODE_2535_length_574_cov_6.682746_g2421_i0	PRJEB14664	2535	574	6.682746	38.35896204	Philodina citrina	468664	Rotifera	other_Eukaryota	531	5.969999999999999e-146	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g2421	i0	83.392	2.01742160278746	572	95	99	0	1	572	10967	10396	Philodina citrina complete mitochondrial genome	blastn	1158	531	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
19146765	19146765	PRJEB14664_P_NODE_4396_length_416_cov_1.587927_g4268_i0	PRJEB14664	4396	416	1.587927	6.60577632	Philodina roseola	96448	Rotifera	other_Eukaryota	276	2.18e-69	NTclustered	gi\|209867673\|gb\|EU637021.1\|	96448	g4268	i0	85.338	0.959134615384615	266	39	96	0	2	267	32952	33217	Philodina roseola hypothetical proteins, CNNOS1-like protein, hypothetical protein, MyoD-like protein, hypothetical protein, YTH domain family member 1-like protein, hypothetical protein, cell division cycle protein 123-like protein, hypothetical protein, Hox-6a, ubiquinol-cytochrome c reductase-like protein, hypothetical protein, G protein-coupled receptor-like protein, hypothetical protein, TPR repeat containing protein-like protein, hypothetical protein, exportin 5-like protein, zinc finger protein Cezanne-like protein, hypothetical protein, StAR-related lipid transfer (START) domain containing protein-like protein, and hypothetical protein genes, complete cds; and unknown gene	blastn	399	276	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
19146805	19146805	PRJEB14664_P_NODE_7536_length_293_cov_1.279070_g7406_i0	PRJEB14664	7536	293	1.27907	3.7476751	Adineta ricciae	249248	Rotifera	other_Eukaryota	392	1.41e-104	NTclustered	gi\|62362191\|gb\|AY942835.1\|	249248	g7406	i0	90.785	1	293	27	100	0	1	293	590	298	Adineta ricciae ribosomal protein L18a-like protein mRNA, complete cds	blastn	293	392	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
20421927	20421927	PRJEB14664_P_NODE_3197_length_503_cov_5.292735_g3074_i0	PRJEB14664	3197	503	5.292735	26.62245705	Philodina citrina	468664	Rotifera	other_Eukaryota	492	2.44e-134	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g3074	i0	84.493	15.8926441351889	503	72	99	6	4	503	10253	9754	Philodina citrina complete mitochondrial genome	blastn	7994	492	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
21697888	21697888	PRJEB14664_P_NODE_14918_length_183_cov_4.040541_g14788_i0	PRJEB14664	14918	183	4.040541	7.39419003	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	128	2.52e-25	NTclustered	gi\|218117251\|emb\|AM980954.1\|	10195	g14788	i0	84.328	3.81420765027322	134	18	72	3	12	143	1	133	Brachionus plicatilis partial mRNA for 60S ribosomal protein L37a, (RPL37a gene)	blastn	698	128	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
21698002	21698002	PRJEB14664_P_NODE_8678_length_267_cov_1.616379_g8548_i0	PRJEB14664	8678	267	1.616379	4.31573193	Philodina citrina	468664	Rotifera	other_Eukaryota	154	6.51e-33	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g8548	i0	80.184	0.812734082397004	217	33	79	9	57	267	11549	11337	Philodina citrina complete mitochondrial genome	blastn	217	154	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
22973200	22973200	PRJEB14664_P_NODE_2099_length_633_cov_5.073579_g1990_i0	PRJEB14664	2099	633	5.073579	32.11575507	Philodina citrina	468664	Rotifera	other_Eukaryota	721	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1990	i0	87.322	45.7503949447077	631	78	99	2	2	631	5753	5124	Philodina citrina complete mitochondrial genome	blastn	28960	721	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
24246951	24246951	PRJEB14664_P_NODE_11440_length_220_cov_2.097297_g11310_i0	PRJEB14664	11440	220	2.097297	4.6140534	Adineta ricciae	249248	Rotifera	other_Eukaryota	390	3.629999999999999e-104	NTclustered	gi\|62362195\|gb\|AY942837.1\|	249248	g11310	i0	98.636	1	220	3	100	0	1	220	27	246	Adineta ricciae ribosomal protein S7-like protein mRNA, complete cds	blastn	220	390	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
24246994	24246994	PRJEB14664_P_NODE_1660_length_718_cov_1.923865_g1559_i0	PRJEB14664	1660	718	1.923865	13.8133507	Philodina roseola	96448	Rotifera	other_Eukaryota	562	2.68e-155	NTclustered	gi\|572455682\|gb\|KF159020.1\|	96448	g1559	i0	84.892	47.8857938718663	556	84	77	0	163	718	1	556	Philodina roseola myosin heavy chain type II mRNA, partial cds	blastn	34382	562	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
24247019	24247019	PRJEB14664_P_NODE_18740_length_157_cov_1.967213_g18610_i0	PRJEB14664	18740	157	1.967213	3.08852441	Philodina roseola	96448	Rotifera	other_Eukaryota	169	1.23e-37	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g18610	i0	85.987	87.9235668789809	157	22	100	0	1	157	26612	26456	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	13804	169	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
24247127	24247127	PRJEB14664_P_NODE_900_length_966_cov_4.190118_g828_i0	PRJEB14664	900	966	4.190118	40.47653988	Philodina roseola	96448	Rotifera	other_Eukaryota	658	0	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g828	i0	88.214	4.53209109730849	560	55	88	10	257	806	35023	34465	Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds	blastn	4378	658	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola

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