metadata: contig_metadata: 14 rows where bioproject = "PRJNA763243" and tax

14 rows where bioproject = "PRJNA763243" 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
743661	743661	PRJNA763243_P_NODE_56141_length_247_cov_1.040230_g55795_i0	PRJNA763243	56141	247	1.04023	2.5693681	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	121	1.36e-32	NR	XP_057310909.1	13093	g55795	i0	65.4	5.79352226720648	81	28	98.4	0	243	1	84	164	XP_057310909.1 60S ribosomal protein L13a-like [Hydractinia symbiolongicarpus]	diamond	1431	122	0.991803278688525	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
2480585	2480585	PRJNA763243_P_NODE_19622_length_356_cov_3.014134_g19276_i0	PRJNA763243	19622	356	3.014134	10.73031704	Ectopleura	264051	Cnidaria	other_Eukaryota	172	2.48e-38	NTclustered	gi\|1032656006\|gb\|JN594044.2\|	264053	g19276	i0	86.25	45.685393258427	160	21	45	1	196	355	2274	2432	Ectopleura wrighti voucher MHNGINVE27331 28S ribosomal RNA gene, partial sequence	blastn	16264	172	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Tubulariidae	Ectopleura	Ectopleura wrighti
17321516	17321516	PRJNA763243_P_NODE_36454_length_286_cov_2.201878_g36108_i0	PRJNA763243	36454	286	2.201878	6.29737108	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	165	2.82e-49	NR	XP_028415884.1	151771	g36108	i0	82.8	65.3391608391608	93	16	97.6	0	283	5	30	122	XP_028415884.1 60S ribosomal protein L10-like [Dendronephthya gigantea]	diamond	18687	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
26799953	26799953	PRJNA763243_P_NODE_74001_length_202_cov_5.782946_g73655_i0	PRJNA763243	74001	202	5.782946	11.68155092	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	67.8	3.12e-11	NR	XP_066914400.1	252671	g73655	i0	50	0.772277227722772	52	26	77.2	0	45	200	16	67	XP_066914400.1 uncharacterized protein [Clytia hemisphaerica]	diamond	156	67.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
27442363	27442363	PRJNA763243_P_NODE_9383_length_486_cov_5.615012_g9040_i0	PRJNA763243	9383	486	5.615012	27.28895832	Acropora	6127	Cnidaria	other_Eukaryota	60.8	2.56e-7	NR	XP_044184077.1	45264	g9040	i0	28.5	2.38888888888889	165	82	97.5	7	6	479	14915	15050	XP_044184077.1 LOW QUALITY PROTEIN: uncharacterized protein LOC114956723 [Acropora millepora]	diamond	1161	60.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27694928	27694928	PRJNA763243_P_NODE_10944_length_456_cov_1.621410_g10601_i0	PRJNA763243	10944	456	1.62141	7.3936296	Cnidaria	6073	Cnidaria	other_Eukaryota	168	2.91e-49	NR	CAB4006907.1	317549	g10601	i0	56.4	8.05263157894737	156	60	99.3	3	4	456	75	227	CAB4006907.1 40S ribosomal S8 [Paramuricea clavata]	diamond	3672	169	0.994082840236686	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
28452585	28452585	PRJNA763243_P_NODE_33166_length_296_cov_4.573991_g32820_i0	PRJNA763243	33166	296	4.573991	13.53901336	Metazoa	33208	Cnidaria	other_Eukaryota	70.9	8e-12	NR	XP_031569994.1	6105	g32820	i0	54.4	13.722972972973	68	30	68.9	1	5	208	146	212	XP_031569994.1 radial spoke head protein 3 homolog [Actinia tenebrosa]	diamond	4062	71.2	0.995786516853933	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
29052468	29052468	PRJNA763243_P_NODE_61788_length_242_cov_2.201183_g61442_i0	PRJNA763243	61788	242	2.201183	5.32686286	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	98.2	1.11e-21	NR	XP_002158573.3	6087	g61442	i0	61.5	6.54545454545455	78	29	96.7	1	5	238	543	619	XP_002158573.3 thimet oligopeptidase isoform X1 [Hydra vulgaris]	diamond	1584	98.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
29484443	29484443	PRJNA763243_P_NODE_51410_length_251_cov_6.696629_g51064_i0	PRJNA763243	51410	251	6.696629	16.80853879	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	65.1	1.44e-11	NR	EDO32471.1	45351	g51064	i0	53.7	0.800796812749004	67	29	77.7	1	246	52	22	88	EDO32471.1 predicted protein, partial [Nematostella vectensis]	diamond	201	65.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30116243	30116243	PRJNA763243_P_NODE_59592_length_244_cov_1.333333_g59246_i0	PRJNA763243	59592	244	1.333333	3.25333252	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	73.6	3.77e-13	NR	XP_057293703.1	13093	g59246	i0	55.7	0.75	61	27	75	0	62	244	8	68	XP_057293703.1 crystallin J1A-like [Hydractinia symbiolongicarpus]	diamond	183	73.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
30716575	30716575	PRJNA763243_P_NODE_52054_length_251_cov_0.865169_g51708_i0	PRJNA763243	52054	251	0.865169	2.17157419	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	134	2.6e-34	NR	EDO39324.1	45351	g51708	i0	80	7.67330677290837	80	16	95.6	0	248	9	749	828	EDO39324.1 predicted protein, partial [Nematostella vectensis]	diamond	1926	134	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
31253820	31253820	PRJNA763243_P_NODE_58295_length_245_cov_1.610465_g57949_i0	PRJNA763243	58295	245	1.610465	3.94563925	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	47.8	6.67e-4	NR	XP_065063149.1	499914	g57949	i0	35.7	0.857142857142857	70	45	85.7	0	235	26	666	735	XP_065063149.1 cullin-associated NEDD8-dissociated protein 1-like [Rhopilema esculentum]	diamond	210	47.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
31253822	31253822	PRJNA763243_P_NODE_65035_length_238_cov_2.072727_g64689_i0	PRJNA763243	65035	238	2.072727	4.93309026	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	120	2.07e-29	NR	XP_066918440.1	252671	g64689	i0	73.7	10.3991596638655	76	20	95.8	0	6	233	543	618	XP_066918440.1 cytoplasmic aconitate hydratase-like [Clytia hemisphaerica]	diamond	2475	120	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
32076317	32076317	PRJNA763243_P_NODE_54118_length_249_cov_0.875000_g53772_i0	PRJNA763243	54118	249	0.875	2.17875	Montipora foliosa	591990	Cnidaria	other_Eukaryota	93.2	5.1e-20	NR	XP_068670946.1	591990	g53772	i0	53.7	4.93975903614458	82	37	97.6	1	244	2	171	252	XP_068670946.1 NAD-dependent protein deacetylase Sirt6-like [Montipora foliosa]	diamond	1230	93.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora foliosa

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