metadata: contig_metadata: 5 rows where bioproject = "PRJNA436017" and tax

5 rows where bioproject = "PRJNA436017" 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
17666574	17666574	PRJNA436017_P_NODE_10054_length_272_cov_2.489362_g9756_i0	PRJNA436017	10054	272	2.489362	6.77106464	Metazoa	33208	Platyhelminthes	Platyhelminthes	501	2.06e-137	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g9756	i0	100	99.6323529411765	271	0	99	0	2	272	45	315	Schistosoma japonicum unknown mRNA	blastn	27100	501	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
21490815	21490815	PRJNA436017_P_NODE_15137_length_213_cov_1.875000_g14839_i0	PRJNA436017	15137	213	1.875	3.99375	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	119	1.82e-22	NTclustered	gi\|138752562\|emb\|AM489593.1\|	421533	g14839	i0	83.721	15.037558685446	129	18	59	3	1	126	1562	1434	Paradeontacylix ibericus partial 28S rRNA gene	blastn	3203	119	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Aporocotylidae	Paradeontacylix	Paradeontacylix iberica
25315178	25315178	PRJNA436017_P_NODE_16460_length_203_cov_1.620482_g16162_i0	PRJNA436017	16460	203	1.620482	3.28957846	Anthocephaliidae	1617303	Platyhelminthes	Platyhelminthes	86.1	1.74e-12	NTclustered	gi\|223670572\|gb\|FJ177099.1\|	595947	g16162	i0	90.909	34.4433497536946	66	3	32	3	9	72	1067	1131	Anthocephalum cf. centrurum LRP4219 voucher LRP4219 (TE141) 28S ribosomal RNA gene, partial sequence	blastn	6992	86.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Rhinebothriidea	Anthocephaliidae	Anthocephalum	Anthocephalum cf. centrurum LRP4219
30201972	30201972	PRJNA436017_P_NODE_17212_length_198_cov_1.447205_g16914_i0	PRJNA436017	17212	198	1.447205	2.8654659	Paragonimus skrjabini miyazakii	59628	Platyhelminthes	Platyhelminthes	58.5	5.39e-8	NR	KAF7255177.1	59628	g16914	i0	43.8	1.92424242424242	64	33	97	1	194	3	72	132	KAF7255177.1 hypothetical protein EG68_08165 [Paragonimus skrjabini miyazakii]	diamond	381	58.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus skrjabini miyazakii
31893903	31893903	PRJNA436017_P_NODE_25717_length_161_cov_1.064516_g25419_i0	PRJNA436017	25717	161	1.064516	1.71387076	root	1	Root_unresolved	Root_unresolved	61.2	6.71e-10	NR	CDS41549.1	6211	g25419	i0	58.5	7.90062111801242	53	12	98.8	1	1	159	47	89	CDS41549.1 expressed protein [Echinococcus multilocularis]	diamond	1272	61.6	0.993506493506494	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus multilocularis

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