metadata: contig_metadata: 7 rows where bioproject = "PRJNA694770" and tax

7 rows where bioproject = "PRJNA694770" 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
15978293	15978293	PRJNA694770_P_NODE_82213_length_249_cov_1.250000_g81919_i0	PRJNA694770	82213	249	1.25	3.1125	Cnidaria	6073	Cnidaria	other_Eukaryota	134	1.46e-36	NR	XP_027049447.1	46731	g81919	i0	80.2	49.7831325301205	81	16	97.6	0	3	245	124	204	XP_027049447.1 40S ribosomal protein S2 [Pocillopora damicornis]	diamond	12396	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
27966964	27966964	PRJNA694770_P_NODE_95945_length_243_cov_0.905882_g95651_i0	PRJNA694770	95945	243	0.905882	2.20129326	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	48.1	3.97e-4	NR	XP_046842661.1	2897299	g95651	i0	36	1.85185185185185	75	41	91.4	3	14	235	54	122	XP_046842661.1 protein tofu-2-like isoform X1 [Xenia sp. Carnegie-2017]	diamond	450	48.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
29461984	29461984	PRJNA694770_P_NODE_57630_length_283_cov_1.461905_g57336_i0	PRJNA694770	57630	283	1.461905	4.13719115	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	108	3.86e-25	NR	XP_065667469.1	6087	g57336	i0	57.1	10.4416961130742	84	36	89	0	281	30	124	207	XP_065667469.1 ATP-binding cassette sub-family E member 1 isoform X2 [Hydra vulgaris]	diamond	2955	108	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29956253	29956253	PRJNA694770_P_NODE_75131_length_255_cov_1.692308_g74837_i0	PRJNA694770	75131	255	1.692308	4.3153854	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	51.6	3.19e-5	NR	KXJ13505.1	2652724	g74837	i0	44.9	2.11764705882353	49	27	57.6	0	194	48	99	147	KXJ13505.1 Kinetochore protein NDC80-like [Exaiptasia diaphana]	diamond	540	51.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
30177326	30177326	PRJNA694770_P_NODE_77132_length_252_cov_1.351955_g76838_i0	PRJNA694770	77132	252	1.351955	3.4069266	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	43.1	0.031	NR	CAB4029270.1	317549	g76838	i0	59.5	1.32142857142857	37	13	44	1	237	127	538	572	CAB4029270.1 Hypothetical predicted protein, partial [Paramuricea clavata]	diamond	333	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
30567520	30567520	PRJNA694770_P_NODE_88773_length_246_cov_0.890173_g88479_i0	PRJNA694770	88773	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	43.9	0.0146	NR	XP_028414643.1	151771	g88479	i0	37.3	11.9146341463415	75	44	87.8	1	23	238	345	419	XP_028414643.1 ethanolamine-phosphate phospho-lyase-like isoform X1 [Dendronephthya gigantea]	diamond	2931	44.3	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
31674051	31674051	PRJNA694770_P_NODE_82737_length_249_cov_0.875000_g82443_i0	PRJNA694770	82737	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	83.6	1.68e-16	NR	XP_020617129.1	48498	g82443	i0	90.9	16.9518072289157	44	4	53	0	178	47	44	87	XP_020617129.1 NAD(P) transhydrogenase, mitochondrial-like, partial [Orbicella faveolata]	diamond	4221	84.3	0.991696322657177	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata

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