metadata: contig_metadata: 10 rows where bioproject = "PRJNA695273" and tax

10 rows where bioproject = "PRJNA695273" 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
1954496	1954496	PRJNA695273_P_NODE_59322_length_355_cov_1.464539_g58564_i0	PRJNA695273	59322	355	1.464539	5.19911345	Margelopsis haeckelii	2876032	Cnidaria	other_Eukaryota	300	1.09e-76	NTclustered	gi\|2095489123\|gb\|OK142735.1\|	2876032	g58564	i0	82.123	100.633802816901	358	56	100	8	1	355	943	1295	Margelopsis haeckelii strain Ost2019 large subunit ribosomal RNA gene, partial sequence	blastn	35725	300	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Margelopsidae	Margelopsis	Margelopsis haeckelii
2458766	2458766	PRJNA695273_P_NODE_91762_length_289_cov_1.199074_g91004_i0	PRJNA695273	91762	289	1.199074	3.46532386	Metazoa	33208	Cnidaria	other_Eukaryota	52.8	0.027	NTclustered	gi\|2917940701\|emb\|OZ237558.1\|	6108	g91004	i0	96.774	0.806228373702422	31	1	11	0	105	135	11052293	11052323	Anemonia sulcata genome assembly, chromosome: 4	blastn	233	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
18529571	18529571	PRJNA695273_P_NODE_17875_length_669_cov_4.394295_g17129_i0	PRJNA695273	17875	669	4.394295	29.39783355	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	284	4.93e-94	NR	XP_031562332.1	6105	g17129	i0	62.8	21.1973094170404	215	80	96.4	0	24	668	1	215	XP_031562332.1 60S ribosomal protein L10a-like [Actinia tenebrosa]	diamond	14181	285	0.996491228070175	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
23631131	23631131	PRJNA695273_P_NODE_50179_length_383_cov_5.548387_g49421_i0	PRJNA695273	50179	383	5.548387	21.25032221	Acropora millepora	45264	Cnidaria	other_Eukaryota	165	8.4e-50	NR	XP_044172593.1	45264	g49421	i0	73.6	8.45953002610966	106	28	83	0	33	350	40	145	XP_044172593.1 60S ribosomal protein L44-like [Acropora millepora]	diamond	3240	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27872335	27872335	PRJNA695273_P_NODE_41625_length_420_cov_2.158501_g40867_i0	PRJNA695273	41625	420	2.158501	9.0657042	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	140	2.65e-39	NR	XP_002166736.1	6087	g40867	i0	57	2.45	114	46	81.4	1	420	79	66	176	XP_002166736.1 large ribosomal subunit protein eL20 isoform X1 [Hydra vulgaris]	diamond	1029	140	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29872827	29872827	PRJNA695273_P_NODE_24331_length_562_cov_4.773006_g23579_i0	PRJNA695273	24331	562	4.773006	26.82429372	Opisthokonta	33154	Cnidaria	other_Eukaryota	209	1.33e-64	NR	XP_057309555.1	13093	g23579	i0	68.6	11.9519572953737	172	46	89.7	2	508	5	10	177	XP_057309555.1 60S ribosomal protein L7-like [Hydractinia symbiolongicarpus]	diamond	6717	209	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
30789026	30789026	PRJNA695273_P_NODE_21674_length_599_cov_7.965779_g20923_i0	PRJNA695273	21674	599	7.965779	47.71501621	Metazoa	33208	Cnidaria	other_Eukaryota	214	4.1e-67	NR	XP_031560243.1	6105	g20923	i0	60.6	16.2971619365609	180	70	90.2	1	3	542	10	188	XP_031560243.1 40S ribosomal protein S7-like [Actinia tenebrosa]	diamond	9762	216	0.990740740740741	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
31599856	31599856	PRJNA695273_P_NODE_91596_length_289_cov_1.416667_g90838_i0	PRJNA695273	91596	289	1.416667	4.09416763	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	50.4	1.34e-4	NR	XP_066029081.1	203993	g90838	i0	35.4	2.00346020761246	99	55	96.5	4	8	286	3954	4049	XP_066029081.1 sacsin-like isoform X2 [Pocillopora verrucosa]	diamond	579	50.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
31642394	31642394	PRJNA695273_P_NODE_43696_length_409_cov_4.851190_g42938_i0	PRJNA695273	43696	409	4.85119	19.8413671	Pocilloporidae	46729	Cnidaria	other_Eukaryota	148	3.09e-43	NR	XP_027048772.1	46731	g42938	i0	64.9	3.25672371638142	111	39	81.4	0	34	366	3	113	XP_027048772.1 60S ribosomal protein L35a-like [Pocillopora damicornis]	diamond	1332	148	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
32401984	32401984	PRJNA695273_P_NODE_142559_length_246_cov_0.890173_g141801_i0	PRJNA695273	142559	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	80.5	1.87e-15	NR	XP_020604892.1	48498	g141801	i0	53.2	6.6219512195122	77	35	92.7	1	245	18	297	373	XP_020604892.1 cytochrome P450 4c21-like [Orbicella faveolata]	diamond	1629	80.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata

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