metadata: contig_metadata: 5 rows where bioproject = "PRJNA753151", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA753151", 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
14758766	14758766	PRJNA753151_S_NODE_202312_length_203_cov_1.787500_g200022_i0	PRJNA753151	202312	203	1.7875	3.628625	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	348	2.0100000000000006e-91	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g200022	i0	97.537	2.5320197044335	203	5	100	0	1	203	230	432	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	514	348	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14759245	14759245	PRJNA753151_S_NODE_28312_length_443_cov_5.737500_g26121_i0	PRJNA753151	28312	443	5.7375	25.417125	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	52.8	0.043	NTclustered	gi\|393794191\|dbj\|AK388788.1\|	6161	g26121	i0	100	0.0632054176072235	28	0	6	0	370	397	1772	1799	Dugesia japonica cDNA, clone: Dj_aH_000_02497HH.full, full-insert sequence, expressed in adult head	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
19856800	19856800	PRJNA753151_S_NODE_192196_length_209_cov_1.355422_g189906_i0	PRJNA753151	192196	209	1.355422	2.83283198	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.005	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g189906	i0	100	0.138755980861244	29	0	14	0	87	115	5389	5361	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
28884451	28884451	PRJNA753151_S_NODE_181208_length_215_cov_4.813953_g178918_i0	PRJNA753151	181208	215	4.813953	10.34999895	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	49.7	5.61e-6	NR	ABA40899.1	6182	g178918	i0	59	0.544186046511628	39	14	51.6	1	192	82	4	42	ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum]	diamond	117	49.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30464070	30464070	PRJNA753151_S_NODE_318953_length_153_cov_40.109091_g316663_i0	PRJNA753151	318953	153	40.109091	61.36690923	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	66.2	3.7e-12	NR	AAW27122.1	6182	g316663	i0	79.1	0.843137254901961	43	7	80.4	1	124	2	1	43	AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum]	diamond	129	66.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum

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