metadata: contig_metadata: 12 rows where bioproject = "PRJNA669701", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA669701", 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
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.
7542048	7542048	PRJNA669701_P_NODE_27806_length_445_cov_2.188172_g27411_i0	PRJNA669701	27806	445	2.188172	9.7373654	Nitrospira	1234	Bacteria	Bacteria	701	0	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g27411	i0	95.056	51.0224719101124	445	22	100	0	1	445	3063211	3062767	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	22705	706	0.992917847025496	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
8288432	8288432	PRJNA669701_P_NODE_123127_length_246_cov_2.283237_g122732_i0	PRJNA669701	123127	246	2.283237	5.61676302	Nitrospira defluvii	330214	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|300603458\|emb\|FP929003.1\|	330214	g122732	i0	99.593	1.36178861788618	246	1	100	0	1	246	824498	824743	Candidatus Nitrospira defluvii chromosome, complete genome	blastn	335	449	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
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.
17213023	17213023	PRJNA669701_P_NODE_112814_length_250_cov_0.870056_g112419_i0	PRJNA669701	112814	250	0.870056	2.17514	Nitrospira japonica	1325564	Bacteria	Bacteria	124	4.729999999999999e-24	NTclustered	gi\|1167499077\|emb\|LT828648.1\|	1325564	g112419	i0	92.045	0.352	88	7	35	0	155	242	1413045	1412958	Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I	blastn	88	124	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira japonica
22841852	22841852	PRJNA669701_P_NODE_5018_length_1110_cov_3.294118_g4731_i0	PRJNA669701	5018	1110	3.294118	36.5647098	Nitrospira	1234	Bacteria	Bacteria	1858	0	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g4731	i0	97.019	100.500900900901	1107	29	99	3	1	1106	3063251	3064354	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	111556	1873	0.991991457554725	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);;