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

9 rows where analysis = "blastn", bioproject = "PRJNA812715" 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
4641009	4641009	PRJNA812715_P_NODE_18944_length_791_cov_13.583565_g17376_i0	PRJNA812715	18944	791	13.583565	107.44599915	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	54.7	0.022	NTclustered	gi\|2918369540\|emb\|OZ237722.1\|	317547	g17376	i0	100	0.0366624525916561	29	0	4	0	412	440	5240126	5240154	Eunicella cavolini genome assembly, chromosome: 6	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
7190275	7190275	PRJNA812715_P_NODE_116526_length_243_cov_1.811765_g114725_i0	PRJNA812715	116526	243	1.811765	4.40258895	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940731\|emb\|OZ237564.1\|	6108	g114725	i0	100	0.592592592592593	30	0	12	0	158	187	11304901	11304930	Anemonia sulcata genome assembly, chromosome: 10	blastn	144	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
8466994	8466994	PRJNA812715_P_NODE_64507_length_323_cov_0.984000_g62708_i0	PRJNA812715	64507	323	0.984	3.17832	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	132	3.79e-26	NTclustered	gi\|2917940714\|emb\|OZ237561.1\|	6108	g62708	i0	89.423	7.1640866873065	104	11	32	0	87	190	4587226	4587329	Anemonia sulcata genome assembly, chromosome: 7	blastn	2314	132	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
8467816	8467816	PRJNA812715_P_NODE_92887_length_264_cov_1.366492_g91086_i0	PRJNA812715	92887	264	1.366492	3.60753888	Acropora millepora	45264	Cnidaria	other_Eukaryota	52.8	0.024	NTclustered	gi\|2114135399\|ref\|XM_029355121.2\|	45264	g91086	i0	100	0.318181818181818	28	0	11	0	177	204	605	578	PREDICTED: Acropora millepora uncharacterized LOC114974984 (LOC114974984), mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
12293886	12293886	PRJNA812715_P_NODE_85770_length_275_cov_1.524752_g83969_i0	PRJNA812715	85770	275	1.524752	4.193068	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	189	1.8499999999999993e-43	NTclustered	gi\|2751529865\|ref\|XM_059099308.2\|	203993	g83969	i0	79.924	12.6109090909091	264	47	95	6	1	261	520	780	PREDICTED: Pocillopora verrucosa serine/threonine-protein phosphatase 4 catalytic subunit B (LOC131782562), mRNA	blastn	3468	189	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
13568549	13568549	PRJNA812715_P_NODE_96471_length_258_cov_2.529730_g94670_i0	PRJNA812715	96471	258	2.52973	6.5267034	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|1603827957\|ref\|XM_028562417.1\|	151771	g94670	i0	100	0.217054263565891	28	0	11	0	109	136	375	402	PREDICTED: Dendronephthya gigantea uncharacterized LOC114543442 (LOC114543442), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
16114508	16114508	PRJNA812715_P_NODE_115213_length_244_cov_0.900585_g113412_i0	PRJNA812715	115213	244	0.900585	2.1974274	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	58.4	4.73e-4	NTclustered	gi\|2518963869\|ref\|XM_057435836.1\|	13093	g113412	i0	100	2.41803278688525	31	0	13	0	105	135	2695	2725	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130614409 (LOC130614409), mRNA	blastn	590	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
17802255	17802255	PRJNA812715_P_NODE_107294_length_248_cov_1.308571_g105493_i0	PRJNA812715	107294	248	1.308571	3.24525608	Metazoa	33208	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940744\|emb\|OZ237568.1\|	6108	g105493	i0	75.61	9.77822580645161	123	25	48	5	39	157	1853914	1853793	Anemonia sulcata genome assembly, chromosome: 14	blastn	2425	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
21215043	21215043	PRJNA812715_P_NODE_29617_length_559_cov_0.874486_g27856_i0	PRJNA812715	29617	559	0.874486	4.88837674	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	54.7	0.015	NTclustered	gi\|2744793178\|ref\|XM_065822044.1\|	6087	g27856	i0	100	0.0518783542039356	29	0	5	0	374	402	1957	1985	PREDICTED: Hydra vulgaris uncharacterized LOC136093124 (LOC136093124), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris

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