metadata: contig_metadata: 25 rows where bioproject = "PRJNA557895" and tax

25 rows where bioproject = "PRJNA557895" 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
1811540	1811540	PRJNA557895_P_NODE_20362_length_206_cov_0.974522_g20007_i0	PRJNA557895	20362	206	0.974522	2.00751532	Myoviridae sp. ctNQr16	2826644	Viruses	Viruses	52.8	0.018	NTclustered	gi\|2051091879\|tpg\|BK014863.1\|	2826644	g20007	i0	100	0.135922330097087	28	0	14	0	171	198	6516	6543	MAG TPA_asm: Myoviridae sp. ctNQr16, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Myoviridae sp. ctNQr16
8188968	8188968	PRJNA557895_P_NODE_27347_length_176_cov_1.110236_g26992_i0	PRJNA557895	27347	176	1.110236	1.95401536	Caudoviricetes sp.	2832643	Viruses	Viruses	60.2	8.87e-5	NTclustered	gi\|2054626776\|tpg\|BK022234.1\|	2832643	g26992	i0	87.273	0.3125	55	4	31	3	33	86	101540	101592	MAG TPA_asm: Caudoviricetes sp. isolate ctoHj1, partial genome	blastn	55	60.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11331462	11331462	PRJNA557895_P_NODE_30289_length_167_cov_0.864407_g29934_i0	PRJNA557895	30289	167	0.864407	1.44355969	Viruses	10239	Viruses	Viruses	52.8	0.014	NTclustered	gi\|2059790287\|tpg\|BK039526.1\|	38018	g29934	i0	100	0.335329341317365	28	0	17	0	97	124	12995	12968	MAG TPA_asm: Bacteriophage sp. isolate ctIei2, partial genome	blastn	56	52.8	1	Viruses							Bacteriophage sp.
17706272	17706272	PRJNA557895_P_NODE_25914_length_181_cov_1.348485_g25559_i0	PRJNA557895	25914	181	1.348485	2.44075785	Viruses	10239	Viruses	Viruses	52.8	0.015	NTclustered	gi\|2294118676\|gb\|OP073777.1\|	38018	g25559	i0	100	0.92817679558011	28	0	15	0	146	173	18773	18746	MAG: Bacteriophage sp. isolate 1241_3989, partial genome	blastn	168	52.8	1	Viruses							Bacteriophage sp.
27078854	27078854	PRJNA557895_P_NODE_19402_length_210_cov_1.677019_g19047_i0	PRJNA557895	19402	210	1.677019	3.5217399	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	114	1.1500000000000002e-27	NR	YP_009337310.1	1923643	g19047	i0	80.3	1.01428571428571	71	13	100	1	210	1	512	582	YP_009337310.1 hypothetical protein 2 [Wenzhou picorna-like virus 6]	diamond	213	114	1	Viruses							Wenzhou picorna-like virus 6
27110264	27110264	PRJNA557895_P_NODE_23022_length_193_cov_2.125000_g22667_i0	PRJNA557895	23022	193	2.125	4.10125	Flumine marna-like virus 6	2941474	Viruses	Viruses	69.3	8.31e-12	NR	UQB76035.1	2941474	g22667	i0	46.9	0.994818652849741	64	34	99.5	0	193	2	2441	2504	UQB76035.1 nonstructural protein [Flumine marna-like virus 6]	diamond	192	69.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Flumine marna-like virus 6
27931689	27931689	PRJNA557895_P_NODE_13885_length_248_cov_1.276382_g13530_i0	PRJNA557895	13885	248	1.276382	3.16542736	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	152	8.38e-41	NR	YP_009337309.1	1923643	g13530	i0	81.7	0.991935483870968	82	15	99.2	0	1	246	1292	1373	YP_009337309.1 hypothetical protein 1 [Wenzhou picorna-like virus 6]	diamond	246	152	1	Viruses							Wenzhou picorna-like virus 6
28387734	28387734	PRJNA557895_P_NODE_16786_length_225_cov_0.772727_g16431_i0	PRJNA557895	16786	225	0.772727	1.73863575	Viruses	10239	Viruses	Viruses	58.9	5.96e-8	NR	QJI53795.1	2715102	g16431	i0	43.8	4.34666666666667	64	32	85.3	1	1	192	592	651	QJI53795.1 MAG: hypothetical protein 2 [Marnaviridae sp.]	diamond	978	58.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
28531742	28531742	PRJNA557895_P_NODE_22487_length_196_cov_1.034014_g22132_i0	PRJNA557895	22487	196	1.034014	2.02666744	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	134	8.61e-35	NR	YP_009337310.1	1923643	g22132	i0	95.4	0.994897959183674	65	3	99.5	0	2	196	357	421	YP_009337310.1 hypothetical protein 2 [Wenzhou picorna-like virus 6]	diamond	195	134	1	Viruses							Wenzhou picorna-like virus 6
28658020	28658020	PRJNA557895_P_NODE_2527_length_639_cov_3.115254_g2197_i0	PRJNA557895	2527	639	3.115254	19.90647306	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	105	6.1e-23	NR	BCT22626.1	RQ14	g2197	i0	37.2	0.882629107981221	188	111	86.4	5	556	5	3	187	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	diamond	564	105	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
28910178	28910178	PRJNA557895_P_NODE_8008_length_316_cov_1.505618_g7653_i0	PRJNA557895	8008	316	1.505618	4.75775288	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	86.3	4.65e-17	NR	BCT22717.1	RQ14	g7653	i0	40.8	0.977848101265823	103	57	94	2	299	3	1022	1124	BCT22717.1 B22R family protein [Carp edema virus]	diamond	309	86.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29131653	29131653	PRJNA557895_P_NODE_19249_length_211_cov_1.259259_g18894_i0	PRJNA557895	19249	211	1.259259	2.65703649	Wenzhou picorna-like virus 27	1923612	Viruses	Viruses	149	7.879999999999999e-40	NR	YP_009336706.1	1923612	g18894	i0	98.6	1.96208530805687	69	1	98.1	0	3	209	2162	2230	YP_009336706.1 hypothetical protein [Wenzhou picorna-like virus 27]	diamond	414	149	1	Viruses							Wenzhou picorna-like virus 27
29257563	29257563	PRJNA557895_P_NODE_34049_length_164_cov_0.886957_g33694_i0	PRJNA557895	34049	164	0.886957	1.45460948	Caudoviricetes sp.	2832643	Viruses	Viruses	40	0.0461	NR	DAI02745.1	2832643	g33694	i0	44.7	0.695121951219512	38	21	69.5	0	18	131	66	103	DAI02745.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	114	40	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30236841	30236841	PRJNA557895_P_NODE_5132_length_400_cov_2.917379_g4777_i0	PRJNA557895	5132	400	2.917379	11.669516	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	51.6	9.09e-5	NR	BCT22707.1	RQ14	g4777	i0	30.5	0.9825	131	71	95.3	6	12	392	1	115	BCT22707.1 hypothetical protein [Carp edema virus]	diamond	393	51.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
30521163	30521163	PRJNA557895_P_NODE_28353_length_172_cov_1.227642_g27998_i0	PRJNA557895	28353	172	1.227642	2.11154424	Oxalis corniculata genomoviridae	2739874	Viruses	Viruses	42	0.027	NR	YP_010798486.1	2739874	g27998	i0	37.8	0.784883720930233	45	28	78.5	0	22	156	169	213	YP_010798486.1 Rep [Oxalis corniculata genomoviridae]	diamond	135	42	1	Viruses	Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Genomoviridae	Gemycircularvirus	Gemycircularvirus oxcor1
30661667	30661667	PRJNA557895_P_NODE_37393_length_162_cov_0.902655_g37038_i0	PRJNA557895	37393	162	0.902655	1.4623011	Viruses	10239	Viruses	Viruses	64.7	2.28e-10	NR	WZH59296.1	3130218	g37038	i0	52.8	1.90740740740741	53	25	98.1	0	162	4	1079	1131	WZH59296.1 MAG: replicase polyprotein [Ripiwisk virus]	diamond	309	65.1	0.993855606758833	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Ripiwisk virus
30678986	30678986	PRJNA557895_P_NODE_23693_length_190_cov_1.446809_g23338_i0	PRJNA557895	23693	190	1.446809	2.7489371	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	58.5	4.82e-8	NR	BCT22716.1	RQ14	g23338	i0	46.3	0.852631578947368	54	29	85.3	0	164	3	1620	1673	BCT22716.1 variola B22R family protein [Carp edema virus]	diamond	162	58.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
31215898	31215898	PRJNA557895_P_NODE_5835_length_373_cov_1.166667_g5480_i0	PRJNA557895	5835	373	1.166667	4.35166791	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	192	1.5099999999999998e-54	NR	YP_009337310.1	1923643	g5480	i0	79.7	0.989276139410188	123	25	98.9	0	3	371	181	303	YP_009337310.1 hypothetical protein 2 [Wenzhou picorna-like virus 6]	diamond	369	192	1	Viruses							Wenzhou picorna-like virus 6
31785434	31785434	PRJNA557895_P_NODE_33717_length_164_cov_1.330435_g33362_i0	PRJNA557895	33717	164	1.330435	2.1819134	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	74.3	9.25e-14	NR	YP_009337309.1	1923643	g33362	i0	68.8	0.878048780487805	48	15	87.8	0	19	162	46	93	YP_009337309.1 hypothetical protein 1 [Wenzhou picorna-like virus 6]	diamond	144	74.3	1	Viruses							Wenzhou picorna-like virus 6
31817139	31817139	PRJNA557895_P_NODE_24757_length_186_cov_1.116788_g24402_i0	PRJNA557895	24757	186	1.116788	2.07722568	Mute swan feces associated picorna-like virus 19	2832192	Viruses	Viruses	77.4	1.03e-14	NR	QUS52722.1	2832192	g24402	i0	50	0.967741935483871	60	30	96.8	0	2	181	12	71	QUS52722.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 19]	diamond	180	77.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Mute swan feces associated picorna-like virus 19
32133794	32133794	PRJNA557895_P_NODE_37938_length_161_cov_1.776786_g37583_i0	PRJNA557895	37938	161	1.776786	2.86062546	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	48.9	8.11e-5	NR	QJI53566.1	3003959	g37583	i0	43.1	0.950310559006211	51	29	95	0	7	159	462	512	QJI53566.1 MAG: capsid protein [Picornavirales sp.]	diamond	153	48.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32292250	32292250	PRJNA557895_P_NODE_3339_length_533_cov_1.760331_g2995_i0	PRJNA557895	3339	533	1.760331	9.38256423	Wenzhou picorna-like virus 6	1923643	Viruses	Viruses	279	5.47e-86	NR	YP_009337310.1	1923643	g2995	i0	92.3	0.799249530956848	142	11	79.9	0	3	428	682	823	YP_009337310.1 hypothetical protein 2 [Wenzhou picorna-like virus 6]	diamond	426	279	1	Viruses							Wenzhou picorna-like virus 6
32355372	32355372	PRJNA557895_P_NODE_14299_length_244_cov_1.046154_g13944_i0	PRJNA557895	14299	244	1.046154	2.55261576	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	73.9	3.96e-13	NR	BCT22715.1	RQ14	g13944	i0	45.2	1.84426229508197	73	40	89.8	0	240	22	357	429	BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus]	diamond	450	73.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
32369452	32369452	PRJNA557895_P_NODE_31579_length_166_cov_0.871795_g31224_i0	PRJNA557895	31579	166	0.871795	1.4471797	Moumouvirus	3080801	Viruses	Viruses	45.8	0.00109	NR	QFG74124.1	1737588	g31224	i0	46.5	4.91566265060241	43	23	77.7	0	141	13	469	511	QFG74124.1 MAG: DNA topoisomerase I-like protein [Megaviridae environmental sample]	diamond	816	46.2	0.991341991341991	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
32702419	32702419	PRJNA557895_P_NODE_36020_length_163_cov_0.894737_g35665_i0	PRJNA557895	36020	163	0.894737	1.45842131	Penaeus japonicus marna-like virus2	3132547	Viruses	Viruses	53.5	1.89e-6	NR	WWZ85606.1	3132547	g35665	i0	54	1.89570552147239	50	23	92	0	3	152	304	353	WWZ85606.1 capsid protein [Penaeus japonicus marna-like virus2]	diamond	309	53.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Penaeus japonicus marna-like virus2

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