metadata: contig_metadata: 16 rows where bioproject = "PRJNA1087264" and tax

16 rows where bioproject = "PRJNA1087264" 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
1468678	1468678	PRJNA1087264_P_NODE_2_length_7143_cov_12.054412_g1_i0	PRJNA1087264	2	7143	12.054412	861.04664916	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2474	0	NR	WKU61618.1	3063761	g1	i0	63.4	0.933221335573289	2222	787	92.3	4	6629	36	1	2220	WKU61618.1 polyprotein [Zebrafish picornavirus 2]	diamond	6666	2474	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
24419877	24419877	PRJNA1087264_P_NODE_20880_length_162_cov_0.902655_g20798_i0	PRJNA1087264	20880	162	0.902655	1.4623011	Herelleviridae sp.	2831613	Viruses	Viruses	243	7.45e-60	NTclustered	gi\|2053226277\|tpg\|BK035376.1\|	2831613	g20798	i0	94.304	0.975308641975309	158	9	98	0	3	160	85187	85344	MAG TPA_asm: Herelleviridae sp. isolate ctdGG3, partial genome	blastn	158	243	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes		Herelleviridae		Herelleviridae sp.
26972530	26972530	PRJNA1087264_P_NODE_3342_length_359_cov_1.867742_g3261_i0	PRJNA1087264	3342	359	1.867742	6.70519378	Bodo saltans virus	2024608	Viruses	Viruses	125	9.75e-34	NR	YP_010778932.1	2024608	g3261	i0	71.3	0.668523676880223	80	23	66.9	0	2	241	108	187	YP_010778932.1 N6-adenine methyltransferase [Bodo saltans virus]	diamond	240	125	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
27627796	27627796	PRJNA1087264_P_NODE_4344_length_312_cov_1.114068_g4262_i0	PRJNA1087264	4344	312	1.114068	3.47589216	root	1	Root_unresolved	Root_unresolved	97.1	8.159999999999999e-23	NR	CAA10165.1	1891767	g4262	i0	92.2	2.44230769230769	51	4	49	0	154	2	83	133	CAA10165.1 large tumor antigen [Betapolyomavirus macacae]	diamond	762	97.1	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
27983467	27983467	PRJNA1087264_P_NODE_15745_length_166_cov_0.871795_g15663_i0	PRJNA1087264	15745	166	0.871795	1.4471797	Acanthamoeba polyphaga mimivirus	212035	Viruses	Viruses	48.1	1.92e-5	NR	AKI80780.1	212035	g15663	i0	54.8	1.71686746987952	31	14	56	0	103	11	5	35	AKI80780.1 hypothetical protein [Acanthamoeba polyphaga mimivirus]	diamond	285	48.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
28385359	28385359	PRJNA1087264_P_NODE_13066_length_174_cov_1.640000_g12984_i0	PRJNA1087264	13066	174	1.64	2.8536	root	1	Root_unresolved	Root_unresolved	80.5	3.94e-17	NR	CAA10165.1	1891767	g12984	i0	81.1	3.6551724137931	53	10	91.4	0	16	174	83	135	CAA10165.1 large tumor antigen [Betapolyomavirus macacae]	diamond	636	80.5	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
28393890	28393890	PRJNA1087264_P_NODE_2626_length_411_cov_1.265193_g2545_i0	PRJNA1087264	2626	411	1.265193	5.19994323	Solivirus sp.	2487772	Viruses	Viruses	52.4	8.83e-5	NR	AYV86093.1	2487772	g2545	i0	35.2	0.788321167883212	108	61	72.3	3	298	2	32	139	AYV86093.1 MAG: hypothetical protein Solivirus6_2 [Solivirus sp.]	diamond	324	52.4	1	Viruses	Pithoviruses							Solivirus sp.
28520363	28520363	PRJNA1087264_P_NODE_12067_length_182_cov_1.000000_g11985_i0	PRJNA1087264	12067	182	1	1.82	Escherichia phage Copypasta	3096133	Viruses	Viruses	40.4	0.0141	NR	WPH57058.1	3096133	g11985	i0	54.2	0.791208791208791	48	22	79.1	0	3	146	9	56	WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta]	diamond	144	40.4	1	Viruses		Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Escherichia phage Copypasta
28962533	28962533	PRJNA1087264_P_NODE_3508_length_350_cov_1.900332_g3426_i0	PRJNA1087264	3508	350	1.900332	6.651162	Solivirus sp.	2487772	Viruses	Viruses	45.4	0.0131	NR	AYV86093.1	2487772	g3426	i0	37	0.857142857142857	100	55	79.7	3	281	3	200	298	AYV86093.1 MAG: hypothetical protein Solivirus6_2 [Solivirus sp.]	diamond	300	45.4	1	Viruses	Pithoviruses							Solivirus sp.
29120410	29120410	PRJNA1087264_P_NODE_749_length_772_cov_2.621024_g680_i0	PRJNA1087264	749	772	2.621024	20.23430528	Tupanvirus soda lake	2126985	Viruses	Viruses	161	4.6499999999999995e-45	NR	YP_010782214.1	2126985	g680	i0	44.5	0.819948186528497	211	89	80.8	8	770	147	11	196	YP_010782214.1 exonuclease [Tupanvirus soda lake]	diamond	633	161	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
29404384	29404384	PRJNA1087264_P_NODE_29_length_2505_cov_2.491857_g22_i0	PRJNA1087264	29	2505	2.491857	62.42101785	Terrestrivirus sp.	2487775	Viruses	Viruses	216	3.0699999999999988e-55	NR	AYV76628.1	2487775	g22	i0	28.7	2.29580838323353	641	354	73.4	19	2358	520	11	576	AYV76628.1 MAG: hypothetical protein Terrestrivirus10_12 [Terrestrivirus sp.]	diamond	5751	216	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
29530693	29530693	PRJNA1087264_P_NODE_3710_length_339_cov_2.317241_g3628_i0	PRJNA1087264	3710	339	2.317241	7.85544699	Bodo saltans virus	2024608	Viruses	Viruses	147	3.5e-42	NR	YP_010778932.1	2024608	g3628	i0	65.7	0.955752212389381	108	35	95.6	1	325	2	1	106	YP_010778932.1 N6-adenine methyltransferase [Bodo saltans virus]	diamond	324	147	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
29909717	29909717	PRJNA1087264_P_NODE_10471_length_195_cov_1.047945_g10389_i0	PRJNA1087264	10471	195	1.047945	2.04349275	Terrestrivirus sp.	2487775	Viruses	Viruses	54.7	1.04e-6	NR	AYV75674.1	2487775	g10389	i0	40.7	0.830769230769231	54	31	81.5	1	192	34	43	96	AYV75674.1 MAG: hypothetical protein Terrestrivirus2_182 [Terrestrivirus sp.]	diamond	162	54.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
30722323	30722323	PRJNA1087264_P_NODE_12554_length_178_cov_1.364341_g12472_i0	PRJNA1087264	12554	178	1.364341	2.42852698	root	1	Root_unresolved	Root_unresolved	77.4	6.48e-16	NR	CAA10165.1	1891767	g12472	i0	66	3.57303370786517	53	18	89.3	0	163	5	83	135	CAA10165.1 large tumor antigen [Betapolyomavirus macacae]	diamond	636	77.4	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
32217308	32217308	PRJNA1087264_P_NODE_38_length_2217_cov_2.104244_g30_i0	PRJNA1087264	38	2217	2.104244	46.65108948	Hyperionvirus sp.	2487770	Viruses	Viruses	221	2.85e-57	NR	AYV84279.1	2487770	g30	i0	27.6	1.00676589986468	744	423	98.6	23	2215	29	18	660	AYV84279.1 MAG: endonuclease/exonuclease/phosphatase family [Hyperionvirus sp.]	diamond	2232	221	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
32880111	32880111	PRJNA1087264_P_NODE_13760_length_169_cov_1.700000_g13678_i0	PRJNA1087264	13760	169	1.7	2.873	Hyperionvirus sp.	2487770	Viruses	Viruses	72.4	4.53e-14	NR	AYV84438.1	2487770	g13678	i0	58.8	1.79289940828402	51	21	90.5	0	153	1	4	54	AYV84438.1 MAG: hypothetical protein Hyperionvirus25_24 [Hyperionvirus sp.]	diamond	303	72.4	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);;