metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA981359" 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
27279249	27279249	PRJNA981359_S_NODE_14323_length_388_cov_2.476190_g14223_i0	PRJNA981359	14323	388	2.47619	9.6076172	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	46.6	0.0077	NR	PFX14780.1	50429	g14223	i0	31.7	0.487113402061856	63	42	48.7	1	282	94	152	213	PFX14780.1 RNA-directed DNA polymerase from mobile element jockey [Stylophora pistillata]	diamond	189	46.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
28289475	28289475	PRJNA981359_S_NODE_46746_length_287_cov_3.285047_g46646_i0	PRJNA981359	46746	287	3.285047	9.42808489	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	43.1	0.0481	NR	KXJ07861.1	2652724	g46646	i0	41.3	1.31707317073171	63	33	61.7	1	215	39	362	424	KXJ07861.1 hypothetical protein AC249_AIPGENE9596 [Exaiptasia diaphana]	diamond	378	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
28479115	28479115	PRJNA981359_S_NODE_63966_length_253_cov_3.883333_g63866_i0	PRJNA981359	63966	253	3.883333	9.82483249	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	51.2	4.11e-5	NR	XP_065650966.1	6087	g63866	i0	44.6	3.08300395256917	65	36	77.1	0	12	206	309	373	XP_065650966.1 uncharacterized protein LOC136079171 [Hydra vulgaris]	diamond	780	51.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29047524	29047524	PRJNA981359_S_NODE_18628_length_366_cov_2.109215_g18528_i0	PRJNA981359	18628	366	2.109215	7.7197269	Acropora millepora	45264	Cnidaria	other_Eukaryota	71.6	1.05e-11	NR	XP_044162836.1	45264	g18528	i0	46.2	0.639344262295082	78	38	60.7	1	303	82	350	427	XP_044162836.1 putative nuclease HARBI1 [Acropora millepora]	diamond	234	71.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
29583866	29583866	PRJNA981359_S_NODE_41930_length_298_cov_1.537778_g41830_i0	PRJNA981359	41930	298	1.537778	4.58257844	Porites lobata	104759	Cnidaria	other_Eukaryota	43.1	0.0434	NR	CAH3034171.1	104759	g41830	i0	35.3	0.513422818791946	51	33	51.3	0	276	124	136	186	CAH3034171.1 unnamed protein product, partial [Porites lobata]	diamond	153	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
30917195	30917195	PRJNA981359_S_NODE_34894_length_314_cov_5.182573_g34794_i0	PRJNA981359	34894	314	5.182573	16.27327922	Anthozoa	6101	Cnidaria	other_Eukaryota	45.4	0.00953	NR	XP_044168140.1	45264	g34794	i0	55	4.88216560509554	40	17	37.3	1	1	117	336	375	XP_044168140.1 uncharacterized protein LOC114974227 [Acropora millepora]	diamond	1533	45.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
31290110	31290110	PRJNA981359_S_NODE_18195_length_368_cov_2.098305_g18095_i0	PRJNA981359	18195	368	2.098305	7.7217624	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	87	2.61e-18	NR	XP_065658445.1	6087	g18095	i0	65.6	0.497282608695652	61	21	49.7	0	2	184	146	206	XP_065658445.1 histone-lysine N-methyltransferase SETMAR-like [Hydra vulgaris]	diamond	183	87	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
31448436	31448436	PRJNA981359_S_NODE_6136_length_473_cov_2.700000_g6037_i0	PRJNA981359	6136	473	2.7	12.771	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	66.2	1.37e-10	NR	XP_028400485.1	151771	g6037	i0	33.6	0.754756871035941	119	79	75.5	0	471	115	10	128	XP_028400485.1 intraflagellar transport protein 20 homolog [Dendronephthya gigantea]	diamond	357	66.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
31638052	31638052	PRJNA981359_S_NODE_68876_length_247_cov_2.241379_g68776_i0	PRJNA981359	68876	247	2.241379	5.53620613	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	50.4	7.58e-5	NR	CAB3978258.1	317549	g68776	i0	35.5	3.01214574898785	62	40	75.3	0	237	52	602	663	CAB3978258.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	744	50.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31644002	31644002	PRJNA981359_S_NODE_71916_length_243_cov_3.976471_g71816_i0	PRJNA981359	71916	243	3.976471	9.66282453	root	1	Root_unresolved	Root_unresolved	66.6	1.43e-10	NR	EDO33944.1	45351	g71816	i0	59.6	1.28395061728395	52	21	64.2	0	86	241	292	343	EDO33944.1 predicted protein [Nematostella vectensis]	diamond	312	66.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
32492568	32492568	PRJNA981359_S_NODE_47819_length_285_cov_2.207547_g47719_i0	PRJNA981359	47819	285	2.207547	6.29150895	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	45.8	0.00529	NR	XP_066926116.1	252671	g47719	i0	35.4	0.684210526315789	65	41	67.4	1	43	234	162	226	XP_066926116.1 uncharacterized protein [Clytia hemisphaerica]	diamond	195	45.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
32687527	32687527	PRJNA981359_S_NODE_39100_length_304_cov_3.038961_g39000_i0	PRJNA981359	39100	304	3.038961	9.23844144	root	1	Root_unresolved	Root_unresolved	67	1.86e-10	NR	CAB4015517.1	317549	g39000	i0	37.8	6.91776315789474	90	55	87.8	1	32	298	96	185	CAB4015517.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	2103	67	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata

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