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

4 rows where bioproject = "PRJNA1073183", tax_clade = "Opisthokonta" 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
1461961	1461961	PRJNA1073183_P_NODE_3422_length_678_cov_3.709091_g3335_i0	PRJNA1073183	3422	678	3.709091	25.14763698	Sabellida	6362	Annelida	Annelida	199	6.41e-61	NR	CAH1784699.1	6347	g3335	i0	55	14.4513274336283	191	80	84.5	2	37	609	1	185	CAH1784699.1 unnamed protein product [Owenia fusiformis]	diamond	9798	199	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27438412	27438412	PRJNA1073183_P_NODE_25683_length_255_cov_1.401099_g25588_i0	PRJNA1073183	25683	255	1.401099	3.57280245	Metazoa	33208	Annelida	Annelida	155	1.3599999999999999e-42	NR	CAH1781234.1	6347	g25588	i0	88.1	44.4705882352941	84	10	98.8	0	2	253	361	444	CAH1781234.1 unnamed protein product [Owenia fusiformis]	diamond	11340	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29427070	29427070	PRJNA1073183_P_NODE_12449_length_366_cov_2.163823_g12354_i0	PRJNA1073183	12449	366	2.163823	7.91959218	Metazoa	33208	Annelida	Annelida	129	9.55e-36	NR	ABW90363.1	6446	g12354	i0	69.1	12.5901639344262	94	29	77	0	85	366	6	99	ABW90363.1 putative ribosomal protein L31 [Sipunculus nudus]	diamond	4608	130	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Annelida	Sipuncula	Golfingiida	Sipunculidae	Sipunculus	Sipunculus nudus
32682454	32682454	PRJNA1073183_P_NODE_21640_length_282_cov_1.105263_g21545_i0	PRJNA1073183	21640	282	1.105263	3.11684166	Metazoa	33208	Annelida	Annelida	114	1.04e-28	NR	XP_009024124.1	6412	g21545	i0	61.7	16	94	35	100	1	1	282	117	209	XP_009024124.1 hypothetical protein HELRODRAFT_185887 [Helobdella robusta]	diamond	4512	114	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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