metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax_phylum = "Candidatus Curtissiibacteriota"

10 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax_phylum = "Candidatus Curtissiibacteriota"

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_species
26667036	26667036	PRJNA557436_S_NODE_1681_length_287_cov_1.726190_g1633_i0	PRJNA557436	1681	287	1.72619	4.9541653	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	107	1.61e-28	NR	MBP6980126.1	2750075	g1633	i0	90.8	0.679442508710801	65	6	67.9	0	195	1	1	65	MBP6980126.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	195	107	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
26825840	26825840	PRJNA557436_S_NODE_1581_length_294_cov_2.841699_g1533_i0	PRJNA557436	1581	294	2.841699	8.35459506	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	152	2.73e-45	NR	MCR4324182.1	2750075	g1533	i0	69.4	1	98	30	100	0	1	294	16	113	MCR4324182.1 DNA-packaging protein [Candidatus Curtissbacteria bacterium]	diamond	294	152	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
26889213	26889213	PRJNA557436_S_NODE_6601_length_167_cov_2.477273_g6553_i0	PRJNA557436	6601	167	2.477273	4.13704591	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	72.8	5.42e-14	NR	MBP6980127.1	2750075	g6553	i0	64.2	0.952095808383233	53	14	95.2	1	9	167	97	144	MBP6980127.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	159	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
27047248	27047248	PRJNA557436_S_NODE_3622_length_207_cov_1.988372_g3574_i0	PRJNA557436	3622	207	1.988372	4.11593004	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	137	3.03e-38	NR	MBP6980098.1	2750075	g3574	i0	95.7	1	69	3	100	0	1	207	204	272	MBP6980098.1 site-specific integrase [Candidatus Curtissbacteria bacterium]	diamond	207	137	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
27931672	27931672	PRJNA557436_S_NODE_4445_length_192_cov_1.649682_g4397_i0	PRJNA557436	4445	192	1.649682	3.16738944	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	78.2	3.28e-15	NR	MBP6980111.1	2750075	g4397	i0	92.3	0.609375	39	3	60.9	0	2	118	287	325	MBP6980111.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	117	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
28815459	28815459	PRJNA557436_S_NODE_5968_length_173_cov_1.717391_g5920_i0	PRJNA557436	5968	173	1.717391	2.97108643	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	100	2.22e-25	NR	MBP6980123.1	2750075	g5920	i0	96.4	0.971098265895954	56	2	97.1	0	170	3	20	75	MBP6980123.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	168	100	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
29384194	29384194	PRJNA557436_S_NODE_7469_length_161_cov_1.428571_g7421_i0	PRJNA557436	7469	161	1.428571	2.29999931	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	63.9	1.22e-10	NR	MBP6980127.1	2750075	g7421	i0	54.7	0.987577639751553	53	24	98.8	0	160	2	139	191	MBP6980127.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	159	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
30268721	30268721	PRJNA557436_S_NODE_2592_length_236_cov_2.547264_g2544_i0	PRJNA557436	2592	236	2.547264	6.01154304	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	148	7.29e-43	NR	MBP6980060.1	2750075	g2544	i0	95.9	0.940677966101695	74	3	94.1	0	223	2	1	74	MBP6980060.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	222	148	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
30395189	30395189	PRJNA557436_S_NODE_2173_length_256_cov_1.547511_g2125_i0	PRJNA557436	2173	256	1.547511	3.96162816	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	149	2.3199999999999993e-43	NR	MBP6980060.1	2750075	g2125	i0	88.9	2.84765625	81	9	94.9	0	245	3	124	204	MBP6980060.1 hypothetical protein [Candidatus Curtissbacteria bacterium]	diamond	729	149	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria bacterium
31184395	31184395	PRJNA557436_S_NODE_5395_length_179_cov_3.611111_g5347_i0	PRJNA557436	5395	179	3.611111	6.46388869	Candidatus Curtissbacteria bacterium	2750075	Bacteria	Bacteria	109	1.6e-27	NR	MBP6980098.1	2750075	g5347	i0	96.6	0.988826815642458	59	2	98.9	0	179	3	49	107	MBP6980098.1 site-specific integrase [Candidatus Curtissbacteria bacterium]	diamond	177	109	1	Bacteria	Bacteria candidate phyla	Candidatus Curtissiibacteriota	Candidatus Curtissbacteria 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);;