metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1104180" 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
1020246	1020246	PRJNA1104180_P_NODE_27241_length_232_cov_18.610063_g27098_i0	PRJNA1104180	27241	232	18.610063	43.17534616	Ammonia	29189	SAR_Eukaryotes	SAR_Eukaryotes	248	2.47e-61	NTclustered	gi\|155970688\|gb\|EF534072.1\|	460812	g27098	i0	91.351	57.6422413793103	185	11	80	3	31	215	770	949	Ammonia sp. JP-2007 small subunit ribosomal RNA gene, complete sequence	blastn	13373	250	0.992	Eukaryota	Sar	Foraminifera	Rotaliida	Rotaliidae	Ammonia	Ammonia sp. JP-2007
4848347	4848347	PRJNA1104180_P_NODE_27164_length_234_cov_2.068323_g27021_i0	PRJNA1104180	27164	234	2.068323	4.83987582	Rotaliida	29185	SAR_Eukaryotes	SAR_Eukaryotes	235	1.94e-57	NTclustered	gi\|998623043\|dbj\|LC049322.1\|	51039	g27021	i0	92.683	12.8376068376068	164	11	83	1	1	164	4042	4204	Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89	blastn	3004	237	0.991561181434599	Eukaryota	Sar	Foraminifera	Rotaliida	Globorotaliidae	Neogloboquadrina	Neogloboquadrina dutertrei
6123355	6123355	PRJNA1104180_P_NODE_22885_length_246_cov_3.456647_g22742_i0	PRJNA1104180	22885	246	3.456647	8.50335162	Rotaliida	29185	SAR_Eukaryotes	SAR_Eukaryotes	171	5.879999999999999e-38	NTclustered	gi\|998623043\|dbj\|LC049322.1\|	51039	g22742	i0	91.27	9.22357723577236	126	10	51	1	121	246	3689	3565	Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89	blastn	2269	171	1	Eukaryota	Sar	Foraminifera	Rotaliida	Globorotaliidae	Neogloboquadrina	Neogloboquadrina dutertrei
9948489	9948489	PRJNA1104180_P_NODE_24248_length_244_cov_1.561404_g24105_i0	PRJNA1104180	24248	244	1.561404	3.80982576	Rotaliida	29185	SAR_Eukaryotes	SAR_Eukaryotes	134	7.640000000000001e-27	NTclustered	gi\|998623043\|dbj\|LC049322.1\|	51039	g24105	i0	81.667	34.0081967213115	180	16	92	10	1	165	3156	2979	Neogloboquadrina dutertrei gene for 28S rRNA, partial sequence, isolate: 11-9-T89	blastn	8298	134	1	Eukaryota	Sar	Foraminifera	Rotaliida	Globorotaliidae	Neogloboquadrina	Neogloboquadrina dutertrei
12499049	12499049	PRJNA1104180_P_NODE_11770_length_299_cov_3.331858_g11628_i0	PRJNA1104180	11770	299	3.331858	9.96225542	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	267	9.12e-67	NTclustered	gi\|14140045\|emb\|AJ311216.1\|	159868	g11628	i0	85.252	60.0635451505017	278	19	93	17	1	277	1105	849	Hemisphaerammina bradyi partial 18S rRNA gene, isolate 1439	blastn	17959	267	1	Eukaryota	Sar	Foraminifera	Astrorhizida	Saccamminidae	Hemisphaerammina	Hemisphaerammina bradyi

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