metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Nucleocytoviricota"

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
298614	298614	PRJNA1148190_P_NODE_658681_length_247_cov_1.316092_g647508_i0	PRJNA1148190	658681	247	1.316092	3.25074724	Biavirus raunefjordenense	3059777	Viruses	Viruses	102	2.19e-17	NTclustered	gi\|2500387999\|ref\|NC_077221.1\|	1499987	g647508	i0	96.721	2.12955465587045	61	2	25	0	67	127	1393485	1393425	Prymnesium kappa virus genome assembly, chromosome: 1	blastn	526	102	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae	Biavirus	Biavirus raunefjordenense
2845464	2845464	PRJNA1148190_P_NODE_360643_length_297_cov_0.852679_g349470_i0	PRJNA1148190	360643	297	0.852679	2.53245663	Moumouvirus australiense	3080759	Viruses	Viruses	58.4	5.93e-4	NTclustered	gi\|2500366567\|ref\|NC_075368.1\|	2109587	g349470	i0	100	0.208754208754209	31	0	10	0	259	289	679254	679224	Moumouvirus australiensis isolate 10A, complete genome	blastn	62	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus australiense
2849410	2849410	PRJNA1148190_P_NODE_650463_length_248_cov_0.880000_g639290_i0	PRJNA1148190	650463	248	0.88	2.1824	Marseillevirus LCMAC101	2506602	Viruses	Viruses	62.1	3.73e-5	NTclustered	gi\|1588059154\|gb\|MK500328.1\|	2506602	g639290	i0	94.872	8.76612903225806	39	2	16	0	202	240	145309	145347	MAG: Marseillevirus LCMAC101, sequence	blastn	2174	62.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
4118004	4118004	PRJNA1148190_P_NODE_137244_length_449_cov_1.542553_g126079_i0	PRJNA1148190	137244	449	1.542553	6.92606297	Catovirus CTV1	1977631	Viruses	Viruses	52.8	0.043	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g126079	i0	100	0.0623608017817372	28	0	6	0	39	66	835652	835679	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
4124813	4124813	PRJNA1148190_P_NODE_59984_length_741_cov_4.435629_g48995_i0	PRJNA1148190	59984	741	4.435629	32.86801089	Mimivirus U306	1932880	Viruses	Viruses	62.1	1.23e-4	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g48995	i0	100	0.257759784075574	33	0	4	0	3	35	238728	238760	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	191	62.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306
5395388	5395388	PRJNA1148190_P_NODE_205885_length_372_cov_1.227425_g194715_i0	PRJNA1148190	205885	372	1.227425	4.566021	Epsilonentomopoxvirus dlongicaudata	3428560	Viruses	Viruses	60.2	2.11e-4	NTclustered	gi\|2500377030\|ref\|NC_076102.1\|	109981	g194715	i0	97.143	0.352150537634409	35	1	9	0	246	280	175286	175320	Diachasmimorpha longicaudata entomopoxvirus, complete genome	blastn	131	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Epsilonentomopoxvirus	Epsilonentomopoxvirus dlongicaudata
5400719	5400719	PRJNA1148190_P_NODE_577165_length_252_cov_1.262570_g565992_i0	PRJNA1148190	577165	252	1.26257	3.1816764	Chlorovirus sp.	2809302	Viruses	Viruses	108	4.81e-19	NTclustered	gi\|2719864549\|gb\|PP681909.1\|	2809302	g565992	i0	92.208	7.65476190476191	77	4	31	2	105	181	185336	185262	Chlorovirus sp. isolate OSyNE-4B-M2, complete genome	blastn	1929	108	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
5401227	5401227	PRJNA1148190_P_NODE_6185_length_4781_cov_6.723874_g2976_i0	PRJNA1148190	6185	4781	6.723874	321.46841594	Hokovirus HKV1	1977638	Viruses	Viruses	58.4	0.011	NTclustered	gi\|1174572331\|gb\|KY684107.1\|	1977638	g2976	i0	88.235	0.0106672244300356	51	2	1	3	1200	1250	25367	25321	Hokovirus HKV1 Hokovirus_5 genomic sequence, sequence	blastn	51	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
6676346	6676346	PRJNA1148190_P_NODE_644306_length_248_cov_0.880000_g633133_i0	PRJNA1148190	644306	248	0.88	2.1824	Bathycoccus sp. RCC1105 virus BpV	933845	Viruses	Viruses	52.8	0.022	NTclustered	gi\|313767999\|ref\|NC_014765.1\|	880159	g633133	i0	100	0.112903225806452	28	0	11	0	197	224	20605	20632	Bathycoccus sp. RCC1105 virus BpV1, complete genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Bathycoccus sp. RCC1105 virus BpV
9219105	9219105	PRJNA1148190_P_NODE_14028_length_2484_cov_8.627126_g2158_i2	PRJNA1148190	14028	2484	8.627126	214.29780984	Theiavirus salishense	3060737	Viruses	Viruses	67.6	9.2e-6	NTclustered	gi\|2500354595\|ref\|NC_075036.1\|	2024608	g2158	i2	88.889	0.0938003220611916	54	6	8	0	401	454	1313667	1313614	Bodo saltans virus strain NG1, complete genome	blastn	233	67.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
9220518	9220518	PRJNA1148190_P_NODE_220028_length_361_cov_2.385417_g208858_i0	PRJNA1148190	220028	361	2.385417	8.61135537	Yellowstone lake phycodnavirus 1	1586713	Viruses	Viruses	78.7	5.65e-10	NTclustered	gi\|941356238\|dbj\|LC015647.1\|	1586713	g208858	i0	88.889	2.85041551246537	63	7	17	0	63	125	61116	61054	Yellowstone lake phycodnavirus 1 DNA, complete genome, isolate: 1	blastn	1029	78.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Yellowstone lake phycodnavirus 1
9222606	9222606	PRJNA1148190_P_NODE_356608_length_298_cov_1.368889_g345435_i0	PRJNA1148190	356608	298	1.368889	4.07928922	Betaentomopoxvirus crosaceana	3427229	Viruses	Viruses	189	2.02e-43	NTclustered	gi\|506498610\|ref\|NC_021249.1\|	1293539	g345435	i0	79.004	1.8255033557047	281	55	94	3	17	296	22660	22937	Choristoneura rosaceana entomopoxvirus 'L', complete genome	blastn	544	189	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus crosaceana
10499366	10499366	PRJNA1148190_P_NODE_436829_length_279_cov_1.266990_g425656_i0	PRJNA1148190	436829	279	1.26699	3.5349021	Moumouvirus sp. 'Monve'	1128131	Viruses	Viruses	52.8	0.026	NTclustered	gi\|371944392\|gb\|JN885995.1\|	1128131	g425656	i0	100	0.100358422939068	28	0	10	0	181	208	31184	31157	Moumouvirus Monve isolate Mv13-mv, partial genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
10499488	10499488	PRJNA1148190_P_NODE_4449_length_6069_cov_6.476484_g2158_i0	PRJNA1148190	4449	6069	6.476484	393.05781396	Theiavirus salishense	3060737	Viruses	Viruses	73.1	4.87e-7	NTclustered	gi\|2500354595\|ref\|NC_075036.1\|	2024608	g2158	i0	90.741	0.0970505849398583	54	5	6	0	4373	4426	63495	63548	Bodo saltans virus strain NG1, complete genome	blastn	589	73.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
10501117	10501117	PRJNA1148190_P_NODE_560609_length_255_cov_1.302198_g549436_i0	PRJNA1148190	560609	255	1.302198	3.3206049	Epsilonentomopoxvirus dlongicaudata	3428560	Viruses	Viruses	60.2	1.38e-4	NTclustered	gi\|2500377030\|ref\|NC_076102.1\|	109981	g549436	i0	92.857	1.73333333333333	42	2	16	1	58	98	1112	1153	Diachasmimorpha longicaudata entomopoxvirus, complete genome	blastn	442	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Epsilonentomopoxvirus	Epsilonentomopoxvirus dlongicaudata
10501530	10501530	PRJNA1148190_P_NODE_589489_length_251_cov_0.865169_g578316_i0	PRJNA1148190	589489	251	0.865169	2.17157419	Hokovirus HKV1	1977638	Viruses	Viruses	322	1.57e-83	NTclustered	gi\|1174571674\|gb\|KY684104.1\|	1977638	g578316	i0	90	0.99601593625498	250	23	99	2	1	249	208829	208581	Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence	blastn	250	322	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
11769190	11769190	PRJNA1148190_P_NODE_11110_length_3010_cov_6.892067_g2976_i1	PRJNA1148190	11110	3010	6.892067	207.4512167	Hokovirus HKV1	1977638	Viruses	Viruses	58.4	0.007	NTclustered	gi\|1174572331\|gb\|KY684107.1\|	1977638	g2976	i1	88.235	0.0169435215946844	51	2	2	3	1761	1811	25321	25367	Hokovirus HKV1 Hokovirus_5 genomic sequence, sequence	blastn	51	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
13047451	13047451	PRJNA1148190_P_NODE_311651_length_315_cov_1.272727_g300478_i0	PRJNA1148190	311651	315	1.272727	4.00909005	Cotonvirus japonicum	3059904	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2500766720\|ref\|NC_079139.1\|	2811091	g300478	i0	96.97	0.104761904761905	33	1	10	0	232	264	687473	687441	Cotonvirus japonicus DNA, complete genome	blastn	33	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
13051726	13051726	PRJNA1148190_P_NODE_620351_length_249_cov_1.312500_g609178_i0	PRJNA1148190	620351	249	1.3125	3.268125	Betaentomopoxvirus cbiennis	3427227	Viruses	Viruses	108	4.74e-19	NTclustered	gi\|502523787\|emb\|HF679132.1\|	10288	g609178	i0	79.866	2.39357429718876	149	29	60	1	50	198	22253	22400	Choristoneura biennis entomopoxvirus 'L', complete genome	blastn	596	108	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus cbiennis
13053390	13053390	PRJNA1148190_P_NODE_751931_length_242_cov_2.573964_g740758_i0	PRJNA1148190	751931	242	2.573964	6.22899288	Terrestrivirus sp.	2487775	Viruses	Viruses	52.8	0.022	NTclustered	gi\|1512470939\|gb\|MK071981.1\|	2487775	g740758	i0	94.286	0.144628099173554	35	1	14	1	202	236	139163	139130	MAG: Terrestrivirus sp. clone Terrestrivirus_3 genomic sequence	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
14325453	14325453	PRJNA1148190_P_NODE_497892_length_267_cov_1.340206_g486719_i0	PRJNA1148190	497892	267	1.340206	3.57835002	Chlorella virus XW01	2922419	Viruses	Viruses	52.8	0.024	NTclustered	gi\|2200493011\|gb\|OL828820.1\|	2922419	g486719	i0	100	0.104868913857678	28	0	10	0	227	254	69126	69099	Chlorella virus XW01, complete genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Chlorella virus XW01
14325576	14325576	PRJNA1148190_P_NODE_505792_length_265_cov_2.005208_g494619_i0	PRJNA1148190	505792	265	2.005208	5.3138012	Megavirus courdo7	1128135	Viruses	Viruses	54.7	0.007	NTclustered	gi\|371944095\|gb\|JN885992.1\|	1128135	g494619	i0	100	0.109433962264151	29	0	11	0	23	51	80281	80309	Megavirus courdo7 isolate Mv13-c7, partial genome	blastn	29	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus courdo7
14328142	14328142	PRJNA1148190_P_NODE_700172_length_245_cov_0.895349_g688999_i0	PRJNA1148190	700172	245	0.895349	2.19360505	Ostreococcus tauri virus 19-T2	3378374	Viruses	Viruses	62.1	3.67e-5	NTclustered	gi\|2853282120\|gb\|PQ442278.1\|	3378374	g688999	i0	94.872	0.159183673469388	39	2	16	0	35	73	61830	61792	Ostreococcus tauri virus 19-T2, complete genome	blastn	39	62.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus tauri virus 19-T2
14328842	14328842	PRJNA1148190_P_NODE_756392_length_242_cov_1.366864_g745219_i0	PRJNA1148190	756392	242	1.366864	3.30781088	Diabrotica toursvirus 3a	2935083	Viruses	Viruses	86.1	2.15e-12	NTclustered	gi\|2223912418\|gb\|OM891062.1\|	2935083	g745219	i0	97.959	3.53305785123967	49	1	20	0	1	49	2337	2385	MAG: Diabrotica toursvirus 3a isolate Ames, Iowa clone fragment14 genomic sequence	blastn	855	86.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Ascoviridae	Toursvirus	Diabrotica toursvirus 3a
15595331	15595331	PRJNA1148190_P_NODE_22213_length_1673_cov_3.964375_g13759_i0	PRJNA1148190	22213	1673	3.964375	66.32399375	Chlorovirus sp.	2809302	Viruses	Viruses	1238	0	NTclustered	gi\|2719855753\|gb\|PP681887.1\|	2809302	g13759	i0	87.442	4.03466826060968	1075	135	64	0	405	1479	33807	34881	Chlorovirus sp. isolate O-NE-11, complete genome	blastn	6750	1238	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
19423512	19423512	PRJNA1148190_P_NODE_560656_length_255_cov_1.296703_g549483_i0	PRJNA1148190	560656	255	1.296703	3.30659265	Marseillevirus LCMAC202	2506606	Viruses	Viruses	60.2	1.38e-4	NTclustered	gi\|1588061053\|gb\|MK500369.1\|	2506606	g549483	i0	94.737	1.46666666666667	38	2	15	0	87	124	84729	84692	MAG: Marseillevirus LCMAC202, sequence	blastn	374	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC202
24517252	24517252	PRJNA1148190_P_NODE_154080_length_423_cov_3.345714_g142913_i0	PRJNA1148190	154080	423	3.345714	14.15237022	Hokovirus HKV1	1977638	Viruses	Viruses	56.5	0.003	NTclustered	gi\|1174571316\|gb\|KY684103.1\|	1977638	g142913	i0	100	0.0709219858156028	30	0	7	0	227	256	271885	271914	Hokovirus HKV1 isolate HKV1 clone Hokovirus_1, sequence	blastn	30	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
24523174	24523174	PRJNA1148190_P_NODE_5520_length_5216_cov_6.765895_g2158_i1	PRJNA1148190	5520	5216	6.765895	352.9090832	Theiavirus salishense	3060737	Viruses	Viruses	67.6	1.95e-5	NTclustered	gi\|2500354595\|ref\|NC_075036.1\|	2024608	g2158	i1	91.667	0.0262653374233129	48	4	3	0	1827	1874	58182	58135	Bodo saltans virus strain NG1, complete genome	blastn	137	67.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense

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