metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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
179399	179399	PRJNA1063685_S_NODE_15221_length_559_cov_16.333333_g14693_i0	PRJNA1063685	15221	559	16.333333	91.30333147	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	54.7	0.015	NTclustered	gi\|2202645818\|ref\|XM_046996428.1\|	2897299	g14693	i0	96.875	0.0572450805008945	32	1	6	0	134	165	7208	7239	PREDICTED: Xenia sp. Carnegie-2017 cytoplasmic dynein 2 heavy chain 1-like (LOC124445678), mRNA	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
5282405	5282405	PRJNA1063685_S_NODE_40885_length_363_cov_13.706897_g40342_i0	PRJNA1063685	40885	363	13.706897	49.75603611	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	209	1.93e-49	NTclustered	gi\|2918369537\|emb\|OZ237719.1\|	317547	g40342	i0	77.322	74.2727272727273	366	76	100	6	1	363	26507960	26508321	Eunicella cavolini genome assembly, chromosome: 3	blastn	26961	209	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
7389837	7389837	PRJNA1063685_S_NODE_62426_length_272_cov_1.728643_g61883_i0	PRJNA1063685	62426	272	1.728643	4.70190896	root	1	Root_unresolved	Root_unresolved	99	3.16e-16	NTclustered	gi\|1005425980\|ref\|XR_001560994.1\|	70779	g61883	i0	91.549	17.0661764705882	71	6	26	0	196	266	9	79	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA	blastn	4642	99	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
8665256	8665256	PRJNA1063685_S_NODE_5387_length_721_cov_32.212963_g4939_i0	PRJNA1063685	5387	721	32.212963	232.25546323	root	1	Root_unresolved	Root_unresolved	108	1.52e-18	NTclustered	gi\|1005425980\|ref\|XR_001560994.1\|	70779	g4939	i0	95.522	13.0929264909847	67	3	9	0	637	703	9	75	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA	blastn	9440	108	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
9940058	9940058	PRJNA1063685_S_NODE_29988_length_429_cov_1.974719_g29446_i0	PRJNA1063685	29988	429	1.974719	8.47154451	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.041	NTclustered	gi\|2917940714\|emb\|OZ237561.1\|	6108	g29446	i0	100	0.137529137529138	28	0	7	0	269	296	1740783	1740756	Anemonia sulcata genome assembly, chromosome: 7	blastn	59	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
11215302	11215302	PRJNA1063685_S_NODE_27069_length_450_cov_10.217507_g26528_i0	PRJNA1063685	27069	450	10.217507	45.9787815	root	1	Root_unresolved	Root_unresolved	117	1.52e-21	NTclustered	gi\|1005425980\|ref\|XR_001560994.1\|	70779	g26528	i0	95.833	15.08	72	3	16	0	378	449	9	80	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X7, ncRNA	blastn	6786	117	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
12933335	12933335	PRJNA1063685_S_NODE_37271_length_383_cov_2.738710_g36728_i0	PRJNA1063685	37271	383	2.73871	10.4892593	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.01	NTclustered	gi\|2917940712\|emb\|OZ237560.1\|	6108	g36728	i0	100	0.0757180156657963	29	0	8	0	106	134	9052098	9052070	Anemonia sulcata genome assembly, chromosome: 6	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
18031478	18031478	PRJNA1063685_S_NODE_60815_length_277_cov_2.553922_g60272_i0	PRJNA1063685	60815	277	2.553922	7.07436394	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	71.3	7.04e-8	NTclustered	gi\|1270070985\|ref\|XR_002695435.1\|	50429	g60272	i0	87.097	0.570397111913357	62	8	22	0	56	117	111	172	PREDICTED: Stylophora pistillata uncharacterized LOC111336533 (LOC111336533), ncRNA	blastn	158	71.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
21856430	21856430	PRJNA1063685_S_NODE_36818_length_385_cov_7.897436_g36275_i0	PRJNA1063685	36818	385	7.897436	30.4051286	Acropora digitifera	70779	Cnidaria	other_Eukaryota	52.8	0.037	NTclustered	gi\|1005481871\|ref\|XM_015922156.1\|	70779	g36275	i0	100	0.0727272727272727	28	0	7	0	109	136	528	501	PREDICTED: Acropora digitifera mannosyl-oligosaccharide 1,2-alpha-mannosidase IA-like (LOC107355569), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera

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