metadata: contig_metadata: 7 rows where bioproject = "PRJNA564013", tax_kingdom = "Pararnavirae" and tax

7 rows where bioproject = "PRJNA564013", 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
3684277	3684277	PRJNA564013_P_NODE_360143_length_191_cov_7.192308_g357291_i0	PRJNA564013	360143	191	7.192308	13.73730828	root	1	Root_unresolved	Root_unresolved	84.2	5.83e-12	NTclustered	gi\|7414449\|emb\|AJ288590.1\|	61673	g357291	i0	94.545	25.2041884816754	55	2	29	1	21	75	1976	1923	Porcine endogenous retrovirus PERV-B4 env gene for envelope protein, genomic RNA	blastn	4814	84.2	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus porConc
10750946	10750946	PRJNA564013_P_NODE_109909_length_395_cov_8.877246_g107068_i0	PRJNA564013	109909	395	8.877246	35.0651217	Gammaretrovirus murleu	3428959	Viruses	Viruses	392	1.9599999999999994e-104	NTclustered	gi\|4928667\|gb\|AF136154.1\|AF136154	11786	g107068	i0	97.807	70.2329113924051	228	3	57	1	20	245	228	1	Murine leukemia virus long terminal repeat, partial sequence	blastn	27742	392	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
10755170	10755170	PRJNA564013_P_NODE_309809_length_219_cov_4.164557_g306957_i0	PRJNA564013	309809	219	4.164557	9.12037983	Gammaretrovirus murleu	3428959	Viruses	Viruses	324	3.72e-84	NTclustered	gi\|1167936865\|gb\|KY574518.1\|	11786	g306957	i0	100	79.8721461187215	175	0	80	0	24	198	3400	3226	Murine leukemia virus isolate PTV1, complete genome	blastn	17492	324	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
18982853	18982853	PRJNA564013_P_NODE_123975_length_378_cov_4.507886_g121129_i0	PRJNA564013	123975	378	4.507886	17.03980908	Viruses	10239	Viruses	Viruses	510	4.94e-140	NTclustered	gi\|1189354729\|gb\|KY609920.1\|	1435008	g121129	i0	91.005	6.95767195767196	378	34	100	0	1	378	1323	1700	Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds	blastn	2630	510	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
28184423	28184423	PRJNA564013_P_NODE_206766_length_300_cov_1.573222_g203915_i0	PRJNA564013	206766	300	1.573222	4.719666	Agapanthus tungrovirus	2838078	Viruses	Viruses	44.3	0.0134	NR	YP_010804323.1	2838078	g203915	i0	41.8	0.67	67	36	65	3	73	267	16	81	YP_010804323.1 p24 [Agapanthus tungrovirus]	diamond	201	44.3	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus agapanthi
29636721	29636721	PRJNA564013_P_NODE_55030_length_536_cov_20.690526_g52259_i0	PRJNA564013	55030	536	20.690526	110.90121936	Marsupial endogenous gammaretrovirus 2	3386030	Viruses	Viruses	69.7	3.27e-10	NR	DBA62711.1	3386030	g52259	i0	45.2	0.408582089552239	73	40	40.9	0	23	241	163	235	DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2]	diamond	219	69.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Marsupial endogenous gammaretrovirus 2
29777052	29777052	PRJNA564013_P_NODE_369691_length_179_cov_10.703390_g366839_i0	PRJNA564013	369691	179	10.70339	19.1590681	Gammaretrovirus	153135	Viruses	Viruses	89.7	4.39e-19	NR	AAA43042.1	11772	g366839	i0	76.8	10.0893854748603	56	13	93.9	0	178	11	177	232	AAA43042.1 gag-abl-pol fusion polyprotein, partial [Feline sarcoma virus]	diamond	1806	89.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus felleu

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