metadata: contig_metadata: 14 rows where bioproject = "PRJNA1073183", tax_kingdom = "Metazoa" and tax

14 rows where bioproject = "PRJNA1073183", tax_kingdom = "Metazoa" 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
1461606	1461606	PRJNA1073183_P_NODE_12102_length_371_cov_2.577181_g12007_i0	PRJNA1073183	12102	371	2.577181	9.56134151	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	392	1.83e-104	NTclustered	gi\|2782844603\|ref\|XM_067056021.1\|	252671	g12007	i0	88.959	82.1266846361186	317	35	85	0	1	317	1103	1419	PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA	blastn	30469	392	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
5289877	5289877	PRJNA1073183_P_NODE_15285_length_333_cov_2.811538_g15190_i0	PRJNA1073183	15285	333	2.811538	9.36242154	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	279	1.32e-70	NTclustered	gi\|2782873191\|ref\|XM_067061560.1\|	252671	g15190	i0	89.545	63.954954954955	220	23	66	0	112	331	1465	1246	PREDICTED: Clytia hemisphaerica tubulin alpha-2/alpha-4 chain (LOC136805028), mRNA	blastn	21297	279	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
7393880	7393880	PRJNA1073183_P_NODE_9226_length_421_cov_2.925287_g9132_i0	PRJNA1073183	9226	421	2.925287	12.31545827	Opisthokonta	33154	Cnidaria	other_Eukaryota	166	4.74e-50	NR	XP_068702776.1	591990	g9132	i0	65.7	16.1472684085511	134	45	95.5	1	7	408	1	133	XP_068702776.1 large ribosomal subunit protein eL32-like [Montipora foliosa]	diamond	6798	167	0.994011976047904	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
7839960	7839960	PRJNA1073183_P_NODE_30627_length_246_cov_0.890173_g30532_i0	PRJNA1073183	30627	246	0.890173	2.18982558	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2729067808\|ref\|XM_065195882.1\|	499914	g30532	i0	100	0.609756097560976	30	0	12	0	105	134	314	343	PREDICTED: Rhopilema esculentum alpha-2Db adrenergic receptor-like (LOC135681415), transcript variant X5, mRNA	blastn	150	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
14215926	14215926	PRJNA1073183_P_NODE_25372_length_257_cov_1.673913_g25277_i0	PRJNA1073183	25372	257	1.673913	4.30195641	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	149	3.43e-40	NR	XP_022793021.1	50429	g25277	i0	81	21.431906614786	84	16	98.1	0	253	2	184	267	XP_022793021.1 H/ACA ribonucleoprotein complex subunit 4-like [Stylophora pistillata]	diamond	5508	149	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
23139553	23139553	PRJNA1073183_P_NODE_25339_length_257_cov_2.092391_g25244_i0	PRJNA1073183	25339	257	2.092391	5.37744487	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	149	9.04e-43	NR	EDO25965.1	45351	g25244	i0	91.5	0.957198443579767	82	7	95.7	0	254	9	1	82	EDO25965.1 predicted protein, partial [Nematostella vectensis]	diamond	246	149	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
27438414	27438414	PRJNA1073183_P_NODE_32003_length_244_cov_0.900585_g31908_i0	PRJNA1073183	32003	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	127	7.66e-33	NR	KAK2551111.1	6130	g31908	i0	80	4.91803278688525	80	16	98.4	0	242	3	29	108	KAK2551111.1 RuvB-like 1 [Acropora cervicornis]	diamond	1200	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
28669657	28669657	PRJNA1073183_P_NODE_2767_length_748_cov_2.588148_g2684_i0	PRJNA1073183	2767	748	2.588148	19.35934704	Metazoa	33208	Cnidaria	other_Eukaryota	176	1.19e-48	NR	PFX18144.1	50429	g2684	i0	66.9	8.6951871657754	127	42	50.9	0	620	240	331	457	PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata]	diamond	6504	177	0.994350282485876	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
29530576	29530576	PRJNA1073183_P_NODE_33250_length_242_cov_1.532544_g33155_i0	PRJNA1073183	33250	242	1.532544	3.70875648	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	49.7	1.35e-4	NR	XP_057299698.1	13093	g33155	i0	42.4	0.731404958677686	59	34	73.1	0	60	236	1746	1804	XP_057299698.1 NFX1-type zinc finger-containing protein 1-like [Hydractinia symbiolongicarpus]	diamond	177	49.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
29751260	29751260	PRJNA1073183_P_NODE_25611_length_256_cov_1.060109_g25516_i0	PRJNA1073183	25611	256	1.060109	2.71387904	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	99.8	3.08e-23	NR	XP_020917829.1	2652724	g25516	i0	55.3	4.734375	85	38	99.6	0	255	1	150	234	XP_020917829.1 T-complex protein 1 subunit epsilon, partial [Exaiptasia diaphana]	diamond	1212	99.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
29806065	29806065	PRJNA1073183_P_NODE_4511_length_595_cov_1.559387_g4419_i0	PRJNA1073183	4511	595	1.559387	9.27835265	Anthozoa	6101	Cnidaria	other_Eukaryota	271	1.03e-89	NR	XP_029195686.1	45264	g4419	i0	74.2	11.1075630252101	194	48	96.8	1	2	577	3	196	XP_029195686.1 60S ribosomal protein L19-like [Acropora millepora]	diamond	6609	271	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
30415298	30415298	PRJNA1073183_P_NODE_24333_length_264_cov_1.314136_g24238_i0	PRJNA1073183	24333	264	1.314136	3.46931904	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	120	1.03e-30	NR	KAF0990582.1	69463	g24238	i0	66.7	5.47727272727273	84	28	95.5	0	1	252	11	94	KAF0990582.1 hypothetical protein HZS_1026 [Henneguya salminicola]	diamond	1446	120	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
30635925	30635925	PRJNA1073183_P_NODE_31993_length_244_cov_0.900585_g31898_i0	PRJNA1073183	31993	244	0.900585	2.1974274	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	67.8	1.46e-11	NR	XP_028401840.1	151771	g31898	i0	40.8	3.71311475409836	76	45	93.4	0	240	13	60	135	XP_028401840.1 methylosome subunit pICln-like [Dendronephthya gigantea]	diamond	906	67.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
32217167	32217167	PRJNA1073183_P_NODE_24218_length_265_cov_1.203125_g24123_i0	PRJNA1073183	24218	265	1.203125	3.18828125	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	118	1.04e-28	NR	XP_065059180.1	499914	g24123	i0	67.1	1.94716981132075	85	28	96.2	0	3	257	146	230	XP_065059180.1 advillin-like [Rhopilema esculentum]	diamond	516	118	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum

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