metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
1455673	1455673	PRJNA1067370_P_NODE_60942_length_278_cov_1.795122_g60393_i0	PRJNA1067370	60942	278	1.795122	4.99043916	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|690463342\|emb\|LN003358.1\|	99802	g60393	i0	100	0.10431654676259	29	0	10	0	142	170	5419	5447	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0003332	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
4007723	4007723	PRJNA1067370_P_NODE_98704_length_246_cov_0.878613_g98155_i0	PRJNA1067370	98704	246	0.878613	2.16138798	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	52.8	0.022	NTclustered	gi\|2318758887\|ref\|XM_051209242.1\|	6185	g98155	i0	100	0.113821138211382	28	0	11	0	138	165	3952	3979	Schistosoma haematobium CTD (Carboxy-terminal domain, RNA polymerase II, polypeptide A) small (CTDSP2_1), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
6558795	6558795	PRJNA1067370_P_NODE_46906_length_304_cov_1.333333_g46358_i0	PRJNA1067370	46906	304	1.333333	4.05333232	Syndesmis kurakaikina	2711315	Platyhelminthes	Platyhelminthes	121	7.659999999999999e-23	NTclustered	gi\|1858375042\|gb\|MT622644.1\|	2711315	g46358	i0	83.721	29.7006578947368	129	19	42	2	11	138	6066	6193	Syndesmis kurakaikina small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	9029	121	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Umagillidae	Syndesmis	Syndesmis kurakaikina
9108623	9108623	PRJNA1067370_P_NODE_72328_length_261_cov_1.420213_g71779_i0	PRJNA1067370	72328	261	1.420213	3.70675593	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	60.2	1.42e-4	NTclustered	gi\|687165215\|emb\|LN049133.1\|	99802	g71779	i0	100	0.122605363984674	32	0	12	0	17	48	5422	5391	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0047827	blastn	32	60.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
9941346	9941346	PRJNA1067370_P_NODE_20768_length_413_cov_1.555882_g20220_i0	PRJNA1067370	20768	413	1.555882	6.42579266	Metazoa	33208	Platyhelminthes	Platyhelminthes	326	2.12e-84	NTclustered	gi\|226469103\|emb\|FN314298.1\|	6182	g20220	i0	82.967	68.6246973365617	364	58	88	4	7	368	479	118	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA2796.003\|FSA001-P00024-H02, complete sequence	blastn	28342	326	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
16757955	16757955	PRJNA1067370_P_NODE_69754_length_265_cov_1.255208_g69205_i0	PRJNA1067370	69754	265	1.255208	3.3263012	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.024	NTclustered	gi\|690593994\|emb\|LN146892.1\|	99802	g69205	i0	100	0.105660377358491	28	0	11	0	126	153	1193	1220	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0133757	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
19306483	19306483	PRJNA1067370_P_NODE_41556_length_315_cov_0.913223_g41008_i0	PRJNA1067370	41556	315	0.913223	2.87665245	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.029	NTclustered	gi\|687187304\|emb\|LN169230.1\|	99802	g41008	i0	100	0.0888888888888889	28	0	9	0	57	84	96	69	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0150255	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
24406642	24406642	PRJNA1067370_P_NODE_2140_length_1134_cov_11.891612_g1801_i0	PRJNA1067370	2140	1134	11.891612	134.85088008	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	678	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g1801	i0	85.429	16.4100529100529	652	95	57	0	317	968	652	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	18609	678	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni

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