metadata: contig_metadata: 19 rows where bioproject = "PRJNA1011833", tax_clade = "Opisthokonta" and tax

19 rows where bioproject = "PRJNA1011833", 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
155303	155303	PRJNA1011833_S_NODE_10981_length_357_cov_3.375796_g10562_i0	PRJNA1011833	10981	357	3.375796	12.05159172	Lamellibrachia satsuma	104711	Annelida	Annelida	130	1.42e-34	NR	KAI0217027.1	104711	g10562	i0	64.5	5.09243697478992	93	33	78.2	0	319	41	168	260	KAI0217027.1 General transcription factor IIF subunit 2 [Lamellibrachia satsuma]	diamond	1818	130	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
11633903	11633903	PRJNA1011833_S_NODE_13330_length_329_cov_4.447552_g12910_i0	PRJNA1011833	13330	329	4.447552	14.63244608	Metazoa	33208	Annelida	Annelida	122	1.98e-32	NR	CAH1783921.1	6347	g12910	i0	54.6	44.4255319148936	108	49	98.5	0	3	326	56	163	CAH1783921.1 unnamed protein product [Owenia fusiformis]	diamond	14616	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
19280810	19280810	PRJNA1011833_S_NODE_11056_length_356_cov_2.613419_g10637_i0	PRJNA1011833	11056	356	2.613419	9.30377164	Hirudo verbana	311461	Annelida	Annelida	62.1	5.6e-5	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g10637	i0	100	0.0926966292134832	33	0	9	0	5	37	5830502	5830470	Hirudo verbana genome assembly, chromosome: 7	blastn	33	62.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
27248330	27248330	PRJNA1011833_S_NODE_43323_length_176_cov_3.984962_g42903_i0	PRJNA1011833	43323	176	3.984962	7.01353312	Metazoa	33208	Annelida	Annelida	57.4	1.03e-7	NR	CAH1797464.1	6347	g42903	i0	53.8	9.71590909090909	52	24	88.6	0	174	19	1605	1656	CAH1797464.1 unnamed protein product [Owenia fusiformis]	diamond	1710	57.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27255893	27255893	PRJNA1011833_S_NODE_3943_length_502_cov_13.644880_g3543_i0	PRJNA1011833	3943	502	13.64488	68.4972976	Paralvinella palmiformis	53620	Annelida	Annelida	62.4	6.78e-9	NR	KAK2163798.1	53620	g3543	i0	29.2	0.573705179282869	96	68	57.4	0	173	460	44	139	KAK2163798.1 hypothetical protein LSH36_74g11125 [Paralvinella palmiformis]	diamond	288	62.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
27816980	27816980	PRJNA1011833_S_NODE_6444_length_431_cov_4.670103_g6029_i0	PRJNA1011833	6444	431	4.670103	20.12814393	Metazoa	33208	Annelida	Annelida	71.2	5.78e-12	NR	XP_009019383.1	6412	g6029	i0	52.6	2.94431554524362	78	36	53.6	1	430	200	86	163	XP_009019383.1 hypothetical protein HELRODRAFT_155763 [Helobdella robusta]	diamond	1269	71.6	0.994413407821229	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28076895	28076895	PRJNA1011833_S_NODE_14985_length_312_cov_1.572491_g14565_i0	PRJNA1011833	14985	312	1.572491	4.90617192	Capitella teleta	283909	Annelida	Annelida	115	4.36e-28	NR	ELU17997.1	283909	g14565	i0	67.4	13.2307692307692	86	28	82.7	0	259	2	148	233	ELU17997.1 hypothetical protein CAPTEDRAFT_76358, partial [Capitella teleta]	diamond	4128	115	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
28290262	28290262	PRJNA1011833_S_NODE_47906_length_167_cov_1.935484_g47486_i0	PRJNA1011833	47906	167	1.935484	3.23225828	Metazoa	33208	Annelida	Annelida	58.9	4.09e-9	NR	CAH1772653.1	6347	g47486	i0	46.3	4.76047904191617	54	29	97	0	162	1	73	126	CAH1772653.1 unnamed protein product [Owenia fusiformis]	diamond	795	58.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28416834	28416834	PRJNA1011833_S_NODE_5926_length_443_cov_4.252500_g5514_i0	PRJNA1011833	5926	443	4.2525	18.838575	Metazoa	33208	Annelida	Annelida	72.4	2.93e-12	NR	KAK2187454.1	27915	g5514	i0	31.9	7.79458239277652	135	80	84.7	3	1	375	92	224	KAK2187454.1 hypothetical protein NP493_165g06015 [Ridgeia piscesae]	diamond	3453	72.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
28708643	28708643	PRJNA1011833_S_NODE_25947_length_233_cov_2.273684_g25527_i0	PRJNA1011833	25947	233	2.273684	5.29768372	Capitella teleta	283909	Annelida	Annelida	68.9	1.93e-11	NR	ELU12607.1	283909	g25527	i0	48.3	0.772532188841202	60	31	77.3	0	6	185	738	797	ELU12607.1 hypothetical protein CAPTEDRAFT_218920 [Capitella teleta]	diamond	180	68.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
29048308	29048308	PRJNA1011833_S_NODE_14768_length_314_cov_2.302583_g14348_i0	PRJNA1011833	14768	314	2.302583	7.23011062	Metazoa	33208	Annelida	Annelida	123	3.6699999999999995e-30	NR	XP_009026502.1	6412	g14348	i0	53.8	8.94267515923567	104	48	99.4	0	2	313	186	289	XP_009026502.1 hypothetical protein HELRODRAFT_193557 [Helobdella robusta]	diamond	2808	123	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29395524	29395524	PRJNA1011833_S_NODE_12049_length_343_cov_4.156667_g11629_i0	PRJNA1011833	12049	343	4.156667	14.25736781	Annelida	6340	Annelida	Annelida	54.3	4.94e-6	NR	XP_009025440.1	6412	g11629	i0	51.9	2.07288629737609	52	25	45.5	0	341	186	126	177	XP_009025440.1 hypothetical protein HELRODRAFT_185077 [Helobdella robusta]	diamond	711	54.7	0.992687385740402	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29750166	29750166	PRJNA1011833_S_NODE_4231_length_492_cov_3.336303_g3829_i0	PRJNA1011833	4231	492	3.336303	16.41461076	Paralvinella palmiformis	53620	Annelida	Annelida	54.3	4.62e-5	NR	KAK2165386.1	53620	g3829	i0	39	0.5	82	49	50	1	369	124	363	443	KAK2165386.1 hypothetical protein LSH36_51g06003 [Paralvinella palmiformis]	diamond	246	54.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
29876861	29876861	PRJNA1011833_S_NODE_3771_length_509_cov_15.605150_g3372_i0	PRJNA1011833	3771	509	15.60515	79.4302135	Helobdella robusta	6412	Annelida	Annelida	150	1e-40	NR	XP_009029093.1	6412	g3372	i0	51.4	6.00589390962672	144	66	83.7	3	508	83	198	339	XP_009029093.1 hypothetical protein HELRODRAFT_185160 [Helobdella robusta]	diamond	3057	150	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30184957	30184957	PRJNA1011833_S_NODE_3472_length_523_cov_8.872917_g3079_i0	PRJNA1011833	3472	523	8.872917	46.40535591	Metazoa	33208	Annelida	Annelida	83.2	3.07e-15	NR	KAI0208194.1	104711	g3079	i0	35.2	2.5697896749522	159	95	86.6	2	22	474	172	330	KAI0208194.1 Secretory carrier-associated membrane protein 3 [Lamellibrachia satsuma]	diamond	1344	83.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30382663	30382663	PRJNA1011833_S_NODE_25413_length_236_cov_1.430052_g24993_i0	PRJNA1011833	25413	236	1.430052	3.37492272	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	42.7	0.033	NR	CAD5125273.1	2664684	g24993	i0	35.8	1.02966101694915	81	42	95.3	2	236	12	271	347	CAD5125273.1 DgyrCDS13520 [Dimorphilus gyrociliatus]	diamond	243	42.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
30919544	30919544	PRJNA1011833_S_NODE_25954_length_233_cov_2.252632_g25534_i0	PRJNA1011833	25954	233	2.252632	5.24863256	Paralvinella palmiformis	53620	Annelida	Annelida	65.1	4.31e-10	NR	KAK2145597.1	53620	g25534	i0	38.2	2.88412017167382	76	47	97.9	0	231	4	142	217	KAK2145597.1 hypothetical protein LSH36_669g01023 [Paralvinella palmiformis]	diamond	672	65.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31259372	31259372	PRJNA1011833_S_NODE_1595_length_687_cov_10.177019_g1282_i0	PRJNA1011833	1595	687	10.177019	69.91612053	Metazoa	33208	Annelida	Annelida	264	8.11e-86	NR	CAH1784968.1	6347	g1282	i0	81.9	43.3406113537118	155	28	67.7	0	685	221	76	230	CAH1784968.1 unnamed protein product [Owenia fusiformis]	diamond	29775	266	0.992481203007519	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32050152	32050152	PRJNA1011833_S_NODE_10378_length_365_cov_2.934783_g9960_i0	PRJNA1011833	10378	365	2.934783	10.71195795	Metazoa	33208	Annelida	Annelida	53.9	1.71e-5	NR	KAK2185683.1	27915	g9960	i0	41.8	2.76986301369863	79	43	64.9	2	357	121	370	445	KAK2185683.1 hypothetical protein NP493_226g02013 [Ridgeia piscesae]	diamond	1011	53.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae

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