metadata: contig_metadata: 12 rows where bioproject = "PRJNA1160211" and tax

12 rows where bioproject = "PRJNA1160211" 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
1038960	1038960	PRJNA1160211_S_NODE_60681_length_545_cov_15.970339_g59496_i0	PRJNA1160211	60681	545	15.970339	87.03834755	root	1	Root_unresolved	Root_unresolved	521	3.4e-143	NTclustered	gi\|2088546\|gb\|U87552.1\|MLU87552	11786	g59496	i0	99.308	71.702752293578	289	1	53	1	236	523	682	394	Murine leukemia virus integrase (pol) gene, partial cds	blastn	39078	521	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
5413888	5413888	PRJNA1160211_S_NODE_85885_length_486_cov_1.496368_g84665_i0	PRJNA1160211	85885	486	1.496368	7.27234848	Gammaretrovirus murleu	3428959	Viruses	Viruses	717	0	NTclustered	gi\|2228757\|gb\|U94692.1\|RMU94692	11938	g84665	i0	97.831	94.0329218106996	415	9	100	0	1	415	132	546	Rauscher murine leukemia virus, complete genome	blastn	45700	717	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6141549	6141549	PRJNA1160211_S_NODE_271185_length_247_cov_1.206897_g269952_i0	PRJNA1160211	271185	247	1.206897	2.98103559	Gammaretrovirus	153135	Viruses	Viruses	451	1.88e-122	NTclustered	gi\|2225989\|emb\|Y13893.1\|	11786	g269952	i0	99.595	24.8987854251012	247	1	100	0	1	247	1193	1439	Murine leukemia virus RNA for gag-pol-env polyproteins	blastn	6150	451	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6141729	6141729	PRJNA1160211_S_NODE_46545_length_587_cov_7.396887_g45387_i0	PRJNA1160211	46545	587	7.396887	43.41972669	root	1	Root_unresolved	Root_unresolved	110	3.39e-19	NTclustered	gi\|2859928216\|gb\|PQ511684.1\|	11676	g45387	i0	98.387	11.3049403747871	62	1	11	0	520	581	9469	9530	HIV-1 isolate GB1LV100191 from USA, complete genome	blastn	6636	111	0.990990990990991	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
6687929	6687929	PRJNA1160211_S_NODE_242866_length_268_cov_1.379487_g241633_i0	PRJNA1160211	242866	268	1.379487	3.69702516	Gammaretrovirus murleu	3428959	Viruses	Viruses	453	5.76e-123	NTclustered	gi\|2228757\|gb\|U94692.1\|RMU94692	11938	g241633	i0	98.444	95.8955223880597	257	4	96	0	1	257	1887	1631	Rauscher murine leukemia virus, complete genome	blastn	25700	453	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
7416063	7416063	PRJNA1160211_S_NODE_121586_length_418_cov_10.585507_g120357_i0	PRJNA1160211	121586	418	10.585507	44.24741926	root	1	Root_unresolved	Root_unresolved	121	1.09e-22	NTclustered	gi\|2859928216\|gb\|PQ511684.1\|	11676	g120357	i0	98.529	17.0287081339713	68	1	16	0	68	135	9536	9469	HIV-1 isolate GB1LV100191 from USA, complete genome	blastn	7118	122	0.991803278688525	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
11242292	11242292	PRJNA1160211_S_NODE_75549_length_508_cov_13.648276_g74335_i0	PRJNA1160211	75549	508	13.648276	69.33324208	Gammaretrovirus	153135	Viruses	Viruses	896	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g74335	i0	100	95.494094488189	485	0	95	0	8	492	3998	4482	Moloney murine leukemia virus, complete genome	blastn	48511	896	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
15611838	15611838	PRJNA1160211_S_NODE_117093_length_426_cov_5.501416_g115864_i0	PRJNA1160211	117093	426	5.501416	23.43603216	Citrus endogenous pararetrovirus	1435008	Viruses	Viruses	538	2.5899999999999992e-148	NTclustered	gi\|565672283\|gb\|KF800045.1\|	1435008	g115864	i0	90.977	5.47652582159624	399	36	94	0	23	421	523	125	Citrus endogenous pararetrovirus clone CB17-3, complete genome	blastn	2333	538	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
16886826	16886826	PRJNA1160211_S_NODE_196754_length_314_cov_5.672199_g195521_i0	PRJNA1160211	196754	314	5.672199	17.81070486	Citrus endogenous pararetrovirus	1435008	Viruses	Viruses	342	1.5599999999999997e-89	NTclustered	gi\|1189354729\|gb\|KY609920.1\|	1435008	g195521	i0	92.5	3.82165605095541	240	17	76	1	1	239	3806	3567	Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds	blastn	1200	342	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
17616143	17616143	PRJNA1160211_S_NODE_1874_length_1195_cov_5.576649_g1564_i0	PRJNA1160211	1874	1195	5.576649	66.64095555	Gammaretrovirus	153135	Viruses	Viruses	1375	0	NTclustered	gi\|2225989\|emb\|Y13893.1\|	11786	g1564	i0	98.96	92.4945606694561	769	7	96	1	406	1173	3020	3788	Murine leukemia virus RNA for gag-pol-env polyproteins	blastn	110531	1380	0.996376811594203	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
17616735	17616735	PRJNA1160211_S_NODE_66874_length_529_cov_10.872807_g65674_i0	PRJNA1160211	66874	529	10.872807	57.51714903	root	1	Root_unresolved	Root_unresolved	99	6.57e-16	NTclustered	gi\|2859928216\|gb\|PQ511684.1\|	11676	g65674	i0	93.846	12.9281663516068	65	4	12	0	455	519	9469	9533	HIV-1 isolate GB1LV100191 from USA, complete genome	blastn	6839	100	0.99	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
21987654	21987654	PRJNA1160211_S_NODE_92798_length_471_cov_13.168342_g91575_i0	PRJNA1160211	92798	471	13.168342	62.02289082	Citrus blight-associated pararetrovirus	2689385	Viruses	Viruses	750	0	NTclustered	gi\|1785997357\|gb\|MN814438.1\|	2689385	g91575	i0	96.875	2.82802547770701	448	14	95	0	1	448	3207	2760	Citrus blight-associated pararetrovirus isolate CBaPRV-LC, complete genome	blastn	1332	750	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus blight-associated pararetrovirus

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