metadata: contig_metadata: 10 rows where bioproject = "PRJNA816047", tax_kingdom = "Pararnavirae" and tax

10 rows where bioproject = "PRJNA816047", tax_kingdom = "Pararnavirae" 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
25769521	25769521	PRJNA816047a_S_NODE_68722_length_256_cov_2.939891_g66062_i0	PRJNA816047	68722	256	2.939891	7.52612096	Gammaretrovirus	153135	Viruses	Viruses	412	9.27e-111	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g66062	i0	98.298	90.6640625	235	4	92	0	1	235	4391	4157	Moloney murine leukemia virus, complete genome	blastn	23210	412	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26042690	26042690	PRJNA816047b_S_NODE_35988_length_282_cov_2.421053_g33676_i0	PRJNA816047	35988	282	2.421053	6.82736946	Gammaretrovirus	153135	Viruses	Viruses	363	1.0599999999999999e-95	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g33676	i0	97.63	17.4326241134752	211	5	75	0	50	260	4612	4402	Moloney murine leukemia virus, complete genome	blastn	4916	363	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26177262	26177262	PRJNA816047a_S_NODE_28885_length_382_cov_6.411003_g26225_i0	PRJNA816047	28885	382	6.411003	24.49003146	root	1	Root_unresolved	Root_unresolved	459	1.84e-124	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g26225	i0	96.085	73.5602094240838	281	11	74	0	100	380	2596	2876	Moloney murine leukemia virus, complete genome	blastn	28100	459	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26177331	26177331	PRJNA816047a_S_NODE_33109_length_359_cov_5.702797_g30449_i0	PRJNA816047	33109	359	5.702797	20.47304123	Gammaretrovirus	153135	Viruses	Viruses	361	4.98e-95	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g30449	i0	97.183	33.6629526462396	213	6	59	0	133	345	4612	4400	Moloney murine leukemia virus, complete genome	blastn	12085	361	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26179250	26179250	PRJNA816047b_S_NODE_5549_length_616_cov_7.095764_g3344_i0	PRJNA816047	5549	616	7.095764	43.70990624	Gammaretrovirus	153135	Viruses	Viruses	1051	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g3344	i0	98.333	94.4172077922078	600	9	97	1	13	611	4439	3840	Moloney murine leukemia virus, complete genome	blastn	58161	1051	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26180215	26180215	PRJNA816047d_S_NODE_34413_length_364_cov_9037.025723_g32579_i0	PRJNA816047	34413	364	9037.025723	32894.77363172	root	1	Root_unresolved	Root_unresolved	239	2.47e-58	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g32579	i0	99.242	36.2664835164835	132	1	36	0	97	228	2596	2727	Moloney murine leukemia virus, complete genome	blastn	13201	239	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26180513	26180513	PRJNA816047d_S_NODE_5453_length_1708_cov_3648.715408_g3702_i1	PRJNA816047	5453	1708	3648.715408	62320.05916864	Gammaretrovirus	153135	Viruses	Viruses	2289	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g3702	i1	97.743	77.8103044496487	1329	30	78	0	284	1612	3924	2596	Moloney murine leukemia virus, complete genome	blastn	132900	2289	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26312689	26312689	PRJNA816047a_S_NODE_11190_length_603_cov_107.279245_g8623_i0	PRJNA816047	11190	603	107.279245	646.89384735	Gammaretrovirus	153135	Viruses	Viruses	926	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g8623	i0	98.662	86.7313432835821	523	6	87	1	4	525	3841	3319	Moloney murine leukemia virus, complete genome	blastn	52299	926	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26449450	26449450	PRJNA816047a_S_NODE_41855_length_322_cov_3.991968_g39195_i0	PRJNA816047	41855	322	3.991968	12.85413696	Gammaretrovirus	153135	Viruses	Viruses	536	6.839999999999997e-148	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g39195	i0	98.366	79.8167701863354	306	4	95	1	1	306	4185	3881	Moloney murine leukemia virus, complete genome	blastn	25701	536	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26450467	26450467	PRJNA816047b_S_NODE_2215_length_1442_cov_9.344777_g390_i0	PRJNA816047	2215	1442	9.344777	134.75168434	Gammaretrovirus	153135	Viruses	Viruses	2211	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g390	i0	97.597	89.4590846047157	1290	31	89	0	79	1368	2596	3885	Moloney murine leukemia virus, complete genome	blastn	129000	2211	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu

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