metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax_superkingdom = "Viruses"

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
12497932	12497932	PRJNA1093008_S_NODE_70_length_2444_cov_31.236187_g19_i0	PRJNA1093008	70	2444	31.236187	763.41241028	Moloney murine leukemia virus	11801	Viruses	Viruses	1295	0	NR	NP_057933.2	11801	g19	i0	97.6	2.42675941080196	659	16	80.9	0	142	2118	677	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5931	1295	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
20600020	20600020	PRJNA1093008_S_NODE_93537_length_242_cov_2.733728_g93210_i0	PRJNA1093008	93537	242	2.733728	6.61562176	Partitiviridae sp.	1955170	Viruses	Viruses	127	1.94e-33	NR	QDH91349.1	1955170	g93210	i0	82.2	5.4297520661157	73	13	90.5	0	221	3	163	235	QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.]	diamond	1314	127	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
26687703	26687703	PRJNA1093008_S_NODE_59201_length_279_cov_2.305825_g58874_i0	PRJNA1093008	59201	279	2.305825	6.43325175	Caudoviricetes sp.	2832643	Viruses	Viruses	179	6.3e-55	NR	DAR47499.1	2832643	g58874	i0	91.4	1	93	8	100	0	1	279	89	181	DAR47499.1 MAG TPA: Morphogenesis protein 1 wall, phi29, hydrolase, infection [Caudoviricetes sp.]	diamond	279	179	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27510086	27510086	PRJNA1093008_S_NODE_45063_length_303_cov_1.339130_g44736_i0	PRJNA1093008	45063	303	1.33913	4.0575639	Lepidopteran phasma-related virus OKIAV246	2746306	Viruses	Viruses	97.8	3.53e-21	NR	QMP82218.1	2746306	g44736	i0	44	0.99009900990099	100	56	99	0	2	301	1155	1254	QMP82218.1 RNA-dependent RNA polymerase, partial [Lepidopteran phasma-related virus OKIAV246]	diamond	300	97.8	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Phasmaviridae		Lepidopteran phasma-related virus OKIAV246
27510087	27510087	PRJNA1093008_S_NODE_47483_length_298_cov_3.071111_g47156_i0	PRJNA1093008	47483	298	3.071111	9.15191078	Lepidopteran phasma-related virus OKIAV246	2746306	Viruses	Viruses	114	5.3e-27	NR	QMP82218.1	2746306	g47156	i0	61.6	0.996644295302013	99	38	99.7	0	2	298	176	274	QMP82218.1 RNA-dependent RNA polymerase, partial [Lepidopteran phasma-related virus OKIAV246]	diamond	297	114	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Phasmaviridae		Lepidopteran phasma-related virus OKIAV246
27564244	27564244	PRJNA1093008_S_NODE_89344_length_245_cov_2.563953_g89017_i0	PRJNA1093008	89344	245	2.563953	6.28168485	root	1	Root_unresolved	Root_unresolved	75.9	7.82e-14	NR	UVX92683.1	38018	g89017	i0	74.4	1.53061224489796	43	11	52.7	0	224	96	428	470	UVX92683.1 MAG: protein of unknown function DUF2828 [Bacteriophage sp.]	diamond	375	76.3	0.99475753604194	Viruses							Bacteriophage sp.
27636411	27636411	PRJNA1093008_S_NODE_93744_length_242_cov_1.822485_g93417_i0	PRJNA1093008	93744	242	1.822485	4.4104137	Erythrocytic necrosis virus	1543320	Viruses	Viruses	76.6	9.79e-16	NR	QCF47480.1	1543320	g93417	i0	65.4	0.644628099173554	52	18	64.5	0	23	178	64	115	QCF47480.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	156	76.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
27825810	27825810	PRJNA1093008_S_NODE_34324_length_326_cov_2.407115_g33997_i0	PRJNA1093008	34324	326	2.407115	7.8471949	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	104	2.4799999999999994e-23	NR	AVM87439.1	3063761	g33997	i0	54.5	0.809815950920245	88	40	81	0	264	1	928	1015	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	264	104	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
27880231	27880231	PRJNA1093008_S_NODE_7665_length_478_cov_3.140741_g7340_i0	PRJNA1093008	7665	478	3.140741	15.01274198	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	114	7.23e-26	NR	YP_009104360.1	3063761	g7340	i0	48.4	3.55230125523013	128	63	78.5	3	70	444	765	892	YP_009104360.1 polyprotein [Crohivirus A]	diamond	1698	115	0.991304347826087	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Crohivirus	Danio blood picornavirus/Zebrafish picornavirus 2
28046694	28046694	PRJNA1093008_S_NODE_88065_length_246_cov_1.780347_g87738_i0	PRJNA1093008	88065	246	1.780347	4.37965362	Marsupial endogenous gammaretrovirus 2	3386030	Viruses	Viruses	49.3	1.98e-4	NR	DBA62711.1	3386030	g87738	i0	50	1.41463414634146	52	26	63.4	0	246	91	491	542	DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2]	diamond	348	49.3	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Marsupial endogenous gammaretrovirus 2
28204414	28204414	PRJNA1093008_S_NODE_85666_length_248_cov_1.320000_g85339_i0	PRJNA1093008	85666	248	1.32	3.2736	Erythrocytic necrosis virus	1543320	Viruses	Viruses	73.6	1.15e-14	NR	QCF47486.1	1543320	g85339	i0	67.3	0.665322580645161	55	8	54.4	1	247	113	35	89	QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus]	diamond	165	73.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
28804258	28804258	PRJNA1093008_S_NODE_31088_length_335_cov_1.175573_g30761_i0	PRJNA1093008	31088	335	1.175573	3.93816955	Erythrocytic necrosis virus	1543320	Viruses	Viruses	67	1.19e-11	NR	QCF47486.1	1543320	g30761	i0	69.6	0.411940298507463	46	13	40.3	1	229	95	5	50	QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus]	diamond	138	67	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
29878177	29878177	PRJNA1093008_S_NODE_75351_length_258_cov_1.248649_g75024_i0	PRJNA1093008	75351	258	1.248649	3.22151442	Betapartitivirus sp.	1955169	Viruses	Viruses	111	2.46e-26	NR	UDL14392.1	1955169	g75024	i0	64.7	0.988372093023256	85	30	98.8	0	2	256	55	139	UDL14392.1 MAG: putative RNA-dependent RNA polymerase, partial [Betapartitivirus sp.]	diamond	255	111	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Betapartitivirus	Betapartitivirus sp.
32502321	32502321	PRJNA1093008_S_NODE_90239_length_245_cov_0.895349_g89912_i0	PRJNA1093008	90239	245	0.895349	2.19360505	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	107	5.01e-25	NR	AVM87439.1	3063761	g89912	i0	60.5	0.991836734693878	81	32	99.2	0	1	243	247	327	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	243	107	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
32533905	32533905	PRJNA1093008_S_NODE_46319_length_300_cov_3.198238_g45992_i0	PRJNA1093008	46319	300	3.198238	9.594714	Erythrocytic necrosis virus	1543320	Viruses	Viruses	51.2	1.11e-5	NR	QCF47486.1	1543320	g45992	i0	84.6	0.26	26	4	26	0	215	138	1	26	QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus]	diamond	78	51.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
32722847	32722847	PRJNA1093008_S_NODE_37280_length_319_cov_2.414634_g36953_i0	PRJNA1093008	37280	319	2.414634	7.70268246	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	79.7	1.01e-14	NR	AVM87439.1	3063761	g36953	i0	44.4	0.931034482758621	99	47	88.4	3	38	319	1440	1535	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	297	79.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2

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