metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Nucleocytoviricota"

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
26656386	26656386	PRJNA1120060_P_NODE_1093221_length_311_cov_3.168067_g1075286_i0	PRJNA1120060	1093221	311	3.168067	9.85268837	Micromonas commoda virus	3057169	Viruses	Viruses	49.7	6.57e-5	NR	XHR79460.1	3057169	g1075286	i0	39.5	0.829581993569132	86	50	83	1	1	258	27	110	XHR79460.1 hypothetical protein [Micromonas commoda virus]	diamond	258	49.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Micromonas commoda virus
27890930	27890930	PRJNA1120060_P_NODE_468685_length_373_cov_2.200000_g451121_i0	PRJNA1120060	468685	373	2.2	8.206	Ostreococcus tauri virus OtV5	1785753	Viruses	Viruses	45.4	0.0171	NR	YP_001648087.2	1785753	g451121	i0	41.1	0.587131367292225	73	41	57.9	2	42	257	255	326	YP_001648087.2 hypothetical protein OtV5_010c [Ostreococcus tauri virus OtV5]	diamond	219	45.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Prasinovirus ostreotauri
29027110	29027110	PRJNA1120060_P_NODE_2275708_length_262_cov_1.761905_g2257653_i0	PRJNA1120060	2275708	262	1.761905	4.6161911	Rhinella marina erythrocytic-like virus	2859906	Viruses	Viruses	45.1	0.0074	NR	QXT57828.1	2859906	g2257653	i0	43.8	0.549618320610687	48	26	55	1	232	89	110	156	QXT57828.1 putative tyrosine kinase/LPS-modifying enzyme, partial [Rhinella marina erythrocytic-like virus]	diamond	144	45.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Rhinella marina erythrocytic-like virus
29364568	29364568	PRJNA1120060_P_NODE_2243349_length_263_cov_2.473684_g2225295_i0	PRJNA1120060	2243349	263	2.473684	6.50578892	Mimivirus	315393	Viruses	Viruses	43.9	0.0181	NR	YP_003987095.1	212035	g2225295	i0	32.3	2.82889733840304	62	42	70.7	0	63	248	305	366	YP_003987095.1 putative ankyrin repeat protein [Acanthamoeba polyphaga mimivirus]	diamond	744	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
29752125	29752125	PRJNA1120060_P_NODE_1275491_length_308_cov_3.068085_g1257546_i0	PRJNA1120060	1275491	308	3.068085	9.4497018	Organic Lake phycodnavirus 1	938081	Viruses	Viruses	46.2	6.42e-4	NR	ADX06161.1	938081	g1257546	i0	45	0.38961038961039	40	22	39	0	139	20	7	46	ADX06161.1 putative zinc knuckle domain-containing protein [Organic Lake phycodnavirus 1]	diamond	120	46.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Organic Lake phycodnavirus 1
29973782	29973782	PRJNA1120060_P_NODE_1758751_length_282_cov_3.846890_g1740740_i0	PRJNA1120060	1758751	282	3.84689	10.8482298	Iridovirus macaca37137	3116699	Viruses	Viruses	73.6	7.59e-15	NR	DBA45586.1	3116699	g1740740	i0	48.7	2.42553191489362	78	40	83	0	3	236	4	81	DBA45586.1 MAG TPA_asm: Ubiquit [Iridovirus macaca37137]	diamond	684	73.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Iridovirus macaca37137
31016569	31016569	PRJNA1120060_P_NODE_1948115_length_275_cov_1.202970_g1930091_i0	PRJNA1120060	1948115	275	1.20297	3.3081675	Hokovirus HKV1	1977638	Viruses	Viruses	43.5	0.029	NR	ARF10155.1	1977638	g1930091	i0	32.4	0.807272727272727	74	42	75.3	2	3	209	236	306	ARF10155.1 hypothetical protein Hokovirus_1_34 [Hokovirus HKV1]	diamond	222	43.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
31618285	31618285	PRJNA1120060_P_NODE_3559316_length_202_cov_4.465116_g3541189_i0	PRJNA1120060	3559316	202	4.465116	9.01953432	Harvfovirus sp.	2487768	Viruses	Viruses	48.5	1.62e-4	NR	AYV81818.1	2487768	g3541189	i0	51	0.727722772277228	49	24	72.8	0	24	170	157	205	AYV81818.1 MAG: hypothetical protein Harvfovirus65_5 [Harvfovirus sp.]	diamond	147	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
31734170	31734170	PRJNA1120060_P_NODE_2508617_length_253_cov_3.844444_g2490545_i0	PRJNA1120060	2508617	253	3.844444	9.72644332	Decapodiridovirus	2560120	Viruses	Viruses	52.8	7.35e-7	NR	YP_009552359.1	2035708	g2490545	i0	46.7	19.0197628458498	60	32	71.1	0	251	72	17	76	YP_009552359.1 078R [Cherax quadricarinatus iridovirus]	diamond	4812	53.1	0.994350282485876	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae	Decapodiridovirus	Decapodiridovirus litopenaeus1
32061225	32061225	PRJNA1120060_P_NODE_417258_length_384_cov_4.758842_g399793_i0	PRJNA1120060	417258	384	4.758842	18.27395328	Nucleocytoviricota sp.	2809609	Viruses	Viruses	46.2	0.00358	NR	UZT29167.1	2809609	g399793	i0	31.5	0.421875	54	37	42.2	0	171	10	61	114	UZT29167.1 ribonuclease HI family protein [Nucleocytoviricota sp.]	diamond	162	46.2	1	Viruses	Bamfordvirae	Nucleocytoviricota					Nucleocytoviricota 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);;