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

5 rows where bioproject = "PRJEB673" 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
6512988	6512988	PRJEB673_P_NODE_1326_length_822_cov_2.395172_g1108_i0	PRJEB673	1326	822	2.395172	19.68831384	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	317	3.93e-105	NR	KAG7353846.1	303405	g1108	i0	77.8	7.65328467153285	194	43	70.8	0	796	215	3	196	KAG7353846.1 30S ribosomal protein S2 [Nitzschia inconspicua]	diamond	6291	317	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
12888549	12888549	PRJEB673_P_NODE_9751_length_188_cov_1.575163_g9402_i0	PRJEB673	9751	188	1.575163	2.96130644	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	100	4.67e-25	NR	KAG7346278.1	303405	g9402	i0	80.6	0.98936170212766	62	12	98.9	0	187	2	50	111	KAG7346278.1 ribosomal protein L6e [Nitzschia inconspicua]	diamond	186	100	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
21811621	21811621	PRJEB673_P_NODE_10098_length_181_cov_1.027397_g9749_i0	PRJEB673	10098	181	1.027397	1.85958857	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	219	1.4299999999999996e-52	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g9749	i0	88.462	1.51381215469613	182	19	100	2	1	181	374	194	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	274	219	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
28044808	28044808	PRJEB673_P_NODE_12165_length_155_cov_2.250000_g11816_i0	PRJEB673	12165	155	2.25	3.4875	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	68.2	1.17e-11	NR	KAL3822236.1	382380	g11816	i0	60	2.90322580645161	50	20	96.8	0	151	2	271	320	KAL3822236.1 hypothetical protein ACHAXA_005869 [Cyclostephanos tholiformis]	diamond	450	68.2	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
32310670	32310670	PRJEB673_P_NODE_8379_length_281_cov_1.621951_g8030_i0	PRJEB673	8379	281	1.621951	4.55768231	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	46.6	3.38e-4	NR	KAK1743969.1	267567	g8030	i0	63.3	1.60142348754448	30	11	32	0	280	191	59	88	KAK1743969.1 60S ribosomal protein L38 [Skeletonema marinoi]	diamond	450	46.6	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);;