metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA315399" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA315399" and tax_kingdom = "Orthornavirae"

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
4212349	4212349	PRJNA315399_S_NODE_28624_length_251_cov_7.182243_g28423_i0	PRJNA315399	28624	251	7.182243	18.02742993	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	97.1	3.32e-21	NR	QPG92982.1	2789378	g28423	i0	54.9	1.9601593625498	82	37	98	0	4	249	819	900	QPG92982.1 polyprotein [Shenzhen dicistro-like virus]	diamond	492	97.1	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
27264212	27264212	PRJNA315399_S_NODE_19043_length_284_cov_5.433198_g18842_i0	PRJNA315399	19043	284	5.433198	15.43028232	Botourmiaviridae sp.	2808997	Viruses	Viruses	54.7	3.83e-6	NR	WAK77858.1	2808997	g18842	i0	42.9	0.961267605633803	91	51	95.1	1	2	271	608	698	WAK77858.1 MAG: RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.]	diamond	273	54.7	1	Viruses		Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
28779582	28779582	PRJNA315399_P_NODE_288267_length_179_cov_4.950704_g287819_i0	PRJNA315399	288267	179	4.950704	8.86176016	brine shrimp rhabdovirus 1	2900475	Viruses	Viruses	65.9	1.11e-10	NR	UNI73977.1	2900475	g287819	i0	50	0.972067039106145	58	29	97.2	0	175	2	70	127	UNI73977.1 MAG: RNA-dependent RNA polymerase [brine shrimp rhabdovirus 1]	diamond	174	65.9	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		brine shrimp rhabdovirus 1
29348203	29348203	PRJNA315399_S_NODE_169569_length_156_cov_2.403361_g169368_i0	PRJNA315399	169569	156	2.403361	3.74924316	Wuhan aphid virus 2	1746068	Viruses	Viruses	110	6.410000000000001e-27	NR	YP_009179385.1	1746068	g169368	i0	94.1	0.980769230769231	51	3	98.1	0	155	3	135	185	YP_009179385.1 putative glycoprotein [Wuhan aphid virus 2]	diamond	153	110	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Wuhan aphid virus 2
29853333	29853333	PRJNA315399_P_NODE_341871_length_171_cov_26.343284_g341423_i0	PRJNA315399	341871	171	26.343284	45.04701564	brine shrimp rhabdovirus 1	2900475	Viruses	Viruses	59.7	1.43e-8	NR	UNI73976.1	2900475	g341423	i0	51.1	0.824561403508772	47	23	82.5	0	163	23	374	420	UNI73976.1 MAG: glycoprotein [brine shrimp rhabdovirus 1]	diamond	141	59.7	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		brine shrimp rhabdovirus 1
30769674	30769674	PRJNA315399_S_NODE_28414_length_252_cov_3.232558_g28213_i0	PRJNA315399	28414	252	3.232558	8.14604616	Plasmopara viticola lesion associated ourmia-like virus 45	2686515	Viruses	Viruses	66.6	1.64e-10	NR	YP_010800240.1	2686515	g28213	i0	51.5	0.80952380952381	68	32	79.8	1	13	213	449	516	YP_010800240.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 45]	diamond	204	66.6	1	Viruses		Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Epsilonscleroulivirus	Epsilonscleroulivirus plasmoparae
31211411	31211411	PRJNA315399_S_NODE_10355_length_345_cov_8.457792_g10154_i0	PRJNA315399	10355	345	8.457792	29.1793824	Malassezia restricta virus MrV4	76775	Viruses	Viruses	197	7.379999999999998e-56	NR	QJA42332.1	2727863	g10154	i0	83	1.94782608695652	112	19	97.4	0	8	343	792	903	QJA42332.1 polyprotein [Malassezia restricta virus MrV40L]	diamond	672	197	1	Viruses		Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
32192597	32192597	PRJNA315399_S_NODE_12758_length_322_cov_10.378947_g12557_i0	PRJNA315399	12758	322	10.378947	33.42020934	Panax cryptic virus 4	2809267	Viruses	Viruses	75.5	3.33e-15	NR	WAQ73893.1	2809267	g12557	i0	84.1	0.819875776397516	44	7	41	0	2	133	53	96	WAQ73893.1 coat protein, partial [Panax cryptic virus 4]	diamond	264	75.5	1	Viruses		Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Panax cryptic virus 4
32224246	32224246	PRJNA315399_S_NODE_10098_length_348_cov_4.990354_g9897_i0	PRJNA315399	10098	348	4.990354	17.36643192	Wuhan aphid virus 2	1746068	Viruses	Viruses	182	3.9899999999999986e-55	NR	QDF44112.1	1746068	g9897	i0	94.4	0.775862068965517	90	5	77.6	0	6	275	174	263	QDF44112.1 putative capsid protein [Wuhan aphid virus 2]	diamond	270	182	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Wuhan aphid virus 2
32287803	32287803	PRJNA315399_S_NODE_17819_length_290_cov_8.387352_g17618_i0	PRJNA315399	17819	290	8.387352	24.3233208	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	127	1.22e-31	NR	QPG92982.1	2789378	g17618	i0	63.5	0.993103448275862	96	35	99.3	0	289	2	1114	1209	QPG92982.1 polyprotein [Shenzhen dicistro-like virus]	diamond	288	127	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
32319422	32319422	PRJNA315399_S_NODE_24159_length_264_cov_8.656388_g23958_i0	PRJNA315399	24159	264	8.656388	22.85286432	Geotrichum candidum totivirus 3b	2971329	Viruses	Viruses	160	2.0599999999999996e-43	NR	UUT40381.1	2971329	g23958	i0	97.5	0.920454545454545	81	2	92	0	22	264	46	126	UUT40381.1 RNA-dependent RNA polymerase [Geotrichum candidum totivirus 3b]	diamond	243	160	1	Viruses		Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Geotrichum candidum totivirus 3b
32540830	32540830	PRJNA315399_S_NODE_18579_length_286_cov_10.686747_g18378_i0	PRJNA315399	18579	286	10.686747	30.56409642	Medicago sativa marafivirus 1	2043552	Viruses	Viruses	82.4	7.41e-16	NR	ATJ00054.1	2043552	g18378	i0	61.9	0.660839160839161	63	24	66.1	0	25	213	2048	2110	ATJ00054.1 polyprotein [Medicago sativa marafivirus 1]	diamond	189	82.4	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Marafivirus	Medicago sativa marafivirus 1

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