metadata: contig_metadata: 20 rows where bioproject = "PRJEB64798" and tax

20 rows where bioproject = "PRJEB64798" and tax_phylum = "Xenacoelomorpha"

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_order	tax_family	tax_genus	tax_species
3544251	3544251	PRJEB64798_P_NODE_76323_length_220_cov_12.988304_g74557_i0	PRJEB64798	76323	220	12.988304	28.5742688	Acoela	31265	Xenacoelomorpha	other_Eukaryota	124	4.07e-24	NTclustered	gi\|378781063\|emb\|FR837817.1\|	996693	g74557	i0	83.333	36.7954545454545	138	19	62	4	1	136	2080	1945	Philomecynostomum sp. UJ-2011 partial 28S rRNA gene, specimen voucher AWSp-41	blastn	8095	124	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Mecynostomidae	Philomecynostomum	Philomecynostomum sp. UJ-2011
3955910	3955910	PRJEB64798_P_NODE_9204_length_656_cov_53.578254_g7134_i1	PRJEB64798	9204	656	53.578254	351.47334624	Sterreria lundini	1547312	Xenacoelomorpha	other_Eukaryota	147	2.91e-30	NTclustered	gi\|686136443\|gb\|KM062841.1\|	1547312	g7134	i1	88.983	28.6981707317073	118	13	18	0	539	656	1215	1098	Sterreria lundini voucher SMNH<SWE>:MCG11 28S ribosomal RNA gene, partial sequence	blastn	18826	147	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Nemertodermatida	Nemertodermatidae	Sterreria	Sterreria lundini
6096445	6096445	PRJEB64798_P_NODE_231085_length_158_cov_5.192661_g229319_i0	PRJEB64798	231085	158	5.192661	8.20440438	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.2	7.8e-5	NTclustered	gi\|378781067\|emb\|FR837821.1\|	996671	g229319	i0	92.683	21.8860759493671	41	3	26	0	39	79	889	929	Praeconvoluta castinea partial 28S rRNA gene, specimen voucher MHMa7	blastn	3458	60.2	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Convolutidae	Praeconvoluta	Praeconvoluta castinea
6506393	6506393	PRJEB64798_P_NODE_219266_length_162_cov_4.283186_g217500_i0	PRJEB64798	219266	162	4.283186	6.93876132	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	78.7	2.22e-10	NTclustered	gi\|2701362129\|ref\|XR_010163696.1\|	84072	g217500	i0	90.164	37.6172839506173	61	5	37	1	99	158	68	8	PREDICTED: Symsagittifera roscoffensis U2 spliceosomal RNA (LOC134849684), ncRNA	blastn	6094	78.7	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
6506609	6506609	PRJEB64798_P_NODE_235626_length_156_cov_16.654206_g233860_i0	PRJEB64798	235626	156	16.654206	25.98056136	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	93.5	7.57e-15	NTclustered	gi\|2701361670\|ref\|XR_010163236.1\|	84072	g233860	i0	83.838	20.1602564102564	99	14	63	2	11	108	4	101	PREDICTED: Symsagittifera roscoffensis 5S ribosomal RNA (LOC134849198), rRNA	blastn	3145	93.5	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
8646718	8646718	PRJEB64798_P_NODE_66287_length_238_cov_6.724868_g64522_i0	PRJEB64798	66287	238	6.724868	16.00518584	Nemertodermatida	52050	Xenacoelomorpha	other_Eukaryota	97.1	9.74e-16	NTclustered	gi\|1019367217\|gb\|KT698955.1\|	450194	g64522	i0	83.495	3.10924369747899	103	17	43	0	136	238	429	327	Flagellophora apelti voucher SMNH-UJ-13110 28S large subunit ribosomal RNA gene, partial sequence	blastn	740	97.1	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Nemertodermatida	Nemertodermatidae	Flagellophora	Flagellophora apelti
9921542	9921542	PRJEB64798_P_NODE_27448_length_375_cov_137.273006_g25693_i0	PRJEB64798	27448	375	137.273006	514.7737725	Acoela	31265	Xenacoelomorpha	other_Eukaryota	82.4	4.55e-11	NTclustered	gi\|378781076\|emb\|FR837830.1\|	996676	g25693	i0	86.667	1.616	75	8	20	2	23	96	981	1054	Pseudohaplogonaria rodmani partial 28S rRNA gene, specimen voucher MHPh	blastn	606	82.4	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Haploposthiidae	Pseudohaplogonaria	Pseudohaplogonaria rodmani
10331382	10331382	PRJEB64798_P_NODE_232269_length_158_cov_2.577982_g230503_i0	PRJEB64798	232269	158	2.577982	4.07321156	Myopea sp. cf. callaeum	188053	Xenacoelomorpha	other_Eukaryota	97.1	5.95e-16	NTclustered	gi\|378781045\|emb\|FR837799.1\|	188053	g230503	i0	90.411	21.3481012658228	73	7	46	0	61	133	1015	943	Myopea sp. cf. callaeum partial 28S rRNA gene, specimen voucher MHMc	blastn	3373	97.1	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Solenofilomorphidae	Myopea	Myopea sp. cf. callaeum
11608086	11608086	PRJEB64798_P_NODE_75670_length_221_cov_13.912791_g73904_i0	PRJEB64798	75670	221	13.912791	30.74726811	Hofstenia cf. miamia	3135051	Xenacoelomorpha	other_Eukaryota	89.8	1.49e-13	NTclustered	gi\|2704011507\|gb\|PP536126.1\|	3135051	g73904	i0	82.857	2.07239819004525	105	12	45	2	3	101	2282	2386	Hofstenia cf. miamia large subunit ribosomal RNA gene, partial sequence	blastn	458	89.8	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Hofsteniidae	Hofstenia	Hofstenia cf. miamia
14156560	14156560	PRJEB64798_P_NODE_220412_length_162_cov_2.035398_g218646_i0	PRJEB64798	220412	162	2.035398	3.29734476	Childia sp. MR-2009	662517	Xenacoelomorpha	other_Eukaryota	113	6.1e-21	NTclustered	gi\|255733359\|gb\|FJ555371.1\|	662517	g218646	i0	79.874	3.73456790123457	159	28	97	3	1	157	816	660	Childia sp. MR-2009 ATP synthase beta subunit mRNA, partial cds	blastn	605	113	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Childiidae	Childia	Childia sp. MR-2009
20120176	20120176	PRJEB64798_P_NODE_59056_length_253_cov_20.024510_g57291_i0	PRJEB64798	59056	253	20.02451	50.6620103	Nemertoderma	172107	Xenacoelomorpha	other_Eukaryota	110	1.34e-19	NTclustered	gi\|1019367212\|gb\|KT698950.1\|	172108	g57291	i0	86.735	4.31620553359684	98	13	39	0	155	252	2047	2144	Nemertoderma bathycola voucher SMNH-UJ-12116 28S large subunit ribosomal RNA gene, partial sequence	blastn	1092	110	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Nemertodermatida	Nemertodermatidae	Nemertoderma	Nemertoderma bathycola
23081637	23081637	PRJEB64798_P_NODE_8539_length_677_cov_50.019108_g7134_i0	PRJEB64798	8539	677	50.019108	338.62936116	Sterreria lundini	1547312	Xenacoelomorpha	other_Eukaryota	147	3.01e-30	NTclustered	gi\|686136443\|gb\|KM062841.1\|	1547312	g7134	i0	88.983	27.7045790251108	118	13	17	0	560	677	1215	1098	Sterreria lundini voucher SMNH<SWE>:MCG11 28S ribosomal RNA gene, partial sequence	blastn	18756	147	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Nemertodermatida	Nemertodermatidae	Sterreria	Sterreria lundini
26812236	26812236	PRJEB64798_P_NODE_164301_length_181_cov_5.545455_g162535_i0	PRJEB64798	164301	181	5.545455	10.03727355	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	64.7	2.83e-10	NR	XP_063728272.1	84072	g162535	i0	50.8	2.86740331491713	59	29	97.8	0	179	3	812	870	XP_063728272.1 WD repeat-containing protein 35-like [Symsagittifera roscoffensis]	diamond	519	64.7	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
27539434	27539434	PRJEB64798_P_NODE_236504_length_156_cov_6.065421_g234738_i0	PRJEB64798	236504	156	6.065421	9.46205676	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	69.7	2.07e-12	NR	XP_063712035.1	84072	g234738	i0	61.2	0.942307692307692	49	19	94.2	0	150	4	10	58	XP_063712035.1 mitochondrial carnitine/acylcarnitine carrier protein-like [Symsagittifera roscoffensis]	diamond	147	69.7	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
27974445	27974445	PRJEB64798_P_NODE_201225_length_167_cov_2.033898_g199459_i0	PRJEB64798	201225	167	2.033898	3.39660966	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	6e-23	NR	XP_063719940.1	84072	g199459	i0	88.9	3.88023952095808	54	6	97	0	163	2	21	74	XP_063719940.1 polyadenylate-binding protein 4-like [Symsagittifera roscoffensis]	diamond	648	100	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
29079602	29079602	PRJEB64798_P_NODE_105408_length_211_cov_12.561728_g103642_i0	PRJEB64798	105408	211	12.561728	26.50524608	Metazoa	33208	Xenacoelomorpha	other_Eukaryota	67	7.33e-12	NR	XP_063722177.1	84072	g103642	i0	87.5	17.6445497630332	32	4	45.5	0	101	6	21	52	XP_063722177.1 eukaryotic translation initiation factor 5A-1-like [Symsagittifera roscoffensis]	diamond	3723	67	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
29995421	29995421	PRJEB64798_P_NODE_237351_length_156_cov_3.439252_g235585_i0	PRJEB64798	237351	156	3.439252	5.36523312	Metazoa	33208	Xenacoelomorpha	other_Eukaryota	60.5	6.49e-9	NR	XP_063724192.1	84072	g235585	i0	57.1	3.71153846153846	49	21	94.2	0	147	1	286	334	XP_063724192.1 ubiquitin-like modifier-activating enzyme 1 [Symsagittifera roscoffensis]	diamond	579	60.5	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
31259154	31259154	PRJEB64798_P_NODE_197695_length_168_cov_1.663866_g195929_i0	PRJEB64798	197695	168	1.663866	2.79529488	Metazoa	33208	Xenacoelomorpha	other_Eukaryota	102	1.2699999999999999e-23	NR	XP_063718296.1	84072	g195929	i0	88.9	17.9285714285714	54	6	96.4	0	163	2	440	493	XP_063718296.1 transitional endoplasmic reticulum ATPase [Symsagittifera roscoffensis]	diamond	3012	102	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
31645508	31645508	PRJEB64798_P_NODE_246097_length_153_cov_3.788462_g244331_i0	PRJEB64798	246097	153	3.788462	5.79634686	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	48.1	1.34e-4	NR	XP_063712938.1	84072	g244331	i0	62.9	1.50980392156863	35	12	68.6	1	119	15	334	367	XP_063712938.1 MYND-type zinc finger-containing chromatin reader ZMYND8-like [Symsagittifera roscoffensis]	diamond	231	48.1	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
32151797	32151797	PRJEB64798_P_NODE_17678_length_474_cov_10.040000_g15967_i0	PRJEB64798	17678	474	10.04	47.5896	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	102	1.32e-22	NR	XP_063718357.1	84072	g15967	i0	42.3	2.68354430379747	130	65	76.6	5	105	467	117	245	XP_063718357.1 four and a half LIM domains protein 2-like [Symsagittifera roscoffensis]	diamond	1272	102	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis

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