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

12 rows where bioproject = "PRJNA939369" 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
914544	914544	PRJNA939369_S_NODE_71821_length_243_cov_0.905882_g71404_i0	PRJNA939369	71821	243	0.905882	2.20129326	Retrovirus rattus8197	3117313	Viruses	Viruses	425	1.12e-114	NTclustered	gi\|2710390889\|tpg\|BK066447.1\|	3117313	g71404	i0	98.347	1.9917695473251	242	4	99	0	2	243	7118	7359	MAG TPA_asm: Retrovirus rattus8197 isolate Retro8197 genomic sequence	blastn	484	425	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retrovirus rattus8197
7292309	7292309	PRJNA939369_S_NODE_10366_length_419_cov_1.445087_g9949_i0	PRJNA939369	10366	419	1.445087	6.05491453	Gammaretrovirus murleu	3428959	Viruses	Viruses	767	0	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g9949	i0	99.761	14.673031026253	419	0	100	1	1	419	4577	4994	Murine leukemia virus strain SRS 19-6 complete genome	blastn	6148	767	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
11117933	11117933	PRJNA939369_S_NODE_26009_length_313_cov_1.283333_g25592_i0	PRJNA939369	26009	313	1.283333	4.01683229	Gammaretrovirus murleu	3428959	Viruses	Viruses	566	8.459999999999999e-157	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g25592	i0	99.361	87.849840255591	313	1	100	1	1	313	528	217	Murine leukemia virus strain SRS 19-6 complete genome	blastn	27497	566	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
12393632	12393632	PRJNA939369_S_NODE_54610_length_251_cov_1.028090_g54193_i0	PRJNA939369	54610	251	1.02809	2.5805059	Gammaretrovirus murleu	3428959	Viruses	Viruses	453	5.34e-123	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g54193	i0	99.203	19.7211155378486	251	2	100	0	1	251	7404	7654	Murine leukemia virus strain SRS 19-6 complete genome	blastn	4950	453	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
14942217	14942217	PRJNA939369_S_NODE_31572_length_296_cov_2.071749_g31155_i0	PRJNA939369	31572	296	2.071749	6.13237704	Gammaretrovirus murleu	3428959	Viruses	Viruses	475	1.3799999999999998e-129	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g31155	i0	100	83.7736486486486	257	0	100	0	1	257	8008	7752	Murine leukemia virus strain SRS 19-6 complete genome	blastn	24797	475	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
14942269	14942269	PRJNA939369_S_NODE_41732_length_273_cov_1.155000_g41315_i0	PRJNA939369	41732	273	1.155	3.15315	Gammaretrovirus murleu	3428959	Viruses	Viruses	505	1.6e-138	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g41315	i0	100	98.3882783882784	273	0	100	0	1	273	3915	3643	Murine leukemia virus strain SRS 19-6 complete genome	blastn	26860	505	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
21316419	21316419	PRJNA939369_S_NODE_41117_length_274_cov_1.532338_g40700_i0	PRJNA939369	41117	274	1.532338	4.19860612	Gammaretrovirus murleu	3428959	Viruses	Viruses	507	4.47e-139	NTclustered	gi\|378404894\|dbj\|AB187566.2\|	11786	g40700	i0	100	95.3394160583942	274	0	100	0	1	274	4574	4301	Murine leukemia virus Graffi GV-1.4 DNA, complete genome	blastn	26123	507	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
23866719	23866719	PRJNA939369_S_NODE_37379_length_282_cov_1.315789_g36962_i0	PRJNA939369	37379	282	1.315789	3.71052498	Gammaretrovirus murleu	3428959	Viruses	Viruses	521	1.6499999999999996e-143	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g36962	i0	100	16.2021276595745	282	0	100	0	1	282	1868	2149	Murine leukemia virus strain SRS 19-6 complete genome	blastn	4569	521	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25140391	25140391	PRJNA939369_S_NODE_22080_length_328_cov_1.325490_g21663_i0	PRJNA939369	22080	328	1.32549	4.3476072	Gammaretrovirus murleu	3428959	Viruses	Viruses	606	5.249999999999998e-169	NTclustered	gi\|4071074\|gb\|AF019230.1\|AF019230	11786	g21663	i0	100	24.8719512195122	328	0	100	0	1	328	6445	6772	Murine leukemia virus strain SRS 19-6 complete genome	blastn	8158	606	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26866994	26866994	PRJNA939369_S_NODE_22901_length_324_cov_5.541833_g22484_i0	PRJNA939369	22901	324	5.541833	17.95553892	Gammaretrovirus murleu	3428959	Viruses	Viruses	224	3.81e-69	NR	8WUS_E	11801	g22484	i0	100	7.92592592592593	107	0	99.1	0	2	322	152	258	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	2568	224	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
29740478	29740478	PRJNA939369_S_NODE_2990_length_660_cov_3.524702_g2593_i0	PRJNA939369	2990	660	3.524702	23.2630332	Moloney murine leukemia virus	11801	Viruses	Viruses	424	2.89e-134	NR	NP_057933.2	11801	g2593	i0	98.2	0.995454545454545	219	4	99.5	0	2	658	1111	1329	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	657	424	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
32648556	32648556	PRJNA939369_S_NODE_78460_length_230_cov_3.605096_g78043_i0	PRJNA939369	78460	230	3.605096	8.2917208	Gammaretrovirus murleu	3428959	Viruses	Viruses	154	1.1899999999999997e-42	NR	8WUS_E	11801	g78043	i0	98.7	5.94782608695652	76	1	99.1	0	2	229	252	327	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	1368	154	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);;