metadata: contig_metadata: 4 rows where bioproject = "PRJNA1226487", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA1226487", tax_kingdom = "Metazoa" 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
13088724	13088724	PRJNA1226487_P_NODE_70271_length_247_cov_0.885057_g70169_i0	PRJNA1226487	70271	247	0.885057	2.18609079	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	320	5.54e-83	NTclustered	gi\|2744816743\|ref\|XM_047280293.2\|	6087	g70169	i0	90.244	0.995951417004049	246	23	99	1	2	247	1476	1232	PREDICTED: Hydra vulgaris protein disulfide-isomerase A4 (LOC100204811), mRNA	blastn	246	320	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
22723724	22723724	PRJNA1226487_P_NODE_32698_length_308_cov_16.578723_g32596_i0	PRJNA1226487	32698	308	16.578723	51.06246684	Anthozoa	6101	Cnidaria	other_Eukaryota	435	2.4400000000000003e-117	NTclustered	gi\|2751533362\|ref\|XR_010716805.1\|	203993	g32596	i0	92.691	94.5779220779221	301	22	98	0	1	301	302	2	PREDICTED: Pocillopora verrucosa large subunit ribosomal RNA (LOC136279283), rRNA	blastn	29130	438	0.993150684931507	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
28336019	28336019	PRJNA1226487_P_NODE_32986_length_308_cov_1.089362_g32884_i0	PRJNA1226487	32986	308	1.089362	3.35523496	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	89	2.29e-19	NR	XP_004209547.2	6087	g32884	i0	51.8	0.827922077922078	85	41	82.8	0	51	305	1	85	XP_004209547.2 uncharacterized protein LOC101239388 [Hydra vulgaris]	diamond	255	89	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
32349276	32349276	PRJNA1226487_P_NODE_82919_length_196_cov_4.959350_g82817_i0	PRJNA1226487	82919	196	4.95935	9.720326	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	51.2	2.09e-5	NR	KXJ24236.1	2652724	g82817	i0	51.2	0.658163265306122	43	21	65.8	0	8	136	1140	1182	KXJ24236.1 Pre-mRNA-splicing factor ATP-dependent RNA helicase PRP16 [Exaiptasia diaphana]	diamond	129	51.2	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);;