metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB11523" 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
27948793	27948793	PRJEB11523_P_NODE_3265_length_275_cov_2.340708_g3187_i0	PRJEB11523	3265	275	2.340708	6.436947	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	122	1.25e-30	NR	CAB9531516.1	568900	g3187	i0	61.9	1.85454545454545	84	32	91.6	0	1	252	148	231	CAB9531516.1 osmC-like protein [Seminavis robusta]	diamond	510	122	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
28037491	28037491	PRJEB11523_P_NODE_3725_length_251_cov_2.801980_g3647_i0	PRJEB11523	3725	251	2.80198	7.0329698	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	142	1.54e-39	NR	KAG7356896.1	303405	g3647	i0	89.9	4.72111553784861	79	8	94.4	0	14	250	230	308	KAG7356896.1 mitochondrial carrier protein [Nitzschia inconspicua]	diamond	1185	142	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
28043493	28043493	PRJEB11523_P_NODE_1785_length_416_cov_2.275204_g1707_i0	PRJEB11523	1785	416	2.275204	9.46484864	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	46.6	9.11e-4	NR	EJK58442.1	159749	g1707	i0	64.9	0.266826923076923	37	13	26.7	0	273	383	24	60	EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica]	diamond	111	46.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica
28706657	28706657	PRJEB11523_P_NODE_5807_length_192_cov_2.650350_g5729_i0	PRJEB11523	5807	192	2.65035	5.088672	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	65.5	5.84e-11	NR	KAG7338838.1	303405	g5729	i0	88.2	1.65625	34	4	53.1	0	160	59	184	217	KAG7338838.1 50S ribosomal protein L10 [Nitzschia inconspicua]	diamond	318	65.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
31581499	31581499	PRJEB11523_P_NODE_3256_length_275_cov_11.933628_g3178_i0	PRJEB11523	3256	275	11.933628	32.817477	Bacillariaceae sp.	3061772	SAR_Eukaryotes	SAR_Eukaryotes	87.4	6.59e-19	NR	KAL3942254.1	3061772	g3178	i0	57.9	1.64727272727273	76	26	76.4	2	24	233	9	84	KAL3942254.1 MAG: hypothetical protein SGBAC_003524 [Bacillariaceae sp.]	diamond	453	87.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae		Bacillariaceae sp.
31897640	31897640	PRJEB11523_P_NODE_6217_length_185_cov_2.661765_g6139_i0	PRJEB11523	6217	185	2.661765	4.92426525	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	47.8	2.97e-4	NR	CAB9514703.1	568900	g6139	i0	74.1	0.437837837837838	27	7	43.8	0	6	86	1271	1297	CAB9514703.1 Coatomer subunit alpha [Seminavis robusta]	diamond	81	47.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32119268	32119268	PRJEB11523_P_NODE_1438_length_477_cov_8.649533_g1360_i0	PRJEB11523	1438	477	8.649533	41.25827241	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	293	2.2999999999999998e-89	NR	KAL3765181.1	259834	g1360	i0	95.9	1.82389937106918	145	6	91.2	0	22	456	758	902	KAL3765181.1 hypothetical protein ACHAWU_010372 [Discostella pseudostelligera]	diamond	870	293	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera

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