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

8 rows where analysis = "diamond", bioproject = "PRJNA826497" 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
27022815	27022815	PRJNA826497_S_NODE_11422_length_180_cov_2.244898_g11382_i0	PRJNA826497	11422	180	2.244898	4.0408164	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	60.1	3.07e-9	NR	PIQ26768.1	2014262	g11382	i0	93.3	0.5	30	2	50	0	90	1	1	30	PIQ26768.1 MAG: DNA recombination-mediator protein A [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	90	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
27749698	27749698	PRJNA826497_S_NODE_18844_length_153_cov_5.591667_g18804_i0	PRJNA826497	18844	153	5.591667	8.55525051	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	55.8	2.29e-7	NR	PIQ28218.1	2014262	g18804	i0	59.6	0.92156862745098	47	19	92.2	0	152	12	217	263	PIQ28218.1 MAG: hypothetical protein COW64_04215 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	141	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
28475682	28475682	PRJNA826497_S_NODE_18566_length_154_cov_3.396694_g18526_i0	PRJNA826497	18566	154	3.396694	5.23090876	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	92.8	2.21e-20	NR	PIQ27226.1	2014262	g18526	i0	98	0.974025974025974	50	1	97.4	0	152	3	406	455	PIQ27226.1 MAG: hypothetical protein COW64_07910 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	150	92.8	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
28602038	28602038	PRJNA826497_S_NODE_20107_length_150_cov_4.914530_g20067_i0	PRJNA826497	20107	150	4.91453	7.371795	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	87.8	1.25e-18	NR	PIQ27244.1	2014262	g20067	i0	91.8	0.98	49	4	98	0	3	149	75	123	PIQ27244.1 MAG: hypothetical protein COW64_08000 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	147	87.8	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
30180767	30180767	PRJNA826497_S_NODE_17792_length_156_cov_5.203252_g17752_i0	PRJNA826497	17792	156	5.203252	8.11707312	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	48.9	7.81e-5	NR	PIQ26316.1	2014262	g17752	i0	47.2	2.05769230769231	53	24	94.2	2	10	156	217	269	PIQ26316.1 MAG: hypothetical protein COW64_11550 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	321	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
30717866	30717866	PRJNA826497_S_NODE_18214_length_155_cov_3.295082_g18174_i0	PRJNA826497	18214	155	3.295082	5.1073771	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	94.7	6.88e-22	NR	PIQ26662.1	2014262	g18174	i0	90.2	0.987096774193548	51	5	98.7	0	154	2	96	146	PIQ26662.1 MAG: 3-hydroxybutyryl-CoA dehydrogenase [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	153	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
32362618	32362618	PRJNA826497_S_NODE_19579_length_151_cov_16.966102_g19539_i0	PRJNA826497	19579	151	16.966102	25.61881402	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	90.9	9.31e-20	NR	PIQ28582.1	2014262	g19539	i0	85.7	0.973509933774834	49	7	97.4	0	149	3	341	389	PIQ28582.1 MAG: hypothetical protein COW64_02680 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	147	90.9	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
32489143	32489143	PRJNA826497_S_NODE_14959_length_165_cov_4.265152_g14919_i0	PRJNA826497	14959	165	4.265152	7.0375008	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5	2014262	Bacteria	Bacteria	89.7	3.54e-19	NR	PIQ25007.1	2014262	g14919	i0	84.9	0.963636363636364	53	8	96.4	0	2	160	14	66	PIQ25007.1 MAG: preprotein translocase subunit SecA [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	159	89.7	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria	bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26

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