metadata: contig_metadata: 9 rows where bioproject = "PRJNA704949", tax_phylum = "Artverviricota" and tax

9 rows where bioproject = "PRJNA704949", 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
690747	690747	PRJNA704949_P_NODE_1597721_length_193_cov_1.083333_g1582382_i0	PRJNA704949	1597721	193	1.083333	2.09083269	Citrus blight-associated pararetrovirus	2689385	Viruses	Viruses	291	3.2399999999999994e-74	NTclustered	gi\|2288530032\|gb\|MZ330114.1\|	2689385	g1582382	i0	93.782	2	193	12	100	0	1	193	4969	4777	Citrus blight-associated pararetrovirus isolate TL 101/CBaPRV, complete genome	blastn	386	291	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus blight-associated pararetrovirus
3742711	3742711	PRJNA704949_P_NODE_975563_length_264_cov_1.888372_g960228_i0	PRJNA704949	975563	264	1.888372	4.98530208	root	1	Root_unresolved	Root_unresolved	488	1.5499999999999999e-133	NTclustered	gi\|2567179267\|gb\|OR245780.1\|	11676	g960228	i0	100	5	264	0	100	0	1	264	4400	4663	HIV-1 isolate MRC008_umi406bins_ubs-42_rep06_count-1 from Belgium defective genome	blastn	1320	488	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
9620881	9620881	PRJNA704949_P_NODE_1793308_length_178_cov_1.271318_g1777969_i0	PRJNA704949	1793308	178	1.271318	2.26294604	Citrus endogenous pararetrovirus	1435008	Viruses	Viruses	122	1.13e-23	NTclustered	gi\|1189354729\|gb\|KY609920.1\|	1435008	g1777969	i0	91.209	0.51123595505618	91	7	51	1	3	92	3651	3561	Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds	blastn	91	122	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
10892989	10892989	PRJNA704949_P_NODE_1368389_length_213_cov_1.902439_g1353051_i0	PRJNA704949	1368389	213	1.902439	4.05219507	Lentivirus humimdef1	3418650	Viruses	Viruses	54.7	0.005	NTclustered	gi\|1624730909\|gb\|MK466069.1\|	11676	g1353051	i0	100	0.136150234741784	29	0	14	0	125	153	185	213	HIV-1 isolate 3162_EMN14 from USA envelope glycoprotein (env) gene, partial cds	blastn	29	54.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
13447688	13447688	PRJNA704949_P_NODE_1995731_length_167_cov_0.957627_g1980392_i0	PRJNA704949	1995731	167	0.957627	1.59923709	Citrus endogenous pararetrovirus	1435008	Viruses	Viruses	108	2.95e-19	NTclustered	gi\|565672279\|gb\|KF800044.1\|	1435008	g1980392	i0	95.522	1.60479041916168	67	3	40	0	86	152	6882	6948	Citrus endogenous pararetrovirus clone CB17-2, complete genome	blastn	268	108	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
17280340	17280340	PRJNA704949_P_NODE_963994_length_266_cov_1.778802_g948659_i0	PRJNA704949	963994	266	1.778802	4.73161332	Caulimovirus sp.	2692413	Viruses	Viruses	309	1.31e-79	NTclustered	gi\|1789142630\|gb\|MN203146.1\|	2692413	g948659	i0	87.594	1	266	33	100	0	1	266	5391	5126	Caulimovirus sp. isolate UHEPClV-1.CD-W ORF2 gene, complete cds; and ORF1 gene, partial cds	blastn	266	309	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Caulimovirus	Caulimovirus sp.
22863997	22863997	PRJNA704949_P_NODE_1458418_length_205_cov_0.942308_g1443080_i0	PRJNA704949	1458418	205	0.942308	1.9317314	Viruses	10239	Viruses	Viruses	322	1.24e-83	NTclustered	gi\|1189354729\|gb\|KY609920.1\|	1435008	g1443080	i0	95.098	7.61951219512195	204	10	99	0	1	204	2716	2513	Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds	blastn	1562	324	0.993827160493827	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Citrus endogenous pararetrovirus
26956422	26956422	PRJNA704949_P_NODE_1835902_length_175_cov_1.238095_g1820563_i0	PRJNA704949	1835902	175	1.238095	2.16666625	Tobacco vein clearing virus	107324	Viruses	Viruses	60.8	6.04e-9	NR	NP_569140.1	107324	g1820563	i0	50	0.994285714285714	58	29	99.4	0	2	175	319	376	NP_569140.1 putative cell-to-cell movement protein [Tobacco vein clearing virus]	diamond	174	60.8	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Solendovirus	Solendovirus venanicotianae
32580942	32580942	PRJNA704949_P_NODE_1532199_length_198_cov_1.395973_g1516860_i0	PRJNA704949	1532199	198	1.395973	2.76402654	Caulimovirus sp.	2692413	Viruses	Viruses	65.1	2.69e-10	NR	QHB15111.1	2692413	g1516860	i0	72.5	1.21212121212121	40	11	60.6	0	59	178	81	120	QHB15111.1 ORF2 [Caulimovirus sp.]	diamond	240	65.1	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Caulimovirus	Caulimovirus sp.

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