metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA839281" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA839281" 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
2105306	2105306	PRJNA839281_S_NODE_37582_length_161_cov_0.910714_g37313_i0	PRJNA839281	37582	161	0.910714	1.46624954	Caudoviricetes sp.	2832643	Viruses	Viruses	270	3.389999999999999e-68	NTclustered	gi\|2053012969\|tpg\|BK023725.1\|	2832643	g37313	i0	96.894	4.98136645962733	161	5	100	0	1	161	20880	21040	MAG TPA_asm: Caudoviricetes sp. isolate ctDA71, partial genome	blastn	802	270	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2505920	2505920	PRJNA839281_S_NODE_30382_length_165_cov_0.879310_g30113_i0	PRJNA839281	30382	165	0.87931	1.4508615	Pahexavirus	1982251	Viruses	Viruses	300	4.46e-77	NTclustered	gi\|1338076751\|gb\|MG820638.1\|	2079411	g30113	i0	99.394	44.4787878787879	165	1	100	0	1	165	26415	26579	Propionibacterium phage pa6919-4, complete genome	blastn	7339	300	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage pa6919-4
3380422	3380422	PRJNA839281_S_NODE_18623_length_191_cov_1.788732_g18354_i0	PRJNA839281	18623	191	1.788732	3.41647812	Svunavirus GBSV1	2170221	Viruses	Viruses	255	1.17e-63	NTclustered	gi\|124300942\|ref\|NC_008376.2\|	365048	g18354	i0	91.005	0.989528795811518	189	17	99	0	3	191	25534	25722	Geobacillus phage GBSV1, complete genome	blastn	189	255	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Svunavirus	Svunavirus GBSV1
4657944	4657944	PRJNA839281_S_NODE_13984_length_215_cov_1.222892_g13715_i0	PRJNA839281	13984	215	1.222892	2.6292178	Pahexavirus P91	1982260	Viruses	Viruses	390	3.54e-104	NTclustered	gi\|408905829\|ref\|NC_018834.1\|	1229782	g13715	i0	99.533	98.7813953488372	214	1	99	0	1	214	17500	17713	Propionibacterium phage P9.1, complete genome	blastn	21238	390	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus P91
4658157	4658157	PRJNA839281_S_NODE_29484_length_165_cov_1.362069_g29215_i0	PRJNA839281	29484	165	1.362069	2.24741385	Caudoviricetes sp.	2832643	Viruses	Viruses	287	3.47e-73	NTclustered	gi\|2053100536\|tpg\|BK020490.1\|	2832643	g29215	i0	98.171	1.98787878787879	164	3	99	0	1	164	12102	12265	MAG TPA_asm: Caudoviricetes sp. isolate ctziT1, partial genome	blastn	328	287	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5058414	5058414	PRJNA839281_S_NODE_7844_length_286_cov_1.713080_g7575_i0	PRJNA839281	7844	286	1.71308	4.8994088	Salasvirus	186846	Viruses	Viruses	518	2.17e-142	NTclustered	gi\|1882288612\|ref\|NC_049965.1\|	2022474	g7575	i0	99.301	18.6958041958042	286	2	100	0	1	286	2635	2350	Bacillus phage vB_BveP-Goe6, complete genome	blastn	5347	523	0.990439770554493	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Salasmaviridae	Salasvirus	Salasvirus Goe6
5932915	5932915	PRJNA839281_S_NODE_28385_length_166_cov_0.871795_g28116_i0	PRJNA839281	28385	166	0.871795	1.4471797	Caudoviricetes sp.	2832643	Viruses	Viruses	307	2.69e-79	NTclustered	gi\|2058123527\|tpg\|BK033972.1\|	2832643	g28116	i0	100	1	166	0	100	0	1	166	38492	38657	MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome	blastn	166	307	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7608355	7608355	PRJNA839281_S_NODE_20226_length_185_cov_1.441176_g19957_i0	PRJNA839281	20226	185	1.441176	2.6661756	root	1	Root_unresolved	Root_unresolved	333	5.039999999999999e-87	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g19957	i0	99.454	98.8054054054054	183	1	99	0	3	185	18207	18389	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	18279	333	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
8482619	8482619	PRJNA839281_S_NODE_32307_length_164_cov_0.886957_g32038_i0	PRJNA839281	32307	164	0.886957	1.45460948	Caudoviricetes sp.	2832643	Viruses	Viruses	274	2.68e-69	NTclustered	gi\|2054665279\|tpg\|BK052293.1\|	2832643	g32038	i0	96.933	1.98170731707317	163	5	99	0	2	164	13810	13972	MAG TPA_asm: Caudoviricetes sp. isolate ctGk85, partial genome	blastn	325	274	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11033403	11033403	PRJNA839281_S_NODE_22989_length_176_cov_1.622047_g22720_i0	PRJNA839281	22989	176	1.622047	2.85480272	Salasvirus phi29	10756	Viruses	Viruses	326	7.92e-85	NTclustered	gi\|15659\|emb\|V01155.1\|	2884424	g22720	i0	100	17.9318181818182	176	0	100	0	1	176	2295	2470	Left end of bacteriophage phi-29 coding for 15 potential proteins Among these are the terminal protein and the proteins encoded by the genes 1, 2 (sus), 3, and (probably) 4	blastn	3156	326	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Salasmaviridae	Salasvirus	Salasvirus phi29
11434191	11434191	PRJNA839281_S_NODE_33769_length_163_cov_0.894737_g33500_i0	PRJNA839281	33769	163	0.894737	1.45842131	Viruses	10239	Viruses	Viruses	165	1.67e-36	NTclustered	gi\|823079719\|gb\|KR093628.1\|	1647550	g33500	i0	90.551	2.93251533742331	127	8	77	4	1	125	9862	9738	Moraxella phage Mcat4, complete genome	blastn	478	165	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Moraxella phage Mcat4
12308937	12308937	PRJNA839281_S_NODE_29590_length_165_cov_1.206897_g29321_i0	PRJNA839281	29590	165	1.206897	1.99138005	Inoviridae sp.	2219103	Viruses	Viruses	132	1.72e-26	NTclustered	gi\|2053040871\|tpg\|BK024249.1\|	2219103	g29321	i0	83.333	0.872727272727273	144	22	87	2	23	165	9942	9800	MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome	blastn	144	132	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
13583406	13583406	PRJNA839281_S_NODE_28831_length_166_cov_0.871795_g28562_i0	PRJNA839281	28831	166	0.871795	1.4471797	Caudoviricetes sp.	2832643	Viruses	Viruses	254	3.55e-63	NTclustered	gi\|2914840405\|gb\|OR222837.1\|	2832643	g28562	i0	95.062	0.975903614457831	162	7	98	1	1	162	17915	17755	MAG: Caudoviricetes sp. isolate MSP0518 genomic sequence	blastn	162	254	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13583477	13583477	PRJNA839281_S_NODE_34311_length_163_cov_0.894737_g34042_i0	PRJNA839281	34311	163	0.894737	1.45842131	Caudoviricetes sp.	2832643	Viruses	Viruses	191	2.76e-44	NTclustered	gi\|2915011501\|gb\|OR222465.1\|	2832643	g34042	i0	87.73	1	163	20	100	0	1	163	11514	11676	MAG: Caudoviricetes sp. isolate MSP0923 genomic sequence	blastn	163	191	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13583508	13583508	PRJNA839281_S_NODE_37031_length_161_cov_0.910714_g36762_i0	PRJNA839281	37031	161	0.910714	1.46624954	Caudoviricetes sp.	2832643	Viruses	Viruses	292	7.24e-75	NTclustered	gi\|2914875393\|gb\|OR221562.1\|	2832643	g36762	i0	99.379	1	161	1	100	0	1	161	18235	18395	MAG: Caudoviricetes sp. isolate MSP1502 genomic sequence	blastn	161	292	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14857810	14857810	PRJNA839281_S_NODE_38052_length_161_cov_0.901786_g37783_i0	PRJNA839281	38052	161	0.901786	1.45187546	Salasvirus phi29	10756	Viruses	Viruses	222	9.63e-54	NTclustered	gi\|15731\|emb\|X53371.1\|	2884424	g37783	i0	100	14.0993788819876	120	0	75	0	42	161	1728	1609	Bacteriophage phi29 temperature sensitive mutant TS2(24) DNA polymerase gene	blastn	2270	222	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Salasmaviridae	Salasvirus	Salasvirus phi29
16132227	16132227	PRJNA839281_S_NODE_16853_length_199_cov_1.960000_g16584_i0	PRJNA839281	16853	199	1.96	3.9004	Betacoronavirus pandemicum	3418604	Viruses	Viruses	54.7	0.005	NTclustered	gi\|2156866290\|gb\|OL674078.1\|	694009	g16584	i0	100	0.14572864321608	29	0	15	0	168	196	29716	29688	Severe acute respiratory syndrome-related coronavirus isolate Rs7921, complete genome	blastn	29	54.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
17408091	17408091	PRJNA839281_S_NODE_37994_length_161_cov_0.910714_g37725_i0	PRJNA839281	37994	161	0.910714	1.46624954	Pahexavirus pirate	1982303	Viruses	Viruses	298	1.56e-76	NTclustered	gi\|1725329241\|ref\|NC_027623.2\|	1655018	g37725	i0	100	99.9192546583851	161	0	100	0	1	161	8597	8757	Propionibacterium phage Pirate, complete genome	blastn	16087	298	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus pirate
17408094	17408094	PRJNA839281_S_NODE_38134_length_161_cov_0.866071_g37865_i0	PRJNA839281	38134	161	0.866071	1.39437431	Caudoviricetes sp.	2832643	Viruses	Viruses	254	3.42e-63	NTclustered	gi\|2059893405\|tpg\|BK041203.1\|	2832643	g37865	i0	95.031	2	161	8	100	0	1	161	4102	4262	MAG TPA_asm: Caudoviricetes sp. isolate ctzTc7, partial genome	blastn	322	254	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19081854	19081854	PRJNA839281_S_NODE_12715_length_224_cov_1.748571_g12446_i0	PRJNA839281	12715	224	1.748571	3.91679904	Salasvirus	186846	Viruses	Viruses	414	2.1999999999999996e-111	NTclustered	gi\|15733\|emb\|X53370.1\|	2884424	g12446	i0	100	18	224	0	100	0	1	224	1214	991	Bacteriophage phi29 temperature sensitive mutant TS2(98) DNA polymerase gene	blastn	4032	414	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Salasmaviridae	Salasvirus	Salasvirus phi29
19956321	19956321	PRJNA839281_S_NODE_4936_length_402_cov_2.524079_g4667_i0	PRJNA839281	4936	402	2.524079	10.14679758	Salasvirus phi29	10756	Viruses	Viruses	743	0	NTclustered	gi\|15731\|emb\|X53371.1\|	2884424	g4667	i0	100	18.3805970149254	402	0	100	0	1	402	1203	1604	Bacteriophage phi29 temperature sensitive mutant TS2(24) DNA polymerase gene	blastn	7389	743	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Salasmaviridae	Salasvirus	Salasvirus phi29
20356731	20356731	PRJNA839281_S_NODE_29396_length_165_cov_2.060345_g29127_i0	PRJNA839281	29396	165	2.060345	3.39956925	Viruses	10239	Viruses	Viruses	300	4.46e-77	NTclustered	gi\|2287983993\|gb\|ON778006.1\|	2961987	g29127	i0	99.394	32	165	1	100	0	1	165	12182	12346	Pseudomonas phage vB_Pae_HB2107-3I, complete genome	blastn	5280	300	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage vB_Pae_HB2107-3I
22506581	22506581	PRJNA839281_S_NODE_30718_length_165_cov_0.879310_g30449_i0	PRJNA839281	30718	165	0.87931	1.4508615	Gammaretrovirus murleu	3428959	Viruses	Viruses	278	2.09e-70	NTclustered	gi\|18448741\|gb\|AF462057.1\|	11801	g30449	i0	97.531	98.569696969697	162	4	98	0	4	165	3238	3077	Moloney murine leukemia virus neuropathogenic variant ts1-92b, complete genome	blastn	16264	278	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
22506647	22506647	PRJNA839281_S_NODE_35438_length_162_cov_0.902655_g35169_i0	PRJNA839281	35438	162	0.902655	1.4623011	Caudoviricetes sp.	2832643	Viruses	Viruses	239	9.64e-59	NTclustered	gi\|2914915550\|gb\|OR221273.1\|	2832643	g35169	i0	93.21	2	162	11	100	0	1	162	20422	20583	MAG: Caudoviricetes sp. isolate MSP1835 genomic sequence	blastn	324	239	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23782100	23782100	PRJNA839281_S_NODE_32119_length_164_cov_0.886957_g31850_i0	PRJNA839281	32119	164	0.886957	1.45460948	Caudoviricetes sp.	2832643	Viruses	Viruses	209	7.68e-50	NTclustered	gi\|2914984909\|gb\|OR222109.1\|	2832643	g31850	i0	89.634	1	164	17	100	0	1	164	57176	57339	MAG: Caudoviricetes sp. isolate MSP0001 genomic sequence	blastn	164	209	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;