metadata: contig_metadata: 8 rows where bioproject = "PRJNA1120060", tax_clade = "Bacteria candidate phyla" and tax

8 rows where bioproject = "PRJNA1120060", 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	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_species
2818094	2818094	PRJNA1120060_P_NODE_527583_length_361_cov_2.996528_g509941_i0	PRJNA1120060	527583	361	2.996528	10.81746608	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g509941	i0	100	0.0775623268698061	28	0	8	0	14	41	301008	300981	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26785281	26785281	PRJNA1120060_P_NODE_774961_length_323_cov_4.156000_g757092_i0	PRJNA1120060	774961	323	4.156	13.42388	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	44.3	0.0124	NR	MCE9585689.1	2052152	g757092	i0	37.7	0.56656346749226	61	37	56.7	1	13	195	95	154	MCE9585689.1 DUF192 domain-containing protein [Candidatus Nomurabacteria bacterium]	diamond	183	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28017009	28017009	PRJNA1120060_P_NODE_2844065_length_245_cov_1.093023_g2825979_i0	PRJNA1120060	2844065	245	1.093023	2.67790635	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	43.1	0.0111	NR	MCB9802691.1	2052152	g2825979	i0	35.7	0.685714285714286	56	36	68.6	0	58	225	22	77	MCB9802691.1 ribonuclease HI family protein [Candidatus Nomurabacteria bacterium]	diamond	168	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28427871	28427871	PRJNA1120060_P_NODE_387266_length_392_cov_2.789969_g369876_i0	PRJNA1120060	387266	392	2.789969	10.93667848	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	55.5	1.03e-6	NR	MDR0957338.1	2052152	g369876	i0	36.2	1.53061224489796	69	44	52.8	0	208	2	24	92	MDR0957338.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	600	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29310505	29310505	PRJNA1120060_P_NODE_1584109_length_290_cov_1.073733_g1566117_i0	PRJNA1120060	1584109	290	1.073733	3.1138257	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	53.5	1.91e-6	NR	MCB9802691.1	2052152	g1566117	i0	33.8	1.69655172413793	74	49	76.6	0	61	282	5	78	MCB9802691.1 ribonuclease HI family protein [Candidatus Nomurabacteria bacterium]	diamond	492	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29564038	29564038	PRJNA1120060_P_NODE_3047770_length_238_cov_4.472727_g3029669_i0	PRJNA1120060	3047770	238	4.472727	10.64509026	Candidatus Nomurabacteria bacterium GW2	2052152	Bacteria	Bacteria	45.8	0.00134	NR	KKS04591.1	1618736	g3029669	i0	37.5	0.80672268907563	64	39	79.4	1	192	4	40	103	KKS04591.1 MAG: hypothetical protein UU58_C0005G0040 [Candidatus Nomurabacteria bacterium GW2011_GWA2_41_25]	diamond	192	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWA2_41_25
30090609	30090609	PRJNA1120060_P_NODE_2199852_length_265_cov_1.447917_g2181800_i0	PRJNA1120060	2199852	265	1.447917	3.83698005	root	1	Root_unresolved	Root_unresolved	50.4	2.24e-5	NR	MCB9802691.1	2052152	g2181800	i0	37.5	2.06037735849057	64	40	72.5	0	196	5	4	67	MCB9802691.1 ribonuclease HI family protein [Candidatus Nomurabacteria bacterium]	diamond	546	50.8	0.992125984251969	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32440407	32440407	PRJNA1120060_P_NODE_2301619_length_261_cov_1.872340_g2283560_i0	PRJNA1120060	2301619	261	1.87234	4.8868074	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	46.2	9.1e-4	NR	MCB9802691.1	2052152	g2283560	i0	41.1	1.86206896551724	56	33	64.4	0	180	13	18	73	MCB9802691.1 ribonuclease HI family protein [Candidatus Nomurabacteria bacterium]	diamond	486	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;