metadata: contig_metadata: 15 rows where bioproject = "PRJNA942359" and tax

15 rows where bioproject = "PRJNA942359" and tax_phylum = "Nitrospirota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
922987	922987	PRJNA942359_P_NODE_19841_length_242_cov_1.029586_g19726_i0	PRJNA942359	19841	242	1.029586	2.49159812	Nitrospira sp.	70125	Bacteria	Bacteria	176	1.24e-39	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g19726	i0	80.162	1.97520661157025	247	39	100	9	1	242	393502	393743	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	478	176	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2198360	2198360	PRJNA942359_P_NODE_20502_length_235_cov_2.209877_g20387_i0	PRJNA942359	20502	235	2.209877	5.19321095	Nitrospira sp.	70125	Bacteria	Bacteria	313	8.75e-81	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g20387	i0	90.638	2.9531914893617	235	22	100	0	1	235	2488386	2488620	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	694	313	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
11126589	11126589	PRJNA942359_P_NODE_17829_length_246_cov_0.901734_g17714_i0	PRJNA942359	17829	246	0.901734	2.21826564	Nitrospirota bacterium	2026887	Bacteria	Bacteria	160	9.04e-47	NR	MCE9535777.1	2026887	g17714	i0	97.6	2	82	2	100	0	246	1	182	263	MCE9535777.1 ATP-grasp domain-containing protein [Nitrospirota bacterium]	diamond	492	160	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
11462625	11462625	PRJNA942359_P_NODE_18969_length_244_cov_0.912281_g18854_i0	PRJNA942359	18969	244	0.912281	2.22596564	Nitrospira	1234	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g18854	i0	98.361	5.82786885245902	244	4	100	0	1	244	707633	707876	MAG: Nitrospira sp. isolate DJ chromosome	blastn	1422	429	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
13676614	13676614	PRJNA942359_P_NODE_15491_length_249_cov_0.886364_g15376_i0	PRJNA942359	15491	249	0.886364	2.20704636	Nitrospira sp.	70125	Bacteria	Bacteria	257	4.45e-64	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g15376	i0	86.134	7.60642570281125	238	33	96	0	7	244	1842685	1842448	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	1894	257	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
14950916	14950916	PRJNA942359_P_NODE_17192_length_247_cov_0.873563_g17077_i0	PRJNA942359	17192	247	0.873563	2.15770061	Candidatus Nitrospira allomarina	3020900	Bacteria	Bacteria	200	7.529999999999999e-47	NTclustered	gi\|2582126190\|gb\|CP116967.1\|	3020900	g17077	i0	86.022	0.753036437246964	186	26	75	0	62	247	2306419	2306604	Candidatus Nitrospira allomarina strain VA chromosome, complete genome	blastn	186	200	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira allomarina
16225777	16225777	PRJNA942359_P_NODE_10993_length_270_cov_3.060914_g10878_i0	PRJNA942359	10993	270	3.060914	8.2644678	Candidatus Nitrospira neomarina	3020899	Bacteria	Bacteria	340	4.719999999999999e-89	NTclustered	gi\|2582130041\|gb\|CP116968.1\|	3020899	g10878	i0	89.377	3.03333333333333	273	25	100	3	1	270	2788660	2788389	Candidatus Nitrospira neomarina strain DK chromosome, complete genome	blastn	819	340	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira neomarina
16226050	16226050	PRJNA942359_P_NODE_6293_length_336_cov_1.262357_g6178_i0	PRJNA942359	6293	336	1.262357	4.24151952	uncultured Nitrospira sp.	157176	Bacteria	Bacteria	199	4.97e-61	NR	WP_342349387.1	157176	g6178	i0	90.8	1.94642857142857	109	10	97.3	0	327	1	1	109	WP_342349387.1 alpha/beta hydrolase [uncultured Nitrospira sp.]	diamond	654	199	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	uncultured Nitrospira sp.
18774729	18774729	PRJNA942359_P_NODE_17735_length_246_cov_0.901734_g17620_i0	PRJNA942359	17735	246	0.901734	2.21826564	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g17620	i0	100	1	246	0	100	0	1	246	867154	867399	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	246	455	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
25149029	25149029	PRJNA942359_P_NODE_10000_length_280_cov_3.352657_g9885_i0	PRJNA942359	10000	280	3.352657	9.3874396	Nitrospira japonica	1325564	Bacteria	Bacteria	316	8.289999999999998e-82	NTclustered	gi\|1167499077\|emb\|LT828648.1\|	1325564	g9885	i0	87.143	10.9321428571429	280	34	100	2	1	280	982336	982613	Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I	blastn	3061	316	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira japonica
28548229	28548229	PRJNA942359_P_NODE_17367_length_246_cov_0.901734_g17252_i0	PRJNA942359	17367	246	0.901734	2.21826564	Nitrospira	1234	Bacteria	Bacteria	125	4.02e-34	NR	TKB52926.1	70125	g17252	i0	86.4	2.8780487804878	59	8	72	0	179	3	1	59	TKB52926.1 MAG: hypothetical protein E8D50_09080 [Nitrospira sp.]	diamond	708	125	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29116469	29116469	PRJNA942359_P_NODE_18408_length_245_cov_0.906977_g18293_i0	PRJNA942359	18408	245	0.906977	2.22209365	Nitrospira	1234	Bacteria	Bacteria	133	1.81e-38	NR	ULA59642.1	70125	g18293	i0	92.4	3.23265306122449	66	5	80.8	0	243	46	31	96	ULA59642.1 MAG: Cytoplasmic protein [Nitrospira sp.]	diamond	792	133	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30214654	30214654	PRJNA942359_P_NODE_10552_length_275_cov_1.544554_g10437_i0	PRJNA942359	10552	275	1.544554	4.2475235	Candidatus Nitrobium versatile	2884831	Bacteria	Bacteria	75.1	2.31e-13	NR	MBZ0154906.1	2884831	g10437	i0	87.2	0.425454545454545	39	5	42.5	0	275	159	1069	1107	MBZ0154906.1 DUF499 domain-containing protein [Candidatus Nitrobium versatile]	diamond	117	75.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Candidatus Nitrobium	Candidatus Nitrobium versatile
30695512	30695512	PRJNA942359_P_NODE_6613_length_330_cov_0.898833_g6498_i0	PRJNA942359	6613	330	0.898833	2.9661489	Bacteria	2	Bacteria	Bacteria	43.1	0.0412	NR	MEC4672313.1	2026887	g6498	i0	36.9	1.43636363636364	84	49	72.7	2	87	326	10	93	MEC4672313.1 DUF192 domain-containing protein [Nitrospirota bacterium]	diamond	474	43.5	0.990804597701149	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
32586354	32586354	PRJNA942359_P_NODE_17819_length_246_cov_0.901734_g17704_i0	PRJNA942359	17819	246	0.901734	2.21826564	Nitrospira lenta	1436998	Bacteria	Bacteria	104	1.5600000000000002e-26	NR	WP_121988829.1	1436998	g17704	i0	91.7	0.731707317073171	60	5	73.2	0	182	3	1	60	WP_121988829.1 hypothetical protein [Nitrospira lenta]	diamond	180	104	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta

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