metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA667863" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA667863" 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
1163487	1163487	PRJNA667863_P_NODE_17741_length_235_cov_2.240741_g17707_i0	PRJNA667863	17741	235	2.240741	5.26574135	root	1	Root_unresolved	Root_unresolved	424	3.87e-114	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g17707	i0	99.149	24.931914893617	235	2	100	0	1	235	6090	6324	Moloney murine leukemia virus, complete genome	blastn	5859	424	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
3715226	3715226	PRJNA667863_P_NODE_2303_length_378_cov_1.888525_g2269_i0	PRJNA667863	2303	378	1.888525	7.1386245	Gammaretrovirus	153135	Viruses	Viruses	693	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g2269	i0	99.735	98.8148148148148	378	1	100	0	1	378	5478	5101	Moloney murine leukemia virus, complete genome	blastn	37352	693	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6267430	6267430	PRJNA667863_P_NODE_1505_length_434_cov_2.750693_g1471_i0	PRJNA667863	1505	434	2.750693	11.93800762	root	1	Root_unresolved	Root_unresolved	791	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g1471	i0	99.539	100.195852534562	434	2	100	0	1	434	1551	1984	Moloney murine leukemia virus, complete genome	blastn	43485	791	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
7012558	7012558	PRJNA667863_P_NODE_2026_length_394_cov_3.563863_g1992_i0	PRJNA667863	2026	394	3.563863	14.04162022	Gammaretrovirus murleu	3428959	Viruses	Viruses	706	0	NTclustered	gi\|18448741\|gb\|AF462057.1\|	11801	g1992	i0	98.985	100	394	4	100	0	1	394	2583	2976	Moloney murine leukemia virus neuropathogenic variant ts1-92b, complete genome	blastn	39400	706	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
8816499	8816499	PRJNA667863_P_NODE_11827_length_250_cov_0.870056_g11793_i0	PRJNA667863	11827	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	446	8.89e-121	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g11793	i0	98.8	6.396	250	3	100	0	1	250	6623	6374	Moloney murine leukemia virus, complete genome	blastn	1599	446	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
15192109	15192109	PRJNA667863_P_NODE_17872_length_234_cov_2.111801_g17838_i0	PRJNA667863	17872	234	2.111801	4.94161434	root	1	Root_unresolved	Root_unresolved	427	2.9799999999999993e-115	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g17838	i0	100	99.2307692307692	231	0	99	0	4	234	2529	2299	Moloney murine leukemia virus, complete genome	blastn	23220	427	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
17741493	17741493	PRJNA667863_P_NODE_414_length_721_cov_3.686728_g385_i0	PRJNA667863	414	721	3.686728	26.58130888	Gammaretrovirus	153135	Viruses	Viruses	1288	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g385	i0	98.764	92.9528432732316	728	2	100	1	1	721	3933	4660	Moloney murine leukemia virus, complete genome	blastn	67019	1288	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
19015222	19015222	PRJNA667863_P_NODE_935_length_518_cov_4.555056_g902_i0	PRJNA667863	935	518	4.555056	23.59519008	Gammaretrovirus	153135	Viruses	Viruses	939	0	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g902	i0	99.421	99.8030888030888	518	2	100	1	1	518	3928	3412	Moloney murine leukemia virus, complete genome	blastn	51698	939	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
19760905	19760905	PRJNA667863_P_NODE_18596_length_226_cov_4.503268_g18562_i0	PRJNA667863	18596	226	4.503268	10.17738568	RD114 retrovirus	11834	Viruses	Viruses	418	1.7199999999999998e-112	NTclustered	gi\|306482054\|dbj\|AB559882.1\|	11834	g18562	i0	100	30.9026548672566	226	0	100	0	1	226	7978	7753	RD114 retrovirus proviral DNA, complete genome, strain: CRT1	blastn	6984	418	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	RD114 retrovirus

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