metadata: contig_metadata: 8 rows where bioproject = "PRJNA1148190" and tax

8 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Liptoniibacteriota"

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_phylum	tax_species
2847527	2847527	PRJNA1148190_P_NODE_503_length_22144_cov_9.215350_g5_i7	PRJNA1148190	503	22144	9.21535	2040.647104	Bacteria	2	Bacteria	Bacteria	2466	0	NR	OGZ00444.1	1798650	g5	i7	56.4	6.31403540462428	2317	895	31.3	19	6138	13064	10	2219	OGZ00444.1 MAG: hypothetical protein A2945_03830 [Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25]	diamond	139818	2488	0.991157556270096	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25
9224703	9224703	PRJNA1148190_P_NODE_508_length_22087_cov_9.206823_g5_i8	PRJNA1148190	508	22087	9.206823	2033.51099601	Bacteria	2	Bacteria	Bacteria	2466	0	NR	OGZ00444.1	1798650	g5	i8	56.4	6.3303300584054	2317	895	31.4	19	15950	9024	10	2219	OGZ00444.1 MAG: hypothetical protein A2945_03830 [Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25]	diamond	139818	2488	0.991157556270096	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25
28302630	28302630	PRJNA1148190_P_NODE_269086_length_334_cov_0.992337_g257915_i0	PRJNA1148190	269086	334	0.992337	3.31440558	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	129	1.95e-33	NR	MBI3589119.1	2528273	g257915	i0	58.6	1.9940119760479	111	46	99.7	0	2	334	161	271	MBI3589119.1 hypothetical protein [Candidatus Liptonbacteria bacterium]	diamond	666	129	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
29396377	29396377	PRJNA1148190_P_NODE_29009_length_1327_cov_1.513557_g19508_i0	PRJNA1148190	29009	1327	1.513557	20.08490139	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	1.94e-4	NR	MBM3256873.1	2528273	g19508	i0	38.7	0.813865862848531	75	44	16.5	1	895	1113	364	438	MBM3256873.1 chromosomal replication initiator protein DnaA [Candidatus Liptonbacteria bacterium]	diamond	1080	56.2	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
30197227	30197227	PRJNA1148190_P_NODE_32612_length_1204_cov_2.419982_g22730_i0	PRJNA1148190	32612	1204	2.419982	29.13658328	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	325	5.509999999999998e-103	NR	MBI3589735.1	2528273	g22730	i0	57.2	1.35049833887043	271	116	67.5	0	392	1204	1	271	MBI3589735.1 Flp pilus assembly complex ATPase component TadA [Candidatus Liptonbacteria bacterium]	diamond	1626	325	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
30956715	30956715	PRJNA1148190_P_NODE_9294_length_3479_cov_3.494715_g4685_i0	PRJNA1148190	9294	3479	3.494715	121.58113485	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	355	3.48e-109	NR	MBI4095000.1	2528273	g4685	i0	53	0.58120149468238	338	155	28.9	3	2222	3226	3	339	MBI4095000.1 di-trans,poly-cis-decaprenylcistransferase [Candidatus Liptonbacteria bacterium]	diamond	2022	355	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
32082663	32082663	PRJNA1148190_P_NODE_587978_length_251_cov_0.865169_g576805_i0	PRJNA1148190	587978	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	102	1.76e-25	NR	OGZ01871.1	1798651	g576805	i0	60.2	8.83266932270916	83	33	99.2	0	249	1	4	86	OGZ01871.1 MAG: hypothetical protein A2946_02975 [Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_53_13]	diamond	2217	102	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_53_13
32726722	32726722	PRJNA1148190_P_NODE_603400_length_250_cov_0.870056_g592227_i0	PRJNA1148190	603400	250	0.870056	2.17514	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_	2528273	Bacteria	Bacteria	74.3	7.65e-14	NR	OGY99636.1	1798650	g592227	i0	84.2	2.328	38	6	45.6	0	247	134	199	236	OGY99636.1 MAG: hypothetical protein A2945_03250 [Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25]	diamond	582	74.3	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25

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);;