metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB25583" 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_species
26653045	26653045	PRJEB25583_P_NODE_6481_length_165_cov_0.914062_g6304_i0	PRJEB25583	6481	165	0.914062	1.5082023	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	114	5.97e-28	NR	MCC6323882.1	2052152	g6304	i0	100	1	55	0	100	0	165	1	31	85	MCC6323882.1 type IV secretion system DNA-binding domain-containing protein [Candidatus Nomurabacteria bacterium]	diamond	165	114	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota			Candidatus Nomurabacteria bacterium
27753517	27753517	PRJEB25583_P_NODE_6424_length_165_cov_1.820312_g6247_i0	PRJEB25583	6424	165	1.820312	3.0035148	Bacteria	2	Bacteria	Bacteria	76.3	1.68e-16	NR	MDQ5957064.1	2052139	g6247	i0	77.1	8.74545454545455	48	11	87.3	0	17	160	1	48	MDQ5957064.1 CsoR family transcriptional regulator, copper-sensing transcriptional repressor [Patescibacteria group bacterium]	diamond	1443	77	0.990909090909091	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
27823079	27823079	PRJEB25583_P_NODE_5864_length_171_cov_2.694030_g5687_i0	PRJEB25583	5864	171	2.69403	4.6067913	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	78.2	5.49e-16	NR	HEY5268622.1	2973664	g5687	i0	63.2	1	57	20	98.2	1	2	169	96	152	HEY5268622.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	171	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadales bacterium
28264776	28264776	PRJEB25583_P_NODE_3066_length_232_cov_1.246154_g2889_i0	PRJEB25583	3066	232	1.246154	2.89107728	Candidatus Tayloriibacteriota bacterium	2052153	Bacteria	Bacteria	79.3	1.4e-16	NR	MDB5259126.1	2052153	g2889	i0	66.7	0.737068965517241	57	18	73.7	1	62	232	9	64	MDB5259126.1 rpsL [Candidatus Taylorbacteria bacterium]	diamond	171	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Tayloriibacteriota			Candidatus Tayloriibacteriota bacterium
29464349	29464349	PRJEB25583_P_NODE_2290_length_272_cov_3.072340_g2113_i0	PRJEB25583	2290	272	3.07234	8.3567648	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	40.8	0.0228	NR	HKA33321.1	2838779	g2113	i0	46.4	0.308823529411765	28	15	30.9	0	98	181	17	44	HKA33321.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	84	40.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
30001735	30001735	PRJEB25583_P_NODE_8191_length_151_cov_2.350877_g8014_i0	PRJEB25583	8191	151	2.350877	3.54982427	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	77.4	7.24e-17	NR	MBU0626772.1	2052139	g8014	i0	67.3	0.973509933774834	49	15	97.4	1	3	149	49	96	MBU0626772.1 hypothetical protein [Patescibacteria group bacterium]	diamond	147	77.4	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
30279919	30279919	PRJEB25583_P_NODE_7332_length_157_cov_2.183333_g7155_i0	PRJEB25583	7332	157	2.183333	3.42783281	Bacteria	2	Bacteria	Bacteria	71.2	4.26e-13	NR	PIV08291.1	1974847	g7155	i0	74.5	1.79617834394904	47	12	89.8	0	15	155	1	47	PIV08291.1 MAG: phenylalanine--tRNA ligase subunit alpha, partial [Candidatus Roizmanbacteria bacterium CG03_land_8_20_14_0_80_39_12]	diamond	282	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota			Candidatus Roizmanbacteria bacterium CG03_land_8_20_14_0_80_39_12
30412646	30412646	PRJEB25583_P_NODE_6013_length_170_cov_1.150376_g5836_i0	PRJEB25583	6013	170	1.150376	1.9556392	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	51.6	1.03e-5	NR	MCK9371323.1	2099670	g5836	i0	75	0.564705882352941	32	8	56.5	0	18	113	322	353	MCK9371323.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	96	51.6	1	Bacteria	Bacteria candidate phyla				Candidatus Dojkabacteria bacterium
32309719	32309719	PRJEB25583_P_NODE_5919_length_171_cov_1.149254_g5742_i0	PRJEB25583	5919	171	1.149254	1.96522434	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	76.6	1.48e-14	NR	MFA6417189.1	2052139	g5742	i0	62.5	0.982456140350877	56	21	98.2	0	169	2	330	385	MFA6417189.1 PEP-utilizing enzyme [Patescibacteria group bacterium]	diamond	168	76.6	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
32594165	32594165	PRJEB25583_P_NODE_3060_length_232_cov_1.779487_g2883_i0	PRJEB25583	3060	232	1.779487	4.12840984	Microgenomates group bacterium ADurb.Bin238	1852934	Bacteria	Bacteria	50.1	8.33e-5	NR	OQA82340.1	1852934	g2883	i0	36.6	1.06034482758621	82	45	97	1	6	230	193	274	OQA82340.1 MAG: hypothetical protein BWY29_00919 [Microgenomates group bacterium ADurb.Bin238]	diamond	246	50.1	1	Bacteria	Bacteria candidate phyla				Microgenomates group bacterium ADurb.Bin238

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