metadata: contig_metadata: 7 rows where bioproject = "PRJNA316313" and tax

7 rows where bioproject = "PRJNA316313" 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
2938625	2938625	PRJNA316313_P_NODE_446543_length_151_cov_3.736842_g445157_i0	PRJNA316313	446543	151	3.736842	5.64263142	Citrus endogenous pararetrovirus	1435008	Viruses	Viruses	87.9	3.38e-13	NTclustered	gi\|1189354729\|gb\|KY609920.1\|	1435008	g445157	i0	89.706	0.450331125827815	68	7	45	0	8	75	4059	3992	Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds	blastn	68	87.9	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
4895142	4895142	PRJNA316313_P_NODE_125764_length_188_cov_6.311258_g124378_i0	PRJNA316313	125764	188	6.311258	11.86516504	root	1	Root_unresolved	Root_unresolved	147	7.179999999999999e-31	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g124378	i0	100	72.5425531914894	79	0	82	0	1	79	3625	3703	Moloney murine leukemia virus, complete genome	blastn	13638	147	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
5490633	5490633	PRJNA316313_P_NODE_303665_length_187_cov_2.406667_g302279_i0	PRJNA316313	303665	187	2.406667	4.50046729	Red clover bacilliform virus	1214920	Viruses	Viruses	126	9.3e-25	NTclustered	gi\|397770868\|gb\|JX069965.1\|	1214920	g302279	i0	97.297	0.39572192513369	74	2	40	0	114	187	64	137	Red clover bacilliform virus isolate 12/13 polyprotein gene, partial cds	blastn	74	126	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Red clover bacilliform virus
27327455	27327455	PRJNA316313_P_NODE_274323_length_187_cov_2.593333_g272937_i0	PRJNA316313	274323	187	2.593333	4.84953271	Tobacco vein clearing virus	107324	Viruses	Viruses	44.3	0.00516	NR	NP_569141.1	107324	g272937	i0	85	0.641711229946524	20	3	32.1	0	128	187	521	540	NP_569141.1 polyprotein [Tobacco vein clearing virus]	diamond	120	44.3	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Solendovirus	Solendovirus venanicotianae
30042857	30042857	PRJNA316313_P_NODE_254931_length_187_cov_2.800000_g253545_i0	PRJNA316313	254931	187	2.8	5.236	Tobacco vein clearing virus	107324	Viruses	Viruses	56.6	2.17e-7	NR	NP_569139.1	107324	g253545	i0	84	1.60427807486631	25	4	40.1	0	185	111	494	518	NP_569139.1 putative coat protein [Tobacco vein clearing virus]	diamond	300	56.6	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Solendovirus	Solendovirus venanicotianae
30579784	30579784	PRJNA316313_P_NODE_314433_length_187_cov_2.320000_g313047_i0	PRJNA316313	314433	187	2.32	4.3384	Tobacco vein clearing virus	107324	Viruses	Viruses	41.6	0.0464	NR	NP_569139.1	107324	g313047	i0	68	0.401069518716578	25	8	40.1	0	112	186	386	410	NP_569139.1 putative coat protein [Tobacco vein clearing virus]	diamond	75	41.6	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Solendovirus	Solendovirus venanicotianae
30801154	30801154	PRJNA316313_P_NODE_503834_length_150_cov_3.238938_g502448_i0	PRJNA316313	503834	150	3.238938	4.858407	Tobacco vein clearing virus	107324	Viruses	Viruses	68.9	5.85e-12	NR	NP_569141.1	107324	g502448	i0	57.8	2.56	64	11	96	1	148	5	506	569	NP_569141.1 polyprotein [Tobacco vein clearing virus]	diamond	384	68.9	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Solendovirus	Solendovirus venanicotianae

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