metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA493632" 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
464190	464190	PRJNA493632_P_NODE_45101_length_632_cov_2.239714_g41902_i0	PRJNA493632	45101	632	2.239714	14.15499248	Mus musculus mobilized endogenous polytropic provirus	590745	Viruses	Viruses	1123	0	NTclustered	gi\|221326511\|gb\|FJ544576.1\|	590745	g41902	i0	98.734	151.030063291139	632	8	100	0	1	632	5327	4696	Mus musculus mobilized endogenous polytropic provirus clone 5 truncated gag-pol polyprotein (gag) gene, complete cds	blastn	95451	1123	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Mus musculus mobilized endogenous polytropic provirus
1100314	1100314	PRJNA493632_P_NODE_111501_length_435_cov_1.306630_g108091_i0	PRJNA493632	111501	435	1.30663	5.6838405	root	1	Root_unresolved	Root_unresolved	795	0	NTclustered	gi\|57547617\|tpd\|BR000029.1\|	10654	g108091	i0	99.539	31.2896551724138	434	2	99	0	2	435	3223	2790	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A	blastn	13611	802	0.991271820448878	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
1101380	1101380	PRJNA493632_P_NODE_24881_length_815_cov_1.517520_g22146_i0	PRJNA493632	24881	815	1.51752	12.367788	root	1	Root_unresolved	Root_unresolved	1467	0	NTclustered	gi\|57547617\|tpd\|BR000029.1\|	10654	g22146	i0	99.017	82.6687116564417	814	8	99	0	2	815	2108	1295	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A	blastn	67375	1472	0.996603260869565	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
1735140	1735140	PRJNA493632_P_NODE_242162_length_319_cov_0.914634_g238726_i0	PRJNA493632	242162	319	0.914634	2.91768246	Gammaretrovirus porConc	3428960	Viruses	Viruses	311	4.47e-80	NTclustered	gi\|333034216\|gb\|HQ540594.1\|	194959	g238726	i0	95.855	0.605015673981191	193	6	60	2	1	191	9212	9404	Porcine endogenous retrovirus B clone 742H1, complete genome	blastn	193	311	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
3655010	3655010	PRJNA493632_P_NODE_65543_length_541_cov_1.188034_g62220_i0	PRJNA493632	65543	541	1.188034	6.42726394	root	1	Root_unresolved	Root_unresolved	926	0	NTclustered	gi\|57547617\|tpd\|BR000029.1\|	10654	g62220	i0	98.292	105.770794824399	527	9	97	0	1	527	3304	3830	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A	blastn	57222	929	0.996770721205597	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
7478528	7478528	PRJNA493632_P_NODE_13126_length_1058_cov_3.480203_g11084_i0	PRJNA493632	13126	1058	3.480203	36.82054774	root	1	Root_unresolved	Root_unresolved	1936	0	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g11084	i0	99.622	87.3270321361059	1058	4	100	0	1	1058	2370	1313	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	92392	1943	0.996397323726197	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
8118718	8118718	PRJNA493632_P_NODE_535787_length_249_cov_1.005682_g532348_i0	PRJNA493632	535787	249	1.005682	2.50414818	Betaretrovirus maspfimon	3427294	Viruses	Viruses	438	1.4799999999999996e-118	NTclustered	gi\|298352665\|gb\|HM143845.1\|	11942	g532348	i0	98.4	109.353413654618	250	3	100	1	1	249	3383	3134	Simian retrovirus 1 isolate SRV_Vero_Assembled gag pseudogene, partial sequence; pol protein (pol) gene, partial cds; and env pseudogene, complete sequence	blastn	27229	438	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus maspfimon
12580013	12580013	PRJNA493632_P_NODE_21190_length_870_cov_1.863237_g18645_i0	PRJNA493632	21190	870	1.863237	16.2101619	root	1	Root_unresolved	Root_unresolved	1555	0	NTclustered	gi\|57547621\|tpd\|BR000030.1\|	10654	g18645	i0	98.851	107.873563218391	870	10	100	0	1	870	4178	3309	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-B	blastn	93850	1563	0.99488163787588	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
13215311	13215311	PRJNA493632_P_NODE_31651_length_735_cov_7.749245_g28702_i0	PRJNA493632	31651	735	7.749245	56.95695075	Gammaretrovirus felleu	3428951	Viruses	Viruses	549	2.1399999999999992e-151	NTclustered	gi\|1249614576\|dbj\|AB898926.1\|	11768	g28702	i0	93.514	0.503401360544218	370	23	50	1	1	370	1429	1061	Feline leukemia virus gene for gag-pol polyprotein gPr80, partial sequence, clone: g45-5R	blastn	370	549	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus felleu
13857948	13857948	PRJNA493632_P_NODE_76511_length_507_cov_2.320276_g73145_i0	PRJNA493632	76511	507	2.320276	11.76379932	root	1	Root_unresolved	Root_unresolved	931	0	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g73145	i0	99.803	63.1439842209073	507	1	100	0	1	507	2877	2371	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	32014	937	0.993596584845251	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
17044544	17044544	PRJNA493632_P_NODE_629694_length_243_cov_0.905882_g626253_i0	PRJNA493632	629694	243	0.905882	2.20129326	Lentivirus humimdef1	3418650	Viruses	Viruses	54.7	0.006	NTclustered	gi\|1321077542\|gb\|KY713237.1\|	11676	g626253	i0	100	0.119341563786008	29	0	12	0	45	73	780	752	HIV-1 isolate SC012 from India nonfunctional gag protein (gag) gene, complete sequence	blastn	29	54.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
17679487	17679487	PRJNA493632_P_NODE_29954_length_753_cov_2.510294_g27054_i0	PRJNA493632	29954	753	2.510294	18.90251382	root	1	Root_unresolved	Root_unresolved	1293	0	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g27054	i0	98.753	143.26427622842	722	8	96	1	33	753	353	1074	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	107878	1304	0.991564417177914	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
17682046	17682046	PRJNA493632_P_NODE_7434_length_1326_cov_2.636073_g5935_i0	PRJNA493632	7434	1326	2.636073	34.95432798	root	1	Root_unresolved	Root_unresolved	2422	0	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g5935	i0	99.548	103.93137254902	1326	6	100	0	1	1326	7003	5678	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	137813	2429	0.997118155619596	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
18953820	18953820	PRJNA493632_P_NODE_36815_length_689_cov_10.803571_g33739_i0	PRJNA493632	36815	689	10.803571	74.43660419	Gammaretrovirus	153135	Viruses	Viruses	1232	0	NTclustered	gi\|82582295\|gb\|DQ241301.1\|	356663	g33739	i0	98.983	105.377358490566	688	7	99	0	2	689	8161	7474	Xenotropic MuLV-related virus VP35, complete genome	blastn	72605	1232	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Murine leukemia-related retroviruses
19589870	19589870	PRJNA493632_P_NODE_44016_length_638_cov_7.824779_g40828_i0	PRJNA493632	44016	638	7.824779	49.92209002	Gammaretrovirus felleu	3428951	Viruses	Viruses	449	1.9199999999999995e-121	NTclustered	gi\|1249614576\|dbj\|AB898926.1\|	11768	g40828	i0	96.337	0.427899686520376	273	10	43	0	366	638	1061	1333	Feline leukemia virus gene for gag-pol polyprotein gPr80, partial sequence, clone: g45-5R	blastn	273	449	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus felleu
20227697	20227697	PRJNA493632_P_NODE_23356_length_836_cov_1.427261_g20691_i0	PRJNA493632	23356	836	1.427261	11.93190196	root	1	Root_unresolved	Root_unresolved	1513	0	NTclustered	gi\|57547617\|tpd\|BR000029.1\|	10654	g20691	i0	99.163	97.2356459330144	836	7	100	0	1	836	6084	6919	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A	blastn	81289	1522	0.994086727989487	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
22781527	22781527	PRJNA493632_P_NODE_90578_length_473_cov_2.535000_g87193_i0	PRJNA493632	90578	473	2.535	11.99055	root	1	Root_unresolved	Root_unresolved	856	0	NTclustered	gi\|57547621\|tpd\|BR000030.1\|	10654	g87193	i0	99.154	119.659619450317	473	4	100	0	1	473	5724	5252	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-B	blastn	56599	863	0.99188876013905	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
23417078	23417078	PRJNA493632_P_NODE_483059_length_255_cov_2.269231_g479620_i0	PRJNA493632	483059	255	2.269231	5.78653905	Orthohepadnavirus hominoidei	3431302	Viruses	Viruses	460	3.25e-125	NTclustered	gi\|116812272\|dbj\|AB246340.1\|	10407	g479620	i0	99.216	100	255	2	100	0	1	255	310	56	Hepatitis B virus DNA, complete genome, clone: Ba_JPN58	blastn	25500	460	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Blubervirales	Hepadnaviridae	Orthohepadnavirus	Orthohepadnavirus hominoidei
25326599	25326599	PRJNA493632_P_NODE_112600_length_433_cov_1.894444_g109190_i0	PRJNA493632	112600	433	1.894444	8.20294252	root	1	Root_unresolved	Root_unresolved	793	0	NTclustered	gi\|57547617\|tpd\|BR000029.1\|	10654	g109190	i0	99.538	121.685912240185	433	2	100	0	1	433	4970	5402	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A	blastn	52690	795	0.99748427672956	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae

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