metadata: contig_metadata: 7 rows where bioproject = "PRJNA682774" and tax

7 rows where bioproject = "PRJNA682774" 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
26650424	26650424	PRJNA682774_P_NODE_3521_length_253_cov_0.866667_g3492_i0	PRJNA682774	3521	253	0.866667	2.19266751	Metazoa	33208	Cnidaria	other_Eukaryota	92.8	8.11e-21	NR	XP_031572380.1	6105	g3492	i0	52	15.5098814229249	98	30	99.6	3	253	2	18	112	XP_031572380.1 N-terminal Xaa-Pro-Lys N-methyltransferase 1-B-like [Actinia tenebrosa]	diamond	3924	93.6	0.991452991452991	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
27935030	27935030	PRJNA682774_P_NODE_5325_length_242_cov_1.473373_g5296_i0	PRJNA682774	5325	242	1.473373	3.56556266	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	70.5	2.15e-13	NR	XP_027046022.1	46731	g5296	i0	58.8	1.66115702479339	68	19	84.3	2	205	2	7	65	XP_027046022.1 protein DD3-3-like [Pocillopora damicornis]	diamond	402	70.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
28104318	28104318	PRJNA682774_P_NODE_4765_length_245_cov_1.866279_g4736_i0	PRJNA682774	4765	245	1.866279	4.57238355	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	94.7	3.95e-21	NR	XP_065651848.1	6087	g4736	i0	51.9	14.8530612244898	81	39	99.2	0	244	2	158	238	XP_065651848.1 large ribosomal subunit protein uL10 [Hydra vulgaris]	diamond	3639	94.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28218886	28218886	PRJNA682774_P_NODE_5026_length_244_cov_0.912281_g4997_i0	PRJNA682774	5026	244	0.912281	2.22596564	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	122	4.04e-33	NR	XP_065060436.1	499914	g4997	i0	71.3	2.93852459016393	80	23	98.4	0	242	3	63	142	XP_065060436.1 large ribosomal subunit protein uL22 [Rhopilema esculentum]	diamond	717	122	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
31187660	31187660	PRJNA682774_P_NODE_4055_length_249_cov_0.886364_g4026_i0	PRJNA682774	4055	249	0.886364	2.20704636	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	105	1.7e-24	NR	XP_057314243.1	13093	g4026	i0	59.3	5.6144578313253	81	33	97.6	0	247	5	139	219	XP_057314243.1 probable phosphoglycerate kinase [Hydractinia symbiolongicarpus]	diamond	1398	105	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
31927081	31927081	PRJNA682774_P_NODE_5457_length_242_cov_0.923077_g5428_i0	PRJNA682774	5457	242	0.923077	2.23384634	Cnidaria	6073	Cnidaria	other_Eukaryota	83.2	2.03e-16	NR	XP_066916646.1	252671	g5428	i0	58.3	11.5413223140496	60	25	74.4	0	241	62	328	387	XP_066916646.1 E3 ubiquitin-protein ligase arih1-like [Clytia hemisphaerica]	diamond	2793	83.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
32453626	32453626	PRJNA682774_P_NODE_1939_length_322_cov_2.481928_g1910_i0	PRJNA682774	1939	322	2.481928	7.99180816	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	109	2.99e-28	NR	EDO33935.1	45351	g1910	i0	63.8	1.95652173913043	105	27	97.8	1	320	6	3	96	EDO33935.1 predicted protein [Nematostella vectensis]	diamond	630	109	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis

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