metadata: contig_metadata: 5 rows where bioproject = "PRJNA572587", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA572587", 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
6936817	6936817	PRJNA572587_P_NODE_15846_length_288_cov_19.167364_g15518_i0	PRJNA572587	15846	288	19.167364	55.20200832	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.027	NTclustered	gi\|2917940759\|emb\|OZ237572.1\|	6108	g15518	i0	94.118	0.118055555555556	34	2	12	0	155	188	10900946	10900979	Anemonia sulcata genome assembly, chromosome: 18	blastn	34	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
8211919	8211919	PRJNA572587_P_NODE_25887_length_220_cov_7.187135_g25559_i0	PRJNA572587	25887	220	7.187135	15.811697	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	58.4	4.19e-4	NTclustered	gi\|2918369539\|emb\|OZ237721.1\|	317547	g25559	i0	100	0.268181818181818	31	0	14	0	25	55	3476522	3476492	Eunicella cavolini genome assembly, chromosome: 5	blastn	59	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
28784671	28784671	PRJNA572587_P_NODE_5647_length_527_cov_1.462343_g5327_i0	PRJNA572587	5647	527	1.462343	7.70654761	Montipora foliosa	591990	Cnidaria	other_Eukaryota	77	8.29e-13	NR	XP_068711837.1	591990	g5327	i0	67.3	0.870967741935484	52	17	29.6	0	156	1	507	558	XP_068711837.1 glycine betaine transporter 1-like [Montipora foliosa]	diamond	459	77	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa
28847798	28847798	PRJNA572587_P_NODE_23388_length_233_cov_6.673913_g23060_i0	PRJNA572587	23388	233	6.673913	15.55021729	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	43.1	0.00931	NR	KII71058.1	669202	g23060	i0	56.8	0.476394849785408	37	15	46.4	1	9	116	66	102	KII71058.1 hypothetical protein RF11_14684 [Thelohanellus kitauei]	diamond	111	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
32891971	32891971	PRJNA572587_P_NODE_40980_length_171_cov_1.254098_g40652_i0	PRJNA572587	40980	171	1.254098	2.14450758	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	77	1.13e-14	NR	XP_031569602.1	6105	g40652	i0	65.5	2.89473684210526	55	19	96.5	0	2	166	274	328	XP_031569602.1 uncharacterized protein LOC116304088 [Actinia tenebrosa]	diamond	495	77	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa

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