metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1156092" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1156092" 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
302781	302781	PRJNA1156092_P_NODE_22141_length_251_cov_0.865169_g22011_i0	PRJNA1156092	22141	251	0.865169	2.17157419	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	193	1.28e-44	NTclustered	gi\|2202645792\|ref\|XM_046996420.1\|	2897299	g22011	i0	82.432	7.36653386454183	222	37	88	2	31	251	369	149	PREDICTED: Xenia sp. Carnegie-2017 RING-box protein 1-like (LOC124445670), mRNA	blastn	1849	193	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
9230821	9230821	PRJNA1156092_P_NODE_23528_length_250_cov_0.870056_g23398_i0	PRJNA1156092	23528	250	0.870056	2.17514	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2257864996\|ref\|XM_001628341.3\|	45351	g23398	i0	100	0.112	28	0	11	0	161	188	394	421	PREDICTED: Nematostella vectensis progestin and adipoQ receptor family member 3 (LOC5507734), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
13056650	13056650	PRJNA1156092_P_NODE_5531_length_444_cov_1.326146_g5401_i0	PRJNA1156092	5531	444	1.326146	5.88808824	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	244	6.600000000000002e-60	NTclustered	gi\|2518998737\|ref\|XM_057450856.1\|	13093	g5401	i0	84.127	135.540540540541	252	40	57	0	193	444	532	281	PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA	blastn	60180	244	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
18154654	18154654	PRJNA1156092_P_NODE_28355_length_245_cov_0.895349_g28225_i0	PRJNA1156092	28355	245	0.895349	2.19360505	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	220	5.73e-53	NTclustered	gi\|2744801597\|ref\|XM_012699221.3\|	6087	g28225	i0	82.927	8.84489795918367	246	40	100	2	1	245	1827	2071	PREDICTED: Hydra vulgaris transitional endoplasmic reticulum ATPase (LOC100205318), mRNA	blastn	2167	220	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
22714150	22714150	PRJNA1156092_P_NODE_22818_length_250_cov_1.305085_g22688_i0	PRJNA1156092	22818	250	1.305085	3.2627125	Acropora	6127	Cnidaria	other_Eukaryota	189	1.6499999999999999e-43	NTclustered	gi\|2114098761\|ref\|XM_029328531.2\|	45264	g22688	i0	83.582	19.176	201	33	80	0	7	207	278	78	PREDICTED: Acropora millepora tubulin beta-4B chain-like (LOC114952563), mRNA	blastn	4794	189	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora

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