metadata: contig_metadata: 10 rows where bioproject = "PRJNA1241156" and tax

10 rows where bioproject = "PRJNA1241156" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3601300	3601300	PRJNA1241156_S_NODE_563_length_2021_cov_107.843782_g547_i1	PRJNA1241156	563	2021	107.843782	2179.52283422	Moloney murine leukemia virus	11801	Viruses	Viruses	1216	0	NR	NP_057933.2	11801	g547	i1	97.7	2.75210291934686	618	14	91.7	0	1864	11	718	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5562	1216	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
4177081	4177081	PRJNA1241156_S_NODE_37024_length_310_cov_5.602996_g36564_i0	PRJNA1241156	37024	310	5.602996	17.3692876	Murine leukemia-related retroviruses	99182	Viruses	Viruses	525	1.42e-144	NTclustered	gi\|336087897\|emb\|FR872816.1\|	438045	g36564	i0	98.02	97.758064516129	303	5	98	1	1	303	828	1129	XMRV complete proviral genome, isolate S-162	blastn	30305	525	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Murine leukemia-related retroviruses
13804193	13804193	PRJNA1241156_S_NODE_65391_length_242_cov_2702.467337_g64931_i0	PRJNA1241156	65391	242	2702.467337	6539.97095554	root	1	Root_unresolved	Root_unresolved	69.4	2.16e-7	NTclustered	gi\|2859928216\|gb\|PQ511684.1\|	11676	g64931	i0	100	18.0123966942149	37	0	15	0	2	38	9503	9467	HIV-1 isolate GB1LV100191 from USA, complete genome	blastn	4359	69.4	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
16927406	16927406	PRJNA1241156_S_NODE_554_length_2129_cov_103.581016_g547_i0	PRJNA1241156	554	2129	103.581016	2205.23983064	Moloney murine leukemia virus	11801	Viruses	Viruses	1291	0	NR	NP_057933.2	11801	g547	i0	97.6	2.78581493658995	659	16	92.9	0	143	2119	677	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5931	1291	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26711565	26711565	PRJNA1241156_S_NODE_55201_length_264_cov_1.085973_g54741_i0	PRJNA1241156	55201	264	1.085973	2.86696872	Gammaretrovirus	153135	Viruses	Viruses	168	3.07e-46	NR	NP_057933.2	11801	g54741	i0	97.7	1.97727272727273	87	2	98.9	0	262	2	1243	1329	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	522	168	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
27294830	27294830	PRJNA1241156_S_NODE_48243_length_280_cov_4.987342_g47783_i0	PRJNA1241156	48243	280	4.987342	13.9645576	Human endogenous retrovirus K	45617	Viruses	Viruses	70.5	1.04e-11	NR	CAA76882.1	45617	g47783	i0	49.3	4.82142857142857	75	38	80.4	0	235	11	199	273	CAA76882.1 pol protein [Human endogenous retrovirus K]	diamond	1350	71.2	0.990168539325843	Viruses	Human endogenous retroviruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Human endogenous retrovirus K
28241958	28241958	PRJNA1241156_S_NODE_50846_length_274_cov_2.233766_g50386_i0	PRJNA1241156	50846	274	2.233766	6.12051884	Moloney murine leukemia virus	11801	Viruses	Viruses	160	3.3599999999999992e-43	NR	NP_057933.2	11801	g50386	i0	98.8	1.77372262773723	81	1	88.7	0	273	31	1155	1235	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	486	160	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
29441680	29441680	PRJNA1241156_S_NODE_32850_length_322_cov_2.465950_g32390_i0	PRJNA1241156	32850	322	2.46595	7.940359	Gammaretrovirus murleu	3428959	Viruses	Viruses	225	1.91e-69	NR	8WUS_E	11801	g32390	i0	100	7.97515527950311	107	0	99.7	0	1	321	149	255	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	2568	225	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
30642123	30642123	PRJNA1241156_S_NODE_20913_length_362_cov_1.877743_g20453_i0	PRJNA1241156	20913	362	1.877743	6.79742966	Gammaretrovirus murleu	3428959	Viruses	Viruses	244	1.08e-76	NR	8WUS_E	11801	g20453	i0	99.2	3.97790055248619	120	1	99.4	0	3	362	256	375	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	1440	244	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31653627	31653627	PRJNA1241156_S_NODE_54297_length_266_cov_0.959641_g53837_i0	PRJNA1241156	54297	266	0.959641	2.55264506	Retroviridae sp.	2681591	Viruses	Viruses	99.4	6.160000000000001e-22	NR	XNT20491.1	2681591	g53837	i0	54.5	0.992481203007519	88	38	99.2	1	265	2	89	174	XNT20491.1 MAG: hypothetical protein, partial [Retroviridae sp.]	diamond	264	99.4	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retroviridae sp.

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