metadata: contig_metadata: 5 rows where bioproject = "PRJEB14175" and tax

5 rows where bioproject = "PRJEB14175" 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
25644383	25644383	PRJEB14175_P_NODE_270626_length_189_cov_3.546875_g268358_i0	PRJEB14175	270626	189	3.546875	6.70359375	Rotaliella elatiana	35210	SAR_Eukaryotes	SAR_Eukaryotes	156	1.2e-33	NTclustered	gi\|643022\|emb\|X78521.1\|	35210	g268358	i0	86.395	16.3703703703704	147	14	76	4	17	159	3803	3947	R.elatiana complete gene of large subunit rRNA	blastn	3094	156	1	Eukaryota	Sar	Foraminifera	Rotaliida	Rotaliidae	Rotaliella	Rotaliella elatiana
26317688	26317688	PRJEB14175_P_NODE_112087_length_333_cov_12.286765_g109821_i0	PRJEB14175	112087	333	12.286765	40.91492745	Pulleniatina obliquiloculata	225066	SAR_Eukaryotes	SAR_Eukaryotes	303	7.85e-78	NTclustered	gi\|998623053\|dbj\|LC049332.1\|	225066	g109821	i0	87.319	49.2582582582583	276	21	79	12	14	276	3945	4219	Pulleniatina obliquiloculata gene for 28S rRNA, partial sequence, isolate: 11-9-T94	blastn	16403	303	1	Eukaryota	Sar	Foraminifera	Rotaliida	Pulleniatinidae	Pulleniatina	Pulleniatina obliquiloculata
26327969	26327969	PRJEB14175_P_NODE_80271_length_407_cov_15.369942_g78009_i0	PRJEB14175	80271	407	15.369942	62.55566394	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	177	8.339999999999998e-54	NR	ETO03070.1	46433	g78009	i0	79.4	1.57002457002457	107	22	78.9	0	392	72	81	187	ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa]	diamond	639	177	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32976803	32976803	PRJEB14175_P_NODE_110187_length_337_cov_3.695652_g107921_i0	PRJEB14175	110187	337	3.695652	12.45434724	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	108	7.69e-25	NR	ETO03404.1	46433	g107921	i0	69.9	0.649851632047478	73	22	65	0	95	313	413	485	ETO03404.1 hypothetical protein RFI_34006 [Reticulomyxa filosa]	diamond	219	108	1	Eukaryota	Sar	Foraminifera		Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
33130482	33130482	PRJEB14175_P_NODE_136511_length_294_cov_5.738197_g134244_i0	PRJEB14175	136511	294	5.738197	16.87029918	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	93.6	2.58e-20	NR	ETO27401.1	46433	g134244	i0	41.3	0.938775510204082	92	54	93.9	0	292	17	235	326	ETO27401.1 hypothetical protein RFI_09731 [Reticulomyxa filosa]	diamond	276	93.6	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);;