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

7 rows where bioproject = "PRJNA255848", 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
6746476	6746476	PRJNA255848_P_NODE_48306_length_160_cov_3.288288_g47988_i0	PRJNA255848	48306	160	3.288288	5.2612608	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	99	1.68e-16	NTclustered	gi\|2917940714\|emb\|OZ237561.1\|	6108	g47988	i0	87.356	0.54375	87	9	54	2	38	123	3961706	3961791	Anemonia sulcata genome assembly, chromosome: 7	blastn	87	99	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
28228498	28228498	PRJNA255848_P_NODE_17786_length_236_cov_1.636364_g17468_i0	PRJNA255848	17786	236	1.636364	3.86181904	Metazoa	33208	Cnidaria	other_Eukaryota	158	7.659999999999999e-45	NR	KAK2556315.1	6130	g17468	i0	98.7	150.71186440678	77	1	97.9	0	236	6	207	283	KAK2556315.1 26S proteasome regulatory subunit 7 [Acropora cervicornis]	diamond	35568	159	0.993710691823899	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
28796884	28796884	PRJNA255848_P_NODE_46267_length_162_cov_0.902655_g45949_i0	PRJNA255848	46267	162	0.902655	1.4623011	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	114	7.62e-28	NR	XP_047125603.1	6087	g45949	i0	98.1	482.833333333333	53	1	98.1	0	3	161	158	210	XP_047125603.1 histone deacetylase 1 isoform X1 [Hydra vulgaris]	diamond	78219	114	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29712345	29712345	PRJNA255848_P_NODE_22990_length_208_cov_1.157233_g22672_i0	PRJNA255848	22990	208	1.157233	2.40704464	Metazoa	33208	Cnidaria	other_Eukaryota	72	7.55e-13	NR	XP_031559192.1	6105	g22672	i0	100	57.1153846153846	33	0	47.6	0	208	110	291	323	XP_031559192.1 ubiquitin-like-conjugating enzyme ATG3 [Actinia tenebrosa]	diamond	11880	72	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
32178394	32178394	PRJNA255848_P_NODE_38218_length_166_cov_0.871795_g37900_i0	PRJNA255848	38218	166	0.871795	1.4471797	root	1	Root_unresolved	Root_unresolved	114	3.24e-28	NR	XP_031569504.1	6105	g37900	i0	98.1	178.066265060241	54	1	97.6	0	162	1	34	87	XP_031569504.1 spliceosome RNA helicase Ddx39b [Actinia tenebrosa]	diamond	29559	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
32494802	32494802	PRJNA255848_P_NODE_20479_length_220_cov_1.385965_g20161_i0	PRJNA255848	20479	220	1.385965	3.049123	Metazoa	33208	Cnidaria	other_Eukaryota	152	1.02e-40	NR	KAK2549732.1	6130	g20161	i0	97.3	330.490909090909	73	2	99.5	0	1	219	481	553	KAK2549732.1 Histone deacetylase 1 [Acropora cervicornis]	diamond	72708	153	0.993464052287582	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
32558177	32558177	PRJNA255848_P_NODE_32539_length_174_cov_1.224000_g32221_i0	PRJNA255848	32539	174	1.224	2.12976	Metazoa	33208	Cnidaria	other_Eukaryota	113	4.2e-28	NR	XP_047137947.1	6087	g32221	i0	98.2	208.344827586207	57	1	98.3	0	172	2	136	192	XP_047137947.1 actin-related protein 3 isoform X1 [Hydra vulgaris]	diamond	36252	113	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);;