metadata: contig_metadata: 35 rows where bioproject = "PRJNA558770" and tax

35 rows where bioproject = "PRJNA558770" 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
539915	539915	PRJNA558770_P_NODE_244821_length_234_cov_2.427136_g242816_i0	PRJNA558770	244821	234	2.427136	5.67949824	Microvirus sp.	2202559	Viruses	Viruses	111	3.41e-20	NTclustered	gi\|1832329640\|gb\|MT309940.1\|	2202559	g242816	i0	93.333	0.594017094017094	75	5	32	0	160	234	1175	1101	MAG: Microvirus sp. isolate BS1_485, complete genome	blastn	139	111	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
1814887	1814887	PRJNA558770_P_NODE_202302_length_234_cov_3.693467_g200297_i0	PRJNA558770	202302	234	3.693467	8.64271278	Microviridae sp.	2202644	Viruses	Viruses	82.4	2.67e-11	NTclustered	gi\|2302021493\|gb\|MT209467.1\|	2202644	g200297	i0	89.552	0.286324786324786	67	3	28	4	4	68	129	193	MAG: Microviridae sp. isolate CN7_L19_407, complete genome	blastn	67	82.4	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
5643979	5643979	PRJNA558770_P_NODE_258945_length_234_cov_2.120603_g256940_i0	PRJNA558770	258945	234	2.120603	4.96221102	Microvirus sp.	2202559	Viruses	Viruses	106	1.59e-18	NTclustered	gi\|1832331690\|gb\|MT310250.1\|	2202559	g256940	i0	92.105	11.6068376068376	76	5	32	1	160	234	460	535	MAG: Microvirus sp. isolate 1712115_803, complete genome	blastn	2716	106	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
5645067	5645067	PRJNA558770_P_NODE_344705_length_233_cov_2.575758_g342700_i0	PRJNA558770	344705	233	2.575758	6.00151614	bajarodmic virus 689	3344058	Viruses	Viruses	52.8	0.021	NTclustered	gi\|2811247707\|gb\|PQ006907.1\|	3344058	g342700	i0	100	0.120171673819742	28	0	12	0	5	32	3900	3873	Bajarodmic virus 689 isolate BGG_076_17, complete genome	blastn	28	52.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	bajarodmic virus 689
6918165	6918165	PRJNA558770_P_NODE_257446_length_234_cov_2.150754_g255441_i0	PRJNA558770	257446	234	2.150754	5.03276436	Microvirus sp.	2202559	Viruses	Viruses	84.2	7.43e-12	NTclustered	gi\|2581533081\|gb\|OR350161.1\|	2202559	g255441	i0	91.667	1.33760683760684	60	5	26	0	15	74	1353	1294	MAG: Microvirus sp. isolate LSWO_180 clone LS394, complete genome	blastn	313	84.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
8194326	8194326	PRJNA558770_P_NODE_375927_length_228_cov_8.751295_g373922_i0	PRJNA558770	375927	228	8.751295	19.9529526	Microviridae sp.	2202644	Viruses	Viruses	171	5.38e-38	NTclustered	gi\|2906156024\|gb\|PQ646919.1\|	2202644	g373922	i0	87.417	1.31140350877193	151	16	65	3	1	149	3060	3209	MAG: Microviridae sp. isolate k127_3884585 genomic sequence	blastn	299	171	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
12017762	12017762	PRJNA558770_P_NODE_177930_length_234_cov_4.743719_g175925_i0	PRJNA558770	177930	234	4.743719	11.10030246	Microviridae sp.	2202644	Viruses	Viruses	93.5	1.23e-14	NTclustered	gi\|2302017726\|gb\|MT205596.1\|	2202644	g175925	i0	92.308	0.628205128205128	65	5	28	0	160	224	4224	4288	MAG: Microviridae sp. isolate CN7_L16_276, complete genome	blastn	147	93.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
14567118	14567118	PRJNA558770_P_NODE_148472_length_234_cov_6.527638_g146467_i0	PRJNA558770	148472	234	6.527638	15.27467292	Microviridae sp.	2202644	Viruses	Viruses	128	3.38e-25	NTclustered	gi\|2216796470\|gb\|MW202471.1\|	2202644	g146467	i0	100	0.918803418803419	69	0	62	0	165	233	672	604	Microviridae sp. isolate ctUFZ915, complete genome	blastn	215	128	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
14569113	14569113	PRJNA558770_P_NODE_254572_length_234_cov_2.211055_g252567_i0	PRJNA558770	254572	234	2.211055	5.1738687	Flumine microvirus 25	2940843	Viruses	Viruses	63.9	9.68e-6	NTclustered	gi\|2235497272\|gb\|OM953919.1\|	2940843	g252567	i0	95.122	0.55982905982906	41	1	17	1	22	61	2733	2773	Flumine microvirus 25 replication associated protein gene, complete cds	blastn	131	63.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Flumine microvirus 25
17116316	17116316	PRJNA558770_P_NODE_171434_length_234_cov_5.085427_g169429_i0	PRJNA558770	171434	234	5.085427	11.89989918	Microviridae sp.	2202644	Viruses	Viruses	97.1	9.55e-16	NTclustered	gi\|1603902580\|gb\|MH616802.2\|	2202644	g169429	i0	93.846	0.277777777777778	65	2	27	2	164	227	3551	3488	MAG: Microviridae sp. isolate ctce543, complete genome	blastn	65	97.1	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
17118307	17118307	PRJNA558770_P_NODE_286374_length_234_cov_1.633166_g284369_i0	PRJNA558770	286374	234	1.633166	3.82160844	Microviridae sp.	2202644	Viruses	Viruses	93.5	1.23e-14	NTclustered	gi\|1603903341\|gb\|MH617602.2\|	2202644	g284369	i0	96.429	0.239316239316239	56	2	24	0	6	61	3903	3958	MAG: Microviridae sp. isolate ctfg851, complete genome	blastn	56	93.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
20944961	20944961	PRJNA558770_P_NODE_76597_length_237_cov_8.524752_g74592_i0	PRJNA558770	76597	237	8.524752	20.20366224	Microviridae sp.	2202644	Viruses	Viruses	195	3.3399999999999997e-45	NTclustered	gi\|2056886486\|tpg\|BK053603.1\|	2202644	g74592	i0	91.549	2.43881856540084	142	11	59	1	1	141	1937	2078	MAG TPA_asm: Microviridae sp. isolate ctBLm2, partial genome	blastn	578	195	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
24765515	24765515	PRJNA558770_P_NODE_204640_length_234_cov_3.608040_g202635_i0	PRJNA558770	204640	234	3.60804	8.4428136	Microviridae sp.	2202644	Viruses	Viruses	124	4.38e-24	NTclustered	gi\|2056854241\|tpg\|BK044386.1\|	2202644	g202635	i0	96.053	2.15384615384615	76	3	64	0	159	234	5917	5992	MAG TPA_asm: Microviridae sp. isolate ctfkX3, partial genome	blastn	504	124	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
26603843	26603843	PRJNA558770_P_NODE_258741_length_234_cov_2.120603_g256736_i0	PRJNA558770	258741	234	2.120603	4.96221102	Microvirus sp.	2202559	Viruses	Viruses	48.5	1.2e-4	NR	WNK14872.1	2202559	g256736	i0	75	0.307692307692308	24	6	30.8	0	163	234	62	85	WNK14872.1 MAG: internal scaffolding protein [Microvirus sp.]	diamond	72	48.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
26825950	26825950	PRJNA558770_P_NODE_385781_length_192_cov_7.560510_g383776_i0	PRJNA558770	385781	192	7.56051	14.5161792	Microviridae sp.	2202644	Viruses	Viruses	86.7	2.45e-20	NR	UOF78628.1	2202644	g383776	i0	67.2	1	64	21	100	0	192	1	5	68	UOF78628.1 hypothetical protein [Microviridae sp.]	diamond	192	86.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
26857787	26857787	PRJNA558770_P_NODE_390981_length_173_cov_4.253623_g388976_i0	PRJNA558770	390981	173	4.253623	7.35876779	Microviridae sp.	2202644	Viruses	Viruses	70.9	1.47e-14	NR	XOF05521.1	2202644	g388976	i0	100	0.641618497109827	37	0	64.2	0	112	2	1	37	XOF05521.1 MAG: hypothetical protein [Microviridae sp.]	diamond	111	70.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27110341	27110341	PRJNA558770_P_NODE_382142_length_208_cov_8.335260_g380137_i0	PRJNA558770	382142	208	8.33526	17.3373408	Microviridae sp.	2202644	Viruses	Viruses	127	1.43e-32	NR	UOF78622.1	2202644	g380137	i0	94	0.966346153846154	67	4	96.6	0	205	5	258	324	UOF78622.1 major capsid protein [Microviridae sp.]	diamond	201	127	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
27774045	27774045	PRJNA558770_P_NODE_268884_length_234_cov_1.929648_g266879_i0	PRJNA558770	268884	234	1.929648	4.51537632	Blackfly microvirus SF	2576452	Viruses	Viruses	43.1	0.0228	NR	QCQ84715.1	2576452	g266879	i0	79.2	0.307692307692308	24	5	30.8	0	74	3	167	190	QCQ84715.1 replication initiator protein [Blackfly microvirus SF02]	diamond	72	43.1	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	Blackfly microvirus SF02
28247324	28247324	PRJNA558770_P_NODE_241786_length_234_cov_2.497487_g239781_i0	PRJNA558770	241786	234	2.497487	5.84411958	Microviridae sp.	2202644	Viruses	Viruses	51.2	3.05e-6	NR	XOE98612.1	2202644	g239781	i0	88	0.320512820512821	25	3	32.1	0	1	75	2	26	XOE98612.1 MAG: DNA binding protein [Microviridae sp.]	diamond	75	51.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29163406	29163406	PRJNA558770_P_NODE_47049_length_313_cov_8.694245_g45047_i0	PRJNA558770	47049	313	8.694245	27.21298685	Microviridae sp.	2202644	Viruses	Viruses	91.7	1.77e-19	NR	AXH75287.1	2202644	g45047	i0	76.5	0.488817891373802	51	12	48.9	0	312	160	142	192	AXH75287.1 MAG: replication initiator protein [Microviridae sp.]	diamond	153	91.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29320968	29320968	PRJNA558770_P_NODE_55209_length_283_cov_6.370968_g53205_i0	PRJNA558770	55209	283	6.370968	18.02983944	Ariapismic virus 59	3376564	Viruses	Viruses	62	1.42e-9	NR	XJW04580.1	3376564	g53205	i0	72.1	0.45583038869258	43	12	45.6	0	137	9	50	92	XJW04580.1 MAG: internal scaffolding protein [Ariapismic virus 59]	diamond	129	62	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Ariapismic virus 59
29384280	29384280	PRJNA558770_P_NODE_389549_length_178_cov_6.566434_g387544_i0	PRJNA558770	389549	178	6.566434	11.68825252	Microviridae sp.	2202644	Viruses	Viruses	67	3.61e-11	NR	AXH76120.1	2202644	g387544	i0	63.8	0.97752808988764	58	20	96.1	1	173	3	73	130	AXH76120.1 MAG: replication initiator protein [Microviridae sp.]	diamond	174	67	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29604869	29604869	PRJNA558770_P_NODE_75030_length_239_cov_19.686275_g73025_i0	PRJNA558770	75030	239	19.686275	47.05019725	Microviridae sp.	2202644	Viruses	Viruses	61.6	7.2e-9	NR	AXH76551.1	2202644	g73025	i0	47.1	1.59414225941423	70	33	82.8	2	5	202	269	338	AXH76551.1 MAG: replication initiator protein [Microviridae sp.]	diamond	381	61.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
29808534	29808534	PRJNA558770_P_NODE_236011_length_234_cov_2.643216_g234006_i0	PRJNA558770	236011	234	2.643216	6.18512544	Microvirus	10842	Viruses	Viruses	43.9	0.0127	NR	AXH76386.1	2202644	g234006	i0	83.3	4.61538461538461	24	4	30.8	0	3	74	283	306	AXH76386.1 MAG: major capsid protein [Microviridae sp.]	diamond	1080	44.3	0.99097065462754	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
30110490	30110490	PRJNA558770_P_NODE_73372_length_242_cov_10.869565_g71367_i0	PRJNA558770	73372	242	10.869565	26.3043473	Microvirus sp.	2202559	Viruses	Viruses	132	1.19e-35	NR	QJB19245.1	2202559	g71367	i0	82.1	0.966942148760331	78	14	96.7	0	3	236	63	140	QJB19245.1 MAG: replication initiator protein [Microvirus sp.]	diamond	234	132	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
30236877	30236877	PRJNA558770_P_NODE_207452_length_234_cov_3.502513_g205447_i0	PRJNA558770	207452	234	3.502513	8.19588042	Ariapismic virus 19	3376425	Viruses	Viruses	43.1	0.0124	NR	XJW05234.1	3376426	g205447	i0	91.3	0.58974358974359	23	2	29.5	0	229	161	67	89	XJW05234.1 MAG: internal scaffolding protein [Ariapismic virus 190]	diamond	138	43.1	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Ariapismic virus 190
30489727	30489727	PRJNA558770_P_NODE_56193_length_279_cov_19.930328_g54189_i0	PRJNA558770	56193	279	19.930328	55.60561512	Microviridae sp.	2202644	Viruses	Viruses	101	8.28e-24	NR	AXH73227.1	2202644	g54189	i0	56	0.978494623655914	91	38	95.7	1	274	8	121	211	AXH73227.1 MAG: DNA pilot protein [Microviridae sp.]	diamond	273	101	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
30774171	30774171	PRJNA558770_P_NODE_237054_length_234_cov_2.613065_g235049_i0	PRJNA558770	237054	234	2.613065	6.1145721	Microviridae sp.	2202644	Viruses	Viruses	60.5	1.67e-8	NR	AXH78097.1	2202644	g235049	i0	40.3	1.97435897435897	77	18	98.7	1	233	3	81	129	AXH78097.1 MAG: replication initiator protein [Microviridae sp.]	diamond	462	60.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
30805668	30805668	PRJNA558770_P_NODE_66174_length_256_cov_5.018100_g64169_i0	PRJNA558770	66174	256	5.0181	12.846336	Microviridae sp.	2202644	Viruses	Viruses	58.5	1.07e-7	NR	AXH76120.1	2202644	g64169	i0	52.8	0.62109375	53	24	60.9	1	6	161	302	354	AXH76120.1 MAG: replication initiator protein [Microviridae sp.]	diamond	159	58.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31152739	31152739	PRJNA558770_P_NODE_204895_length_234_cov_3.597990_g202890_i0	PRJNA558770	204895	234	3.59799	8.4192966	Microviridae sp.	2202644	Viruses	Viruses	50.8	1.54e-5	NR	XOF02485.1	2202644	g202890	i0	91.7	0.628205128205128	24	2	30.8	0	161	232	60	83	XOF02485.1 MAG: hypothetical protein [Microviridae sp.]	diamond	147	50.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31564566	31564566	PRJNA558770_P_NODE_377456_length_226_cov_10.361257_g375451_i0	PRJNA558770	377456	226	10.361257	23.41644082	Microviridae sp.	2202644	Viruses	Viruses	43.5	0.00574	NR	QRQ90067.1	2202644	g375451	i0	72	0.331858407079646	25	7	33.2	0	76	2	1	25	QRQ90067.1 MAG: major capsid protein, partial [Microviridae sp.]	diamond	75	43.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31659004	31659004	PRJNA558770_P_NODE_285477_length_234_cov_1.648241_g283472_i0	PRJNA558770	285477	234	1.648241	3.85688394	Microvirus sp.	2202559	Viruses	Viruses	46.2	0.00194	NR	WNK14659.1	2202559	g283472	i0	87.5	2.83333333333333	24	3	30.8	0	2	73	192	215	WNK14659.1 MAG: major capsid protein [Microvirus sp.]	diamond	663	46.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus sp.
31799570	31799570	PRJNA558770_P_NODE_222997_length_234_cov_3.005025_g220992_i0	PRJNA558770	222997	234	3.005025	7.0317585	Viruses	10239	Viruses	Viruses	59.3	8.35e-9	NR	AXH76779.1	2202644	g220992	i0	47.4	1.92307692307692	76	15	97.4	1	7	234	90	140	AXH76779.1 MAG: internal scaffolding protein [Microviridae sp.]	diamond	450	59.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
31912255	31912255	PRJNA558770_P_NODE_381297_length_212_cov_3.525424_g379292_i0	PRJNA558770	381297	212	3.525424	7.47389888	bajarodmic virus 77	3343703	Viruses	Viruses	53.9	7.5e-7	NR	XHH69933.1	3344143	g379292	i0	56.5	1.31603773584906	46	20	65.1	0	212	75	86	131	XHH69933.1 internal scaffolding protein [bajarodmic virus 770]	diamond	279	53.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus	bajarodmic virus 770
32070405	32070405	PRJNA558770_P_NODE_205618_length_234_cov_3.572864_g203613_i0	PRJNA558770	205618	234	3.572864	8.36050176	Apis mellifera associated microvirus 49	2494779	Viruses	Viruses	76.3	4.95e-14	NR	AZL82871.1	2494779	g203613	i0	50	0.974358974358974	76	15	97.4	1	6	233	15	67	AZL82871.1 major capsid protein [Apis mellifera associated microvirus 49]	diamond	228	76.3	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Apis mellifera associated microvirus 49

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