metadata: contig_metadata: 14 rows where bioproject = "PRJNA1237347", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax

14 rows where bioproject = "PRJNA1237347", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_phylum = "Nitrospinota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
14367426	14367426	PRJNA1237347_P_NODE_195312_length_440_cov_2.365123_g188740_i0	PRJNA1237347	195312	440	2.365123	10.4065412	Candidatus Nitronauta litoralis	2705533	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1938439011\|gb\|CP048685.1\|	2705533	g188740	i0	96.97	0.465909090909091	33	1	8	0	335	367	34942	34974	MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome	blastn	205	56.5	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitronauta	Candidatus Nitronauta litoralis
24565316	24565316	PRJNA1237347_P_NODE_228620_length_397_cov_1.425926_g222048_i0	PRJNA1237347	228620	397	1.425926	5.66092622	Bacteria	2	Bacteria	Bacteria	149	1.0299999999999999e-38	NR	MDA1109176.1	2026769	g222048	i0	61.3	8.62972292191436	119	46	89.9	0	37	393	669	787	MDA1109176.1 PAS domain S-box protein [Nitrospinota bacterium]	diamond	3426	149	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26597949	26597949	PRJNA1237347_P_NODE_337241_length_310_cov_2.270042_g330668_i0	PRJNA1237347	337241	310	2.270042	7.0371302	Nitrospinota bacterium	2026769	Bacteria	Bacteria	64.3	2.19e-9	NR	MBI4384665.1	2026769	g330668	i0	60	3.35806451612903	50	20	48.4	0	1	150	617	666	MBI4384665.1 adenylate/guanylate cyclase domain-containing protein [Nitrospinota bacterium]	diamond	1041	64.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26661402	26661402	PRJNA1237347_P_NODE_430761_length_267_cov_1.293814_g424188_i0	PRJNA1237347	430761	267	1.293814	3.45448338	Nitrospinota bacterium	2026769	Bacteria	Bacteria	57.4	3.4e-7	NR	MDH5763792.1	2026769	g424188	i0	45.6	0.640449438202247	57	31	64	0	175	5	399	455	MDH5763792.1 HEAT repeat domain-containing protein [Nitrospinota bacterium]	diamond	171	57.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26756174	26756174	PRJNA1237347_P_NODE_19261_length_1803_cov_2.019075_g16804_i0	PRJNA1237347	19261	1803	2.019075	36.40392225	Nitrospinota bacterium	2026769	Bacteria	Bacteria	127	1.29e-26	NR	MBI5186125.1	2026769	g16804	i0	27.3	0.810316139767055	487	306	76.7	17	1710	328	441	905	MBI5186125.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Nitrospinota bacterium]	diamond	1461	127	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
27831097	27831097	PRJNA1237347_P_NODE_303344_length_332_cov_0.698842_g296771_i0	PRJNA1237347	303344	332	0.698842	2.32015544	Nitrospina sp.	2024844	Bacteria	Bacteria	43.9	0.0369	NR	MBT5471931.1	2024844	g296771	i0	32	0.677710843373494	75	49	66	1	242	24	18	92	MBT5471931.1 AmmeMemoRadiSam system radical SAM enzyme [Nitrospina sp.]	diamond	225	43.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
28589112	28589112	PRJNA1237347_P_NODE_307347_length_329_cov_1.218750_g300774_i0	PRJNA1237347	307347	329	1.21875	4.0096875	Nitrospinota bacterium	2026769	Bacteria	Bacteria	49.3	2.85e-4	NR	MFQ5915144.1	2026769	g300774	i0	61	0.373860182370821	41	16	37.4	0	125	3	73	113	MFQ5915144.1 ribonuclease HI family protein [Nitrospinota bacterium]	diamond	123	49.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29585882	29585882	PRJNA1237347_P_NODE_104650_length_662_cov_1.276740_g98219_i0	PRJNA1237347	104650	662	1.27674	8.4520188	Bacteria	2	Bacteria	Bacteria	62	8.95e-8	NR	MFP6870892.1	2026769	g98219	i0	32.1	1.96676737160121	168	104	74.3	5	45	536	7	168	MFP6870892.1 LamG domain-containing protein [Nitrospinota bacterium]	diamond	1302	62.4	0.993589743589744	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29693764	29693764	PRJNA1237347_P_NODE_378030_length_289_cov_1.370370_g371457_i0	PRJNA1237347	378030	289	1.37037	3.9603693	Nitrospinota bacterium	2026769	Bacteria	Bacteria	124	3.96e-32	NR	MDA0692544.1	2026769	g371457	i0	63.5	1.99307958477509	96	34	99.7	1	289	2	109	203	MDA0692544.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Nitrospinota bacterium]	diamond	576	124	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30691840	30691840	PRJNA1237347_P_NODE_434973_length_265_cov_1.604167_g428400_i0	PRJNA1237347	434973	265	1.604167	4.25104255	Pseudomonadati	3379134	Bacteria	Bacteria	134	4.21e-34	NR	MBF0293179.1	2026769	g428400	i0	69	7.59622641509434	84	26	95.1	0	14	265	573	656	MBF0293179.1 RHS repeat-associated core domain-containing protein [Nitrospinota bacterium]	diamond	2013	134	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30818304	30818304	PRJNA1237347_P_NODE_436654_length_264_cov_2.816754_g430081_i0	PRJNA1237347	436654	264	2.816754	7.43623056	Bacteria	2	Bacteria	Bacteria	127	5.03e-33	NR	OGV99163.1	1801680	g430081	i0	67.8	27.5795454545455	87	28	98.9	0	3	263	104	190	OGV99163.1 MAG: 6-phosphofructokinase [Nitrospinae bacterium RIFCSPHIGHO2_02_39_11]	diamond	7281	128	0.9921875	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium RIFCSPHIGHO2_02_39_11
30862692	30862692	PRJNA1237347_P_NODE_163174_length_496_cov_1.267139_g156612_i0	PRJNA1237347	163174	496	1.267139	6.28500944	Nitrospinales bacterium	2833568	Bacteria	Bacteria	65.5	3.79e-9	NR	MFQ5673231.1	2833568	g156612	i0	53.1	1.08870967741935	64	23	35.1	2	143	316	79	141	MFQ5673231.1 formimidoylglutamase [Nitrospinales bacterium]	diamond	540	65.5	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales			Nitrospinales bacterium
31209723	31209723	PRJNA1237347_P_NODE_117415_length_615_cov_1.040590_g110918_i0	PRJNA1237347	117415	615	1.04059	6.3996285	Nitrospina sp.	2024844	Bacteria	Bacteria	79.7	2.6e-15	NR	HIB43776.1	2024844	g110918	i0	61	0.604878048780488	59	23	28.8	0	12	188	59	117	HIB43776.1 hypothetical protein [Nitrospina sp.]	diamond	372	79.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
32476244	32476244	PRJNA1237347_P_NODE_426619_length_268_cov_4.948718_g420046_i0	PRJNA1237347	426619	268	4.948718	13.26256424	Nitrospinota bacterium	2026769	Bacteria	Bacteria	43.9	0.0193	NR	MDP7580296.1	2026769	g420046	i0	31.5	1.02985074626866	92	55	96.3	3	259	2	26	115	MDP7580296.1 sigma 54-interacting transcriptional regulator [Nitrospinota bacterium]	diamond	276	43.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota 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);;