metadata: contig_metadata: 9 rows where bioproject = "PRJNA558770", tax_kingdom = "Pararnavirae" and tax

9 rows where bioproject = "PRJNA558770", 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
5641818	5641818	PRJNA558770_P_NODE_142645_length_234_cov_6.974874_g140640_i0	PRJNA558770	142645	234	6.974874	16.32120516	Gammaretrovirus felleu	3428951	Viruses	Viruses	119	2.04e-22	NTclustered	gi\|1249614576\|dbj\|AB898926.1\|	11768	g140640	i0	95.89	0.606837606837607	73	3	61	0	2	74	1139	1211	Feline leukemia virus gene for gag-pol polyprotein gPr80, partial sequence, clone: g45-5R	blastn	142	119	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus felleu
6233070	6233070	PRJNA558770_P_NODE_277245_length_234_cov_1.778894_g275240_i0	PRJNA558770	277245	234	1.778894	4.1626119600000004	Gammaretrovirus	153135	Viruses	Viruses	139	1.56e-28	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g275240	i0	100	25.0299145299145	75	0	63	0	160	234	3978	3904	Moloney murine leukemia virus, complete genome	blastn	5857	139	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6233509	6233509	PRJNA558770_P_NODE_395885_length_157_cov_4.409836_g393880_i0	PRJNA558770	395885	157	4.409836	6.92344252	root	1	Root_unresolved	Root_unresolved	276	7.06e-70	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g393880	i0	98.71	96.3184713375796	155	2	99	0	1	155	3491	3645	Moloney murine leukemia virus, complete genome	blastn	15122	276	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
8193475	8193475	PRJNA558770_P_NODE_2847_length_902_cov_16.214533_g1974_i0	PRJNA558770	2847	902	16.214533	146.25508766	Gammaretrovirus murleu	3428959	Viruses	Viruses	302	8.19e-77	NTclustered	gi\|1071348744\|gb\|KX173421.1\|	11786	g1974	i0	98.824	73.9711751662971	170	1	76	1	180	349	3002	3170	Murine leukemia virus clone 26, complete sequence	blastn	66722	302	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
10741872	10741872	PRJNA558770_P_NODE_13029_length_524_cov_25.582822_g11338_i0	PRJNA558770	13029	524	25.582822	134.05398728	Gammaretrovirus murleu	3428959	Viruses	Viruses	302	4.6200000000000004e-77	NTclustered	gi\|1071348744\|gb\|KX173421.1\|	11786	g11338	i0	98.824	90.1393129770992	170	1	91	1	1	170	3170	3002	Murine leukemia virus clone 26, complete sequence	blastn	47233	302	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
23490260	23490260	PRJNA558770_P_NODE_136479_length_234_cov_7.497487_g134474_i0	PRJNA558770	136479	234	7.497487	17.54411958	Lentivirus humimdef1	3418650	Viruses	Viruses	52.8	0.021	NTclustered	gi\|1344498386\|gb\|MF109386.1\|	11676	g134474	i0	100	0.11965811965812	28	0	12	0	199	226	5812	5839	HIV-1 isolate 13592_1_42.3 from United Kingdom, partial genome	blastn	28	52.8	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
26794166	26794166	PRJNA558770_P_NODE_329161_length_233_cov_6.459596_g327156_i0	PRJNA558770	329161	233	6.459596	15.05085868	Chestnut mosaic virus	2781948	Viruses	Viruses	51.6	2.51e-5	NR	YP_010800602.1	2781948	g327156	i0	84	0.321888412017167	25	4	32.2	0	232	158	1220	1244	YP_010800602.1 polyprotein [Chestnut mosaic virus]	diamond	75	51.6	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Badnavirus tessellocastaneae
31279517	31279517	PRJNA558770_P_NODE_332615_length_233_cov_5.580808_g330610_i0	PRJNA558770	332615	233	5.580808	13.00328264	Gulupa bacilliform virus A	2910932	Viruses	Viruses	44.7	0.00706	NR	USH10133.1	2910932	g330610	i0	79.2	0.309012875536481	24	5	30.9	0	76	5	99	122	USH10133.1 ORF3 [Gulupa bacilliform virus A]	diamond	72	44.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Gulupa bacilliform virus A
31912228	31912228	PRJNA558770_P_NODE_241937_length_234_cov_2.492462_g239932_i0	PRJNA558770	241937	234	2.492462	5.83236108	Hibiscus soymovirus	3023608	Viruses	Viruses	44.3	0.00921	NR	WPF45136.1	3023608	g239932	i0	79.2	0.307692307692308	24	5	30.8	0	74	3	125	148	WPF45136.1 transactivation protein [Hibiscus soymovirus]	diamond	72	44.3	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Soymovirus	Soymovirus hibisci

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