metadata: contig_metadata: 11 rows where bioproject = "PRJNA169559", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJNA169559", 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
365041	365041	PRJNA169559_P_NODE_3721_length_869_cov_3.745238_g2589_i0	PRJNA169559	3721	869	3.745238	32.54611822	Opisthokonta	33154	Cnidaria	other_Eukaryota	217	1.01e-65	NR	CAH3024970.1	104178	g2589	i0	64.5	24.9804372842348	169	60	58.3	0	2	508	4	172	CAH3024970.1 unnamed protein product [Porites evermanni]	diamond	21708	219	0.990867579908676	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Poritidae	Porites	Porites evermanni
14394124	14394124	PRJNA169559_P_NODE_28532_length_273_cov_1.299180_g26456_i0	PRJNA169559	28532	273	1.29918	3.5467614	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	71.3	6.92e-8	NTclustered	gi\|2257845315\|ref\|XM_048720923.1\|	45351	g26456	i0	97.561	9.9010989010989	41	1	15	0	174	214	112	72	PREDICTED: Nematostella vectensis histone H2A (LOC5497237), mRNA	blastn	2703	71.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
21456582	21456582	PRJNA169559_P_NODE_12257_length_480_cov_2.516630_g10396_i0	PRJNA169559	12257	480	2.51663	12.079824	Scleractinia	6125	Cnidaria	other_Eukaryota	154	5.559999999999999e-40	NR	XP_020630312.1	48498	g10396	i0	67.3	1.2625	101	33	63.1	0	1	303	1401	1501	XP_020630312.1 bifunctional glutamate/proline--tRNA ligase-like [Orbicella faveolata]	diamond	606	155	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
23317025	23317025	PRJNA169559_P_NODE_20859_length_360_cov_7.102719_g18802_i0	PRJNA169559	20859	360	7.102719	25.5697884	Mastigias albipunctata	3143520	Cnidaria	other_Eukaryota	128	5.51e-25	NTclustered	gi\|2862235117\|gb\|PQ647264.1\|	3143520	g18802	i0	93.103	23.2194444444444	87	6	24	0	2	88	2959	3045	Mastigias albipunctata isolate AGC18067 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	8359	128	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Mastigiidae	Mastigias	Mastigias albipunctata
28589967	28589967	PRJNA169559_P_NODE_25727_length_294_cov_5.079245_g23651_i0	PRJNA169559	25727	294	5.079245	14.9329803	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	57	5.64e-7	NR	PFX19138.1	50429	g23651	i0	57.8	0.928571428571429	45	19	45.9	0	148	14	178	222	PFX19138.1 BTB/POZ domain-containing protein KCTD6 [Stylophora pistillata]	diamond	273	57	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
29838950	29838950	PRJNA169559_P_NODE_21511_length_350_cov_3.099688_g19448_i0	PRJNA169559	21511	350	3.099688	10.848908	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.3	4e-15	NR	XP_032232305.1	45351	g19448	i0	42.6	4.34571428571429	101	57	86.6	1	348	46	602	701	XP_032232305.1 vesicle-fusing ATPase [Nematostella vectensis]	diamond	1521	81.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
30376525	30376525	PRJNA169559_P_NODE_31632_length_258_cov_1.794760_g29556_i0	PRJNA169559	31632	258	1.79476	4.6304808	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	63.2	2.87e-9	NR	XP_022783403.1	50429	g29556	i0	79.4	2.37209302325581	34	7	39.5	0	156	257	129	162	XP_022783403.1 isoleucine--tRNA ligase, cytoplasmic-like isoform X2 [Stylophora pistillata]	diamond	612	63.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
30674128	30674128	PRJNA169559_P_NODE_12613_length_473_cov_2.229730_g10739_i0	PRJNA169559	12613	473	2.22973	10.5466229	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	67.4	1.06e-9	NR	XP_048579407.1	45351	g10739	i0	26.8	1.06553911205074	168	112	99.6	3	471	1	449	616	XP_048579407.1 protein white [Nematostella vectensis]	diamond	504	67.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
31039899	31039899	PRJNA169559_P_NODE_47415_length_178_cov_2.228188_g45338_i0	PRJNA169559	47415	178	2.228188	3.96617464	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	92	6.38e-20	NR	XP_028408260.1	151771	g45338	i0	74.6	1.98876404494382	59	15	99.4	0	178	2	354	412	XP_028408260.1 glutamate dehydrogenase, mitochondrial-like isoform X2 [Dendronephthya gigantea]	diamond	354	92.8	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
31210867	31210867	PRJNA169559_P_NODE_10935_length_510_cov_4.825364_g9136_i0	PRJNA169559	10935	510	4.825364	24.6093564	Xenia sp. Carnegie-2	86540	Cnidaria	other_Eukaryota	132	8.78e-36	NR	XP_046849006.1	2897299	g9136	i0	52	2.44705882352941	148	66	87.1	1	31	474	1	143	XP_046849006.1 60S ribosomal protein L24-like [Xenia sp. Carnegie-2017]	diamond	1248	132	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
32368263	32368263	PRJNA169559_P_NODE_17559_length_406_cov_1.840849_g15566_i0	PRJNA169559	17559	406	1.840849	7.47384694	Actiniaria	6103	Cnidaria	other_Eukaryota	50.1	4.4e-4	NR	XP_032226936.1	45351	g15566	i0	57.9	1.12315270935961	38	15	27.3	1	123	233	18	55	XP_032226936.1 polyadenylate-binding protein, cytoplasmic and nuclear [Nematostella vectensis]	diamond	456	50.4	0.994047619047619	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);;