metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1200128" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1200128" 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
1601686	1601686	PRJNA1200128_S_NODE_11442_length_242_cov_1.809045_g11333_i0	PRJNA1200128	11442	242	1.809045	4.3778889	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	97.1	9.93e-16	NTclustered	gi\|56753506\|gb\|AY813225.1\|	6182	g11333	i0	98.182	23.6280991735537	55	1	23	0	1	55	825	771	Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds	blastn	5718	97.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
1601693	1601693	PRJNA1200128_S_NODE_12702_length_234_cov_1.732984_g12593_i0	PRJNA1200128	12702	234	1.732984	4.05518256	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	370	5.09e-98	NTclustered	gi\|60698656\|gb\|AY915745.1\|	6182	g12593	i0	97.674	12.1410256410256	215	5	92	0	20	234	467	253	Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds	blastn	2841	370	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
1601734	1601734	PRJNA1200128_S_NODE_21742_length_198_cov_548.677419_g21633_i0	PRJNA1200128	21742	198	548.677419	1086.38128962	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	285	1.55e-72	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g21633	i0	99.363	96.6969696969697	157	1	79	0	42	198	1305	1461	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	19146	285	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
2877901	2877901	PRJNA1200128_S_NODE_1823_length_488_cov_619.253933_g1717_i0	PRJNA1200128	1823	488	619.253933	3021.95919304	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	544	6.44e-150	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g1717	i0	98.387	128.463114754098	310	4	100	1	1	309	1461	1152	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	62690	544	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
2878057	2878057	PRJNA1200128_S_NODE_963_length_769_cov_7.870523_g891_i0	PRJNA1200128	963	769	7.870523	60.52432187	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.021	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g891	i0	100	0.0377113133940182	29	0	4	0	142	170	5389	5361	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
9255086	9255086	PRJNA1200128_S_NODE_42228_length_159_cov_1.112069_g42119_i0	PRJNA1200128	42228	159	1.112069	1.76818971	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	117	4.600000000000001e-22	NTclustered	gi\|56758417\|gb\|AY815617.1\|	6182	g42119	i0	97.101	42.3333333333333	69	2	43	0	91	159	275	343	Schistosoma japonicum SJCHGC04625 protein mRNA, complete cds	blastn	6731	117	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14356147	14356147	PRJNA1200128_S_NODE_9212_length_259_cov_5.587963_g9103_i0	PRJNA1200128	9212	259	5.587963	14.47282417	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	457	4.279999999999999e-124	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g9103	i0	98.456	2.32046332046332	259	4	100	0	1	259	57	315	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	601	457	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22003820	22003820	PRJNA1200128_S_NODE_35358_length_169_cov_1.150794_g35249_i0	PRJNA1200128	35358	169	1.150794	1.94484186	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	291	2.75e-74	NTclustered	gi\|60698656\|gb\|AY915745.1\|	6182	g35249	i0	97.647	12.0710059171598	170	3	100	1	1	169	222	53	Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds	blastn	2040	291	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22003903	22003903	PRJNA1200128_S_NODE_9258_length_259_cov_1.740741_g9149_i0	PRJNA1200128	9258	259	1.740741	4.50851919	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	237	6.0700000000000005e-58	NTclustered	gi\|20386492\|gb\|AF500622.1\|	6182	g9149	i0	89.119	0.745173745173745	193	18	74	2	29	220	483	293	Schistosoma japonicum hepato-portal schistosomula protein (M9) mRNA, complete cds	blastn	193	237	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);;