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

6 rows where bioproject = "PRJNA1204310", 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
26597442	26597442	PRJNA1204310_P_NODE_12121_length_506_cov_1.621247_g11824_i0	PRJNA1204310	12121	506	1.621247	8.20350982	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	48.5	0.00417	NR	ETO08850.1	46433	g11824	i0	55.3	0.225296442687747	38	17	22.5	0	448	335	307	344	ETO08850.1 hypothetical protein RFI_28538, partial [Reticulomyxa filosa]	diamond	114	48.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27028229	27028229	PRJNA1204310_P_NODE_55362_length_249_cov_0.886364_g55065_i0	PRJNA1204310	55362	249	0.886364	2.20704636	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	62.8	3.12e-9	NR	ETO29173.1	46433	g55065	i0	47.5	5.93975903614458	61	31	72.3	1	41	220	150	210	ETO29173.1 hypothetical protein RFI_07952, partial [Reticulomyxa filosa]	diamond	1479	62.8	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29724891	29724891	PRJNA1204310_P_NODE_59870_length_245_cov_0.906977_g59573_i0	PRJNA1204310	59870	245	0.906977	2.22209365	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	122	2.69e-30	NR	ETO22614.1	46433	g59573	i0	68.8	0.942857142857143	77	24	94.3	0	243	13	1318	1394	ETO22614.1 hypothetical protein RFI_14580 [Reticulomyxa filosa]	diamond	231	122	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30186158	30186158	PRJNA1204310_P_NODE_16332_length_442_cov_1.108401_g16035_i0	PRJNA1204310	16332	442	1.108401	4.89913242	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	55.1	1.4e-5	NR	ETO13041.1	46433	g16035	i0	26.4	4.98868778280543	148	84	98.4	6	442	8	263	388	ETO13041.1 hypothetical protein RFI_24335 [Reticulomyxa filosa]	diamond	2205	55.1	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31273289	31273289	PRJNA1204310_P_NODE_21395_length_393_cov_1.218750_g21098_i0	PRJNA1204310	21395	393	1.21875	4.7896875	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	121	6.69e-29	NR	ETO27461.1	46433	g21098	i0	51.4	4.38167938931298	109	53	83.2	0	57	383	1272	1380	ETO27461.1 HECT type ubiquitin ligase [Reticulomyxa filosa]	diamond	1722	121	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32696212	32696212	PRJNA1204310_P_NODE_44180_length_278_cov_1.521951_g43883_i0	PRJNA1204310	44180	278	1.521951	4.23102378	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	132	1.13e-34	NR	ETO26568.1	46433	g43883	i0	66.7	0.971223021582734	90	30	97.1	0	2	271	215	304	ETO26568.1 phytanoyl-CoA dioxygenase (PhyH) family protein [Reticulomyxa filosa]	diamond	270	132	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);;