metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
2179046	2179046	PRJNA928559_P_NODE_225702_length_213_cov_49.635714_g224133_i0	PRJNA928559	225702	213	49.635714	105.72407082	Umbellula sp. 2 RH-2019	2598118	Cnidaria	other_Eukaryota	106	1.42e-18	NTclustered	gi\|2160785911\|gb\|OL741705.1\|	2598118	g224133	i0	80.986	33.981220657277	142	19	66	7	9	148	4540	4675	Umbellula sp. NMS.Z.2019.25.13 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	7238	106	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleralcyonacea	Umbellulidae	Umbellula	Umbellula sp. 2 RH-2019
2179198	2179198	PRJNA928559_P_NODE_30582_length_591_cov_34.675676_g29055_i0	PRJNA928559	30582	591	34.675676	204.93324516	Myxidium gadi	371546	Cnidaria	other_Eukaryota	150	2.01e-31	NTclustered	gi\|241911756\|gb\|FJ417062.1\|	371546	g29055	i0	88.281	21.3011844331641	128	11	21	4	457	583	2161	2037	Myxidium gadi isolate M0307 28S large subunit ribosomal RNA gene, partial sequence	blastn	12589	150	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium gadi
3452897	3452897	PRJNA928559_P_NODE_108783_length_342_cov_1.457249_g107214_i0	PRJNA928559	108783	342	1.457249	4.98379158	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	148	4.01e-31	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g107214	i0	88	0.365497076023392	125	15	37	0	1	125	549	673	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	125	148	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
6005137	6005137	PRJNA928559_P_NODE_10445_length_950_cov_4.393387_g9233_i0	PRJNA928559	10445	950	4.393387	41.7371765	Pennaria disticha	264068	Cnidaria	other_Eukaryota	119	9.34e-22	NTclustered	gi\|166407165\|gb\|EU272581.1\|	264068	g9233	i0	88.66	2.36947368421053	97	11	10	0	73	169	1417	1513	Pennaria disticha voucher AGC68 28S large subunit ribosomal RNA gene, partial sequence	blastn	2251	119	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Pennariidae	Pennaria	Pennaria disticha
6005589	6005589	PRJNA928559_P_NODE_135785_length_304_cov_1.800866_g134216_i0	PRJNA928559	135785	304	1.800866	5.47463264	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	433	8.66e-117	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g134216	i0	94.326	2.78289473684211	282	16	93	0	1	282	396	677	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	846	433	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
8906075	8906075	PRJNA928559_P_NODE_9727_length_980_cov_91.207277_g8561_i0	PRJNA928559	9727	980	91.207277	893.8313146	Ectopleura	264051	Cnidaria	other_Eukaryota	189	7.249999999999999e-43	NTclustered	gi\|1032656006\|gb\|JN594044.2\|	264053	g8561	i0	86.628	42.6295918367347	172	21	18	2	809	980	2272	2441	Ectopleura wrighti voucher MHNGINVE27331 28S ribosomal RNA gene, partial sequence	blastn	41777	189	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Tubulariidae	Ectopleura	Ectopleura wrighti
9831310	9831310	PRJNA928559_P_NODE_213928_length_242_cov_1.650888_g212359_i0	PRJNA928559	213928	242	1.650888	3.99514896	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	134	7.57e-27	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g212359	i0	84.848	0.545454545454545	132	20	55	0	111	242	672	541	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	132	134	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
9831601	9831601	PRJNA928559_P_NODE_26908_length_624_cov_15.774955_g25394_i0	PRJNA928559	26908	624	15.774955	98.4357192	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	91.6	1.31e-13	NTclustered	gi\|2918369537\|emb\|OZ237719.1\|	317547	g25394	i0	78.472	1.21955128205128	144	28	23	3	288	428	27237146	27237003	Eunicella cavolini genome assembly, chromosome: 3	blastn	761	91.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
9832395	9832395	PRJNA928559_P_NODE_8908_length_1020_cov_17.725449_g7791_i0	PRJNA928559	8908	1020	17.725449	180.7995798	Halecium muricatum	308658	Cnidaria	other_Eukaryota	115	1.3e-20	NTclustered	gi\|256674504\|gb\|FJ550408.1\|	308658	g7791	i0	78.283	3.47843137254902	198	29	19	10	1	193	1323	1511	Halecium muricatum voucher MHNG INVE29028 28S ribosomal RNA gene, partial sequence	blastn	3548	115	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Haleciidae	Halecium	Halecium muricatum
11107470	11107470	PRJNA928559_P_NODE_33329_length_570_cov_10.241449_g31792_i0	PRJNA928559	33329	570	10.241449	58.3762593	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	126	3.27e-24	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g31792	i0	98.592	0.243859649122807	71	1	12	0	1	71	85	15	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	139	126	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
13656385	13656385	PRJNA928559_P_NODE_155731_length_282_cov_1.181818_g154162_i0	PRJNA928559	155731	282	1.181818	3.33272676	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	255	1.85e-63	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g154162	i0	86.325	1.6595744680851101	234	32	83	0	49	282	293	60	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	468	255	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
13656742	13656742	PRJNA928559_P_NODE_181411_length_258_cov_1.286486_g179842_i0	PRJNA928559	181411	258	1.286486	3.31913388	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	97.1	1.07e-15	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g179842	i0	81.148	0.472868217054264	122	21	47	1	139	258	666	545	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	122	97.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
13656787	13656787	PRJNA928559_P_NODE_184091_length_255_cov_4.280220_g182522_i0	PRJNA928559	184091	255	4.28022	10.914561	Ceratomyxa leatherjacketi	1579382	Cnidaria	other_Eukaryota	62.1	3.85e-5	NTclustered	gi\|730837044\|gb\|KM392428.1\|	1579382	g182522	i0	100	0.254901960784314	33	0	13	0	223	255	380	412	Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence	blastn	65	62.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Ceratomyxidae	Ceratomyxa	Ceratomyxa leatherjacketi
14930195	14930195	PRJNA928559_P_NODE_128072_length_314_cov_1.414938_g126503_i0	PRJNA928559	128072	314	1.414938	4.44290532	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	279	1.24e-70	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g126503	i0	88.938	0.719745222929936	226	25	72	0	1	226	442	667	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	226	279	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
14931120	14931120	PRJNA928559_P_NODE_189952_length_252_cov_1.296089_g188383_i0	PRJNA928559	189952	252	1.296089	3.26614428	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	219	2.13e-52	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g188383	i0	94.366	1.13095238095238	142	8	56	0	102	243	676	535	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	285	219	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
16205951	16205951	PRJNA928559_P_NODE_174993_length_263_cov_2.505263_g173424_i0	PRJNA928559	174993	263	2.505263	6.58884169	Myxobolus cloutmani	2766936	Cnidaria	other_Eukaryota	307	4.6400000000000006e-79	NTclustered	gi\|1896054819\|gb\|MT919695.1\|	2766936	g173424	i0	88.76	97.3079847908745	258	20	98	6	6	263	839	1087	Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence	blastn	25592	307	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus cloutmani
18754479	18754479	PRJNA928559_P_NODE_17335_length_754_cov_73.585903_g15916_i0	PRJNA928559	17335	754	73.585903	554.83770862	Cephea cephea	880218	Cnidaria	other_Eukaryota	117	2.64e-21	NTclustered	gi\|2862235116\|gb\|PQ647263.1\|	880218	g15916	i0	91.765	10.7347480106101	85	5	11	2	21	104	2	85	Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	8094	117	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Cepheidae	Cephea	Cephea cephea
20379432	20379432	PRJNA928559_P_NODE_39096_length_534_cov_4.607375_g37541_i0	PRJNA928559	39096	534	4.607375	24.6033825	Leptothecata	500008	Cnidaria	other_Eukaryota	200	1.77e-46	NTclustered	gi\|66864859\|gb\|AY920799.1\|	6100	g37541	i0	84.804	79.2209737827715	204	25	87	6	1	202	2478	2677	Aequorea victoria large subunit 28S ribosomal RNA gene, partial sequence	blastn	42304	200	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Aequoreidae	Aequorea	Aequorea victoria
21306564	21306564	PRJNA928559_P_NODE_82497_length_391_cov_1.371069_g80928_i0	PRJNA928559	82497	391	1.371069	5.36087979	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	388	2.51e-103	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g80928	i0	85.185	1.93350383631714	378	56	97	0	2	379	229	606	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	756	388	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
23855853	23855853	PRJNA928559_P_NODE_217059_length_239_cov_2.710843_g215490_i0	PRJNA928559	217059	239	2.710843	6.47891477	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	145	3.4499999999999996e-30	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g215490	i0	87.805	0.514644351464435	123	15	51	0	117	239	666	544	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	123	145	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi
25128790	25128790	PRJNA928559_P_NODE_15780_length_787_cov_3.731092_g14405_i0	PRJNA928559	15780	787	3.731092	29.36369404	Antarctoscyphus spiralis	655730	Cnidaria	other_Eukaryota	161	1.2599999999999999e-34	NTclustered	gi\|984932199\|gb\|KT757141.1\|	655730	g14405	i0	87.681	16.2033036848793	138	17	18	0	552	689	1652	1515	Antarctoscyphus spiralis voucher LEM m3x S155 large subunit 28S ribosomal RNA gene, partial sequence	blastn	12752	161	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Antarctoscyphus	Antarctoscyphus spiralis
25130299	25130299	PRJNA928559_P_NODE_54420_length_467_cov_78.936548_g52854_i0	PRJNA928559	54420	467	78.936548	368.63367916	Sphaeromyxa zaharoni	275449	Cnidaria	other_Eukaryota	60.2	2.71e-4	NTclustered	gi\|2663986569\|emb\|OY751524.1\|	275449	g52854	i0	100	1.42612419700214	32	0	7	0	146	177	6334	6365	Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences	blastn	666	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Sphaeromyxidae	Sphaeromyxa	Sphaeromyxa zaharoni
25130860	25130860	PRJNA928559_P_NODE_98780_length_359_cov_1.506993_g97211_i0	PRJNA928559	98780	359	1.506993	5.41010487	Trachyphyllia geoffroyi	196280	Cnidaria	other_Eukaryota	326	1.81e-84	NTclustered	gi\|23503507\|dbj\|AB085641.1\|	196280	g97211	i0	93.213	0.615598885793872	221	15	62	0	1	221	453	673	Trachyphyllia geoffroyi mRNA for Kaede, complete cds	blastn	221	326	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Trachyphyllia	Trachyphyllia geoffroyi

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