metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA938397" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA938397" and tax_clade = "Sar"

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
26715051	26715051	PRJNA938397_S_NODE_35181_length_186_cov_1.530201_g34940_i0	PRJNA938397	35181	186	1.530201	2.84617386	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	63.9	5.53e-10	NR	GLD94218.1	114742	g34940	i0	53.4	5.64516129032258	58	26	93.5	1	5	178	242	298	GLD94218.1 hypothetical protein PINS_up002829 [Pythium insidiosum]	diamond	1050	64.3	0.993779160186625	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Pythium	Pythium insidiosum
27214469	27214469	PRJNA938397_S_NODE_31142_length_197_cov_43.306250_g30901_i0	PRJNA938397	31142	197	43.30625	85.3133125	Tetrahymena utriculariae	2486642	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0107	NR	KAL4488841.1	2486642	g30901	i0	40.5	1.27918781725888	42	24	62.4	1	193	71	60	101	KAL4488841.1 hypothetical protein ABPG72_016494 [Tetrahymena utriculariae]	diamond	252	42.7	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena utriculariae
28200411	28200411	PRJNA938397_S_NODE_22426_length_233_cov_7.219388_g22185_i0	PRJNA938397	22426	233	7.219388	16.82117404	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.00138	NR	TNV71235.1	5974	g22185	i0	43.1	2.07296137339056	51	28	64.4	1	229	80	315	365	TNV71235.1 hypothetical protein FGO68_gene10204 [Halteria grandinella]	diamond	483	47	0.991489361702128	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Halteriidae	Halteria	Halteria grandinella
28326758	28326758	PRJNA938397_S_NODE_39326_length_175_cov_5.355072_g39085_i0	PRJNA938397	39326	175	5.355072	9.371376	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	42.7	0.0147	NR	ETO21862.1	46433	g39085	i0	50	1.90285714285714	30	15	51.4	0	19	108	8	37	ETO21862.1 Dual specificity phosphatase, catalytic domain containing protein [Reticulomyxa filosa]	diamond	333	43.1	0.990719257540603	Eukaryota	Sar	Foraminifera			Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28390014	28390014	PRJNA938397_S_NODE_24346_length_224_cov_2.604278_g24105_i0	PRJNA938397	24346	224	2.604278	5.83358272	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	78.2	5.16e-16	NR	OQR96846.1	1202772	g24105	i0	73.5	5.27678571428571	49	13	65.6	0	216	70	119	167	OQR96846.1 U11/U12 small nuclear ribonucleoprotein 35 kDa protein [Achlya hypogyna]	diamond	1182	78.6	0.994910941475827	Eukaryota	Sar	Oomycota	Saprolegniomycetes	Saprolegniales	Achlyaceae	Achlya	Achlya hypogyna
29077831	29077831	PRJNA938397_S_NODE_8528_length_356_cov_8.589342_g8287_i0	PRJNA938397	8528	356	8.589342	30.57805752	Stentor coeruleus	5963	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.036	NR	OMJ71667.1	5963	g8287	i0	43.3	0.50561797752809	60	31	48	1	24	194	391	450	OMJ71667.1 hypothetical protein SteCoe_30063 [Stentor coeruleus]	diamond	180	44.3	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
29361888	29361888	PRJNA938397_S_NODE_14989_length_283_cov_6.077236_g14748_i0	PRJNA938397	14989	283	6.077236	17.19857788	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	106	1.17e-24	NR	ETO28832.1	46433	g14748	i0	64.9	1.5583038869258	74	26	78.4	0	4	225	357	430	ETO28832.1 hypothetical protein RFI_08294 [Reticulomyxa filosa]	diamond	441	106	1	Eukaryota	Sar	Foraminifera			Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30095078	30095078	PRJNA938397_S_NODE_48212_length_158_cov_1.570248_g47971_i0	PRJNA938397	48212	158	1.570248	2.48099184	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	82.4	4.33e-18	NR	XP_012770183.1	5866	g47971	i0	75	13.5379746835443	52	13	98.7	0	2	157	102	153	XP_012770183.1 ubiquitin-conjugating enzyme E2, putative [Babesia bigemina]	diamond	2139	82.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
30600623	30600623	PRJNA938397_S_NODE_39473_length_175_cov_2.934783_g39232_i0	PRJNA938397	39473	175	2.934783	5.13587025	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	70.1	1.76e-12	NR	CAI2377975.1	5936	g39232	i0	60.7	9.61714285714286	56	21	96	1	170	3	219	273	CAI2377975.1 unnamed protein product [Moneuplotes crassus]	diamond	1683	70.1	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Euplotida	Euplotidae	Moneuplotes	Moneuplotes crassus
31549242	31549242	PRJNA938397_S_NODE_38156_length_178_cov_3.241135_g37915_i0	PRJNA938397	38156	178	3.241135	5.7692203	Stephanodiscaceae	1365474	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00233	NR	KAL3764264.1	259834	g37915	i0	41.3	1.55056179775281	46	27	77.5	0	33	170	560	605	KAL3764264.1 hypothetical protein ACHAWU_004076 [Discostella pseudostelligera]	diamond	276	45.1	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);;