metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA436017" 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
8083976	8083976	PRJNA436017_P_NODE_1727_length_721_cov_1.872807_g1505_i0	PRJNA436017	1727	721	1.8728070000000001	13.50293847	Bacteria	2	Bacteria	Bacteria	263	1.13e-81	NR	PIR04142.1	1974653	g1505	i0	66	77.5298196948682	203	69	84.5	0	2	610	260	462	PIR04142.1 MAG: F0F1 ATP synthase subunit alpha [Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_39_34]	diamond	55899	265	0.992452830188679	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota			Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_39_34
26664024	26664024	PRJNA436017_P_NODE_17681_length_195_cov_1.455696_g17383_i0	PRJNA436017	17681	195	1.455696	2.8386072	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42.4	0.0276	NR	MCC2631344.1	2052139	g17383	i0	40.7	0.830769230769231	54	31	83.1	1	30	191	793	845	MCC2631344.1 hypothetical protein [Patescibacteria group bacterium]	diamond	162	42.4	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
27297099	27297099	PRJNA436017_P_NODE_22223_length_173_cov_1.955882_g21925_i0	PRJNA436017	22223	173	1.955882	3.38367586	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	55.8	3.45e-7	NR	MDP2090429.1	2044595	g21925	i0	46.4	2.93063583815029	56	30	97.1	0	172	5	649	704	MDP2090429.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium]	diamond	507	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota			Candidatus Altimarinota bacterium
27328832	27328832	PRJNA436017_P_NODE_16603_length_202_cov_1.654545_g16305_i0	PRJNA436017	16603	202	1.654545	3.3421809	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	42.7	0.0211	NR	MEZ4655645.1	2212470	g16305	i0	37.3	0.876237623762376	59	36	86.1	1	16	189	175	233	MEZ4655645.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium]	diamond	177	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota			Candidatus Eiseniibacteriota bacterium
27991958	27991958	PRJNA436017_P_NODE_24365_length_165_cov_1.617188_g24067_i0	PRJNA436017	24365	165	1.617188	2.6683602	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	90.5	2.66e-21	NR	MFA6094966.1	2053589	g24067	i0	84	1.83636363636364	50	8	90.9	0	154	5	42	91	MFA6094966.1 DUF4145 domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	303	90.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
29475478	29475478	PRJNA436017_P_NODE_18190_length_192_cov_1.509677_g17892_i0	PRJNA436017	18190	192	1.509677	2.89857984	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	52.4	6.99e-6	NR	MBS1988326.1	2030827	g17892	i0	57.5	0.625	40	17	62.5	0	72	191	7	46	MBS1988326.1 ABC transporter ATP-binding protein [Candidatus Dependentiae bacterium]	diamond	120	52.4	1	Bacteria	Bacteria candidate phyla				Candidatus Babelota bacterium
30201975	30201975	PRJNA436017_P_NODE_23332_length_169_cov_1.174242_g23034_i0	PRJNA436017	23332	169	1.174242	1.98446898	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	47.8	2.36e-4	NR	MDR3549977.1	2803731	g23034	i0	50	0.816568047337278	46	22	81.7	1	168	31	313	357	MDR3549977.1 ankyrin repeat domain-containing protein [Candidatus Babeliales bacterium]	diamond	138	47.8	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliales bacterium
31276424	31276424	PRJNA436017_P_NODE_10275_length_269_cov_1.176724_g9977_i0	PRJNA436017	10275	269	1.176724	3.16538756	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	79.7	2.39e-15	NR	MBM3305384.1	2052149	g9977	i0	56.3	0.713754646840149	64	28	71.4	0	2	193	243	306	MBM3305384.1 calcium/sodium antiporter [Candidatus Aminicenantes bacterium]	diamond	192	79.7	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota			Candidatus Aminicenantes 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);;