metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA752572" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA752572" 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
9657125	9657125	PRJNA752572_P_NODE_4688_length_1088_cov_24.529915_g4470_i0	PRJNA752572	4688	1088	24.529915	266.8854752	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	276	4.9000000000000015e-87	NR	AAN28680.1	13286	g4470	i0	48.6	3.53216911764706	348	144	88	13	69	1025	10	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	3843	278	0.992805755395683	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
24955106	24955106	PRJNA752572_P_NODE_11740_length_760_cov_3.867586_g11375_i0	PRJNA752572	11740	760	3.867586	29.3936536	Owenia fusiformis	6347	Annelida	Annelida	249	2.4599999999999993e-74	NR	CAH1789021.1	6347	g11375	i0	58.5	1.58289473684211	200	81	78.6	2	760	164	476	674	CAH1789021.1 unnamed protein product [Owenia fusiformis]	diamond	1203	249	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27274140	27274140	PRJNA752572_P_NODE_104523_length_264_cov_1.742358_g104016_i0	PRJNA752572	104523	264	1.742358	4.59982512	Pectinaria gouldii	260746	Annelida	Annelida	102	1.09e-25	NR	ACJ09354.1	260746	g104016	i0	70.7	0.931818181818182	82	23	93.2	1	247	2	1	81	ACJ09354.1 hypothetical protein [Pectinaria gouldii]	diamond	246	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Pectinariidae	Pectinaria	Pectinaria gouldii
27852352	27852352	PRJNA752572_P_NODE_243624_length_170_cov_2.074074_g243117_i0	PRJNA752572	243624	170	2.074074	3.5259258	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82	7.5e-17	NR	XP_009028105.1	6412	g243117	i0	64.3	11.6823529411765	56	20	98.8	0	168	1	200	255	XP_009028105.1 hypothetical protein HELRODRAFT_88168 [Helobdella robusta]	diamond	1986	82.8	0.990338164251208	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27874113	27874113	PRJNA752572_P_NODE_210785_length_183_cov_1.337838_g210278_i0	PRJNA752572	210785	183	1.337838	2.44824354	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	50.8	2.32e-5	NR	CAD5117623.1	2664684	g210278	i0	42.6	1	61	34	98.4	1	2	181	995	1055	CAD5117623.1 DgyrCDS6378 [Dimorphilus gyrociliatus]	diamond	183	50.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
28063520	28063520	PRJNA752572_P_NODE_7925_length_895_cov_3.433721_g7631_i0	PRJNA752572	7925	895	3.433721	30.73180295	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	76.6	1.71e-11	NR	CAD5111537.1	2664684	g7631	i0	29.6	1.67597765363128	250	145	78.1	12	35	733	40	275	CAD5111537.1 DgyrCDS840 [Dimorphilus gyrociliatus]	diamond	1500	76.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29736759	29736759	PRJNA752572_P_NODE_124850_length_240_cov_2.336585_g124343_i0	PRJNA752572	124850	240	2.336585	5.607804	Helobdella robusta	6412	Annelida	Annelida	48.5	3.23e-4	NR	XP_009029697.1	6412	g124343	i0	30.7	1.775	75	46	86.3	1	6	212	238	312	XP_009029697.1 hypothetical protein HELRODRAFT_157973 [Helobdella robusta]	diamond	426	48.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30242535	30242535	PRJNA752572_P_NODE_185492_length_196_cov_1.223602_g184985_i0	PRJNA752572	185492	196	1.223602	2.39825992	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	78.2	5.73e-15	NR	CAD5117400.1	2664684	g184985	i0	56.3	6.8265306122449	64	28	98	0	194	3	205	268	CAD5117400.1 DgyrCDS6173 [Dimorphilus gyrociliatus]	diamond	1338	78.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30599729	30599729	PRJNA752572_P_NODE_275153_length_162_cov_1.566929_g274646_i0	PRJNA752572	275153	162	1.566929	2.53842498	Metazoa	33208	Annelida	Annelida	60.1	9.29e-9	NR	CAH1772611.1	6347	g274646	i0	54.3	8.14814814814815	46	21	85.2	0	161	24	539	584	CAH1772611.1 unnamed protein product [Owenia fusiformis]	diamond	1320	60.5	0.993388429752066	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31443305	31443305	PRJNA752572_P_NODE_43016_length_417_cov_2.751309_g42511_i0	PRJNA752572	43016	417	2.751309	11.47295853	Capitella teleta	283909	Annelida	Annelida	149	9.99e-39	NR	ELU17469.1	283909	g42511	i0	53.2	7.01438848920863	141	58	99.3	3	3	416	1839	1974	ELU17469.1 hypothetical protein CAPTEDRAFT_228350 [Capitella teleta]	diamond	2925	149	1	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);;