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

5 rows where bioproject = "PRJNA509429" 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
2386312	2386312	PRJNA509429_P_NODE_48342_length_157_cov_5.532787_g47514_i0	PRJNA509429	48342	157	5.532787	8.68647559	Plexauridae	44191	Cnidaria	other_Eukaryota	95.3	2.12e-15	NTclustered	gi\|2689317080\|gb\|PP410637.1\|	1329949	g47514	i0	93.548	4.71974522292994	62	4	39	0	96	157	3519	3580	Swiftia koreni voucher USNM:55966 large subunit ribosomal RNA gene, partial sequence	blastn	741	95.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Swiftia	Swiftia koreni
4312149	4312149	PRJNA509429_P_NODE_36224_length_195_cov_1.250000_g35396_i0	PRJNA509429	36224	195	1.25	2.4375	Eutima gegenbauri	661993	Cnidaria	other_Eukaryota	82.4	2.15e-11	NTclustered	gi\|256674552\|gb\|FJ550456.1\|	661993	g35396	i0	78.169	18.5846153846154	142	22	72	8	1	141	1537	1670	Eutima gegenbauri voucher MHNG INVE31748 28S ribosomal RNA gene, partial sequence	blastn	3624	82.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Eirenidae	Eutima	Eutima gegenbauri
14514191	14514191	PRJNA509429_P_NODE_41512_length_176_cov_1.702128_g40684_i0	PRJNA509429	41512	176	1.702128	2.99574528	Acropora millepora	45264	Cnidaria	other_Eukaryota	52.8	0.015	NTclustered	gi\|2113840228\|ref\|XM_029337221.2\|	45264	g40684	i0	100	0.159090909090909	28	0	16	0	142	169	2064	2091	PREDICTED: Acropora millepora histone-lysine N-methyltransferase SMYD3-like (LOC114959269), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
21512750	21512750	PRJNA509429_P_NODE_42237_length_174_cov_1.546763_g41409_i0	PRJNA509429	42237	174	1.546763	2.69136762	Cnidaria	6073	Cnidaria	other_Eukaryota	84.2	5.19e-12	NTclustered	gi\|1347759492\|gb\|MG979310.1\|	1911533	g41409	i0	75.429	20.7528735632184	175	41	100	2	1	174	1404	1577	Cunina octonaria isolate DLSI188 voucher KT07-18_ORI-2-E large subunit ribosomal RNA gene, partial sequence	blastn	3611	84.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Narcomedusae	Cuninidae	Cunina	Cunina octonaria
29350895	29350895	PRJNA509429_P_NODE_44629_length_167_cov_1.515152_g43801_i0	PRJNA509429	44629	167	1.515152	2.53030384	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	46.2	8.02e-4	NR	CAB4024523.1	317549	g43801	i0	62.2	3.32335329341317	37	14	66.5	0	161	51	715	751	CAB4024523.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	555	46.2	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);;