metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax_kingdom = "Pararnavirae"

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
1041869	1041869	PRJNA1182301_P_NODE_661_length_922_cov_4.368669_g556_i0	PRJNA1182301	661	922	4.368669	40.27912818	root	1	Root_unresolved	Root_unresolved	1661	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g556	i0	99.241	99.8926247288503	922	4	100	1	1	922	1976	2894	Moloney murine leukemia virus, complete genome	blastn	92101	1661	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
9969402	9969402	PRJNA1182301_P_NODE_11188_length_334_cov_5.057471_g11063_i0	PRJNA1182301	11188	334	5.057471	16.89195314	root	1	Root_unresolved	Root_unresolved	617	2.48e-172	NTclustered	gi\|332027\|gb\|M33469.1\|MLVENVC	11786	g11063	i0	100	9.94011976047904	334	0	100	0	1	334	1015	1348	4070A Amphotropic Murine leukemia virus envelope gene, complete cds	blastn	3320	617	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
13795276	13795276	PRJNA1182301_P_NODE_811_length_837_cov_3.217277_g700_i0	PRJNA1182301	811	837	3.217277	26.92860849	Gammaretrovirus	153135	Viruses	Viruses	1546	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g700	i0	100	89.3799283154122	837	0	100	0	1	837	5480	4644	Moloney murine leukemia virus, complete genome	blastn	74811	1546	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
16343975	16343975	PRJNA1182301_P_NODE_2393_length_549_cov_1.699580_g2269_i0	PRJNA1182301	2393	549	1.69958	9.3306942	root	1	Root_unresolved	Root_unresolved	1003	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g2269	i0	99.636	99.9744990892532	549	2	100	0	1	549	1990	1442	Moloney murine leukemia virus, complete genome	blastn	54886	1003	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
18893094	18893094	PRJNA1182301_P_NODE_3875_length_466_cov_2.486005_g3750_i0	PRJNA1182301	3875	466	2.486005	11.5847833	Gammaretrovirus	153135	Viruses	Viruses	523	7.979999999999998e-144	NTclustered	gi\|332010\|gb\|K02729.1\|MLV4070A	11786	g3750	i0	98.013	91.7982832618026	302	4	65	2	1	301	669	969	Mouse leukemia virus (amphotropic) 4070A LTR	blastn	42778	523	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
20167750	20167750	PRJNA1182301_P_NODE_2176_length_568_cov_8.426263_g2052_i0	PRJNA1182301	2176	568	8.426263	47.86117384	root	1	Root_unresolved	Root_unresolved	1050	0	NTclustered	gi\|1173658\|gb\|U36602.1\|MLU36602	11786	g2052	i0	100	7.67429577464789	568	0	100	0	1	568	836	1403	Murine leukemia virus gPr80 envelope polyprotein precursor (env) mRNA, complete cds	blastn	4359	1050	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
20167769	20167769	PRJNA1182301_P_NODE_2416_length_547_cov_2.719409_g2292_i0	PRJNA1182301	2416	547	2.719409	14.87516723	Gammaretrovirus	153135	Viruses	Viruses	1005	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g2292	i0	99.817	100.042047531993	547	1	100	0	1	547	3605	4151	Moloney murine leukemia virus, complete genome	blastn	54723	1005	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
21443844	21443844	PRJNA1182301_P_NODE_7697_length_376_cov_2.815182_g7572_i0	PRJNA1182301	7697	376	2.815182	10.58508432	Gammaretrovirus	153135	Viruses	Viruses	693	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g7572	i0	100	99.6196808510638	375	0	99	0	2	376	4191	4565	Moloney murine leukemia virus, complete genome	blastn	37457	693	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
23993897	23993897	PRJNA1182301_P_NODE_54999_length_247_cov_0.885057_g54874_i0	PRJNA1182301	54999	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	363	9.079999999999999e-96	NTclustered	gi\|1045515\|gb\|U36800.1\|MLU36800	11786	g54874	i0	93.117	10.1943319838057	247	17	100	0	1	247	1755	2001	Murine leukemia virus Mo Ampho Delta recombinant envelope polyprotein (env) mRNA, complete cds	blastn	2518	363	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);;