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

5 rows where bioproject = "PRJEB58983" 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
8645174	8645174	PRJEB58983_P_NODE_10307_length_390_cov_1.271293_g9892_i0	PRJEB58983	10307	390	1.271293	4.9580427	Polycystididae	39194	Platyhelminthes	Platyhelminthes	126	2.1699999999999994e-24	NTclustered	gi\|667755593\|gb\|KJ887527.1\|	1525023	g9892	i0	94.048	23.8564102564103	84	3	21	2	296	378	90	8	Djeziraia euxinica voucher DNA517SARIII 28S ribosomal RNA gene, partial sequence	blastn	9304	126	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Polycystididae	Djeziraia	Djeziraia euxinica
20526211	20526211	PRJEB58983_P_NODE_9577_length_403_cov_3.109091_g9163_i0	PRJEB58983	9577	403	3.109091	12.52963673	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	695	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g9163	i0	97.767	1	403	9	100	0	1	403	415	13	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	403	695	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27121338	27121338	PRJEB58983_P_NODE_28722_length_251_cov_0.870787_g28307_i0	PRJEB58983	28722	251	0.870787	2.18567537	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99	2.35e-22	NR	KAK4468778.1	38744	g28307	i0	51.8	6.88446215139442	83	40	99.2	0	1	249	245	327	KAK4468778.1 hypothetical protein MN116_007950 [Schistosoma mekongi]	diamond	1728	99	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mekongi
28321685	28321685	PRJEB58983_P_NODE_31086_length_245_cov_0.906977_g30671_i0	PRJEB58983	31086	245	0.906977	2.22209365	Taeniidae	6208	Platyhelminthes	Platyhelminthes	56.6	5e-7	NR	KAH9285024.1	6210	g30671	i0	49.2	1.59183673469388	65	30	75.9	1	186	1	183	247	KAH9285024.1 Trafficking protein particle complex subunit 11 [Echinococcus granulosus]	diamond	390	56.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
28738995	28738995	PRJEB58983_P_NODE_24707_length_266_cov_3.041451_g24292_i0	PRJEB58983	24707	266	3.041451	8.09025966	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	81.6	9.58e-16	NR	PAA73958.1	282301	g24292	i0	48	0.845864661654135	75	38	84.6	1	236	12	333	406	PAA73958.1 hypothetical protein BOX15_Mlig013895g3, partial [Macrostomum lignano]	diamond	225	81.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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