metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA906294" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA906294" 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
1248359	1248359	PRJNA906294_P_NODE_1561_length_3650_cov_888.655857_g51_i15	PRJNA906294	1561	3650	888.655857	32435.9387805	Gammaretrovirus	153135	Viruses	Viruses	4983	0	NTclustered	gi\|1233685432\|gb\|KY484771.1\|	194958	g51	i15	98.015	74.3668493150685	2872	52	99	3	1	2871	5805	8672	Porcine endogenous retrovirus A gag-pol polyprotein and env protein genes, complete cds	blastn	271439	4983	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
1248887	1248887	PRJNA906294_P_NODE_70221_length_545_cov_1.646186_g66121_i0	PRJNA906294	70221	545	1.646186	8.9717137	Betaretrovirus	140052	Viruses	Viruses	1005	0	NTclustered	gi\|9627014\|ref\|NC_001514.1\|	11856	g66121	i0	100	3.32844036697248	544	0	99	0	1	544	3794	4337	Squirrel monkey retrovirus - HLB, complete genome	blastn	1814	1005	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus squmon
1249027	1249027	PRJNA906294_S_NODE_441_length_349_cov_1.239130_g440_i0	PRJNA906294	441	349	1.23913	4.3245637	root	1	Root_unresolved	Root_unresolved	603	7.259999999999999e-168	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g440	i0	98.817	95.9512893982808	338	4	97	0	12	349	1841	1504	Moloney murine leukemia virus, complete genome	blastn	33487	603	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
1249032	1249032	PRJNA906294_S_NODE_781_length_289_cov_1.185185_g780_i0	PRJNA906294	781	289	1.185185	3.42518465	root	1	Root_unresolved	Root_unresolved	529	1.01e-145	NTclustered	gi\|1045515\|gb\|U36800.1\|MLU36800	11786	g780	i0	99.654	6.44982698961938	289	1	100	0	1	289	1399	1111	Murine leukemia virus Mo Ampho Delta recombinant envelope polyprotein (env) mRNA, complete cds	blastn	1864	529	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
5990953	5990953	PRJNA906294_P_NODE_200165_length_255_cov_1.362637_g196049_i0	PRJNA906294	200165	255	1.362637	3.47472435	Betaretrovirus squmon	3427297	Viruses	Viruses	464	2.5099999999999998e-126	NTclustered	gi\|1666023499\|gb\|MK561030.1\|	11856	g196049	i0	99.606	8.48235294117647	254	1	99	0	2	255	614	361	Squirrel monkey retrovirus, complete genome	blastn	2163	464	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus squmon
5993365	5993365	PRJNA906294_S_NODE_525_length_326_cov_0.865613_g524_i0	PRJNA906294	525	326	0.865613	2.82189838	Gammaretrovirus murleu	3428959	Viruses	Viruses	569	6.839999999999998e-158	NTclustered	gi\|535516\|gb\|U13766.1\|MLU13766	11786	g524	i0	98.16	98.9723926380368	326	6	100	0	1	326	6914	7239	Murine leukemia virus MCF1233, complete genome	blastn	32265	569	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
8901666	8901666	PRJNA906294_P_NODE_4067_length_2683_cov_569.239464_g51_i23	PRJNA906294	4067	2683	569.239464	15272.69481912	Gammaretrovirus	153135	Viruses	Viruses	4682	0	NTclustered	gi\|6688947\|emb\|AJ133817.1\|	61673	g51	i23	98.107	77.1833768169959	2694	40	100	3	1	2683	5910	8603	Porcine endogenous retrovirus type C proviral gag, pol and env genesand LTR (class A, clone 42)	blastn	207083	4682	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
10177339	10177339	PRJNA906294_P_NODE_368_length_5250_cov_868.029940_g51_i11	PRJNA906294	368	5250	868.02994	45571.57185	Gammaretrovirus	153135	Viruses	Viruses	5009	0	NTclustered	gi\|1233685432\|gb\|KY484771.1\|	194958	g51	i11	98.155	74.1626666666667	2873	49	100	2	91	2962	8673	5804	Porcine endogenous retrovirus A gag-pol polyprotein and env protein genes, complete cds	blastn	389354	5009	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
10177379	10177379	PRJNA906294_P_NODE_4908_length_2520_cov_4.217000_g4126_i0	PRJNA906294	4908	2520	4.217	106.2684	Betaretrovirus	140052	Viruses	Viruses	4632	0	NTclustered	gi\|9627014\|ref\|NC_001514.1\|	11856	g4126	i0	99.841	3.99126984126984	2520	4	100	0	1	2520	6853	4334	Squirrel monkey retrovirus - HLB, complete genome	blastn	10058	4632	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus squmon
10177609	10177609	PRJNA906294_S_NODE_948_length_271_cov_1.015152_g947_i0	PRJNA906294	948	271	1.015152	2.75106192	root	1	Root_unresolved	Root_unresolved	496	9.55e-136	NTclustered	gi\|332027\|gb\|M33469.1\|MLVENVC	11786	g947	i0	99.631	8	271	1	100	0	1	271	1271	1001	4070A Amphotropic Murine leukemia virus envelope gene, complete cds	blastn	2168	496	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
11452348	11452348	PRJNA906294_P_NODE_2149_length_3312_cov_964.350726_g51_i21	PRJNA906294	2149	3312	964.350726	31939.29604512	Gammaretrovirus	153135	Viruses	Viruses	5018	0	NTclustered	gi\|1233685432\|gb\|KY484771.1\|	194958	g51	i21	98.224	71.6545893719807	2872	47	100	2	442	3312	8673	5805	Porcine endogenous retrovirus A gag-pol polyprotein and env protein genes, complete cds	blastn	237320	5018	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
11452731	11452731	PRJNA906294_P_NODE_9929_length_1866_cov_10.131623_g8482_i0	PRJNA906294	9929	1866	10.131623	189.05608518	Betaretrovirus	140052	Viruses	Viruses	3434	0	NTclustered	gi\|9627014\|ref\|NC_001514.1\|	11856	g8482	i0	99.893	5.68595927116827	1865	2	99	0	2	1866	8676	6812	Squirrel monkey retrovirus - HLB, complete genome	blastn	10610	3434	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus squmon
14003045	14003045	PRJNA906294_S_NODE_531_length_325_cov_0.976190_g530_i0	PRJNA906294	531	325	0.97619	3.1726175	root	1	Root_unresolved	Root_unresolved	553	6.869999999999998e-153	NTclustered	gi\|1045515\|gb\|U36800.1\|MLU36800	11786	g530	i0	100	48.4615384615385	299	0	92	0	27	325	2098	1800	Murine leukemia virus Mo Ampho Delta recombinant envelope polyprotein (env) mRNA, complete cds	blastn	15750	553	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
14914475	14914475	PRJNA906294_P_NODE_152692_length_308_cov_1.072340_g148576_i0	PRJNA906294	152692	308	1.07234	3.3028072	Enzootic nasal tumor virus 2	2913605	Viruses	Viruses	551	2.3299999999999993e-152	NTclustered	gi\|1945368535\|dbj\|LC570918.1\|	2913605	g148576	i0	99.026	99.9220779220779	308	2	100	1	1	308	803	497	Enzootic nasal tumor virus 2 NAOM-HU3118124 env gene for envelope glycoprotein, complete cds	blastn	30776	551	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Enzootic nasal tumor virus 2
16551381	16551381	PRJNA906294_P_NODE_773_length_4367_cov_683.589194_g51_i13	PRJNA906294	773	4367	683.589194	29852.34010198	Gammaretrovirus	153135	Viruses	Viruses	4983	0	NTclustered	gi\|1233685432\|gb\|KY484771.1\|	194958	g51	i13	98.015	67.1387680329746	2872	52	100	3	1	2871	5805	8672	Porcine endogenous retrovirus A gag-pol polyprotein and env protein genes, complete cds	blastn	293195	4983	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
16551494	16551494	PRJNA906294_S_NODE_373_length_370_cov_0.855219_g372_i0	PRJNA906294	373	370	0.855219	3.1643103	Gammaretrovirus	153135	Viruses	Viruses	669	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g372	i0	99.457	98.4702702702703	368	2	99	0	1	368	3930	4297	Moloney murine leukemia virus, complete genome	blastn	36434	669	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
17467330	17467330	PRJNA906294_P_NODE_54_length_7987_cov_19.597170_g44_i0	PRJNA906294	54	7987	19.59717	1565.2259679	RD114 retrovirus	11834	Viruses	Viruses	14595	0	NTclustered	gi\|306482054\|dbj\|AB559882.1\|	11834	g44	i0	99.899	64.0930261675222	7927	8	100	0	61	7987	8249	323	RD114 retrovirus proviral DNA, complete genome, strain: CRT1	blastn	511911	14595	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	RD114 retrovirus
17826502	17826502	PRJNA906294_S_NODE_954_length_270_cov_1.563452_g953_i0	PRJNA906294	954	270	1.563452	4.2213204	Gammaretrovirus	153135	Viruses	Viruses	499	7.349999999999998e-137	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g953	i0	100	99.9518518518519	270	0	100	0	1	270	3612	3881	Moloney murine leukemia virus, complete genome	blastn	26987	499	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
19100336	19100336	PRJNA906294_P_NODE_5955_length_2328_cov_623.363636_g51_i24	PRJNA906294	5955	2328	623.363636	14511.90544608	Gammaretrovirus	153135	Viruses	Viruses	4172	0	NTclustered	gi\|6688947\|emb\|AJ133817.1\|	61673	g51	i24	99.012	85.6550687285223	2328	23	100	0	1	2328	8237	5910	Porcine endogenous retrovirus type C proviral gag, pol and env genesand LTR (class A, clone 42)	blastn	199405	4172	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
20375299	20375299	PRJNA906294_S_NODE_776_length_290_cov_0.940092_g775_i0	PRJNA906294	776	290	0.940092	2.7262668	root	1	Root_unresolved	Root_unresolved	379	1.08e-100	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g775	i0	98.165	29.9758620689655	218	3	87	1	1	218	1790	2006	Moloney murine leukemia virus, complete genome	blastn	8693	379	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
21650732	21650732	PRJNA906294_P_NODE_1997_length_3400_cov_651.575293_g51_i18	PRJNA906294	1997	3400	651.575293	22153.559962	Gammaretrovirus	153135	Viruses	Viruses	5703	0	NTclustered	gi\|1233685432\|gb\|KY484771.1\|	194958	g51	i18	97.765	67.7502941176471	3311	73	100	1	91	3400	8673	5363	Porcine endogenous retrovirus A gag-pol polyprotein and env protein genes, complete cds	blastn	230351	5703	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
22563830	22563830	PRJNA906294_P_NODE_164498_length_293_cov_0.959091_g160382_i0	PRJNA906294	164498	293	0.959091	2.81013663	Enzootic nasal tumor virus 2	2913605	Viruses	Viruses	448	2.9699999999999996e-121	NTclustered	gi\|2452509992\|gb\|ON843769.1\|	2913605	g160382	i0	94	102.081911262799	300	11	100	1	1	293	6863	7162	Enzootic nasal tumour virus of goats isolate GDZJ2022 gag protein (gag), pro protein (pro), pol protein (pol), and env protein (env) genes, complete cds	blastn	29910	448	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Enzootic nasal tumor virus 2
22926692	22926692	PRJNA906294_P_NODE_978_length_4153_cov_679.877696_g51_i14	PRJNA906294	978	4153	679.877696	28235.32071488	Gammaretrovirus	153135	Viruses	Viruses	4983	0	NTclustered	gi\|1233685432\|gb\|KY484771.1\|	194958	g51	i14	98.015	59.8829761618107	2872	52	100	3	1283	4153	8672	5805	Porcine endogenous retrovirus A gag-pol polyprotein and env protein genes, complete cds	blastn	248694	4983	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
24200306	24200306	PRJNA906294_P_NODE_41099_length_814_cov_2.948718_g37372_i0	PRJNA906294	41099	814	2.948718	24.00256452	Betaretrovirus	140052	Viruses	Viruses	1493	0	NTclustered	gi\|9627014\|ref\|NC_001514.1\|	11856	g37372	i0	99.754	3.08845208845209	814	2	100	0	1	814	876	1689	Squirrel monkey retrovirus - HLB, complete genome	blastn	2514	1493	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus squmon

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