metadata: contig_metadata: 9 rows where bioproject = "PRJEB55122", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJEB55122", 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
3947478	3947478	PRJEB55122_P_NODE_4624_length_700_cov_5.655914_g4273_i0	PRJEB55122	4624	700	5.655914	39.591398	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	54.7	0.019	NTclustered	gi\|1191051559\|ref\|XM_021047964.1\|	2652724	g4273	i0	100	0.0414285714285714	29	0	4	0	199	227	3846	3818	PREDICTED: Exaiptasia diaphana monocarboxylate transporter 10 (LOC110242031), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
15423510	15423510	PRJEB55122_P_NODE_34313_length_176_cov_1.574803_g33916_i0	PRJEB55122	34313	176	1.574803	2.77165328	Acropora muricata	159855	Cnidaria	other_Eukaryota	270	3.77e-68	NTclustered	gi\|2784680719\|ref\|XM_067170670.1\|	159855	g33916	i0	94.318	23.0113636363636	176	10	100	0	1	176	734	559	PREDICTED: Acropora muricata uncharacterized protein (LOC136898106), mRNA	blastn	4050	270	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora muricata
27475961	27475961	PRJEB55122_P_NODE_28983_length_196_cov_1.061224_g28586_i0	PRJEB55122	28983	196	1.061224	2.07999904	Pocillopora meandrina	46732	Cnidaria	other_Eukaryota	136	4.319999999999999e-37	NR	CAH3152047.1	46732	g28586	i0	87.7	3.97959183673469	65	8	99.5	0	1	195	271	335	CAH3152047.1 unnamed protein product [Pocillopora meandrina]	diamond	780	136	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora meandrina
27563681	27563681	PRJEB55122_P_NODE_41644_length_164_cov_0.904348_g41247_i0	PRJEB55122	41644	164	0.904348	1.48313072	Metazoa	33208	Cnidaria	other_Eukaryota	64.7	9.17e-11	NR	XP_044170327.1	45264	g41247	i0	68.2	1.60975609756098	44	14	80.5	0	33	164	22	65	XP_044170327.1 uncharacterized protein LOC122954378 [Acropora millepora]	diamond	264	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27854830	27854830	PRJEB55122_P_NODE_43385_length_162_cov_0.920354_g42988_i0	PRJEB55122	43385	162	0.920354	1.49097348	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	50.8	1.78e-5	NR	XP_065070280.1	499914	g42988	i0	45.8	2.16666666666667	59	27	100	1	162	1	335	393	XP_065070280.1 uncharacterized protein LOC135695211 [Rhopilema esculentum]	diamond	351	50.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
28865185	28865185	PRJEB55122_P_NODE_42468_length_163_cov_0.912281_g42071_i0	PRJEB55122	42468	163	0.912281	1.48701803	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	43.1	0.00772	NR	CAB4037392.1	317549	g42071	i0	58.8	1.17791411042945	34	9	62.6	2	147	46	8	36	CAB4037392.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	192	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
29591061	29591061	PRJEB55122_P_NODE_23090_length_226_cov_1.073446_g22693_i0	PRJEB55122	23090	226	1.073446	2.42598796	Porites lobata	104759	Cnidaria	other_Eukaryota	72.4	1.04e-12	NR	CAH3149612.1	104759	g22693	i0	47.3	0.982300884955752	74	38	98.2	1	224	3	402	474	CAH3149612.1 unnamed protein product, partial [Porites lobata]	diamond	222	72.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
31322279	31322279	PRJEB55122_P_NODE_42415_length_163_cov_0.912281_g42018_i0	PRJEB55122	42415	163	0.912281	1.48701803	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.3	0.00254	NR	XP_002167403.2	6087	g42018	i0	95	30.5521472392638	20	1	36.8	0	60	1	96	115	XP_002167403.2 ferredoxin-2, mitochondrial [Hydra vulgaris]	diamond	4980	44.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32531476	32531476	PRJEB55122_P_NODE_33459_length_179_cov_1.561538_g33062_i0	PRJEB55122	33459	179	1.561538	2.79515302	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	42.7	0.0154	NR	CAB4040371.1	317549	g33062	i0	47.4	3.31843575418994	38	20	63.7	0	162	49	68	105	CAB4040371.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	594	42.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata

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