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

4 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Annelida"

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
32914171	32914171	PRJEB8827h_S_NODE_601_length_347_cov_2.108974_g582_i0	PRJEB8827	601	347	2.108974	7.31813978	Eurythoe complanata	167815	Annelida	Annelida	84	3.46e-17	NR	ABW23216.1	167815	g582	i0	64.3	6.25936599423631	56	20	48.4	0	347	180	153	208	ABW23216.1 ribosomal protein rpl10 [Eurythoe complanata]	diamond	2172	84	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Eunicida	Amphinomidae	Eurythoe	Eurythoe complanata
33008780	33008780	PRJEB8827f_S_NODE_9747_length_182_cov_1.251701_g9727_i0	PRJEB8827	9747	182	1.251701	2.27809582	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	108	1.29e-26	NR	KAK2181487.1	27915	g9727	i0	83.6	7.07142857142857	55	9	90.7	0	3	167	284	338	KAK2181487.1 hypothetical protein NP493_396g02012 [Ridgeia piscesae]	diamond	1287	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
33033508	33033508	PRJEB8827b_S_NODE_3124_length_221_cov_1627.225806_g3072_i0	PRJEB8827	3124	221	1627.225806	3596.16903126	Capitella teleta	283909	Annelida	Annelida	69.7	8.57e-12	NR	ELU14708.1	283909	g3072	i0	54.2	1.45248868778281	59	27	80.1	0	180	4	81	139	ELU14708.1 hypothetical protein CAPTEDRAFT_122874 [Capitella teleta]	diamond	321	69.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
33111067	33111067	PRJEB8827f_S_NODE_2054_length_290_cov_4.184314_g2034_i0	PRJEB8827	2054	290	4.184314	12.1345106	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	131	2.18e-34	NR	ELU06845.1	283909	g2034	i0	71.3	4.48965517241379	87	23	90	1	290	30	308	392	ELU06845.1 hypothetical protein CAPTEDRAFT_183346 [Capitella teleta]	diamond	1302	132	0.992424242424242	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta

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