metadata: contig_metadata: 19 rows where bioproject = "PRJNA975724", tax_kingdom = "Metazoa" and tax

19 rows where bioproject = "PRJNA975724", tax_kingdom = "Metazoa" 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
2220729	2220729	PRJNA975724_S_NODE_1202_length_765_cov_10.144509_g1056_i0	PRJNA975724	1202	765	10.144509	77.60549385	Paralvinella palmiformis	53620	Annelida	Annelida	226	1.74e-68	NR	KAK2152681.1	53620	g1056	i0	74.3	4.75294117647059	152	37	59.2	2	1	453	236	386	KAK2152681.1 hypothetical protein LSH36_321g00017 [Paralvinella palmiformis]	diamond	3636	226	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
2221795	2221795	PRJNA975724_S_NODE_53262_length_291_cov_1.311927_g53081_i0	PRJNA975724	53262	291	1.311927	3.81770757	Metazoa	33208	Annelida	Annelida	129	3.8e-33	NR	CAH1792308.1	6347	g53081	i0	58.7	11.360824742268	92	38	94.8	0	3	278	327	418	CAH1792308.1 unnamed protein product [Owenia fusiformis]	diamond	3306	129	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
3496517	3496517	PRJNA975724_S_NODE_31003_length_345_cov_1.132353_g30822_i0	PRJNA975724	31003	345	1.132353	3.90661785	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	60.2	1.95e-4	NTclustered	gi\|2920003484\|emb\|OZ238865.1\|	1046305	g30822	i0	97.143	1.41449275362319	35	1	10	0	296	330	27773905	27773871	Ailoscolex lacteospumosus genome assembly, chromosome: 6	blastn	488	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
3496595	3496595	PRJNA975724_S_NODE_34163_length_335_cov_1.938931_g33982_i0	PRJNA975724	34163	335	1.938931	6.49541885	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.032	NTclustered	gi\|2920003323\|emb\|OZ238861.1\|	1046305	g33982	i0	100	0.0835820895522388	28	0	8	0	88	115	6411909	6411936	Ailoscolex lacteospumosus genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
12426499	12426499	PRJNA975724_S_NODE_84370_length_246_cov_1.485549_g84189_i0	PRJNA975724	84370	246	1.485549	3.65445054	Arenicola marina	6344	Annelida	Annelida	64.7	1.44e-10	NR	ABW23171.1	6344	g84189	i0	61.2	6.90243902439024	49	19	59.8	0	246	100	128	176	ABW23171.1 ribosomal protein rpl17 [Arenicola marina]	diamond	1698	64.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
13699133	13699133	PRJNA975724_S_NODE_14571_length_415_cov_12.464912_g14390_i0	PRJNA975724	14571	415	12.464912	51.7293848	Opisthokonta	33154	Annelida	Annelida	108	1.5600000000000002e-27	NR	XP_009025143.1	6412	g14390	i0	57.9	5.50120481927711	95	40	68.7	0	73	357	7	101	XP_009025143.1 hypothetical protein HELRODRAFT_67827 [Helobdella robusta]	diamond	2283	108	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
20072605	20072605	PRJNA975724_S_NODE_34316_length_334_cov_11.919540_g34135_i0	PRJNA975724	34316	334	11.91954	39.8112636	Arenicola marina	6344	Annelida	Annelida	200	1.06e-46	NTclustered	gi\|158187717\|gb\|EU124943.1\|	6344	g34135	i0	81.967	80.9580838323353	244	37	72	7	64	304	107	346	Arenicola marina ribosomal protein rps18 mRNA, partial cds	blastn	27040	200	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
26779137	26779137	PRJNA975724_S_NODE_4021_length_550_cov_4.230608_g3843_i0	PRJNA975724	4021	550	4.230608	23.268344	Metazoa	33208	Annelida	Annelida	102	7.15e-22	NR	CAH1773839.1	6347	g3843	i0	48	3.68727272727273	98	50	52.9	1	4	294	270	367	CAH1773839.1 unnamed protein product [Owenia fusiformis]	diamond	2028	102	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
27443418	27443418	PRJNA975724_S_NODE_24103_length_369_cov_1.851351_g23922_i0	PRJNA975724	24103	369	1.851351	6.83148519	Metazoa	33208	Annelida	Annelida	128	1.27e-33	NR	KAK2169273.1	27915	g23922	i0	64.1	20.4471544715447	92	33	74.8	0	353	78	184	275	KAK2169273.1 hypothetical protein NP493_1197g00015 [Ridgeia piscesae]	diamond	7545	129	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
27759149	27759149	PRJNA975724_S_NODE_20224_length_385_cov_5.394231_g20043_i0	PRJNA975724	20224	385	5.3942310000000004	20.76778935	Annelida	6340	Annelida	Annelida	65.5	6.58e-10	NR	XP_009020642.1	6412	g20043	i0	40	1.3012987012987	75	45	58.4	0	28	252	141	215	XP_009020642.1 hypothetical protein HELRODRAFT_81815 [Helobdella robusta]	diamond	501	65.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
27815938	27815938	PRJNA975724_S_NODE_79024_length_251_cov_0.865169_g78843_i0	PRJNA975724	79024	251	0.865169	2.17157419	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	43.5	0.0223	NR	CAD5113532.1	2664684	g78843	i0	38.2	0.657370517928287	55	34	65.7	0	248	84	912	966	CAD5113532.1 DgyrCDS2694 [Dimorphilus gyrociliatus]	diamond	165	43.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
28800564	28800564	PRJNA975724_S_NODE_41447_length_316_cov_2.218107_g41266_i0	PRJNA975724	41447	316	2.218107	7.00921812	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.6	0.00148	NR	CAH1789287.1	6347	g41266	i0	43.6	1.04430379746835	55	31	52.2	0	314	150	98	152	CAH1789287.1 unnamed protein product [Owenia fusiformis]	diamond	330	46.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28990518	28990518	PRJNA975724_S_NODE_52008_length_293_cov_1.895455_g51827_i0	PRJNA975724	52008	293	1.895455	5.55368315	Metazoa	33208	Annelida	Annelida	103	6.39e-25	NR	CAH1798256.1	6347	g51827	i0	74.6	23.5597269624573	63	14	62.5	1	2	184	182	244	CAH1798256.1 unnamed protein product [Owenia fusiformis]	diamond	6903	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29558435	29558435	PRJNA975724_S_NODE_39310_length_321_cov_2.419355_g39129_i0	PRJNA975724	39310	321	2.419355	7.76612955	Metazoa	33208	Annelida	Annelida	82	1.22e-15	NR	CAH1775393.1	6347	g39129	i0	86.7	6.16822429906542	45	6	42.1	0	319	185	386	430	CAH1775393.1 unnamed protein product [Owenia fusiformis]	diamond	1980	82.8	0.990338164251208	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30032369	30032369	PRJNA975724_S_NODE_47091_length_303_cov_2.008696_g46910_i0	PRJNA975724	47091	303	2.008696	6.08634888	Metazoa	33208	Annelida	Annelida	104	6.88e-24	NR	XP_009021881.1	6412	g46910	i0	64.6	1.56435643564356	79	28	78.2	0	2	238	340	418	XP_009021881.1 hypothetical protein HELRODRAFT_187263 [Helobdella robusta]	diamond	474	104	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30253690	30253690	PRJNA975724_S_NODE_26412_length_360_cov_3.432056_g26231_i0	PRJNA975724	26412	360	3.432056	12.3554016	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.4	2.94e-10	NR	KAK2165567.1	53620	g26231	i0	44.2	2.94166666666667	86	41	70.8	2	346	92	335	414	KAK2165567.1 hypothetical protein LSH36_48g02049 [Paralvinella palmiformis]	diamond	1059	67.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30594586	30594586	PRJNA975724_S_NODE_42533_length_314_cov_0.958506_g42352_i0	PRJNA975724	42533	314	0.958506	3.00970884	Ridgeia piscesae	27915	Annelida	Annelida	66.6	1.94e-11	NR	KAK2189599.1	27915	g42352	i0	57.7	0.993630573248408	52	22	49.7	0	312	157	77	128	KAK2189599.1 hypothetical protein NP493_101g02000 [Ridgeia piscesae]	diamond	312	66.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31384956	31384956	PRJNA975724_S_NODE_42956_length_313_cov_1.179167_g42775_i0	PRJNA975724	42956	313	1.179167	3.69079271	Lamellibrachia satsuma	104711	Annelida	Annelida	96.7	8.6e-21	NR	KAI0227552.1	104711	g42775	i0	56.7	0.862619808306709	90	34	81.5	1	5	259	415	504	KAI0227552.1 Hercynylcysteine sulfoxide lyase [Lamellibrachia satsuma]	diamond	270	96.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
31606241	31606241	PRJNA975724_S_NODE_49976_length_297_cov_2.026786_g49795_i0	PRJNA975724	49976	297	2.026786	6.01955442	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	53.9	8.27e-6	NR	CAD5115921.1	2664684	g49795	i0	36.4	2.68686868686869	88	55	88.9	1	275	12	693	779	CAD5115921.1 DgyrCDS4852 [Dimorphilus gyrociliatus]	diamond	798	53.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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