metadata: contig_metadata: 4 rows where bioproject = "PRJNA1193541", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA1193541", tax_clade = "Opisthokonta" 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
6145240	6145240	PRJNA1193541_P_NODE_2525_length_491_cov_1.105263_g2388_i0	PRJNA1193541	2525	491	1.105263	5.42684133	Hausera	2676385	Platyhelminthes	Platyhelminthes	193	2.71e-44	NTclustered	gi\|588313918\|gb\|KC869876.1\|	1468254	g2388	i0	80.22	54.7515274949084	273	40	54	12	127	392	945	1210	Cavernicola sp. n. CEL-2014 28S ribosomal RNA gene, partial sequence	blastn	26883	193	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida			Cavernicola sp. n. CEL-2014
13795756	13795756	PRJNA1193541_P_NODE_11371_length_260_cov_2.058824_g11233_i0	PRJNA1193541	11371	260	2.058824	5.3529424	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.2	1.42e-4	NTclustered	gi\|2224869\|gb\|U53001.1\|DLU53001	27895	g11233	i0	100	12.5153846153846	32	0	12	0	94	125	80	111	Dendrocoelum lacteum ribosomal RNA large subunit gene, partial sequence	blastn	3254	60.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dendrocoelidae	Dendrocoelum	Dendrocoelum lacteum
16897811	16897811	PRJNA1193541_P_NODE_494_length_963_cov_1.978652_g401_i0	PRJNA1193541	494	963	1.978652	19.05441876	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.027	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g401	i0	100	0.0301142263759086	29	0	3	0	125	153	5389	5361	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
31703286	31703286	PRJNA1193541_P_NODE_13637_length_246_cov_0.890173_g13499_i0	PRJNA1193541	13637	246	0.890173	2.18982558	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	62.4	8.71e-10	NR	VDP28099.1	27848	g13499	i0	76.3	7.5	38	9	46.3	0	129	242	16	53	VDP28099.1 unnamed protein product [Echinostoma caproni]	diamond	1845	62.8	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Echinostomatidae	Echinostoma	Echinostoma caproni

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