metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA703759" 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
28262329	28262329	PRJNA703759_P_NODE_48986_length_243_cov_0.917647_g48510_i0	PRJNA703759	48986	243	0.917647	2.22988221	Metazoa	33208	Cnidaria	other_Eukaryota	92.8	8.78e-20	NR	XP_065072197.1	499914	g48510	i0	62.5	60.2469135802469	80	7	98.8	1	242	3	117	173	XP_065072197.1 kinesin-II 95 kDa subunit-like [Rhopilema esculentum]	diamond	14640	93.6	0.991452991452991	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
28535744	28535744	PRJNA703759_P_NODE_46867_length_245_cov_0.901163_g46391_i0	PRJNA703759	46867	245	0.901163	2.20784935	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	55.8	9.09e-7	NR	XP_066930093.1	252671	g46391	i0	33.3	2.9265306122449	75	29	91.8	1	3	227	458	511	XP_066930093.1 SH2B adapter protein 1-like [Clytia hemisphaerica]	diamond	717	55.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
28693604	28693604	PRJNA703759_P_NODE_20387_length_307_cov_2.547009_g19911_i0	PRJNA703759	20387	307	2.547009	7.81931763	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	44.7	0.00278	NR	CAB4037651.1	317549	g19911	i0	39.6	0.517915309446254	53	26	45.9	2	162	302	7	59	CAB4037651.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	159	44.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
29072490	29072490	PRJNA703759_P_NODE_48008_length_244_cov_0.912281_g47532_i0	PRJNA703759	48008	244	0.912281	2.22596564	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	47.4	9.05e-4	NR	XP_065671281.1	6087	g47532	i0	35.9	1.91803278688525	78	40	83.6	3	31	234	45	122	XP_065671281.1 uncharacterized protein LOC105845042 isoform X2 [Hydra vulgaris]	diamond	468	47.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29872860	29872860	PRJNA703759_P_NODE_34811_length_253_cov_0.866667_g34335_i0	PRJNA703759	34811	253	0.866667	2.19266751	root	1	Root_unresolved	Root_unresolved	49.7	1.58e-4	NR	PFX15780.1	50429	g34335	i0	43.8	1.68379446640316	48	27	56.9	0	53	196	415	462	PFX15780.1 Collagen alpha-1(XXVII) chain B [Stylophora pistillata]	diamond	426	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
30430737	30430737	PRJNA703759_P_NODE_29753_length_268_cov_1.148718_g29277_i0	PRJNA703759	29753	268	1.148718	3.07856424	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	51.2	4.52e-5	NR	XP_066936139.1	252671	g29277	i0	81.5	0.604477611940298	27	5	30.2	0	83	3	258	284	XP_066936139.1 methylglutaconyl-CoA hydratase, mitochondrial-like [Clytia hemisphaerica]	diamond	162	51.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
31093856	31093856	PRJNA703759_P_NODE_50915_length_242_cov_0.923077_g50439_i0	PRJNA703759	50915	242	0.923077	2.23384634	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	46.2	0.00226	NR	XP_065066223.1	499914	g50439	i0	37.2	2.36776859504132	78	43	91.7	2	238	17	1192	1267	XP_065066223.1 phospholipid-transporting ATPase ABCA3-like [Rhopilema esculentum]	diamond	573	46.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
31262996	31262996	PRJNA703759_P_NODE_31135_length_263_cov_1.231579_g30659_i0	PRJNA703759	31135	263	1.231579	3.23905277	Metazoa	33208	Cnidaria	other_Eukaryota	81.3	1.32e-15	NR	XP_047144757.1	6087	g30659	i0	43.7	4.02661596958175	87	49	99.2	0	1	261	35	121	XP_047144757.1 uncharacterized protein LOC124818242 [Hydra vulgaris]	diamond	1059	82	0.991463414634146	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32528669	32528669	PRJNA703759_P_NODE_20799_length_305_cov_1.413793_g20323_i0	PRJNA703759	20799	305	1.413793	4.31206865	Metazoa	33208	Cnidaria	other_Eukaryota	58.5	1.37e-7	NR	CAH3174767.1	104759	g20323	i0	34.3	3.89508196721311	99	63	97.4	1	3	299	156	252	CAH3174767.1 unnamed protein product [Porites lobata]	diamond	1188	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata

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