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

5 rows where bioproject = "PRJNA1046144", 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
7824750	7824750	PRJNA1046144_P_NODE_31207_length_301_cov_1.879310_g30912_i0	PRJNA1046144	31207	301	1.87931	5.6567231	Halcampulactis solimar	2591176	Cnidaria	other_Eukaryota	124	5.85e-24	NTclustered	gi\|1697232357\|gb\|MK279365.1\|	2591176	g30912	i0	91.304	44.9003322259136	92	7	31	1	203	294	2011	2101	Halcampulactis solimar voucher AMNH:IZ 4218 28S large subunit ribosomal RNA gene, partial sequence	blastn	13515	124	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Halcampulactidae	Halcampulactis	Halcampulactis solimar
10375688	10375688	PRJNA1046144_P_NODE_45389_length_258_cov_1.523810_g45094_i0	PRJNA1046144	45389	258	1.52381	3.9314298	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2744899243\|ref\|XM_065815241.1\|	6087	g45094	i0	100	0.108527131782946	28	0	11	0	229	256	11325	11352	PREDICTED: Hydra vulgaris uncharacterized LOC136089301 (LOC136089301), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
16749042	16749042	PRJNA1046144_P_NODE_30114_length_306_cov_1.168776_g29819_i0	PRJNA1046144	30114	306	1.168776	3.57645456	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	75	6.09e-9	NTclustered	gi\|1603779081\|ref\|XM_028536864.1\|	151771	g29819	i0	80	12.3496732026144	100	20	33	0	205	304	419	320	PREDICTED: Dendronephthya gigantea zinc finger protein 436-like (LOC114517204), mRNA	blastn	3779	75	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
18860972	18860972	PRJNA1046144_P_NODE_57675_length_234_cov_0.872727_g57380_i0	PRJNA1046144	57675	234	0.872727	2.04218118	root	1	Root_unresolved	Root_unresolved	60.2	1.25e-4	NTclustered	gi\|2917940701\|emb\|OZ237558.1\|	6108	g57380	i0	100	39.0555555555556	32	0	15	0	147	178	14434401	14434432	Anemonia sulcata genome assembly, chromosome: 4	blastn	9139	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
31078066	31078066	PRJNA1046144_P_NODE_43975_length_261_cov_2.671875_g43680_i0	PRJNA1046144	43975	261	2.671875	6.97359375	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	42.4	0.0447	NR	XP_012555619.1	6087	g43680	i0	28.4	0.931034482758621	81	50	93.1	3	17	259	43	115	XP_012555619.1 transmembrane protein 18 isoform X1 [Hydra vulgaris]	diamond	243	42.4	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);;