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

25 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
5741628	5741628	PRJNA670521_P_NODE_42905_length_315_cov_0.954545_g42160_i0	PRJNA670521	42905	315	0.954545	3.00681675	Achromobacter phage JWF	1589748	Viruses	Viruses	361	4.3099999999999996e-95	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g42160	i0	87.908	0.971428571428571	306	37	97	0	1	306	6923	7228	Achromobacter phage JWF, complete genome	blastn	306	361	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
8291316	8291316	PRJNA670521_P_NODE_27_length_5661_cov_8.548318_g18_i0	PRJNA670521	27	5661	8.548318	483.92028198	Potexvirus marmormanihotis	3433851	Viruses	Viruses	8421	0	NTclustered	gi\|1847771809\|gb\|KT002435.2\|	39046	g18	i0	93.52	20.0823176117294	5664	361	100	6	1	5661	705	6365	Cassava common mosaic virus isolate Mcol22_1, complete genome	blastn	113686	8421	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
8291606	8291606	PRJNA670521_P_NODE_8007_length_628_cov_4.540541_g7282_i0	PRJNA670521	8007	628	4.540541	28.51459748	Potexvirus marmormanihotis	3433851	Viruses	Viruses	1022	0	NTclustered	gi\|1847771809\|gb\|KT002435.2\|	39046	g7282	i0	96.019	14.937898089172	628	25	100	0	1	628	652	25	Cassava common mosaic virus isolate Mcol22_1, complete genome	blastn	9381	1022	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
10093564	10093564	PRJNA670521_P_NODE_44508_length_310_cov_1.299578_g43763_i0	PRJNA670521	44508	310	1.299578	4.0286918	Mimiviridae	549779	Viruses	Viruses	58.4	6.22e-4	NTclustered	gi\|363539767\|ref\|NC_016072.1\|	1094892	g43763	i0	89.13	1.75483870967742	46	5	15	0	99	144	336535	336580	Megavirus chiliensis, complete genome	blastn	544	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
10093576	10093576	PRJNA670521_P_NODE_51708_length_292_cov_0.840183_g50963_i0	PRJNA670521	51708	292	0.840183	2.45333436	root	1	Root_unresolved	Root_unresolved	63.9	1.25e-5	NTclustered	gi\|51518014\|ref\|NC_006146.1\|	45455	g50963	i0	97.297	0.897260273972603	37	1	15	0	166	202	65249	65213	Macacine herpesvirus 4, complete genome	blastn	262	63.9	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Lymphocryptovirus	Lymphocryptovirus macacinegamma4
10842107	10842107	PRJNA670521_P_NODE_16589_length_456_cov_1.005222_g15847_i0	PRJNA670521	16589	456	1.005222	4.58381232	Achromobacter phage JWF	1589748	Viruses	Viruses	399	1.3699999999999998e-106	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g15847	i0	82.713	1.00219298245614	457	71	99	6	1	453	7487	7939	Achromobacter phage JWF, complete genome	blastn	457	399	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
10842251	10842251	PRJNA670521_P_NODE_50489_length_295_cov_0.792793_g49744_i0	PRJNA670521	50489	295	0.792793	2.33873935	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.027	NTclustered	gi\|2054476111\|tpg\|BK031846.1\|	2832643	g49744	i0	100	0.0949152542372881	28	0	9	0	37	64	17862	17889	MAG TPA_asm: Caudoviricetes sp. isolate ctBDg1, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12117521	12117521	PRJNA670521_P_NODE_72070_length_250_cov_1.406780_g71325_i0	PRJNA670521	72070	250	1.40678	3.51695	Achromobacter phage JWF	1589748	Viruses	Viruses	246	9.679999999999999e-61	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g71325	i0	85.185	1.952	243	33	96	3	5	245	66010	66251	Achromobacter phage JWF, complete genome	blastn	488	246	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
12117650	12117650	PRJNA670521_P_NODE_87450_length_243_cov_1.117647_g86705_i0	PRJNA670521	87450	243	1.117647	2.71588221	Pseudomonas phage Lu11	1161927	Viruses	Viruses	58.4	4.71e-4	NTclustered	gi\|388684650\|ref\|NC_017972.1\|	1161927	g86705	i0	100	0.728395061728395	31	0	13	0	54	84	125149	125119	Pseudomonas phage Lu11, complete genome	blastn	177	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage Lu11
14667023	14667023	PRJNA670521_P_NODE_12_length_7224_cov_32.693609_g8_i0	PRJNA670521	12	7224	32.693609	2361.78631416	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2926	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8	i0	96.298	0.666112956810631	1783	61	67	5	13	1793	7108	5329	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4812	2926	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14667195	14667195	PRJNA670521_P_NODE_58092_length_277_cov_1.500000_g57347_i0	PRJNA670521	58092	277	1.5	4.155	Lagopoecus perplexus nudivirus	3153919	Viruses	Viruses	54.7	0.007	NTclustered	gi\|2778029637\|tpg\|BK068079.1\|	3153919	g57347	i0	100	0.104693140794224	29	0	10	0	240	268	27218	27190	TPA_asm: Lagopoecus perplexus nudivirus genomic sequence	blastn	29	54.7	1	Viruses			Naldaviricetes	Lefavirales	Nudiviridae		Lagopoecus perplexus nudivirus
15940838	15940838	PRJNA670521_P_NODE_13_length_7224_cov_29.761851_g8_i1	PRJNA670521	13	7224	29.761851	2149.99611624	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2915	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8	i1	96.186	0.66625138427464	1783	63	67	5	5432	7212	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4813	2915	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
17216066	17216066	PRJNA670521_P_NODE_26994_length_375_cov_1.258278_g26250_i0	PRJNA670521	26994	375	1.258278	4.7185425	Achromobacter phage JWF	1589748	Viruses	Viruses	255	2.53e-63	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g26250	i0	79.675	0.984	369	63	97	9	13	375	64114	64476	Achromobacter phage JWF, complete genome	blastn	369	255	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
18490570	18490570	PRJNA670521_P_NODE_44535_length_310_cov_1.299578_g43790_i0	PRJNA670521	44535	310	1.299578	4.0286918	Achromobacter phage JWF	1589748	Viruses	Viruses	431	3.18e-116	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g43790	i0	92.384	1.91290322580645	302	23	97	0	9	310	51674	51373	Achromobacter phage JWF, complete genome	blastn	593	431	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
19764997	19764997	PRJNA670521_P_NODE_26616_length_377_cov_1.108553_g25872_i0	PRJNA670521	26616	377	1.108553	4.17924481	Rosenblumvirus LSA2366	2956379	Viruses	Viruses	58.4	7.72e-4	NTclustered	gi\|2047460022\|ref\|NC_055916.1\|	2797417	g25872	i0	90.698	0.114058355437666	43	4	11	0	30	72	310	268	Staphylococcus phage LSA2366, complete genome	blastn	43	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Rountreeviridae	Rosenblumvirus	Rosenblumvirus LSA2366
19765008	19765008	PRJNA670521_P_NODE_29596_length_362_cov_1.332180_g28851_i0	PRJNA670521	29596	362	1.33218	4.8224916	Achromobacter phage JWF	1589748	Viruses	Viruses	230	1.4799999999999995e-55	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g28851	i0	78.552	1.9585635359116	359	69	98	8	8	362	24683	24329	Achromobacter phage JWF, complete genome	blastn	709	230	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
19765092	19765092	PRJNA670521_P_NODE_49896_length_296_cov_1.381166_g49151_i0	PRJNA670521	49896	296	1.381166	4.08825136	Achromobacter phage JWF	1589748	Viruses	Viruses	281	3.22e-71	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g49151	i0	85.145	0.932432432432432	276	39	93	2	1	275	20838	21112	Achromobacter phage JWF, complete genome	blastn	276	281	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
22315417	22315417	PRJNA670521_P_NODE_18_length_6376_cov_44.189116_g12_i0	PRJNA670521	18	6376	44.189116	2817.49803616	Potexvirus marmormanihotis	3433851	Viruses	Viruses	10008	0	NTclustered	gi\|2851473175\|gb\|PQ497977.1\|	39046	g12	i0	94.997	20.7964240903388	6376	319	100	0	1	6376	17	6392	Cassava common mosaic virus isolate BR-21GS-C3-251-6, complete genome	blastn	132598	10008	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
22315597	22315597	PRJNA670521_P_NODE_68738_length_254_cov_1.038674_g67993_i0	PRJNA670521	68738	254	1.038674	2.63823196	Caudoviricetes sp.	2832643	Viruses	Viruses	58.4	4.96e-4	NTclustered	gi\|2914830750\|gb\|OR222504.1\|	2832643	g67993	i0	100	0.122047244094488	31	0	12	0	85	115	2080	2110	MAG: Caudoviricetes sp. isolate MSP0877 genomic sequence	blastn	31	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23590907	23590907	PRJNA670521_P_NODE_19_length_6373_cov_16.364127_g12_i1	PRJNA670521	19	6373	16.364127	1042.88581371	Potexvirus marmormanihotis	3433851	Viruses	Viruses	9915	0	NTclustered	gi\|2018315478\|gb\|MT279196.1\|	39046	g12	i1	94.771	19.8562686332967	6368	333	99	0	6	6373	1	6368	Cassava common mosaic virus isolate BR, complete genome	blastn	126544	9915	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
23591344	23591344	PRJNA670521_P_NODE_91619_length_241_cov_1.375000_g90874_i0	PRJNA670521	91619	241	1.375	3.31375	Achromobacter phage JWF	1589748	Viruses	Viruses	137	5.82e-28	NTclustered	gi\|985758637\|ref\|NC_029075.1\|	1589748	g90874	i0	84.783	0.572614107883817	138	19	57	2	3	139	42555	42691	Achromobacter phage JWF, complete genome	blastn	138	137	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage JWF
24864208	24864208	PRJNA670521_P_NODE_20_length_6357_cov_38.469446_g12_i2	PRJNA670521	20	6357	38.469446	2445.50268222	Potexvirus marmormanihotis	3433851	Viruses	Viruses	9718	0	NTclustered	gi\|2851473175\|gb\|PQ497977.1\|	39046	g12	i2	94.258	20.6005977662419	6357	365	100	0	1	6357	17	6373	Cassava common mosaic virus isolate BR-21GS-C3-251-6, complete genome	blastn	130958	9718	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus marmormanihotis
24864244	24864244	PRJNA670521_P_NODE_27640_length_372_cov_1.030100_g26896_i0	PRJNA670521	27640	372	1.0301	3.831972	Zebrafish picornavirus 1	2304617	Viruses	Viruses	569	7.899999999999997e-158	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g26896	i0	94.34	2.98387096774194	371	21	99	0	2	372	5563	5193	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1110	569	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24864286	24864286	PRJNA670521_P_NODE_39620_length_325_cov_0.916667_g38875_i0	PRJNA670521	39620	325	0.916667	2.97916775	Bacteriophage sp.	38018	Viruses	Viruses	58.4	6.56e-4	NTclustered	gi\|2295359715\|gb\|OP075432.1\|	38018	g38875	i0	97.143	0.206153846153846	35	0	11	1	231	265	178	145	MAG: Bacteriophage sp. isolate 3376_53066, partial genome	blastn	67	58.4	1	Viruses							Bacteriophage sp.
24864337	24864337	PRJNA670521_P_NODE_57400_length_279_cov_1.048544_g56655_i0	PRJNA670521	57400	279	1.048544	2.92543776	Achromobacter phage 2-1	3061295	Viruses	Viruses	366	8.08e-97	NTclustered	gi\|2552395816\|gb\|OQ974181.1\|	3061295	g56655	i0	90.357	2.00716845878136	280	26	100	1	1	279	19464	19185	Achromobacter phage 2-1, complete genome	blastn	560	366	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage 2-1

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