metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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
1594270	1594270	PRJNA1186363_P_NODE_10382_length_641_cov_12.096831_g9503_i0	PRJNA1186363	10382	641	12.096831	77.54068671	Montipora capricornis	246305	Cnidaria	other_Eukaryota	56.5	0.005	NTclustered	gi\|2812158196\|ref\|XM_068891834.1\|	246305	g9503	i0	96.97	0.102964118564743	33	1	5	0	470	502	1981	1949	PREDICTED: Montipora capricornis uncharacterized protein (LOC138045367), transcript variant X1, mRNA	blastn	66	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
1594323	1594323	PRJNA1186363_P_NODE_15902_length_492_cov_1.525060_g15016_i0	PRJNA1186363	15902	492	1.52506	7.5032952	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	73.1	3.69e-8	NTclustered	gi\|2257874017\|ref\|XM_032367683.2\|	45351	g15016	i0	90.909	6.14837398373984	55	3	11	2	78	131	1118	1171	PREDICTED: Nematostella vectensis RNA-binding protein FUS (LOC5522375), transcript variant X1, mRNA	blastn	3025	73.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
1594454	1594454	PRJNA1186363_P_NODE_33762_length_286_cov_1.098592_g32874_i0	PRJNA1186363	33762	286	1.098592	3.14197312	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	156	1.96e-33	NTclustered	gi\|2751518619\|ref\|XM_059090295.2\|	203993	g32874	i0	84.472	1.59090909090909	161	21	56	4	124	282	994	836	PREDICTED: Pocillopora verrucosa calreticulin (LOC131774291), mRNA	blastn	455	156	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
6697521	6697521	PRJNA1186363_P_NODE_13186_length_556_cov_1.093168_g12302_i0	PRJNA1186363	13186	556	1.093168	6.07801408	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	75	1.17e-8	NTclustered	gi\|2751571410\|ref\|XM_059111393.2\|	203993	g12302	i0	80.702	1.28956834532374	114	6	19	14	129	235	515	411	PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC131793887), transcript variant X1, mRNA	blastn	717	75	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
6697534	6697534	PRJNA1186363_P_NODE_14606_length_521_cov_1.218750_g13721_i0	PRJNA1186363	14606	521	1.21875	6.3496875	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	60.2	3.05e-4	NTclustered	gi\|1619596918\|ref\|XM_028661674.1\|	2652724	g13721	i0	97.222	0.644913627639155	36	0	7	1	298	333	3028	2994	PREDICTED: Exaiptasia diaphana UPF0577 protein KIAA1324-like (LOC110231150), mRNA	blastn	336	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
6697621	6697621	PRJNA1186363_P_NODE_25266_length_361_cov_1.083333_g24378_i0	PRJNA1186363	25266	361	1.083333	3.91083213	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	71.3	9.45e-8	NTclustered	gi\|2729070062\|ref\|XM_065197103.1\|	499914	g24378	i0	97.561	5.42105263157895	41	1	11	0	186	226	1169	1209	PREDICTED: Rhopilema esculentum proline-rich protein 36-like (LOC135682283), transcript variant X1, mRNA	blastn	1957	71.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
7419872	7419872	PRJNA1186363_P_NODE_21166_length_408_cov_1.367164_g20278_i0	PRJNA1186363	21166	408	1.367164	5.57802912	Metazoa	33208	Cnidaria	other_Eukaryota	58.4	8.42e-4	NTclustered	gi\|2917940724\|emb\|OZ237563.1\|	6108	g20278	i0	97.059	0.470588235294118	34	1	8	0	244	277	14183291	14183324	Anemonia sulcata genome assembly, chromosome: 9	blastn	192	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
9247669	9247669	PRJNA1186363_P_NODE_29368_length_322_cov_0.939759_g28480_i0	PRJNA1186363	29368	322	0.939759	3.02602398	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	215	3.64e-51	NTclustered	gi\|2202625358\|ref\|XM_046990337.1\|	2897299	g28480	i0	79.012	3.53726708074534	324	60	99	8	1	320	512	831	PREDICTED: Xenia sp. Carnegie-2017 sperm-associated antigen 6 (LOC124440014), mRNA	blastn	1139	215	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
9247670	9247670	PRJNA1186363_P_NODE_29568_length_320_cov_1.263158_g28680_i0	PRJNA1186363	29568	320	1.263158	4.0421056	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	60.2	1.79e-4	NTclustered	gi\|2917940752\|emb\|OZ237570.1\|	6108	g28680	i0	100	9.8875	32	0	10	0	1	32	11998815	11998784	Anemonia sulcata genome assembly, chromosome: 16	blastn	3164	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
9247713	9247713	PRJNA1186363_P_NODE_37428_length_259_cov_1.258065_g36540_i0	PRJNA1186363	37428	259	1.258065	3.25838835	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	52.8	0.024	NTclustered	gi\|2202635358\|ref\|XM_046993395.1\|	2897299	g36540	i0	100	0.108108108108108	28	0	11	0	52	79	265	292	PREDICTED: Xenia sp. Carnegie-2017 ras-like GTP-binding protein RHO (LOC124442878), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
13795377	13795377	PRJNA1186363_P_NODE_38531_length_253_cov_0.866667_g37643_i0	PRJNA1186363	38531	253	0.866667	2.19266751	Opisthokonta	33154	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2917940745\|emb\|OZ237569.1\|	6108	g37643	i0	100	0.343873517786561	28	0	11	0	210	237	4989135	4989162	Anemonia sulcata genome assembly, chromosome: 15	blastn	87	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
14348720	14348720	PRJNA1186363_P_NODE_19832_length_426_cov_1.110482_g18944_i0	PRJNA1186363	19832	426	1.110482	4.73065332	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	220	1.0599999999999999e-52	NTclustered	gi\|2744821218\|ref\|XM_047270565.2\|	6087	g18944	i0	81.749	4.21596244131455	263	48	62	0	152	414	587	325	PREDICTED: Hydra vulgaris uncharacterized LOC101241424 (LOC101241424), transcript variant X2, mRNA	blastn	1796	220	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
16896920	16896920	PRJNA1186363_P_NODE_3674_length_1084_cov_9.212661_g3141_i0	PRJNA1186363	3674	1084	9.212661	99.86524524	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.031	NTclustered	gi\|2917940712\|emb\|OZ237560.1\|	6108	g3141	i0	100	0.0267527675276753	29	0	3	0	723	751	3240172	3240200	Anemonia sulcata genome assembly, chromosome: 6	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
17619796	17619796	PRJNA1186363_P_NODE_36054_length_269_cov_1.193878_g35166_i0	PRJNA1186363	36054	269	1.193878	3.21153182	Metazoa	33208	Cnidaria	other_Eukaryota	180	1.08e-40	NTclustered	gi\|323472247\|gb\|HQ203635.1\|	102205	g35166	i0	80.165	48.3382899628253	242	46	90	2	2	242	241	1	Platygyra sinensis isolate P130 histone H3 gene, partial cds	blastn	13003	180	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Platygyra	Platygyra sinensis
18171386	18171386	PRJNA1186363_P_NODE_3595_length_1094_cov_9.932419_g3069_i0	PRJNA1186363	3595	1094	9.932419	108.66066386	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	56.5	0.009	NTclustered	gi\|2918369535\|emb\|OZ237717.1\|	317547	g3069	i0	100	0.0274223034734918	30	0	3	0	592	621	11261788	11261759	Eunicella cavolini genome assembly, chromosome: 1	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
19445632	19445632	PRJNA1186363_P_NODE_11416_length_607_cov_1.576779_g10534_i0	PRJNA1186363	11416	607	1.576779	9.57104853	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	54.7	0.017	NTclustered	gi\|1270074214\|ref\|XM_022944380.1\|	50429	g10534	i0	100	0.0955518945634267	29	0	5	0	431	459	2126	2154	PREDICTED: Stylophora pistillata uncharacterized LOC111337977 (LOC111337977), transcript variant X2, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
19445851	19445851	PRJNA1186363_P_NODE_4296_length_1012_cov_2.685836_g3702_i0	PRJNA1186363	4296	1012	2.685836	27.18066032	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	353	2.51e-92	NTclustered	gi\|1603801533\|ref\|XM_028548900.1\|	151771	g3702	i0	75.594	10.1215415019763	758	162	74	19	32	776	457	1204	PREDICTED: Dendronephthya gigantea calreticulin-like (LOC114527247), mRNA	blastn	10243	353	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
20721175	20721175	PRJNA1186363_P_NODE_38737_length_252_cov_1.307263_g37849_i0	PRJNA1186363	38737	252	1.307263	3.29430276	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	220	5.919999999999999e-53	NTclustered	gi\|2782873195\|ref\|XM_067061561.1\|	252671	g37849	i0	82.677	13.7301587301587	254	38	99	5	1	251	320	70	PREDICTED: Clytia hemisphaerica tubulin alpha-1 chain-like (LOC136805029), mRNA	blastn	3460	220	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
23271896	23271896	PRJNA1186363_P_NODE_24099_length_373_cov_1.560000_g23211_i0	PRJNA1186363	24099	373	1.56	5.8188	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	294	5.34e-75	NTclustered	gi\|2519004569\|ref\|XM_057453964.1\|	13093	g23211	i0	83.23	43.656836461126	322	52	86	2	1	321	1520	1200	PREDICTED: Hydractinia symbiolongicarpus DNA replication licensing factor MCM3-like (LOC130647955), mRNA	blastn	16284	294	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
23271926	23271926	PRJNA1186363_P_NODE_27139_length_342_cov_1.836431_g26251_i0	PRJNA1186363	27139	342	1.836431	6.28059402	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	63.9	1.49e-5	NTclustered	gi\|2518975834\|ref\|XM_057438742.1\|	13093	g26251	i0	88.462	0.339181286549708	52	6	15	0	180	231	3889	3838	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130623271 (LOC130623271), mRNA	blastn	116	63.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus

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