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

5 rows where analysis = "diamond", bioproject = "PRJNA792582" 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
26864231	26864231	PRJNA792582_P_NODE_44601_length_265_cov_1.828125_g43787_i0	PRJNA792582	44601	265	1.828125	4.84453125	Owenia fusiformis	6347	Annelida	Annelida	103	1.94e-23	NR	CAH1772664.1	6347	g43787	i0	57	0.973584905660377	86	36	96.2	1	3	257	656	741	CAH1772664.1 unnamed protein product [Owenia fusiformis]	diamond	258	103	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
26936321	26936321	PRJNA792582_P_NODE_14942_length_445_cov_1.252688_g14129_i0	PRJNA792582	14942	445	1.252688	5.5744616	Metazoa	33208	Annelida	Annelida	59.3	5.38e-7	NR	KAK2140645.1	53620	g14129	i0	51	0.923595505617978	49	23	32.4	1	9	152	492	540	KAK2140645.1 hypothetical protein LSH36_1285g00055 [Paralvinella palmiformis]	diamond	411	59.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
27094539	27094539	PRJNA792582_P_NODE_17542_length_411_cov_5.162722_g16728_i0	PRJNA792582	17542	411	5.162722	21.21878742	Metazoa	33208	Annelida	Annelida	193	1.18e-54	NR	CAH1774938.1	6347	g16728	i0	69.6	142.85401459854	135	41	98.5	0	406	2	388	522	CAH1774938.1 unnamed protein product [Owenia fusiformis]	diamond	58713	194	0.994845360824742	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28285275	28285275	PRJNA792582_P_NODE_55386_length_245_cov_1.174419_g54572_i0	PRJNA792582	55386	245	1.174419	2.87732655	Paralvinella palmiformis	53620	Annelida	Annelida	43.1	0.0267	NR	KAK2156904.1	53620	g54572	i0	32.9	0.893877551020408	73	48	89.4	1	17	235	253	324	KAK2156904.1 hypothetical protein LSH36_202g04001 [Paralvinella palmiformis]	diamond	219	43.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
32686541	32686541	PRJNA792582_P_NODE_52500_length_248_cov_1.320000_g51686_i0	PRJNA792582	52500	248	1.32	3.2736	Metazoa	33208	Annelida	Annelida	149	1.9e-40	NR	CAH1782481.1	6347	g51686	i0	85.4	42.6290322580645	82	12	99.2	0	2	247	79	160	CAH1782481.1 unnamed protein product [Owenia fusiformis]	diamond	10572	150	0.993333333333333	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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