metadata: contig_metadata: 8 rows where bioproject = "PRJNA556992" and tax

8 rows where bioproject = "PRJNA556992" and tax_phylum = "Candidatus Blackallbacteria"

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
1810786	1810786	PRJNA556992_P_NODE_956742_length_235_cov_2.574074_g954552_i0	PRJNA556992	956742	235	2.574074	6.0490739	bacterium (Candidatus Blackallbacteria) CG13_big_fil_rev_8_21_14_2_5	2014260	Bacteria	Bacteria	70.9	4.09e-12	NR	PIW49648.1	2014260	g954552	i0	49.4	1.96595744680851	77	39	98.3	0	2	232	245	321	PIW49648.1 MAG: hypothetical protein COW20_05300 [bacterium (Candidatus Blackallbacteria) CG13_big_fil_rev_8_21_14_2_50_49_14]	diamond	462	70.9	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG13_big_fil_rev_8_21_14_2_50_49_14
11328539	11328539	PRJNA556992_P_NODE_230249_length_311_cov_9.147059_g228061_i0	PRJNA556992	230249	311	9.147059	28.44735349	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	163	6.23e-50	NR	PIQ26792.1	2014262	g228061	i0	95.6	0.877813504823151	91	4	87.8	0	297	25	1	91	PIQ26792.1 MAG: hypothetical protein COW64_10745 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	273	163	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
25350896	25350896	PRJNA556992_P_NODE_1084560_length_216_cov_5.993007_g1082369_i0	PRJNA556992	1084560	216	5.993007	12.94489512	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	122	1.67e-30	NR	PIQ23631.1	2014262	g1082369	i0	75	1	72	18	100	0	216	1	286	357	PIQ23631.1 MAG: ABC transporter substrate-binding protein [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	216	122	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
29478492	29478492	PRJNA556992_P_NODE_976570_length_233_cov_2.487500_g974380_i0	PRJNA556992	976570	233	2.4875	5.795875	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	42.7	0.0307	NR	PIQ26947.1	2014262	g974380	i0	50	0.540772532188841	42	20	54.1	1	5	130	246	286	PIQ26947.1 MAG: hypothetical protein COW64_09405 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	126	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
30931850	30931850	PRJNA556992_P_NODE_75134_length_443_cov_5.167568_g72958_i0	PRJNA556992	75134	443	5.167568	22.89232624	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	138	7.77e-35	NR	PIQ26396.1	2014262	g72958	i0	63.9	1.9706546275395	144	38	96.8	3	13	441	112	242	PIQ26396.1 MAG: hypothetical protein COW64_11990 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	873	138	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
31784893	31784893	PRJNA556992_P_NODE_1065477_length_221_cov_4.439189_g1063287_i0	PRJNA556992	1065477	221	4.439189	9.81060769	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	103	8.549999999999999e-24	NR	PIQ27644.1	2014262	g1063287	i0	75.3	0.990950226244344	73	18	99.1	0	1	219	305	377	PIQ27644.1 MAG: alkaline serine protease [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	219	103	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
32242920	32242920	PRJNA556992_P_NODE_398738_length_277_cov_1.137255_g396549_i0	PRJNA556992	398738	277	1.137255	3.15019635	Bacteria	2	Bacteria	Bacteria	50.1	1.26e-4	NR	PIQ28063.1	2014262	g396549	i0	92	0.541516245487365	25	2	27.1	0	79	5	92	116	PIQ28063.1 MAG: hypothetical protein COW64_05190, partial [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	150	50.1	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
32607559	32607559	PRJNA556992_P_NODE_155060_length_354_cov_6.274021_g152872_i0	PRJNA556992	155060	354	6.274021	22.21003434	bacterium (Candidatus Blackallbacteria) CG13_big_fil_rev_8_21_14_2_5	2014260	Bacteria	Bacteria	85.9	9.55e-17	NR	PIW49940.1	2014260	g152872	i0	44.3	0.974576271186441	115	62	95.8	1	5	343	442	556	PIW49940.1 MAG: hypothetical protein COW20_04630, partial [bacterium (Candidatus Blackallbacteria) CG13_big_fil_rev_8_21_14_2_50_49_14]	diamond	345	85.9	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG13_big_fil_rev_8_21_14_2_50_49_14

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