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

7 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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
1551154	1551154	PRJNA1120771_S_NODE_21262_length_255_cov_2.028302_g20862_i0	PRJNA1120771	21262	255	2.028302	5.1721701	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	90.9	1.17e-20	NR	GFH54200.1	426638	g20862	i0	59.5	1.74117647058824	74	30	87.1	0	246	25	95	168	GFH54200.1 ribosomal L14e-domain-containing protein [Chaetoceros tenuissimus]	diamond	444	90.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
6654413	6654413	PRJNA1120771_S_NODE_13586_length_301_cov_2.325581_g13186_i0	PRJNA1120771	13586	301	2.325581	6.99999881	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	85.9	4.72e-17	NR	XP_002184327.1	556484	g13186	i0	66.7	1.75415282392027	60	20	59.8	0	299	120	449	508	XP_002184327.1 succinyl-coenzyme A:3-oxo-acid coenzyme a-transferase [Phaeodactylum tricornutum CCAP 1055/1]	diamond	528	85.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
26690223	26690223	PRJNA1120771_S_NODE_18641_length_268_cov_3.293333_g18241_i0	PRJNA1120771	18641	268	3.293333	8.82613244	Discostella pseudostelligera	259834	SAR_Eukaryotes	SAR_Eukaryotes	127	8.75e-32	NR	KAL3756409.1	259834	g18241	i0	68.9	1.00746268656716	90	27	99.6	1	2	268	646	735	KAL3756409.1 hypothetical protein ACHAWU_007680 [Discostella pseudostelligera]	diamond	270	127	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
29564731	29564731	PRJNA1120771_S_NODE_8430_length_357_cov_3.815287_g8030_i0	PRJNA1120771	8430	357	3.815287	13.62057459	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	58.9	1.12e-7	NR	KAL3793339.1	29204	g8030	i0	42.9	0.941176470588235	56	32	47.1	0	302	135	144	199	KAL3793339.1 hypothetical protein HJC23_003849 [Cyclotella cryptica]	diamond	336	58.9	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29690726	29690726	PRJNA1120771_S_NODE_32550_length_214_cov_4.403509_g32150_i0	PRJNA1120771	32550	214	4.403509	9.42350926	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0133	NR	GKY94747.1	2872254	g32150	i0	62.1	1.34579439252336	29	11	40.7	0	214	128	273	301	GKY94747.1 hypothetical protein MPSEU_000440100 [Mayamaea pseudoterrestris]	diamond	288	43.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
30638671	30638671	PRJNA1120771_S_NODE_15693_length_286_cov_2.864198_g15293_i0	PRJNA1120771	15693	286	2.864198	8.19160628	Fistulifera solaris	1519565	SAR_Eukaryotes	SAR_Eukaryotes	54.7	2.49e-6	NR	GAX23880.1	1519565	g15293	i0	41.3	0.660839160839161	63	37	66.1	0	19	207	139	201	GAX23880.1 hypothetical protein FisN_20Hh086 [Fistulifera solaris]	diamond	189	54.7	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Fistulifera	Fistulifera solaris
32851166	32851166	PRJNA1120771_S_NODE_13920_length_298_cov_4.094118_g13520_i0	PRJNA1120771	13920	298	4.094118	12.20047164	Fragilaria crotonensis	210448	SAR_Eukaryotes	SAR_Eukaryotes	87.8	9.42e-18	NR	KAI2503083.1	210448	g13520	i0	50	1.57046979865772	78	38	77.5	1	1	231	210	287	KAI2503083.1 hypothetical protein MHU86_11354 [Fragilaria crotonensis]	diamond	468	87.8	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis

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