metadata: contig_metadata: 5 rows where bioproject = "PRJNA404067", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA404067", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Nomuraibacteriota"

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	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_species
26648789	26648789	PRJNA404067_P_NODE_26501_length_219_cov_1.240506_g26114_i0	PRJNA404067	26501	219	1.240506	2.71670814	Bacteria	2	Bacteria	Bacteria	84	1.56e-19	NR	OGI95384.1	1801780	g26114	i0	70.2	4.68493150684932	57	17	78.1	2	172	2	58	OGI95384.1 MAG: hypothetical protein A2917_02370 [Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_42_17]	diamond	1026	84.7	0.991735537190083	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_42_17
27281885	27281885	PRJNA404067_P_NODE_26683_length_218_cov_19.611465_g26296_i0	PRJNA404067	26683	218	19.611465	42.7529937	Bacteria	2	Bacteria	Bacteria	103	8.37e-24	NR	MEI7689334.1	2052152	g26296	i0	69.4	4.94036697247706	72	22	99.1	3	218	271	342	MEI7689334.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	1077	104	0.990384615384615	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27612673	27612673	PRJNA404067_P_NODE_42144_length_188_cov_2.425197_g41757_i0	PRJNA404067	42144	188	2.425197	4.55937036	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	91.3	1.33e-19	NR	USN95535.1	2052152	g41757	i0	69.4	0.98936170212766	62	19	98.9	2	187	112	173	USN95535.1 MAG: recombinase family protein [Candidatus Nomurabacteria bacterium]	diamond	186	91.3	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27675931	27675931	PRJNA404067_P_NODE_36784_length_203_cov_0.866197_g36397_i0	PRJNA404067	36784	203	0.866197	1.75837991	Candidatus Nomurabacteria bacterium GW2	2052152	Bacteria	Bacteria	108	1.01e-26	NR	KKS03733.1	1618736	g36397	i0	76.1	1.98029556650246	67	16	99	3	203	196	262	KKS03733.1 MAG: Inner-membrane translocator [Candidatus Nomurabacteria bacterium GW2011_GWA2_41_25]	diamond	402	108	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWA2_41_25
29854358	29854358	PRJNA404067_P_NODE_38511_length_201_cov_1.171429_g38124_i0	PRJNA404067	38511	201	1.171429	2.35457229	Candidatus Nomurabacteria bacterium CG1	2052152	Bacteria	Bacteria	108	9.81e-26	NR	PIR68243.1	1974731	g38124	i0	84.8	0.985074626865672	66	10	98.5	2	199	506	571	PIR68243.1 MAG: ribonuclease J [Candidatus Nomurabacteria bacterium CG10_big_fil_rev_8_21_14_0_10_35_16]	diamond	198	108	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium CG10_big_fil_rev_8_21_14_0_10_35_16

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