metadata: contig_metadata: 8 rows where bioproject = "PRJDB4941", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJDB4941", tax_kingdom = "Pseudomonadati" 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
12460688	12460688	PRJDB4941_P_NODE_12130_length_316_cov_2.378277_g11362_i0	PRJDB4941	12130	316	2.378277	7.51535532	Nitrospirota bacterium	2026887	Bacteria	Bacteria	186	8.589999999999997e-55	NR	MCZ6801735.1	2026887	g11362	i0	83.7	1.93670886075949	104	17	98.7	0	3	314	241	344	MCZ6801735.1 glycosyltransferase family 4 protein [Nitrospirota bacterium]	diamond	612	186	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
23933893	23933893	PRJDB4941_P_NODE_11279_length_331_cov_1.695035_g10511_i0	PRJDB4941	11279	331	1.695035	5.61056585	Nitrospira	1234	Bacteria	Bacteria	106	2.36e-18	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g10511	i0	93.151	21.416918429003	73	4	22	1	160	232	2250419	2250348	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	7089	106	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
26963088	26963088	PRJDB4941_P_NODE_34902_length_168_cov_1.310924_g34134_i0	PRJDB4941	34902	168	1.310924	2.20235232	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	2.39e-7	NR	WHZ24630.1	70125	g34134	i0	45.5	1.96428571428571	55	30	98.2	0	165	1	277	331	WHZ24630.1 MAG: hypothetical protein OJF47_003742 [Nitrospira sp.]	diamond	330	56.6	0.992932862190813	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28106276	28106276	PRJDB4941_P_NODE_37285_length_166_cov_0.888889_g36517_i0	PRJDB4941	37285	166	0.888889	1.47555574	Nitrospirota bacterium	2026887	Bacteria	Bacteria	84.7	2.13e-17	NR	MBI5640577.1	2026887	g36517	i0	69.1	6.95783132530121	55	17	99.4	0	165	1	529	583	MBI5640577.1 response regulator [Nitrospirota bacterium]	diamond	1155	84.7	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28200887	28200887	PRJDB4941_P_NODE_14406_length_282_cov_1.072961_g13638_i0	PRJDB4941	14406	282	1.072961	3.02575002	Nitrospirota bacterium	2026887	Bacteria	Bacteria	111	4.1800000000000005e-27	NR	MBI3605363.1	2026887	g13638	i0	60.9	1.86170212765957	87	34	92.6	0	261	1	209	295	MBI3605363.1 hypothetical protein [Nitrospirota bacterium]	diamond	525	111	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28479397	28479397	PRJDB4941_P_NODE_35546_length_167_cov_2.220339_g34778_i0	PRJDB4941	35546	167	2.220339	3.70796613	Pseudomonadati	3379134	Bacteria	Bacteria	66.6	4.93e-11	NR	MCC6968444.1	70125	g34778	i0	54.5	2.96407185628743	55	25	98.8	0	166	2	190	244	MCC6968444.1 glycosyltransferase family 39 protein [Nitrospira sp.]	diamond	495	67	0.994029850746269	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28921219	28921219	PRJDB4941_P_NODE_8548_length_402_cov_4.121813_g7780_i0	PRJDB4941	8548	402	4.121813	16.56968826	Pseudomonadati	3379134	Bacteria	Bacteria	144	6.11e-37	NR	MEW5744165.1	2026887	g7780	i0	63.7	3.58955223880597	124	45	92.5	0	17	388	219	342	MEW5744165.1 PKD domain-containing protein [Nitrospirota bacterium]	diamond	1443	145	0.993103448275862	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30695939	30695939	PRJDB4941_P_NODE_9674_length_368_cov_1.777429_g8906_i0	PRJDB4941	9674	368	1.777429	6.54093872	Nitrospirota bacterium	2026887	Bacteria	Bacteria	73.6	5.7e-13	NR	MEK7748115.1	2026887	g8906	i0	59	0.872282608695652	61	25	49.7	0	185	3	2	62	MEK7748115.1 DUF998 domain-containing protein [Nitrospirota bacterium]	diamond	321	73.6	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota 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);;