metadata: contig_metadata: 8 rows where bioproject = "PRJNA966993", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA966993", 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
26772735	26772735	PRJNA966993_P_NODE_83061_length_251_cov_0.865169_g82609_i0	PRJNA966993	83061	251	0.865169	2.17157419	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	54.7	2.46e-6	NR	ETO29348.1	46433	g82609	i0	42.4	0.705179282868526	59	34	70.5	0	74	250	191	249	ETO29348.1 hypothetical protein RFI_07778 [Reticulomyxa filosa]	diamond	177	54.7	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27063805	27063805	PRJNA966993_P_NODE_83502_length_250_cov_2.175141_g83050_i0	PRJNA966993	83502	250	2.175141	5.4378525	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	56.2	2.52e-7	NR	ETO33844.1	46433	g83050	i0	44.4	1.56	63	35	75.6	0	57	245	8	70	ETO33844.1 hypothetical protein RFI_03259 [Reticulomyxa filosa]	diamond	390	56.2	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29741334	29741334	PRJNA966993_P_NODE_27370_length_404_cov_1.628399_g26921_i0	PRJNA966993	27370	404	1.628399	6.57873196	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	124	2.7499999999999996e-32	NR	ETO00580.1	46433	g26921	i0	53.9	0.95049504950495	128	48	89.9	4	404	42	105	228	ETO00580.1 hypothetical protein RFI_36860 [Reticulomyxa filosa]	diamond	384	124	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
29994486	29994486	PRJNA966993_P_NODE_88771_length_247_cov_1.701149_g88319_i0	PRJNA966993	88771	247	1.701149	4.20183803	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	67.4	8.1e-11	NR	ETO27916.1	46433	g88319	i0	46.1	3.04858299595142	89	31	91.1	3	225	1	334	419	ETO27916.1 alpha-1,2-mannosidase, partial [Reticulomyxa filosa]	diamond	753	67.4	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30910732	30910732	PRJNA966993_P_NODE_75114_length_262_cov_1.629630_g74662_i0	PRJNA966993	75114	262	1.62963	4.2696306	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	62.4	5.58e-9	NR	ETO10269.1	46433	g74662	i0	35.6	0.99618320610687	87	55	98.5	1	260	3	718	804	ETO10269.1 hypothetical protein RFI_27108 [Reticulomyxa filosa]	diamond	261	62.4	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32048957	32048957	PRJNA966993_P_NODE_49538_length_308_cov_1.842553_g49086_i0	PRJNA966993	49538	308	1.842553	5.67506324	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	103	3.509999999999999e-23	NR	ETO32398.1	46433	g49086	i0	55.9	4.63636363636364	93	41	90.6	0	30	308	379	471	ETO32398.1 hypothetical protein RFI_04716 [Reticulomyxa filosa]	diamond	1428	103	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32498492	32498492	PRJNA966993_P_NODE_46939_length_315_cov_2.342975_g46487_i0	PRJNA966993	46939	315	2.342975	7.38037125	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	74.7	2.46e-13	NR	ETO19641.1	46433	g46487	i0	46.9	1.06666666666667	64	29	61	1	195	4	189	247	ETO19641.1 hypothetical protein RFI_17588 [Reticulomyxa filosa]	diamond	336	74.7	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
32618264	32618264	PRJNA966993_P_NODE_97680_length_242_cov_0.911243_g97228_i0	PRJNA966993	97680	242	0.911243	2.20520806	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	57.8	1.77e-7	NR	ETO05567.1	46433	g97228	i0	41.6	0.954545454545455	77	41	91.7	2	19	240	272	347	ETO05567.1 hypothetical protein RFI_31831, partial [Reticulomyxa filosa]	diamond	231	57.8	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);;