metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA980587" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA980587" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26677720	26677720	PRJNA980587_P_NODE_51321_length_321_cov_1.004032_g50528_i0	PRJNA980587	51321	321	1.004032	3.22294272	Edafosvirus sp.	2487765	Viruses	Viruses	48.1	7.52e-4	NR	AYV78627.1	2487765	g50528	i0	40.6	0.598130841121495	64	38	59.8	0	318	127	135	198	AYV78627.1 MAG: hypothetical protein Edafosvirus21_6 [Edafosvirus sp.]	diamond	192	48.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
27468733	27468733	PRJNA980587_P_NODE_27743_length_463_cov_2.256410_g26950_i0	PRJNA980587	27743	463	2.25641	10.4471783	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	89.7	1.6e-17	NR	QIG59935.1	2704072	g26950	i0	50	0.544276457883369	84	37	53.1	3	218	463	312	392	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	252	89.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
27690031	27690031	PRJNA980587_P_NODE_27784_length_463_cov_1.371795_g26991_i0	PRJNA980587	27784	463	1.371795	6.35141085	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	129	1.3099999999999998e-31	NR	QIG59935.1	2704072	g26991	i0	40.8	1.01727861771058	157	80	99.1	4	3	461	331	478	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	471	129	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
28037069	28037069	PRJNA980587_P_NODE_13565_length_729_cov_2.411585_g12819_i0	PRJNA980587	13565	729	2.411585	17.58045465	Edafosvirus sp.	2487765	Viruses	Viruses	65.9	5.12e-9	NR	AYV78627.1	2487765	g12819	i0	37.4	0.473251028806584	115	71	47.3	1	689	345	85	198	AYV78627.1 MAG: hypothetical protein Edafosvirus21_6 [Edafosvirus sp.]	diamond	345	65.9	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
28131842	28131842	PRJNA980587_P_NODE_70965_length_267_cov_2.041237_g70172_i0	PRJNA980587	70965	267	2.041237	5.45010279	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	86.7	1.83e-17	NR	QIG59935.1	2704072	g70172	i0	42.2	1.01123595505618	90	50	100	2	1	267	319	407	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	270	86.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
28479025	28479025	PRJNA980587_P_NODE_55886_length_306_cov_1.060086_g55093_i0	PRJNA980587	55886	306	1.060086	3.24386316	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	122	6.27e-30	NR	XCM68104.1	3003959	g55093	i0	59.4	0.990196078431373	101	41	99	0	1	303	572	672	XCM68104.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	303	122	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29110587	29110587	PRJNA980587_P_NODE_78788_length_251_cov_0.865169_g77995_i0	PRJNA980587	78788	251	0.865169	2.17157419	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	91.7	7.99e-21	NR	YP_010804274.1	3060017	g77995	i0	53.1	0.968127490039841	81	37	95.6	1	249	10	53	133	YP_010804274.1 VWa domain-containing protein [Fadolivirus algeromassiliense]	diamond	243	91.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
30120863	30120863	PRJNA980587_P_NODE_74252_length_260_cov_1.363636_g73459_i0	PRJNA980587	74252	260	1.363636	3.5454536	Caudoviricetes sp.	2832643	Viruses	Viruses	71.2	2.49e-12	NR	XOR92109.1	2832643	g73459	i0	59.6	0.6	52	21	60	0	258	103	254	305	XOR92109.1 MAG: hypothetical protein MSP1531_38 [Caudoviricetes sp.]	diamond	156	71.2	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30342688	30342688	PRJNA980587_P_NODE_52772_length_316_cov_1.123457_g51979_i0	PRJNA980587	52772	316	1.123457	3.55012412	Pithovirus sibericum	1450746	Viruses	Viruses	75.5	2.95e-13	NR	YP_009000988.1	1450746	g51979	i0	45.9	1.35759493670886	74	39	69.3	1	2	220	1498	1571	YP_009000988.1 serine-threonine kinase [Pithovirus sibericum]	diamond	429	75.5	1	Viruses	Pithoviruses						Alphapithovirus	Alphapithovirus sibericum
30594800	30594800	PRJNA980587_P_NODE_73233_length_262_cov_1.629630_g72440_i0	PRJNA980587	73233	262	1.62963	4.2696306	Barrevirus sp.	2487763	Viruses	Viruses	53.1	6.19e-6	NR	AYV77273.1	2487763	g72440	i0	35.3	0.973282442748092	85	52	95	2	260	12	132	215	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	255	53.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
30594801	30594801	PRJNA980587_P_NODE_75213_length_258_cov_1.248649_g74420_i0	PRJNA980587	75213	258	1.248649	3.22151442	Tupanvirus deep ocean	2126984	Viruses	Viruses	42.4	0.0422	NR	YP_010781270.1	2126984	g74420	i0	37.7	0.709302325581395	61	34	70.9	1	11	193	11	67	YP_010781270.1 putative ORFan [Tupanvirus deep ocean]	diamond	183	42.4	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
31353446	31353446	PRJNA980587_P_NODE_74676_length_259_cov_1.424731_g73883_i0	PRJNA980587	74676	259	1.424731	3.69005329	uncultured virus	340016	Viruses	Viruses	80.9	1.67e-15	NR	CAK7994547.1	340016	g73883	i0	45.9	0.857142857142857	74	40	85.7	0	2	223	389	462	CAK7994547.1 Hypothetical protein POVR1_LOCUS71 [uncultured virus]	diamond	222	80.9	1	Viruses								uncultured virus
31480196	31480196	PRJNA980587_P_NODE_89216_length_244_cov_1.654971_g88423_i0	PRJNA980587	89216	244	1.654971	4.03812924	Soybean thrips virus 4	2796558	Viruses	Viruses	129	9.7e-33	NR	QPZ88419.1	2796558	g88423	i0	77.5	0.983606557377049	80	18	98.4	0	240	1	572	651	QPZ88419.1 NS3-like protein [Soybean thrips virus 4]	diamond	240	129	1	Viruses								Soybean thrips virus 4
31764552	31764552	PRJNA980587_P_NODE_24837_length_497_cov_3.351415_g24046_i0	PRJNA980587	24837	497	3.351415	16.65653255	Pithovirus LCPAC3	2506593	Viruses	Viruses	72.4	1.13e-12	NR	QBK91478.1	2506593	g24046	i0	31.8	1.55734406438632	154	94	91.8	4	481	26	2	146	QBK91478.1 MAG: hypothetical protein LCPAC302_00980 [Pithovirus LCPAC302]	diamond	774	72.4	1	Viruses	Pithoviruses							Pithovirus LCPAC302
31865353	31865353	PRJNA980587_P_NODE_52397_length_317_cov_1.262295_g51604_i0	PRJNA980587	52397	317	1.262295	4.00147515	root	1	Root_unresolved	Root_unresolved	59.7	9.8e-8	NR	QIG59935.1	2704072	g51604	i0	30.9	2.07255520504732	81	47	76.7	1	4	246	184	255	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	657	60.1	0.993344425956739	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
31985883	31985883	PRJNA980587_P_NODE_39978_length_369_cov_1.469595_g39185_i0	PRJNA980587	39978	369	1.469595	5.42280555	Harvfovirus sp.	2487768	Viruses	Viruses	77.4	1.55e-14	NR	AYV81585.1	2487768	g39185	i0	35.9	0.951219512195122	117	75	95.1	0	5	355	70	186	AYV81585.1 MAG: hypothetical protein Harvfovirus43_7 [Harvfovirus sp.]	diamond	351	77.4	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
31985888	31985888	PRJNA980587_P_NODE_73238_length_262_cov_1.629630_g72445_i0	PRJNA980587	73238	262	1.62963	4.2696306	Sylvanvirus sp.	2487774	Viruses	Viruses	43.9	0.0183	NR	AYV86560.1	2487774	g72445	i0	29.5	0.893129770992366	78	55	89.3	0	238	5	122	199	AYV86560.1 MAG: hypothetical protein Sylvanvirus3_14 [Sylvanvirus sp.]	diamond	234	43.9	1	Viruses								Sylvanvirus sp.
32239410	32239410	PRJNA980587_P_NODE_20658_length_558_cov_2.439175_g19870_i0	PRJNA980587	20658	558	2.439175	13.6105965	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	127	1.94e-30	NR	QIG59935.1	2704072	g19870	i0	41.3	0.741935483870968	138	72	73.7	3	412	2	257	386	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	414	127	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
32397491	32397491	PRJNA980587_P_NODE_75019_length_258_cov_1.664865_g74226_i0	PRJNA980587	75019	258	1.664865	4.2953517	Aquamicrobium phage P14	1927013	Viruses	Viruses	83.6	2.7e-18	NR	YP_009599026.1	1927013	g74226	i0	47.6	0.953488372093023	82	43	95.3	0	248	3	37	118	YP_009599026.1 tail fiber protein [Aquamicrobium phage P14]	diamond	246	83.6	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autonotataviridae	Aqualcavirus	Aqualcavirus P14
32807458	32807458	PRJNA980587_P_NODE_75600_length_257_cov_1.282609_g74807_i0	PRJNA980587	75600	257	1.282609	3.29630513	Adintovirus pavo15764	3115938	Viruses	Viruses	160	1.91e-43	NR	DBA50341.1	3115938	g74807	i0	83.5	2.97665369649805	85	14	99.2	0	256	2	696	780	DBA50341.1 MAG TPA_asm: PolBb [Adintovirus pavo15764]	diamond	765	161	0.993788819875776	Viruses		Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus pavo15764

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