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

9 rows where analysis = "blastn", bioproject = "PRJNA846486" 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
3384092	3384092	PRJNA846486_P_NODE_73163_length_171_cov_1.909836_g73067_i0	PRJNA846486	73163	171	1.909836	3.26581956	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	163	6.34e-36	NTclustered	gi\|60597103\|gb\|AY809212.1\|	6182	g73067	i0	98.901	15.4795321637427	91	1	100	0	81	171	140	230	Schistosoma japonicum SJCHGC04513 protein mRNA, partial cds	blastn	2647	163	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
5936419	5936419	PRJNA846486_P_NODE_34805_length_227_cov_11.000000_g34709_i0	PRJNA846486	34805	227	11	24.97	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	409	1.04e-109	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g34709	i0	99.119	2.36563876651982	227	2	100	0	1	227	347	121	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	537	409	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
8486189	8486189	PRJNA846486_P_NODE_91447_length_163_cov_0.912281_g91351_i0	PRJNA846486	91447	163	0.912281	1.48701803	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	54.7	0.004	NTclustered	gi\|28316820\|gb\|AY222866.1\|	6182	g91351	i0	100	0.699386503067485	29	0	30	0	14	42	334	362	Schistosoma japonicum clone ZZD1204 mRNA sequence	blastn	114	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
11036906	11036906	PRJNA846486_P_NODE_26309_length_255_cov_1.247573_g26213_i0	PRJNA846486	26309	255	1.247573	3.18131115	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	460	3.25e-125	NTclustered	gi\|60600058\|gb\|AY810684.1\|	6182	g26213	i0	99.216	5.83529411764706	255	2	100	0	1	255	247	501	Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds	blastn	1488	460	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14861117	14861117	PRJNA846486_P_NODE_10192_length_387_cov_2.426036_g10097_i0	PRJNA846486	10192	387	2.426036	9.38875932	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	219	3.44e-52	NTclustered	gi\|60698656\|gb\|AY915745.1\|	6182	g10097	i0	97.638	6.23255813953488	127	3	47	0	1	127	353	227	Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds	blastn	2412	219	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14861236	14861236	PRJNA846486_P_NODE_6832_length_465_cov_1.673077_g6739_i0	PRJNA846486	6832	465	1.673077	7.77980805	Pacifides sp. n. ML-2020	2771503	Platyhelminthes	Platyhelminthes	226	2.52e-54	NTclustered	gi\|1900854572\|gb\|MT994578.1\|	2771503	g6739	i0	76.629	70.3354838709677	445	83	95	16	24	463	926	1354	Pacifides sp. n. ML-2020 isolate ML3 large subunit ribosomal RNA gene, partial sequence	blastn	32706	226	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Cercyridae	Pacifides	Pacifides sp. n. ML-2020
19082947	19082947	PRJNA846486_P_NODE_21175_length_279_cov_1.552174_g21079_i0	PRJNA846486	21175	279	1.552174	4.33056546	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.2	1.54e-4	NTclustered	gi\|2224869\|gb\|U53001.1\|DLU53001	27895	g21079	i0	100	11.663082437276	32	0	11	0	39	70	111	80	Dendrocoelum lacteum ribosomal RNA large subunit gene, partial sequence	blastn	3254	60.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dendrocoelidae	Dendrocoelum	Dendrocoelum lacteum
23785620	23785620	PRJNA846486_P_NODE_75539_length_169_cov_1.733333_g75443_i0	PRJNA846486	75539	169	1.733333	2.92933277	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	313	5.859999999999999e-81	NTclustered	gi\|546143622\|ref\|NC_022448.1\|	79327	g75443	i0	100	9.00591715976331	169	0	100	0	1	169	23184	23352	Schmidtea mediterranea mitochondrion, complete genome	blastn	1522	313	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
25059491	25059491	PRJNA846486_P_NODE_65760_length_178_cov_3.472868_g65664_i0	PRJNA846486	65760	178	3.472868	6.18170504	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	274	2.95e-69	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g65664	i0	94.413	95.4325842696629	179	8	100	2	1	178	1806	1983	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	16987	274	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);;