metadata: contig_metadata: 9 rows where bioproject = "PRJEB12237", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJEB12237", tax_kingdom = "Metazoa" 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
19146197	19146197	PRJEB12237_P_NODE_7436_length_205_cov_1.270588_g7240_i0	PRJEB12237	7436	205	1.270588	2.6047054	Paragonimus westermani	34504	Platyhelminthes	Platyhelminthes	68.9	1.05e-11	NR	KAA3669811.1	34504	g7240	i0	50	8.64878048780488	62	29	87.8	1	197	18	145	206	KAA3669811.1 uncharacterized protein DEA37_0009771 [Paragonimus westermani]	diamond	1773	68.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus westermani
21697420	21697420	PRJEB12237_P_NODE_7058_length_213_cov_1.977528_g6862_i0	PRJEB12237	7058	213	1.977528	4.21213464	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	113	2.17e-27	NR	TNN11288.1	6182	g6862	i0	74.6	81.3802816901408	71	18	100	0	213	1	362	432	TNN11288.1 Elongation factor 1-alpha 2 isoform 2 [Schistosoma japonicum]	diamond	17334	113	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
24246496	24246496	PRJEB12237_P_NODE_5120_length_270_cov_1.872340_g4924_i0	PRJEB12237	5120	270	1.87234	5.055318	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	344	3.65e-90	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g4924	i0	89.63	1	270	28	100	0	1	270	14	283	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	270	344	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27665044	27665044	PRJEB12237_P_NODE_11964_length_151_cov_2.413793_g11768_i0	PRJEB12237	11964	151	2.413793	3.64482743	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	73.9	3.08e-15	NR	AAY97887.1	6182	g11768	i0	94.7	0.754966887417219	38	2	75.5	0	3	116	91	128	AAY97887.1 unknown [Schistosoma japonicum]	diamond	114	73.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
28068967	28068967	PRJEB12237_P_NODE_12225_length_150_cov_1.008696_g12029_i0	PRJEB12237	12225	150	1.008696	1.513044	Trematoda	6178	Platyhelminthes	Platyhelminthes	76.3	6.6e-16	NR	XP_009171894.1	6198	g12029	i0	63.3	5.88	49	18	98	0	148	2	53	101	XP_009171894.1 hypothetical protein T265_07959 [Opisthorchis viverrini]	diamond	882	76.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
28896131	28896131	PRJEB12237_P_NODE_7548_length_203_cov_1.172619_g7352_i0	PRJEB12237	7548	203	1.172619	2.38041657	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	48.5	1.94e-4	NR	PAA53228.1	282301	g7352	i0	37.7	2.48275862068966	53	31	75.4	1	202	50	212	264	PAA53228.1 hypothetical protein BOX15_Mlig023111g2 [Macrostomum lignano]	diamond	504	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30190884	30190884	PRJEB12237_P_NODE_9032_length_180_cov_1.655172_g8836_i0	PRJEB12237	9032	180	1.655172	2.9793096	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	52.8	5.73e-7	NR	PAA64051.1	282301	g8836	i0	62.9	0.583333333333333	35	13	58.3	0	2	106	19	53	PAA64051.1 hypothetical protein BOX15_Mlig003163g1, partial [Macrostomum lignano]	diamond	105	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
31897889	31897889	PRJEB12237_P_NODE_8217_length_192_cov_1.019108_g8021_i0	PRJEB12237	8217	192	1.019108	1.95668736	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	70.1	1.32e-12	NR	THD22131.1	6192	g8021	i0	51.7	1.875	60	29	93.8	0	13	192	69	128	THD22131.1 Transcriptional coactivator [Fasciola hepatica]	diamond	360	70.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
32870951	32870951	PRJEB12237_P_NODE_6500_length_226_cov_1.287958_g6304_i0	PRJEB12237	6500	226	1.287958	2.91078508	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	46.6	0.00129	NR	KAA0190063.1	27845	g6304	i0	54.3	0.955752212389381	35	16	46.5	0	226	122	138	172	KAA0190063.1 EF-hand domain-containing family member C2, partial [Fasciolopsis buskii]	diamond	216	47	0.991489361702128	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii

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