metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA857857" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA857857" 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
11049034	11049034	PRJNA857857_P_NODE_49389_length_242_cov_1.609467_g48940_i0	PRJNA857857	49389	242	1.609467	3.89491014	Metazoa	33208	Annelida	Annelida	79.7	3.47e-15	NR	KAK2191170.1	27915	g48940	i0	45.8	27.3719008264463	72	39	89.3	0	239	24	93	164	KAK2191170.1 hypothetical protein NP493_57g01029 [Ridgeia piscesae]	diamond	6624	80.1	0.995006242197254	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
23797684	23797684	PRJNA857857_P_NODE_6139_length_627_cov_5.864621_g5719_i0	PRJNA857857	6139	627	5.864621	36.77117367	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	224	7.759999999999999e-72	NR	XP_009028241.1	6412	g5719	i0	76.4	14.7799043062201	140	33	67	0	40	459	8	147	XP_009028241.1 hypothetical protein HELRODRAFT_115475 [Helobdella robusta]	diamond	9267	226	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
26611718	26611718	PRJNA857857_P_NODE_13301_length_432_cov_1.501393_g12855_i0	PRJNA857857	13301	432	1.501393	6.48601776	Capitella teleta	283909	Annelida	Annelida	129	1.54e-31	NR	ELT88611.1	283909	g12855	i0	45.4	0.979166666666667	141	71	97.9	3	425	3	481	615	ELT88611.1 hypothetical protein CAPTEDRAFT_195295 [Capitella teleta]	diamond	423	129	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
26991600	26991600	PRJNA857857_P_NODE_52562_length_206_cov_5.225564_g52113_i0	PRJNA857857	52562	206	5.225564	10.76466184	Helobdella robusta	6412	Annelida	Annelida	99.8	1.4000000000000002e-22	NR	XP_009019935.1	6412	g52113	i0	83.1	7.9368932038835	59	10	85.9	0	198	22	418	476	XP_009019935.1 hypothetical protein HELRODRAFT_188740 [Helobdella robusta]	diamond	1635	99.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27979232	27979232	PRJNA857857_P_NODE_17165_length_379_cov_1.424837_g16718_i0	PRJNA857857	17165	379	1.424837	5.40013223	Metazoa	33208	Annelida	Annelida	85.5	1.44e-16	NR	XP_009028227.1	6412	g16718	i0	37.5	10.7651715039578	128	74	96.6	2	13	378	66	193	XP_009028227.1 hypothetical protein HELRODRAFT_115456 [Helobdella robusta]	diamond	4080	85.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28484480	28484480	PRJNA857857_P_NODE_946_length_1391_cov_1.832322_g758_i0	PRJNA857857	946	1391	1.832322	25.48759902	root	1	Root_unresolved	Root_unresolved	51.2	0.0103	NR	CAH1777824.1	6347	g758	i0	37.5	0.638389647735442	64	40	13.8	0	628	437	605	668	CAH1777824.1 unnamed protein product, partial [Owenia fusiformis]	diamond	888	51.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29683902	29683902	PRJNA857857_P_NODE_26150_length_304_cov_0.930736_g25701_i0	PRJNA857857	26150	304	0.930736	2.82943744	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.1	6.39e-8	NR	CAH1794207.1	6347	g25701	i0	38.9	3.53289473684211	90	49	84.9	3	258	1	607	694	CAH1794207.1 unnamed protein product [Owenia fusiformis]	diamond	1074	60.5	0.993388429752066	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);;