metadata: contig_metadata: 6 rows where bioproject = "PRJNA752572", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA752572", tax_clade = "Sar" and tax_phylum = "Foraminifera"

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_family	tax_genus	tax_species
17306680	17306680	PRJNA752572_P_NODE_168554_length_206_cov_1.157895_g168047_i0	PRJNA752572	168554	206	1.157895	2.3852637	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	132	4.8099999999999994e-35	NR	ETO31553.1	46433	g168047	i0	92.6	121.805825242718	68	5	99	0	204	1	235	302	ETO31553.1 26S proteasome regulatory subunit [Reticulomyxa filosa]	diamond	25092	132	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28452509	28452509	PRJNA752572_P_NODE_49826_length_387_cov_3.321023_g49320_i0	PRJNA752572	49826	387	3.321023	12.85235901	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00471	NR	ETO18721.1	46433	g49320	i0	46.6	1.23255813953488	58	28	45	1	209	36	60	114	ETO18721.1 V-type ATPase, G subunit family protein [Reticulomyxa filosa]	diamond	477	45.8	0.991266375545852	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
28821064	28821064	PRJNA752572_P_NODE_275128_length_162_cov_1.574803_g274621_i0	PRJNA752572	275128	162	1.574803	2.55118086	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	47	3.73e-4	NR	ETO00348.1	46433	g274621	i0	63.9	0.666666666666667	36	12	64.8	1	146	42	237	272	ETO00348.1 TLDc domain-containing protein [Reticulomyxa filosa]	diamond	108	47	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29115493	29115493	PRJNA752572_P_NODE_143148_length_224_cov_1.312169_g142641_i0	PRJNA752572	143148	224	1.312169	2.93925856	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.00174	NR	ETO32960.1	46433	g142641	i0	55.9	1.15178571428571	34	15	45.5	0	122	223	10	43	ETO32960.1 hypothetical protein RFI_04147, partial [Reticulomyxa filosa]	diamond	258	46.2	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31475074	31475074	PRJNA752572_P_NODE_160256_length_211_cov_1.835227_g159749_i0	PRJNA752572	160256	211	1.835227	3.87232897	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	61.6	5.19e-9	NR	ETO35987.1	46433	g159749	i0	53.2	0.66824644549763	47	22	66.8	0	143	3	32	78	ETO35987.1 hypothetical protein RFI_01076 [Reticulomyxa filosa]	diamond	141	61.6	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32613643	32613643	PRJNA752572_P_NODE_270400_length_163_cov_2.187500_g269893_i0	PRJNA752572	270400	163	2.1875	3.565625	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	47.4	2.47e-4	NR	ETO18968.1	46433	g269893	i0	55.6	1.34355828220859	36	12	66.3	1	111	4	198	229	ETO18968.1 hypothetical protein RFI_18272, partial [Reticulomyxa filosa]	diamond	219	47.4	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa

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