metadata: contig_metadata: 12 rows where bioproject = "PRJNA630162" and tax

12 rows where bioproject = "PRJNA630162" and tax_phylum = "Foraminifera"

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_order	tax_family	tax_genus	tax_species
2426322	2426322	PRJNA630162_P_NODE_108222_length_181_cov_0.954545_g106699_i0	PRJNA630162	108222	181	0.954545	1.72772645	Rotaliida	29185	SAR_Eukaryotes	SAR_Eukaryotes	87.9	4.21e-13	NTclustered	gi\|998623043\|dbj\|LC049322.1\|	51039	g106699	i0	92.063	5.69613259668508	63	3	34	2	51	112	4248	4309	Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89	blastn	1031	87.9	1	Eukaryota	Sar	Foraminifera	Rotaliida	Globorotaliidae	Neogloboquadrina	Neogloboquadrina dutertrei
4430346	4430346	PRJNA630162_P_NODE_76204_length_206_cov_1.700637_g74681_i0	PRJNA630162	76204	206	1.700637	3.50331222	Trochammina sp.	37356	SAR_Eukaryotes	SAR_Eukaryotes	246	7.7e-61	NTclustered	gi\|619567\|emb\|Z30147.1\|	37356	g74681	i0	89.691	57.2572815533981	194	18	94	2	3	196	1742	1551	T.sp. gene for 28S ribosomal RNA	blastn	11795	246	1	Eukaryota	Sar	Foraminifera	Textulariida	Trochamminidae	Trochammina	Trochammina sp.
5706436	5706436	PRJNA630162_P_NODE_93665_length_189_cov_2.714286_g92142_i0	PRJNA630162	93665	189	2.714286	5.13000054	Foraminifera environmental sample	185789	SAR_Eukaryotes	SAR_Eukaryotes	283	5.28e-72	NTclustered	gi\|28194285\|gb\|AF474144.1\|	185789	g92142	i0	95	52.4656084656085	180	9	95	0	1	180	769	590	Uncultured Foraminifera clone Cha 5A4 small subunit ribosomal RNA gene, partial sequence	blastn	9916	283	1	Eukaryota	Sar	Foraminifera				Foraminifera environmental sample
13355612	13355612	PRJNA630162_P_NODE_106711_length_181_cov_3.242424_g105188_i0	PRJNA630162	106711	181	3.242424	5.86878744	Allogromida sp. 2 MH-2012	1238470	SAR_Eukaryotes	SAR_Eukaryotes	150	5.299999999999999e-32	NTclustered	gi\|559105587\|emb\|HE998686.1\|	1238470	g105188	i0	81.868	1.00552486187845	182	29	99	4	2	180	704	884	Allogromida sp. 2 MH-2012 partial 18s rRNA gene, isolate 12323	blastn	182	150	1	Eukaryota	Sar	Foraminifera				Allogromida sp. 2 MH-2012
13356323	13356323	PRJNA630162_P_NODE_27751_length_345_cov_2.479730_g26229_i0	PRJNA630162	27751	345	2.47973	8.5550685	Allogromida sp. 2 MH-2012	1238470	SAR_Eukaryotes	SAR_Eukaryotes	326	1.74e-84	NTclustered	gi\|559105587\|emb\|HE998686.1\|	1238470	g26229	i0	92.952	67.6434782608696	227	10	81	4	121	345	352	574	Allogromida sp. 2 MH-2012 partial 18s rRNA gene, isolate 12323	blastn	23337	326	1	Eukaryota	Sar	Foraminifera				Allogromida sp. 2 MH-2012
22828570	22828570	PRJNA630162_P_NODE_125578_length_171_cov_2.950820_g124055_i0	PRJNA630162	125578	171	2.95082	5.0459022	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	182	1.75e-41	NTclustered	gi\|259090635\|gb\|FJ705892.1\|	674485	g124055	i0	99.01	59.6432748538012	101	1	59	0	2	102	2233	2133	Rotaliida sp. F20 small subunit ribosomal RNA gene, complete sequence	blastn	10199	183	0.994535519125683	Eukaryota	Sar	Foraminifera	Rotaliida			Rotaliida sp. F20
23554172	23554172	PRJNA630162_P_NODE_130879_length_169_cov_1.500000_g129356_i0	PRJNA630162	130879	169	1.5	2.535	Allogromida sp. 2 MH-2012	1238470	SAR_Eukaryotes	SAR_Eukaryotes	126	8.2e-25	NTclustered	gi\|559105587\|emb\|HE998686.1\|	1238470	g129356	i0	84.091	0.781065088757396	132	19	77	2	2	131	884	753	Allogromida sp. 2 MH-2012 partial 18s rRNA gene, isolate 12323	blastn	132	126	1	Eukaryota	Sar	Foraminifera				Allogromida sp. 2 MH-2012
29587755	29587755	PRJNA630162_P_NODE_102850_length_184_cov_1.355556_g101327_i0	PRJNA630162	102850	184	1.355556	2.49422304	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.5	2.83e-12	NR	ETO26066.1	46433	g101327	i0	52.6	4.67934782608696	57	26	92.9	1	178	8	426	481	ETO26066.1 SET domain containing protein [Reticulomyxa filosa]	diamond	861	70.9	0.994358251057828	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29764742	29764742	PRJNA630162_P_NODE_72971_length_210_cov_2.720497_g71448_i0	PRJNA630162	72971	210	2.720497	5.7130437	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	48.5	2.1e-4	NR	ETO27253.1	46433	g71448	i0	71.4	0.914285714285714	28	8	40	0	6	89	170	197	ETO27253.1 hypothetical protein RFI_09882, partial [Reticulomyxa filosa]	diamond	192	48.5	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30112169	30112169	PRJNA630162_P_NODE_131212_length_169_cov_1.325000_g129689_i0	PRJNA630162	131212	169	1.325	2.23925	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	55.5	4.21e-7	NR	ETO09817.1	46433	g129689	i0	92.9	1.47337278106509	28	2	49.7	0	85	2	3	30	ETO09817.1 Ras GTPase [Reticulomyxa filosa]	diamond	249	55.5	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31439405	31439405	PRJNA630162_P_NODE_118756_length_175_cov_1.555556_g117233_i0	PRJNA630162	118756	175	1.555556	2.722223	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	45.8	0.00119	NR	ETO04668.1	46433	g117233	i0	35.7	1.85142857142857	56	34	96	1	3	170	28	81	ETO04668.1 hypothetical protein RFI_32728, partial [Reticulomyxa filosa]	diamond	324	45.8	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32874456	32874456	PRJNA630162_P_NODE_70060_length_212_cov_3.239264_g68537_i0	PRJNA630162	70060	212	3.239264	6.86723968	Viridiplantae	33090	SAR_Eukaryotes	SAR_Eukaryotes	55.8	2.52e-7	NR	ETO28446.1	46433	g68537	i0	81.3	4.07547169811321	32	6	45.3	0	208	113	120	151	ETO28446.1 hybrid cluster protein [Reticulomyxa filosa]	diamond	864	55.8	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa

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