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

11 rows where bioproject = "PRJNA690124", 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
12148849	12148849	PRJNA690124_P_NODE_46890_length_250_cov_0.881356_g46524_i0	PRJNA690124	46890	250	0.881356	2.20339	Nitrospirota	40117	Bacteria	Bacteria	125	4.1499999999999986e-34	NR	MBM4128633.1	70125	g46524	i0	79.3	2.952	82	12	98.4	1	248	3	76	152	MBM4128633.1 D-alanine--D-alanine ligase [Nitrospira sp.]	diamond	738	125	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24895886	24895886	PRJNA690124_P_NODE_51080_length_246_cov_0.901734_g50714_i0	PRJNA690124	51080	246	0.901734	2.21826564	Bacteria	2	Bacteria	Bacteria	154	4.86e-44	NR	OGX10387.1	1801718	g50714	i0	97.5	1.97560975609756	81	2	98.8	0	2	244	6	86	OGX10387.1 MAG: ketol-acid reductoisomerase [Nitrospirae bacterium RIFCSPLOWO2_12_FULL_63_8]	diamond	486	154	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirae bacterium RIFCSPLOWO2_12_FULL_63_8
26670586	26670586	PRJNA690124_P_NODE_52601_length_245_cov_0.906977_g52235_i0	PRJNA690124	52601	245	0.906977	2.22209365	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	169	8.199999999999999e-49	NR	HET9395606.1	2026770	g52235	i0	100	3.96734693877551	81	0	99.2	0	245	3	284	364	HET9395606.1 alpha-amylase family glycosyl hydrolase [Nitrospiraceae bacterium]	diamond	972	169	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
28440510	28440510	PRJNA690124_P_NODE_46026_length_251_cov_0.876404_g45660_i0	PRJNA690124	46026	251	0.876404	2.19977404	Nitrospirota bacterium	2026887	Bacteria	Bacteria	85.9	2.67e-17	NR	PHX90426.1	2026887	g45660	i0	93.6	0.561752988047809	47	3	56.2	0	3	143	584	630	PHX90426.1 MAG: hypothetical protein CK534_05520 [Nitrospirota bacterium]	diamond	141	85.9	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30125208	30125208	PRJNA690124_P_NODE_44852_length_252_cov_0.871508_g44486_i0	PRJNA690124	44852	252	0.871508	2.19620016	Dissulfurispira	2811506	Bacteria	Bacteria	77	4.92e-16	NR	MEW6410371.1	2026887	g44486	i0	48.1	1.85714285714286	79	41	94	0	239	3	5	83	MEW6410371.1 nucleotidyltransferase domain-containing protein [Nitrospirota bacterium]	diamond	468	77	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30208482	30208482	PRJNA690124_P_NODE_52452_length_245_cov_0.906977_g52086_i0	PRJNA690124	52452	245	0.906977	2.22209365	Nitrospira sp.	70125	Bacteria	Bacteria	167	4.35e-49	NR	MBM4123376.1	70125	g52086	i0	95.1	0.991836734693878	81	4	99.2	0	245	3	170	250	MBM4123376.1 FMN-binding protein [Nitrospira sp.]	diamond	243	167	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30682491	30682491	PRJNA690124_P_NODE_52213_length_245_cov_0.906977_g51847_i0	PRJNA690124	52213	245	0.906977	2.22209365	Nitrospirota bacterium	2026887	Bacteria	Bacteria	73.2	6.9e-13	NR	MBI5666217.1	2026887	g51847	i0	52.9	0.857142857142857	70	30	83.3	2	243	40	146	214	MBI5666217.1 DNA ligase [Nitrospirota bacterium]	diamond	210	73.2	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
31187884	31187884	PRJNA690124_P_NODE_44195_length_252_cov_0.871508_g43829_i0	PRJNA690124	44195	252	0.871508	2.19620016	Nitrospirales bacterium	2358460	Bacteria	Bacteria	85.9	1e-18	NR	MDO8547866.1	2358460	g43829	i0	59.2	0.904761904761905	76	29	88.1	2	225	4	49	124	MDO8547866.1 hypothetical protein [Nitrospirales bacterium]	diamond	228	85.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales			Nitrospirales bacterium
31757520	31757520	PRJNA690124_P_NODE_50337_length_247_cov_0.896552_g49971_i0	PRJNA690124	50337	247	0.896552	2.21448344	Nitrospirota bacterium	2026887	Bacteria	Bacteria	83.6	1.62e-16	NR	MEW5745900.1	2026887	g49971	i0	50	1.02024291497976	84	38	98.4	2	245	3	537	619	MEW5745900.1 hypothetical protein [Nitrospirota bacterium]	diamond	252	83.6	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
31820641	31820641	PRJNA690124_P_NODE_48157_length_249_cov_0.886364_g47791_i0	PRJNA690124	48157	249	0.886364	2.20704636	Nitrospira sp.	70125	Bacteria	Bacteria	66.6	1.58e-10	NR	MEO2054693.1	70125	g47791	i0	45	0.963855421686747	80	38	92.8	2	18	248	2891	2967	MEO2054693.1 LPD38 domain-containing protein [Nitrospira sp.]	diamond	240	66.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31947148	31947148	PRJNA690124_P_NODE_44897_length_252_cov_0.871508_g44531_i0	PRJNA690124	44897	252	0.871508	2.19620016	Nitrospira sp.	70125	Bacteria	Bacteria	133	4.84e-34	NR	HKC95882.1	70125	g44531	i0	85.5	0.988095238095238	83	12	98.8	0	251	3	378	460	HKC95882.1 acyl-[ACP]--phospholipid O-acyltransferase [Nitrospira sp.]	diamond	249	133	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);;