metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax_clade = "Nitrospinota/Tectimicrobiota group"

8 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax_clade = "Nitrospinota/Tectimicrobiota group"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
28838632	28838632	PRJNA1123436_P_NODE_123728_length_242_cov_0.911243_g122514_i0	PRJNA1123436	123728	242	0.911243	2.20520806	Nitrospinota bacterium	2026769	Bacteria	Bacteria	84.3	4.51e-19	NR	MBI5814349.1	2026769	g122514	i0	67.2	0.71900826446281	58	19	71.9	0	242	69	45	102	MBI5814349.1 nucleotidyltransferase domain-containing protein [Nitrospinota bacterium]	diamond	174	84.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota				Nitrospinota bacterium
29564868	29564868	PRJNA1123436_P_NODE_69310_length_299_cov_2.203540_g68096_i0	PRJNA1123436	69310	299	2.20354	6.5885846	Nitrospinota bacterium	2026769	Bacteria	Bacteria	98.2	1.28e-21	NR	HBK80997.1	2026769	g68096	i0	92	1.00334448160535	50	4	50.2	0	150	1	282	331	HBK80997.1 diaminopimelate decarboxylase [Nitrospinota bacterium]	diamond	300	98.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota				Nitrospinota bacterium
29743270	29743270	PRJNA1123436_P_NODE_107730_length_247_cov_0.885057_g106516_i0	PRJNA1123436	107730	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	126	6.4e-33	NR	MEE9149516.1	2528274	g106516	i0	74.4	2.98785425101215	82	20	99.6	1	2	247	229	309	MEE9149516.1 NF038122 family metalloprotease [Candidatus Tectimicrobiota bacterium]	diamond	738	126	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota				Candidatus Tectimicrobiota bacterium
30007203	30007203	PRJNA1123436_P_NODE_126591_length_241_cov_0.916667_g125377_i0	PRJNA1123436	126591	241	0.916667	2.20916747	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	48.9	2.18e-4	NR	MEE8301576.1	2528274	g125377	i0	61.1	1.04564315352697	36	14	44.8	0	133	240	69	104	MEE8301576.1 transposase [Candidatus Tectimicrobiota bacterium]	diamond	252	48.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota				Candidatus Tectimicrobiota bacterium
30912620	30912620	PRJNA1123436_P_NODE_115594_length_245_cov_0.895349_g114380_i0	PRJNA1123436	115594	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	113	4.6500000000000005e-27	NR	GJL77223.1	2358456	g114380	i0	62.5	1.9469387755102	80	30	98	0	241	2	895	974	GJL77223.1 MAG: adenine methyltransferase [Nitrospinaceae bacterium]	diamond	477	114	0.991228070175439	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospinaceae bacterium
31133375	31133375	PRJNA1123436_P_NODE_91935_length_256_cov_1.229508_g90721_i0	PRJNA1123436	91935	256	1.229508	3.14754048	Bacteria	2	Bacteria	Bacteria	70.5	1.18e-12	NR	MCH7645932.1	2026769	g90721	i0	46.5	5.02734375	86	42	96.1	2	248	3	81	166	MCH7645932.1 uracil-DNA glycosylase [Nitrospinota bacterium]	diamond	1287	71.2	0.990168539325843	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota				Nitrospinota bacterium
31555851	31555851	PRJNA1123436_P_NODE_119916_length_243_cov_0.905882_g118702_i0	PRJNA1123436	119916	243	0.905882	2.20129326	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	103	1.1399999999999999e-24	NR	MBI2877351.1	2528274	g118702	i0	66.2	0.876543209876543	71	24	87.7	0	215	3	37	107	MBI2877351.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	213	103	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota				Candidatus Tectimicrobiota bacterium
32315207	32315207	PRJNA1123436_P_NODE_120299_length_243_cov_0.905882_g119085_i0	PRJNA1123436	120299	243	0.905882	2.20129326	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	97.4	2.93e-23	NR	MDH3603386.1	2528274	g119085	i0	80.7	2.81481481481481	57	11	70.4	0	172	2	70	126	MDH3603386.1 recombinase family protein [Candidatus Tectimicrobiota bacterium]	diamond	684	97.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota				Candidatus Tectimicrobiota 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);;