metadata: contig_metadata: 18 rows where bioproject = "PRJNA283169" and tax

18 rows where bioproject = "PRJNA283169" 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
1646598	1646598	PRJNA283169_P_NODE_6802_length_167_cov_0.872881_g6739_i0	PRJNA283169	6802	167	0.872881	1.45771127	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	237	3.599999999999999e-58	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g6739	i0	92.216	28.9041916167665	167	13	100	0	1	167	431413	431247	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	4827	237	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8025034	8025034	PRJNA283169_P_NODE_2907_length_243_cov_1.582474_g2844_i0	PRJNA283169	2907	243	1.582474	3.84541182	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	117	7.6600000000000005e-22	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g2844	i0	93.671	0.473251028806584	79	4	33	1	53	131	254865	254788	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	115	117	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18223498	18223498	PRJNA283169_P_NODE_8235_length_157_cov_2.388889_g8172_i0	PRJNA283169	8235	157	2.388889	3.75055573	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	104	3.53e-18	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g8172	i0	95.385	7.51592356687898	65	3	41	0	1	65	125420	125356	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1180	104	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
19497715	19497715	PRJNA283169_P_NODE_4496_length_199_cov_1.386667_g4433_i0	PRJNA283169	4496	199	1.386667	2.75946733	Bacteria	2	Bacteria	Bacteria	118	3.39e-29	NR	MCE9517680.1	2052152	g4433	i0	86.4	3.97989949748744	66	9	99.5	0	198	1	108	173	MCE9517680.1 translational GTPase TypA [Candidatus Nomurabacteria bacterium]	diamond	792	119	0.991596638655462	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27800791	27800791	PRJNA283169_P_NODE_4404_length_201_cov_1.210526_g4341_i0	PRJNA283169	4404	201	1.210526	2.43315726	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	126	1.91e-32	NR	MCX6757640.1	2052152	g4341	i0	89.4	3.94029850746269	66	7	98.5	0	2	199	158	223	MCX6757640.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	792	126	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28400580	28400580	PRJNA283169_P_NODE_1266_length_352_cov_1.610561_g1204_i0	PRJNA283169	1266	352	1.610561	5.66917472	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	166	1.8e-45	NR	QQR50401.1	2052152	g1204	i0	73.7	1.95170454545455	114	30	97.2	0	9	350	358	471	QQR50401.1 MAG: hypothetical protein IPF86_00565 [Candidatus Nomurabacteria bacterium]	diamond	687	166	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28527076	28527076	PRJNA283169_P_NODE_5927_length_176_cov_1.188976_g5864_i0	PRJNA283169	5927	176	1.188976	2.09259776	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	56.6	1.91e-7	NR	HCC06132.1	2052152	g5864	i0	54.4	0.971590909090909	57	20	97.2	1	3	173	420	470	HCC06132.1 DNA primase [Candidatus Nomurabacteria bacterium]	diamond	171	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28684923	28684923	PRJNA283169_P_NODE_5807_length_178_cov_1.069767_g5744_i0	PRJNA283169	5807	178	1.069767	1.90418526	Candidatus Nomurabacteria bacterium GW2	2052152	Bacteria	Bacteria	114	9.929999999999999e-30	NR	KKP85796.1	1618727	g5744	i0	86.2	0.97752808988764	58	8	97.8	0	176	3	65	122	KKP85796.1 MAG: Ribulose-phosphate 3-epimerase [Candidatus Nomurabacteria bacterium GW2011_GWA1_35_8]	diamond	174	114	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWA1_35_8
28860148	28860148	PRJNA283169_S_NODE_3268_length_164_cov_0.173913_g3254_i0	PRJNA283169	3268	164	0.173913	0.28521732	root	1	Root_unresolved	Root_unresolved	99	1.2499999999999999e-23	NR	KKR79715.1	1618734	g3254	i0	100	110.634146341463	48	0	87.8	0	1	144	29	76	KKR79715.1 MAG: Holliday junction ATP-dependent DNA helicase RuvB [Candidatus Nomurabacteria bacterium GW2011_GWA2_40_9]	diamond	18144	99	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWA2_40_9
29063751	29063751	PRJNA283169_P_NODE_7508_length_164_cov_0.904348_g7445_i0	PRJNA283169	7508	164	0.904348	1.48313072	Candidatus Nomurabacteria bacterium RIFOXYC2_FULL_36_8	1801807	Bacteria	Bacteria	109	1.54e-26	NR	OGJ11840.1	1801807	g7445	i0	94.4	0.98780487804878	54	3	98.8	0	164	3	69	122	OGJ11840.1 MAG: hypothetical protein A2467_00260 [Candidatus Nomurabacteria bacterium RIFOXYC2_FULL_36_8]	diamond	162	109	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFOXYC2_FULL_36_8
29144763	29144763	PRJNA283169_P_NODE_4609_length_197_cov_1.513514_g4546_i0	PRJNA283169	4609	197	1.513514	2.98162258	Bacteria	2	Bacteria	Bacteria	57.4	2.34e-8	NR	MEI6352628.1	2052152	g4546	i0	57.1	3.19796954314721	42	18	64	0	71	196	1	42	MEI6352628.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	630	57.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29459857	29459857	PRJNA283169_P_NODE_7670_length_164_cov_0.869565_g7607_i0	PRJNA283169	7670	164	0.869565	1.4260866	Bacteria	2	Bacteria	Bacteria	97.8	4.99e-22	NR	KKP24059.1	1618771	g7607	i0	95.9	24.2012195121951	49	2	89.6	0	2	148	66	114	KKP24059.1 MAG: Type IV secretory pathway VirB4 component-like protein [Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133]	diamond	3969	98.2	0.995926680244399	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133
29694772	29694772	PRJNA283169_S_NODE_1290_length_239_cov_0.200000_g1276_i0	PRJNA283169	1290	239	0.2	0.478	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	73.6	2.61e-13	NR	MCE9549388.1	2052152	g1276	i0	63	0.677824267782427	54	20	67.8	0	1	162	44	97	MCE9549388.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	162	73.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29965499	29965499	PRJNA283169_P_NODE_6991_length_166_cov_0.888889_g6928_i0	PRJNA283169	6991	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	80.1	1.54e-16	NR	OIO32536.1	1805282	g6928	i0	69.8	2.87349397590361	53	16	95.8	0	164	6	140	192	OIO32536.1 MAG: hypothetical protein AUJ44_02145 [Candidatus Nomurabacteria bacterium CG1_02_47_685]	diamond	477	80.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium CG1_02_47_685
30818485	30818485	PRJNA283169_P_NODE_894_length_410_cov_1.412742_g832_i0	PRJNA283169	894	410	1.412742	5.7922422	Bacteria	2	Bacteria	Bacteria	117	5.37e-30	NR	OGI66136.1	1801739	g832	i0	92.3	2.85365853658537	65	5	47.6	0	2	196	151	215	OGI66136.1 MAG: hypothetical protein A2647_03100 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_40_24b]	diamond	1170	118	0.991525423728814	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_40_24b
30832383	30832383	PRJNA283169_P_NODE_4634_length_197_cov_1.033784_g4571_i0	PRJNA283169	4634	197	1.033784	2.03655448	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	101	6.41e-24	NR	HCC06074.1	2052152	g4571	i0	87	1.64467005076142	54	7	82.2	0	18	179	207	260	HCC06074.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	324	101	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31907413	31907413	PRJNA283169_S_NODE_1657_length_215_cov_0.240964_g1643_i0	PRJNA283169	1657	215	0.240964	0.5180726	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	67	7.17e-11	NR	MCX6756108.1	2052152	g1643	i0	58.7	2.6651162790697698	63	26	87.9	0	8	196	12	74	MCX6756108.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Candidatus Nomurabacteria bacterium]	diamond	573	67	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32129107	32129107	PRJNA283169_S_NODE_3218_length_165_cov_0.094828_g3204_i0	PRJNA283169	3218	165	0.094828	0.1564662	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_	2052152	Bacteria	Bacteria	52.8	1.34e-6	NR	OGI68902.1	1801736	g3204	i0	72.4	1.58181818181818	29	8	52.7	0	77	163	1	29	OGI68902.1 MAG: hypothetical protein A2732_00555 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_40_10]	diamond	261	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_40_10

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