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

9 rows where analysis = "blastn", bioproject = "PRJNA699078" 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
3233934	3233934	PRJNA699078_S_NODE_91343_length_175_cov_1.134921_g90394_i0	PRJNA699078	91343	175	1.134921	1.98611175	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.004	NTclustered	gi\|2917940745\|emb\|OZ237569.1\|	6108	g90394	i0	100	0.497142857142857	29	0	17	0	76	104	13111706	13111678	Anemonia sulcata genome assembly, chromosome: 15	blastn	87	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
8336008	8336008	PRJNA699078_S_NODE_8047_length_518_cov_6.560768_g7162_i0	PRJNA699078	8047	518	6.560768	33.98477824	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	58.4	0.001	NTclustered	gi\|2518984399\|ref\|XM_057442528.1\|	13093	g7162	i0	86.538	0.501930501930502	52	7	10	0	3	54	684	735	PREDICTED: Hydractinia symbiolongicarpus peroxiredoxin-1-like (LOC130629371), transcript variant X1, mRNA	blastn	260	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
12161494	12161494	PRJNA699078_S_NODE_49650_length_243_cov_1.360825_g48701_i0	PRJNA699078	49650	243	1.360825	3.30680475	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	132	2.7300000000000003e-26	NTclustered	gi\|2257801647\|ref\|XM_032374702.2\|	45351	g48701	i0	84.328	0.551440329218107	134	21	55	0	109	242	3580	3447	PREDICTED: Nematostella vectensis structural maintenance of chromosomes protein 2 (LOC116614105), mRNA	blastn	134	132	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
13938033	13938033	PRJNA699078_S_NODE_15791_length_408_cov_1.518106_g14849_i0	PRJNA699078	15791	408	1.518106	6.19387248	Metazoa	33208	Cnidaria	other_Eukaryota	58.4	8.42e-4	NTclustered	gi\|2744885481\|ref\|XR_010641465.1\|	6087	g14849	i0	94.595	0.806372549019608	37	2	9	0	306	342	171	135	PREDICTED: Hydra vulgaris uncharacterized LOC101236854 (LOC101236854), transcript variant X2, misc_RNA	blastn	329	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
15985010	15985010	PRJNA699078_S_NODE_50973_length_239_cov_2.942105_g50024_i0	PRJNA699078	50973	239	2.942105	7.03163095	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	165	2.64e-36	NTclustered	gi\|2202634487\|ref\|XM_046993075.1\|	2897299	g50024	i0	81.818	50.1255230125523	198	34	82	2	41	237	756	560	PREDICTED: Xenia sp. Carnegie-2017 polyubiquitin (LOC124442587), mRNA	blastn	11980	165	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
17259799	17259799	PRJNA699078_S_NODE_21834_length_361_cov_3.673077_g20885_i0	PRJNA699078	21834	361	3.673077	13.25980797	Montipora capricornis	246305	Cnidaria	other_Eukaryota	257	6.76e-64	NTclustered	gi\|2812133237\|ref\|XM_068879853.1\|	246305	g20885	i0	80.597	9.80609418282548	335	63	93	2	28	361	708	375	PREDICTED: Montipora capricornis 33 kDa inner dynein arm light chain, axonemal-like (LOC138032228), mRNA	blastn	3540	257	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Montipora	Montipora capricornis
17761910	17761910	PRJNA699078_S_NODE_1194_length_1079_cov_33.459223_g816_i0	PRJNA699078	1194	1079	33.459223	361.02501617	Leptothecata	500008	Cnidaria	other_Eukaryota	65.8	1.41e-5	NTclustered	gi\|167858113\|gb\|EU305532.1\|	308591	g816	i0	95.122	3.26042632066728	41	2	4	0	1039	1079	3098	3058	Sertularia perpusilla large subunit 28S ribosomal RNA gene, partial sequence	blastn	3518	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Sertulariidae	Tridentata	Tridentata perpusilla
21084553	21084553	PRJNA699078_S_NODE_37077_length_284_cov_2.557447_g36128_i0	PRJNA699078	37077	284	2.557447	7.26314948	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	62.1	4.36e-5	NTclustered	gi\|2918369563\|emb\|OZ237729.1\|	317547	g36128	i0	93.182	1.23943661971831	44	0	15	2	183	224	12914046	12914004	Eunicella cavolini genome assembly, chromosome: 13	blastn	352	62.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
22359916	22359916	PRJNA699078_S_NODE_7538_length_529_cov_28.806250_g6666_i0	PRJNA699078	7538	529	28.80625	152.3850625	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	63.9	2.4e-5	NTclustered	gi\|1270028065\|ref\|XM_022952689.1\|	50429	g6666	i0	93.333	1.02079395085066	45	0	8	3	99	140	576	620	PREDICTED: Stylophora pistillata wiskott-Aldrich syndrome protein homolog 1-like (LOC111345318), transcript variant X2, mRNA	blastn	540	63.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata

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