metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA493244" 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
19581309	19581309	PRJNA493244_P_NODE_134116_length_1383_cov_27.645234_g125387_i0	PRJNA493244	134116	1383	27.645234	382.33358622	Botourmiaviridae sp.	2808997	Viruses	Viruses	432	4.31e-143	NR	UJQ91996.1	2808997	g125387	i0	54	0.991323210412148	457	154	88.3	10	1221	1	2	452	UJQ91996.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.]	diamond	1371	432	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
26791758	26791758	PRJNA493244_P_NODE_91001_length_1579_cov_6.777997_g84529_i0	PRJNA493244	91001	1579	6.777997	107.02457263	Erysiphe necator associated totivirus 6	2737096	Viruses	Viruses	355	7.319999999999998e-110	NR	QJW70335.1	2737096	g84529	i0	50.1	1.38695376820773	365	179	68.8	1	1086	1	1	365	QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6]	diamond	2190	355	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Erysiphe necator associated totivirus 6
27377210	27377210	PRJNA493244_P_NODE_345543_length_910_cov_1.992933_g328708_i0	PRJNA493244	345543	910	1.992933	18.1356903	Viruses	10239	Viruses	Viruses	108	4.4e-22	NR	WAK73589.1	2976296	g328708	i0	32.6	1.11098901098901	218	132	70.5	6	822	181	559	765	WAK73589.1 RNA-dependent RNA polymerase [Phytophthora palustris narna-like virus 4]	diamond	1011	109	0.990825688073395	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Phytophthora palustris narna-like virus 4
28087074	28087074	PRJNA493244_P_NODE_855365_length_476_cov_7.419277_g832510_i0	PRJNA493244	855365	476	7.419277	35.31575852	Sanya botourmia-like virus 15	2970187	Viruses	Viruses	151	2.3099999999999998e-39	NR	UUW21046.1	2970187	g832510	i0	53.3	0.863445378151261	137	63	85.7	1	442	35	423	559	UUW21046.1 MAG: putative RNA-dependent RNA polymerase [Sanya botourmia-like virus 15]	diamond	411	151	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Sanya botourmia-like virus 15
28276489	28276489	PRJNA493244_P_NODE_367266_length_879_cov_10.913203_g349853_i0	PRJNA493244	367266	879	10.913203	95.92705437	Tomato associated alphaendornavirus 1	2950884	Viruses	Viruses	522	3.329999999999999e-166	NR	UTQ50503.1	2950884	g349853	i0	89.8	0.969283276450512	284	29	96.9	0	853	2	2599	2882	UTQ50503.1 MAG: polyprotein (domains: helicase - caspase/glycosyltransferase - RNA-dependent RNA polymerase) [Tomato associated alphaendornavirus 1]	diamond	852	522	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Tomato associated alphaendornavirus 1
28466208	28466208	PRJNA493244_P_NODE_1474166_length_249_cov_1.585106_g1451041_i0	PRJNA493244	1474166	249	1.585106	3.94691394	Botourmiaviridae sp.	2808997	Viruses	Viruses	127	3.869999999999999e-32	NR	UJQ91947.1	2808997	g1451041	i0	73.2	0.987951807228916	82	22	98.8	0	2	247	160	241	UJQ91947.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	246	127	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
28829205	28829205	PRJNA493244_P_NODE_1513608_length_240_cov_1.072626_g1490483_i0	PRJNA493244	1513608	240	1.072626	2.5743024	Totivirus	11007	Viruses	Viruses	73.2	7.01e-13	NR	QJW70335.1	2737096	g1490483	i0	43	1.975	79	45	98.8	0	240	4	690	768	QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6]	diamond	474	73.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Erysiphe necator associated totivirus 6
28971293	28971293	PRJNA493244_P_NODE_894088_length_456_cov_17.840506_g871136_i0	PRJNA493244	894088	456	17.840506	81.35270736	ssRNA phage SRR696	2845865	Viruses	Viruses	162	5.1499999999999993e-48	NR	YP_010769763.1	2786514	g871136	i0	57.8	2.48026315789474	128	54	84.2	0	64	447	1	128	YP_010769763.1 coat protein [ssRNA phage SRR6960507_4]	diamond	1131	162	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Pohlevirus	Pohlevirus caenicola
29476099	29476099	PRJNA493244_P_NODE_1094110_length_367_cov_15.343137_g1070989_i0	PRJNA493244	1094110	367	15.343137	56.30931279	Penicillium discovirus	2185132	Viruses	Viruses	44.7	0.0254	NR	YP_010840287.1	2185132	g1070989	i0	51.2	0.35149863760218	43	21	35.1	0	5	133	223	265	YP_010840287.1 Nucleocapsid [Penicillium discovirus]	diamond	129	44.7	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Discoviridae	Orthodiscovirus	Orthodiscovirus missouriense
29871317	29871317	PRJNA493244_P_NODE_1173131_length_338_cov_2.541516_g1150007_i0	PRJNA493244	1173131	338	2.541516	8.59032408	Viruses	10239	Viruses	Viruses	72.4	4.38e-12	NR	WAK77450.1	1955172	g1150007	i0	45.5	1.61538461538462	77	42	68.3	0	231	1	255	331	WAK77450.1 MAG: capsid protein [Totiviridae sp.]	diamond	546	72.4	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
29918632	29918632	PRJNA493244_P_NODE_1222211_length_321_cov_2.961538_g1199087_i0	PRJNA493244	1222211	321	2.961538	9.50653698	Tomato associated alphaendornavirus 1	2950884	Viruses	Viruses	209	4.8899999999999997e-60	NR	UTQ50503.1	2950884	g1199087	i0	91.5	0.990654205607477	106	9	99.1	0	319	2	1817	1922	UTQ50503.1 MAG: polyprotein (domains: helicase - caspase/glycosyltransferase - RNA-dependent RNA polymerase) [Tomato associated alphaendornavirus 1]	diamond	318	209	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Tomato associated alphaendornavirus 1
30076332	30076332	PRJNA493244_P_NODE_1368052_length_277_cov_1.893519_g1344927_i0	PRJNA493244	1368052	277	1.893519	5.24504763	Leviviridae sp.	2027243	Viruses	Viruses	53.5	8.42e-6	NR	DAH09204.1	2027243	g1344927	i0	50	0.51985559566787	48	24	52	0	253	110	239	286	DAH09204.1 MAG TPA: capsid protein [Leviviridae sp.]	diamond	144	53.5	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
30424450	30424450	PRJNA493244_P_NODE_582053_length_655_cov_5.513468_g560734_i0	PRJNA493244	582053	655	5.513468	36.1132154	Skokie dicistro-like virus	2789443	Viruses	Viruses	201	1.8899999999999996e-55	NR	QPG92978.1	2789443	g560734	i0	74.8	0.581679389312977	127	32	58.2	0	24	404	730	856	QPG92978.1 polyprotein 1 [Skokie dicistro-like virus]	diamond	381	201	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
31340413	31340413	PRJNA493244_P_NODE_1579216_length_225_cov_1.493902_g1556091_i0	PRJNA493244	1579216	225	1.493902	3.3612795	Botourmiaviridae sp.	2808997	Viruses	Viruses	99.8	2.6e-22	NR	UJQ91947.1	2808997	g1556091	i0	69.7	0.88	66	19	88	1	25	222	65	129	UJQ91947.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	198	99.8	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
31530372	31530372	PRJNA493244_P_NODE_1089116_length_369_cov_10.240260_g1065995_i0	PRJNA493244	1089116	369	10.24026	37.7865594	Magnaporthe oryzae botourmiavirus 7	2755484	Viruses	Viruses	84	5.58e-16	NR	QVU39995.1	2755484	g1065995	i0	51	1.5609756097561	96	45	76.4	1	35	316	380	475	QVU39995.1 RNA-dependent RNA polymerase [Magnaporthe oryzae botourmiavirus 7]	diamond	576	84	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Epsilonscleroulivirus	Epsilonscleroulivirus alphaoryzae
31751480	31751480	PRJNA493244_P_NODE_1523637_length_237_cov_2.903409_g1500512_i0	PRJNA493244	1523637	237	2.903409	6.88107933	Diplodia seriata botourmiavirus 1	2932871	Viruses	Viruses	43.9	0.0133	NR	UOK20173.1	2932871	g1500512	i0	41.5	0.670886075949367	53	31	67.1	0	208	50	503	555	UOK20173.1 RNA dependent RNA polymerase [Diplodia seriata botourmiavirus 1]	diamond	159	43.9	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Diplodia seriata botourmiavirus 1
32020700	32020700	PRJNA493244_P_NODE_1741818_length_190_cov_10.395349_g1718693_i0	PRJNA493244	1741818	190	10.395349	19.7511631	Alphachrysovirus	2560087	Viruses	Viruses	75.9	3.92e-14	NR	UFJ44705.1	158372	g1718693	i0	68.6	3.14210526315789	51	16	80.5	0	38	190	441	491	UFJ44705.1 RNA-dependent RNA polymerase [Penicillium chrysogenum virus]	diamond	597	76.6	0.990861618798956	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus penicillii

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