metadata: contig_metadata: 6 rows where bioproject = "PRJNA680334", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA680334", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

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
1925187	1925187	PRJNA680334_S_NODE_101222_length_153_cov_1.850000_g100736_i0	PRJNA680334	101222	153	1.85	2.8305	Pinnularia borealis	1089218	SAR_Eukaryotes	SAR_Eukaryotes	283	4.0799999999999995e-72	NTclustered	gi\|1509777192\|gb\|MH707916.1\|	1089218	g100736	i0	100	98.6797385620915	153	0	100	0	1	153	5	157	Pinnularia borealis voucher (Sterre6)a 28S ribosomal RNA gene, partial sequence	blastn	15098	283	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Pinnulariaceae	Pinnularia	Pinnularia borealis
13923313	13923313	PRJNA680334_S_NODE_6411_length_358_cov_243710.544615_g5925_i0	PRJNA680334	6411	358	243710.544615	872483.7497217	Hantzschia	186033	SAR_Eukaryotes	SAR_Eukaryotes	451	2.8600000000000003e-122	NTclustered	gi\|725539095\|gb\|KM407568.1\|	186034	g5925	i0	97.719	73.6256983240224	263	5	73	1	96	357	319	57	Hantzschia amphioxys isolate Ant025-E04 28S ribosomal RNA gene, partial sequence	blastn	26358	451	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Hantzschia	Hantzschia amphioxys
22846714	22846714	PRJNA680334_S_NODE_51898_length_189_cov_18.115385_g51412_i0	PRJNA680334	51898	189	18.115385	34.23807765	Nitzschia	2857	SAR_Eukaryotes	SAR_Eukaryotes	294	2.44e-75	NTclustered	gi\|2524387100\|emb\|OY101133.1\|	3034176	g51412	i0	94.709	194.275132275132	189	10	100	0	1	189	32047	31859	Nitzschia sp. pyKryTriq1 genome assembly, organelle: plastid:chloroplast	blastn	36718	294	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia sp. pyKryTriq1
27239911	27239911	PRJNA680334_S_NODE_33743_length_217_cov_1.717391_g33257_i0	PRJNA680334	33743	217	1.717391	3.72673847	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	79.3	2.14e-16	NR	GKY99837.1	2872254	g33257	i0	60.6	0.981566820276498	71	25	98.2	2	213	1	16	83	GKY99837.1 hypothetical protein MPSEU_000937500 [Mayamaea pseudoterrestris]	diamond	213	79.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
29734207	29734207	PRJNA680334_S_NODE_49850_length_192_cov_2.748428_g49364_i0	PRJNA680334	49850	192	2.748428	5.27698176	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	51.2	1.76e-5	NR	GKY95538.1	2872254	g49364	i0	48.3	0.9375	60	31	93.8	0	188	9	236	295	GKY95538.1 hypothetical protein MPSEU_000515400 [Mayamaea pseudoterrestris]	diamond	180	51.2	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
31262809	31262809	PRJNA680334_S_NODE_57815_length_183_cov_3.453333_g57329_i0	PRJNA680334	57815	183	3.453333	6.31959939	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	75.1	6.23e-14	NR	KAK1742141.1	267567	g57329	i0	82.9	6.55737704918033	41	7	67.2	0	2	124	425	465	KAK1742141.1 UDP-glucose 6-dehydrogenase [Skeletonema marinoi]	diamond	1200	75.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi

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