metadata: contig_metadata: 7 rows where bioproject = "PRJEB673", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJEB673", 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
7787304	7787304	PRJEB673_P_NODE_4987_length_407_cov_2.024194_g4639_i0	PRJEB673	4987	407	2.024194	8.23846958	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	227	1.7599999999999998e-72	NR	EDO25965.1	45351	g4639	i0	88.9	0.995085995085995	135	15	99.5	0	3	407	1	135	EDO25965.1 predicted protein, partial [Nematostella vectensis]	diamond	405	227	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
14163275	14163275	PRJEB673_P_NODE_12992_length_150_cov_1.391304_g12643_i0	PRJEB673	12992	150	1.391304	2.086956	Psammocora contigua	213643	Cnidaria	other_Eukaryota	150	4.2099999999999997e-32	NTclustered	gi\|148595594\|emb\|AM421746.1\|	213643	g12643	i0	85.816	61.5066666666667	141	20	94	0	10	150	48	188	Psammocora contigua partial tubb gene for beta tubulin, exons 1-2, clone MA256C	blastn	9226	150	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Siderastreidae	Psammocora	Psammocora contigua
23086705	23086705	PRJEB673_P_NODE_3659_length_522_cov_1.948665_g3334_i0	PRJEB673	3659	522	1.948665	10.1720313	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	226	1.65e-71	NR	XP_065068387.1	499914	g3334	i0	67.9	2.90804597701149	165	53	94.8	0	3	497	42	206	XP_065068387.1 large ribosomal subunit protein eL8-like [Rhopilema esculentum]	diamond	1518	226	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
26653977	26653977	PRJEB673_P_NODE_2461_length_626_cov_3.913706_g2173_i0	PRJEB673	2461	626	3.913706	24.49979956	Porites lobata	104759	Cnidaria	other_Eukaryota	146	6.419999999999999e-37	NR	CAH3037219.1	104759	g2173	i0	56.4	49.7060702875399	156	59	71.4	3	623	177	447	600	CAH3037219.1 unnamed protein product [Porites lobata]	diamond	31116	147	0.993197278911565	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
28258529	28258529	PRJEB673_P_NODE_5266_length_391_cov_2.050562_g4917_i0	PRJEB673	5266	391	2.050562	8.01769742	root	1	Root_unresolved	Root_unresolved	86.7	1.1e-17	NR	EDO25965.1	45351	g4917	i0	100	1.48849104859335	45	0	34.5	0	1	135	134	178	EDO25965.1 predicted protein, partial [Nematostella vectensis]	diamond	582	86.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
31006365	31006365	PRJEB673_P_NODE_10674_length_170_cov_1.555556_g10325_i0	PRJEB673	10674	170	1.555556	2.6444452	Opisthokonta	33154	Cnidaria	other_Eukaryota	85.9	2.07e-19	NR	KII64693.1	669202	g10325	i0	72.7	1.94117647058824	55	15	97.1	0	165	1	72	126	KII64693.1 60S ribosomal protein L12-3 [Thelohanellus kitauei]	diamond	330	85.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
32366633	32366633	PRJEB673_P_NODE_10639_length_171_cov_1.139706_g10290_i0	PRJEB673	10639	171	1.139706	1.94889726	Opisthokonta	33154	Cnidaria	other_Eukaryota	89.4	1.4500000000000002e-21	NR	XP_057300244.1	13093	g10290	i0	73.1	10.2280701754386	52	14	91.2	0	159	4	1	52	XP_057300244.1 probable 60S ribosomal protein L37-A [Hydractinia symbiolongicarpus]	diamond	1749	90.1	0.992230854605993	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);;