metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA896554" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA896554" 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
2147391	2147391	PRJNA896554_P_NODE_70502_length_452_cov_2.015831_g62962_i0	PRJNA896554	70502	452	2.015831	9.11155612	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	182	5.35e-41	NTclustered	gi\|2744824236\|ref\|XM_047289062.2\|	6087	g62962	i0	76.829	20.9004424778761	328	72	72	4	122	447	821	496	PREDICTED: Hydra vulgaris serine/threonine-protein phosphatase 2A catalytic subunit beta isoform (LOC100201603), transcript variant X1, mRNA	blastn	9447	182	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
8523755	8523755	PRJNA896554_P_NODE_169987_length_243_cov_0.905882_g162447_i0	PRJNA896554	169987	243	0.905882	2.20129326	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	71.3	6.05e-8	NTclustered	gi\|2518976843\|ref\|XM_057439239.1\|	13093	g162447	i0	90.741	0.222222222222222	54	3	22	2	4	56	247	195	PREDICTED: Hydractinia symbiolongicarpus AP-2 complex subunit beta-like (LOC130623727), mRNA	blastn	54	71.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
10172416	10172416	PRJNA896554_P_NODE_64128_length_500_cov_1.648712_g56594_i0	PRJNA896554	64128	500	1.648712	8.24356	Metazoa	33208	Cnidaria	other_Eukaryota	58.4	0.001	NTclustered	gi\|2917940687\|emb\|OZ237555.1\|	6108	g56594	i0	100	5.86	31	0	6	0	103	133	19663362	19663332	Anemonia sulcata genome assembly, chromosome: 1	blastn	2930	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
11447487	11447487	PRJNA896554_P_NODE_137289_length_266_cov_1.595855_g129749_i0	PRJNA896554	137289	266	1.595855	4.2449743	Acropora	6127	Cnidaria	other_Eukaryota	52.8	0.024	NTclustered	gi\|2113956199\|ref\|XM_029328078.2\|	45264	g129749	i0	100	0.315789473684211	28	0	11	0	2	29	444	417	PREDICTED: Acropora millepora ATP-dependent RNA helicase DDX51-like (LOC114952007), mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
16173876	16173876	PRJNA896554_P_NODE_179013_length_198_cov_4.280000_g171473_i0	PRJNA896554	179013	198	4.28	8.4744	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	93.5	1.01e-14	NTclustered	gi\|2782916312\|ref\|XM_067071568.1\|	252671	g171473	i0	83.019	2.59090909090909	106	14	53	4	1	104	1028	1131	PREDICTED: Clytia hemisphaerica T-complex protein 1 subunit epsilon-like (LOC136815125), mRNA	blastn	513	93.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica

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