metadata: contig_metadata: 8 rows where bioproject = "PRJNA494251", tax_phylum = "Artverviricota" and tax

8 rows where bioproject = "PRJNA494251", tax_phylum = "Artverviricota" 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
4935038	4935038	PRJNA494251_P_NODE_19164_length_323_cov_1.232000_g18850_i0	PRJNA494251	19164	323	1.232	3.97936	root	1	Root_unresolved	Root_unresolved	58.4	6.52e-4	NTclustered	gi\|94539197\|gb\|DQ484472.1\|	11676	g18850	i0	100	6.06811145510836	31	0	10	0	1	31	104	74	HIV-1 isolate BCCFE_HOMER_HIV_NEF406 from Canada nef protein (nef) gene, partial cds	blastn	1960	58.4	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
4935108	4935108	PRJNA494251_P_NODE_3744_length_645_cov_92.047203_g3342_i1	PRJNA494251	3744	645	92.047203	593.70445935	Gammaretrovirus	153135	Viruses	Viruses	1014	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g3342	i1	97.797	87.0697674418605	590	10	91	2	56	642	4441	3852	Moloney murine leukemia virus, complete genome	blastn	56160	1014	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6210319	6210319	PRJNA494251_P_NODE_3625_length_653_cov_100.065517_g3342_i0	PRJNA494251	3625	653	100.065517	653.42782601	Gammaretrovirus	153135	Viruses	Viruses	1037	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g3342	i0	98.469	87.2848392036753	588	9	90	0	63	650	4439	3852	Moloney murine leukemia virus, complete genome	blastn	56997	1037	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
16409555	16409555	PRJNA494251_P_NODE_2813_length_725_cov_9.556748_g2545_i0	PRJNA494251	2813	725	9.556748	69.286423	root	1	Root_unresolved	Root_unresolved	438	4.769999999999999e-118	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g2545	i0	82.341	6.6	504	89	70	0	155	658	2171	1668	Moloney murine leukemia virus, complete genome	blastn	4785	438	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
16409636	16409636	PRJNA494251_P_NODE_933_length_1167_cov_160.483547_g515_i1	PRJNA494251	933	1167	160.483547	1872.84299349	root	1	Root_unresolved	Root_unresolved	1967	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g515	i1	97.403	98.955441302485	1155	30	99	0	10	1164	3790	2636	Moloney murine leukemia virus, complete genome	blastn	115481	1967	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
22784040	22784040	PRJNA494251_P_NODE_638_length_1338_cov_139.075889_g515_i0	PRJNA494251	638	1338	139.075889	1860.83539482	root	1	Root_unresolved	Root_unresolved	2015	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g515	i0	97.46	97.2242152466368	1181	30	97	0	149	1329	2610	3790	Moloney murine leukemia virus, complete genome	blastn	130086	2015	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
27487794	27487794	PRJNA494251_P_NODE_5483_length_546_cov_7.926004_g5186_i0	PRJNA494251	5483	546	7.926004	43.27598184	Murine leukemia virus	11786	Viruses	Viruses	106	4.63e-23	NR	AAA46514.1	11786	g5186	i0	61.4	0.483516483516484	88	34	48.4	0	277	14	141	228	AAA46514.1 env protein [Murine leukemia virus]	diamond	264	106	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
29508374	29508374	PRJNA494251_P_NODE_24630_length_292_cov_3.191781_g24316_i0	PRJNA494251	24630	292	3.191781	9.32000052	Murine leukemia virus	11786	Viruses	Viruses	43.1	0.0366	NR	AAC55819.1	11786	g24316	i0	55.8	0.441780821917808	43	19	44.2	0	32	160	165	207	AAC55819.1 reverse transcriptase, partial [Murine leukemia virus]	diamond	129	43.1	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);;