metadata: contig_metadata: 29 rows where bioproject = "PRJNA340009" and tax

29 rows where bioproject = "PRJNA340009" and tax_phylum = "Phixviricota"

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
1666475	1666475	PRJNA340009_P_NODE_14162_length_313_cov_5.132576_g13855_i0	PRJNA340009	14162	313	5.132576	16.06496288	Microviridae sp.	2202644	Viruses	Viruses	193	1.65e-44	NTclustered	gi\|1603902751\|gb\|MH616940.2\|	2202644	g13855	i0	87.805	1.27476038338658	164	20	52	0	46	209	2333	2170	MAG: Microviridae sp. isolate ctdg534, complete genome	blastn	399	193	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
1667147	1667147	PRJNA340009_P_NODE_72642_length_163_cov_0.877193_g72335_i0	PRJNA340009	72642	163	0.877193	1.42982459	Microviridae sp.	2202644	Viruses	Viruses	92.4	3.99e-20	NR	WQF92503.1	2202644	g72335	i0	74.1	9.79141104294479	54	14	99.4	0	2	163	650	703	WQF92503.1 MAG: major capsid protein, partial [Microviridae sp.]	diamond	1596	92.4	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
1667224	1667224	PRJNA340009_P_NODE_80822_length_152_cov_2.456311_g80515_i0	PRJNA340009	80822	152	2.456311	3.73359272	Microviridae sp.	2202644	Viruses	Viruses	110	7.27e-20	NTclustered	gi\|2906151359\|gb\|PQ646576.1\|	2202644	g80515	i0	93.243	0.486842105263158	74	5	49	0	1	74	3631	3558	MAG: Microviridae sp. isolate k127_3173000 genomic sequence	blastn	74	110	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
2943090	2943090	PRJNA340009_P_NODE_63763_length_166_cov_1.743590_g63456_i0	PRJNA340009	63763	166	1.74359	2.8943594	Kummerowia striata gokushovirus	2740155	Viruses	Viruses	68.6	1.04e-11	NR	QKI28903.1	2740155	g63456	i0	72.5	9.39759036144578	40	11	72.3	0	2	121	489	528	QKI28903.1 VP1 [Kummerowia striata gokushovirus]	diamond	1560	68.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Kummerowia striata gokushovirus
10595756	10595756	PRJNA340009_P_NODE_26589_length_239_cov_2.147368_g26282_i0	PRJNA340009	26589	239	2.147368	5.13220952	Microviridae sp.	2202644	Viruses	Viruses	392	1.11e-104	NTclustered	gi\|2497507111\|gb\|OQ709380.1\|	2202644	g26282	i0	96.234	2	239	9	100	0	1	239	2860	2622	MAG: Microviridae sp. isolate SHu1-1, complete genome	blastn	478	392	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
13146101	13146101	PRJNA340009_P_NODE_67251_length_165_cov_0.879310_g66944_i0	PRJNA340009	67251	165	0.87931	1.4508615	Microviridae sp.	2202644	Viruses	Viruses	108	2.9e-19	NTclustered	gi\|2384854028\|gb\|OM154917.1\|	2202644	g66944	i0	85.437	8.83636363636364	103	15	62	0	50	152	101	203	MAG: Microviridae sp. isolate Miresoil microvirus 98, complete genome	blastn	1458	108	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
16969525	16969525	PRJNA340009_P_NODE_36174_length_210_cov_1.236025_g35867_i0	PRJNA340009	36174	210	1.236025	2.5956525	Microviridae sp.	2202644	Viruses	Viruses	359	9.7e-95	NTclustered	gi\|2906151359\|gb\|PQ646576.1\|	2202644	g35867	i0	99	0.952380952380952	200	2	95	0	11	210	2903	2704	MAG: Microviridae sp. isolate k127_3173000 genomic sequence	blastn	200	359	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
16969679	16969679	PRJNA340009_P_NODE_49414_length_184_cov_2.940741_g49107_i0	PRJNA340009	49414	184	2.940741	5.41096344	Microviridae sp.	2202644	Viruses	Viruses	89.8	1.2e-13	NTclustered	gi\|2384853757\|gb\|OM154888.1\|	2202644	g49107	i0	81.818	0.945652173913043	110	17	59	3	1	108	3599	3707	MAG: Microviridae sp. isolate Miresoil microvirus 69, complete genome	blastn	174	89.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
19518392	19518392	PRJNA340009_P_NODE_74936_length_162_cov_0.902655_g74629_i0	PRJNA340009	74936	162	0.902655	1.4623011	Microviridae sp.	2202644	Viruses	Viruses	54.7	0.004	NTclustered	gi\|2384853489\|gb\|OM154857.1\|	2202644	g74629	i0	100	0.179012345679012	29	0	18	0	19	47	2344	2372	MAG: Microviridae sp. isolate Miresoil microvirus 38, complete genome	blastn	29	54.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
20793231	20793231	PRJNA340009_P_NODE_12297_length_332_cov_5.130742_g11990_i0	PRJNA340009	12297	332	5.130742	17.03406344	Microvirus sp.	2202559	Viruses	Viruses	186	8.009999999999999e-54	NR	QJB19370.1	2202559	g11990	i0	79.6	0.930722891566265	103	21	93.1	0	20	328	74	176	QJB19370.1 MAG: major capsid protein [Microvirus sp.]	diamond	309	186	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
26979708	26979708	PRJNA340009_P_NODE_21102_length_264_cov_1.897674_g20795_i0	PRJNA340009	21102	264	1.897674	5.00985936	Microvirus sp.	2202559	Viruses	Viruses	55.5	1.55e-6	NR	WNK12897.1	2202559	g20795	i0	80.6	1.35227272727273	31	6	35.2	0	95	3	1	31	WNK12897.1 MAG: major capsid protein [Microvirus sp.]	diamond	357	55.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
26979782	26979782	PRJNA340009_P_NODE_79662_length_155_cov_2.764151_g79355_i0	PRJNA340009	79662	155	2.764151	4.28443405	Microviridae sp.	2202644	Viruses	Viruses	66.2	2.56e-11	NR	AXH76778.1	2202644	g79355	i0	70.8	0.929032258064516	48	14	92.9	0	154	11	31	78	AXH76778.1 MAG: DNA pilot protein [Microviridae sp.]	diamond	144	66.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27074692	27074692	PRJNA340009_P_NODE_59482_length_170_cov_1.561983_g59175_i0	PRJNA340009	59482	170	1.561983	2.6553711	Ariapismic virus 187	3376422	Viruses	Viruses	42	0.0146	NR	XJW05214.1	3376422	g59175	i0	37	1.92352941176471	54	34	95.3	0	6	167	44	97	XJW05214.1 MAG: internal scaffolding protein [Ariapismic virus 187]	diamond	327	42	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Ariapismic virus 187
27296000	27296000	PRJNA340009_P_NODE_67083_length_165_cov_0.879310_g66776_i0	PRJNA340009	67083	165	0.87931	1.4508615	Microviridae sp.	2202644	Viruses	Viruses	75.5	3.13e-16	NR	WAE43576.1	2202644	g66776	i0	85.4	0.745454545454545	41	6	74.5	0	41	163	1	41	WAE43576.1 MAG: nonstructural protein [Microviridae sp.]	diamond	123	75.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27390994	27390994	PRJNA340009_P_NODE_69343_length_164_cov_0.886957_g69036_i0	PRJNA340009	69343	164	0.886957	1.45460948	Microviridae sp.	2202644	Viruses	Viruses	93.2	2.03e-20	NR	WQF94744.1	2202644	g69036	i0	85.2	1.97560975609756	54	8	98.8	0	162	1	349	402	WQF94744.1 MAG: major capsid protein, partial [Microviridae sp.]	diamond	324	93.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27517105	27517105	PRJNA340009_P_NODE_57203_length_173_cov_1.500000_g56896_i0	PRJNA340009	57203	173	1.5	2.595	Microviridae Fen794	1655662	Viruses	Viruses	76.6	1.59e-14	NR	YP_009160412.1	1655662	g56896	i0	91.7	1.2485549132948	36	3	62.4	0	109	2	1	36	YP_009160412.1 major capsid protein VP1 [Microviridae Fen7940_21]	diamond	216	76.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae Fen7940_21
28022418	28022418	PRJNA340009_P_NODE_35505_length_211_cov_5.456790_g35198_i0	PRJNA340009	35505	211	5.45679	11.5138269	Microvirus sp.	2202559	Viruses	Viruses	50.1	2.11e-5	NR	QJB19372.1	2202559	g35198	i0	55	0.568720379146919	40	18	56.9	0	154	35	3	42	QJB19372.1 MAG: internal scaffolding protein [Microvirus sp.]	diamond	120	50.1	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
28369512	28369512	PRJNA340009_P_NODE_52906_length_179_cov_1.569231_g52599_i0	PRJNA340009	52906	179	1.569231	2.80892349	Microviridae sp.	2202644	Viruses	Viruses	92.8	3.61e-20	NR	AXH74404.1	2202644	g52599	i0	83	4.49162011173184	53	9	88.8	0	11	169	377	429	AXH74404.1 MAG: major capsid protein [Microviridae sp.]	diamond	804	92.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
28969524	28969524	PRJNA340009_P_NODE_18048_length_282_cov_2.918455_g17741_i0	PRJNA340009	18048	282	2.918455	8.2300431	Microvirus sp.	2202559	Viruses	Viruses	124	5.779999999999999e-32	NR	QJB20151.1	2202559	g17741	i0	69.1	2.96808510638298	94	24	97.9	3	280	5	7	97	QJB20151.1 MAG: replication initiator protein [Microvirus sp.]	diamond	837	124	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
29348511	29348511	PRJNA340009_P_NODE_77429_length_161_cov_0.910714_g77122_i0	PRJNA340009	77429	161	0.910714	1.46624954	Microvirus sp.	2202559	Viruses	Viruses	53.5	1.88e-6	NR	QJB19237.1	2202559	g77122	i0	60.9	0.857142857142857	46	18	85.7	0	139	2	239	284	QJB19237.1 MAG: major capsid protein [Microvirus sp.]	diamond	138	53.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
29442858	29442858	PRJNA340009_P_NODE_52750_length_179_cov_2.000000_g52443_i0	PRJNA340009	52750	179	2	3.58	Microviridae sp.	2202644	Viruses	Viruses	95.9	2.99e-21	NR	AXH75645.1	2202644	g52443	i0	69.5	9.75418994413408	59	18	98.9	0	1	177	475	533	AXH75645.1 MAG: major capsid protein [Microviridae sp.]	diamond	1746	95.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29506142	29506142	PRJNA340009_P_NODE_44590_length_192_cov_1.608392_g44283_i0	PRJNA340009	44590	192	1.608392	3.08811264	Microviridae sp.	2202644	Viruses	Viruses	64.7	2.33e-10	NR	XOE97502.1	2202644	g44283	i0	56.4	1.71875	55	24	85.9	0	26	190	91	145	XOE97502.1 MAG: pilot protein for DNA ejection [Microviridae sp.]	diamond	330	64.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29758743	29758743	PRJNA340009_P_NODE_74871_length_162_cov_0.902655_g74564_i0	PRJNA340009	74871	162	0.902655	1.4623011	Flyfo microvirus Tbat2_116	2907267	Viruses	Viruses	45.1	0.00185	NR	UIB81443.1	2907267	g74564	i0	42.3	0.962962962962963	52	30	96.3	0	158	3	245	296	UIB81443.1 DNA pilot protein [Flyfo microvirus Tbat2_116]	diamond	156	45.1	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Flyfo microvirus Tbat2_116
30232689	30232689	PRJNA340009_P_NODE_62772_length_167_cov_0.864407_g62465_i0	PRJNA340009	62772	167	0.864407	1.44355969	Blackfly microvirus SF	2576452	Viruses	Viruses	71.6	5.38e-13	NR	QCQ84969.1	2576452	g62465	i0	59.3	2.91017964071856	54	22	97	0	4	165	169	222	QCQ84969.1 replication initiator protein [Blackfly microvirus SF02]	diamond	486	71.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	Blackfly microvirus SF02
31306989	31306989	PRJNA340009_P_NODE_48815_length_185_cov_2.250000_g48508_i0	PRJNA340009	48815	185	2.25	4.1625	Microviridae sp.	2202644	Viruses	Viruses	55.5	5.21e-7	NR	DAL55228.1	2202644	g48508	i0	54.3	0.745945945945946	46	19	71.4	1	53	184	1	46	DAL55228.1 MAG TPA_asm: Replication associated protein [Microviridae sp.]	diamond	138	55.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31307000	31307000	PRJNA340009_P_NODE_59515_length_170_cov_1.388430_g59208_i0	PRJNA340009	59515	170	1.38843	2.360331	Microviridae sp.	2202644	Viruses	Viruses	53.9	1.57e-6	NR	WQF91826.1	2202644	g59208	i0	54.5	1.37647058823529	44	20	77.6	0	161	30	173	216	WQF91826.1 MAG: major capsid protein, partial [Microviridae sp.]	diamond	234	53.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31971289	31971289	PRJNA340009_P_NODE_74418_length_162_cov_0.902655_g74111_i0	PRJNA340009	74418	162	0.902655	1.4623011	Microvirus sp.	2202559	Viruses	Viruses	76.3	1.85e-14	NR	WNK13596.1	2202559	g74111	i0	68.8	0.888888888888889	48	15	88.9	0	17	160	21	68	WNK13596.1 MAG: major capsid protein [Microvirus sp.]	diamond	144	76.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
32477734	32477734	PRJNA340009_P_NODE_35739_length_211_cov_1.259259_g35432_i0	PRJNA340009	35739	211	1.259259	2.65703649	Microviridae sp.	2202644	Viruses	Viruses	105	3.05e-25	NR	AXH74403.1	2202644	g35432	i0	72.9	0.995260663507109	70	18	98.1	1	1	207	42	111	AXH74403.1 MAG: replication initiator protein [Microviridae sp.]	diamond	210	105	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
32477766	32477766	PRJNA340009_P_NODE_70599_length_163_cov_1.789474_g70292_i0	PRJNA340009	70599	163	1.789474	2.91684262	Gokushovirus WZ-2	1758150	Viruses	Viruses	62.8	8.72e-10	NR	ALS03705.1	1758150	g70292	i0	52	3.47852760736196	50	24	92	0	7	156	114	163	ALS03705.1 VP4 [Gokushovirus WZ-2015a]	diamond	567	62.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Gokushovirus WZ-2015a

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