metadata: contig_metadata: 14 rows where bioproject = "PRJNA1240804", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA1240804", tax_clade = "Opisthokonta" 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
1623218	1623218	PRJNA1240804_P_NODE_58262_length_207_cov_1.607595_g57896_i0	PRJNA1240804	58262	207	1.607595	3.32772165	Ceratomyxa leatherjacketi	1579382	Cnidaria	other_Eukaryota	73.1	1.39e-8	NTclustered	gi\|730837044\|gb\|KM392428.1\|	1579382	g57896	i0	85.714	0.536231884057971	70	9	34	1	138	207	380	448	Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence	blastn	111	73.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Ceratomyxidae	Ceratomyxa	Ceratomyxa leatherjacketi
4175209	4175209	PRJNA1240804_P_NODE_3424_length_622_cov_2.677138_g3086_i0	PRJNA1240804	3424	622	2.677138	16.65179836	Montipora capricornis	246305	Cnidaria	other_Eukaryota	58.4	0.001	NTclustered	gi\|2812114944\|ref\|XM_068870257.1\|	246305	g3086	i0	97.059	0.0546623794212219	34	1	5	0	558	591	178	145	PREDICTED: Montipora capricornis nucleolar transcription factor 1-A-like (LOC138023236), mRNA	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
11253332	11253332	PRJNA1240804_P_NODE_145409_length_163_cov_0.912281_g145043_i0	PRJNA1240804	145409	163	0.912281	1.48701803	Anthozoa	6101	Cnidaria	other_Eukaryota	82.4	1.73e-11	NTclustered	gi\|636577294\|gb\|KJ483128.1\|	856778	g145043	i0	87.5	2.19018404907975	72	8	44	1	10	80	1901	1830	Antholoba achates isolate acha 28S large subunit ribosomal RNA gene, partial sequence	blastn	357	82.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Antholoba	Antholoba achates
15651201	15651201	PRJNA1240804_P_NODE_40313_length_237_cov_1.281915_g39947_i0	PRJNA1240804	40313	237	1.281915	3.03813855	Parvicapsula sp. SPS-2018	2806882	Cnidaria	other_Eukaryota	121	5.75e-23	NTclustered	gi\|1444845538\|gb\|MH729074.1\|	2806882	g39947	i0	85.593	5.24472573839662	118	14	50	3	20	137	1978	1864	Parvicapsula sp. SPS-2018 isolate JejuCJGd-2018 large subunit ribosomal RNA gene, partial sequence	blastn	1243	121	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Parvicapsulidae	Parvicapsula	Parvicapsula sp. SPS-2018
18200261	18200261	PRJNA1240804_P_NODE_56955_length_209_cov_1.218750_g56589_i0	PRJNA1240804	56955	209	1.21875	2.5471875	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	76.8	1.09e-9	NTclustered	gi\|2518956999\|ref\|XR_008980547.1\|	13093	g56589	i0	95.833	18.7416267942584	48	0	22	2	15	61	2119	2165	PREDICTED: Hydractinia symbiolongicarpus large subunit ribosomal RNA (LOC130619804), rRNA	blastn	3917	76.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
18901834	18901834	PRJNA1240804_P_NODE_69395_length_194_cov_1.551724_g69029_i0	PRJNA1240804	69395	194	1.551724	3.01034456	Buddenbrockia	185686	Cnidaria	other_Eukaryota	56.5	0.001	NTclustered	gi\|570962622\|gb\|KF731730.1\|	1442316	g69029	i0	82.353	18.2113402061856	68	9	35	2	38	104	319	254	Buddenbrockia sp. 2 PBS-2014 isolate Bsp2CaC 28S ribosomal RNA gene, partial sequence	blastn	3533	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Malacovalvulida	Saccosporidae	Buddenbrockia	Buddenbrockia sp. 2 PBS-2014
20750628	20750628	PRJNA1240804_P_NODE_84917_length_183_cov_1.447761_g84551_i0	PRJNA1240804	84917	183	1.447761	2.64940263	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	52.8	0.016	NTclustered	gi\|2782839894\|ref\|XM_067055043.1\|	252671	g84551	i0	100	0.306010928961749	28	0	15	0	64	91	7988	7961	PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136798434), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
25276435	25276435	PRJNA1240804_P_NODE_60500_length_204_cov_1.606452_g60134_i0	PRJNA1240804	60500	204	1.606452	3.27716208	Cubozoa	6137	Cnidaria	other_Eukaryota	121	4.809999999999999e-23	NTclustered	gi\|270297346\|gb\|GQ849057.1\|	645347	g60134	i0	82.609	21.9656862745098	138	22	67	2	69	204	1936	2073	Chiropsalmus quadrumanus isolate BB011 28S large subunit ribosomal RNA gene, partial sequence	blastn	4481	121	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Cubozoa	Chirodropida	Chiropsalmidae	Chiropsalmus	Chiropsalmus quadrumanus
27231486	27231486	PRJNA1240804_P_NODE_13563_length_362_cov_9.440895_g13198_i0	PRJNA1240804	13563	362	9.440895	34.1760399	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	47.4	0.0035	NR	CAB4034706.1	317549	g13198	i0	35.6	4.97237569060773	87	50	70.4	3	25	279	152	234	CAB4034706.1 Retrovirus-related Pol poly from transposon TNT 1-94 [Paramuricea clavata]	diamond	1800	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
27294702	27294702	PRJNA1240804_P_NODE_117923_length_167_cov_1.483051_g117557_i0	PRJNA1240804	117923	167	1.483051	2.47669517	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	42.4	0.00239	NR	EDO34211.1	45351	g117557	i0	61.3	0.55688622754491	31	12	55.7	0	107	15	13	43	EDO34211.1 predicted protein, partial [Nematostella vectensis]	diamond	93	42.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
27863101	27863101	PRJNA1240804_P_NODE_25425_length_284_cov_1.093617_g25059_i0	PRJNA1240804	25425	284	1.093617	3.10587228	Porites lobata	104759	Cnidaria	other_Eukaryota	47	0.00201	NR	CAH3119332.1	104759	g25059	i0	50	2.10211267605634	30	14	31.7	1	140	229	1142	1170	CAH3119332.1 unnamed protein product [Porites lobata]	diamond	597	47.4	0.991561181434599	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
29852487	29852487	PRJNA1240804_P_NODE_83691_length_184_cov_1.318519_g83325_i0	PRJNA1240804	83691	184	1.318519	2.42607496	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	58.5	4.57e-8	NR	XP_065056091.1	499914	g83325	i0	45.5	1.77717391304348	55	30	89.7	0	16	180	63	117	XP_065056091.1 fragile X messenger ribonucleoprotein 1 homolog A-like [Rhopilema esculentum]	diamond	327	58.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
29884043	29884043	PRJNA1240804_P_NODE_106331_length_169_cov_1.625000_g105965_i0	PRJNA1240804	106331	169	1.625	2.74625	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	78.2	3.71e-15	NR	PFX25697.1	50429	g105965	i0	75.5	0.869822485207101	49	12	87	0	16	162	341	389	PFX25697.1 ATP-dependent helicase SGS1 [Stylophora pistillata]	diamond	147	78.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
31906742	31906742	PRJNA1240804_P_NODE_119917_length_167_cov_0.881356_g119551_i0	PRJNA1240804	119917	167	0.881356	1.47186452	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	46.2	7.97e-4	NR	XP_020907419.2	2652724	g119551	i0	55.6	0.48502994011976	27	12	48.5	0	10	90	17	43	XP_020907419.2 uncharacterized protein LOC110245476 [Exaiptasia diaphana]	diamond	81	46.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana

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