metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax_kingdom = "Bamfordvirae"

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_class	tax_order	tax_family	tax_genus	tax_species
26699459	26699459	PRJNA565778_S_NODE_8821_length_363_cov_36.346626_g8525_i0	PRJNA565778	8821	363	36.346626	131.93825238	Hyperionvirus sp.	2487770	Viruses	Viruses	70.5	2.58e-11	NR	AYV84018.1	2487770	g8525	i0	40.8	0.809917355371901	98	47	81	1	33	326	14	100	AYV84018.1 MAG: seryl-tRNA synthetase [Hyperionvirus sp.]	diamond	294	70.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
27364284	27364284	PRJNA565778_S_NODE_27983_length_208_cov_127.105263_g27687_i0	PRJNA565778	27983	208	127.105263	264.37894704	Hyperionvirus sp.	2487770	Viruses	Viruses	42.4	0.0332	NR	AYV84452.1	2487770	g27687	i0	52.8	0.519230769230769	36	17	51.9	0	169	62	789	824	AYV84452.1 MAG: poly(beta-D-mannuronate) C5 epimerase 7 [Hyperionvirus sp.]	diamond	108	42.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
27458882	27458882	PRJNA565778_S_NODE_7283_length_396_cov_2.994429_g6999_i0	PRJNA565778	7283	396	2.994429	11.85793884	Hyperionvirus sp.	2487770	Viruses	Viruses	46.6	0.00902	NR	AYV84565.1	2487770	g6999	i0	60	0.265151515151515	35	14	26.5	0	107	3	67	101	AYV84565.1 MAG: DNA repair exonuclease [Hyperionvirus sp.]	diamond	105	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
28121773	28121773	PRJNA565778_S_NODE_17605_length_263_cov_117.075221_g17309_i0	PRJNA565778	17605	263	117.075221	307.90783123	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	127	8.709999999999998e-32	NR	YP_010804160.1	3060017	g17309	i0	80.3	0.866920152091255	76	15	86.7	0	232	5	475	550	YP_010804160.1 long-chain fatty acid CoA synthetase [Fadolivirus algeromassiliense]	diamond	228	127	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29556042	29556042	PRJNA565778_S_NODE_3270_length_551_cov_3.521401_g3083_i0	PRJNA565778	3270	551	3.521401	19.40291951	Viruses	10239	Viruses	Viruses	243	1.08e-76	NR	AYV80951.1	2487768	g3083	i0	80.1	1.60072595281307	146	29	79.5	0	1	438	193	338	AYV80951.1 MAG: DNA directed RNA polymerase subunit L [Harvfovirus sp.]	diamond	882	243	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
30427475	30427475	PRJNA565778_S_NODE_1273_length_779_cov_4.563342_g1184_i0	PRJNA565778	1273	779	4.563342	35.54843418	Harvfovirus sp.	2487768	Viruses	Viruses	333	1.2099999999999998e-101	NR	AYV81576.1	2487768	g1184	i0	60.6	0.997432605905006	259	101	99.7	1	777	1	68	325	AYV81576.1 MAG: DNA repair exonuclease [Harvfovirus sp.]	diamond	777	333	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
30647945	30647945	PRJNA565778_S_NODE_4273_length_494_cov_5.120350_g4054_i0	PRJNA565778	4273	494	5.12035	25.294529	Harvfovirus sp.	2487768	Viruses	Viruses	292	3.049999999999999e-96	NR	AYV80951.1	2487768	g4054	i0	86.5	1.88866396761134	155	21	94.1	0	25	489	45	199	AYV80951.1 MAG: DNA directed RNA polymerase subunit L [Harvfovirus sp.]	diamond	933	292	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
31470139	31470139	PRJNA565778_S_NODE_37756_length_175_cov_517.101449_g37460_i0	PRJNA565778	37756	175	517.101449	904.92753575	Harvfovirus sp.	2487768	Viruses	Viruses	52	8.23e-6	NR	AYV80943.1	2487768	g37460	i0	79.3	0.497142857142857	29	6	49.7	0	89	175	343	371	AYV80943.1 MAG: metallophosphoesterase [Harvfovirus sp.]	diamond	87	52	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
31628068	31628068	PRJNA565778_S_NODE_26796_length_213_cov_23.511364_g26500_i0	PRJNA565778	26796	213	23.511364	50.07920532	Catovirus CTV1	1977631	Viruses	Viruses	88.6	1.8e-18	NR	ARF08649.1	1977631	g26500	i0	67.8	1.66197183098592	59	19	83.1	0	178	2	216	274	ARF08649.1 UvrD/REP helicase family protein [Catovirus CTV1]	diamond	354	88.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
31754578	31754578	PRJNA565778_S_NODE_10037_length_343_cov_2.862745_g9741_i0	PRJNA565778	10037	343	2.862745	9.81921535	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	134	6.18e-34	NR	YP_010803545.1	3060017	g9741	i0	62.3	0.927113702623907	106	38	92.7	1	323	6	1	104	YP_010803545.1 NAD-dependent DNA ligase [Fadolivirus algeromassiliense]	diamond	318	134	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31881010	31881010	PRJNA565778_S_NODE_4337_length_491_cov_16.559471_g4116_i0	PRJNA565778	4337	491	16.559471	81.30700261	Hyperionvirus sp.	2487770	Viruses	Viruses	195	3.3499999999999997e-57	NR	AYV84092.1	2487770	g4116	i0	62.9	0.855397148676171	140	52	85.5	0	454	35	319	458	AYV84092.1 MAG: hypothetical protein Hyperionvirus17_12 [Hyperionvirus sp.]	diamond	420	195	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.

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