metadata: contig_metadata: 11 rows where bioproject = "PRJNA454503", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA454503", 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
3644562	3644562	PRJNA454503_P_NODE_1703_length_924_cov_3914.676709_g1442_i0	PRJNA454503	1703	924	3914.676709	36171.61279116	Malacalcyonacea	3028843	Cnidaria	other_Eukaryota	154	2.49e-32	NTclustered	gi\|8101942\|gb\|AF262347.1\|	51768	g1442	i0	95.789	11.0064935064935	95	4	10	0	6	100	675	769	Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	10170	154	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Alcyoniidae	Alcyonium	Alcyonium digitatum
8746525	8746525	PRJNA454503_P_NODE_1767_length_910_cov_3978.122497_g1503_i0	PRJNA454503	1767	910	3978.122497	36200.9147227	Malacalcyonacea	3028843	Cnidaria	other_Eukaryota	154	2.45e-32	NTclustered	gi\|8101942\|gb\|AF262347.1\|	51768	g1503	i0	95.789	11.1758241758242	95	4	10	0	811	905	769	675	Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	10170	154	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Alcyoniidae	Alcyonium	Alcyonium digitatum
13847419	13847419	PRJNA454503_P_NODE_5811_length_474_cov_6974.731235_g5483_i0	PRJNA454503	5811	474	6974.731235	33060.2260539	Malacalcyonacea	3028843	Cnidaria	other_Eukaryota	154	1.23e-32	NTclustered	gi\|8101942\|gb\|AF262347.1\|	51768	g5483	i0	95.789	21.4556962025316	95	4	20	0	375	469	769	675	Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	10170	154	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Alcyoniidae	Alcyonium	Alcyonium digitatum
19568746	19568746	PRJNA454503_P_NODE_87556_length_198_cov_2.459854_g87227_i0	PRJNA454503	87556	198	2.459854	4.87051092	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	115	2.16e-21	NTclustered	gi\|2782945195\|ref\|XM_067077207.1\|	252671	g87227	i0	80.795	1.96969696969697	151	25	75	4	18	166	1615	1763	PREDICTED: Clytia hemisphaerica 26S proteasome non-ATPase regulatory subunit 1-like (LOC136820975), mRNA	blastn	390	115	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
20843666	20843666	PRJNA454503_P_NODE_11197_length_336_cov_1.621818_g10868_i0	PRJNA454503	11197	336	1.621818	5.44930848	Agalma elegans	316166	Cnidaria	other_Eukaryota	137	1.2999999999999998e-38	NR	AAZ83740.1	316166	g10868	i0	82.4	1.51785714285714	85	15	75.9	0	5	259	89	173	AAZ83740.1 elongation factor 1 alpha, partial [Agalma elegans]	diamond	510	137	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Siphonophorae	Agalmatidae	Agalma	Agalma elegans
24668367	24668367	PRJNA454503_P_NODE_24420_length_251_cov_5.505263_g24091_i0	PRJNA454503	24420	251	5.505263	13.81821013	Sinuolinea arctica	1483224	Cnidaria	other_Eukaryota	80.5	1.04e-10	NTclustered	gi\|605060087\|gb\|KF874227.1\|	1483224	g24091	i0	80.374	0.549800796812749	107	19	42	2	35	140	1378	1273	Sinuolinea arctica 28S ribosomal RNA gene, partial sequence	blastn	138	80.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Sinuolineidae	Sinuolinea	Sinuolinea arctica
24668376	24668376	PRJNA454503_P_NODE_25380_length_249_cov_1.026596_g25051_i0	PRJNA454503	25380	249	1.026596	2.55622404	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	134	7.82e-27	NTclustered	gi\|2782891151\|ref\|XM_067066273.1\|	252671	g25051	i0	80.226	42.1044176706827	177	35	71	0	27	203	808	984	PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136809726), mRNA	blastn	10484	134	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
26902686	26902686	PRJNA454503_P_NODE_55661_length_211_cov_0.866667_g55332_i0	PRJNA454503	55661	211	0.866667	1.82866737	Metazoa	33208	Cnidaria	other_Eukaryota	110	4.81e-26	NR	KAK2549642.1	6130	g55332	i0	82.9	8.95734597156398	70	12	99.5	0	210	1	543	612	KAK2549642.1 Polycystin-2 [Acropora cervicornis]	diamond	1890	110	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
27802832	27802832	PRJNA454503_P_NODE_7804_length_402_cov_2.281525_g7475_i0	PRJNA454503	7804	402	2.281525	9.1717305	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	94.4	2.13e-22	NR	XP_027042795.1	46731	g7475	i0	51.8	0.619402985074627	83	40	61.9	0	319	71	1	83	XP_027042795.1 migration and invasion enhancer 1-like, partial [Pocillopora damicornis]	diamond	249	94.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
30218630	30218630	PRJNA454503_P_NODE_21592_length_262_cov_2.537313_g21263_i0	PRJNA454503	21592	262	2.537313	6.64776006	Metazoa	33208	Cnidaria	other_Eukaryota	67	1.34e-10	NR	XP_047144239.1	6087	g21263	i0	63.4	2.32442748091603	41	15	46.9	0	140	262	418	458	XP_047144239.1 uncharacterized protein LOC124817853 [Hydra vulgaris]	diamond	609	67.4	0.99406528189911	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30644700	30644700	PRJNA454503_P_NODE_83413_length_202_cov_2.304965_g83084_i0	PRJNA454503	83413	202	2.304965	4.6560293	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	123	3.5e-31	NR	KAJ7383681.1	174260	g83084	i0	82.1	3.98019801980198	67	12	99.5	0	201	1	388	454	KAJ7383681.1 Elongation factor 1-alpha 1 [Desmophyllum pertusum]	diamond	804	123	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum

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