metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA492280" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA492280" 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
26855136	26855136	PRJNA492280_P_NODE_20601_length_164_cov_3.236220_g20494_i0	PRJNA492280	20601	164	3.23622	5.3074008	Caudoviricetes sp.	2832643	Viruses	Viruses	75.5	1.3e-14	NR	XOS36382.1	2832643	g20494	i0	74	0.914634146341463	50	10	91.5	1	3	152	108	154	XOS36382.1 MAG: thymidylate synthase [Caudoviricetes sp.]	diamond	150	75.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26886756	26886756	PRJNA492280_P_NODE_19721_length_164_cov_3.377953_g19614_i0	PRJNA492280	19721	164	3.377953	5.53984292	Caudoviricetes sp.	2832643	Viruses	Viruses	49.3	6.21e-5	NR	XOR14691.1	2832643	g19614	i0	95.8	0.439024390243902	24	1	43.9	0	91	162	626	649	XOR14691.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.]	diamond	72	49.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27803078	27803078	PRJNA492280_P_NODE_13024_length_164_cov_5.779528_g12917_i0	PRJNA492280	13024	164	5.779528	9.47842592	uncultured Caudovirales phage	2100421	Viruses	Viruses	51.6	9.46e-6	NR	CAB4152307.1	2100421	g12917	i0	95.8	0.439024390243902	24	1	43.9	0	5	76	407	430	CAB4152307.1 PolA DNA polymerase I - 3'-5' exonuclease and polymerase domains [uncultured Caudovirales phage]	diamond	72	51.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28181566	28181566	PRJNA492280_P_NODE_14326_length_164_cov_4.881890_g14219_i0	PRJNA492280	14326	164	4.88189	8.0062996	Caudoviricetes sp.	2832643	Viruses	Viruses	57	1.18e-7	NR	XOS71940.1	2832643	g14219	i0	92	0.914634146341463	25	2	45.7	0	89	163	571	595	XOS71940.1 MAG: phage associated primase, partial [Caudoviricetes sp.]	diamond	150	57	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28687294	28687294	PRJNA492280_P_NODE_9707_length_172_cov_3.881481_g9600_i0	PRJNA492280	9707	172	3.881481	6.67614732	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	43.9	0.0058	NR	YP_010840939.1	2951531	g9600	i0	55.3	0.819767441860465	47	20	80.2	1	160	23	14	60	YP_010840939.1 L protein [Hardyhead chuvirus]	diamond	141	43.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
28812959	28812959	PRJNA492280_P_NODE_17328_length_164_cov_3.874016_g17221_i0	PRJNA492280	17328	164	3.874016	6.35338624	uncultured Caudovirales phage	2100421	Viruses	Viruses	45.1	0.00193	NR	CAB4134624.1	2100421	g17221	i0	58.1	0.786585365853659	43	12	67.7	2	159	49	165	207	CAB4134624.1 Phage-like element PBSX protein, XkdF [uncultured Caudovirales phage]	diamond	129	45.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28971212	28971212	PRJNA492280_P_NODE_33128_length_150_cov_4.398230_g33021_i0	PRJNA492280	33128	150	4.39823	6.597345	Caudoviricetes sp.	2832643	Viruses	Viruses	40.8	0.049	NR	XOS01503.1	2832643	g33021	i0	62.5	0.48	24	9	48	0	77	148	240	263	XOS01503.1 MAG: hypothetical protein MSP1228_56 [Caudoviricetes sp.]	diamond	72	40.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29034564	29034564	PRJNA492280_P_NODE_34188_length_150_cov_3.265487_g34081_i0	PRJNA492280	34188	150	3.265487	4.8982305	Caudoviricetes sp.	2832643	Viruses	Viruses	79	1.13e-15	NR	XOR14693.1	2832643	g34081	i0	46.1	2.04	102	2	98	1	148	2	239	340	XOR14693.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.]	diamond	306	79	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29476055	29476055	PRJNA492280_P_NODE_29610_length_151_cov_6.710526_g29503_i0	PRJNA492280	29610	151	6.710526	10.13289426	Ralstonia phage PY	3145150	Viruses	Viruses	55.8	3.12e-8	NR	XAO34315.1	3145150	g29503	i0	91.7	0.47682119205298	24	2	47.7	0	77	148	31	54	XAO34315.1 hypothetical protein HMHLAPFJ_00021 [Ralstonia phage PY059YO380]	diamond	72	55.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Ralstonia phage PY059YO380
29665418	29665418	PRJNA492280_P_NODE_24650_length_164_cov_2.629921_g24543_i0	PRJNA492280	24650	164	2.629921	4.31307044	Caudoviricetes sp.	2832643	Viruses	Viruses	74.3	9.21e-14	NR	XOS31925.1	2832643	g24543	i0	64.7	1.24390243902439	68	9	97	1	4	162	77	144	XOS31925.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.]	diamond	204	74.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30361222	30361222	PRJNA492280_P_NODE_16272_length_164_cov_4.149606_g16165_i0	PRJNA492280	16272	164	4.149606	6.80535384	Erysiphales associated mitovirus 1	2719863	Viruses	Viruses	44.3	0.00368	NR	QIP68031.1	2719863	g16165	i0	79.2	0.439024390243902	24	5	43.9	0	4	75	224	247	QIP68031.1 RNA-dependent RNA polymerase [Erysiphales associated mitovirus 1]	diamond	72	44.3	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Erysiphales associated mitovirus 1
30676560	30676560	PRJNA492280_P_NODE_8393_length_183_cov_4.102740_g8286_i0	PRJNA492280	8393	183	4.10274	7.5080142	Stenotrophomonas virus Jojan6	2932861	Viruses	Viruses	44.7	0.00216	NR	UPU15964.1	2932861	g8286	i0	58.8	0.557377049180328	34	14	55.7	0	102	1	93	126	UPU15964.1 major tail protein [Stenotrophomonas virus Jojan60]	diamond	102	44.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Stenotrophomonas virus Jojan60
30992754	30992754	PRJNA492280_P_NODE_30454_length_151_cov_4.263158_g30347_i0	PRJNA492280	30454	151	4.263158	6.43736858	Caudoviricetes sp.	2832643	Viruses	Viruses	41.2	0.0363	NR	XOQ91085.1	2832643	g30347	i0	30.5	2.54304635761589	128	9	95.4	1	146	3	17	144	XOQ91085.1 MAG: baseplate protein [Caudoviricetes sp.]	diamond	384	41.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31688207	31688207	PRJNA492280_P_NODE_30957_length_151_cov_3.631579_g30850_i0	PRJNA492280	30957	151	3.631579	5.48368429	Caudoviricetes sp.	2832643	Viruses	Viruses	50.8	1.49e-5	NR	XOS71940.1	2832643	g30850	i0	91.7	0.95364238410596	24	2	47.7	0	74	145	219	242	XOS71940.1 MAG: phage associated primase, partial [Caudoviricetes sp.]	diamond	144	50.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31814796	31814796	PRJNA492280_P_NODE_20277_length_164_cov_3.291339_g20170_i0	PRJNA492280	20277	164	3.291339	5.39779596	Caudoviricetes sp.	2832643	Viruses	Viruses	55.1	5.58e-7	NR	XOR14618.1	2832643	g20170	i0	100	0.402439024390244	22	0	40.2	0	10	75	98	119	XOR14618.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	66	55.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31909718	31909718	PRJNA492280_P_NODE_28477_length_155_cov_4.737288_g28370_i0	PRJNA492280	28477	155	4.737288	7.3427964	Xiaogan botourmia-like virus 3	2970214	Viruses	Viruses	52.4	4.43e-6	NR	UUW21033.1	2970214	g28370	i0	87.5	0.929032258064516	24	3	46.5	0	76	5	189	212	UUW21033.1 MAG: putative RNA-dependent RNA polymerase [Xiaogan botourmia-like virus 3]	diamond	144	52.4	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Xiaogan botourmia-like virus 3
32321357	32321357	PRJNA492280_P_NODE_23759_length_164_cov_2.763780_g23652_i0	PRJNA492280	23759	164	2.76378	4.5325992	Caudoviricetes sp.	2832643	Viruses	Viruses	43.5	0.00691	NR	XOQ89890.1	2832643	g23652	i0	72	0.914634146341463	25	7	45.7	0	164	90	646	670	XOQ89890.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	150	43.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32447836	32447836	PRJNA492280_P_NODE_32679_length_150_cov_5.345133_g32572_i0	PRJNA492280	32679	150	5.345133	8.0176995	Plasmopara viticola lesion associated Partitivirus 3	2692001	Viruses	Viruses	43.9	0.0042	NR	QHD64799.1	2692001	g32572	i0	76	1.96	25	6	50	0	76	150	258	282	QHD64799.1 coat protein [Plasmopara viticola lesion associated Partitivirus 3]	diamond	294	43.9	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Plasmopara viticola lesion associated Partitivirus 3
32668495	32668495	PRJNA492280_P_NODE_18720_length_164_cov_3.551181_g18613_i0	PRJNA492280	18720	164	3.551181	5.82393684	Leviviridae sp.	2027243	Viruses	Viruses	44.3	0.00366	NR	URG15268.1	2027243	g18613	i0	83.3	0.439024390243902	24	4	43.9	0	91	162	254	277	URG15268.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	72	44.3	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae 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);;