metadata: contig_metadata: 18 rows where bioproject = "PRJNA689790", tax_kingdom = "Metazoa" and tax

18 rows where bioproject = "PRJNA689790", 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
668768	668768	PRJNA689790_S_NODE_6841_length_227_cov_1.494737_g6726_i0	PRJNA689790	6841	227	1.494737	3.39305299	Helobdella robusta	6412	Annelida	Annelida	112	1.79e-28	NR	XP_009024801.1	6412	g6726	i0	80.3	5.62995594713656	71	14	93.8	0	14	226	1	71	XP_009024801.1 hypothetical protein HELRODRAFT_155141 [Helobdella robusta]	diamond	1278	112	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
1944761	1944761	PRJNA689790_S_NODE_16302_length_152_cov_1.356522_g16187_i0	PRJNA689790	16302	152	1.356522	2.06191344	Cirriformia luxuriosa	398471	Annelida	Annelida	108	2.62e-19	NTclustered	gi\|112144461\|gb\|DQ813355.1\|	398471	g16187	i0	87.234	18.2697368421053	94	12	62	0	53	146	503	596	Cirriformia luxuriosa elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds	blastn	2777	108	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Cirratulidae	Cirriformia	Cirriformia luxuriosa
10872755	10872755	PRJNA689790_S_NODE_10669_length_182_cov_1.289655_g10554_i0	PRJNA689790	10669	182	1.289655	2.3471721	Metazoa	33208	Annelida	Annelida	129	1.2e-33	NR	KAK2159364.1	53620	g10554	i0	93.3	14.8351648351648	60	4	98.9	0	182	3	178	237	KAK2159364.1 hypothetical protein LSH36_154g06008 [Paralvinella palmiformis]	diamond	2700	130	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
12657533	12657533	PRJNA689790_S_NODE_13570_length_163_cov_2.166667_g13455_i0	PRJNA689790	13570	163	2.166667	3.53166721	Opisthokonta	33154	Annelida	Annelida	54.7	0.004	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g13455	i0	94.286	2.50306748466258	35	2	21	0	55	89	652232	652266	Hirudo verbana genome assembly, chromosome: 13	blastn	408	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18520779	18520779	PRJNA689790_S_NODE_14655_length_158_cov_2.256198_g14540_i0	PRJNA689790	14655	158	2.256198	3.56479284	Hirudo verbana	311461	Annelida	Annelida	58.4	2.81e-4	NTclustered	gi\|2918369706\|emb\|OZ237788.1\|	311461	g14540	i0	92.5	0.253164556962025	40	3	25	0	111	150	1492683	1492722	Hirudo verbana genome assembly, chromosome: 10	blastn	40	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
24894913	24894913	PRJNA689790_S_NODE_15200_length_156_cov_1.630252_g15085_i0	PRJNA689790	15200	156	1.630252	2.54319312	Helobdella robusta	6412	Annelida	Annelida	89.8	9.79e-14	NTclustered	gi\|675878013\|ref\|XM_009026319.1\|	6412	g15085	i0	81.905	3.98076923076923	105	19	67	0	42	146	288	184	Helobdella robusta hypothetical protein mRNA	blastn	621	89.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
24894967	24894967	PRJNA689790_S_NODE_6560_length_233_cov_1.515306_g6445_i0	PRJNA689790	6560	233	1.515306	3.53066298	Hirudo verbana	311461	Annelida	Annelida	58.4	4.48e-4	NTclustered	gi\|2918369643\|emb\|OZ237784.1\|	311461	g6445	i0	97.059	0.145922746781116	34	1	15	0	91	124	9986770	9986737	Hirudo verbana genome assembly, chromosome: 6	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
26670545	26670545	PRJNA689790_S_NODE_12481_length_169_cov_2.068182_g12366_i0	PRJNA689790	12481	169	2.068182	3.49522758	Ridgeia piscesae	27915	Annelida	Annelida	77.4	7.88e-15	NR	KAK2172443.1	27915	g12366	i0	56.4	1.95266272189349	55	24	97.6	0	167	3	453	507	KAK2172443.1 hypothetical protein NP493_960g01001 [Ridgeia piscesae]	diamond	330	77.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
28767515	28767515	PRJNA689790_S_NODE_10047_length_187_cov_1.520000_g9932_i0	PRJNA689790	10047	187	1.52	2.8424	Metazoa	33208	Annelida	Annelida	106	3.23e-26	NR	CAH1786155.1	6347	g9932	i0	82	28.379679144385	61	11	97.9	0	184	2	40	100	CAH1786155.1 unnamed protein product [Owenia fusiformis]	diamond	5307	106	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28913728	28913728	PRJNA689790_S_NODE_6308_length_238_cov_2.328358_g6193_i0	PRJNA689790	6308	238	2.328358	5.54149204	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	60.1	2.68e-8	NR	CAD5126109.1	2664684	g6193	i0	42	0.869747899159664	69	38	87	2	19	225	208	274	CAD5126109.1 DgyrCDS14281 [Dimorphilus gyrociliatus]	diamond	207	60.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29272547	29272547	PRJNA689790_S_NODE_11289_length_177_cov_1.392857_g11174_i0	PRJNA689790	11289	177	1.392857	2.46535689	Metazoa	33208	Annelida	Annelida	53.1	3.35e-6	NR	CAH1792601.1	6347	g11174	i0	51.9	3.86440677966102	54	17	76.3	1	141	7	613	666	CAH1792601.1 unnamed protein product [Owenia fusiformis]	diamond	684	53.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29702925	29702925	PRJNA689790_S_NODE_8010_length_209_cov_1.087209_g7895_i0	PRJNA689790	8010	209	1.087209	2.27226681	Lamellibrachia satsuma	104711	Annelida	Annelida	68.2	2.57e-11	NR	KAI0209873.1	104711	g7895	i0	73.7	0.545454545454545	38	10	54.5	0	2	115	608	645	KAI0209873.1 Protein DD3-3 [Lamellibrachia satsuma]	diamond	114	68.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
29702928	29702928	PRJNA689790_S_NODE_9670_length_190_cov_2.150327_g9555_i0	PRJNA689790	9670	190	2.150327	4.0856213	Owenia fusiformis	6347	Annelida	Annelida	47.4	4.37e-4	NR	CAH1784022.1	6347	g9555	i0	44	1.51578947368421	50	28	78.9	0	5	154	498	547	CAH1784022.1 unnamed protein product [Owenia fusiformis]	diamond	288	47.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30093637	30093637	PRJNA689790_S_NODE_4412_length_289_cov_1.702381_g4297_i0	PRJNA689790	4412	289	1.702381	4.91988109	Metazoa	33208	Annelida	Annelida	93.6	2e-20	NR	KAK2157618.1	53620	g4297	i0	87.8	4.03806228373702	49	6	50.9	0	1	147	163	211	KAK2157618.1 hypothetical protein LSH36_188g09042 [Paralvinella palmiformis]	diamond	1167	93.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30461924	30461924	PRJNA689790_S_NODE_13153_length_165_cov_3.000000_g13038_i0	PRJNA689790	13153	165	3	4.95	Helobdella robusta	6412	Annelida	Annelida	70.1	5.32e-13	NR	XP_009028941.1	6412	g13038	i0	63.6	8	55	20	100	0	1	165	25	79	XP_009028941.1 hypothetical protein HELRODRAFT_185136 [Helobdella robusta]	diamond	1320	70.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
31378036	31378036	PRJNA689790_S_NODE_11376_length_176_cov_2.237410_g11261_i0	PRJNA689790	11376	176	2.23741	3.9378416	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	95.5	5.37e-24	NR	CAD5122772.1	2664684	g11261	i0	81.8	1.84090909090909	55	10	93.8	0	167	3	36	90	CAD5122772.1 DgyrCDS11179 [Dimorphilus gyrociliatus]	diamond	324	95.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
31630903	31630903	PRJNA689790_S_NODE_5436_length_257_cov_3.527273_g5321_i0	PRJNA689790	5436	257	3.527273	9.06509161	Lamellibrachia satsuma	104711	Annelida	Annelida	68.9	2.19e-12	NR	KAI0209284.1	104711	g5321	i0	53.2	1.75097276264591	62	29	72.4	0	192	7	29	90	KAI0209284.1 60S ribosomal protein L35a [Lamellibrachia satsuma]	diamond	450	68.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
32528554	32528554	PRJNA689790_S_NODE_13699_length_163_cov_0.928571_g13584_i0	PRJNA689790	13699	163	0.928571	1.51357073	Metazoa	33208	Annelida	Annelida	79.3	1.6e-15	NR	CAH1794555.1	6347	g13584	i0	67.9	11.2453987730061	53	17	97.5	0	163	5	529	581	CAH1794555.1 unnamed protein product [Owenia fusiformis]	diamond	1833	79.3	1	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);;