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

19 rows where bioproject = "PRJNA316313", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

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
2936709	2936709	PRJNA316313_P_NODE_130183_length_187_cov_6.953333_g128797_i0	PRJNA316313	130183	187	6.953333	13.00273271	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.004	NTclustered	gi\|2917940712\|emb\|OZ237560.1\|	6108	g128797	i0	96.97	0.176470588235294	33	0	18	1	40	72	11166101	11166132	Anemonia sulcata genome assembly, chromosome: 6	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
16963478	16963478	PRJNA316313_P_NODE_128254_length_188_cov_2.278146_g126868_i0	PRJNA316313	128254	188	2.278146	4.28291448	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	58.4	3.46e-4	NTclustered	gi\|2917940766\|emb\|OZ237573.1\|	6108	g126868	i0	100	4.42021276595745	31	0	16	0	150	180	6485114	6485144	Anemonia sulcata genome assembly, chromosome: 19	blastn	831	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
19514653	19514653	PRJNA316313_S_NODE_1256_length_197_cov_1.381250_g1253_i0	PRJNA316313	1256	197	1.38125	2.7210625	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	98.6	2.6499999999999996e-23	NR	KAF0988594.1	69463	g1253	i0	76.9	1.97969543147208	65	15	99	0	2	196	102	166	KAF0988594.1 hypothetical protein HZS_904, partial [Henneguya salminicola]	diamond	390	98.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
19514682	19514682	PRJNA316313_S_NODE_2116_length_163_cov_2.476190_g2113_i0	PRJNA316313	2116	163	2.47619	4.0361897	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	90.1	1.9300000000000003e-21	NR	KAF1743137.1	59785	g2113	i0	84.9	1.95092024539877	53	6	97.5	1	2	160	78	128	KAF1743137.1 hypothetical protein MXB_2311 [Myxobolus squamalis]	diamond	318	90.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
24612500	24612500	PRJNA316313_P_NODE_15740_length_423_cov_4.137306_g14394_i0	PRJNA316313	15740	423	4.137306	17.50080438	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.041	NTclustered	gi\|2917940687\|emb\|OZ237555.1\|	6108	g14394	i0	100	0.066193853427896	28	0	7	0	241	268	16930281	16930308	Anemonia sulcata genome assembly, chromosome: 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
27895749	27895749	PRJNA316313_S_NODE_2465_length_156_cov_0.983193_g2462_i0	PRJNA316313	2465	156	0.983193	1.53378108	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	80.5	2.15e-18	NR	KAF0986755.1	69463	g2462	i0	78.4	0.980769230769231	51	11	98.1	0	154	2	18	68	KAF0986755.1 hypothetical protein HZS_4116, partial [Henneguya salminicola]	diamond	153	80.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
28369390	28369390	PRJNA316313_S_NODE_1526_length_183_cov_1.335616_g1523_i0	PRJNA316313	1526	183	1.335616	2.44417728	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	86.3	7.35e-20	NR	KAF1743742.1	59785	g1523	i0	67.8	2.90163934426229	59	19	96.7	0	181	5	61	119	KAF1743742.1 hypothetical protein MXB_1250 [Myxobolus squamalis]	diamond	531	86.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
28401015	28401015	PRJNA316313_S_NODE_2666_length_152_cov_1.356522_g2663_i0	PRJNA316313	2666	152	1.356522	2.06191344	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	48.9	7.12e-5	NR	KAF0992473.1	69463	g2663	i0	42.9	0.967105263157895	49	26	92.8	1	147	7	372	420	KAF0992473.1 hypothetical protein HZS_141 [Henneguya salminicola]	diamond	147	48.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
29032725	29032725	PRJNA316313_S_NODE_568_length_271_cov_2.824786_g565_i0	PRJNA316313	568	271	2.824786	7.65517006	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	125	1.02e-33	NR	KII61746.1	669202	g565	i0	67.9	0.896678966789668	81	26	89.7	0	270	28	140	220	KII61746.1 Peroxiredoxin-1 [Thelohanellus kitauei]	diamond	243	125	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
29379817	29379817	PRJNA316313_S_NODE_1869_length_170_cov_2.631579_g1866_i0	PRJNA316313	1869	170	2.631579	4.4736843	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	65.5	1.12e-10	NR	KAF0988069.1	69463	g1866	i0	50	0.917647058823529	52	25	91.8	1	170	15	274	324	KAF0988069.1 hypothetical protein HZS_4578 [Henneguya salminicola]	diamond	156	65.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
29491819	29491819	PRJNA316313_S_NODE_2690_length_152_cov_0.991304_g2687_i0	PRJNA316313	2690	152	0.991304	1.50678208	Myxobolidae	35587	Cnidaria	other_Eukaryota	50.1	9.99e-6	NR	KAF1744765.1	59785	g2687	i0	56.4	1.53947368421053	39	17	77	0	2	118	113	151	KAF1744765.1 hypothetical protein MXB_2282 [Myxobolus squamalis]	diamond	234	50.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
29663617	29663617	PRJNA316313_S_NODE_2610_length_153_cov_1.301724_g2607_i0	PRJNA316313	2610	153	1.301724	1.99163772	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	82.8	7.86e-17	NR	KII73571.1	669202	g2607	i0	64	0.980392156862745	50	18	98	0	152	3	120	169	KII73571.1 Coronin-1A [Thelohanellus kitauei]	diamond	150	82.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
30137379	30137379	PRJNA316313_S_NODE_1672_length_177_cov_1.671429_g1669_i0	PRJNA316313	1672	177	1.671429	2.95842933	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	84	2.63e-17	NR	KII61270.1	669202	g1669	i0	60	0.932203389830508	55	22	93.2	0	177	13	303	357	KII61270.1 Cathepsin L [Thelohanellus kitauei]	diamond	165	84	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
30471233	30471233	PRJNA316313_S_NODE_1813_length_172_cov_2.007407_g1810_i0	PRJNA316313	1813	172	2.007407	3.45274004	Metazoa	33208	Cnidaria	other_Eukaryota	56.2	2.35e-7	NR	KAF1743601.1	59785	g1810	i0	51.8	4.91860465116279	56	25	97.7	2	2	169	123	176	KAF1743601.1 hypothetical protein MXB_1537, partial [Myxobolus squamalis]	diamond	846	56.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
30674807	30674807	PRJNA316313_S_NODE_1393_length_189_cov_1.282895_g1390_i0	PRJNA316313	1393	189	1.282895	2.42467155	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	97.8	6.28e-22	NR	KAF0988596.1	69463	g1390	i0	74.2	10.8253968253968	62	16	98.4	0	187	2	127	188	KAF0988596.1 hypothetical protein HZS_5168, partial [Henneguya salminicola]	diamond	2046	97.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
31054342	31054342	PRJNA316313_S_NODE_1295_length_194_cov_1.324841_g1292_i0	PRJNA316313	1295	194	1.324841	2.57019154	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	68.9	1.44e-12	NR	KAF0992763.1	69463	g1292	i0	42.2	1.9639175257732	64	37	99	0	194	3	16	79	KAF0992763.1 hypothetical protein HZS_3886 [Henneguya salminicola]	diamond	381	68.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
31686322	31686322	PRJNA316313_S_NODE_1277_length_195_cov_2.702532_g1274_i0	PRJNA316313	1277	195	2.702532	5.2699374	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	97.4	9.38e-22	NR	KAF0988596.1	69463	g1274	i0	60.9	0.984615384615385	64	25	98.5	0	194	3	4	67	KAF0988596.1 hypothetical protein HZS_5168, partial [Henneguya salminicola]	diamond	192	97.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
31844481	31844481	PRJNA316313_S_NODE_2537_length_154_cov_1.666667_g2534_i0	PRJNA316313	2537	154	1.666667	2.56666718	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	71.6	4.22e-14	NR	KAF1741427.1	59785	g2534	i0	68	0.974025974025974	50	16	97.4	0	152	3	55	104	KAF1741427.1 hypothetical protein MXB_3943 [Myxobolus squamalis]	diamond	150	71.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
32319542	32319542	PRJNA316313_S_NODE_2419_length_156_cov_2.294118_g2416_i0	PRJNA316313	2419	156	2.294118	3.57882408	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	52.8	3.19e-6	NR	KII61043.1	669202	g2416	i0	62.5	1.86538461538462	48	17	92.3	1	13	156	249	295	KII61043.1 Nucleoplasmin-like protein ANO39 [Thelohanellus kitauei]	diamond	291	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei

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