metadata: contig_metadata: 12 rows where bioproject = "PRJNA340009" and tax

12 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Lloydiibacteriota"

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
392585	392585	PRJNA340009_P_NODE_74161_length_162_cov_0.902655_g73854_i0	PRJNA340009	74161	162	0.902655	1.4623011	Bacteria	2	Bacteria	Bacteria	100	4.029999999999999e-23	NR	OGZ11706.1	1798665	g73854	i0	94.3	124.648148148148	53	3	98.1	0	3	161	272	324	OGZ11706.1 MAG: hypothetical protein A2942_04895 [Candidatus Lloydbacteria bacterium RIFCSPLOWO2_01_FULL_50_20]	diamond	20193	101	0.99009900990099	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPLOWO2_01_FULL_50_20
26662910	26662910	PRJNA340009_P_NODE_69141_length_164_cov_0.886957_g68834_i0	PRJNA340009	69141	164	0.886957	1.45460948	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	88.2	8.02e-20	NR	OGZ05818.1	1798658	g68834	i0	68.6	1.86585365853659	51	16	93.3	0	159	7	123	173	OGZ05818.1 MAG: hypothetical protein A2845_03370 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22]	diamond	306	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22
26726145	26726145	PRJNA340009_P_NODE_58621_length_171_cov_1.672131_g58314_i0	PRJNA340009	58621	171	1.672131	2.85934401	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	62.4	1.61e-9	NR	OGZ08634.1	1798661	g58314	i0	59.1	2.31578947368421	44	18	77.2	0	38	169	1	44	OGZ08634.1 MAG: hypothetical protein A3D65_01910 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13]	diamond	396	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13
27186583	27186583	PRJNA340009_P_NODE_47942_length_186_cov_51.613139_g47635_i0	PRJNA340009	47942	186	51.613139	96.00043854	Bacteria	2	Bacteria	Bacteria	80.1	7.32e-16	NR	OGZ06248.1	1798658	g47635	i0	62.3	2.95161290322581	61	23	98.4	0	184	2	224	284	OGZ06248.1 MAG: hypothetical protein A2845_00375 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22]	diamond	549	80.9	0.990111248454882	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22
27359367	27359367	PRJNA340009_P_NODE_63603_length_166_cov_2.247863_g63296_i0	PRJNA340009	63603	166	2.247863	3.73145258	Candidatus Lloydbacteria bacterium RIFOXYC12_FULL_46_25	1798670	Bacteria	Bacteria	58.2	4.01e-8	NR	OGZ16347.1	1798670	g63296	i0	46.3	0.975903614457831	54	29	97.6	0	2	163	39	92	OGZ16347.1 MAG: hypothetical protein A2494_00485 [Candidatus Lloydbacteria bacterium RIFOXYC12_FULL_46_25]	diamond	162	58.2	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFOXYC12_FULL_46_25
27959124	27959124	PRJNA340009_P_NODE_79365_length_156_cov_2.504673_g79058_i0	PRJNA340009	79365	156	2.504673	3.90728988	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	94.4	7.510000000000001e-21	NR	OGZ04006.1	1798657	g79058	i0	90.4	1	52	5	100	0	156	1	72	123	OGZ04006.1 MAG: hypothetical protein A2648_00185 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20]	diamond	156	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20
29460011	29460011	PRJNA340009_P_NODE_70050_length_164_cov_0.886957_g69743_i0	PRJNA340009	70050	164	0.886957	1.45460948	Bacteria	2	Bacteria	Bacteria	57	1.19e-7	NR	OGZ10561.1	1798664	g69743	i0	44.4	2.08536585365854	54	30	98.8	0	2	163	369	422	OGZ10561.1 MAG: hypothetical protein A3C93_01965 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_54_17]	diamond	342	57	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_54_17
29617835	29617835	PRJNA340009_P_NODE_39410_length_202_cov_5.156863_g39103_i0	PRJNA340009	39410	202	5.156863	10.41686326	Bacteria	2	Bacteria	Bacteria	110	3.97e-26	NR	OGZ03673.1	1798657	g39103	i0	89.5	5.92574257425743	57	6	84.7	0	30	200	286	342	OGZ03673.1 MAG: DNA topoisomerase IV subunit B [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20]	diamond	1197	110	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20
30186614	30186614	PRJNA340009_P_NODE_71372_length_163_cov_0.894737_g71065_i0	PRJNA340009	71372	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	87.4	2.28e-18	NR	OGZ08729.1	1798659	g71065	i0	79.6	3.97546012269939	54	11	99.4	0	163	2	268	321	OGZ08729.1 MAG: hypothetical protein A2762_00070 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_54_11]	diamond	648	88.2	0.99092970521542	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_54_11
31370570	31370570	PRJNA340009_P_NODE_75976_length_161_cov_0.910714_g75669_i0	PRJNA340009	75976	161	0.910714	1.46624954	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	78.2	3.88e-15	NR	OGZ04808.1	1798658	g75669	i0	77.4	2.90683229813665	53	12	98.8	0	159	1	47	99	OGZ04808.1 MAG: hypothetical protein A2845_05605 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22]	diamond	468	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22
32351185	32351185	PRJNA340009_P_NODE_50979_length_182_cov_1.518797_g50672_i0	PRJNA340009	50979	182	1.518797	2.76421054	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	80.5	7.97e-16	NR	OGZ04920.1	1798658	g50672	i0	92.9	0.692307692307692	42	3	69.2	0	127	2	112	153	OGZ04920.1 MAG: exodeoxyribonuclease VII large subunit [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22]	diamond	126	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22
32729936	32729936	PRJNA340009_P_NODE_35140_length_212_cov_4.380368_g34833_i0	PRJNA340009	35140	212	4.380368	9.28638016	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	78.6	2.71e-15	NR	OGZ12728.1	1798663	g34833	i0	66.7	0.891509433962264	63	14	89.2	1	2	190	235	290	OGZ12728.1 MAG: hypothetical protein A3D67_02865 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_51_22]	diamond	189	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_51_22

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