metadata: contig_metadata: 9 rows where bioproject = "PRJNA864829", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA864829", 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
8889847	8889847	PRJNA864829_S_NODE_5087_length_262_cov_2.816901_g5001_i0	PRJNA864829	5087	262	2.816901	7.38028062	Metazoa	33208	Cnidaria	other_Eukaryota	94	7.6300000000000005e-22	NR	XP_012553648.1	6087	g5001	i0	70.6	7.93511450381679	68	19	76.7	1	260	60	114	181	XP_012553648.1 large ribosomal subunit protein uL22 isoform X1 [Hydra vulgaris]	diamond	2079	94	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
12326400	12326400	PRJNA864829_S_NODE_10210_length_197_cov_21.574324_g10124_i0	PRJNA864829	10210	197	21.574324	42.50141828	Parvicapsula irregularis	1483221	Cnidaria	other_Eukaryota	143	9.839999999999999e-30	NTclustered	gi\|605060086\|gb\|KF874226.1\|	1483221	g10124	i0	83.893	74.6548223350254	149	24	76	0	25	173	1194	1342	Parvicapsula irregularis 28S ribosomal RNA gene, partial sequence	blastn	14707	143	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Parvicapsulidae	Parvicapsula	Parvicapsula irregularis
13600945	13600945	PRJNA864829_S_NODE_12071_length_184_cov_1.844444_g11985_i0	PRJNA864829	12071	184	1.844444	3.39377696	Podocorynoides minima	367905	Cnidaria	other_Eukaryota	111	2.55e-20	NTclustered	gi\|219810230\|gb\|EU883552.1\|	367905	g11985	i0	82.576	71.2771739130435	132	17	71	4	1	131	1570	1696	Podocorynoides minima large subunit 28S ribosomal RNA gene, partial sequence	blastn	13115	111	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Rathkeidae	Podocorynoides	Podocorynoides minima
13990752	13990752	PRJNA864829_S_NODE_331_length_730_cov_7.230543_g269_i0	PRJNA864829	331	730	7.230543	52.7829639	Coronatae	86058	Cnidaria	other_Eukaryota	87.9	2e-12	NTclustered	gi\|15208481\|gb\|AY026368.1\|	86043	g269	i0	89.706	0.186301369863014	68	7	9	0	49	116	1402	1469	Atolla vanhoeffeni 28S large subunit ribosomal RNA gene, partial sequence	blastn	136	87.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Coronatae	Atollidae	Atolla	Atolla vanhoeffeni
18698613	18698613	PRJNA864829_S_NODE_2935_length_319_cov_2.974074_g2849_i0	PRJNA864829	2935	319	2.974074	9.48729606	Fraseroscyphus hozawai	1850501	Cnidaria	other_Eukaryota	113	1.35e-20	NTclustered	gi\|1006165262\|gb\|KT190772.1\|	1850501	g2849	i0	81.119	48.987460815047	143	25	45	1	165	307	1259	1399	Fraseroscyphus hozawai clone FH06P208-2, 209-4 28S ribosomal RNA gene, partial sequence	blastn	15627	113	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Fraseroscyphus	Fraseroscyphus hozawai
21638897	21638897	PRJNA864829_S_NODE_11457_length_188_cov_1.812950_g11371_i0	PRJNA864829	11457	188	1.81295	3.408346	root	1	Root_unresolved	Root_unresolved	54.7	0.004	NTclustered	gi\|2917940731\|emb\|OZ237564.1\|	6108	g11371	i0	100	4.25	29	0	15	0	106	134	11881228	11881200	Anemonia sulcata genome assembly, chromosome: 10	blastn	799	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
22523961	22523961	PRJNA864829_S_NODE_1018_length_476_cov_11.662763_g932_i0	PRJNA864829	1018	476	11.662763	55.51475188	Symplectoscyphus tricuspidatus	308614	Cnidaria	other_Eukaryota	145	7.43e-30	NTclustered	gi\|1006165264\|gb\|KT190774.1\|	308614	g932	i0	80.5	33.5546218487395	200	29	41	6	254	450	2489	2297	Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence	blastn	15972	145	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Symplectoscyphus	Symplectoscyphus tricuspidatus
23799554	23799554	PRJNA864829_S_NODE_6599_length_237_cov_8.377660_g6513_i0	PRJNA864829	6599	237	8.37766	19.8550542	Carybdea rastonii	78582	Cnidaria	other_Eukaryota	196	9.29e-46	NTclustered	gi\|66864847\|gb\|AY920787.1\|	78582	g6513	i0	84.36	83.9915611814346	211	21	89	9	1	211	1616	1418	Carybdea rastonii voucher XH0114 large subunit 28S ribosomal RNA gene, partial sequence	blastn	19906	196	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Cubozoa	Carybdeida	Carybdeidae	Carybdea	Carybdea rastonii
27063226	27063226	PRJNA864829_S_NODE_5662_length_252_cov_1.458128_g5576_i0	PRJNA864829	5662	252	1.458128	3.67448256	Anthozoa	6101	Cnidaria	other_Eukaryota	65.9	2.85e-10	NR	XP_048583816.1	45351	g5576	i0	44.3	15.1904761904762	79	40	94	2	16	252	260	334	XP_048583816.1 tyrosine-protein kinase CSK isoform X2 [Nematostella vectensis]	diamond	3828	65.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis

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