metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA669701" 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
635381	635381	PRJNA669701_P_NODE_130301_length_244_cov_1.485380_g129906_i0	PRJNA669701	130301	244	1.48538	3.6243272	Pseudomonadati	3379134	Bacteria	Bacteria	104	5.64e-26	NR	MCK6499161.1	70125	g129906	i0	66.3	2.95081967213115	80	24	98.4	1	244	5	35	111	MCK6499161.1 AAA family ATPase [Nitrospira sp.]	diamond	720	104	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9563685	9563685	PRJNA669701_P_NODE_127768_length_245_cov_0.895349_g127373_i0	PRJNA669701	127768	245	0.895349	2.19360505	Nitrospira	1234	Bacteria	Bacteria	165	5.79e-48	NR	MEQ1847728.1	70125	g127373	i0	96.3	21.8204081632653	81	3	99.2	0	245	3	172	252	MEQ1847728.1 IscS subfamily cysteine desulfurase [Nitrospira sp.]	diamond	5346	165	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27682218	27682218	PRJNA669701_P_NODE_143624_length_239_cov_2.638554_g143229_i0	PRJNA669701	143624	239	2.638554	6.30614406	Nitrospira sp.	70125	Bacteria	Bacteria	51.6	7.09e-6	NR	HRC43098.1	70125	g143229	i0	40	0.878661087866109	70	42	87.9	0	211	2	66	135	HRC43098.1 tetratricopeptide repeat protein [Nitrospira sp.]	diamond	210	51.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28029309	28029309	PRJNA669701_P_NODE_128045_length_245_cov_0.895349_g127650_i0	PRJNA669701	128045	245	0.895349	2.19360505	Nitrospira sp.	70125	Bacteria	Bacteria	136	4.68e-37	NR	HEU4504162.1	70125	g127650	i0	98.6	0.869387755102041	71	1	86.9	0	244	32	264	334	HEU4504162.1 catalase family peroxidase [Nitrospira sp.]	diamond	213	136	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31061322	31061322	PRJNA669701_P_NODE_133455_length_243_cov_1.811765_g133060_i0	PRJNA669701	133455	243	1.811765	4.40258895	Nitrospira sp.	70125	Bacteria	Bacteria	78.6	2.91e-16	NR	HRC44879.1	70125	g133060	i0	60.6	1.55555555555556	66	25	80.2	1	204	10	5	70	HRC44879.1 MauE/DoxX family redox-associated membrane protein [Nitrospira sp.]	diamond	378	78.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31567243	31567243	PRJNA669701_P_NODE_81896_length_279_cov_3.757282_g81501_i0	PRJNA669701	81896	279	3.757282	10.48281678	Nitrospira sp.	70125	Bacteria	Bacteria	75.1	3.32e-14	NR	TKB71202.1	70125	g81501	i0	46.8	1.94623655913978	94	48	98.9	1	278	3	82	175	TKB71202.1 MAG: hypothetical protein E8D46_17700 [Nitrospira sp.]	diamond	543	75.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31725078	31725078	PRJNA669701_P_NODE_76297_length_286_cov_2.497653_g75902_i0	PRJNA669701	76297	286	2.497653	7.14328758	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	50.1	1.72e-4	NR	WP_173045152.1	1936990	g75902	i0	30	1.04895104895105	100	64	99.7	3	1	285	22	120	WP_173045152.1 hypothetical protein [Nitrospira sp. KM1]	diamond	300	50.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
32136560	32136560	PRJNA669701_P_NODE_95278_length_264_cov_1.612565_g94883_i0	PRJNA669701	95278	264	1.612565	4.2571716	Nitrospira sp.	70125	Bacteria	Bacteria	172	9.37e-51	NR	HEU4505238.1	70125	g94883	i0	97.7	1	88	2	100	0	1	264	15	102	HEU4505238.1 outer membrane beta-barrel protein [Nitrospira sp.]	diamond	264	172	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);;