metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1111448" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1111448" 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
2298443	2298443	PRJNA1111448_S_NODE_92862_length_280_cov_1.115942_g92039_i0	PRJNA1111448	92862	280	1.115942	3.1246376	root	1	Root_unresolved	Root_unresolved	507	4.58e-139	NTclustered	gi\|1173658\|gb\|U36602.1\|MLU36602	11786	g92039	i0	99.286	9	280	2	100	0	1	280	955	676	Murine leukemia virus gPr80 envelope polyprotein precursor (env) mRNA, complete cds	blastn	2520	507	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6596608	6596608	PRJNA1111448_S_NODE_94326_length_278_cov_1.502439_g93503_i0	PRJNA1111448	94326	278	1.502439	4.17678042	Betaretrovirus murmamtum	3427295	Viruses	Viruses	508	1.26e-139	NTclustered	gi\|6911279\|gb\|AF228551.1\|AF228551	46608	g93503	i0	99.64	37.6115107913669	278	1	100	0	1	278	1624	1347	Exogenous mouse mammary tumor virus HeJ complete proviral genome	blastn	10456	508	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus murmamtum
10421209	10421209	PRJNA1111448_S_NODE_17409_length_487_cov_9.410628_g16592_i0	PRJNA1111448	17409	487	9.410628	45.82975836	Gammaretrovirus murleu	3428959	Viruses	Viruses	821	0	NTclustered	gi\|332038\|gb\|K01204.1\|MLVGPB	11786	g16592	i0	97.308	99.1457905544148	483	13	99	0	1	483	254	736	Murine leukemia virus B-tropic strain WN1802B gag-pol region	blastn	48284	821	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
13775897	13775897	PRJNA1111448_S_NODE_21611_length_455_cov_3.594241_g20789_i0	PRJNA1111448	21611	455	3.594241	16.35379655	root	1	Root_unresolved	Root_unresolved	804	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g20789	i0	99.105	98.1538461538462	447	4	98	0	9	455	2006	1560	Moloney murine leukemia virus, complete genome	blastn	44660	804	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
15520505	15520505	PRJNA1111448_S_NODE_27773_length_419_cov_6.546243_g26950_i0	PRJNA1111448	27773	419	6.546243	27.42875817	Betaretrovirus murmamtum	3427295	Viruses	Viruses	730	0	NTclustered	gi\|6911285\|gb\|AF228552.1\|AF228552	46608	g26950	i0	98.095	27.2577565632458	420	7	100	1	1	419	2045	1626	Exogenous mouse mammary tumor virus C3H complete proviral genome	blastn	11421	730	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus murmamtum

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