metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1136957" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1136957" 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
2835278	2835278	PRJNA1136957_S_NODE_5283_length_347_cov_5.677083_g5186_i0	PRJNA1136957	5283	347	5.677083	19.69947801	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	180	1.44e-40	NTclustered	gi\|1270078307\|ref\|XM_022946576.1\|	50429	g5186	i0	78.041	17.864553314121	296	57	84	7	12	303	994	703	PREDICTED: Stylophora pistillata endoplasmin-like (LOC111339851), mRNA	blastn	6199	180	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
3582517	3582517	PRJNA1136957_S_NODE_16463_length_214_cov_76.464516_g16366_i0	PRJNA1136957	16463	214	76.464516	163.63406424	root	1	Root_unresolved	Root_unresolved	52.8	0.019	NTclustered	gi\|2202666560\|ref\|XR_006951441.1\|	2897299	g16366	i0	100	0.294392523364486	28	0	13	0	1	28	1	28	PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA	blastn	63	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
5387803	5387803	PRJNA1136957_S_NODE_2185_length_462_cov_8.545906_g2088_i0	PRJNA1136957	2185	462	8.545906	39.48208572	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	87.9	1.23e-12	NTclustered	gi\|2744827602\|ref\|XM_002157242.5\|	6087	g2088	i0	84.27	0.344155844155844	89	14	19	0	373	461	1006	918	PREDICTED: Hydra vulgaris ribosome biogenesis protein NSA2 homolog (LOC100213141), transcript variant X1, mRNA	blastn	159	87.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
9960153	9960153	PRJNA1136957_S_NODE_1508_length_515_cov_48.561404_g1413_i0	PRJNA1136957	1508	515	48.561404	250.0912306	Pocillopora	46730	Cnidaria	other_Eukaryota	54.7	0.014	NTclustered	gi\|1524859678\|ref\|XM_027181014.1\|	46731	g1413	i0	94.444	0.209708737864078	36	0	7	2	397	431	10427	10393	PREDICTED: Pocillopora damicornis prolow-density lipoprotein receptor-related protein 1-like (LOC113665335), partial mRNA	blastn	108	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
11235366	11235366	PRJNA1136957_S_NODE_6209_length_327_cov_1.466418_g6112_i0	PRJNA1136957	6209	327	1.466418	4.79518686	Metazoa	33208	Cnidaria	other_Eukaryota	231	3.68e-56	NTclustered	gi\|2518975123\|ref\|XM_057438390.1\|	13093	g6112	i0	81.338	22.4617737003058	284	53	87	0	41	324	236	519	PREDICTED: Hydractinia symbiolongicarpus serine/threonine-protein phosphatase alpha-2 isoform (LOC130622931), mRNA	blastn	7345	231	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
11763177	11763177	PRJNA1136957_S_NODE_10650_length_262_cov_1.502463_g10553_i0	PRJNA1136957	10650	262	1.502463	3.93645306	Dendronephthya gigantea	151771	Cnidaria	other_Eukaryota	106	1.81e-18	NTclustered	gi\|1603780777\|ref\|XM_028537764.1\|	151771	g10553	i0	85.859	0.706106870229008	99	14	38	0	164	262	283	185	PREDICTED: Dendronephthya gigantea calmodulin-like (LOC114517914), mRNA	blastn	185	106	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Dendronephthya	Dendronephthya gigantea
12510738	12510738	PRJNA1136957_S_NODE_1230_length_544_cov_27.416495_g1139_i0	PRJNA1136957	1230	544	27.416495	149.1457328	Opisthokonta	33154	Cnidaria	other_Eukaryota	97.1	2.44e-15	NTclustered	gi\|1840174040\|gb\|MT318871.1\|	1350343	g1139	i0	98.214	10.0680147058824	56	0	10	1	489	544	210	264	Leiopathes expansa 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	5477	97.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Antipatharia	Antipathidae	Leiopathes	Leiopathes expansa
18136266	18136266	PRJNA1136957_S_NODE_1335_length_533_cov_5.535865_g1241_i0	PRJNA1136957	1335	533	5.535865	29.50616045	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	71.3	1.44e-7	NTclustered	gi\|1524887265\|ref\|XM_027195699.1\|	46731	g1241	i0	79.798	0.185741088180113	99	18	18	2	156	253	231	328	PREDICTED: Pocillopora damicornis protein dpy-30 homolog (LOC113678792), mRNA	blastn	99	71.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
24510554	24510554	PRJNA1136957_S_NODE_3480_length_402_cov_1.860058_g3383_i0	PRJNA1136957	3480	402	1.860058	7.47743316	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.011	NTclustered	gi\|2917940759\|emb\|OZ237572.1\|	6108	g3383	i0	100	0.0721393034825871	29	0	7	0	3	31	1642470	1642442	Anemonia sulcata genome assembly, chromosome: 18	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata

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