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

5 rows where analysis = "blastn", bioproject = "PRJNA437204" 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
4259110	4259110	PRJNA437204_P_NODE_15064_length_458_cov_2.064935_g14765_i0	PRJNA437204	15064	458	2.064935	9.4574023	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	363	1.8099999999999994e-95	NTclustered	gi\|657012369\|gb\|KF302532.1\|	2850	g14765	i0	94.85	8.41703056768559	233	11	51	1	92	324	10	241	Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds	blastn	3855	363	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
11910442	11910442	PRJNA437204_P_NODE_11150_length_515_cov_1.393665_g10852_i0	PRJNA437204	11150	515	1.393665	7.17737475	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	459	2.54e-124	NTclustered	gi\|657012511\|gb\|KF302595.1\|	2850	g10852	i0	92.547	11.6912621359223	322	21	62	2	183	501	3	324	Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds	blastn	6021	459	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
13187217	13187217	PRJNA437204_P_NODE_911_length_1341_cov_2.511830_g775_i0	PRJNA437204	911	1341	2.51183	33.6836403	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	856	0	NTclustered	gi\|657012465\|gb\|KF302574.1\|	2850	g775	i0	97.047	50.0395227442207	508	15	38	0	829	1336	1	508	Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds	blastn	67103	856	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
15734694	15734694	PRJNA437204_P_NODE_14233_length_468_cov_2.339241_g13934_i0	PRJNA437204	14233	468	2.339241	10.94764788	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	62.1	7.56e-5	NTclustered	gi\|219118737\|ref\|XM_002180100.1\|	556484	g13934	i0	97.222	0.224358974358974	36	1	8	0	193	228	65	30	Phaeodactylum tricornutum CCAP 1055/1 predicted protein partial mRNA	blastn	105	62.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
22108942	22108942	PRJNA437204_P_NODE_27898_length_365_cov_2.842466_g27599_i0	PRJNA437204	27898	365	2.842466	10.3750009	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	370	8.42e-98	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g27599	i0	97.674	1.05479452054795	215	5	59	0	1	215	176	390	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	385	370	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum

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