metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA934332" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA934332" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6013860	6013860	PRJNA934332_P_NODE_545_length_800_cov_2.371389_g473_i0	PRJNA934332	545	800	2.371389	18.971112	Edafosvirus sp.	2487765	Viruses	Viruses	338	7.55e-111	NR	AYV78014.1	2487765	g473	i0	61	3.01125	267	100	99.4	2	3	797	140	404	AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.]	diamond	2409	338	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
17488945	17488945	PRJNA934332_P_NODE_9494_length_246_cov_0.890173_g9407_i0	PRJNA934332	9494	246	0.890173	2.18982558	Florenciella sp. virus SA2	3240092	Viruses	Viruses	102	5.04e-24	NR	XDO01906.1	3240092	g9407	i0	58	2.96341463414634	81	30	98.8	2	3	245	215	291	XDO01906.1 hypothetical protein FloV-SA2_00084 [Florenciella sp. virus SA2]	diamond	729	102	1	Viruses							Florenciella sp. virus SA2
26898507	26898507	PRJNA934332_P_NODE_8041_length_250_cov_0.870056_g7954_i0	PRJNA934332	8041	250	0.870056	2.17514	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	157	2.76e-42	NR	WKU61618.1	3063761	g7954	i0	98.7	0.912	76	1	91.2	0	248	21	171	246	WKU61618.1 polyprotein [Zebrafish picornavirus 2]	diamond	228	157	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
27309645	27309645	PRJNA934332_P_NODE_7443_length_251_cov_1.730337_g7356_i0	PRJNA934332	7443	251	1.730337	4.34314587	Caudoviricetes sp.	2832643	Viruses	Viruses	95.1	1.46e-20	NR	XOR38078.1	2832643	g7356	i0	94.1	0.609561752988048	51	3	61	0	251	99	521	571	XOR38078.1 MAG: putative tail protein [Caudoviricetes sp.]	diamond	153	95.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28383000	28383000	PRJNA934332_P_NODE_9926_length_245_cov_0.895349_g9839_i0	PRJNA934332	9926	245	0.895349	2.19360505	Adintovirus bos4377	3115894	Viruses	Viruses	62.8	6.64e-10	NR	DBA50495.1	3115894	g9839	i0	47.3	1.8	74	39	90.6	0	222	1	2	75	DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377]	diamond	441	62.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus bos4377
30025154	30025154	PRJNA934332_P_NODE_8911_length_247_cov_1.327586_g8824_i0	PRJNA934332	8911	247	1.327586	3.27913742	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	87	7.22e-18	NR	YP_010803269.1	3060017	g8824	i0	46.9	0.983805668016194	81	43	98.4	0	1	243	288	368	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	243	87	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
30506019	30506019	PRJNA934332_P_NODE_10913_length_242_cov_0.911243_g10826_i0	PRJNA934332	10913	242	0.911243	2.20520806	Viruses	10239	Viruses	Viruses	121	6.54e-30	NR	DAD80240.1	2826775	g10826	i0	71.8	2.91322314049587	78	22	96.7	0	1	234	991	1068	DAD80240.1 MAG TPA: putative internal virion protein [Caudovirales sp. ctTqA28]	diamond	705	121	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudovirales sp. ctTqA28
31288773	31288773	PRJNA934332_P_NODE_5535_length_285_cov_1.452830_g5448_i0	PRJNA934332	5535	285	1.45283	4.1405655	Erwinia phage Hena1	2678601	Viruses	Viruses	120	1.48e-33	NR	YP_009854391.1	2678601	g5448	i0	85.3	0.715789473684211	68	9	70.5	1	281	81	1	68	YP_009854391.1 hypothetical protein HWC84_gp184 [Erwinia phage Hena1]	diamond	204	120	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Henunavirus	Henunavirus hena1

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