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

8 rows where bioproject = "PRJNA744060", 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
24949832	24949832	PRJNA744060_P_NODE_33060_length_286_cov_1.821596_g32731_i0	PRJNA744060	33060	286	1.821596	5.20976456	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	135	3.01e-36	NR	ETO34045.1	46433	g32731	i0	65.2	2.89510489510489	92	32	96.5	0	3	278	75	166	ETO34045.1 hypothetical protein RFI_03046 [Reticulomyxa filosa]	diamond	828	136	0.992647058823529	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
26672542	26672542	PRJNA744060_P_NODE_5461_length_676_cov_2.474295_g5150_i0	PRJNA744060	5461	676	2.474295	16.7262342	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	165	4.4299999999999996e-46	NR	ETO28241.1	46433	g5150	i0	36.9	1.10502958579882	249	125	96.3	7	11	661	68	316	ETO28241.1 hypothetical protein RFI_08889 [Reticulomyxa filosa]	diamond	747	165	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
26926132	26926132	PRJNA744060_P_NODE_30882_length_295_cov_1.531532_g30553_i0	PRJNA744060	30882	295	1.531532	4.5180194	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0237	NR	ETO30488.1	46433	g30553	i0	38.2	0.559322033898305	55	34	55.9	0	93	257	213	267	ETO30488.1 hypothetical protein RFI_06633 [Reticulomyxa filosa]	diamond	165	43.9	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
27726500	27726500	PRJNA744060_P_NODE_31004_length_294_cov_3.031674_g30675_i0	PRJNA744060	31004	294	3.031674	8.91312156	Ochromonadales	98652	SAR_Eukaryotes	SAR_Eukaryotes	53.5	2.53e-6	NR	ETO06965.1	46433	g30675	i0	66.7	0.989795918367347	33	11	33.7	0	292	194	115	147	ETO06965.1 hypothetical protein RFI_30425 [Reticulomyxa filosa]	diamond	291	53.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
30274154	30274154	PRJNA744060_P_NODE_34172_length_282_cov_1.344498_g33843_i0	PRJNA744060	34172	282	1.344498	3.79148436	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	103	5.3e-25	NR	ETO00580.1	46433	g33843	i0	50.5	1.0531914893617	99	40	95.7	2	282	13	103	201	ETO00580.1 hypothetical protein RFI_36860 [Reticulomyxa filosa]	diamond	297	103	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31253336	31253336	PRJNA744060_P_NODE_13935_length_430_cov_1.568627_g13606_i0	PRJNA744060	13935	430	1.568627	6.7450961	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	109	4.66e-25	NR	ETO32845.1	46433	g13606	i0	38.9	1.03953488372093	149	82	99.1	3	1	426	57	203	ETO32845.1 hypothetical protein RFI_04271 [Reticulomyxa filosa]	diamond	447	109	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31569899	31569899	PRJNA744060_P_NODE_31776_length_291_cov_2.110092_g31447_i0	PRJNA744060	31776	291	2.110092	6.14036772	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	95.5	1.43e-20	NR	ETO11254.1	46433	g31447	i0	55.4	0.855670103092783	83	37	85.6	0	3	251	370	452	ETO11254.1 propionyl Coenzyme A carboxylase, beta polypeptide [Reticulomyxa filosa]	diamond	249	95.5	1	Eukaryota	Sar	Foraminifera	Reticulomyxidae	Reticulomyxa	Reticulomyxa filosa
31822535	31822535	PRJNA744060_P_NODE_20057_length_361_cov_1.083333_g19728_i0	PRJNA744060	20057	361	1.083333	3.91083213	Reticulomyxa filosa	46433	SAR_Eukaryotes	SAR_Eukaryotes	85.5	1.49e-17	NR	ETO16201.1	46433	g19728	i0	35.1	1.08864265927978	131	69	98.1	3	1	354	42	169	ETO16201.1 hypothetical protein RFI_21156 [Reticulomyxa filosa]	diamond	393	85.5	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);;