metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Giovannoniibacteriota"

16 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Giovannoniibacteriota"

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
5403246	5403246	PRJNA1148190_P_NODE_7845_length_3974_cov_3.049987_g3866_i0	PRJNA1148190	7845	3974	3.049987	121.20648338	Bacteria	2	Bacteria	Bacteria	373	1.87e-114	NR	KKW34598.1	1618650	g3866	i0	61.1	1.84046300956215	306	119	23.1	0	2	919	55	360	KKW34598.1 MAG: Heavy metal transport/detoxification protein [Candidatus Giovannonibacteria bacterium GW2011_GWA2_53_7]	diamond	7314	373	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_53_7
27071165	27071165	PRJNA1148190_P_NODE_431222_length_280_cov_1.362319_g420049_i0	PRJNA1148190	431222	280	1.362319	3.8144932	Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_	2053557	Bacteria	Bacteria	74.3	3.34e-13	NR	OGF51519.1	1798322	g420049	i0	46.3	0.717857142857143	67	36	71.8	0	278	78	240	306	OGF51519.1 MAG: hypothetical protein A2739_02820 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_43_100]	diamond	201	74.3	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_43_100
27249131	27249131	PRJNA1148190_P_NODE_18623_length_1949_cov_4.612473_g10919_i0	PRJNA1148190	18623	1949	4.612473	89.89709877	root	1	Root_unresolved	Root_unresolved	558	1.07e-188	NR	KKT61755.1	1618648	g10919	i0	65.7	1.26988199076449	414	141	63.6	1	709	1947	17	430	KKT61755.1 MAG: hypothetical protein UW55_C0024G0007 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	2475	558	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
28196446	28196446	PRJNA1148190_P_NODE_40766_length_997_cov_2.591991_g30338_i0	PRJNA1148190	40766	997	2.591991	25.84215027	Bacteria	2	Bacteria	Bacteria	313	1.1099999999999998e-101	NR	MBI2023419.1	2053557	g30338	i0	76.3	4.08926780341023	194	46	58.4	0	996	415	155	348	MBI2023419.1 DNA cytosine methyltransferase [Candidatus Giovannonibacteria bacterium]	diamond	4077	313	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium
28291112	28291112	PRJNA1148190_P_NODE_197666_length_378_cov_1.750820_g186496_i0	PRJNA1148190	197666	378	1.75082	6.6180996	Bacillati	1783272	Bacteria	Bacteria	58.2	6.75e-7	NR	OGF63548.1	1798325	g186496	i0	44.3	6.12698412698413	79	41	62.7	1	134	370	658	733	OGF63548.1 MAG: hypothetical protein A2834_04515 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_23]	diamond	2316	58.2	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_23
28480781	28480781	PRJNA1148190_P_NODE_434146_length_279_cov_2.033981_g422973_i0	PRJNA1148190	434146	279	2.033981	5.67480699	Bacteria	2	Bacteria	Bacteria	114	3.6199999999999997e-28	NR	KKT61027.1	1618648	g422973	i0	70	1.93548387096774	90	26	96.8	1	278	9	229	317	KKT61027.1 MAG: Phenylalanyl-tRNA synthetase domain protein [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	540	115	0.991304347826087	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
28733466	28733466	PRJNA1148190_P_NODE_539087_length_259_cov_1.397849_g527914_i0	PRJNA1148190	539087	259	1.397849	3.6204289099999998	Bacteria	2	Bacteria	Bacteria	135	2.69e-38	NR	OGF95656.1	1798361	g527914	i0	88.9	4.16988416988417	72	8	83.4	0	218	3	77	148	OGF95656.1 MAG: hypothetical protein A2Y47_00105 [Candidatus Giovannonibacteria bacterium RIFCSPLOWO2_12_43_8]	diamond	1080	135	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium RIFCSPLOWO2_12_43_8
28807681	28807681	PRJNA1148190_P_NODE_361428_length_296_cov_1.766816_g350255_i0	PRJNA1148190	361428	296	1.766816	5.22977536	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	68.9	3.31e-12	NR	KKT61752.1	1618648	g350255	i0	53.4	0.739864864864865	73	34	74	0	25	243	63	135	KKT61752.1 MAG: hypothetical protein UW55_C0024G0004 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	219	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
29218420	29218420	PRJNA1148190_P_NODE_24049_length_1562_cov_3.654130_g15248_i0	PRJNA1148190	24049	1562	3.65413	57.0775106	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	700	1.9e-246	NR	KKT61755.1	1618648	g15248	i0	67.8	0.996798975672215	519	156	99.5	2	5	1558	55	563	KKT61755.1 MAG: hypothetical protein UW55_C0024G0007 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	1557	700	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
29238666	29238666	PRJNA1148190_P_NODE_56149_length_778_cov_2.387234_g45226_i0	PRJNA1148190	56149	778	2.387234	18.57268052	Bacteria	2	Bacteria	Bacteria	244	6.82e-75	NR	KKT61754.1	1618648	g45226	i0	66.1	1.30719794344473	171	57	65.6	1	27	536	254	424	KKT61754.1 MAG: Phage terminase, large subunit, PBSX family [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	1017	244	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
29975888	29975888	PRJNA1148190_P_NODE_141331_length_442_cov_1.913279_g130166_i0	PRJNA1148190	141331	442	1.913279	8.45669318	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	135	9.07e-35	NR	KKT61754.1	1618648	g130166	i0	56.6	0.766968325791855	113	47	75.3	1	337	5	2	114	KKT61754.1 MAG: Phage terminase, large subunit, PBSX family [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	339	135	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
30355580	30355580	PRJNA1148190_P_NODE_16572_length_2160_cov_3.829420_g9419_i0	PRJNA1148190	16572	2160	3.82942	82.715472	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	109	2.58e-24	NR	KKT61756.1	1618648	g9419	i0	56.7	0.288888888888889	104	45	14.4	0	1097	786	3	106	KKT61756.1 MAG: hypothetical protein UW55_C0024G0008 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	624	109	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
30419383	30419383	PRJNA1148190_P_NODE_611073_length_250_cov_0.870056_g599900_i0	PRJNA1148190	611073	250	0.870056	2.17514	Candidatus Giovannonibacteria bacterium RIFCSPLOWO2_	2053557	Bacteria	Bacteria	93.6	2.21e-22	NR	OGF82204.1	1798352	g599900	i0	66.7	1.656	69	23	82.8	0	2	208	58	126	OGF82204.1 MAG: hypothetical protein A3B18_04135 [Candidatus Giovannonibacteria bacterium RIFCSPLOWO2_01_FULL_46_13]	diamond	414	93.6	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium RIFCSPLOWO2_01_FULL_46_13
31524917	31524917	PRJNA1148190_P_NODE_360136_length_297_cov_1.075893_g348963_i0	PRJNA1148190	360136	297	1.075893	3.19540221	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	63.5	5.58e-10	NR	KKU04265.1	1618649	g348963	i0	44.3	0.707070707070707	70	38	69.7	1	90	296	55	124	KKU04265.1 MAG: hypothetical protein UX06_C0024G0004 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_45_21]	diamond	210	63.5	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_45_21
31809722	31809722	PRJNA1148190_P_NODE_50397_length_843_cov_2.455844_g39600_i0	PRJNA1148190	50397	843	2.455844	20.70276492	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	313	8.32e-102	NR	KKT61754.1	1618648	g39600	i0	58.9	0.935943060498221	263	101	92.9	4	784	2	2	259	KKT61754.1 MAG: Phage terminase, large subunit, PBSX family [Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26]	diamond	789	313	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWA2_44_26
32757663	32757663	PRJNA1148190_P_NODE_31900_length_1226_cov_2.795317_g22090_i0	PRJNA1148190	31900	1226	2.795317	34.27058642	Candidatus Giovannonibacteria bacterium GW2	2053557	Bacteria	Bacteria	284	1.59e-90	NR	KKS48485.1	1618659	g22090	i0	66	0.482055464926591	197	67	48.2	0	376	966	74	270	KKS48485.1 MAG: hypothetical protein UV11_C0008G0024 [Candidatus Giovannonibacteria bacterium GW2011_GWF2_42_19]	diamond	591	284	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium GW2011_GWF2_42_19

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