metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
5850492	5850492	PRJNA770826_P_NODE_5225_length_372_cov_2.034056_g5054_i0	PRJNA770826	5225	372	2.034056	7.56668832	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	364	4e-96	NTclustered	gi\|1603783844\|ref\|XM_028539416.1\|	151771	g5054	i0	86.31	92.1209677419355	336	44	90	2	1	335	454	120	PREDICTED: Dendronephthya gigantea actin, cytoplasmic (LOC114519299), transcript variant X2, mRNA	blastn	34269	364	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
6310755	6310755	PRJNA770826_P_NODE_35525_length_165_cov_0.896552_g35354_i0	PRJNA770826	35525	165	0.896552	1.4793108	Opisthokonta	33154	Cnidaria	other_Eukaryota	121	3.73e-23	NTclustered	gi\|2744884259\|ref\|XM_065808250.1\|	6087	g35354	i0	80.606	14.9454545454545	165	24	98	7	1	161	354	514	PREDICTED: Hydra vulgaris T-complex protein 1 subunit zeta (LOC100211398), transcript variant X2, mRNA	blastn	2466	121	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
7125634	7125634	PRJNA770826_P_NODE_32326_length_166_cov_0.888889_g32155_i0	PRJNA770826	32326	166	0.888889	1.47555574	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	165	1.7100000000000002e-36	NTclustered	gi\|1619698961\|ref\|XM_021060755.2\|	2652724	g32155	i0	87.162	85.8313253012048	148	13	87	5	3	147	380	236	PREDICTED: Exaiptasia diaphana actin, cytoplasmic (LOC110253803), mRNA	blastn	14248	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
8400098	8400098	PRJNA770826_P_NODE_23667_length_169_cov_0.866667_g23496_i0	PRJNA770826	23667	169	0.866667	1.46466723	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	67.6	5.04e-7	NTclustered	gi\|1270082747\|ref\|XM_022948974.1\|	50429	g23496	i0	100	0.420118343195266	36	0	21	0	30	65	1118	1153	PREDICTED: Stylophora pistillata mitogen-activated protein kinase 6-like (LOC111341927), mRNA	blastn	71	67.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
12226539	12226539	PRJNA770826_P_NODE_13290_length_221_cov_0.906977_g13119_i0	PRJNA770826	13290	221	0.906977	2.00441917	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	171	5.18e-38	NTclustered	gi\|1778058979\|ref\|XM_031710909.1\|	6105	g13119	i0	84.091	18.2126696832579	176	28	80	0	3	178	314	139	PREDICTED: Actinia tenebrosa ADP-ribosylation factor 1 (LOC116301791), transcript variant X2, mRNA	blastn	4025	171	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
13500592	13500592	PRJNA770826_P_NODE_15951_length_202_cov_2.267974_g15780_i0	PRJNA770826	15951	202	2.267974	4.58130748	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	159	1.01e-34	NTclustered	gi\|2518992779\|ref\|XM_057447549.1\|	13093	g15780	i0	84.81	10.6138613861386	158	24	78	0	2	159	873	1030	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130640934 (LOC130640934), mRNA	blastn	2144	159	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
13500621	13500621	PRJNA770826_P_NODE_19791_length_182_cov_1.466165_g19620_i0	PRJNA770826	19791	182	1.466165	2.6684203	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	209	8.68e-50	NTclustered	gi\|1778059315\|ref\|XM_031711087.1\|	6105	g19620	i0	87.709	97.5164835164835	179	22	98	0	2	180	585	763	PREDICTED: Actinia tenebrosa actin, cytoplasmic-like (LOC116301916), mRNA	blastn	17748	209	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
13500656	13500656	PRJNA770826_P_NODE_30331_length_167_cov_0.881356_g30160_i0	PRJNA770826	30331	167	0.881356	1.47186452	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	56.5	0.001	NTclustered	gi\|2917940752\|emb\|OZ237570.1\|	6108	g30160	i0	94.444	0.215568862275449	36	2	22	0	105	140	304773	304808	Anemonia sulcata genome assembly, chromosome: 16	blastn	36	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
21149477	21149477	PRJNA770826_P_NODE_25137_length_169_cov_0.866667_g24966_i0	PRJNA770826	25137	169	0.866667	1.46466723	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	135	1.3600000000000002e-27	NTclustered	gi\|2782930168\|ref\|XM_067073905.1\|	252671	g24966	i0	93.407	49.5029585798817	91	6	54	0	6	96	1197	1287	PREDICTED: Clytia hemisphaerica actin, non-muscle 6.2-like (LOC136817581), mRNA	blastn	8366	135	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
21149488	21149488	PRJNA770826_P_NODE_2837_length_516_cov_3.875803_g2667_i0	PRJNA770826	2837	516	3.875803	19.99914348	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	263	2.14e-65	NTclustered	gi\|1270070915\|ref\|XM_022942603.1\|	50429	g2667	i0	77.506	26.312015503876	449	94	86	7	27	472	623	179	PREDICTED: Stylophora pistillata caltractin (LOC111336494), mRNA	blastn	13577	263	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
23699904	23699904	PRJNA770826_P_NODE_36959_length_164_cov_0.904348_g36788_i0	PRJNA770826	36959	164	0.904348	1.48313072	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	56.5	0.001	NTclustered	gi\|1603818482\|ref\|XM_028557847.1\|	151771	g36788	i0	90.476	0.25609756097561	42	4	26	0	98	139	974	933	PREDICTED: Dendronephthya gigantea collagen alpha-1(II) chain-like (LOC114536502), mRNA	blastn	42	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
23699930	23699930	PRJNA770826_P_NODE_4599_length_401_cov_2.363636_g4428_i0	PRJNA770826	4599	401	2.363636	9.47818036	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	309	2.07e-79	NTclustered	gi\|2518992779\|ref\|XM_057447549.1\|	13093	g4428	i0	81.967	19.4239401496259	366	65	91	1	36	401	581	945	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130640934 (LOC130640934), mRNA	blastn	7789	309	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
24973592	24973592	PRJNA770826_P_NODE_5980_length_343_cov_1.976190_g5809_i0	PRJNA770826	5980	343	1.97619	6.7783317	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	104	8.83e-18	NTclustered	gi\|2744834657\|ref\|XM_002163363.5\|	6087	g5809	i0	88.506	1.55685131195335	87	9	25	1	227	312	386	300	PREDICTED: Hydra vulgaris ubiquitin-like FUBI-ribosomal protein eS30 fusion protein (LOC100211988), mRNA	blastn	534	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
25433373	25433373	PRJNA770826_P_NODE_28060_length_167_cov_1.322034_g27889_i0	PRJNA770826	28060	167	1.322034	2.20779678	Metazoa	33208	Cnidaria	other_Eukaryota	139	1.05e-28	NTclustered	gi\|2518975374\|ref\|XM_057438511.1\|	13093	g27889	i0	82.692	5.65868263473054	156	27	93	0	7	162	327	172	PREDICTED: Hydractinia symbiolongicarpus dynein light chain 2, cytoplasmic (LOC130623008), mRNA	blastn	945	139	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus

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