metadata: contig_metadata: 25 rows where bioproject = "PRJNA690592" and tax

25 rows where bioproject = "PRJNA690592" and tax_phylum = "Bryozoa"

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
671570	671570	PRJNA690592_S_NODE_218361_length_233_cov_3.025000_g217347_i0	PRJNA690592	218361	233	3.025	7.04825	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	52.8	0.021	NTclustered	gi\|2795726367\|ref\|XM_068086914.1\|	2589382	g217347	i0	100	0.240343347639485	28	0	12	0	77	104	274	247	PREDICTED: Watersipora subatra uncharacterized protein (LOC137400583), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
7050060	7050060	PRJNA690592_S_NODE_198486_length_247_cov_0.885057_g197472_i0	PRJNA690592	198486	247	0.885057	2.18609079	Bugula neritina	10212	Bryozoa	other_Eukaryota	105	3.0400000000000004e-27	NR	KAF6027139.1	10212	g197472	i0	77.3	10.4089068825911	66	15	80.2	0	245	48	39	104	KAF6027139.1 RPS13 [Bugula neritina]	diamond	2571	105	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
8324129	8324129	PRJNA690592_S_NODE_148027_length_278_cov_2.629268_g147013_i0	PRJNA690592	148027	278	2.629268	7.30936504	Membranipora membranacea	95170	Bryozoa	other_Eukaryota	285	2.32e-72	NTclustered	gi\|2320635325\|gb\|ON868447.1\|	95170	g147013	i0	85.609	33.4604316546763	271	39	97	0	7	277	19	289	Membranipora membranacea calmodulin-like protein 1 mRNA, complete cds	blastn	9302	285	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Membraniporidae	Membranipora	Membranipora membranacea
17249783	17249783	PRJNA690592_S_NODE_66074_length_389_cov_3.696203_g65060_i0	PRJNA690592	66074	389	3.696203	14.37822967	Membranipora membranacea	95170	Bryozoa	other_Eukaryota	187	9.77e-43	NTclustered	gi\|2320635325\|gb\|ON868447.1\|	95170	g65060	i0	86.127	43.0411311053985	173	24	44	0	217	389	18	190	Membranipora membranacea calmodulin-like protein 1 mRNA, complete cds	blastn	16743	187	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Membraniporidae	Membranipora	Membranipora membranacea
21074098	21074098	PRJNA690592_S_NODE_27957_length_570_cov_2.476861_g26959_i0	PRJNA690592	27957	570	2.476861	14.1181077	Bugula neritina	10212	Bryozoa	other_Eukaryota	227	3.19e-67	NR	KAF6032315.1	10212	g26959	i0	60	6.74736842105263	195	72	99.5	2	3	569	470	664	KAF6032315.1 hypothetical protein EB796_009336 [Bugula neritina]	diamond	3846	227	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
24897481	24897481	PRJNA690592_S_NODE_180860_length_254_cov_1.602210_g179846_i0	PRJNA690592	180860	254	1.60221	4.0696134	Bryozoa	10205	Bryozoa	other_Eukaryota	70.9	5.45e-12	NR	KAF6030495.1	10212	g179846	i0	55.4	21.4251968503937	74	32	86.2	1	1	219	1445	1518	KAF6030495.1 hypothetical protein EB796_011204 [Bugula neritina]	diamond	5442	70.9	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
24897915	24897915	PRJNA690592_S_NODE_32160_length_535_cov_2.642857_g31153_i0	PRJNA690592	32160	535	2.642857	14.13928495	Membranipora membranacea	95170	Bryozoa	other_Eukaryota	399	1.6299999999999996e-106	NTclustered	gi\|2320635325\|gb\|ON868447.1\|	95170	g31153	i0	86.501	67.059813084112207	363	49	68	0	173	535	18	380	Membranipora membranacea calmodulin-like protein 1 mRNA, complete cds	blastn	35877	399	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Membraniporidae	Membranipora	Membranipora membranacea
27240392	27240392	PRJNA690592_S_NODE_152683_length_275_cov_1.143564_g151669_i0	PRJNA690592	152683	275	1.143564	3.144801	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	80.1	2.21e-16	NR	XP_067935521.1	2589382	g151669	i0	55.6	2.25818181818182	63	28	68.7	0	190	2	23	85	XP_067935521.1 mesencephalic astrocyte-derived neurotrophic factor homolog [Watersipora subatra]	diamond	621	80.1	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
27851839	27851839	PRJNA690592_S_NODE_15344_length_753_cov_2.025000_g14450_i0	PRJNA690592	15344	753	2.025	15.24825	Metazoa	33208	Bryozoa	other_Eukaryota	299	1.61e-92	NR	KAF6041169.1	10212	g14450	i0	62.9	13.1434262948207	245	90	97.2	1	734	3	343	587	KAF6041169.1 MVP [Bugula neritina]	diamond	9897	301	0.993355481727575	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
28250935	28250935	PRJNA690592_S_NODE_43306_length_468_cov_1.478481_g42292_i0	PRJNA690592	43306	468	1.478481	6.91929108	Bugula neritina	10212	Bryozoa	other_Eukaryota	105	2.0799999999999994e-23	NR	KAF6022947.1	10212	g42292	i0	62.3	0.493589743589744	77	27	48.1	1	335	111	319	395	KAF6022947.1 hypothetical protein EB796_018744 [Bugula neritina]	diamond	231	105	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
28325478	28325478	PRJNA690592_S_NODE_8166_length_989_cov_4.806769_g7486_i0	PRJNA690592	8166	989	4.806769	47.53894541	Opisthokonta	33154	Bryozoa	other_Eukaryota	189	7.23e-50	NR	KAF6025727.1	10212	g7486	i0	36	31.010111223458	308	186	90.1	3	1	891	515	822	KAF6025727.1 EIF3C [Bugula neritina]	diamond	30669	189	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
28850761	28850761	PRJNA690592_S_NODE_3868_length_1319_cov_8.910112_g3448_i0	PRJNA690592	3868	1319	8.910112	117.52437728	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	110	5.87e-24	NR	XP_067945532.1	2589382	g3448	i0	31.5	2.29037149355572	248	136	56.4	2	18	761	15	228	XP_067945532.1 sperm flagellar protein 1-like [Watersipora subatra]	diamond	3021	110	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
28945891	28945891	PRJNA690592_S_NODE_162988_length_267_cov_1.185567_g161974_i0	PRJNA690592	162988	267	1.185567	3.16546389	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	56.2	8.75e-7	NR	XP_067940520.1	2589382	g161974	i0	34.5	0.97752808988764	87	54	97.8	2	264	4	280	363	XP_067940520.1 multiple epidermal growth factor-like domains protein 8 [Watersipora subatra]	diamond	261	56.2	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
29872782	29872782	PRJNA690592_S_NODE_20411_length_662_cov_1.820034_g19448_i0	PRJNA690592	20411	662	1.820034	12.04862508	Metazoa	33208	Bryozoa	other_Eukaryota	145	1.34e-38	NR	KAF6019981.1	10212	g19448	i0	39.9	1.77190332326284	198	113	87.9	4	71	652	48	243	KAF6019981.1 hypothetical protein EB796_021723 [Bugula neritina]	diamond	1173	146	0.993150684931507	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
30283892	30283892	PRJNA690592_S_NODE_82132_length_355_cov_1.528369_g81118_i0	PRJNA690592	82132	355	1.528369	5.42570995	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	123	8.989999999999998e-30	NR	KAF6030914.1	10212	g81118	i0	67.5	4.05633802816901	80	26	67.6	0	240	1	703	782	KAF6030914.1 SNRNP200 [Bugula neritina]	diamond	1440	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
30378640	30378640	PRJNA690592_S_NODE_70332_length_379_cov_1.852941_g69318_i0	PRJNA690592	70332	379	1.852941	7.02264639	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.3	2.1e-17	NR	KAF6041049.1	10212	g69318	i0	39.1	5.41424802110818	110	58	87.1	3	346	17	80	180	KAF6041049.1 ALOX5 [Bugula neritina]	diamond	2052	86.3	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
30524753	30524753	PRJNA690592_S_NODE_155873_length_272_cov_1.633166_g154859_i0	PRJNA690592	155873	272	1.633166	4.44221152	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	116	6.47e-29	NR	XP_067937875.1	2589382	g154859	i0	50.6	0.981617647058823	89	44	98.2	0	270	4	76	164	XP_067937875.1 U5 small nuclear ribonucleoprotein 40 kDa protein-like [Watersipora subatra]	diamond	267	116	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
30947164	30947164	PRJNA690592_S_NODE_77974_length_363_cov_1.327586_g76960_i0	PRJNA690592	77974	363	1.327586	4.81913718	Metazoa	33208	Bryozoa	other_Eukaryota	55.5	4.16e-6	NR	KAF6019861.1	10212	g76960	i0	34.1	1.86776859504132	91	55	71.1	2	314	57	165	255	KAF6019861.1 SH2D4A [Bugula neritina]	diamond	678	55.5	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
31378198	31378198	PRJNA690592_S_NODE_219196_length_230_cov_2.942675_g218182_i0	PRJNA690592	219196	230	2.942675	6.7681525	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	67	3.59e-11	NR	XP_067928618.1	2589382	g218182	i0	65.2	1.2	46	16	60	0	8	145	50	95	XP_067928618.1 large ribosomal subunit protein uL30-like [Watersipora subatra]	diamond	276	67	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra
31768996	31768996	PRJNA690592_S_NODE_94217_length_335_cov_2.393130_g93203_i0	PRJNA690592	94217	335	2.39313	8.0169855	Opisthokonta	33154	Bryozoa	other_Eukaryota	74.3	3.95e-13	NR	KAF6031192.1	10212	g93203	i0	46.6	3.25074626865672	73	39	65.4	0	335	117	112	184	KAF6031192.1 RTFDC1 [Bugula neritina]	diamond	1089	74.7	0.994645247657296	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
31979026	31979026	PRJNA690592_S_NODE_38078_length_495_cov_4.710900_g37067_i0	PRJNA690592	38078	495	4.7109	23.318955	Membranipora membranacea	95170	Bryozoa	other_Eukaryota	82	1.51e-16	NR	UYM80477.1	95170	g37067	i0	45.9	0.806060606060606	133	70	80.6	1	51	449	2	132	UYM80477.1 calmodulin-like protein 1 [Membranipora membranacea]	diamond	399	82	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Membraniporidae	Membranipora	Membranipora membranacea
32485550	32485550	PRJNA690592_S_NODE_40459_length_482_cov_1.694377_g39445_i0	PRJNA690592	40459	482	1.694377	8.16689714	Bugula neritina	10212	Bryozoa	other_Eukaryota	210	9.070000000000001e-66	NR	KAF6038783.1	10212	g39445	i0	67.3	5.93775933609959	159	52	99	0	482	6	60	218	KAF6038783.1 CTH [Bugula neritina]	diamond	2862	210	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
32485564	32485564	PRJNA690592_S_NODE_60879_length_404_cov_0.993958_g59865_i0	PRJNA690592	60879	404	0.993958	4.01559032	Bugula neritina	10212	Bryozoa	other_Eukaryota	56.6	2.71e-6	NR	KAF6017927.1	10212	g59865	i0	36.6	0.608910891089109	82	50	60.9	1	34	279	43	122	KAF6017927.1 P2RX1 [Bugula neritina]	diamond	246	56.6	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
32674475	32674475	PRJNA690592_S_NODE_215260_length_241_cov_0.916667_g214246_i0	PRJNA690592	215260	241	0.916667	2.20916747	Bugula neritina	10212	Bryozoa	other_Eukaryota	81.3	5.68e-16	NR	KAF6017705.1	10212	g214246	i0	47.4	1.91701244813278	76	39	94.6	1	234	7	201	275	KAF6017705.1 NT5C3A [Bugula neritina]	diamond	462	81.3	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina
32832012	32832012	PRJNA690592_S_NODE_110540_length_315_cov_0.954545_g109526_i0	PRJNA690592	110540	315	0.954545	3.00681675	Bugula neritina	10212	Bryozoa	other_Eukaryota	92.8	9.61e-21	NR	KAF6017551.1	10212	g109526	i0	46.2	3.02857142857143	106	56	100	1	315	1	71	176	KAF6017551.1 Vps24 [Bugula neritina]	diamond	954	92.8	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Bugulidae	Bugula	Bugula neritina

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