metadata: contig_metadata: 9 rows where bioproject = "PRJNA902848", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA902848", 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
7260232	7260232	PRJNA902848_P_NODE_6146_length_344_cov_6.690037_g6096_i0	PRJNA902848	6146	344	6.690037	23.01372728	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.009	NTclustered	gi\|2917940744\|emb\|OZ237568.1\|	6108	g6096	i0	96.97	0.0959302325581395	33	0	9	1	214	245	6800800	6800832	Anemonia sulcata genome assembly, chromosome: 14	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
8534841	8534841	PRJNA902848_P_NODE_14007_length_252_cov_0.871508_g13957_i0	PRJNA902848	14007	252	0.871508	2.19620016	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	61.2	1.24e-8	NR	KXJ08354.1	2652724	g13957	i0	55	0.476190476190476	40	18	47.6	0	56	175	42	81	KXJ08354.1 Prolow-density lipoprotein receptor-related protein 1 [Exaiptasia diaphana]	diamond	120	61.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
12361161	12361161	PRJNA902848_P_NODE_8150_length_309_cov_1.652542_g8100_i0	PRJNA902848	8150	309	1.652542	5.10635478	root	1	Root_unresolved	Root_unresolved	183	2.94e-56	NR	XP_066925013.1	252671	g8100	i0	83.3	4.95145631067961	102	17	99	0	307	2	43	144	XP_066925013.1 GTP-binding nuclear protein Ran-like [Clytia hemisphaerica]	diamond	1530	184	0.994565217391304	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
14910103	14910103	PRJNA902848_P_NODE_7812_length_314_cov_1.775934_g7762_i0	PRJNA902848	7812	314	1.775934	5.57643276	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	276	1.6e-69	NTclustered	gi\|2257870126\|ref\|XM_032363373.2\|	45351	g7762	i0	86.454	24.531847133758	251	34	80	0	12	262	379	129	PREDICTED: Nematostella vectensis calmodulin (LOC5518649), mRNA	blastn	7703	276	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
25107949	25107949	PRJNA902848_P_NODE_14640_length_251_cov_0.876404_g14590_i0	PRJNA902848	14640	251	0.876404	2.19977404	Bonneviella sp. 4 839AS	314577	Cnidaria	other_Eukaryota	211	3.55e-50	NTclustered	gi\|62825425\|gb\|AY789849.1\|	314577	g14590	i0	89.697	30	165	17	66	0	1	165	165	1	Bonneviella sp. 4 839AS calmodulin gene, partial cds	blastn	7530	211	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Campanulariidae	Bonneviella	Bonneviella sp. 4 839AS
28824074	28824074	PRJNA902848_P_NODE_20408_length_242_cov_0.923077_g20358_i0	PRJNA902848	20408	242	0.923077	2.23384634	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	50.4	1.47e-5	NR	KAJ7377012.1	174260	g20358	i0	41.5	4.21487603305785	82	44	96.7	4	237	4	6	87	KAJ7377012.1 hypothetical protein OS493_031285 [Desmophyllum pertusum]	diamond	1020	50.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
29392781	29392781	PRJNA902848_P_NODE_11049_length_273_cov_1.340000_g10999_i0	PRJNA902848	11049	273	1.34	3.6582	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	66.6	1.99e-10	NR	XP_020631452.1	48498	g10999	i0	43	0.868131868131868	79	40	81.3	1	1	222	292	370	XP_020631452.1 uncharacterized protein LOC110068417 [Orbicella faveolata]	diamond	237	66.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
30624414	30624414	PRJNA902848_P_NODE_13173_length_253_cov_0.866667_g13123_i0	PRJNA902848	13173	253	0.866667	2.19266751	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	73.6	1.37e-13	NR	XP_046847902.1	2897299	g13123	i0	49.3	4.43478260869565	73	37	86.6	0	252	34	60	132	XP_046847902.1 ribosomal RNA processing protein 36 homolog [Xenia sp. Carnegie-2017]	diamond	1122	73.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
32718689	32718689	PRJNA902848_P_NODE_1780_length_544_cov_2.382166_g1731_i0	PRJNA902848	1780	544	2.382166	12.95898304	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	112	3.76e-28	NR	XP_029195141.1	45264	g1731	i0	49.6	5.63051470588235	133	66	72.8	1	531	136	2	134	XP_029195141.1 60S ribosomal protein L14-like [Acropora millepora]	diamond	3063	112	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora

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