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

19 rows where analysis = "diamond", bioproject = "PRJNA473641" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
445045	445045	PRJNA473641_P_NODE_1_length_4592_cov_5.316220_g0_i0	PRJNA473641	1	4592	5.31622	244.1208224	Beijing Picor tick virus 1	2972306	Viruses	Viruses	1345	0	NR	UYL95406.1	2972306	g0	i0	46.9	1.90831881533101	1475	714	94.5	12	9	4346	949	2383	UYL95406.1 MAG: polyprotein [Beijing Picor tick virus 1]	diamond	8763	1345	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Beijing Picor tick virus 1
17022163	17022163	PRJNA473641_P_NODE_11994_length_295_cov_2.000000_g11911_i0	PRJNA473641	11994	295	2	5.9	Jingmen shrew picorna-like virus 2	3083445	Viruses	Viruses	104	1.6000000000000002e-23	NR	WPV63425.1	3083445	g11911	i0	50.5	1.9728813559322	97	48	98.6	0	293	3	2593	2689	WPV63425.1 MAG: polyprotein, partial [Jingmen shrew picorna-like virus 2]	diamond	582	104	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Jingmen shrew picorna-like virus 2
17022278	17022278	PRJNA473641_P_NODE_1654_length_636_cov_2.467140_g1572_i0	PRJNA473641	1654	636	2.46714	15.6910104	Dicistroviridae sp.	1955144	Viruses	Viruses	201	5.829999999999999e-56	NR	QXV86542.1	1955144	g1572	i0	60.4	0.797169811320755	169	66	79.2	1	635	132	677	845	QXV86542.1 capsid protein [Dicistroviridae sp.]	diamond	507	201	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
26965760	26965760	PRJNA473641_P_NODE_15802_length_261_cov_1.228723_g15719_i0	PRJNA473641	15802	261	1.228723	3.20696703	Viruses	10239	Viruses	Viruses	120	1.8599999999999997e-30	NR	UGO57503.1	1955153	g15719	i0	77	2	87	20	100	0	1	261	280	366	UGO57503.1 MAG: hypothetical protein, partial [Picornavirales sp.]	diamond	522	120	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales sp.
27202410	27202410	PRJNA473641_P_NODE_4782_length_413_cov_1.970588_g4699_i0	PRJNA473641	4782	413	1.970588	8.13852844	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	170	6.82e-46	NR	XCO49439.1	3003959	g4699	i0	64.4	2.94188861985472	135	44	95.2	1	19	411	86	220	XCO49439.1 MAG: putative ORF1 protein, partial [Picornavirales sp.]	diamond	1215	170	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27329183	27329183	PRJNA473641_P_NODE_14523_length_272_cov_1.381910_g14440_i0	PRJNA473641	14523	272	1.38191	3.7587952	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	137	3.99e-35	NR	XCO49414.1	3003959	g14440	i0	67.8	2.97794117647059	90	29	99.3	0	272	3	36	125	XCO49414.1 MAG: putative ORF1 protein, partial [Picornavirales sp.]	diamond	810	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27392405	27392405	PRJNA473641_P_NODE_21843_length_246_cov_0.890173_g21760_i0	PRJNA473641	21843	246	0.890173	2.18982558	Picornaviridae sp.	1530251	Viruses	Viruses	67.8	5.92e-11	NR	UCS96339.1	1530251	g21760	i0	50	0.75609756097561	62	31	75.6	0	56	241	423	484	UCS96339.1 MAG: hypothetical protein, partial [Picornaviridae sp.]	diamond	186	67.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
27613427	27613427	PRJNA473641_P_NODE_2104_length_578_cov_2.398020_g2022_i0	PRJNA473641	2104	578	2.39802	13.8605556	Beijing Picor tick virus 1	2972306	Viruses	Viruses	104	5.0600000000000005e-22	NR	UYL95406.1	2972306	g2022	i0	29.6	1.05363321799308	203	124	97.6	2	573	10	746	944	UYL95406.1 MAG: polyprotein [Beijing Picor tick virus 1]	diamond	609	104	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Beijing Picor tick virus 1
27676678	27676678	PRJNA473641_P_NODE_1924_length_600_cov_1.028463_g1842_i0	PRJNA473641	1924	600	1.028463	6.170778	Qianjiang picorna-like virus 13	3348725	Viruses	Viruses	259	4.9799999999999997e-76	NR	XHA88461.1	3348725	g1842	i0	64	1.015	203	69	99.5	2	2	598	2631	2833	XHA88461.1 MAG: polyprotein [Qianjiang picorna-like virus 13]	diamond	609	259	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 13
27834193	27834193	PRJNA473641_P_NODE_26304_length_228_cov_2.432258_g26221_i0	PRJNA473641	26304	228	2.432258	5.54554824	Maanshan Dicis tick virus 1	2972097	Viruses	Viruses	111	1.73e-26	NR	UYL95314.1	2972097	g26221	i0	70.7	1.90789473684211	75	22	98.7	0	226	2	626	700	UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1]	diamond	435	111	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Maanshan Dicis tick virus 1
27976718	27976718	PRJNA473641_P_NODE_4785_length_413_cov_1.673529_g4702_i0	PRJNA473641	4785	413	1.673529	6.91167477	Cripavirus	144051	Viruses	Viruses	192	7.839999999999998e-54	NR	NP_647481.1	12136	g4702	i0	68.4	1.97578692493947	136	42	98.8	1	410	3	630	764	NP_647481.1 nonstructural polyprotein [Cricket paralysis virus]	diamond	816	192	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus grylli
28055182	28055182	PRJNA473641_P_NODE_23865_length_243_cov_0.905882_g23782_i0	PRJNA473641	23865	243	0.905882	2.20129326	Guiyang Tospo-like virus 1	2905599	Viruses	Viruses	70.1	8.71e-12	NR	UHK03059.1	2905599	g23782	i0	70.2	0.580246913580247	47	14	58	0	2	142	1030	1076	UHK03059.1 MAG: RNA-dependent RNA polymerase [Guiyang Tospo-like virus 1]	diamond	141	70.1	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Tospoviridae		Guiyang Tospo-like virus 1
29286584	29286584	PRJNA473641_P_NODE_4789_length_413_cov_1.405882_g4706_i0	PRJNA473641	4789	413	1.405882	5.80629266	Qianjiang picorna-like virus 13	3348725	Viruses	Viruses	186	2.12e-51	NR	XHA88461.1	3348725	g4706	i0	72.3	0.813559322033898	112	31	81.4	0	3	338	2828	2939	XHA88461.1 MAG: polyprotein [Qianjiang picorna-like virus 13]	diamond	336	186	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 13
29412865	29412865	PRJNA473641_P_NODE_1029_length_775_cov_2.145299_g959_i0	PRJNA473641	1029	775	2.145299	16.62606725	Army ant associated dicistrovirus 8	3004001	Viruses	Viruses	325	6.629999999999998e-99	NR	WAX26108.1	3004001	g959	i0	86.3	0.987096774193548	255	33	98.7	1	9	773	313	565	WAX26108.1 MAG: RNA-dependent RNA polymerase, partial [Army ant associated dicistrovirus 8]	diamond	765	325	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Army ant associated dicistrovirus 8
29791707	29791707	PRJNA473641_P_NODE_9831_length_318_cov_0.906122_g9748_i0	PRJNA473641	9831	318	0.906122	2.88146796	Qianjiang picorna-like virus 13	3348725	Viruses	Viruses	67.4	2.06e-10	NR	XHA88461.1	3348725	g9748	i0	39.8	0.830188679245283	88	51	83	1	54	317	1237	1322	XHA88461.1 MAG: polyprotein [Qianjiang picorna-like virus 13]	diamond	264	67.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Qianjiang picorna-like virus 13
30644732	30644732	PRJNA473641_P_NODE_693_length_907_cov_3.110312_g630_i0	PRJNA473641	693	907	3.110312	28.21052984	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	236	4.0999999999999986e-68	NR	XCO49664.1	3003959	g630	i0	57.6	0.671444321940463	203	73	62.8	3	902	333	566	768	XCO49664.1 MAG: putative ORF1 protein, partial [Picornavirales sp.]	diamond	609	236	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31940957	31940957	PRJNA473641_P_NODE_22297_length_245_cov_0.895349_g22214_i0	PRJNA473641	22297	245	0.895349	2.19360505	Cheeloo virga-like virus	3058128	Viruses	Viruses	74.7	2.15e-13	NR	WLW14427.1	3058128	g22214	i0	47.3	0.906122448979592	74	39	90.6	0	243	22	1284	1357	WLW14427.1 MAG: hypothetical protein 1 [Cheeloo virga-like virus]	diamond	222	74.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae		Cheeloo virga-like virus
32036038	32036038	PRJNA473641_P_NODE_6858_length_361_cov_2.670139_g6775_i0	PRJNA473641	6858	361	2.670139	9.63920179	melon severe mosaic virus	485724	Viruses	Viruses	62.8	1.42e-8	NR	YP_009346016.1	485724	g6775	i0	26.2	1.01385041551247	122	84	98.1	3	5	358	865	984	YP_009346016.1 Gn/Gc [melon severe mosaic virus]	diamond	366	62.8	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Tospoviridae	Orthotospovirus	Orthotospovirus melotessellati
32747448	32747448	PRJNA473641_P_NODE_220_length_1391_cov_1.989378_g185_i0	PRJNA473641	220	1391	1.989378	27.67224798	Orthotospovirus	2560196	Viruses	Viruses	117	9.75e-24	NR	QQY96598.1	584711	g185	i0	26.2	3.63191948238677	343	221	71.6	10	997	2	637	958	QQY96598.1 GnGc [Tomato necrotic ringspot virus]	diamond	5052	118	0.991525423728814	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Tospoviridae		Tomato necrotic ringspot virus

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