metadata: contig_metadata: 7 rows where bioproject = "PRJNA416866", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA416866", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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_class	tax_order	tax_family	tax_species
27012251	27012251	PRJNA416866_P_NODE_9782_length_208_cov_0.870748_g9638_i0	PRJNA416866	9782	208	0.870748	1.81115584	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	46.2	0.00138	NR	MDD5103287.1	2735830	g9638	i0	43.5	0.894230769230769	62	34	89.4	1	8	193	2	62	MDD5103287.1 GDP-mannose 4,6-dehydratase [Candidatus Peribacteraceae bacterium]	diamond	186	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacteraceae bacterium
29033774	29033774	PRJNA416866_P_NODE_5888_length_269_cov_1.086538_g5744_i0	PRJNA416866	5888	269	1.086538	2.92278722	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	47	0.00158	NR	MEO0160769.1	2052148	g5744	i0	33.7	0.925650557620818	83	50	87	2	1	234	8	90	MEO0160769.1 YCF48-related protein [candidate division WOR-3 bacterium]	diamond	249	47	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3				candidate division WOR-3 bacterium
30107083	30107083	PRJNA416866_P_NODE_6592_length_253_cov_3.322917_g6448_i0	PRJNA416866	6592	253	3.322917	8.40698001	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	140	4.979999999999999e-37	NR	MCL4419431.1	2052139	g6448	i0	82.1	0.99604743083004	84	14	98.4	1	251	3	502	585	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	252	140	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
30802249	30802249	PRJNA416866_P_NODE_3174_length_377_cov_1.462025_g3031_i0	PRJNA416866	3174	377	1.462025	5.51183425	Candidatus Ratteibacteria bacterium	3018269	Bacteria	Bacteria	50.8	2.9e-5	NR	MFA5645262.1	3018269	g3031	i0	28.4	1.3368700265252	74	53	58.9	0	83	304	30	103	MFA5645262.1 antibiotic biosynthesis monooxygenase [Candidatus Ratteibacteria bacterium]	diamond	504	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Ratteibacteria				Candidatus Ratteibacteria bacterium
31086665	31086665	PRJNA416866_P_NODE_11335_length_203_cov_0.901408_g11191_i0	PRJNA416866	11335	203	0.901408	1.82985824	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	107	5.36e-28	NR	MDE1970164.1	2052139	g11191	i0	72.7	3.91625615763547	66	18	97.5	0	202	5	35	100	MDE1970164.1 HIT family protein [Patescibacteria group bacterium]	diamond	795	107	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
32225422	32225422	PRJNA416866_P_NODE_5878_length_269_cov_1.288462_g5734_i0	PRJNA416866	5878	269	1.288462	3.46596278	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	79.7	1.98e-15	NR	HXN86564.1	2785449	g5734	i0	55.4	1.65055762081784	74	33	82.5	0	35	256	118	191	HXN86564.1 alpha/beta hydrolase [Candidatus Binataceae bacterium]	diamond	444	79.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
32352117	32352117	PRJNA416866_P_NODE_2479_length_434_cov_1.372654_g2336_i0	PRJNA416866	2479	434	1.372654	5.95731836	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	62.4	1.49e-9	NR	NQT80605.1	2052149	g2336	i0	46.9	1.87327188940092	81	37	54.6	3	308	72	6	82	NQT80605.1 RNA-binding protein [Candidatus Aminicenantes bacterium]	diamond	813	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota				Candidatus Aminicenantes 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);;