metadata: contig_metadata: 5 rows where bioproject = "PRJNA534016" and tax

5 rows where bioproject = "PRJNA534016" 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_species
24070228	24070228	PRJNA534016_P_NODE_13619_length_251_cov_0.865169_g13529_i0	PRJNA534016	13619	251	0.865169	2.17157419	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	429	8.99e-116	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g13529	i0	97.984	94.8366533864542	248	4	99	1	1	248	152418	152172	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	23804	431	0.995359628770302	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharibacteria bacterium oral taxon 488
26824796	26824796	PRJNA534016_P_NODE_7381_length_311_cov_2.840336_g7291_i0	PRJNA534016	7381	311	2.840336	8.83344496	Parcubacteria group bacterium	2026774	Bacteria	Bacteria	140	4.58e-40	NR	MEQ1500496.1	2026774	g7291	i0	65.3	0.97427652733119	101	35	97.4	0	9	311	2	102	MEQ1500496.1 site-specific DNA-methyltransferase [Parcubacteria group bacterium]	diamond	303	140	1	Bacteria	Bacteria candidate phyla		Parcubacteria group bacterium
28120065	28120065	PRJNA534016_P_NODE_8505_length_291_cov_2.422018_g8415_i0	PRJNA534016	8505	291	2.422018	7.04807238	Candidatus Falkowbacteria bacterium RIFCSPLOWO2_	2053554	Bacteria	Bacteria	46.2	0.00384	NR	OGF23892.1	1797989	g8415	i0	30.4	0.948453608247423	92	64	94.8	0	16	291	60	151	OGF23892.1 MAG: hypothetical protein A3H66_01275 [Candidatus Falkowbacteria bacterium RIFCSPLOWO2_02_FULL_45_21]	diamond	276	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Falkowiibacteriota	Candidatus Falkowbacteria bacterium RIFCSPLOWO2_02_FULL_45_21
31310042	31310042	PRJNA534016_P_NODE_2795_length_489_cov_1.795673_g2705_i0	PRJNA534016	2795	489	1.795673	8.78084097	Parcubacteria group bacterium CG1_	2026774	Bacteria	Bacteria	45.8	0.0323	NR	OIO46527.1	1805303	g2705	i0	36.3	0.49079754601227	80	40	44.2	3	471	256	318	394	OIO46527.1 MAG: pyruvate kinase [Parcubacteria group bacterium CG1_02_37_51]	diamond	240	45.8	1	Bacteria	Bacteria candidate phyla		Parcubacteria group bacterium CG1_02_37_51
31436590	31436590	PRJNA534016_P_NODE_17716_length_242_cov_0.911243_g17626_i0	PRJNA534016	17716	242	0.911243	2.20520806	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	98.2	4.23e-22	NR	MEA3273413.1	2052139	g17626	i0	57.5	0.991735537190083	80	34	99.2	0	1	240	179	258	MEA3273413.1 hypothetical protein [Patescibacteria group bacterium]	diamond	240	98.2	1	Bacteria	Bacteria candidate phyla		Patescibacteria group 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);;