metadata: contig_metadata: 11 rows where bioproject = "PRJNA800053", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA800053", 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
5899835	5899835	PRJNA800053_P_NODE_6805_length_359_cov_2.374126_g6641_i0	PRJNA800053	6805	359	2.374126	8.52311234	root	1	Root_unresolved	Root_unresolved	140	1.91e-38	NR	HAN48980.1	70125	g6641	i0	81.8	5.79108635097493	77	14	64.3	0	5	235	202	278	HAN48980.1 phage capsid protein [Nitrospira sp.]	diamond	2079	140	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
11000113	11000113	PRJNA800053_P_NODE_20929_length_245_cov_1.627907_g20765_i0	PRJNA800053	20929	245	1.627907	3.98837215	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	372	1.49e-98	NTclustered	gi\|1808878785\|dbj\|AP022671.1\|	1936990	g20765	i0	94.583	92.330612244898	240	13	98	0	4	243	4207905	4208144	Nitrospira sp. KM1 DNA, complete genome	blastn	22621	372	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
27117072	27117072	PRJNA800053_P_NODE_21562_length_244_cov_1.748538_g21398_i0	PRJNA800053	21562	244	1.748538	4.26643272	Nitrospira sp.	70125	Bacteria	Bacteria	69.7	1.17e-11	NR	HNG01977.1	70125	g21398	i0	49.3	0.922131147540984	75	35	91	2	1	222	368	440	HNG01977.1 tetratricopeptide repeat-containing glycosyltransferase family protein [Nitrospira sp.]	diamond	225	69.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27243684	27243684	PRJNA800053_P_NODE_12083_length_286_cov_3.413146_g11919_i0	PRJNA800053	12083	286	3.413146	9.76159756	Candidatus Magnetobacterium casense	1455061	Bacteria	Bacteria	72.4	5.06e-13	NR	WP_218254002.1	1455061	g11919	i0	40	0.786713286713287	75	43	78.7	1	3	227	153	225	WP_218254002.1 hypothetical protein [Candidatus Magnetobacterium casense]	diamond	225	72.4	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Candidatus Magnetobacteriaceae	Candidatus Magnetobacterium	Candidatus Magnetobacterium casense
27243693	27243693	PRJNA800053_P_NODE_8703_length_325_cov_1.817460_g8539_i0	PRJNA800053	8703	325	1.81746	5.906745	Nitrospira sp.	70125	Bacteria	Bacteria	189	4.529999999999999e-55	NR	HMV57842.1	70125	g8539	i0	84.1	0.987692307692308	107	17	98.8	0	3	323	355	461	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	321	189	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29391024	29391024	PRJNA800053_P_NODE_14209_length_271_cov_1.227273_g14045_i0	PRJNA800053	14209	271	1.227273	3.32590983	Nitrospira sp. BLG_1	3395883	Bacteria	Bacteria	166	1.41e-49	NR	WP_413933349.1	3395883	g14045	i0	96.6	0.985239852398524	89	3	98.5	0	268	2	18	106	WP_413933349.1 hypothetical protein [Nitrospira sp. BLG_1]	diamond	267	166	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. BLG_1
30402080	30402080	PRJNA800053_P_NODE_12873_length_280_cov_2.859903_g12709_i0	PRJNA800053	12873	280	2.859903	8.0077284	Nitrospira sp.	70125	Bacteria	Bacteria	175	8.94e-49	NR	MBK8380046.1	70125	g12709	i0	96.7	0.985714285714286	92	3	98.6	0	278	3	611	702	MBK8380046.1 hypothetical protein [Nitrospira sp.]	diamond	276	175	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30875545	30875545	PRJNA800053_P_NODE_16514_length_256_cov_1.054645_g16350_i0	PRJNA800053	16514	256	1.054645	2.6998912	Nitrospira sp.	70125	Bacteria	Bacteria	61.6	9.61e-9	NR	MCI0526363.1	70125	g16350	i0	50.7	0.83203125	71	26	72.7	3	33	218	112	182	MCI0526363.1 DNA polymerase [Nitrospira sp.]	diamond	213	61.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32045652	32045652	PRJNA800053_P_NODE_11918_length_288_cov_1.111628_g11754_i0	PRJNA800053	11918	288	1.111628	3.20148864	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	93.6	8.73e-20	NR	HBR22855.1	2026770	g11754	i0	51.6	0.96875	93	45	96.9	0	7	285	146	238	HBR22855.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	279	93.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
32244711	32244711	PRJNA800053_P_NODE_20858_length_245_cov_2.680233_g20694_i0	PRJNA800053	20858	245	2.680233	6.56657085	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	89	7.14e-19	NR	KPJ99589.1	1704025	g20694	i0	53.2	2.82857142857143	77	34	94.3	1	234	4	247	321	KPJ99589.1 MAG: sugar dehydratase [Nitrospira bacterium SG8_35_4]	diamond	693	89.4	0.995525727069351	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria				Nitrospira bacterium SG8_35_4
32803686	32803686	PRJNA800053_P_NODE_19740_length_247_cov_1.517241_g19576_i0	PRJNA800053	19740	247	1.517241	3.74758527	Nitrospirota bacterium	2026887	Bacteria	Bacteria	109	8.4e-26	NR	TAJ08711.1	2026887	g19576	i0	71.3	0.97165991902834	80	23	97.2	0	245	6	100	179	TAJ08711.1 MAG: flagellar biosynthesis protein FlhF [Nitrospirota bacterium]	diamond	240	109	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);;