metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA312899" 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
28432362	28432362	PRJNA312899_P_NODE_67966_length_198_cov_2.107383_g67524_i0	PRJNA312899	67966	198	2.107383	4.17261834	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	88.6	1.31e-18	NR	PAA84227.1	282301	g67524	i0	66.2	1.96969696969697	65	22	98.5	0	2	196	412	476	PAA84227.1 hypothetical protein BOX15_Mlig011061g1, partial [Macrostomum lignano]	diamond	390	88.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30818545	30818545	PRJNA312899_P_NODE_74514_length_186_cov_3.569343_g74072_i0	PRJNA312899	74514	186	3.569343	6.63897798	Metazoa	33208	Platyhelminthes	Platyhelminthes	60.5	9.51e-9	NR	XP_051074928.1	6185	g74072	i0	51.9	4.08064516129032	52	25	83.9	0	29	184	403	454	XP_051074928.1 Heat shock protein [Schistosoma haematobium]	diamond	759	60.8	0.995065789473684	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
31464988	31464988	PRJNA312899_P_NODE_42496_length_272_cov_4.547085_g42054_i0	PRJNA312899	42496	272	4.547085	12.3680712	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	49.7	1.93e-4	NR	PAA48956.1	282301	g42054	i0	37.5	4.23529411764706	64	37	67.3	1	3	185	772	835	PAA48956.1 hypothetical protein BOX15_Mlig017056g1 [Macrostomum lignano]	diamond	1152	49.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32746937	32746937	PRJNA312899_P_NODE_83860_length_171_cov_1.672131_g83418_i0	PRJNA312899	83860	171	1.672131	2.85934401	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.4	2.67e-5	NR	VDD75186.1	53468	g83418	i0	57.5	4	40	17	70.2	0	122	3	213	252	VDD75186.1 unnamed protein product [Mesocestoides corti]	diamond	684	50.8	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Mesocestoididae	Mesocestoides	Mesocestoides corti

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