metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA745553" 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
2000436	2000436	PRJNA745553_S_NODE_4562_length_520_cov_2.724832_g4372_i0	PRJNA745553	4562	520	2.724832	14.1691264	Ceratomyxa arcuata	1578846	Cnidaria	other_Eukaryota	104	1.39e-17	NTclustered	gi\|728851402\|gb\|KJ419342.1\|	1578846	g4372	i0	87.097	0.178846153846154	93	10	18	2	54	146	399	309	Ceratomyxa arcuata isolate 302 large subunit ribosomal RNA gene, partial sequence	blastn	93	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Ceratomyxidae	Ceratomyxa	Ceratomyxa arcuata
3275463	3275463	PRJNA745553_S_NODE_17983_length_291_cov_2.435780_g17788_i0	PRJNA745553	17983	291	2.43578	7.0881198	Ceratomyxa ayami	1579381	Cnidaria	other_Eukaryota	58.4	5.79e-4	NTclustered	gi\|730837045\|gb\|KM392429.1\|	1579381	g17788	i0	100	0.302405498281787	31	0	11	0	75	105	1206	1236	Ceratomyxa ayami isolate LJ-Lepto 28S ribosomal RNA gene, partial sequence	blastn	88	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Ceratomyxidae	Ceratomyxa	Ceratomyxa ayami
3750434	3750434	PRJNA745553_S_NODE_29823_length_213_cov_2.685714_g29628_i0	PRJNA745553	29823	213	2.685714	5.72057082	Myxobolidae	35587	Cnidaria	other_Eukaryota	84.2	6.65e-12	NTclustered	gi\|384482801\|gb\|JQ690376.1\|	378740	g29628	i0	88.571	28.5586854460094	70	6	32	2	79	147	2166	2098	Henneguya doneci isolate 8-3 28S ribosomal RNA gene, partial sequence	blastn	6083	84.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya doneci
4552819	4552819	PRJNA745553_S_NODE_28264_length_231_cov_2.436709_g28069_i0	PRJNA745553	28264	231	2.436709	5.62879779	Sphaeromyxa zaharoni	275449	Cnidaria	other_Eukaryota	60.2	1.23e-4	NTclustered	gi\|2663986569\|emb\|OY751524.1\|	275449	g28069	i0	100	2.88311688311688	32	0	14	0	134	165	6365	6334	Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences	blastn	666	60.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Sphaeromyxidae	Sphaeromyxa	Sphaeromyxa zaharoni
5827787	5827787	PRJNA745553_S_NODE_19785_length_278_cov_1.882927_g19590_i0	PRJNA745553	19785	278	1.882927	5.23453706	Kudoa carcharhini	858677	Cnidaria	other_Eukaryota	73.1	1.96e-8	NTclustered	gi\|300089085\|gb\|GU446630.1\|	858677	g19590	i0	92.157	13.9352517985612	51	4	18	0	204	254	88	38	Kudoa carcharhini isolate Cc1 28S ribosomal RNA gene, partial sequence	blastn	3874	73.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Multivalvulida	Kudoidae	Kudoa	Kudoa carcharhini
9652680	9652680	PRJNA745553_S_NODE_23988_length_252_cov_4.000000_g23793_i0	PRJNA745553	23988	252	4	10.08	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2918369535\|emb\|OZ237717.1\|	317547	g23793	i0	96.875	0.126984126984127	32	0	12	1	172	202	78621514	78621483	Eunicella cavolini genome assembly, chromosome: 1	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
22876197	22876197	PRJNA745553_S_NODE_24958_length_248_cov_3.382857_g24763_i0	PRJNA745553	24958	248	3.382857	8.38948536	Opisthokonta	33154	Cnidaria	other_Eukaryota	63.9	1.04e-5	NTclustered	gi\|2917940724\|emb\|OZ237563.1\|	6108	g24763	i0	100	134.286290322581	34	0	14	0	1	34	10560016	10560049	Anemonia sulcata genome assembly, chromosome: 9	blastn	33303	63.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata

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