metadata: contig_metadata: 32 rows where bioproject = "PRJNA1129273" and tax

32 rows where bioproject = "PRJNA1129273" 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
283261	283261	PRJNA1129273_P_NODE_5061_length_316_cov_1.172840_g4781_i0	PRJNA1129273	5061	316	1.17284	3.7061744	Augustepiccardvirus augustepiccard	3426500	Viruses	Viruses	429	1.17e-115	NTclustered	gi\|2071739426\|gb\|MZ501051.1\|	2851954	g4781	i0	91.374	54.4050632911392	313	27	99	0	2	314	19375	19063	Escherichia phage AugustePiccard strain Bas01, complete genome	blastn	17192	429	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae	Augustepiccardvirus	Augustepiccardvirus augustepiccard
4110257	4110257	PRJNA1129273_P_NODE_3324_length_404_cov_2.782477_g3045_i0	PRJNA1129273	3324	404	2.782477	11.24120708	Soybean thrips dicistrovirus 1	2797876	Viruses	Viruses	263	1.64e-65	NTclustered	gi\|1954985862\|gb\|MT195550.1\|	2797876	g3045	i0	78.803	0.992574257425743	401	77	98	7	8	404	7182	6786	Soybean thrips dicistrovirus 1 strain STN1, complete genome	blastn	401	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Soybean thrips dicistrovirus 1
4110292	4110292	PRJNA1129273_P_NODE_8064_length_258_cov_1.081081_g7784_i0	PRJNA1129273	8064	258	1.081081	2.78918898	Veterinaerplatzvirus SU57	3433204	Viruses	Viruses	418	2.0099999999999995e-112	NTclustered	gi\|1867204057\|gb\|MT511058.1\|	2743969	g7784	i0	96.094	58.5	256	10	99	0	2	257	16854	16599	Escherichia phage vB_EcoD_SU57, complete genome	blastn	15093	418	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae	Veterinaerplatzvirus	Veterinaerplatzvirus SU57
5386428	5386428	PRJNA1129273_P_NODE_10525_length_242_cov_0.923077_g10245_i0	PRJNA1129273	10525	242	0.923077	2.23384634	Pseudomonas phage D6	3025445	Viruses	Viruses	237	5.61e-58	NTclustered	gi\|2449456336\|gb\|OQ363659.1\|	3025445	g10245	i0	85.714	0.925619834710744	224	32	93	0	18	241	266046	266269	Pseudomonas phage D6, complete genome	blastn	224	237	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage D6
6661121	6661121	PRJNA1129273_P_NODE_4786_length_326_cov_1.221344_g4506_i0	PRJNA1129273	4786	326	1.221344	3.98158144	Zebrafish picornavirus 1	2304617	Viruses	Viruses	569	6.839999999999998e-158	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g4506	i0	98.452	2.95705521472393	323	5	99	0	4	326	719	397	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	964	569	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6661172	6661172	PRJNA1129273_P_NODE_9966_length_245_cov_0.883721_g9686_i0	PRJNA1129273	9966	245	0.883721	2.16511645	Veterinaerplatzvirus FP	3433202	Viruses	Viruses	374	4.16e-99	NTclustered	gi\|1867199596\|gb\|MT682706.1\|	2750857	g9686	i0	94.262	62.8530612244898	244	14	99	0	1	244	31898	32141	Escherichia phage vB_EcoS_FP, complete genome	blastn	15399	374	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae	Veterinaerplatzvirus	Veterinaerplatzvirus FP
9211267	9211267	PRJNA1129273_P_NODE_5948_length_289_cov_2.800926_g5668_i0	PRJNA1129273	5948	289	2.800926	8.09467614	Suseptimavirus ECBP2	3052757	Viruses	Viruses	466	8.06e-127	NTclustered	gi\|408905854\|ref\|NC_018859.1\|	1604355	g5668	i0	95.833	12.7820069204152	288	12	99	0	1	288	28580	28867	Escherichia phage ECBP2, complete genome	blastn	3694	466	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Suseptimavirus	Suseptimavirus ECBP2
9959780	9959780	PRJNA1129273_P_NODE_5128_length_313_cov_1.908333_g4848_i0	PRJNA1129273	5128	313	1.908333	5.97308229	Mktvariviridae	3424663	Viruses	Viruses	368	2.56e-97	NTclustered	gi\|2438101311\|ref\|NC_070983.1\|	2860374	g4848	i0	88.013	4.98402555910543	317	31	99	1	1	310	67966	68282	Escherichia phage IME267, complete genome	blastn	1560	368	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Suseptimavirus	Suseptimavirus IME267
10486754	10486754	PRJNA1129273_P_NODE_2249_length_526_cov_3.156733_g1973_i0	PRJNA1129273	2249	526	3.156733	16.60441558	Hubei picorna-like virus 14	1923093	Viruses	Viruses	394	7.44e-105	NTclustered	gi\|1132371418\|ref\|NC_033112.1\|	1923093	g1973	i0	80.539	1.97338403041825	519	95	98	6	5	520	1581	2096	Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds	blastn	1038	394	1	Viruses							Hubei picorna-like virus 14
10486763	10486763	PRJNA1129273_P_NODE_3349_length_402_cov_1.844985_g3070_i0	PRJNA1129273	3349	402	1.844985	7.4168397	Polycipiviridae sp.	2496155	Viruses	Viruses	52.8	0.039	NTclustered	gi\|2756421824\|gb\|PP744841.1\|	2496155	g3070	i0	90.244	0.101990049751244	41	3	10	1	296	335	9211	9171	MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence	blastn	41	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae		Polycipiviridae sp.
10486789	10486789	PRJNA1129273_P_NODE_7469_length_266_cov_1.196891_g7189_i0	PRJNA1129273	7469	266	1.196891	3.18373006	Hubei picorna-like virus 14	1923093	Viruses	Viruses	132	3.04e-26	NTclustered	gi\|1132371418\|ref\|NC_033112.1\|	1923093	g7189	i0	80.226	1.71052631578947	177	34	66	1	72	247	978	802	Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds	blastn	455	132	1	Viruses							Hubei picorna-like virus 14
13036946	13036946	PRJNA1129273_P_NODE_10831_length_237_cov_2.329268_g10551_i0	PRJNA1129273	10831	237	2.329268	5.52036516	Kuravirus SGF2	3060083	Viruses	Viruses	239	1.52e-58	NTclustered	gi\|2438101932\|ref\|NC_070988.1\|	2601630	g10551	i0	87.143	32.9746835443038	210	27	89	0	6	215	8080	7871	Shigella phage SGF2, complete genome	blastn	7815	239	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Kuravirus	Kuravirus SGF2
13036990	13036990	PRJNA1129273_P_NODE_7731_length_262_cov_1.629630_g7451_i0	PRJNA1129273	7731	262	1.62963	4.2696306	Suseptimavirus ECBP2	3052757	Viruses	Viruses	425	1.22e-114	NTclustered	gi\|408905854\|ref\|NC_018859.1\|	1604355	g7451	i0	96.154	10.9541984732824	260	10	99	0	2	261	57572	57313	Escherichia phage ECBP2, complete genome	blastn	2870	425	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Suseptimavirus	Suseptimavirus ECBP2
14312201	14312201	PRJNA1129273_P_NODE_5752_length_294_cov_1.733032_g5472_i0	PRJNA1129273	5752	294	1.733032	5.09511408	Suseptimavirus ECBP2	3052757	Viruses	Viruses	357	5.16e-94	NTclustered	gi\|408905854\|ref\|NC_018859.1\|	1604355	g5472	i0	88.699	13.8979591836735	292	33	99	0	2	293	16385	16676	Escherichia phage ECBP2, complete genome	blastn	4086	357	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Suseptimavirus	Suseptimavirus ECBP2
15586182	15586182	PRJNA1129273_P_NODE_4593_length_334_cov_1.467433_g4313_i0	PRJNA1129273	4593	334	1.467433	4.90122622	Hubei picorna-like virus 14	1923093	Viruses	Viruses	217	1.06e-51	NTclustered	gi\|1132371418\|ref\|NC_033112.1\|	1923093	g4313	i0	80.068	1.77245508982036	296	56	88	3	39	333	2806	3099	Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds	blastn	592	217	1	Viruses							Hubei picorna-like virus 14
16860417	16860417	PRJNA1129273_P_NODE_11094_length_228_cov_3.870968_g10814_i0	PRJNA1129273	11094	228	3.870968	8.82580704	Escherichia phage JeanPiccard	2851955	Viruses	Viruses	353	4.98e-93	NTclustered	gi\|2071744090\|gb\|MZ501080.1\|	2851955	g10814	i0	94.714	60.6578947368421	227	12	99	0	1	227	12186	11960	Escherichia phage JeanPiccard strain Bas02, complete genome	blastn	13830	353	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae		Escherichia phage JeanPiccard
17609348	17609348	PRJNA1129273_P_NODE_8054_length_258_cov_1.243243_g7774_i0	PRJNA1129273	8054	258	1.243243	3.20756694	Kuravirus	680277	Viruses	Viruses	464	2.5499999999999994e-126	NTclustered	gi\|2131271452\|gb\|OK148440.1\|	2875841	g7774	i0	99.222	11.9418604651163	257	2	99	0	2	258	54734	54478	Escherichia phage MLP3, complete genome	blastn	3081	464	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Kuravirus	Escherichia phage MLP3
19409181	19409181	PRJNA1129273_P_NODE_8596_length_251_cov_3.078652_g8316_i0	PRJNA1129273	8596	251	3.078652	7.72741652	Sopawad virus	3131649	Viruses	Viruses	366	7.15e-97	NTclustered	gi\|2717323044\|gb\|PP173950.1\|	3131649	g8316	i0	93.522	25.8446215139442	247	14	98	1	5	251	4090	4334	MAG: Sopawad virus isolate SP1A_k141_78953 genomic sequence	blastn	6487	366	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopawad virus
20684663	20684663	PRJNA1129273_P_NODE_2237_length_527_cov_2.218062_g1961_i0	PRJNA1129273	2237	527	2.218062	11.68918674	Hubei picorna-like virus 14	1923093	Viruses	Viruses	436	1.22e-117	NTclustered	gi\|1132371418\|ref\|NC_033112.1\|	1923093	g1961	i0	83.913	1.74573055028463	460	70	87	4	69	526	3606	3149	Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds	blastn	920	436	1	Viruses							Hubei picorna-like virus 14
20684670	20684670	PRJNA1129273_P_NODE_4257_length_349_cov_1.105072_g3977_i0	PRJNA1129273	4257	349	1.105072	3.85670128	Suseptimavirus SU7	3060723	Viruses	Viruses	616	9.32e-172	NTclustered	gi\|2438100929\|ref\|NC_070980.1\|	2849626	g3977	i0	98.563	12.9713467048711	348	5	99	0	1	348	68235	68582	Escherichia phage vB_EcoP_SU7, complete genome	blastn	4527	616	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Suseptimavirus	Suseptimavirus SU7
20684686	20684686	PRJNA1129273_P_NODE_6737_length_277_cov_0.867647_g6457_i0	PRJNA1129273	6737	277	0.867647	2.40338219	Nieuwekanaalvirus KBNP1711	3052361	Viruses	Viruses	411	3.649999999999999e-110	NTclustered	gi\|589892323\|ref\|NC_023593.1\|	1436889	g6457	i0	94.074	3.85559566787004	270	16	97	0	2	271	10994	10725	Escherichia phage KBNP1711, complete genome	blastn	1068	411	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Nieuwekanaalvirus	Nieuwekanaalvirus KBNP1711
24509214	24509214	PRJNA1129273_P_NODE_3640_length_383_cov_1.322581_g3360_i0	PRJNA1129273	3640	383	1.322581	5.06548523	Caudoviricetes sp.	2832643	Viruses	Viruses	538	2.3e-148	NTclustered	gi\|2914851513\|gb\|OR221600.1\|	2832643	g3360	i0	92.167	1	383	26	99	4	2	382	7070	6690	MAG: Caudoviricetes sp. isolate MSP1454 genomic sequence	blastn	383	538	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24509215	24509215	PRJNA1129273_P_NODE_3780_length_374_cov_1.966777_g3500_i0	PRJNA1129273	3780	374	1.966777	7.35574598	Suseptimavirus ECBP2	3052757	Viruses	Viruses	577	4.749999999999998e-160	NTclustered	gi\|408905854\|ref\|NC_018859.1\|	1604355	g3500	i0	94.851	49.7754010695187	369	19	99	0	2	370	34649	35017	Escherichia phage ECBP2, complete genome	blastn	18616	577	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Mktvariviridae	Suseptimavirus	Suseptimavirus ECBP2
27323232	27323232	PRJNA1129273_P_NODE_6043_length_288_cov_1.413953_g5763_i0	PRJNA1129273	6043	288	1.413953	4.07218464	Microbacterium phage Pumpernickel	2885983	Viruses	Viruses	50.1	4.84e-5	NR	YP_010755093.1	2885983	g5763	i0	88	0.260416666666667	25	3	26	0	76	2	1	25	YP_010755093.1 hypothetical protein QEH42_gp062 [Microbacterium phage Pumpernickel]	diamond	75	50.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pumpernickelvirus	Pumpernickelvirus pumpernickel
27765490	27765490	PRJNA1129273_P_NODE_10764_length_239_cov_2.090361_g10484_i0	PRJNA1129273	10764	239	2.090361	4.99596279	Hubei picorna-like virus 14	1923093	Viruses	Viruses	110	5.12e-26	NR	YP_009337314.1	1923093	g10484	i0	67.9	0.97907949790795	78	25	97.9	0	1	234	647	724	YP_009337314.1 hypothetical protein 2 [Hubei picorna-like virus 14]	diamond	234	110	1	Viruses							Hubei picorna-like virus 14
28080930	28080930	PRJNA1129273_P_NODE_7425_length_266_cov_2.362694_g7145_i0	PRJNA1129273	7425	266	2.362694	6.28476604	Hubei picorna-like virus 14	1923093	Viruses	Viruses	139	5.71e-36	NR	YP_009337313.1	1923093	g7145	i0	88	0.845864661654135	75	9	84.6	0	227	3	1206	1280	YP_009337313.1 hypothetical protein 1 [Hubei picorna-like virus 14]	diamond	225	139	1	Viruses							Hubei picorna-like virus 14
28112497	28112497	PRJNA1129273_P_NODE_2905_length_441_cov_1.524457_g2626_i0	PRJNA1129273	2905	441	1.524457	6.72285537	Hubei picorna-like virus 14	1923093	Viruses	Viruses	267	9.09e-80	NR	YP_009337313.1	1923093	g2626	i0	85.6	0.993197278911565	146	21	99.3	0	1	438	1514	1659	YP_009337313.1 hypothetical protein 1 [Hubei picorna-like virus 14]	diamond	438	267	1	Viruses							Hubei picorna-like virus 14
28523177	28523177	PRJNA1129273_P_NODE_7367_length_267_cov_1.582474_g7087_i0	PRJNA1129273	7367	267	1.582474	4.22520558	Hubei picorna-like virus 14	1923093	Viruses	Viruses	167	4.14e-46	NR	YP_009337314.1	1923093	g7087	i0	89.8	0.98876404494382	88	9	98.9	0	3	266	332	419	YP_009337314.1 hypothetical protein 2 [Hubei picorna-like virus 14]	diamond	264	167	1	Viruses							Hubei picorna-like virus 14
29123285	29123285	PRJNA1129273_P_NODE_9389_length_247_cov_1.787356_g9109_i0	PRJNA1129273	9389	247	1.787356	4.41476932	Arthrobacter phage 1191A	3053731	Viruses	Viruses	97.4	5.83e-23	NR	WJZ27838.1	3053731	g9109	i0	53.7	0.995951417004049	82	38	99.6	0	1	246	51	132	WJZ27838.1 DNA invertase [Arthrobacter phage 1191A]	diamond	246	97.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Arthrobacter phage 1191A
29280685	29280685	PRJNA1129273_P_NODE_2029_length_561_cov_1.331967_g1755_i0	PRJNA1129273	2029	561	1.331967	7.47233487	Hubei picorna-like virus 14	1923093	Viruses	Viruses	240	1.55e-69	NR	YP_009337313.1	1923093	g1755	i0	62.6	1	187	69	99.5	1	2	559	702	888	YP_009337313.1 hypothetical protein 1 [Hubei picorna-like virus 14]	diamond	561	240	1	Viruses							Hubei picorna-like virus 14
31133397	31133397	PRJNA1129273_P_NODE_10415_length_243_cov_0.894118_g10135_i0	PRJNA1129273	10415	243	0.894118	2.17270674	Ophiovirus	88129	Viruses	Viruses	108	2.56e-26	NR	UYD21356.1	2979639	g10135	i0	58	2	81	34	100	0	1	243	102	182	UYD21356.1 hypothetical protein [Colletotrichum associated negative-sense single-stranded RNA virus 2]	diamond	486	108	1	Viruses	Orthornavirae	Negarnaviricota					Colletotrichum associated negative-sense single-stranded RNA virus 2
31429113	31429113	PRJNA1129273_P_NODE_7096_length_271_cov_1.166667_g6816_i0	PRJNA1129273	7096	271	1.166667	3.16166757	Sphingomonas phage Scott	2282912	Viruses	Viruses	160	7.61e-47	NR	YP_009807879.1	2282912	g6816	i0	86.5	0.985239852398524	89	12	98.5	0	4	270	145	233	YP_009807879.1 DNA ligase [Sphingomonas phage Scott]	diamond	267	160	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autonotataviridae	Scottvirus	Scottvirus scott

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