metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392284	392284	PRJNA340009_P_NODE_47621_length_187_cov_1.847826_g47314_i0	PRJNA340009	47621	187	1.847826	3.45543462	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	56.5	0.001	NTclustered	gi\|2918369558\|emb\|OZ237728.1\|	317547	g47314	i0	96.97	0.176470588235294	33	1	18	0	4	36	1794363	1794331	Eunicella cavolini genome assembly, chromosome: 12	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
1070043	1070043	PRJNA340009_P_NODE_39341_length_202_cov_56.222222_g39034_i0	PRJNA340009	39341	202	56.222222	113.56888844	Metazoa	33208	Cnidaria	other_Eukaryota	75	3.75e-9	NTclustered	gi\|2257873035\|ref\|XM_001636570.3\|	45351	g39034	i0	88.525	5.59405940594059	61	7	30	0	19	79	1433	1493	PREDICTED: Nematostella vectensis tubulin alpha-1A chain (LOC5516629), mRNA	blastn	1130	75	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
5495596	5495596	PRJNA340009_P_NODE_21285_length_263_cov_1.429907_g20978_i0	PRJNA340009	21285	263	1.429907	3.76065541	Heteropolypus sp.	3097316	Cnidaria	other_Eukaryota	150	8.279999999999998e-32	NTclustered	gi\|2689317291\|gb\|PP410741.1\|	3097316	g20978	i0	86.861	81.2319391634981	137	15	51	2	21	155	2188	2053	Heteropolypus sp. voucher RB-19-192 large subunit ribosomal RNA gene, partial sequence	blastn	21364	150	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleralcyonacea	Coralliidae	Heteropolypus	Heteropolypus sp.
10595729	10595729	PRJNA340009_P_NODE_24469_length_248_cov_1.025126_g24162_i0	PRJNA340009	24469	248	1.025126	2.54231248	cf. Latyspora sp. AK-2014	1483226	Cnidaria	other_Eukaryota	113	1.01e-20	NTclustered	gi\|605060085\|gb\|KF874225.1\|	1483226	g24162	i0	85.981	42.2096774193548	107	13	43	2	142	248	1067	963	Cf. Latyspora sp. AK-2014 28S ribosomal RNA gene, partial sequence	blastn	10468	113	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida			cf. Latyspora sp. AK-2014
13145967	13145967	PRJNA340009_P_NODE_5511_length_459_cov_4.495122_g5204_i0	PRJNA340009	5511	459	4.495122	20.63260998	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	335	3.9499999999999984e-87	NTclustered	gi\|1619698735\|ref\|XM_021060602.2\|	2652724	g5204	i0	81.5	83.3507625272331	400	70	87	4	11	408	25	422	PREDICTED: Exaiptasia diaphana histone H3 (LOC110253653), mRNA	blastn	38258	335	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
18243829	18243829	PRJNA340009_P_NODE_43755_length_193_cov_20.618056_g43448_i0	PRJNA340009	43755	193	20.618056	39.79284808	Malo kingi	500532	Cnidaria	other_Eukaryota	117	5.82e-22	NTclustered	gi\|265141568\|gb\|EU878255.1\|	500532	g43448	i0	86.792	5.73575129533679	106	12	54	2	87	191	2236	2132	Malo kingi clone Mk-BJA-1 non-muscle actin 6.2 mRNA, complete cds	blastn	1107	117	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Cubozoa	Carybdeida	Carukiidae	Malo	Malo kingi
18244116	18244116	PRJNA340009_P_NODE_735_length_1052_cov_11.444666_g524_i0	PRJNA340009	735	1052	11.444666	120.39788632	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	95.3	1.75e-14	NTclustered	gi\|2257858806\|ref\|XR_007306876.1\|	45351	g524	i0	95	5.57984790874525	60	3	6	0	492	551	3324	3383	PREDICTED: Nematostella vectensis large subunit ribosomal RNA (LOC125560793), rRNA	blastn	5870	95.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
23344295	23344295	PRJNA340009_P_NODE_56319_length_174_cov_1.632000_g56012_i0	PRJNA340009	56319	174	1.632	2.83968	Zanclea sp. ZX JRH-2014	1483213	Cnidaria	other_Eukaryota	89.8	1.12e-13	NTclustered	gi\|608606704\|gb\|KF962379.1\|	1483213	g56012	i0	89.855	34.7701149425287	69	7	40	0	6	74	3126	3194	Zanclea sp. ZX JRH-2014 voucher XMZS7 28S ribosomal RNA gene, partial sequence	blastn	6050	89.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Zancleidae	Zanclea	Zanclea sp. ZX JRH-2014

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