metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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
1004863	1004863	PRJNA1028258_P_NODE_163821_length_228_cov_0.893082_g163258_i0	PRJNA1028258	163821	228	0.893082	2.03622696	Pocillopora	46730	Cnidaria	other_Eukaryota	110	1.19e-19	NTclustered	gi\|1524895582\|ref\|XM_027200099.1\|	46731	g163258	i0	86.735	13.5482456140351	98	13	43	0	6	103	642	545	PREDICTED: Pocillopora damicornis histone H2B-like (LOC113682914), mRNA	blastn	3089	110	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
2714657	2714657	PRJNA1028258_P_NODE_175963_length_225_cov_0.910256_g175400_i0	PRJNA1028258	175963	225	0.910256	2.048076	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	161	3.1899999999999996e-35	NTclustered	gi\|2782936388\|ref\|XM_067075037.1\|	252671	g175400	i0	81.91	40.1911111111111	199	28	87	7	31	225	1106	1300	PREDICTED: Clytia hemisphaerica heat shock cognate 71 kDa protein-like (LOC136818800), mRNA	blastn	9043	161	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
6109110	6109110	PRJNA1028258_P_NODE_58945_length_332_cov_1.079848_g58382_i0	PRJNA1028258	58945	332	1.079848	3.58509536	Opisthokonta	33154	Cnidaria	other_Eukaryota	261	4.77e-65	NTclustered	gi\|1389623\|dbj\|D49926.1\|EGYEF1AE	48404	g58382	i0	84.444	87.1536144578313	270	36	80	6	54	320	267	1	Eugymnanthea japonica mRNA for elongation factor-1 alpha, partial cds	blastn	28935	261	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Eirenidae	Eugymnanthea	Eugymnanthea japonica
7382592	7382592	PRJNA1028258_P_NODE_166466_length_227_cov_0.898734_g165903_i0	PRJNA1028258	166466	227	0.898734	2.04012618	Metazoa	33208	Cnidaria	other_Eukaryota	95.3	3.31e-15	NTclustered	gi\|2744834657\|ref\|XM_002163363.5\|	6087	g165903	i0	87.654	1.03964757709251	81	10	36	0	1	81	300	380	PREDICTED: Hydra vulgaris ubiquitin-like FUBI-ribosomal protein eS30 fusion protein (LOC100211988), mRNA	blastn	236	95.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
7817048	7817048	PRJNA1028258_P_NODE_25127_length_507_cov_5.207763_g24568_i0	PRJNA1028258	25127	507	5.207763	26.40335841	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	270	1.26e-67	NTclustered	gi\|1270064191\|ref\|XM_022938999.1\|	50429	g24568	i0	79.733	24.370808678501	375	74	74	2	1	374	492	119	PREDICTED: Stylophora pistillata 40S ribosomal protein S14 (LOC111333429), mRNA	blastn	12356	270	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
7817164	7817164	PRJNA1028258_P_NODE_30527_length_460_cov_0.859335_g29966_i0	PRJNA1028258	30527	460	0.859335	3.952941	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	244	6.86e-60	NTclustered	gi\|2518998737\|ref\|XM_057450856.1\|	13093	g29966	i0	84.337	120.721739130435	249	39	54	0	1	249	284	532	PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA	blastn	55532	244	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
7817204	7817204	PRJNA1028258_P_NODE_32127_length_448_cov_1.076517_g31565_i0	PRJNA1028258	32127	448	1.076517	4.82279616	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	215	5.23e-51	NTclustered	gi\|2782956407\|ref\|XM_067080111.1\|	252671	g31565	i0	79.43	78.5580357142857	316	55	70	10	54	365	156	465	PREDICTED: Clytia hemisphaerica ubiquitin-ribosomal protein eS31 fusion protein (LOC136823954), mRNA	blastn	35194	215	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
9092247	9092247	PRJNA1028258_P_NODE_34588_length_431_cov_1.312155_g34025_i0	PRJNA1028258	34588	431	1.312155	5.65538805	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	272	2.9299999999999993e-68	NTclustered	gi\|2202636460\|ref\|XM_046993750.1\|	2897299	g34025	i0	79.787	11.6125290023202	376	74	87	2	4	378	801	1175	PREDICTED: Xenia sp. Carnegie-2017 26S proteasome regulatory subunit 4 (LOC124443214), mRNA	blastn	5005	272	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
10368947	10368947	PRJNA1028258_P_NODE_86709_length_277_cov_1.298077_g86146_i0	PRJNA1028258	86709	277	1.298077	3.59567329	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2782863103\|ref\|XM_067059373.1\|	252671	g86146	i0	100	0.555956678700361	30	0	11	0	127	156	1090	1061	PREDICTED: Clytia hemisphaerica malate dehydrogenase, cytoplasmic-like (LOC136802621), mRNA	blastn	154	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
12917345	12917345	PRJNA1028258_P_NODE_140991_length_233_cov_0.865854_g140428_i0	PRJNA1028258	140991	233	0.865854	2.01743982	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	163	9.23e-36	NTclustered	gi\|1603789293\|ref\|XM_028542321.1\|	151771	g140428	i0	86.897	27.4635193133047	145	19	62	0	2	146	284	428	PREDICTED: Dendronephthya gigantea ras-related protein rab7 (LOC114521780), mRNA	blastn	6399	163	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
16742089	16742089	PRJNA1028258_P_NODE_58054_length_334_cov_1.607547_g57491_i0	PRJNA1028258	58054	334	1.607547	5.36920698	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	58.4	6.77e-4	NTclustered	gi\|2918369558\|emb\|OZ237728.1\|	317547	g57491	i0	100	0.092814371257485	31	0	9	0	120	150	7682398	7682428	Eunicella cavolini genome assembly, chromosome: 12	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
17584270	17584270	PRJNA1028258_P_NODE_90334_length_271_cov_1.405941_g89771_i0	PRJNA1028258	90334	271	1.405941	3.81010011	Metazoa	33208	Cnidaria	other_Eukaryota	60.2	1.49e-4	NTclustered	gi\|2917940756\|emb\|OZ237571.1\|	6108	g89771	i0	97.143	6.34686346863469	35	1	13	0	25	59	12005693	12005727	Anemonia sulcata genome assembly, chromosome: 17	blastn	1720	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
18015977	18015977	PRJNA1028258_P_NODE_173455_length_226_cov_0.904459_g172892_i0	PRJNA1028258	173455	226	0.904459	2.04407734	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	134	6.980000000000001e-27	NTclustered	gi\|2663986575\|emb\|OY756916.1\|	69463	g172892	i0	95.238	31.4115044247788	84	4	37	0	1	84	6563	6646	Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences	blastn	7099	134	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
20132857	20132857	PRJNA1028258_P_NODE_93596_length_267_cov_1.792929_g93033_i0	PRJNA1028258	93596	267	1.792929	4.78712043	Opisthokonta	33154	Cnidaria	other_Eukaryota	224	4.8899999999999987e-54	NTclustered	gi\|62825449\|gb\|AY789861.1\|	32570	g93033	i0	84.513	27.5805243445693	226	35	85	0	1	226	169	394	Obelia longissima voucher 235NZ calmodulin gene, partial cds	blastn	7364	226	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Obeliidae	Obelia	Obelia longissima
21406897	21406897	PRJNA1028258_P_NODE_164197_length_228_cov_0.893082_g163634_i0	PRJNA1028258	164197	228	0.893082	2.03622696	Staurotheca	655731	Cnidaria	other_Eukaryota	163	8.999999999999999e-36	NTclustered	gi\|1027506870\|gb\|KT824463.1\|	655735	g163634	i0	81.407	8.76315789473684	199	37	87	0	3	201	199	1	Staurotheca pachyclada calmodulin (CaM) gene, partial cds	blastn	1998	163	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Staurotheca	Staurotheca pachyclada
21842811	21842811	PRJNA1028258_P_NODE_98578_length_262_cov_1.502591_g98015_i0	PRJNA1028258	98578	262	1.502591	3.93678842	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	174	4.8899999999999997e-39	NTclustered	gi\|1524889088\|ref\|XM_027196664.1\|	46731	g98015	i0	83.978	64.0076335877863	181	29	69	0	82	262	186	366	PREDICTED: Pocillopora damicornis peptidyl-prolyl cis-trans isomerase-like (LOC113679698), mRNA	blastn	16770	174	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
23115746	23115746	PRJNA1028258_P_NODE_132619_length_235_cov_0.855422_g132056_i0	PRJNA1028258	132619	235	0.855422	2.0102417	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	217	7.06e-52	NTclustered	gi\|2782957080\|ref\|XM_067080290.1\|	252671	g132056	i0	84.475	25.4170212765957	219	34	93	0	1	219	5276	5494	PREDICTED: Clytia hemisphaerica serine/threonine-protein phosphatase PP1-beta catalytic subunit (LOC136824125), transcript variant X2, mRNA	blastn	5973	217	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica

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