metadata: contig_metadata: 4 rows where bioproject = "PRJNA1148190", tax_clade = "Bacteria candidate phyla" and tax

4 rows where bioproject = "PRJNA1148190", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Woykeibacteriota"

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
5399230	5399230	PRJNA1148190_P_NODE_467005_length_273_cov_1.350000_g455832_i0	PRJNA1148190	467005	273	1.35	3.6855	Candidatus Woykebacteria bacterium	2814276	Bacteria	Bacteria	65.9	1.3099999999999999e-10	NR	MEX0616854.1	2814276	g455832	i0	51.5	0.725274725274725	66	32	72.5	0	71	268	1	66	MEX0616854.1 SDR family oxidoreductase [Candidatus Woykebacteria bacterium]	diamond	198	65.9	1	Bacteria	Bacteria candidate phyla	Candidatus Woykeibacteriota	Candidatus Woykebacteria bacterium
9220694	9220694	PRJNA1148190_P_NODE_233108_length_353_cov_1.310714_g221938_i0	PRJNA1148190	233108	353	1.310714	4.62682042	root	1	Root_unresolved	Root_unresolved	87	2.99e-17	NR	OGY25266.1	1802595	g221938	i0	66.7	1.03682719546742	60	20	51	0	352	173	369	428	OGY25266.1 MAG: replicative DNA helicase [Candidatus Woykebacteria bacterium RBG_16_39_9b]	diamond	366	87.8	0.990888382687927	Bacteria	Bacteria candidate phyla	Candidatus Woykeibacteriota	Candidatus Woykebacteria bacterium RBG_16_39_9b
28417718	28417718	PRJNA1148190_P_NODE_153646_length_424_cov_1.655271_g142479_i0	PRJNA1148190	153646	424	1.655271	7.01834904	Bacteria	2	Bacteria	Bacteria	157	1.6999999999999998e-44	NR	OGY24631.1	1802593	g142479	i0	59.4	3.9127358490566	138	55	97.6	1	419	6	18	154	OGY24631.1 MAG: integrase [Candidatus Woykebacteria bacterium RBG_13_40_15]	diamond	1659	158	0.993670886075949	Bacteria	Bacteria candidate phyla	Candidatus Woykeibacteriota	Candidatus Woykebacteria bacterium RBG_13_40_15
29490936	29490936	PRJNA1148190_P_NODE_123250_length_475_cov_1.738806_g112087_i0	PRJNA1148190	123250	475	1.738806	8.2593285	Bacteria	2	Bacteria	Bacteria	102	9.01e-22	NR	OGY22652.1	1802591	g112087	i0	39	1.78105263157895	141	86	89.1	0	48	470	177	317	OGY22652.1 MAG: phage portal protein [Candidatus Woykebacteria bacterium GWA1_44_8]	diamond	846	103	0.990291262135922	Bacteria	Bacteria candidate phyla	Candidatus Woykeibacteriota	Candidatus Woykebacteria bacterium GWA1_44_8

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