metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA493244" 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
3008072	3008072	PRJNA493244_P_NODE_592163_length_647_cov_3.848123_g570723_i0	PRJNA493244	592163	647	3.848123	24.89735581	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	58.4	0.001	NTclustered	gi\|2918369537\|emb\|OZ237719.1\|	317547	g570723	i0	100	0.0479134466769706	31	0	5	0	53	83	9959519	9959549	Eunicella cavolini genome assembly, chromosome: 3	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
7477799	7477799	PRJNA493244_P_NODE_1444786_length_256_cov_3.266667_g1421661_i0	PRJNA493244	1444786	256	3.266667	8.36266752	Metazoa	33208	Cnidaria	other_Eukaryota	87.9	6.38e-13	NTclustered	gi\|2257797986\|ref\|XR_007306929.1\|	45351	g1421661	i0	78.832	2.26171875	137	24	52	5	83	216	1596	1730	PREDICTED: Nematostella vectensis large subunit ribosomal RNA (LOC125560852), rRNA	blastn	579	87.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
8108259	8108259	PRJNA493244_P_NODE_1203647_length_327_cov_16.477444_g1180523_i0	PRJNA493244	1203647	327	16.477444	53.88124188	Sphaeromyxa zaharoni	275449	Cnidaria	other_Eukaryota	60.2	1.84e-4	NTclustered	gi\|2663986569\|emb\|OY751524.1\|	275449	g1180523	i0	100	2.03669724770642	32	0	10	0	141	172	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
10660631	10660631	PRJNA493244_P_NODE_365409_length_882_cov_3.359318_g348044_i0	PRJNA493244	365409	882	3.359318	29.62918476	Acropora millepora	45264	Cnidaria	other_Eukaryota	56.5	0.007	NTclustered	gi\|2113699879\|ref\|XM_029324960.2\|	45264	g348044	i0	100	0.0680272108843537	30	0	3	0	546	575	1287	1258	PREDICTED: Acropora millepora uncharacterized LOC114948400 (LOC114948400), transcript variant X2, mRNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
13211313	13211313	PRJNA493244_P_NODE_818291_length_496_cov_12.850575_g795553_i0	PRJNA493244	818291	496	12.850575	63.738852	Nynantheae gen. sp.	86627	Cnidaria	other_Eukaryota	124	1.0099999999999999e-23	NTclustered	gi\|5441269\|gb\|AF052880.1\|AF052880	86627	g795553	i0	80.368	26.0745967741935	163	30	33	2	333	495	284	444	Nynantheae gen. sp. 18S ribosomal RNA gene, partial sequence	blastn	12933	124	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria			Nynantheae gen. sp.
15758625	15758625	PRJNA493244_P_NODE_1554553_length_230_cov_2.402367_g1531428_i0	PRJNA493244	1554553	230	2.402367	5.5254441	Acropora millepora	45264	Cnidaria	other_Eukaryota	52.8	0.021	NTclustered	gi\|2114281215\|ref\|XR_006396569.1\|	45264	g1531428	i0	100	0.608695652173913	28	0	12	0	1	28	549	522	PREDICTED: Acropora millepora uncharacterized LOC114963031 (LOC114963031), transcript variant X2, ncRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
17033223	17033223	PRJNA493244_P_NODE_1527994_length_236_cov_2.731429_g1504869_i0	PRJNA493244	1527994	236	2.731429	6.44617244	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	86.1	2.09e-12	NTclustered	gi\|1270070985\|ref\|XR_002695435.1\|	50429	g1504869	i0	89.552	1.13135593220339	67	7	28	0	134	200	173	107	PREDICTED: Stylophora pistillata uncharacterized LOC111336533 (LOC111336533), ncRNA	blastn	267	86.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
20857127	20857127	PRJNA493244_P_NODE_1373737_length_275_cov_18.626168_g1350612_i0	PRJNA493244	1373737	275	18.626168	51.221962	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2918369563\|emb\|OZ237729.1\|	317547	g1350612	i0	100	0.109090909090909	30	0	11	0	69	98	2245311	2245340	Eunicella cavolini genome assembly, chromosome: 13	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
22131633	22131633	PRJNA493244_P_NODE_1224738_length_320_cov_5.193050_g1201614_i0	PRJNA493244	1224738	320	5.19305	16.61776	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.03	NTclustered	gi\|2917940703\|emb\|OZ237559.1\|	6108	g1201614	i0	100	0.0875	28	0	9	0	223	250	16207692	16207719	Anemonia sulcata genome assembly, chromosome: 5	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
23408080	23408080	PRJNA493244_P_NODE_1510459_length_240_cov_3.139665_g1487334_i0	PRJNA493244	1510459	240	3.139665	7.535196	Pocillopora damicornis	46731	Cnidaria	other_Eukaryota	52.8	0.022	NTclustered	gi\|1524878826\|ref\|XM_027191205.1\|	46731	g1487334	i0	100	0.583333333333333	28	0	12	0	42	69	1704	1731	PREDICTED: Pocillopora damicornis D(5)-like dopamine receptor (LOC113674721), transcript variant X2, mRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
25326460	25326460	PRJNA493244_P_NODE_912140_length_447_cov_37.865285_g889166_i0	PRJNA493244	912140	447	37.865285	169.25782395	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.043	NTclustered	gi\|2744789683\|ref\|XM_065821175.1\|	6087	g889166	i0	100	1.12751677852349	28	0	6	0	62	89	4051	4078	PREDICTED: Hydra vulgaris rho GTPase-activating protein 20 (LOC100199718), transcript variant X14, mRNA	blastn	504	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris

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