metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA793147" 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
3328524	3328524	PRJNA793147_P_NODE_13563_length_464_cov_1.749367_g13297_i0	PRJNA793147	13563	464	1.749367	8.11706288	Aurantiactinomyxon sp. AUM-3	2184215	Cnidaria	other_Eukaryota	857	0	NTclustered	gi\|1387575735\|gb\|KY784583.1\|	2184215	g13297	i0	100	89.4978448275862	464	0	100	0	1	464	708	1171	Aurantiactinomyxon sp. AUM-3 18S ribosomal RNA gene, complete sequence.	blastn	41527	857	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa			Aurantiactinomyxon	Aurantiactinomyxon sp. AUM-3
4605764	4605764	PRJNA793147_P_NODE_14264_length_450_cov_15.960630_g13998_i0	PRJNA793147	14264	450	15.96063	71.822835	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	56.5	0.003	NTclustered	gi\|2519010430\|ref\|XM_057456658.1\|	13093	g13998	i0	96.97	0.146666666666667	33	1	7	0	138	170	829	861	PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130654126 (LOC130654126), mRNA	blastn	66	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
5881728	5881728	PRJNA793147_P_NODE_5825_length_752_cov_2.357247_g5582_i0	PRJNA793147	5825	752	2.357247	17.72649744	Zschokkella parasiluri	371530	Cnidaria	other_Eukaryota	1116	0	NTclustered	gi\|241911760\|gb\|FJ417066.1\|	371530	g5582	i0	93.484	62.8377659574468	752	48	100	1	1	752	1382	2132	Zschokkella parasiluri isolate M0172 28S large subunit ribosomal RNA gene, partial sequence	blastn	47254	1116	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Zschokkella	Zschokkella parasiluri
7155990	7155990	PRJNA793147_P_NODE_27346_length_318_cov_2.578313_g27080_i0	PRJNA793147	27346	318	2.578313	8.19903534	Aurantiactinomyxon sp. AUM-3	2184215	Cnidaria	other_Eukaryota	588	1.84e-163	NTclustered	gi\|1387575735\|gb\|KY784583.1\|	2184215	g27080	i0	100	99.1006289308176	318	0	100	0	1	318	49	366	Aurantiactinomyxon sp. AUM-3 18S ribosomal RNA gene, complete sequence.	blastn	31514	588	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa			Aurantiactinomyxon	Aurantiactinomyxon sp. AUM-3
14806112	14806112	PRJNA793147_P_NODE_23532_length_343_cov_1.576642_g23266_i0	PRJNA793147	23532	343	1.576642	5.40788206	Myxidium streisingeri	1542451	Cnidaria	other_Eukaryota	634	2.5299999999999996e-177	NTclustered	gi\|681870004\|gb\|KM001687.1\|	1542451	g23266	i0	100	42.7609329446064	343	0	100	0	1	343	429	87	Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence	blastn	14667	634	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Myxidium	Myxidium streisingeri
16080184	16080184	PRJNA793147_P_NODE_31053_length_300_cov_1.982684_g30787_i0	PRJNA793147	31053	300	1.982684	5.948052	Zschokkella parasiluri	371530	Cnidaria	other_Eukaryota	239	1.9999999999999993e-58	NTclustered	gi\|241911760\|gb\|FJ417066.1\|	371530	g30787	i0	81.25	23.9433333333333	304	49	100	7	1	300	807	508	Zschokkella parasiluri isolate M0172 28S large subunit ribosomal RNA gene, partial sequence	blastn	7183	239	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Zschokkella	Zschokkella parasiluri
16080555	16080555	PRJNA793147_P_NODE_49793_length_237_cov_1.714286_g49527_i0	PRJNA793147	49793	237	1.714286	4.06285782	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	104	5.79e-18	NTclustered	gi\|2744909790\|ref\|XM_065820117.1\|	6087	g49527	i0	86.458	2.24050632911392	96	11	40	2	96	190	341	435	PREDICTED: Hydra vulgaris guanine nucleotide-binding protein G(o) subunit alpha (LOC100204078), transcript variant X4, mRNA	blastn	531	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
21180728	21180728	PRJNA793147_P_NODE_58457_length_229_cov_0.900000_g58191_i0	PRJNA793147	58457	229	0.9	2.061	Bivalvulida gen. n. sp. a JO-2023	3073449	Cnidaria	other_Eukaryota	202	1.92e-47	NTclustered	gi\|2572825558\|gb\|OR509833.1\|	3073449	g58191	i0	92.308	54.0960698689956	143	9	62	2	43	185	475	615	Bivalvulida gen. n. sp. a JO-2023 isolate BM_02 large subunit ribosomal RNA gene, partial sequence	blastn	12388	202	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida			Bivalvulida gen. n. sp. a JO-2023
22454793	22454793	PRJNA793147_P_NODE_20958_length_364_cov_2.986441_g20692_i0	PRJNA793147	20958	364	2.986441	10.87064524	Zschokkella parasiluri	371530	Cnidaria	other_Eukaryota	379	1.39e-100	NTclustered	gi\|241911760\|gb\|FJ417066.1\|	371530	g20692	i0	85.831	46.7912087912088	367	41	100	10	1	364	3126	2768	Zschokkella parasiluri isolate M0172 28S large subunit ribosomal RNA gene, partial sequence	blastn	17032	379	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxidiidae	Zschokkella	Zschokkella parasiluri

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