metadata: contig_metadata: 5 rows where bioproject = "PRJNA432257", tax_kingdom = "Pararnavirae" and tax

5 rows where bioproject = "PRJNA432257", 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
429875	429875	PRJNA432257_S_NODE_55501_length_222_cov_8.956757_g55120_i0	PRJNA432257	55501	222	8.956757	19.88400054	Lentivirus simimdef	3418654	Viruses	Viruses	52.8	0.02	NTclustered	gi\|1877673191\|gb\|MK686514.1\|	11723	g55120	i0	100	0.126126126126126	28	0	13	0	151	178	6066	6093	Simian immunodeficiency virus isolate E11.11D07 nonfunctional gag protein (gag) gene, complete sequence; nonfunctional pol protein (pol) gene, partial sequence; nonfunctional vif protein (vif) gene, complete sequence; vpx protein (vpx), vpr protein (vpr), tat protein (tat), and rev protein (rev) genes, complete cds; nonfunctional envelope glycoprotein (env) gene, complete sequence; and nonfunctional nef protein (nef) gene, partial sequence	blastn	28	52.8	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus simimdef
10016815	10016815	PRJNA432257_S_NODE_29888_length_279_cov_118.413223_g29507_i0	PRJNA432257	29888	279	118.413223	330.37289217	root	1	Root_unresolved	Root_unresolved	235	2.38e-57	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g29507	i0	97.81	125.505376344086	137	2	49	1	38	174	2608	2743	Moloney murine leukemia virus, complete genome	blastn	35016	235	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31434595	31434595	PRJNA432257_S_NODE_9636_length_414_cov_15.527851_g9288_i0	PRJNA432257	9636	414	15.527851	64.28530314	Moloney murine leukemia virus	11801	Viruses	Viruses	248	2.3599999999999995e-73	NR	NP_057933.2	11801	g9288	i0	96.1	1.84057971014493	127	5	92	0	33	413	1144	1270	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	762	248	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31577713	31577713	PRJNA432257_S_NODE_3156_length_619_cov_19.537801_g2961_i0	PRJNA432257	3156	619	19.537801	120.93898819	Gammaretrovirus	153135	Viruses	Viruses	389	1.81e-125	NR	AAA79247.1	11786	g2961	i0	96.9	12.0872374798061	192	6	93.1	0	34	609	236	427	AAA79247.1 putative reverse transcriptase [Murine leukemia virus]	diamond	7482	389	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31830472	31830472	PRJNA432257_S_NODE_8437_length_433_cov_153.055556_g8103_i0	PRJNA432257	8437	433	153.055556	662.73055748	Gammaretrovirus	153135	Viruses	Viruses	271	4.7e-81	NR	ARB03489.1	11786	g8103	i0	98.5	9.07621247113164	131	2	90.8	0	395	3	792	922	ARB03489.1 putative gag-pro-pol polyprotein [Murine leukemia virus]	diamond	3930	273	0.992673992673993	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);;