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

9 rows where analysis = "blastn", bioproject = "PRJNA855894" and tax_clade = "Sar"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
842310	842310	PRJNA855894_P_NODE_32501_length_245_cov_0.895349_g32379_i0	PRJNA855894	32501	245	0.895349	2.19360505	Symbiodinium kawagutii	104179	SAR_Eukaryotes	SAR_Eukaryotes	370	5.38e-98	NTclustered	gi\|512791359\|gb\|KC947981.1\|	104179	g32379	i0	93.878	39.734693877551	245	15	100	0	1	245	374	130	Symbiodinium kawagutii strain CCMP2468 clone SymkaFL1061064216428(5'-), partial sequence	blastn	9735	370	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium kawagutii
2117348	2117348	PRJNA855894_P_NODE_18322_length_354_cov_1.348754_g18200_i0	PRJNA855894	18322	354	1.348754	4.77458916	Symbiodinium kawagutii	104179	SAR_Eukaryotes	SAR_Eukaryotes	279	1.41e-70	NTclustered	gi\|512780837\|gb\|KC937459.1\|	104179	g18200	i0	83.072	53.8079096045198	319	42	90	9	7	324	262	569	Symbiodinium kawagutii strain CCMP2468 clone SymkaSLLR3-388, partial sequence	blastn	19048	279	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium kawagutii
3392979	3392979	PRJNA855894_P_NODE_31683_length_247_cov_0.885057_g31561_i0	PRJNA855894	31683	247	0.885057	2.18609079	Cladocopium sp. clade C	293275	SAR_Eukaryotes	SAR_Eukaryotes	237	5.74e-58	NTclustered	gi\|168989231\|gb\|DQ482992.1\|	2558455	g31561	i0	98.507	54.251012145749	134	2	54	0	3	136	158	291	Symbiodinium sp. clade C3 from Acropora aspera photosystem II 12 kDa extrinsic protein-like mRNA sequence	blastn	13400	237	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Cladocopium	Cladocopium sp. clade C
4670713	4670713	PRJNA855894_P_NODE_30304_length_250_cov_0.870056_g30182_i0	PRJNA855894	30304	250	0.870056	2.17514	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	462	8.83e-126	NTclustered	gi\|323690576\|gb\|GU935635.1\|	88167	g30182	i0	100	101.46	250	0	100	0	1	250	2556	2307	Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence	blastn	25365	462	1	Eukaryota	Sar		Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
8494874	8494874	PRJNA855894_P_NODE_19747_length_338_cov_1.162264_g19625_i0	PRJNA855894	19747	338	1.162264	3.92845232	Symbiodinium kawagutii	104179	SAR_Eukaryotes	SAR_Eukaryotes	448	3.479999999999999e-121	NTclustered	gi\|512781119\|gb\|KC937741.1\|	104179	g19625	i0	90.56	9.85798816568047	339	30	100	2	1	338	418	81	Symbiodinium kawagutii strain CCMP2468 clone SymkaSLLR3-670, partial sequence	blastn	3332	448	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium kawagutii
12321509	12321509	PRJNA855894_P_NODE_32010_length_246_cov_1.335260_g31888_i0	PRJNA855894	32010	246	1.33526	3.2847396	Symbiodinium kawagutii	104179	SAR_Eukaryotes	SAR_Eukaryotes	379	8.969999999999998e-101	NTclustered	gi\|512782479\|gb\|KC939101.1\|	104179	g31888	i0	94.672	29.869918699187	244	13	99	0	1	244	267	510	Symbiodinium kawagutii strain CCMP2468 clone SymkaFL1061064198017(5'-), partial sequence	blastn	7348	379	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium kawagutii
16145030	16145030	PRJNA855894_P_NODE_30953_length_248_cov_1.725714_g30831_i0	PRJNA855894	30953	248	1.725714	4.27977072	Symbiodinium kawagutii	104179	SAR_Eukaryotes	SAR_Eukaryotes	409	1.16e-109	NTclustered	gi\|512790723\|gb\|KC947345.1\|	104179	g30831	i0	96.371	16.9193548387097	248	9	100	0	1	248	524	277	Symbiodinium kawagutii strain CCMP2468 clone SymkaFL1061064217399(5'-), partial sequence	blastn	4196	409	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium kawagutii
18693643	18693643	PRJNA855894_P_NODE_31875_length_247_cov_0.885057_g31753_i0	PRJNA855894	31875	247	0.885057	2.18609079	Albugo laibachii	653948	SAR_Eukaryotes	SAR_Eukaryotes	403	5.35e-108	NTclustered	gi\|325194306\|emb\|FR825154.1\|	890382	g31753	i0	96	2.02429149797571	250	7	100	1	1	247	576	327	Albugo laibachii Nc14, genomic contig CONTIG_1768_NC14_v4_1575_58	blastn	500	403	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Albuginales	Albuginaceae	Albugo	Albugo laibachii
20361304	20361304	PRJNA855894_P_NODE_23716_length_300_cov_0.916300_g23594_i0	PRJNA855894	23716	300	0.9163	2.7489	Symbiodiniaceae	252141	SAR_Eukaryotes	SAR_Eukaryotes	516	8.23e-142	NTclustered	gi\|1171207\|gb\|U43532.1\|SSU43532	2950	g23594	i0	97.667	26.4566666666667	300	7	100	0	1	300	5874	5575	Symbiodinium sp. ribulosebisphosphate carboxylase form II polyprotein precursor (rbcA) gene, partial cds	blastn	7937	516	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium sp.

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