metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Woeseibacteriota"

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
3152569	3152569	PRJNA630162_P_NODE_135183_length_168_cov_1.226891_g133660_i0	PRJNA630162	135183	168	1.226891	2.06117688	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	119	1.37e-22	NTclustered	gi\|1950819513\|gb\|CP066693.1\|	2026804	g133660	i0	87.5	0.619047619047619	104	11	61	1	10	111	52919	52816	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_896_Pr1_S2p5_35_35 chromosome	blastn	104	119	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
8254619	8254619	PRJNA630162_P_NODE_117807_length_175_cov_2.976190_g116284_i0	PRJNA630162	117807	175	2.97619	5.2083325	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	137	3.96e-28	NTclustered	gi\|2874253989\|emb\|OY970314.1\|	2026804	g116284	i0	85.401	51.9371428571429	137	15	77	5	10	143	11004	11138	MAG: Candidatus Woesebacteria bacterium isolate MFD01299.bin.c.5 genome assembly, chromosome: 1	blastn	9089	137	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
17180140	17180140	PRJNA630162_P_NODE_30574_length_327_cov_1.679856_g29052_i0	PRJNA630162	30574	327	1.679856	5.49312912	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	171	8.139999999999999e-38	NTclustered	gi\|1950815156\|gb\|CP066686.1\|	2026804	g29052	i0	78.445	8.92966360856269	283	45	84	13	35	310	1058679	1058952	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_442_Ag_B-0.1um_40_41 chromosome	blastn	2920	171	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
17180164	17180164	PRJNA630162_P_NODE_32754_length_314_cov_3.369811_g31232_i0	PRJNA630162	32754	314	3.369811	10.58120654	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	182	3.59e-41	NTclustered	gi\|1958092354\|gb\|CP065002.1\|	2026804	g31232	i0	80.478	14.8503184713376	251	38	78	11	1	245	288277	288522	MAG: Candidatus Woesebacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.182_cln chromosome, complete genome	blastn	4663	182	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
18454706	18454706	PRJNA630162_P_NODE_77495_length_204_cov_3.000000_g75972_i0	PRJNA630162	77495	204	3	6.12	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	172	1.31e-38	NTclustered	gi\|1862742885\|gb\|CP055307.1\|	2026804	g75972	i0	84.181	137.730392156863	177	28	87	0	6	182	68942	68766	MAG: Candidatus Woesebacteria bacterium isolate Ch104b chromosome, complete genome	blastn	28097	172	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
21004542	21004542	PRJNA630162_P_NODE_27057_length_350_cov_3.488372_g25535_i0	PRJNA630162	27057	350	3.488372	12.209302	Candidatus Woesebacteria bacterium GW2011_GWF1_31_35	1618600	Bacteria	Bacteria	527	4.509999999999998e-145	NTclustered	gi\|837352775\|gb\|CP011214.1\|	1618600	g25535	i0	93.785	65.7428571428571	354	17	100	3	1	350	381621	381973	MAG: Candidatus Woesebacteria bacterium GW2011_GWF1_31_35 chromosome, complete genome	blastn	23010	527	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWF1_31_35
22278978	22278978	PRJNA630162_P_NODE_155078_length_163_cov_1.535088_g153555_i0	PRJNA630162	155078	163	1.535088	2.50219344	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	86.1	1.34e-12	NTclustered	gi\|1950819513\|gb\|CP066693.1\|	2026804	g153555	i0	89.706	0.417177914110429	68	5	41	2	1	67	51967	52033	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_896_Pr1_S2p5_35_35 chromosome	blastn	68	86.1	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
23555238	23555238	PRJNA630162_P_NODE_77179_length_205_cov_1.269231_g75656_i0	PRJNA630162	77179	205	1.269231	2.60192355	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	320	4.44e-83	NTclustered	gi\|1950815156\|gb\|CP066686.1\|	2026804	g75656	i0	95.122	16.7512195121951	205	6	99	4	4	205	1057696	1057493	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_442_Ag_B-0.1um_40_41 chromosome	blastn	3434	320	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
23555256	23555256	PRJNA630162_P_NODE_79399_length_202_cov_1.359477_g77876_i0	PRJNA630162	79399	202	1.359477	2.74614354	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	108	3.7e-19	NTclustered	gi\|1950819513\|gb\|CP066693.1\|	2026804	g77876	i0	77.612	13.7673267326733	201	30	97	11	5	200	53129	52939	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_896_Pr1_S2p5_35_35 chromosome	blastn	2781	108	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria 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);;