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

9 rows where bioproject = "PRJEB7614", 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
13749839	13749839	PRJEB7614_P_NODE_3791_length_208_cov_1.458101_g3724_i0	PRJEB7614	3791	208	1.458101	3.03285008	Metazoa	33208	Cnidaria	other_Eukaryota	56.5	0.001	NTclustered	gi\|2917940724\|emb\|OZ237563.1\|	6108	g3724	i0	100	0.899038461538462	30	0	14	0	106	135	455682	455653	Anemonia sulcata genome assembly, chromosome: 9	blastn	187	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
26024680	26024680	PRJEB7614b_S_NODE_556_length_258_cov_52283.847534_g554_i0	PRJEB7614	556	258	52283.847534	134892.32663772	root	1	Root_unresolved	Root_unresolved	106	1.78e-18	NTclustered	gi\|1005425976\|ref\|XR_001560983.1\|	70779	g554	i0	98.333	23.3527131782946	60	1	23	0	1	60	71	12	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X3, ncRNA	blastn	6025	106	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
26069946	26069946	PRJEB7614b_S_NODE_453_length_273_cov_48639.294118_g451_i0	PRJEB7614	453	273	48639.294118	132785.27294214	Acropora digitifera	70779	Cnidaria	other_Eukaryota	95.3	4.11e-15	NTclustered	gi\|1005425982\|ref\|XR_001560996.1\|	70779	g451	i0	100	20.1282051282051	51	0	19	0	1	51	61	11	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X9, ncRNA	blastn	5495	95.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
26206235	26206235	PRJEB7614e_S_NODE_1542_length_214_cov_4945.815642_g1534_i0	PRJEB7614	1542	214	4945.815642	10584.04547388	Acropora digitifera	70779	Cnidaria	other_Eukaryota	73.1	1.45e-8	NTclustered	gi\|1005425982\|ref\|XR_001560996.1\|	70779	g1534	i0	100	18.8785046728972	39	0	18	0	1	39	49	11	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X9, ncRNA	blastn	4040	73.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
26206245	26206245	PRJEB7614e_S_NODE_30_length_615_cov_3711.465517_g25_i0	PRJEB7614	30	615	3711.465517	22825.51292955	Acropora digitifera	70779	Cnidaria	other_Eukaryota	117	2.13e-21	NTclustered	gi\|1005425977\|ref\|XR_001560985.1\|	70779	g25	i0	93.75	11.0991869918699	80	1	13	3	536	615	2	77	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X4, ncRNA	blastn	6826	117	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
26296593	26296593	PRJEB7614a_S_NODE_73078_length_223_cov_192.638298_g71874_i0	PRJEB7614	73078	223	192.638298	429.58340454	root	1	Root_unresolved	Root_unresolved	97.1	9.02e-16	NTclustered	gi\|1005425975\|ref\|XR_001560982.1\|	70779	g71874	i0	92.537	26.2331838565022	67	5	30	0	157	223	23	89	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X2, ncRNA	blastn	5850	97.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
26342050	26342050	PRJEB7614b_S_NODE_463_length_272_cov_5.071730_g461_i0	PRJEB7614	463	272	5.07173	13.7951056	Sphaeromyxa zaharoni	275449	Cnidaria	other_Eukaryota	60.2	1.49e-4	NTclustered	gi\|2663986569\|emb\|OY751524.1\|	275449	g461	i0	100	2.44852941176471	32	0	12	0	159	190	6365	6334	Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences	blastn	666	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Sphaeromyxidae	Sphaeromyxa	Sphaeromyxa zaharoni
26342052	26342052	PRJEB7614b_S_NODE_559_length_257_cov_104871.842342_g557_i0	PRJEB7614	559	257	104871.842342	269520.63481894	Acropora digitifera	70779	Cnidaria	other_Eukaryota	93.5	1.38e-14	NTclustered	gi\|1005425979\|ref\|XR_001560992.1\|	70779	g557	i0	98.148	42.9182879377432	54	0	42	1	205	257	29	82	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X6, ncRNA	blastn	11030	93.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
26568612	26568612	PRJEB7614a_S_NODE_57552_length_253_cov_1598.986239_g56348_i0	PRJEB7614	57552	253	1598.986239	4045.43518467	root	1	Root_unresolved	Root_unresolved	102	2.25e-17	NTclustered	gi\|1005425982\|ref\|XR_001560996.1\|	70779	g56348	i0	96.774	23.6126482213439	62	1	24	1	1	61	70	9	PREDICTED: Acropora digitifera uncharacterized LOC107329384 (LOC107329384), transcript variant X9, ncRNA	blastn	5974	102	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera

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