metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA737474" 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
25626294	25626294	PRJNA737474b_S_NODE_50321_length_219_cov_5.623288_g49282_i0	PRJNA737474	50321	219	5.623288	12.31500072	Gammaretrovirus	153135	Viruses	Viruses	381	2.1799999999999996e-101	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g49282	i0	99.061	97.0045662100457	213	1	97	1	1	213	3798	3587	Moloney murine leukemia virus, complete genome	blastn	21244	381	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25626405	25626405	PRJNA737474b_S_NODE_7081_length_634_cov_40419.684492_g6078_i0	PRJNA737474	7081	634	40419.684492	256260.79967928	root	1	Root_unresolved	Root_unresolved	599	1.789999999999999e-166	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g6078	i0	95.935	58.198738170347	369	15	58	0	125	493	2964	2596	Moloney murine leukemia virus, complete genome	blastn	36898	599	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25628950	25628950	PRJNA737474f_S_NODE_1841_length_2199_cov_347.718250_g1582_i0	PRJNA737474	1841	2199	347.71825	7646.3243175	Gammaretrovirus	153135	Viruses	Viruses	3467	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g1582	i0	97.903	90.0131878126421	2003	42	91	0	147	2149	2610	4612	Moloney murine leukemia virus, complete genome	blastn	197939	3467	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25761726	25761726	PRJNA737474b_S_NODE_13170_length_441_cov_3.497283_g12133_i0	PRJNA737474	13170	441	3.497283	15.42301803	Gammaretrovirus	153135	Viruses	Viruses	719	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g12133	i0	97.393	95.6485260770975	422	11	96	0	6	427	4428	4007	Moloney murine leukemia virus, complete genome	blastn	42181	719	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25763330	25763330	PRJNA737474c_S_NODE_6706_length_417_cov_6.113372_g5875_i0	PRJNA737474	6706	417	6.113372	25.49276124	root	1	Root_unresolved	Root_unresolved	536	9.079999999999999e-148	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g5875	i0	96.049	78.8129496402878	329	13	79	0	85	413	2596	2924	Moloney murine leukemia virus, complete genome	blastn	32865	536	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25763371	25763371	PRJNA737474c_S_NODE_9330_length_364_cov_1.584192_g8499_i0	PRJNA737474	9330	364	1.584192	5.76645888	Gammaretrovirus	153135	Viruses	Viruses	612	1.2599999999999999e-170	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g8499	i0	98.555	91.532967032967	346	5	95	0	17	362	4222	3877	Moloney murine leukemia virus, complete genome	blastn	33318	612	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25764804	25764804	PRJNA737474e_S_NODE_26722_length_259_cov_4.682796_g25840_i0	PRJNA737474	26722	259	4.682796	12.12844164	Gammaretrovirus	153135	Viruses	Viruses	368	2.06e-97	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g25840	i0	97.664	2.47876447876448	214	5	83	0	13	226	4399	4612	Moloney murine leukemia virus, complete genome	blastn	642	368	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25899848	25899848	PRJNA737474d_S_NODE_3267_length_971_cov_5.469933_g2782_i0	PRJNA737474	3267	971	5.469933	53.11304943	root	1	Root_unresolved	Root_unresolved	1456	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g2782	i0	96.38	91.1637487126674	884	32	91	0	5	888	3479	2596	Moloney murine leukemia virus, complete genome	blastn	88520	1456	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26171464	26171464	PRJNA737474c_S_NODE_3189_length_644_cov_2580.089317_g2381_i0	PRJNA737474	3189	644	2580.089317	16615.77520148	Gammaretrovirus	153135	Viruses	Viruses	996	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g2381	i0	98.579	87.1009316770186	563	8	87	0	82	644	3300	3862	Moloney murine leukemia virus, complete genome	blastn	56093	996	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26171967	26171967	PRJNA737474d_S_NODE_20757_length_335_cov_2.713740_g20163_i0	PRJNA737474	20757	335	2.71374	9.091029	Gammaretrovirus	153135	Viruses	Viruses	614	3.209999999999999e-171	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g20163	i0	99.701	99.0776119402985	335	1	100	0	1	335	3974	4308	Moloney murine leukemia virus, complete genome	blastn	33191	614	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26308813	26308813	PRJNA737474e_S_NODE_2126_length_861_cov_5.096447_g1327_i0	PRJNA737474	2126	861	5.096447	43.88040867	Gammaretrovirus	153135	Viruses	Viruses	1426	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g1327	i0	98.049	95.2380952380952	820	16	95	0	18	837	2997	3816	Moloney murine leukemia virus, complete genome	blastn	82000	1426	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26444208	26444208	PRJNA737474d_S_NODE_31175_length_273_cov_9.025000_g30581_i0	PRJNA737474	31175	273	9.025	24.63825	Gammaretrovirus	153135	Viruses	Viruses	459	1.2599999999999999e-124	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g30581	i0	99.213	92.2051282051282	254	2	93	0	20	273	3495	3748	Moloney murine leukemia virus, complete genome	blastn	25172	459	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26580752	26580752	PRJNA737474e_S_NODE_11752_length_346_cov_4.417582_g10870_i0	PRJNA737474	11752	346	4.417582	15.28483372	Gammaretrovirus	153135	Viruses	Viruses	630	3.3099999999999985e-176	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g10870	i0	99.709	98.4248554913295	344	1	99	0	1	344	4317	3974	Moloney murine leukemia virus, complete genome	blastn	34055	630	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26581037	26581037	PRJNA737474e_S_NODE_4208_length_516_cov_9.975169_g3332_i0	PRJNA737474	4208	516	9.975169	51.47187204	root	1	Root_unresolved	Root_unresolved	726	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g3332	i0	96.575	84.8837209302326	438	15	85	0	79	516	2596	3033	Moloney murine leukemia virus, complete genome	blastn	43800	726	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);;