metadata: contig_metadata: 8 rows where bioproject = "PRJNA575566", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA575566", 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
9488518	9488518	PRJNA575566_P_NODE_27828_length_204_cov_0.895105_g27631_i0	PRJNA575566	27828	204	0.895105	1.8260142	Cnidaria	6073	Cnidaria	other_Eukaryota	102	1.02e-24	NR	XP_027050760.1	46731	g27631	i0	74.3	11.2794117647059	70	16	100	1	1	204	2	71	XP_027050760.1 40S ribosomal protein S3a [Pocillopora damicornis]	diamond	2301	102	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
18412145	18412145	PRJNA575566_P_NODE_3675_length_544_cov_0.993789_g3479_i0	PRJNA575566	3675	544	0.993789	5.40621216	Metazoa	33208	Cnidaria	other_Eukaryota	244	5.439999999999999e-74	NR	XP_031551335.1	6105	g3479	i0	66.9	69.6176470588235	181	60	99.8	0	543	1	387	567	XP_031551335.1 heat shock cognate 71 kDa protein [Actinia tenebrosa]	diamond	37872	245	0.995918367346939	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
22237328	22237328	PRJNA575566_P_NODE_858_length_1082_cov_2.458374_g736_i0	PRJNA575566	858	1082	2.458374	26.59960668	Stephanomia amphytridis	645353	Cnidaria	other_Eukaryota	516	3.25e-141	NTclustered	gi\|2554488347\|ref\|NC_080956.1\|	645353	g736	i0	77.377	52.2292051756007	915	177	83	25	177	1074	15145	14244	Stephanomia amphytridis voucher YPM:IZ:35076 mitochondrion, complete genome	blastn	56512	516	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Siphonophorae	Agalmatidae	Stephanomia	Stephanomia amphytridis
28103639	28103639	PRJNA575566_P_NODE_24165_length_209_cov_0.864865_g23968_i0	PRJNA575566	24165	209	0.864865	1.80756785	Scleractinia	6125	Cnidaria	other_Eukaryota	58.9	4.59e-8	NR	KAK2558043.1	6130	g23968	i0	39.7	7.11961722488038	63	36	87.6	1	1	183	417	479	KAK2558043.1 MORN repeat-containing protein 3 [Acropora cervicornis]	diamond	1488	59.3	0.993254637436762	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
29935313	29935313	PRJNA575566_P_NODE_28951_length_202_cov_0.907801_g28754_i0	PRJNA575566	28951	202	0.907801	1.83375802	Metazoa	33208	Cnidaria	other_Eukaryota	99.4	3.2899999999999996e-23	NR	XP_057297044.1	13093	g28754	i0	73.1	16.8712871287129	67	17	99.5	1	2	202	214	279	XP_057297044.1 uncharacterized protein LOC130625935 [Hydractinia symbiolongicarpus]	diamond	3408	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
30395923	30395923	PRJNA575566_P_NODE_27953_length_204_cov_0.895105_g27756_i0	PRJNA575566	27953	204	0.895105	1.8260142	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	68.9	1.3e-11	NR	XP_047128515.1	6087	g27756	i0	52.3	0.955882352941177	65	31	95.6	0	203	9	691	755	XP_047128515.1 uncharacterized protein LOC124809060 [Hydra vulgaris]	diamond	195	68.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
30427523	30427523	PRJNA575566_P_NODE_25853_length_207_cov_0.876712_g25656_i0	PRJNA575566	25853	207	0.876712	1.81479384	Porites evermanni	104178	Cnidaria	other_Eukaryota	57.8	1.19e-7	NR	CAH3026882.1	104178	g25656	i0	45.5	0.797101449275362	55	29	78.3	1	46	207	71	125	CAH3026882.1 unnamed protein product [Porites evermanni]	diamond	165	57.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
31628115	31628115	PRJNA575566_P_NODE_13256_length_289_cov_1.100877_g13059_i0	PRJNA575566	13256	289	1.100877	3.18153453	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	63.2	4.21e-9	NR	XP_065054357.1	499914	g13059	i0	35.1	1.65051903114187	74	47	76.8	1	233	12	544	616	XP_065054357.1 prosaposin-like [Rhopilema esculentum]	diamond	477	63.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum

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