metadata: contig_metadata: 10 rows where bioproject = "PRJNA352850", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA352850", tax_kingdom = "Metazoa" 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
395255	395255	PRJNA352850_P_NODE_27581_length_518_cov_2.443497_g24757_i0	PRJNA352850	27581	518	2.443497	12.65731446	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	56.5	0.004	NTclustered	gi\|2918369537\|emb\|OZ237719.1\|	317547	g24757	i0	96.97	0.138996138996139	33	1	6	0	371	403	30553736	30553768	Eunicella cavolini genome assembly, chromosome: 3	blastn	72	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
4222120	4222120	PRJNA352850_P_NODE_15984_length_765_cov_5.236034_g13341_i0	PRJNA352850	15984	765	5.236034	40.0556601	Porites evermanni	104178	Cnidaria	other_Eukaryota	162	1.0899999999999999e-43	NR	CAH3015503.1	104178	g13341	i0	39.5	3.83529411764706	210	116	80.8	3	668	51	190	392	CAH3015503.1 unnamed protein product [Porites evermanni]	diamond	2934	162	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
26790086	26790086	PRJNA352850_P_NODE_33681_length_450_cov_4.975062_g30851_i0	PRJNA352850	33681	450	4.975062	22.387779	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	182	6.949999999999999e-56	NR	XP_020895630.1	2652724	g30851	i0	63.4	4.34666666666667	134	49	89.3	0	1	402	17	150	XP_020895630.1 superoxide dismutase [Cu-Zn] [Exaiptasia diaphana]	diamond	1956	182	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
26916626	26916626	PRJNA352850_P_NODE_44542_length_370_cov_1.856698_g41709_i0	PRJNA352850	44542	370	1.856698	6.8697826	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	101	1.79e-23	NR	XP_031551251.1	6105	g41709	i0	41.2	1.63783783783784	102	60	82.7	0	370	65	138	239	XP_031551251.1 pyridoxal phosphate phosphatase PHOSPHO2-like [Actinia tenebrosa]	diamond	606	101	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
27724157	27724157	PRJNA352850_P_NODE_55664_length_316_cov_2.666667_g52831_i0	PRJNA352850	55664	316	2.666667	8.42666772	root	1	Root_unresolved	Root_unresolved	89.7	2.83e-18	NR	KAK2563579.1	6130	g52831	i0	51	8.56329113924051	100	45	92.1	3	26	316	196	294	KAK2563579.1 Expansin-YoaJ [Acropora cervicornis]	diamond	2706	90.5	0.991160220994475	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
29316902	29316902	PRJNA352850_P_NODE_66469_length_278_cov_2.724891_g63636_i0	PRJNA352850	66469	278	2.724891	7.57519698	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	58.5	4e-8	NR	XP_020629258.1	48498	g63636	i0	42.9	5.28776978417266	70	40	75.5	0	1	210	76	145	XP_020629258.1 mediator of RNA polymerase II transcription subunit 31-like [Orbicella faveolata]	diamond	1470	58.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
29348592	29348592	PRJNA352850_P_NODE_7929_length_1302_cov_7.768555_g5865_i0	PRJNA352850	7929	1302	7.768555	101.1465861	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	135	3.28e-31	NR	XP_065660070.1	6087	g5865	i0	32.4	3.99769585253456	213	137	47.9	4	6	629	37	247	XP_065660070.1 TNF receptor-associated factor 5-like isoform X1 [Hydra vulgaris]	diamond	5205	135	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29902537	29902537	PRJNA352850_P_NODE_41851_length_387_cov_2.153846_g39019_i0	PRJNA352850	41851	387	2.153846	8.33538402	root	1	Root_unresolved	Root_unresolved	52.4	7.34e-5	NR	CAH3180351.1	104178	g39019	i0	52	1.51162790697674	50	23	38	1	47	193	12	61	CAH3180351.1 unnamed protein product [Porites evermanni]	diamond	585	52.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
31939644	31939644	PRJNA352850_P_NODE_25737_length_543_cov_3.516194_g22916_i0	PRJNA352850	25737	543	3.516194	19.09293342	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	102	3.039999999999999e-23	NR	XP_057295726.1	13093	g22916	i0	39	0.906077348066298	164	91	89	4	542	60	55	212	XP_057295726.1 CDP-diacylglycerol--inositol 3-phosphatidyltransferase-like isoform X2 [Hydractinia symbiolongicarpus]	diamond	492	102	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
32477855	32477855	PRJNA352850_P_NODE_33899_length_448_cov_3.651629_g31069_i0	PRJNA352850	33899	448	3.651629	16.35929792	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	87.4	1.74e-17	NR	XP_012560593.2	6087	g31069	i0	50.8	2.18973214285714	118	52	75	2	447	112	103	220	XP_012560593.2 protein MAK16 homolog [Hydra vulgaris]	diamond	981	87.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris

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