metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1242190" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1242190" and tax_phylum = "Platyhelminthes"

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
11829487	11829487	PRJNA1242190_S_NODE_2270_length_487_cov_2.545894_g2263_i0	PRJNA1242190	2270	487	2.545894	12.39850378	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	203	5.96e-62	NR	AKN21598.1	79327	g2263	i0	87.7	0.702258726899384	114	14	70.2	0	486	145	192	305	AKN21598.1 slc25a-30 [Schmidtea mediterranea]	diamond	342	203	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
26965065	26965065	PRJNA1242190_S_NODE_10902_length_262_cov_1.470899_g10895_i0	PRJNA1242190	10902	262	1.470899	3.85375538	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	63.2	3.16e-9	NR	PAA85988.1	282301	g10895	i0	49.2	4.93511450381679	61	31	69.8	0	1	183	1480	1540	PAA85988.1 hypothetical protein BOX15_Mlig028749g1, partial [Macrostomum lignano]	diamond	1293	63.5	0.995275590551181	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
27231594	27231594	PRJNA1242190_S_NODE_3763_length_411_cov_4.381657_g3756_i0	PRJNA1242190	3763	411	4.381657	18.00861027	Rodentolepis nana	102285	Platyhelminthes	Platyhelminthes	133	3.5300000000000004e-36	NR	AAM94879.1	102285	g3756	i0	62.5	1.86131386861314	128	48	93.4	0	388	5	76	203	AAM94879.1 paramyosin, partial [Rodentolepis nana]	diamond	765	133	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Rodentolepis	Rodentolepis nana
27421468	27421468	PRJNA1242190_S_NODE_11023_length_261_cov_1.015957_g11016_i0	PRJNA1242190	11023	261	1.015957	2.65164777	Girardia sp. ER-2	3376740	Platyhelminthes	Platyhelminthes	44.3	0.0129	NR	AJI44475.1	1608986	g11016	i0	90.6	0.367816091954023	32	3	36.8	0	3	98	494	525	AJI44475.1 NADH dehydrogenase subunit 5 [Girardia sp. ER-2015]	diamond	96	44.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Girardia	Girardia sp. ER-2015
27453010	27453010	PRJNA1242190_S_NODE_12383_length_249_cov_13.119318_g12376_i0	PRJNA1242190	12383	249	13.119318	32.66710182	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	101	9.8e-23	NR	BAF57642.1	6161	g12376	i0	81.4	0.710843373493976	59	11	71.1	0	247	71	536	594	BAF57642.1 nucleolar RNA helicase II/Gu protein, partial [Dugesia japonica]	diamond	177	101	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
27565435	27565435	PRJNA1242190_S_NODE_13164_length_245_cov_0.906977_g13157_i0	PRJNA1242190	13164	245	0.906977	2.22209365	Metazoa	33208	Platyhelminthes	Platyhelminthes	102	5.3e-24	NR	CAH8607826.1	57078	g13157	i0	67.5	12.7102040816327	80	26	98	0	243	4	101	180	CAH8607826.1 unnamed protein product [Dicrocoelium dendriticum]	diamond	3114	102	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
29302201	29302201	PRJNA1242190_S_NODE_10869_length_262_cov_8.253968_g10862_i0	PRJNA1242190	10869	262	8.253968	21.62539616	Metazoa	33208	Platyhelminthes	Platyhelminthes	115	7.39e-29	NR	ADF47427.1	6161	g10862	i0	76.3	18.5496183206107	80	18	91.6	1	4	243	15	93	ADF47427.1 poly(A) binding protein cytoplasmic-2, partial [Dugesia japonica]	diamond	4860	115	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
29410300	29410300	PRJNA1242190_S_NODE_4469_length_383_cov_2.806452_g4462_i0	PRJNA1242190	4469	383	2.806452	10.74871116	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	171	1.71e-50	NR	CAA68079.1	6161	g4462	i0	74.1	0.845953002610966	108	28	84.6	0	374	51	9	116	CAA68079.1 Y-box protein [Dugesia japonica]	diamond	324	171	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
29473257	29473257	PRJNA1242190_S_NODE_8270_length_297_cov_2.352679_g8263_i0	PRJNA1242190	8270	297	2.352679	6.98745663	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	162	4.3e-44	NR	ACM91724.1	6161	g8263	i0	83.7	0.98989898989899	98	16	99	0	295	2	452	549	ACM91724.1 90 kDa heat shock protein [Dugesia japonica]	diamond	294	162	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
29554590	29554590	PRJNA1242190_S_NODE_12730_length_247_cov_1.793103_g12723_i0	PRJNA1242190	12730	247	1.793103	4.42896441	Paragonimus	34503	Platyhelminthes	Platyhelminthes	108	3.99e-26	NR	KAF8562421.1	34504	g12723	i0	63.6	11.1133603238866	77	28	93.5	0	2	232	248	324	KAF8562421.1 hypothetical protein P879_09130 [Paragonimus westermani]	diamond	2745	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
29694209	29694209	PRJNA1242190_S_NODE_14150_length_216_cov_5.230769_g14143_i0	PRJNA1242190	14150	216	5.230769	11.29846104	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	96.3	1.3e-23	NR	AAY97887.1	6182	g14143	i0	71	0.958333333333333	69	20	95.8	0	10	216	1	69	AAY97887.1 unknown [Schistosoma japonicum]	diamond	207	96.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30926878	30926878	PRJNA1242190_S_NODE_13534_length_243_cov_0.917647_g13527_i0	PRJNA1242190	13534	243	0.917647	2.22988221	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	154	2.45e-41	NR	ADF47451.1	6161	g13527	i0	94.7	0.925925925925926	75	4	92.6	0	3	227	473	547	ADF47451.1 vasa PlVAS1-like protein, partial [Dugesia japonica]	diamond	225	154	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
31906875	31906875	PRJNA1242190_S_NODE_14037_length_228_cov_11.322581_g14030_i0	PRJNA1242190	14037	228	11.322581	25.81548468	Girardia sp. ER-2	3376740	Platyhelminthes	Platyhelminthes	77.8	1.11e-14	NR	AJI44479.1	1608986	g14030	i0	80.5	0.539473684210526	41	8	53.9	0	40	162	347	387	AJI44479.1 cytochrome c oxidase subunit II, partial [Girardia sp. ER-2015]	diamond	123	77.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Girardia	Girardia sp. ER-2015
31938364	31938364	PRJNA1242190_S_NODE_11237_length_258_cov_2.016216_g11230_i0	PRJNA1242190	11237	258	2.016216	5.20183728	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	54.7	2.65e-6	NR	PAA93605.1	282301	g11230	i0	35.3	1.97674418604651	85	54	98.8	1	3	257	343	426	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	510	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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