metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
27602185	27602185	PRJEB3181_P_NODE_6024_length_335_cov_6.776316_g5767_i0	PRJEB3181	6024	335	6.776316	22.7006586	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	129	2.2e-35	NR	XP_066914128.1	252671	g5767	i0	75	7.46865671641791	92	23	82.4	0	335	60	98	189	XP_066914128.1 small ribosomal subunit protein uS4 [Clytia hemisphaerica]	diamond	2502	129	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
30918139	30918139	PRJEB3181_P_NODE_8374_length_292_cov_4.766284_g8111_i0	PRJEB3181	8374	292	4.766284	13.91754928	Acropora millepora	45264	Cnidaria	other_Eukaryota	69.3	3.06e-11	NR	XP_029191226.1	45264	g8111	i0	49.3	0.708904109589041	69	33	70.9	1	292	86	579	645	XP_029191226.1 FACT complex subunit SSRP1-like [Acropora millepora]	diamond	207	69.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
31163908	31163908	PRJEB3181_S_NODE_13755_length_174_cov_2.503597_g13462_i0	PRJEB3181	13755	174	2.503597	4.35625878	Opisthokonta	33154	Cnidaria	other_Eukaryota	75.1	3.73e-15	NR	NP_001274705.1	6087	g13462	i0	69.6	4.70689655172414	46	14	79.3	0	174	37	120	165	NP_001274705.1 uncharacterized protein LOC100198049 [Hydra vulgaris]	diamond	819	75.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
31929782	31929782	PRJEB3181_P_NODE_10277_length_265_cov_1.722222_g10013_i0	PRJEB3181	10277	265	1.722222	4.5638883	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	67.8	5.33e-12	NR	XP_065064962.1	499914	g10013	i0	49.2	0.713207547169811	63	32	71.3	0	1	189	77	139	XP_065064962.1 coactosin-like protein [Rhopilema esculentum]	diamond	189	67.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
32183093	32183093	PRJEB3181_P_NODE_5998_length_336_cov_2.888525_g5741_i0	PRJEB3181	5998	336	2.888525	9.705444	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	50.1	2.04e-4	NR	PFX19476.1	50429	g5741	i0	61	0.366071428571429	41	16	36.6	0	196	74	195	235	PFX19476.1 Zinc finger MYND domain-containing protein 10 [Stylophora pistillata]	diamond	123	50.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
32208127	32208127	PRJEB3181_P_NODE_25038_length_161_cov_1.853846_g24773_i0	PRJEB3181	25038	161	1.853846	2.98469206	Scleractinia	6125	Cnidaria	other_Eukaryota	64.3	2.3e-10	NR	XP_029213699.1	45264	g24773	i0	52.8	8.88819875776398	53	25	98.8	0	3	161	235	287	XP_029213699.1 cytochrome c1, heme protein, mitochondrial-like [Acropora millepora]	diamond	1431	64.7	0.993817619783617	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
32239955	32239955	PRJEB3181_P_NODE_8978_length_283_cov_6.130952_g8714_i0	PRJEB3181	8978	283	6.130952	17.35059416	Metazoa	33208	Cnidaria	other_Eukaryota	99	3.1999999999999998e-24	NR	XP_029203073.1	45264	g8714	i0	85	7.18727915194346	60	9	63.6	0	20	199	74	133	XP_029203073.1 ubiquitin-like protein FUBI [Acropora millepora]	diamond	2034	100	0.99	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
32681822	32681822	PRJEB3181_P_NODE_17680_length_197_cov_4.042169_g17416_i0	PRJEB3181	17680	197	4.042169	7.96307293	Nematostella	45350	Cnidaria	other_Eukaryota	42	0.00438	NR	EDO49223.1	45351	g17416	i0	41.8	1.6751269035533	55	31	83.8	1	23	187	2	55	EDO49223.1 predicted protein [Nematostella vectensis]	diamond	330	42	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis

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