metadata: contig_metadata: 11 rows where bioproject = "PRJNA1093008", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA1093008", tax_clade = "Opisthokonta" 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
198774	198774	PRJNA1093008_S_NODE_70121_length_264_cov_2.638743_g69794_i0	PRJNA1093008	70121	264	2.638743	6.96628152	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	52.8	0.024	NTclustered	gi\|2744791770\|ref\|XR_010645119.1\|	6087	g69794	i0	96.875	0.121212121212121	32	0	12	1	1	32	223	193	PREDICTED: Hydra vulgaris uncharacterized LOC124818844 (LOC124818844), ncRNA	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
6576631	6576631	PRJNA1093008_S_NODE_64666_length_271_cov_14.803030_g64339_i0	PRJNA1093008	64666	271	14.80303	40.1162113	Nemalecium lighti	1769417	Cnidaria	other_Eukaryota	128	4.01e-25	NTclustered	gi\|984932204\|gb\|KT757146.1\|	1769417	g64339	i0	89.216	13.4243542435424	102	11	38	0	167	268	2251	2352	Nemalecium lighti voucher LEM m3x S17 large subunit 28S ribosomal RNA gene, partial sequence	blastn	3638	128	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Haleciidae	Nemalecium	Nemalecium lighti
8672305	8672305	PRJNA1093008_S_NODE_62727_length_274_cov_2.059701_g62400_i0	PRJNA1093008	62727	274	2.059701	5.64358074	Metazoa	33208	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940712\|emb\|OZ237560.1\|	6108	g62400	i0	100	6.28102189781022	30	0	11	0	37	66	1512231	1512202	Anemonia sulcata genome assembly, chromosome: 6	blastn	1721	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
9126327	9126327	PRJNA1093008_S_NODE_53388_length_288_cov_1.790698_g53061_i0	PRJNA1093008	53388	288	1.790698	5.15721024	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	52.8	0.027	NTclustered	gi\|2751537736\|ref\|XM_066164102.1\|	203993	g53061	i0	100	0.0972222222222222	28	0	10	0	119	146	1638	1611	PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC136279815), transcript variant X3, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
16775904	16775904	PRJNA1093008_S_NODE_73794_length_260_cov_1.235294_g73467_i0	PRJNA1093008	73794	260	1.235294	3.2117644	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	89	1.49e-19	NR	XP_028402666.1	151771	g73467	i0	57.5	3.71538461538462	80	32	90	2	241	8	128	207	XP_028402666.1 probable bifunctional dTTP/UTP pyrophosphatase/methyltransferase protein [Dendronephthya gigantea]	diamond	966	89	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
29088766	29088766	PRJNA1093008_S_NODE_92728_length_243_cov_1.358824_g92401_i0	PRJNA1093008	92728	243	1.358824	3.30194232	Porites evermanni	104178	Cnidaria	other_Eukaryota	45.4	0.00392	NR	CAH3165213.1	104178	g92401	i0	30.9	0.839506172839506	68	47	84	0	206	3	176	243	CAH3165213.1 unnamed protein product, partial [Porites evermanni]	diamond	204	45.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
29878180	29878180	PRJNA1093008_S_NODE_99311_length_231_cov_2.215190_g98984_i0	PRJNA1093008	99311	231	2.21519	5.1170889	Acropora digitifera	70779	Cnidaria	other_Eukaryota	74.7	1.75e-13	NR	XP_015753150.1	70779	g98984	i0	83.3	1.03896103896104	42	6	54.5	1	34	159	273	313	XP_015753150.1 PREDICTED: G-protein-signaling modulator 2-like [Acropora digitifera]	diamond	240	74.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
30090403	30090403	PRJNA1093008_S_NODE_48152_length_297_cov_2.142857_g47825_i0	PRJNA1093008	48152	297	2.142857	6.36428529	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.9	4.8e-4	NR	EDO37115.1	45351	g47825	i0	62.2	1.09090909090909	37	14	37.4	0	7	117	400	436	EDO37115.1 predicted protein [Nematostella vectensis]	diamond	324	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30478440	30478440	PRJNA1093008_S_NODE_28033_length_344_cov_1.092251_g27706_i0	PRJNA1093008	28033	344	1.092251	3.75734344	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	99.8	1.1699999999999997e-23	NR	CAB3997091.1	317549	g27706	i0	51.1	2.09302325581395	90	44	78.5	0	40	309	89	178	CAB3997091.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	720	99.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
30501309	30501309	PRJNA1093008_S_NODE_38233_length_317_cov_2.016393_g37906_i0	PRJNA1093008	38233	317	2.016393	6.39196581	Anthozoa	6101	Cnidaria	other_Eukaryota	155	1.56e-41	NR	PFX14364.1	50429	g37906	i0	69.4	4.02208201892744	108	30	99.4	1	2	316	253	360	PFX14364.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Stylophora pistillata]	diamond	1275	155	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
31141459	31141459	PRJNA1093008_S_NODE_102155_length_197_cov_16.451613_g101828_i0	PRJNA1093008	102155	197	16.451613	32.40967761	Acropora millepora	45264	Cnidaria	other_Eukaryota	49.3	9.88e-5	NR	XP_044174387.1	45264	g101828	i0	63.2	0.578680203045685	38	14	57.9	0	183	70	354	391	XP_044174387.1 actin, cytoplasmic 1-like [Acropora millepora]	diamond	114	49.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora

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