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

10 rows where bioproject = "PRJNA1218816", 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
2321596	2321596	PRJNA1218816_P_NODE_48882_length_268_cov_1.184615_g48449_i0	PRJNA1218816	48882	268	1.184615	3.1747682	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	61.6	7.13e-10	NR	XP_065652030.1	6087	g48449	i0	55.1	0.548507462686567	49	22	54.9	0	264	118	23	71	XP_065652030.1 large ribosomal subunit protein P1-like isoform X1 [Hydra vulgaris]	diamond	147	61.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
4160313	4160313	PRJNA1218816_P_NODE_32904_length_346_cov_1.945055_g32471_i0	PRJNA1218816	32904	346	1.945055	6.7298903	Podocoryna carnea	6096	Cnidaria	other_Eukaryota	137	1.3799999999999999e-38	NR	P37380.1	6096	g32471	i0	63	2.83526011560694	108	39	92.8	1	344	24	72	179	P37380.1 RecName: Full=Large ribosomal subunit protein uL22; AltName: Full=60S ribosomal protein L17 [Podocoryna carnea]	diamond	981	137	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Podocoryna	Podocoryna carnea
9261396	9261396	PRJNA1218816_P_NODE_44928_length_283_cov_2.814286_g44495_i0	PRJNA1218816	44928	283	2.814286	7.96442938	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	276	1.4199999999999999e-69	NTclustered	gi\|2782857558\|ref\|XM_067058140.1\|	252671	g44495	i0	92.67	77.6007067137809	191	14	67	0	2	192	367	177	PREDICTED: Clytia hemisphaerica actin, non-muscle 6.2 (LOC136801505), mRNA	blastn	21961	276	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
18184775	18184775	PRJNA1218816_P_NODE_18135_length_529_cov_1.796053_g17706_i0	PRJNA1218816	18135	529	1.796053	9.50112037	Opisthokonta	33154	Cnidaria	other_Eukaryota	310	2.19e-103	NR	KAK2573205.1	6130	g17706	i0	80.7	27.6805293005671	176	34	99.8	0	529	2	124	299	KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis]	diamond	14643	310	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
23285422	23285422	PRJNA1218816_P_NODE_13899_length_640_cov_1.373898_g13476_i0	PRJNA1218816	13899	640	1.373898	8.7929472	Opisthokonta	33154	Cnidaria	other_Eukaryota	285	1.26e-94	NR	XP_001622696.2	45351	g13476	i0	71.4	13.3546875	203	56	95.2	1	611	3	1	201	XP_001622696.2 40S ribosomal protein S8 [Nematostella vectensis]	diamond	8547	287	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
26901829	26901829	PRJNA1218816_P_NODE_10901_length_770_cov_3.380201_g10502_i0	PRJNA1218816	10901	770	3.380201	26.0275477	Cnidaria	6073	Cnidaria	other_Eukaryota	264	5.09e-86	NR	XP_029195686.1	45264	g10502	i0	69.9	17.8558441558442	196	59	76.4	0	733	146	1	196	XP_029195686.1 60S ribosomal protein L19-like [Acropora millepora]	diamond	13749	265	0.99622641509434	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27439422	27439422	PRJNA1218816_P_NODE_59103_length_245_cov_0.895349_g58670_i0	PRJNA1218816	59103	245	0.895349	2.19360505	Scleractinia	6125	Cnidaria	other_Eukaryota	66.2	8.83e-11	NR	XP_027044792.1	46731	g58670	i0	42.9	3.40408163265306	77	42	94.3	1	1	231	17	91	XP_027044792.1 oxidoreductase HTATIP2-like [Pocillopora damicornis]	diamond	834	66.6	0.993993993993994	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
31039671	31039671	PRJNA1218816_P_NODE_60915_length_243_cov_0.905882_g60482_i0	PRJNA1218816	60915	243	0.905882	2.20129326	Cnidaria	6073	Cnidaria	other_Eukaryota	111	3e-26	NR	XP_057297445.1	13093	g60482	i0	62.5	3.95061728395062	80	30	98.8	0	1	240	674	753	XP_057297445.1 piwi-like protein 1 [Hydractinia symbiolongicarpus]	diamond	960	111	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
32570738	32570738	PRJNA1218816_P_NODE_48819_length_268_cov_1.523077_g48386_i0	PRJNA1218816	48819	268	1.523077	4.08184636	Desmophyllum pertusum	174260	Cnidaria	other_Eukaryota	87	2.4e-19	NR	KAJ7389113.1	174260	g48386	i0	63	4.39925373134328	81	30	90.7	0	244	2	8	88	KAJ7389113.1 60S ribosomal protein L23 [Desmophyllum pertusum]	diamond	1179	87	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Caryophylliidae	Desmophyllum	Desmophyllum pertusum
32790647	32790647	PRJNA1218816_P_NODE_32380_length_350_cov_1.667870_g31947_i0	PRJNA1218816	32380	350	1.66787	5.837545	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	55.1	1.91e-6	NR	XP_028404663.1	151771	g31947	i0	49.1	0.471428571428571	55	21	41.1	1	347	204	46	100	XP_028404663.1 four-domain proteases inhibitor-like [Dendronephthya gigantea]	diamond	165	55.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea

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