metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Candidatus Sumerlaeota"

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
26333033	26333033	PRJEB20058_P_NODE_191135_length_264_cov_1.778325_g188311_i0	PRJEB20058	191135	264	1.778325	4.694778	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	157	6.2199999999999985e-43	NR	MBN1517219.1	2107588	g188311	i0	85.2	4.60227272727273	81	12	92	0	243	1	214	294	MBN1517219.1 alpha-N-arabinofuranosidase [Candidatus Sumerlaeota bacterium]	diamond	1215	157	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota					Candidatus Sumerlaeota bacterium
32911103	32911103	PRJEB20058_P_NODE_229185_length_233_cov_2.232558_g226360_i0	PRJEB20058	229185	233	2.232558	5.20186014	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	88.2	3.3e-18	NR	MDX2175896.1	2715255	g226360	i0	66.2	1.96995708154506	71	23	90.1	1	211	2	79	149	MDX2175896.1 serine/threonine-protein kinase [Candidatus Sumerlaeia bacterium]	diamond	459	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
32979321	32979321	PRJEB20058_P_NODE_157819_length_303_cov_1.202479_g154996_i0	PRJEB20058	157819	303	1.202479	3.64351137	Sumerlaeia bacterium	3066091	Bacteria	Bacteria	84.7	1.12e-17	NR	MEQ8821557.1	3066091	g154996	i0	65.5	1.12871287128713	55	19	54.5	0	233	69	49	103	MEQ8821557.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Sumerlaeia bacterium]	diamond	342	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Sumerlaeia bacterium
32996133	32996133	PRJEB20058_P_NODE_150763_length_312_cov_16.187251_g147941_i0	PRJEB20058	150763	312	16.187251	50.50422312	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	43.5	0.0399	NR	NUP88230.1	2715255	g147941	i0	38.3	0.451923076923077	47	26	42.3	1	76	207	147	193	NUP88230.1 hypothetical protein [Candidatus Sumerlaeia bacterium]	diamond	141	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
33047617	33047617	PRJEB20058_P_NODE_205797_length_252_cov_2.188482_g202973_i0	PRJEB20058	205797	252	2.188482	5.51497464	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	122	1.8799999999999999e-31	NR	AXA35050.1	2250252	g202973	i0	70.2	1.98809523809524	84	24	98.8	1	3	251	53	136	AXA35050.1 N-acetylmuramoyl-L-alanine amidase [Candidatus Sumerlaea chitinivorans]	diamond	501	122	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
33064424	33064424	PRJEB20058_P_NODE_160269_length_299_cov_8.121849_g157446_i0	PRJEB20058	160269	299	8.121849	24.28432851	Candidatus Sumerlaeia bacterium	2715255	Bacteria	Bacteria	54.7	3.75e-6	NR	MBX3728390.1	2715255	g157446	i0	45.5	0.77257525083612	77	42	77.3	0	43	273	40	116	MBX3728390.1 aminotransferase class IV family protein [Candidatus Sumerlaeia bacterium]	diamond	231	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia				Candidatus Sumerlaeia bacterium
33144946	33144946	PRJEB20058_P_NODE_43783_length_635_cov_24.536585_g41111_i0	PRJEB20058	43783	635	24.536585	155.80731475	Bacteria	2	Bacteria	Bacteria	162	3.43e-44	NR	MBX7244742.1	2315423	g41111	i0	47.8	1.52125984251969	159	82	74.6	1	606	133	232	390	MBX7244742.1 AIPR family protein [Candidatus Sumerlaeaceae bacterium]	diamond	966	162	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae		Candidatus Sumerlaeaceae bacterium

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