metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA312615" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA312615" and tax_superkingdom = "Viruses"

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
2929458	2929458	PRJNA312615_P_NODE_7583_length_446_cov_1.410579_g7433_i0	PRJNA312615	7583	446	1.410579	6.29118234	Campylobacter phage CJLB-4	2781358	Viruses	Viruses	56.2	1.31e-7	NR	QPB10331.1	2781358	g7433	i0	66.7	0.302690582959641	45	15	30.3	0	290	156	10	54	QPB10331.1 hypothetical protein [Campylobacter phage CJLB-4]	diamond	135	56.2	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Lambdavirus	Campylobacter phage CJLB-4
27737998	27737998	PRJNA312615_P_NODE_56904_length_163_cov_0.894737_g56753_i0	PRJNA312615	56904	163	0.894737	1.45842131	Klosneuvirus KNV1	1977640	Viruses	Viruses	55.1	5.41e-7	NR	ARF12097.1	1977640	g56753	i0	51.9	0.957055214723926	52	24	93.9	1	9	161	107	158	ARF12097.1 hypothetical protein Klosneuvirus_3_232 [Klosneuvirus KNV1]	diamond	156	55.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28779468	28779468	PRJNA312615_P_NODE_6387_length_482_cov_1.279446_g6239_i0	PRJNA312615	6387	482	1.279446	6.16692972	Enterobacteria phage IME1	1090133	Viruses	Viruses	117	4.56e-29	NR	YP_007004316.1	1090133	g6239	i0	46.5	0.79045643153527	127	68	79	0	480	100	27	153	YP_007004316.1 regulatory protein Q [Enterobacteria phage IME10]	diamond	381	117	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Lederbergvirus	Enterobacteria phage IME10
28937567	28937567	PRJNA312615_P_NODE_14148_length_327_cov_1.107914_g13997_i0	PRJNA312615	14148	327	1.107914	3.62287878	Escherichia phage Lambda	2681611	Viruses	Viruses	71.2	6.81e-14	NR	NP_040643.1	2681611	g13997	i0	46.9	0.587155963302752	64	34	58.7	0	120	311	1	64	NP_040643.1 hypothetical protein lambdap73 [Escherichia phage Lambda]	diamond	192	71.2	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Lambdavirus	Lambdavirus lambda
29442404	29442404	PRJNA312615_P_NODE_32490_length_215_cov_0.861446_g32339_i0	PRJNA312615	32490	215	0.861446	1.8521089	Multiple sclerosis associated retrovirus element	89382	Viruses	Viruses	41.6	0.00877	NR	AAD48373.1	89382	g32339	i0	55.9	0.474418604651163	34	15	47.4	0	102	1	14	47	AAD48373.1 unknown protein U5/2 [Multiple sclerosis associated retrovirus element]	diamond	102	41.6	1	Viruses	Human endogenous retroviruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Human endogenous retrovirus W
29537326	29537326	PRJNA312615_P_NODE_45190_length_181_cov_1.515152_g45039_i0	PRJNA312615	45190	181	1.515152	2.74242512	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	89.7	2.95e-19	NR	YP_010803269.1	3060017	g45039	i0	70.7	0.961325966850829	58	17	96.1	0	179	6	292	349	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	174	89.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29726543	29726543	PRJNA312615_P_NODE_17690_length_291_cov_1.140496_g17539_i0	PRJNA312615	17690	291	1.140496	3.31884336	Caudoviricetes sp.	2832643	Viruses	Viruses	91.7	1.48e-21	NR	DAH93386.1	2832643	g17539	i0	69.7	1.36082474226804	66	20	68	0	290	93	48	113	DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.]	diamond	396	91.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29916471	29916471	PRJNA312615_P_NODE_44071_length_184_cov_1.133333_g43920_i0	PRJNA312615	44071	184	1.133333	2.08533272	Adintovirus bos4377	3115894	Viruses	Viruses	57	4.79e-8	NR	DBA50495.1	3115894	g43920	i0	46.7	0.978260869565217	60	32	97.8	0	3	182	110	169	DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377]	diamond	180	57	1	Viruses		Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus bos4377
30168844	30168844	PRJNA312615_P_NODE_50092_length_169_cov_0.866667_g49941_i0	PRJNA312615	50092	169	0.866667	1.46466723	Adintovirus bos4377	3115894	Viruses	Viruses	47.4	2.79e-4	NR	DBA50496.1	3115894	g49941	i0	65.6	0.568047337278107	32	11	56.8	0	3	98	178	209	DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377]	diamond	96	47.4	1	Viruses		Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus bos4377
30737663	30737663	PRJNA312615_P_NODE_56954_length_163_cov_0.894737_g56803_i0	PRJNA312615	56954	163	0.894737	1.45842131	uncultured Caudovirales phage	2100421	Viruses	Viruses	94.7	3.78e-21	NR	CAB4147586.1	2100421	g56803	i0	81.1	3.92024539877301	53	10	97.5	0	5	163	269	321	CAB4147586.1 phage_term_2, phage terminase, large subunit, PBSX family [uncultured Caudovirales phage]	diamond	639	94.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30800843	30800843	PRJNA312615_P_NODE_24954_length_245_cov_0.872449_g24803_i0	PRJNA312615	24954	245	0.872449	2.13750005	Pimephales minnow adintovirus	2609864	Viruses	Viruses	68.6	2.59e-11	NR	DAC81401.1	2609864	g24803	i0	48.8	2.00816326530612	82	41	99.2	1	244	2	169	250	DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus]	diamond	492	68.6	1	Viruses		Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
31306537	31306537	PRJNA312615_P_NODE_415_length_1349_cov_1.535385_g360_i0	PRJNA312615	415	1349	1.535385	20.71234365	Escherichia phage Kati	3233700	Viruses	Viruses	190	7.04e-51	NR	XNS38751.1	3233700	g360	i0	54.6	1.22535211267606	185	84	41.1	0	5	559	314	498	XNS38751.1 hypothetical protein WLKYIJTT_CDS0034 [Escherichia phage Kati]	diamond	1653	190	1	Viruses								Escherichia phage Kati
32729466	32729466	PRJNA312615_P_NODE_19580_length_275_cov_2.030973_g19429_i0	PRJNA312615	19580	275	2.030973	5.58517575	Caudoviricetes sp.	2832643	Viruses	Viruses	64.3	2.52e-11	NR	DAI56203.1	2832643	g19429	i0	66.7	0.523636363636364	48	16	52.4	0	192	49	24	71	DAI56203.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	144	64.3	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;