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

10 rows where bioproject = "PRJNA1158727" 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
11782949	11782949	PRJNA1158727_P_NODE_158610_length_242_cov_2.337278_g151148_i0	PRJNA1158727	158610	242	2.337278	5.65621276	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	65.8	2.8e-6	NTclustered	gi\|2917940703\|emb\|OZ237559.1\|	6108	g151148	i0	100	1.63636363636364	35	0	14	0	105	139	16343799	16343833	Anemonia sulcata genome assembly, chromosome: 5	blastn	396	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
24530082	24530082	PRJNA1158727_P_NODE_148020_length_246_cov_1.543353_g140558_i0	PRJNA1158727	148020	246	1.543353	3.79664838	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.022	NTclustered	gi\|2917940714\|emb\|OZ237561.1\|	6108	g140558	i0	91.892	0.150406504065041	37	3	15	0	27	63	6727886	6727922	Anemonia sulcata genome assembly, chromosome: 7	blastn	37	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
26996226	26996226	PRJNA1158727_P_NODE_95562_length_301_cov_3.359649_g88101_i0	PRJNA1158727	95562	301	3.359649	10.11254349	Metazoa	33208	Cnidaria	other_Eukaryota	113	5.05e-30	NR	EDO33935.1	45351	g88101	i0	65.7	4.94352159468439	99	33	98.7	1	4	300	8	105	EDO33935.1 predicted protein [Nematostella vectensis]	diamond	1488	114	0.991228070175439	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
29187953	29187953	PRJNA1158727_P_NODE_148069_length_246_cov_1.450867_g140607_i0	PRJNA1158727	148069	246	1.450867	3.56913282	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	64.7	1.89e-11	NR	EDO32471.1	45351	g140607	i0	54.4	0.829268292682927	68	29	80.5	1	245	48	21	88	EDO32471.1 predicted protein, partial [Nematostella vectensis]	diamond	204	64.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
29787464	29787464	PRJNA1158727_P_NODE_114131_length_274_cov_1.532338_g106670_i0	PRJNA1158727	114131	274	1.532338	4.19860612	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	91.7	1.54e-21	NR	EDO33935.1	45351	g106670	i0	63.3	1.93795620437956	90	22	98.5	1	3	272	5	83	EDO33935.1 predicted protein [Nematostella vectensis]	diamond	531	91.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30325264	30325264	PRJNA1158727_P_NODE_146012_length_247_cov_0.885057_g138550_i0	PRJNA1158727	146012	247	0.885057	2.18609079	Porites lobata	104759	Cnidaria	other_Eukaryota	42.4	0.027	NR	CAH3152690.1	104759	g138550	i0	43.6	0.473684210526316	39	22	47.4	0	127	243	63	101	CAH3152690.1 unnamed protein product [Porites lobata]	diamond	117	42.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
31070903	31070903	PRJNA1158727_P_NODE_149735_length_246_cov_0.890173_g142273_i0	PRJNA1158727	149735	246	0.890173	2.18982558	Scleractinia	6125	Cnidaria	other_Eukaryota	94	1.86e-22	NR	XP_027036291.1	46731	g142273	i0	81.4	9.53658536585366	59	11	72	0	34	210	74	132	XP_027036291.1 ubiquitin-like protein FUBI [Pocillopora damicornis]	diamond	2346	94	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
31177521	31177521	PRJNA1158727_P_NODE_81135_length_336_cov_1.463878_g73674_i0	PRJNA1158727	81135	336	1.463878	4.91863008	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	123	3.05e-33	NR	XP_046849006.1	2897299	g73674	i0	61.8	5.58035714285714	102	39	91.1	0	23	328	1	102	XP_046849006.1 60S ribosomal protein L24-like [Xenia sp. Carnegie-2017]	diamond	1875	123	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
32019567	32019567	PRJNA1158727_P_NODE_142038_length_248_cov_2.925714_g134576_i0	PRJNA1158727	142038	248	2.925714	7.25577072	Scleractinia	6125	Cnidaria	other_Eukaryota	54.7	2.35e-6	NR	XP_020632591.1	48498	g134576	i0	49	2.56451612903226	49	25	59.3	0	216	70	296	344	XP_020632591.1 apoptosis-inducing factor 2-like isoform X1 [Orbicella faveolata]	diamond	636	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
32336189	32336189	PRJNA1158727_P_NODE_162499_length_241_cov_0.916667_g155037_i0	PRJNA1158727	162499	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	45.1	0.00535	NR	RMX53403.1	46731	g155037	i0	57.1	3.46058091286307	35	10	43.6	3	135	239	475	504	RMX53403.1 hypothetical protein pdam_00014232 [Pocillopora damicornis]	diamond	834	45.4	0.993392070484582	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis

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