metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax_clade = "Bacteria candidate phyla"

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_species
10538831	10538831	PRJNA1226487_P_NODE_47109_length_277_cov_1.509804_g47007_i0	PRJNA1226487	47109	277	1.509804	4.18215708	Bacteria	2	Bacteria	Bacteria	154	5.4199999999999984e-43	NR	HXJ35811.1	2212470	g47007	i0	80.4	4.98194945848375	92	18	99.6	0	277	2	242	333	HXJ35811.1 acyl-CoA dehydrogenase family protein [Candidatus Eiseniibacteriota bacterium]	diamond	1380	154	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota				Candidatus Eiseniibacteriota bacterium
27957179	27957179	PRJNA1226487_P_NODE_40945_length_287_cov_1.439252_g40843_i0	PRJNA1226487	40945	287	1.439252	4.13065324	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	168	9.16e-47	NR	HJW67881.1	2838779	g40843	i0	88.4	1.97560975609756	95	11	99.3	0	285	1	65	159	HJW67881.1 response regulator [Candidatus Binatia bacterium]	diamond	567	168	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28146782	28146782	PRJNA1226487_P_NODE_72085_length_245_cov_1.790698_g71983_i0	PRJNA1226487	72085	245	1.790698	4.3872101	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	73.9	5.28e-14	NR	MBI2033089.1	2052151	g71983	i0	40.7	0.991836734693878	81	48	99.2	0	2	244	104	184	MBI2033089.1 nicotinate (nicotinamide) nucleotide adenylyltransferase [Candidatus Levyibacteriota bacterium]	diamond	243	73.9	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota				Candidatus Levyibacteriota bacterium
28683528	28683528	PRJNA1226487_P_NODE_20947_length_355_cov_3.553191_g20845_i0	PRJNA1226487	20947	355	3.553191	12.61382805	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	45.1	0.0185	NR	HZO82793.1	2785449	g20845	i0	38.7	0.523943661971831	62	35	49.9	1	210	34	288	349	HZO82793.1 hypothetical protein [Candidatus Binataceae bacterium]	diamond	186	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
28936018	28936018	PRJNA1226487_P_NODE_51508_length_270_cov_1.563452_g51406_i0	PRJNA1226487	51508	270	1.563452	4.2213204	Candidatus Tayloriibacteriota bacterium	2052153	Bacteria	Bacteria	123	6.59e-31	NR	MCX6718857.1	2052153	g51406	i0	56.7	2	90	39	100	0	1	270	341	430	MCX6718857.1 hypothetical protein [Candidatus Taylorbacteria bacterium]	diamond	540	123	1	Bacteria	Bacteria candidate phyla	Candidatus Tayloriibacteriota				Candidatus Tayloriibacteriota bacterium
29062387	29062387	PRJNA1226487_P_NODE_39448_length_289_cov_2.444444_g39346_i0	PRJNA1226487	39448	289	2.444444	7.06444316	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	136	1.3799999999999999e-38	NR	MBP9719124.1	2052151	g39346	i0	66.7	1.08996539792388	105	25	98.6	1	287	3	43	147	MBP9719124.1 KH domain-containing protein [Candidatus Levyibacteriota bacterium]	diamond	315	136	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota				Candidatus Levyibacteriota bacterium
29283104	29283104	PRJNA1226487_P_NODE_52909_length_268_cov_1.579487_g52807_i0	PRJNA1226487	52909	268	1.579487	4.23302516	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	102	5.659999999999999e-24	NR	MDB5161982.1	2026720	g52807	i0	56.3	0.973880597014925	87	37	97.4	1	5	265	202	287	MDB5161982.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	261	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
29472423	29472423	PRJNA1226487_P_NODE_52890_length_268_cov_1.579487_g52788_i0	PRJNA1226487	52890	268	1.579487	4.23302516	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	52.8	4.39e-7	NR	HEX8964987.1	2052139	g52788	i0	62.2	1.00746268656716	45	16	49.3	1	63	194	1	45	HEX8964987.1 hypothetical protein [Patescibacteria group bacterium]	diamond	270	52.8	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
29756737	29756737	PRJNA1226487_P_NODE_45331_length_280_cov_1.487923_g45229_i0	PRJNA1226487	45331	280	1.487923	4.1661844	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	94	6.279999999999999e-23	NR	HSK43685.1	2838779	g45229	i0	66.7	0.707142857142857	66	22	70.7	0	202	5	12	77	HSK43685.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	198	94	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
30641306	30641306	PRJNA1226487_P_NODE_50293_length_272_cov_1.547739_g50191_i0	PRJNA1226487	50293	272	1.547739	4.20985008	Candidatus Beckwithbacteria bacterium CG1	2053519	Bacteria	Bacteria	42.7	0.0498	NR	PIS09142.1	1974495	g50191	i0	46.2	0.430147058823529	39	21	43	0	216	100	285	323	PIS09142.1 MAG: hypothetical protein COT75_02680 [Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10]	diamond	117	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Beckwithiibacteriota				Candidatus Beckwithbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_34_10
31368573	31368573	PRJNA1226487_P_NODE_79536_length_238_cov_3.866667_g79434_i0	PRJNA1226487	79536	238	3.866667	9.20266746	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	47.8	5.6e-4	NR	MCX6559136.1	2052149	g79434	i0	30.9	6.39075630252101	68	47	85.7	0	206	3	173	240	MCX6559136.1 YCF48-related protein [Candidatus Aminicenantes bacterium]	diamond	1521	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota				Candidatus Aminicenantes bacterium
31463420	31463420	PRJNA1226487_P_NODE_50896_length_271_cov_1.555556_g50794_i0	PRJNA1226487	50896	271	1.555556	4.21555676	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	94	4.45e-20	NR	MCA9374354.1	2030811	g50794	i0	56.7	1.98154981549816	90	38	99.6	1	271	2	406	494	MCA9374354.1 AAA family ATPase [Candidatus Peregrinibacteria bacterium]	diamond	537	94	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota				Candidatus Peregrinibacteria bacterium
32273091	32273091	PRJNA1226487_P_NODE_58578_length_259_cov_1.655914_g58476_i0	PRJNA1226487	58578	259	1.655914	4.28881726	Pseudomonadati	3379134	Bacteria	Bacteria	81.3	2.94e-16	NR	HVX91541.1	2053589	g58476	i0	56.6	5.67567567567568	83	31	91.5	3	258	22	55	136	HVX91541.1 RHS repeat-associated core domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	1470	81.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota				Minisyncoccota bacterium
32809549	32809549	PRJNA1226487_P_NODE_54760_length_265_cov_1.604167_g54658_i0	PRJNA1226487	54760	265	1.604167	4.25104255	Pseudomonadati	3379134	Bacteria	Bacteria	148	7.51e-44	NR	HTO82829.1	2072417	g54658	i0	78.4	1.99245283018868	88	19	99.6	0	2	265	8	95	HTO82829.1 response regulator [Candidatus Methylomirabilota bacterium]	diamond	528	148	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota				Candidatus Methylomirabilota 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);;