metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1255065" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1255065" 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
27390065	27390065	PRJNA1255065_P_NODE_109543_length_169_cov_0.866667_g107315_i0	PRJNA1255065	109543	169	0.866667	1.46466723	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	45.4	0.00154	NR	PAA57464.1	282301	g107315	i0	90.5	0.372781065088757	21	2	37.3	0	168	106	115	135	PAA57464.1 hypothetical protein BOX15_Mlig025138g2 [Macrostomum lignano]	diamond	63	45.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
28147814	28147814	PRJNA1255065_P_NODE_144465_length_163_cov_0.912281_g142237_i0	PRJNA1255065	144465	163	0.912281	1.48701803	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	60.1	9.64e-9	NR	PAA88228.1	282301	g142237	i0	59.3	1.69325153374233	54	19	99.4	1	1	162	436	486	PAA88228.1 hypothetical protein BOX15_Mlig021765g1 [Macrostomum lignano]	diamond	276	60.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
28400263	28400263	PRJNA1255065_P_NODE_144426_length_163_cov_0.912281_g142198_i0	PRJNA1255065	144426	163	0.912281	1.48701803	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	52	1.29e-6	NR	XP_024345032.1	6210	g142198	i0	73	0.680981595092024	37	10	68.1	0	51	161	84	120	XP_024345032.1 hypothetical protein EGR_11314 [Echinococcus granulosus]	diamond	111	52	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
29189760	29189760	PRJNA1255065_P_NODE_114269_length_168_cov_0.873950_g112041_i0	PRJNA1255065	114269	168	0.87395	1.468236	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	50.8	1.87e-5	NR	PAA57971.1	282301	g112041	i0	66.7	1.76785714285714	33	11	58.9	0	3	101	1769	1801	PAA57971.1 hypothetical protein BOX15_Mlig026265g1 [Macrostomum lignano]	diamond	297	50.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
29947486	29947486	PRJNA1255065_P_NODE_115331_length_168_cov_0.873950_g113103_i0	PRJNA1255065	115331	168	0.87395	1.468236	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	107	2.9200000000000003e-26	NR	PAA94567.1	282301	g113103	i0	85.5	0.982142857142857	55	8	98.2	0	166	2	65	119	PAA94567.1 hypothetical protein BOX15_Mlig029059g1 [Macrostomum lignano]	diamond	165	107	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);;