metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA908278" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA908278" 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
3440994	3440994	PRJNA908278_P_NODE_18323_length_298_cov_1.835556_g18220_i0	PRJNA908278	18323	298	1.835556	5.46995688	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	52.8	0.028	NTclustered	gi\|2782838764\|ref\|XM_067054751.1\|	252671	g18220	i0	90.244	0.13758389261745	41	3	13	1	220	259	4610	4570	PREDICTED: Clytia hemisphaerica NACHT and WD repeat domain-containing protein 2-like (LOC136798170), mRNA	blastn	41	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
3441036	3441036	PRJNA908278_P_NODE_22343_length_274_cov_1.955224_g22240_i0	PRJNA908278	22343	274	1.955224	5.35731376	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	52.8	0.025	NTclustered	gi\|2729062097\|ref\|XM_065208644.1\|	499914	g22240	i0	100	0.102189781021898	28	0	10	0	92	119	3984	3957	PREDICTED: Rhopilema esculentum uncharacterized LOC135690937 (LOC135690937), transcript variant X2, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
4718742	4718742	PRJNA908278_P_NODE_19224_length_292_cov_1.406393_g19121_i0	PRJNA908278	19224	292	1.406393	4.10666756	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	180	1.19e-40	NTclustered	gi\|1778034411\|ref\|XM_031698677.1\|	6105	g19121	i0	81.776	14.5821917808219	214	39	73	0	1	214	325	112	PREDICTED: Actinia tenebrosa RING-box protein 1 (LOC116291507), mRNA	blastn	4258	180	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
5993560	5993560	PRJNA908278_P_NODE_29485_length_248_cov_0.880000_g29382_i0	PRJNA908278	29485	248	0.88	2.1824	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940703\|emb\|OZ237559.1\|	6108	g29382	i0	89.362	0.415322580645161	47	2	19	3	52	97	1502654	1502610	Anemonia sulcata genome assembly, chromosome: 5	blastn	103	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
12369512	12369512	PRJNA908278_P_NODE_35910_length_233_cov_2.050000_g35807_i0	PRJNA908278	35910	233	2.05	4.7765	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	161	3.32e-35	NTclustered	gi\|2782887107\|ref\|XM_067065305.1\|	252671	g35807	i0	80.176	4.75107296137339	227	35	95	9	10	231	604	383	PREDICTED: Clytia hemisphaerica cathepsin L-like (LOC136808767), mRNA	blastn	1107	161	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
21292214	21292214	PRJNA908278_P_NODE_25957_length_253_cov_1.577778_g25854_i0	PRJNA908278	25957	253	1.577778	3.99177834	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	65.8	2.95e-6	NTclustered	gi\|2917940731\|emb\|OZ237564.1\|	6108	g25854	i0	97.368	0.482213438735178	38	1	15	0	199	236	13053373	13053336	Anemonia sulcata genome assembly, chromosome: 10	blastn	122	65.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
22567305	22567305	PRJNA908278_P_NODE_16118_length_315_cov_1.909091_g16015_i0	PRJNA908278	16118	315	1.909091	6.01363665	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	60.2	1.76e-4	NTclustered	gi\|2917940703\|emb\|OZ237559.1\|	6108	g16015	i0	92.683	0.520634920634921	41	3	13	0	66	106	15021699	15021739	Anemonia sulcata genome assembly, chromosome: 5	blastn	164	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
23842413	23842413	PRJNA908278_P_NODE_17119_length_307_cov_3.290598_g17016_i0	PRJNA908278	17119	307	3.290598	10.10213586	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	237	7.37e-58	NTclustered	gi\|1619683066\|ref\|XM_021056012.2\|	2652724	g17016	i0	83.142	16.2801302931596	261	43	85	1	46	305	116	376	PREDICTED: Exaiptasia diaphana RING-box protein 1 (LOC110249442), mRNA	blastn	4998	237	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana

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