metadata: contig_metadata: 26 rows where bioproject = "PRJNA577580" and tax

26 rows where bioproject = "PRJNA577580" 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
1839450	1839450	PRJNA577580_P_NODE_10082_length_288_cov_3.153488_g10004_i0	PRJNA577580	10082	288	3.153488	9.08204544	Caudoviricetes sp. vir323	3068356	Viruses	Viruses	102	2.61e-17	NTclustered	gi\|2587525388\|tpg\|BK063679.1\|	3068356	g10004	i0	87.5	3.68402777777778	88	11	90	0	10	97	8906	8819	TPA_asm: Caudoviricetes sp. vir323 genomic sequence	blastn	1061	102	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp. vir323
4391537	4391537	PRJNA577580_P_NODE_6324_length_357_cov_2.003521_g6246_i0	PRJNA577580	6324	357	2.003521	7.15256997	Cotonvirus japonicum	3059904	Viruses	Viruses	67.6	1.21e-6	NTclustered	gi\|2500766720\|ref\|NC_079139.1\|	2811091	g6246	i0	81.395	0.57703081232493	86	12	24	4	3	86	533397	533314	Cotonvirus japonicus DNA, complete genome	blastn	206	67.6	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
6241738	6241738	PRJNA577580_P_NODE_7845_length_322_cov_1.831325_g7767_i0	PRJNA577580	7845	322	1.831325	5.8968665	Megavirus	3044761	Viruses	Viruses	78.7	4.99e-10	NTclustered	gi\|363539767\|ref\|NC_016072.1\|	1094892	g7767	i0	84.146	1.7360248447205	82	11	25	2	58	138	1129728	1129808	Megavirus chiliensis, complete genome	blastn	559	78.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
6942191	6942191	PRJNA577580_P_NODE_15226_length_246_cov_1.491329_g15148_i0	PRJNA577580	15226	246	1.491329	3.66866934	Zebrafish picornavirus 1	2304617	Viruses	Viruses	390	4.15e-104	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g15148	i0	95.492	2.97560975609756	244	11	99	0	1	244	2137	2380	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	732	390	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9492472	9492472	PRJNA577580_P_NODE_5308_length_388_cov_1.457143_g5230_i0	PRJNA577580	5308	388	1.457143	5.65371484	Zebrafish picornavirus 1	2304617	Viruses	Viruses	695	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g5230	i0	98.969	3	388	4	100	0	1	388	7551	7938	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1164	695	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
12043075	12043075	PRJNA577580_P_NODE_11330_length_274_cov_0.990050_g11252_i0	PRJNA577580	11330	274	0.99005	2.712737	Sopafab virus	3131770	Viruses	Viruses	255	1.79e-63	NTclustered	gi\|2717323354\|gb\|PP174071.1\|	3131770	g11252	i0	84.043	68.1824817518248	282	27	97	12	10	274	310	30	MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence	blastn	18682	255	1	Viruses		Orthornavirae	Lenarviricota	Amabiliviricetes				Sopafab virus
12043153	12043153	PRJNA577580_P_NODE_6130_length_363_cov_1.496552_g6052_i0	PRJNA577580	6130	363	1.496552	5.43248376	Zebrafish picornavirus 1	2304617	Viruses	Viruses	623	5.819999999999999e-174	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g6052	i0	98.31	2.93388429752066	355	6	98	0	1	355	4198	3844	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1065	623	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13318010	13318010	PRJNA577580_P_NODE_1891_length_661_cov_16.153061_g1816_i0	PRJNA577580	1891	661	16.153061	106.77173321	Jujube closterovirus 1	3043313	Viruses	Viruses	54.7	0.018	NTclustered	gi\|2496749738\|gb\|OP673405.1\|	3043313	g1816	i0	100	0.0438729198184569	29	0	4	0	1	29	7	35	Jujube closterovirus 1 isolate AKS15-20, complete genome	blastn	29	54.7	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae		Jujube closterovirus 1
13318047	13318047	PRJNA577580_P_NODE_5031_length_400_cov_1.431193_g4953_i0	PRJNA577580	5031	400	1.431193	5.724772	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	93.6	3.4e-19	NR	QIG59935.1	2704072	g4953	i0	41.1	0.93	124	55	87	4	389	42	254	367	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	372	93.6	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
13318068	13318068	PRJNA577580_P_NODE_8211_length_316_cov_1.358025_g8133_i0	PRJNA577580	8211	316	1.358025	4.291359	Caudoviricetes sp.	2832643	Viruses	Viruses	80.5	1.36e-10	NTclustered	gi\|2914774203\|gb\|OR222100.1\|	2832643	g8133	i0	88.235	27.8481012658228	68	6	21	2	169	235	33141	33207	MAG: Caudoviricetes sp. isolate MSP0010 genomic sequence	blastn	8800	80.5	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14592919	14592919	PRJNA577580_P_NODE_4912_length_404_cov_2.592145_g4834_i0	PRJNA577580	4912	404	2.592145	10.4722658	Caudoviricetes sp. vir323	3068356	Viruses	Viruses	121	1.05e-22	NTclustered	gi\|2587525388\|tpg\|BK063679.1\|	3068356	g4834	i0	75.397	5.22772277227723	252	60	79	2	78	328	9381	9131	TPA_asm: Caudoviricetes sp. vir323 genomic sequence	blastn	2112	121	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp. vir323
14592951	14592951	PRJNA577580_P_NODE_8912_length_304_cov_2.528139_g8834_i0	PRJNA577580	8912	304	2.528139	7.68554256	Solumvirus sp.	2487773	Viruses	Viruses	109	3.5100000000000004e-27	NR	AYV86227.1	2487773	g8834	i0	86.7	0.592105263157895	60	8	59.2	0	304	125	125	184	AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.]	diamond	180	109	1	Viruses	Pithoviruses							Solumvirus sp.
17141721	17141721	PRJNA577580_P_NODE_9134_length_301_cov_1.478070_g9056_i0	PRJNA577580	9134	301	1.47807	4.4489907	Zebrafish picornavirus 1	2304617	Viruses	Viruses	529	1.0599999999999996e-145	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9056	i0	98.339	3	301	5	100	0	1	301	4728	4428	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	903	529	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
18415951	18415951	PRJNA577580_P_NODE_3575_length_476_cov_3.548387_g3497_i0	PRJNA577580	3575	476	3.548387	16.89032212	Pseudomonas phage Lu11	1161927	Viruses	Viruses	63.9	2.14e-5	NTclustered	gi\|388684650\|ref\|NC_017972.1\|	1161927	g3497	i0	87.719	0.672268907563025	57	4	12	2	32	88	124877	124824	Pseudomonas phage Lu11, complete genome	blastn	320	63.9	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage Lu11
28058722	28058722	PRJNA577580_P_NODE_12625_length_261_cov_1.659574_g12547_i0	PRJNA577580	12625	261	1.659574	4.33148814	Mitoviridae sp.	2809572	Viruses	Viruses	52.8	1.41e-5	NR	UJQ92489.1	2809572	g12547	i0	35.7	0.804597701149425	70	45	80.5	0	52	261	20	89	UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	210	52.8	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
28121958	28121958	PRJNA577580_P_NODE_2725_length_547_cov_1.666667_g2647_i0	PRJNA577580	2725	547	1.666667	9.11666849	Dishui Lake large algae virus 1	2704073	Viruses	Viruses	68.9	4.75e-11	NR	QIG60086.1	2704073	g2647	i0	38.1	1.82632541133455	97	55	50.5	2	139	414	1	97	QIG60086.1 Erv1 [Dishui Lake large algae virus 1]	diamond	999	68.9	1	Viruses								Dishui Lake large algae virus 1
28248070	28248070	PRJNA577580_P_NODE_686_length_1036_cov_2.997923_g637_i0	PRJNA577580	686	1036	2.997923	31.05848228	Mitoviridae sp.	2809572	Viruses	Viruses	171	1.1e-43	NR	UJQ92489.1	2809572	g637	i0	37.2	0.732625482625483	253	154	71.8	2	270	1013	9	261	UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	759	171	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
28595719	28595719	PRJNA577580_P_NODE_13147_length_256_cov_1.644809_g13069_i0	PRJNA577580	13147	256	1.644809	4.21071104	Barrevirus sp.	2487763	Viruses	Viruses	52	1.54e-5	NR	AYV77273.1	2487763	g13069	i0	32.5	0.97265625	83	54	97.3	1	254	6	94	174	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	249	52	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29745446	29745446	PRJNA577580_P_NODE_9010_length_303_cov_1.356522_g8932_i0	PRJNA577580	9010	303	1.356522	4.11026166	Duamitovirus	2948686	Viruses	Viruses	116	1.1300000000000002e-27	NR	YP_004564622.1	1037523	g8932	i0	65.5	4.16831683168317	84	23	77.2	1	239	6	339	422	YP_004564622.1 RNA-dependent RNA polymerase [Tuber aestivum mitovirus]	diamond	1263	117	0.991452991452991	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Duamitovirus	Duamitovirus tuae1
29858449	29858449	PRJNA577580_P_NODE_3791_length_462_cov_3.437018_g3713_i0	PRJNA577580	3791	462	3.437018	15.87902316	Marseillevirus LCMAC1	2506602	Viruses	Viruses	49.7	2.23e-4	NR	QBK85646.1	2506602	g3713	i0	37.8	0.480519480519481	74	44	46.8	1	52	267	34	107	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	222	49.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
30047870	30047870	PRJNA577580_P_NODE_16671_length_238_cov_2.024242_g16593_i0	PRJNA577580	16671	238	2.024242	4.81769596	Mitoviridae sp.	2809572	Viruses	Viruses	46.6	0.00155	NR	UJQ92489.1	2809572	g16593	i0	36.5	0.794117647058823	63	40	79.4	0	235	47	167	229	UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	189	46.6	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
30205775	30205775	PRJNA577580_P_NODE_52_length_2278_cov_8.436735_g41_i0	PRJNA577580	52	2278	8.436735	192.1888233	Diaporthe gulyae mitovirus 3	3077427	Viruses	Viruses	144	8.62e-32	NR	WNM95031.1	3077427	g41	i0	29.2	0.578138718173837	439	269	55.7	12	406	1674	70	482	WNM95031.1 MAG: RNA-dependent RNA polymerase [Diaporthe gulyae mitovirus 3]	diamond	1317	144	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Diaporthe gulyae mitovirus 3
30837945	30837945	PRJNA577580_P_NODE_5634_length_377_cov_2.335526_g5556_i0	PRJNA577580	5634	377	2.335526	8.80493302	Marseillevirus LCMAC1	2506602	Viruses	Viruses	50.4	5.71e-5	NR	QBK85646.1	2506602	g5556	i0	32.4	0.541114058355438	68	46	54.1	0	359	156	33	100	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	204	50.4	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
31311941	31311941	PRJNA577580_P_NODE_435_length_1234_cov_7.890612_g397_i0	PRJNA577580	435	1234	7.890612	97.37015208	Ripajen virus	3131483	Viruses	Viruses	155	1.24e-37	NR	WZH61493.1	3131483	g397	i0	36.5	0.838735818476499	345	198	81.9	10	1011	1	45	376	WZH61493.1 MAG: RNA-dependent RNA polymerase [Ripajen virus]	diamond	1035	155	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripajen virus
31817983	31817983	PRJNA577580_P_NODE_14797_length_248_cov_0.891429_g14719_i0	PRJNA577580	14797	248	0.891429	2.21074392	Satyrvirus sp.	2487771	Viruses	Viruses	53.5	6.12e-6	NR	AYV85210.1	2487771	g14719	i0	37.5	1.95967741935484	80	47	94.4	2	8	241	30	108	AYV85210.1 MAG: serpin [Satyrvirus sp.]	diamond	486	53.5	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Satyrvirus sp.
32703228	32703228	PRJNA577580_P_NODE_9520_length_296_cov_1.399103_g9442_i0	PRJNA577580	9520	296	1.399103	4.14134488	Guangxi riverbank mitovirus 3	2937069	Viruses	Viruses	69.7	2.31e-11	NR	UPW42193.1	2937069	g9442	i0	40.2	2.93918918918919	97	57	97.3	1	295	8	379	475	UPW42193.1 MAG: putative RNA dependent RNA polymerase [Guangxi riverbank mitovirus 3]	diamond	870	69.7	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Guangxi riverbank mitovirus 3

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