metadata: contig_metadata: 14 rows where bioproject = "PRJNA340009" and tax_clade = "Nitrospinota/Tectimicrobiota group"

14 rows where bioproject = "PRJNA340009" 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_genus	tax_species
4219743	4219743	PRJNA340009_P_NODE_67504_length_165_cov_0.879310_g67197_i0	PRJNA340009	67504	165	0.87931	1.4508615	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	92.4	2.13e-22	NR	MBM3225275.1	2528274	g67197	i0	90.4	0.945454545454545	52	5	94.5	0	163	8	13	64	MBM3225275.1 flagellar protein FlaG [Candidatus Tectimicrobiota bacterium]	diamond	156	92.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
19518379	19518379	PRJNA340009_P_NODE_73836_length_162_cov_0.902655_g73529_i0	PRJNA340009	73836	162	0.902655	1.4623011	Nitrospinota bacterium	2026769	Bacteria	Bacteria	111	1.3600000000000002e-27	NR	MBI3329174.1	2026769	g73529	i0	90.7	1	54	5	100	0	1	162	82	135	MBI3329174.1 LLM class flavin-dependent oxidoreductase [Nitrospinota bacterium]	diamond	162	111	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26694781	26694781	PRJNA340009_P_NODE_64841_length_166_cov_0.871795_g64534_i0	PRJNA340009	64841	166	0.871795	1.4471797	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	41.2	0.042	NR	MDQ3830277.1	2528274	g64534	i0	90	0.72289156626506	20	2	36.1	0	1	60	194	213	MDQ3830277.1 DinB family protein [Candidatus Tectimicrobiota bacterium]	diamond	120	41.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
27074687	27074687	PRJNA340009_P_NODE_55522_length_175_cov_2.055556_g55215_i0	PRJNA340009	55522	175	2.055556	3.597223	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	105	8.799999999999999e-25	NR	HEY5869001.1	2528274	g55215	i0	84.5	0.994285714285714	58	9	99.4	0	1	174	339	396	HEY5869001.1 ATP-dependent helicase HrpB [Candidatus Tectimicrobiota bacterium]	diamond	174	105	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
27200973	27200973	PRJNA340009_P_NODE_76862_length_161_cov_0.910714_g76555_i0	PRJNA340009	76862	161	0.910714	1.46624954	Candidatus Nitromaritima sp. SCGC AAA799-A	3101100	Bacteria	Bacteria	89	2.68e-19	NR	KMP12721.1	1628278	g76555	i0	73.6	1.95652173913043	53	14	98.8	0	2	160	55	107	KMP12721.1 hypothetical protein UR09_00045 [Candidatus Nitromaritima sp. SCGC AAA799-A02]	diamond	315	89	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitromaritima	Candidatus Nitromaritima sp. SCGC AAA799-A02
27724122	27724122	PRJNA340009_P_NODE_76564_length_161_cov_0.910714_g76257_i0	PRJNA340009	76564	161	0.910714	1.46624954	Candidatus Entotheonella	93171	Bacteria	Bacteria	81.3	1.73e-16	NR	ETX09031.1	1429439	g76257	i0	66	2.96273291925466	53	18	98.8	0	1	159	223	275	ETX09031.1 MAG: hypothetical protein ETSY2_01865 [Candidatus Entotheonella gemina]	diamond	477	81.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella gemina
28527673	28527673	PRJNA340009_P_NODE_55607_length_175_cov_1.619048_g55300_i0	PRJNA340009	55607	175	1.619048	2.833334	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	93.2	7.360000000000001e-21	NR	MEE8291618.1	2528274	g55300	i0	80	1.93714285714286	55	11	94.3	0	10	174	14	68	MEE8291618.1 LLM class F420-dependent oxidoreductase [Candidatus Tectimicrobiota bacterium]	diamond	339	93.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
28938002	28938002	PRJNA340009_P_NODE_50348_length_183_cov_1.492537_g50041_i0	PRJNA340009	50348	183	1.492537	2.73134271	Nitrospinota bacterium	2026769	Bacteria	Bacteria	41.6	0.0425	NR	MEK6546535.1	2026769	g50041	i0	75	0.39344262295082	24	6	39.3	0	83	12	275	298	MEK6546535.1 right-handed parallel beta-helix repeat-containing protein [Nitrospinota bacterium]	diamond	72	41.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29222292	29222292	PRJNA340009_P_NODE_78089_length_159_cov_3.600000_g77782_i0	PRJNA340009	78089	159	3.6	5.724	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	70.1	2.1e-12	NR	HEX9868753.1	2528274	g77782	i0	68.6	0.962264150943396	51	16	96.2	0	3	155	137	187	HEX9868753.1 type IV secretion system DNA-binding domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	153	70.1	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30011701	30011701	PRJNA340009_P_NODE_8431_length_388_cov_2.864307_g8124_i0	PRJNA340009	8431	388	2.864307	11.11351116	Nitrospinota bacterium	2026769	Bacteria	Bacteria	89	1.31e-18	NR	MBI5750127.1	2026769	g8124	i0	45.1	2.70618556701031	82	44	62.6	1	146	388	21	102	MBI5750127.1 DUF2851 family protein [Nitrospinota bacterium]	diamond	1050	89	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30959436	30959436	PRJNA340009_P_NODE_32494_length_220_cov_1.040936_g32187_i0	PRJNA340009	32494	220	1.040936	2.2900592	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	84	6.33e-19	NR	HEY5864026.1	2528274	g32187	i0	84.3	1.41818181818182	51	8	69.5	0	220	68	61	111	HEY5864026.1 malate dehydrogenase [Candidatus Tectimicrobiota bacterium]	diamond	312	84	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31211694	31211694	PRJNA340009_P_NODE_36635_length_209_cov_0.956250_g36328_i0	PRJNA340009	36635	209	0.95625	1.9985625	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	62	7.6e-11	NR	HEX9871484.1	2528274	g36328	i0	78.4	0.5311004784689	37	8	53.1	0	61	171	1	37	HEX9871484.1 DUF4277 domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	111	62	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31306985	31306985	PRJNA340009_P_NODE_46115_length_189_cov_3.571429_g45808_i0	PRJNA340009	46115	189	3.571429	6.75000081	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	42.4	0.0246	NR	HEY5867831.1	2528274	g45808	i0	40.7	0.936507936507937	59	35	93.7	0	181	5	130	188	HEY5867831.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	177	42.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32305259	32305259	PRJNA340009_P_NODE_56859_length_173_cov_2.879032_g56552_i0	PRJNA340009	56859	173	2.879032	4.98072536	Bacteria	2	Bacteria	Bacteria	92.4	2.0600000000000001e-22	NR	MBM3224007.1	2528274	g56552	i0	86	1.73410404624277	50	7	86.7	0	171	22	75	124	MBM3224007.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	300	92.8	0.995689655172414	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);;