metadata: contig_metadata: 9 rows where bioproject = "PRJNA1196438" and tax

9 rows where bioproject = "PRJNA1196438" and tax_phylum = "Candidatus Dormiibacterota"

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_species
323164	323164	PRJNA1196438_P_NODE_45241_length_280_cov_3.768116_g44814_i0	PRJNA1196438	45241	280	3.768116	10.5507248	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	180	1.7199999999999997e-55	NR	HLQ98173.1	2052315	g44814	i0	95.7	0.996428571428571	93	4	99.6	0	279	1	21	113	HLQ98173.1 transcriptional repressor LexA [Candidatus Dormiibacterota bacterium]	diamond	279	180	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
2318740	2318740	PRJNA1196438_P_NODE_52522_length_269_cov_2.617347_g52095_i0	PRJNA1196438	52522	269	2.617347	7.04066343	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	110	9.73e-28	NR	HLQ97266.1	2052315	g52095	i0	84.1	0.702602230483271	63	10	70.3	0	190	2	1	63	HLQ97266.1 endonuclease III [Candidatus Dormiibacterota bacterium]	diamond	189	110	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
18894712	18894712	PRJNA1196438_P_NODE_22015_length_312_cov_2.761506_g21589_i0	PRJNA1196438	22015	312	2.761506	8.61589872	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	171	2.29e-48	NR	HLQ97823.1	2052315	g21589	i0	79	1.14423076923077	119	9	99	1	3	311	135	253	HLQ97823.1 cytochrome c biogenesis protein ResB [Candidatus Dormiibacterota bacterium]	diamond	357	171	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
27262254	27262254	PRJNA1196438_P_NODE_73543_length_244_cov_1.818713_g73116_i0	PRJNA1196438	73543	244	1.818713	4.43765972	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	108	3.6300000000000006e-27	NR	HLQ97637.1	2052315	g73116	i0	67.5	0.94672131147541	77	25	94.7	0	1	231	165	241	HLQ97637.1 glycerophosphodiester phosphodiesterase [Candidatus Dormiibacterota bacterium]	diamond	231	108	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
27925348	27925348	PRJNA1196438_P_NODE_60885_length_257_cov_1.614130_g60458_i0	PRJNA1196438	60885	257	1.61413	4.1483141	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	132	9.87e-37	NR	HLQ97735.1	2052315	g60458	i0	72.3	0.968871595330739	83	23	96.9	0	255	7	22	104	HLQ97735.1 protein phosphatase 2C domain-containing protein [Candidatus Dormiibacterota bacterium]	diamond	249	132	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
28240834	28240834	PRJNA1196438_P_NODE_20806_length_312_cov_2.920502_g20380_i0	PRJNA1196438	20806	312	2.920502	9.11196624	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	84	1.23e-16	NR	HLQ97226.1	2052315	g20380	i0	67.2	0.557692307692308	58	16	55.8	1	3	176	63	117	HLQ97226.1 pilus assembly protein PilM [Candidatus Dormiibacterota bacterium]	diamond	174	84	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
28872448	28872448	PRJNA1196438_P_NODE_38328_length_291_cov_2.775229_g37901_i0	PRJNA1196438	38328	291	2.775229	8.07591639	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	178	1.3e-53	NR	HLQ97697.1	2052315	g37901	i0	91.7	0.989690721649485	96	8	99	0	289	2	20	115	HLQ97697.1 pectate lyase [Candidatus Dormiibacterota bacterium]	diamond	288	178	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
28999223	28999223	PRJNA1196438_P_NODE_80848_length_232_cov_2.628931_g80421_i0	PRJNA1196438	80848	232	2.628931	6.09911992	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	117	1.8799999999999999e-31	NR	HLQ97776.1	2052315	g80421	i0	76.3	0.982758620689655	76	18	98.3	0	228	1	66	141	HLQ97776.1 type III toxin-antitoxin system ToxN/AbiQ family toxin [Candidatus Dormiibacterota bacterium]	diamond	228	117	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota bacterium
29724761	29724761	PRJNA1196438_P_NODE_62650_length_254_cov_2.436464_g62223_i0	PRJNA1196438	62650	254	2.436464	6.18861856	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	156	7.429999999999999e-43	NR	HLQ97210.1	2052315	g62223	i0	92.9	0.992125984251969	84	6	99.2	0	254	3	121	204	HLQ97210.1 pyruvate kinase [Candidatus Dormiibacterota bacterium]	diamond	252	156	1	Bacteria	Bacillati	Candidatus Dormiibacterota	Candidatus Dormiibacterota 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);;