metadata: contig_metadata: 13 rows where bioproject = "PRJNA395690", tax_phylum = "Nitrospirota" and tax

13 rows where bioproject = "PRJNA395690", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

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
11890317	11890317	PRJNA395690_P_NODE_12210_length_233_cov_1.592391_g12058_i0	PRJNA395690	12210	233	1.592391	3.71027103	Candidatus Manganitrophus sp.	2927580	Bacteria	Bacteria	65.8	2.68e-6	NTclustered	gi\|2449729286\|gb\|CP114553.1\|	2927580	g12058	i0	100	0.583690987124464	35	0	15	0	59	93	2713777	2713811	MAG: Candidatus Manganitrophus sp. isolate GAC1 chromosome, complete genome	blastn	136	65.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Candidatus Troglogloeales	Candidatus Manganitrophaceae	Candidatus Manganitrophus	Candidatus Manganitrophus sp.
22755883	22755883	PRJNA395690_P_NODE_13838_length_219_cov_0.900000_g13686_i0	PRJNA395690	13838	219	0.9	1.971	Bacteria	2	Bacteria	Bacteria	115	2.44e-21	NTclustered	gi\|298571308\|gb\|HM454279.1\|	798576	g13686	i0	76.889	52.8219178082192	225	38	100	13	1	219	6337	6121	Uncultured Nitrospirae bacterium MY2-1F genomic sequence	blastn	11568	115	1	Bacteria	Pseudomonadati	Nitrospirota					uncultured Nitrospirae bacterium MY2-1F
23363600	23363600	PRJNA395690_P_NODE_15039_length_209_cov_2.550000_g14887_i0	PRJNA395690	15039	209	2.55	5.3295	Nitrospirota bacterium	2026887	Bacteria	Bacteria	84.2	6.5e-12	NTclustered	gi\|2108317525\|gb\|CP070669.1\|	2026887	g14887	i0	90.625	22.5263157894737	64	4	31	2	37	100	568012	568073	MAG: Nitrospirae bacterium isolate bin746 chromosome	blastn	4708	84.2	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
26632193	26632193	PRJNA395690_P_NODE_26101_length_172_cov_1.479675_g25949_i0	PRJNA395690	26101	172	1.479675	2.545041	Nitrospira sp.	70125	Bacteria	Bacteria	110	2.3e-27	NR	MFO0701275.1	70125	g25949	i0	100	0.976744186046512	56	0	97.7	0	3	170	230	285	MFO0701275.1 SGNH/GDSL hydrolase family protein [Nitrospira sp.]	diamond	168	110	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26822328	26822328	PRJNA395690_P_NODE_12921_length_226_cov_2.666667_g12769_i0	PRJNA395690	12921	226	2.666667	6.02666742	Nitrospirota bacterium	2026887	Bacteria	Bacteria	45.1	5.35e-4	NR	MCL5954451.1	2026887	g12769	i0	52.2	0.610619469026549	46	22	61.1	0	174	37	10	55	MCL5954451.1 hypothetical protein [Nitrospirota bacterium]	diamond	138	45.1	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
27106789	27106789	PRJNA395690_P_NODE_2162_length_528_cov_1.098121_g2015_i0	PRJNA395690	2162	528	1.098121	5.79807888	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	79	1.78e-14	NR	MBX9660795.1	2026770	g2015	i0	35	2.41477272727273	103	67	58.5	0	483	175	99	201	MBX9660795.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	1275	79	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
27864890	27864890	PRJNA395690_P_NODE_29525_length_166_cov_0.871795_g29373_i0	PRJNA395690	29525	166	0.871795	1.4471797	Nitrospirales bacterium	2358460	Bacteria	Bacteria	45.8	2.3e-4	NR	MFI5222681.1	2358460	g29373	i0	46.5	0.77710843373494	43	23	77.7	0	13	141	10	52	MFI5222681.1 hypothetical protein [Nitrospirales bacterium]	diamond	129	45.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales			Nitrospirales bacterium
28686232	28686232	PRJNA395690_P_NODE_8367_length_279_cov_2.217391_g8215_i0	PRJNA395690	8367	279	2.217391	6.18652089	Nitrospirales bacterium	2358460	Bacteria	Bacteria	41.6	0.046	NR	MFI5248028.1	2358460	g8215	i0	44	0.537634408602151	50	24	53.8	1	128	277	1	46	MFI5248028.1 hypothetical protein [Nitrospirales bacterium]	diamond	150	41.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales			Nitrospirales bacterium
29949039	29949039	PRJNA395690_P_NODE_25551_length_173_cov_1.637097_g25399_i0	PRJNA395690	25551	173	1.637097	2.83217781	Nitrospira sp.	70125	Bacteria	Bacteria	52	6.5e-6	NR	MCE3222851.1	70125	g25399	i0	51.2	3.06936416184971	43	21	74.6	0	21	149	59	101	MCE3222851.1 hypothetical protein [Nitrospira sp.]	diamond	531	52	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30029036	30029036	PRJNA395690_P_NODE_29551_length_166_cov_0.871795_g29399_i0	PRJNA395690	29551	166	0.871795	1.4471797	root	1	Root_unresolved	Root_unresolved	57.8	6.63e-8	NR	RJR19142.1	2026770	g29399	i0	52.1	2.80120481927711	48	19	79.5	1	133	2	1370	1417	RJR19142.1 MAG: hypothetical protein C4581_05430 [Nitrospiraceae bacterium]	diamond	465	58.2	0.993127147766323	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
32020401	32020401	PRJNA395690_P_NODE_18358_length_190_cov_1.758865_g18206_i0	PRJNA395690	18358	190	1.758865	3.3418435	Bacteria	2	Bacteria	Bacteria	65.9	1.3e-10	NR	MFO0697880.1	70125	g18206	i0	53.2	3.75789473684211	62	27	97.9	1	4	189	168	227	MFO0697880.1 tetratricopeptide repeat protein [Nitrospira sp.]	diamond	714	66.2	0.995468277945619	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32305429	32305429	PRJNA395690_P_NODE_36299_length_161_cov_0.910714_g36147_i0	PRJNA395690	36299	161	0.910714	1.46624954	Pseudomonadati	3379134	Bacteria	Bacteria	89	1.46e-19	NR	HNL89580.1	70125	g36147	i0	84.9	1.97515527950311	53	8	98.8	0	3	161	184	236	HNL89580.1 HAD family hydrolase [Nitrospira sp.]	diamond	318	89	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32368659	32368659	PRJNA395690_P_NODE_9199_length_268_cov_1.630137_g9047_i0	PRJNA395690	9199	268	1.630137	4.36876716	Nitrospira	1234	Bacteria	Bacteria	70.9	3.49e-13	NR	MEQ1795070.1	70125	g9047	i0	41.9	1.92537313432836	86	49	96.3	1	7	264	34	118	MEQ1795070.1 hypothetical protein [Nitrospira sp.]	diamond	516	70.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.

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