metadata: contig_metadata: 14 rows where bioproject = "PRJNA615175", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA615175", tax_clade = "Opisthokonta" 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
1149814	1149814	PRJNA615175_P_NODE_1821_length_1126_cov_16.370370_g1713_i0	PRJNA615175	1821	1126	16.37037	184.3303662	Metazoa	33208	Cnidaria	other_Eukaryota	135	1.11e-26	NTclustered	gi\|605060084\|gb\|KF874224.1\|	109801	g1713	i0	86.885	11.234458259325	122	14	11	2	1005	1126	233	352	Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence	blastn	12650	135	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Parvicapsulidae	Parvicapsula	Parvicapsula minibicornis
3146043	3146043	PRJNA615175_P_NODE_5483_length_654_cov_11.079174_g5319_i0	PRJNA615175	5483	654	11.079174	72.45779796	Montipora capricornis	246305	Cnidaria	other_Eukaryota	54.7	0.018	NTclustered	gi\|2812160882\|ref\|XM_068893302.1\|	246305	g5319	i0	100	0.0443425076452599	29	0	4	0	444	472	1238	1210	PREDICTED: Montipora capricornis PE-PGRS family protein PE_PGRS16-like (LOC138046707), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
20276220	20276220	PRJNA615175_P_NODE_21036_length_301_cov_5.618421_g20868_i0	PRJNA615175	21036	301	5.618421	16.91144721	Symplectoscyphus	308613	Cnidaria	other_Eukaryota	91.6	5.94e-14	NTclustered	gi\|1006165264\|gb\|KT190774.1\|	308614	g20868	i0	80.159	1.82059800664452	126	21	41	4	146	269	2058	1935	Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence	blastn	548	91.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Symplectoscyphus	Symplectoscyphus tricuspidatus
26890726	26890726	PRJNA615175_P_NODE_6961_length_574_cov_1.536926_g6796_i0	PRJNA615175	6961	574	1.536926	8.82195524	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	175	8.52e-51	NR	EDO44007.1	45351	g6796	i0	54.5	1.60975609756098	154	69	80	1	85	543	125	278	EDO44007.1 predicted protein [Nematostella vectensis]	diamond	924	175	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
27333334	27333334	PRJNA615175_P_NODE_1723_length_1151_cov_10.591837_g1621_i0	PRJNA615175	1723	1151	10.591837	121.91204387	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	56.6	1.03e-4	NR	XP_020905248.1	2652724	g1621	i0	23.3	0.76107732406603	292	165	70.6	11	32	844	89	342	XP_020905248.1 F-box protein At3g58530 isoform X2 [Exaiptasia diaphana]	diamond	876	56.6	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
27775450	27775450	PRJNA615175_P_NODE_2644_length_949_cov_2.110731_g2514_i0	PRJNA615175	2644	949	2.110731	20.03083719	Porites lobata	104759	Cnidaria	other_Eukaryota	99.8	1.33e-19	NR	CAH3183681.1	104759	g2514	i0	31.1	2.54162276080084	270	146	81.2	11	27	797	154	396	CAH3183681.1 unnamed protein product [Porites lobata]	diamond	2412	99.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
28217035	28217035	PRJNA615175_P_NODE_106_length_2699_cov_4.185453_g99_i0	PRJNA615175	106	2699	4.185453	112.96537647	Porites evermanni	104178	Cnidaria	other_Eukaryota	51.2	0.023	NR	CAH3178536.1	104178	g99	i0	31.7	0.251204149685069	120	37	13.3	2	2695	2336	5	79	CAH3178536.1 unnamed protein product, partial [Porites evermanni]	diamond	678	51.6	0.992248062015504	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
28293343	28293343	PRJNA615175_P_NODE_6006_length_623_cov_4.605455_g5841_i0	PRJNA615175	6006	623	4.605455	28.69198465	Opisthokonta	33154	Cnidaria	other_Eukaryota	81.6	2.95e-14	NR	CAH3197898.1	104178	g5841	i0	35.2	2.39325842696629	108	52	43.3	2	210	479	144	251	CAH3197898.1 unnamed protein product, partial [Porites evermanni]	diamond	1491	82.4	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
28816908	28816908	PRJNA615175_P_NODE_35768_length_239_cov_3.692771_g35600_i0	PRJNA615175	35768	239	3.692771	8.82572269	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	99.4	6.93e-25	NR	XP_031552790.1	6105	g35600	i0	62.5	3.92887029288703	80	25	94.1	1	226	2	22	101	XP_031552790.1 60S ribosomal protein L35a-like [Actinia tenebrosa]	diamond	939	99.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
29227914	29227914	PRJNA615175_P_NODE_17429_length_335_cov_2.740458_g17261_i0	PRJNA615175	17429	335	2.740458	9.1805343	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	146	9.31e-41	NR	XP_020613016.1	48498	g17261	i0	61.5	3.73432835820896	104	40	93.1	0	8	319	196	299	XP_020613016.1 uncharacterized protein LOC110051320 [Orbicella faveolata]	diamond	1251	146	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
30301937	30301937	PRJNA615175_P_NODE_20952_length_302_cov_2.017467_g20784_i0	PRJNA615175	20952	302	2.017467	6.09275034	Acropora muricata	159855	Cnidaria	other_Eukaryota	74.7	3.48e-13	NR	XP_067028463.1	159855	g20784	i0	35	2.01655629139073	103	55	99.3	3	301	2	280	373	XP_067028463.1 uncharacterized protein [Acropora muricata]	diamond	609	74.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora muricata
31249332	31249332	PRJNA615175_P_NODE_7335_length_557_cov_11.068182_g7170_i0	PRJNA615175	7335	557	11.068182	61.64977374	Porites lobata	104759	Cnidaria	other_Eukaryota	96.7	1.86e-19	NR	CAH3173330.1	104759	g7170	i0	48.1	1.69120287253142	106	50	57.1	2	14	331	302	402	CAH3173330.1 unnamed protein product [Porites lobata]	diamond	942	96.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
31376018	31376018	PRJNA615175_P_NODE_5716_length_641_cov_2.639085_g5551_i0	PRJNA615175	5716	641	2.639085	16.91653485	Porites lobata	104759	Cnidaria	other_Eukaryota	76.3	3.52e-12	NR	CAH3106756.1	104759	g5551	i0	27.9	0.889235569422777	190	114	82.4	7	34	561	193	373	CAH3106756.1 unnamed protein product, partial [Porites lobata]	diamond	570	76.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata
32559735	32559735	PRJNA615175_P_NODE_4179_length_759_cov_3.411079_g4021_i0	PRJNA615175	4179	759	3.411079	25.89008961	Anthozoa	6101	Cnidaria	other_Eukaryota	100	2.29e-21	NR	CAH3173772.1	104759	g4021	i0	30.6	3.23715415019763	209	127	79.8	7	748	143	76	273	CAH3173772.1 unnamed protein product [Porites lobata]	diamond	2457	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites lobata

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