metadata: contig_metadata: 23 rows where bioproject = "PRJNA285816" and tax

23 rows where bioproject = "PRJNA285816" 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
2922691	2922691	PRJNA285816_S_NODE_23563_length_170_cov_1.165289_g23461_i0	PRJNA285816	23563	170	1.165289	1.9809913	Caudoviricetes sp.	2832643	Viruses	Viruses	291	2.77e-74	NTclustered	gi\|2058128472\|tpg\|BK034062.1\|	2832643	g23461	i0	97.633	425.482352941176	169	4	99	0	1	169	39871	39703	MAG TPA_asm: Caudoviricetes sp. isolate ctw8r9, partial genome	blastn	72332	291	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4199017	4199017	PRJNA285816_S_NODE_13424_length_208_cov_0.981132_g13322_i0	PRJNA285816	13424	208	0.981132	2.04075456	Betacoronavirus pandemicum	3418604	Viruses	Viruses	76.8	1.08e-9	NTclustered	gi\|2565365187\|emb\|OY637518.1\|	2697049	g13322	i0	100	21.0913461538462	41	0	20	0	1	41	11672	11632	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	4387	76.8	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
8025231	8025231	PRJNA285816_S_NODE_18207_length_186_cov_5.532847_g18105_i0	PRJNA285816	18207	186	5.532847	10.29109542	Betacoronavirus pandemicum	3418604	Viruses	Viruses	60.2	9.5e-5	NTclustered	gi\|2560517252\|emb\|OY702345.1\|	2697049	g18105	i0	100	4.98924731182796	32	0	17	0	155	186	26488	26519	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	928	60.2	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
9300249	9300249	PRJNA285816_S_NODE_9888_length_232_cov_1.098361_g9786_i0	PRJNA285816	9888	232	1.098361	2.54819752	Parapoxvirus orf	3431389	Viruses	Viruses	65.8	2.66e-6	NTclustered	gi\|2755084565\|gb\|PP943426.1\|	10258	g9786	i0	93.333	17.3706896551724	45	2	19	1	1	45	121051	121094	Orf virus isolate FX17, partial genome	blastn	4030	65.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
10576081	10576081	PRJNA285816_S_NODE_6089_length_282_cov_1.562232_g5987_i0	PRJNA285816	6089	282	1.562232	4.40549424	Paenibacillus phage Pahemo	2835998	Viruses	Viruses	84.2	9.22e-12	NTclustered	gi\|2044627981\|gb\|MW927522.1\|	2835998	g5987	i0	96.154	15.3794326241135	52	1	18	1	1	51	41888	41939	Paenibacillus phage Pahemo, complete genome	blastn	4337	84.2	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Fernvirus	Paenibacillus phage Pahemo
12537624	12537624	PRJNA285816_S_NODE_17610_length_189_cov_1.042857_g17508_i0	PRJNA285816	17610	189	1.042857	1.97099973	Viruses	10239	Viruses	Viruses	71.3	4.48e-8	NTclustered	gi\|2167415105\|tpg\|BK059322.1\|	12271	g17508	i0	100	23.2380952380952	38	0	20	0	152	189	39	2	TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence	blastn	4392	71.3	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus arabis
13125698	13125698	PRJNA285816_S_NODE_12151_length_215_cov_1.566265_g12049_i0	PRJNA285816	12151	215	1.566265	3.36746975	Sopawol virus	3131668	Viruses	Viruses	274	3.72e-69	NTclustered	gi\|2717323098\|gb\|PP173969.1\|	3131668	g12049	i0	90.431	44.0837209302326	209	18	97	2	1	208	325	118	MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence	blastn	9478	274	1	Viruses		Orthornavirae	Lenarviricota	Leviviricetes				Sopawol virus
13125708	13125708	PRJNA285816_S_NODE_12911_length_211_cov_0.962963_g12809_i0	PRJNA285816	12911	211	0.962963	2.03185193	Betacoronavirus pandemicum	3418604	Viruses	Viruses	63.9	8.56e-6	NTclustered	gi\|2557389902\|emb\|OY653400.1\|	2697049	g12809	i0	97.368	17.0758293838863	38	0	18	1	175	211	19642	19679	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	3603	63.9	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
16949512	16949512	PRJNA285816_S_NODE_4914_length_309_cov_23.915385_g4812_i0	PRJNA285816	4914	309	23.915385	73.89853965	Chrocagost virus	3129398	Viruses	Viruses	296	1.21e-75	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g4812	i0	88.525	202.236245954693	244	28	79	0	5	248	5619	5862	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	62491	296	1	Viruses		Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
19497843	19497843	PRJNA285816_S_NODE_14416_length_202_cov_36.084967_g14314_i0	PRJNA285816	14416	202	36.084967	72.89163334	Nepovirus arabis	3047374	Viruses	Viruses	75	3.75e-9	NTclustered	gi\|2167415105\|tpg\|BK059322.1\|	12271	g14314	i0	97.674	19.4207920792079	43	1	21	0	1	43	2	44	TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence	blastn	3923	75	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus arabis
20773351	20773351	PRJNA285816_S_NODE_10477_length_227_cov_1.191011_g10375_i0	PRJNA285816	10477	227	1.191011	2.70359497	Parapoxvirus orf	3431389	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2755084441\|gb\|PP943425.1\|	10258	g10375	i0	100	1.36123348017621	29	0	13	0	199	227	67828	67800	Orf virus isolate FX10, partial genome	blastn	309	54.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
20773655	20773655	PRJNA285816_S_NODE_8097_length_251_cov_1.514851_g7995_i0	PRJNA285816	8097	251	1.514851	3.80227601	Coguvirus henanense	3059897	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2058277675\|dbj\|LC636074.1\|	2034157	g7995	i0	100	0.231075697211155	30	0	12	0	222	251	31	2	Watermelon crinkle leaf-associated virus 2 Ju-01-WCLaV2 MP gene for putative movement protein, complete cds	blastn	58	56.5	1	Viruses		Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Coguvirus	Coguvirus henanense
21460903	21460903	PRJNA285816_S_NODE_30377_length_154_cov_10.133333_g30275_i0	PRJNA285816	30377	154	10.133333	15.60533282	root	1	Root_unresolved	Root_unresolved	276	6.890000000000001e-70	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g30275	i0	100	96.7532467532468	149	0	97	0	6	154	15173	15025	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	14900	276	1	Viruses		Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
23323897	23323897	PRJNA285816_S_NODE_10839_length_224_cov_1.771429_g10737_i0	PRJNA285816	10839	224	1.771429	3.96800096	Betacoronavirus pandemicum	3418604	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2557646044\|emb\|OY675404.1\|	2697049	g10737	i0	100	9.12053571428571	30	0	13	0	195	224	18438	18467	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	2043	56.5	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
27863722	27863722	PRJNA285816_S_NODE_18645_length_185_cov_1.147059_g18543_i0	PRJNA285816	18645	185	1.147059	2.12205915	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	74.7	9.89e-16	NR	VBB17698.1	2420051	g18543	i0	61.5	1.68648648648649	52	20	84.3	0	30	185	32	83	VBB17698.1 Acyl-CoA-binding protein [Yasminevirus sp. GU-2018]	diamond	312	74.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
28021857	28021857	PRJNA285816_S_NODE_20765_length_178_cov_1.209302_g20663_i0	PRJNA285816	20765	178	1.209302	2.15255756	Sonamyl virus	3131590	Viruses	Viruses	74.3	1.14e-13	NR	WZH61631.1	3131590	g20663	i0	59.6	0.960674157303371	57	23	96.1	0	1	171	515	571	WZH61631.1 MAG: RNA-dependent RNA polymerase [Sonamyl virus]	diamond	171	74.3	1	Viruses		Orthornavirae	Lenarviricota	Amabiliviricetes				Sonamyl virus
28842466	28842466	PRJNA285816_S_NODE_25228_length_167_cov_1.381356_g25126_i0	PRJNA285816	25228	167	1.381356	2.30686452	Clandestinovirus	2831644	Viruses	Viruses	44.7	0.00276	NR	QYA18491.1	2831644	g25126	i0	52.5	0.718562874251497	40	19	71.9	0	167	48	39	78	QYA18491.1 deoxyguanosine kinase mitochondrial precursor [Clandestinovirus]	diamond	120	44.7	1	Viruses								Clandestinovirus
28969013	28969013	PRJNA285816_S_NODE_28_length_3767_cov_10.714094_g27_i0	PRJNA285816	28	3767	10.714094	403.59992098	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	160	9.76e-36	NR	YP_009449258.1	2023057	g27	i0	28.2	1.27820546854261	760	415	55.8	32	237	2339	13	700	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	4815	160	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
30453528	30453528	PRJNA285816_S_NODE_25893_length_166_cov_1.777778_g25791_i0	PRJNA285816	25893	166	1.777778	2.95111148	Pithovirus LCPAC	2506585	Viruses	Viruses	49.7	4.72e-5	NR	QBK89686.1	2506585	g25791	i0	44	0.903614457831325	50	21	90.4	1	8	157	283	325	QBK89686.1 MAG: protein of unknown function DUF3432 [Pithovirus LCPAC001]	diamond	150	49.7	1	Viruses	Pithoviruses							Pithovirus LCPAC001
31338023	31338023	PRJNA285816_S_NODE_4456_length_323_cov_2.313869_g4354_i0	PRJNA285816	4456	323	2.313869	7.47379687	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	64.3	2.6e-9	NR	YP_009449258.1	2023057	g4354	i0	39.1	3.72445820433437	110	55	97.5	4	4	318	81	183	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	1203	64.3	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
32034062	32034062	PRJNA285816_S_NODE_838_length_686_cov_3.149137_g772_i0	PRJNA285816	838	686	3.149137	21.60307982	Bamboo mosaic virus satellite RNA	190811	Viruses	Viruses	107	1.28e-25	NR	AJO26629.1	190811	g772	i0	51.1	0.787172011661808	90	44	39.4	0	499	230	25	114	AJO26629.1 P20 protein, partial [Bamboo mosaic virus satellite RNA]	diamond	540	107	1	Viruses	RNA satellites							Bamboo mosaic virus satellite RNA
32603384	32603384	PRJNA285816_S_NODE_11520_length_219_cov_1.488235_g11418_i0	PRJNA285816	11520	219	1.488235	3.25923465	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	55.8	6.51e-7	NR	YP_009449258.1	2023057	g11418	i0	48.5	1.9041095890411	66	27	89	2	14	208	47	106	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	417	55.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
32792073	32792073	PRJNA285816_S_NODE_3560_length_358_cov_4.181230_g3458_i0	PRJNA285816	3560	358	4.18123	14.9688034	Klosneuvirus KNV1	1977640	Viruses	Viruses	84.7	2.25e-16	NR	ARF12058.1	1977640	g3458	i0	52.6	0.653631284916201	78	35	65.4	1	356	123	387	462	ARF12058.1 aminotransferase class-III [Klosneuvirus KNV1]	diamond	234	84.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1

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