metadata: contig_metadata: 16 rows where bioproject = "PRJNA864829" and tax

16 rows where bioproject = "PRJNA864829" 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
847264	847264	PRJNA864829_S_NODE_2141_length_357_cov_4.142857_g2055_i0	PRJNA864829	2141	357	4.142857	14.78999949	Ripaglys virus	3130696	Viruses	Viruses	292	1.83e-74	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g2055	i0	82.687	297.574229691877	335	52	93	6	1	332	91	422	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	106234	292	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
847297	847297	PRJNA864829_S_NODE_7621_length_223_cov_6.155172_g7535_i0	PRJNA864829	7621	223	6.155172	13.72603356	Carlavirus latensdianthi	3427766	Viruses	Viruses	60.2	1.18e-4	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g7535	i0	97.222	0.663677130044843	36	0	16	1	1	35	13	48	Carnation latent virus isolate KL, complete genome	blastn	148	60.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
847301	847301	PRJNA864829_S_NODE_81_length_1201_cov_21.381076_g62_i0	PRJNA864829	81	1201	21.381076	256.78672276	Ripaglys virus	3130696	Viruses	Viruses	483	3.669999999999999e-131	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g62	i0	74.897	111.326394671107	1211	229	97	55	39	1201	2452	1269	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	133703	483	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
2122650	2122650	PRJNA864829_S_NODE_3322_length_305_cov_3.722656_g3236_i0	PRJNA864829	3322	305	3.722656	11.3541008	Ripaglys virus	3130696	Viruses	Viruses	233	9.46e-57	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g3236	i0	80.906	173.63606557377	309	48	100	11	1	305	1006	1307	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	52959	233	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
5950575	5950575	PRJNA864829_S_NODE_2265_length_350_cov_2.252492_g2179_i0	PRJNA864829	2265	350	2.252492	7.883722	Ripaglys virus	3130696	Viruses	Viruses	182	4.04e-41	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g2179	i0	94.828	56.6971428571429	116	6	33	0	217	332	755	640	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	19844	182	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
7225496	7225496	PRJNA864829_S_NODE_7366_length_226_cov_16.723164_g7280_i0	PRJNA864829	7366	226	16.723164	37.79435064	Ripachij virus	3130407	Viruses	Viruses	318	1.8e-82	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g7280	i0	92.035	177.632743362832	226	18	100	0	1	226	721	496	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	40145	318	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
11051006	11051006	PRJNA864829_S_NODE_1629_length_399_cov_6.445714_g1543_i0	PRJNA864829	1629	399	6.445714	25.71839886	Ripaglys virus	3130696	Viruses	Viruses	320	9.49e-83	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g1543	i0	85	93.9674185463659	320	42	79	6	53	369	1	317	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	37493	320	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
13600935	13600935	PRJNA864829_S_NODE_10551_length_195_cov_1.445205_g10465_i0	PRJNA864829	10551	195	1.445205	2.81814975	Ripakrox virus	3130763	Viruses	Viruses	220	4.36e-53	NTclustered	gi\|2717320712\|gb\|PP173065.1\|	3130763	g10465	i0	87.113	0.994871794871795	194	25	99	0	2	195	53	246	MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence	blastn	194	220	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripakrox virus
13600949	13600949	PRJNA864829_S_NODE_13751_length_173_cov_2.153226_g13665_i0	PRJNA864829	13751	173	2.153226	3.72508098	Ripaglys virus	3130696	Viruses	Viruses	102	1.42e-17	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g13665	i0	79.114	7.54913294797688	158	26	90	7	19	173	242	89	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	1306	102	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
14875319	14875319	PRJNA864829_S_NODE_72_length_1223_cov_31.003407_g55_i0	PRJNA864829	72	1223	31.003407	379.17166761	Ripaglys virus	3130696	Viruses	Viruses	725	0	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g55	i0	77.832	142.398201144726	1227	235	98	31	1	1204	1258	2470	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	174153	725	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
21249468	21249468	PRJNA864829_S_NODE_8517_length_213_cov_3.908537_g8431_i0	PRJNA864829	8517	213	3.908537	8.32518381	Caudoviricetes sp.	2832643	Viruses	Viruses	311	2.8000000000000003e-80	NTclustered	gi\|2056945457\|tpg\|BK022580.1\|	2832643	g8431	i0	92.958	1	213	15	100	0	1	213	46886	47098	MAG TPA_asm: Caudoviricetes sp. isolate ctnLt17, partial genome	blastn	213	311	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22524006	22524006	PRJNA864829_S_NODE_7598_length_224_cov_1.160000_g7512_i0	PRJNA864829	7598	224	1.16	2.5984	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g7512	i0	100	0.65625	30	0	13	0	195	224	85	56	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	147	56.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1
23799558	23799558	PRJNA864829_S_NODE_7759_length_222_cov_1.225434_g7673_i0	PRJNA864829	7759	222	1.225434	2.72046348	Caudoviricetes sp.	2832643	Viruses	Viruses	239	1.41e-58	NTclustered	gi\|2914808001\|gb\|OR221659.1\|	2832643	g7673	i0	86.036	2.64414414414414	222	31	100	0	1	222	35412	35191	MAG: Caudoviricetes sp. isolate MSP1387 genomic sequence	blastn	587	239	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29076364	29076364	PRJNA864829_S_NODE_13248_length_176_cov_2.354331_g13162_i0	PRJNA864829	13248	176	2.354331	4.14362256	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	70.9	1.83e-12	NR	ULF50550.1	3003959	g13162	i0	77.8	0.767045454545455	45	8	73.3	1	176	48	663	707	ULF50550.1 MAG: hypothetical protein 1 [Picornavirales sp.]	diamond	135	70.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31003060	31003060	PRJNA864829_S_NODE_4054_length_285_cov_2.283898_g3968_i0	PRJNA864829	4054	285	2.283898	6.5091093	Gammaretrovirus murleu	3428959	Viruses	Viruses	183	2.48e-53	NR	8WUS_E	11801	g3968	i0	100	8.81052631578947	93	0	97.9	0	3	281	209	301	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	2511	183	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31991375	31991375	PRJNA864829_S_NODE_1118_length_458_cov_2.237164_g1032_i0	PRJNA864829	1118	458	2.237164	10.24621112	Gammaretrovirus	153135	Viruses	Viruses	293	7.679999999999999e-89	NR	NP_057933.2	11801	g1032	i0	98	1.99126637554585	152	3	99.6	0	456	1	1168	1319	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	912	293	1	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);;