metadata: contig_metadata: 7 rows where bioproject = "PRJNA596870", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA596870", 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
568471	568471	PRJNA596870_P_NODE_30601_length_250_cov_0.870056_g30468_i0	PRJNA596870	30601	250	0.870056	2.17514	Trematoda	6178	Platyhelminthes	Platyhelminthes	151	4.71e-43	NR	CAX78280.1	6182	g30468	i0	84.3	9.96	83	13	99.6	0	250	2	25	107	CAX78280.1 putative ribosomal protein L5 [Schistosoma japonicum]	diamond	2490	152	0.993421052631579	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22245888	22245888	PRJNA596870_P_NODE_938_length_1124_cov_1.827783_g855_i0	PRJNA596870	938	1124	1.827783	20.54428092	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	1736	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g855	i0	99.789	18.855871886121	946	2	84	0	2	947	946	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	21194	1736	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
26763294	26763294	PRJNA596870_P_NODE_19481_length_302_cov_1.842795_g19348_i0	PRJNA596870	19481	302	1.842795	5.5652409	Trichobilharzia regenti	157069	Platyhelminthes	Platyhelminthes	77.4	3.77e-16	NR	VDQ08198.1	157069	g19348	i0	60.9	5.58278145695364	64	20	59.6	2	29	208	28	90	VDQ08198.1 unnamed protein product [Trichobilharzia regenti]	diamond	1686	77.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
28848103	28848103	PRJNA596870_P_NODE_23528_length_279_cov_1.228155_g23395_i0	PRJNA596870	23528	279	1.228155	3.42655245	Trichobilharzia regenti	157069	Platyhelminthes	Platyhelminthes	48.5	5.49e-4	NR	CAH8871812.1	157069	g23395	i0	38.1	2.01075268817204	63	39	67.7	0	270	82	87	149	CAH8871812.1 unnamed protein product [Trichobilharzia regenti]	diamond	561	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia regenti
30174541	30174541	PRJNA596870_P_NODE_28552_length_253_cov_1.283333_g28419_i0	PRJNA596870	28552	253	1.283333	3.24683249	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	49.3	1.89e-4	NR	CAL5141013.1	300641	g28419	i0	32.5	0.948616600790514	80	44	92.5	3	234	1	196	267	CAL5141013.1 unnamed protein product [Calicophoron daubneyi]	diamond	240	49.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi
30301460	30301460	PRJNA596870_P_NODE_31672_length_249_cov_0.875000_g31539_i0	PRJNA596870	31672	249	0.875	2.17875	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	53.9	4.46e-6	NR	PAA49164.1	282301	g31539	i0	40.3	2.69879518072289	62	35	74.7	1	13	198	177	236	PAA49164.1 hypothetical protein BOX15_Mlig024164g1, partial [Macrostomum lignano]	diamond	672	53.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32243256	32243256	PRJNA596870_P_NODE_6258_length_489_cov_1.050481_g6125_i0	PRJNA596870	6258	489	1.050481	5.13685209	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	63.2	7.38e-9	NR	CUU97725.1	85433	g6125	i0	29.2	3.49693251533742	113	78	68.1	1	142	474	3	115	CUU97725.1 hypothetical transcript [Hymenolepis microstoma]	diamond	1710	63.5	0.995275590551181	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis microstoma

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