metadata: contig_metadata: 5 rows where bioproject = "PRJNA339266" and tax

5 rows where bioproject = "PRJNA339266" 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
2345198	2345198	PRJNA339266_S_NODE_7982_length_190_cov_1.960784_g7971_i0	PRJNA339266	7982	190	1.960784	3.7254896	Metazoa	33208	Cnidaria	other_Eukaryota	63.9	7.54e-6	NTclustered	gi\|2744778600\|ref\|XM_047274539.2\|	6087	g7971	i0	95.122	10.0526315789474	41	1	21	1	115	154	1605	1645	PREDICTED: Hydra vulgaris amyloid-beta-like protein (LOC100201890), transcript variant X1, mRNA	blastn	1910	63.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
16968972	16968972	PRJNA339266_S_NODE_4574_length_219_cov_2.604396_g4563_i0	PRJNA339266	4574	219	2.604396	5.70362724	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	52.8	0.019	NTclustered	gi\|2751547462\|ref\|XM_066166458.1\|	203993	g4563	i0	100	0.127853881278539	28	0	13	0	53	80	708	735	PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC136280768), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
20792741	20792741	PRJNA339266_P_NODE_7177_length_163_cov_6.920635_g7147_i0	PRJNA339266	7177	163	6.920635	11.28063505	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	54.7	0.004	NTclustered	gi\|2917940759\|emb\|OZ237572.1\|	6108	g7147	i0	100	0.177914110429448	29	0	18	0	135	163	10980753	10980725	Anemonia sulcata genome assembly, chromosome: 18	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
27264415	27264415	PRJNA339266_S_NODE_12123_length_171_cov_1.417910_g12112_i0	PRJNA339266	12123	171	1.41791	2.4246261	Acropora millepora	45264	Cnidaria	other_Eukaryota	58.2	1.65e-8	NR	XP_029191643.2	45264	g12112	i0	60.5	3.78947368421053	43	10	75.4	1	168	40	143	178	XP_029191643.2 ADP-ribosylation factor-like protein 3 [Acropora millepora]	diamond	648	58.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
27643557	27643557	PRJNA339266_S_NODE_5444_length_210_cov_1.699422_g5433_i0	PRJNA339266	5444	210	1.699422	3.5687862	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	43.9	0.01	NR	CAB4025004.1	317549	g5433	i0	43.2	0.628571428571429	44	25	62.9	0	207	76	597	640	CAB4025004.1 Transposon TX1 uncharacterized 149 kDa, partial [Paramuricea clavata]	diamond	132	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata

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