metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_kingdom = "Shotokuvirae"

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
274485	274485	PRJNA1120060_P_NODE_998941_length_312_cov_2.569038_g981012_i0	PRJNA1120060	998941	312	2.569038	8.01539856	Alphatorquevirus sp.	2809145	Viruses	Viruses	52.8	0.029	NTclustered	gi\|2894906387\|tpg\|BK069140.1\|	2809145	g981012	i0	100	0.0897435897435897	28	0	9	0	77	104	878	905	MAG TPA_asm: Alphatorquevirus sp. isolate SRR2037084_NODE_1060 genomic sequence	blastn	28	52.8	1	Viruses		Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Alphatorquevirus	Alphatorquevirus sp.
1542355	1542355	PRJNA1120060_P_NODE_552982_length_356_cov_4.424028_g535304_i0	PRJNA1120060	552982	356	4.424028	15.74953968	Grapevine geminivirus A defective DNA	1928761	Viruses	Viruses	56.5	0.003	NTclustered	gi\|1898523535\|gb\|MT344724.1\|	1928761	g535304	i0	100	0.168539325842697	30	0	8	0	90	119	1307	1278	Grapevine geminivirus A defective DNA isolate def2019YM4, complete genome	blastn	60	56.5	1	Viruses		Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Geminiviridae		Grapevine geminivirus A defective DNA
2818481	2818481	PRJNA1120060_P_NODE_553543_length_356_cov_3.787986_g535865_i0	PRJNA1120060	553543	356	3.787986	13.48523016	Human papillomavirus	10566	Viruses	Viruses	636	7.31e-178	NTclustered	gi\|1559669430\|gb\|MH777268.2\|	10566	g535865	i0	98.876	1.13483146067416	356	4	100	0	1	356	6912	6557	MAG: Human papillomavirus isolate HPV-mSK_126, complete genome	blastn	404	636	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
4070392	4070392	PRJNA1120060_P_NODE_1830444_length_279_cov_4.116505_g1812429_i0	PRJNA1120060	1830444	279	4.116505	11.48504895	Alphapapillomavirus 7	337042	Viruses	Viruses	52.8	0.026	NTclustered	gi\|1206430579\|gb\|KY565612.1\|	10593	g1812429	i0	100	0.100358422939068	28	0	10	0	7	34	728	701	Human papillomavirus 45 isolate 509_RJ E6 gene, complete cds; and E7 gene, partial cds	blastn	28	52.8	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Alphapapillomavirus	Alphapapillomavirus 7
5338339	5338339	PRJNA1120060_P_NODE_1250925_length_309_cov_2.919492_g1232984_i0	PRJNA1120060	1250925	309	2.919492	9.02123028	Alphapapillomavirus 3	333767	Viruses	Viruses	52.8	0.029	NTclustered	gi\|289656451\|gb\|GQ244463.1\|	735496	g1232984	i0	100	0.0906148867313916	28	0	9	0	185	212	2574	2547	Human papillomavirus type 114, complete genome	blastn	28	52.8	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Alphapapillomavirus	Alphapapillomavirus 3
5356990	5356990	PRJNA1120060_P_NODE_261345_length_435_cov_3.635359_g244454_i0	PRJNA1120060	261345	435	3.635359	15.81381165	TTV-like mini virus	93678	Viruses	Viruses	52.8	0.042	NTclustered	gi\|2164987747\|gb\|MN771414.1\|	93678	g244454	i0	100	0.064367816091954	28	0	6	0	20	47	1952	1979	MAG: TTV-like mini virus isolate SAfiA-350-43, complete genome	blastn	28	52.8	1	Viruses		Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus
5360578	5360578	PRJNA1120060_P_NODE_2936965_length_243_cov_0.905882_g2918872_i0	PRJNA1120060	2936965	243	0.905882	2.20129326	Ficedula mugimaki CRESS-DNA-virus sp.	2815035	Viruses	Viruses	58.4	4.71e-4	NTclustered	gi\|2015371934\|gb\|MW182753.1\|	2815035	g2918872	i0	94.737	0.156378600823045	38	1	16	1	25	62	2140	2104	MAG: Ficedula mugimaki CRESS-DNA-virus sp. isolate muf159cir1 genomic sequence	blastn	38	58.4	1	Viruses		Shotokuvirae	Cressdnaviricota					Ficedula mugimaki CRESS-DNA-virus sp.
5363901	5363901	PRJNA1120060_P_NODE_3224625_length_230_cov_3.382166_g3206518_i0	PRJNA1120060	3224625	230	3.382166	7.7789818	Human papillomavirus	10566	Viruses	Viruses	420	4.89e-113	NTclustered	gi\|1559669430\|gb\|MH777268.2\|	10566	g3206518	i0	99.565	1.9304347826087	230	1	100	0	1	230	3542	3313	MAG: Human papillomavirus isolate HPV-mSK_126, complete genome	blastn	444	420	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
6620097	6620097	PRJNA1120060_P_NODE_1740226_length_283_cov_2.600000_g1722218_i0	PRJNA1120060	1740226	283	2.6	7.358	Human papillomavirus	10566	Viruses	Viruses	363	1.0599999999999999e-95	NTclustered	gi\|1559669430\|gb\|MH777268.2\|	10566	g1722218	i0	99.497	1	199	1	100	0	85	283	7149	6951	MAG: Human papillomavirus isolate HPV-mSK_126, complete genome	blastn	283	363	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
6627610	6627610	PRJNA1120060_P_NODE_2299186_length_261_cov_2.138298_g2281127_i0	PRJNA1120060	2299186	261	2.138298	5.58095778	Gammapapillomavirus 11	1513256	Viruses	Viruses	483	7.12e-132	NTclustered	gi\|389656408\|ref\|NC_017994.1\|	1070409	g2281127	i0	100	1.98850574712644	261	0	100	0	1	261	649	909	Human papillomavirus type 136, complete genome	blastn	519	483	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Gammapapillomavirus	Gammapapillomavirus 11
7900993	7900993	PRJNA1120060_P_NODE_2179427_length_265_cov_9.145833_g2161375_i0	PRJNA1120060	2179427	265	9.145833	24.23645745	Human papillomavirus	10566	Viruses	Viruses	479	9.38e-131	NTclustered	gi\|1559669430\|gb\|MH777268.2\|	10566	g2161375	i0	99.245	1.88679245283019	265	2	100	0	1	265	6357	6093	MAG: Human papillomavirus isolate HPV-mSK_126, complete genome	blastn	500	479	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
7923820	7923820	PRJNA1120060_P_NODE_767_length_8024_cov_41.330273_g202_i0	PRJNA1120060	767	8024	41.330273	3316.34110552	Dyothetapapillomavirus 1	1235662	Viruses	Viruses	9058	0	NTclustered	gi\|1464308911\|ref\|NC_038520.1\|	568209	g202	i0	99.878	3.14930209371884	4923	6	100	0	1	4923	4923	1	Feline papillomavirus type 2 isolate Main Coon 2007, complete genome	blastn	25270	9058	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Dyothetapapillomavirus	Dyothetapapillomavirus 1
9193942	9193942	PRJNA1120060_P_NODE_438128_length_379_cov_8.192810_g420631_i0	PRJNA1120060	438128	379	8.19281	31.0507499	Human papillomavirus	10566	Viruses	Viruses	390	6.74e-104	NTclustered	gi\|1559669430\|gb\|MH777268.2\|	10566	g420631	i0	99.078	0.965699208443272	217	2	97	0	2	218	4630	4846	MAG: Human papillomavirus isolate HPV-mSK_126, complete genome	blastn	366	390	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
9197125	9197125	PRJNA1120060_P_NODE_64768_length_654_cov_5.759036_g52152_i0	PRJNA1120060	64768	654	5.759036	37.66409544	Human papillomavirus	10566	Viruses	Viruses	1181	0	NTclustered	gi\|1559669430\|gb\|MH777268.2\|	10566	g52152	i0	99.235	4.96483180428135	654	5	100	0	1	654	76	729	MAG: Human papillomavirus isolate HPV-mSK_126, complete genome	blastn	3247	1181	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
10449520	10449520	PRJNA1120060_P_NODE_2024269_length_272_cov_1.020101_g2006236_i0	PRJNA1120060	2024269	272	1.020101	2.77467472	Grapevine geminivirus A defective DNA	1928761	Viruses	Viruses	56.5	0.002	NTclustered	gi\|1898523535\|gb\|MT344724.1\|	1928761	g2006236	i0	100	0.220588235294118	30	0	11	0	165	194	1278	1307	Grapevine geminivirus A defective DNA isolate def2019YM4, complete genome	blastn	60	56.5	1	Viruses		Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Geminiviridae		Grapevine geminivirus A defective DNA
13009653	13009653	PRJNA1120060_P_NODE_2817271_length_245_cov_4.860465_g2799185_i0	PRJNA1120060	2817271	245	4.860465	11.90813925	Melanogrammus aeglefinus-associated papillomavirus 1	2683333	Viruses	Viruses	52.8	0.022	NTclustered	gi\|2069601150\|gb\|MH617143.2\|	2683333	g2799185	i0	96.774	0.126530612244898	31	1	13	0	144	174	3161	3191	MAG: Melanogrammus aeglefinus-associated papillomavirus 1 isolate ctce22, complete genome	blastn	31	52.8	1	Viruses	non-mammal papillomaviruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Melanogrammus aeglefinus-associated papillomavirus 1
14260298	14260298	PRJNA1120060_P_NODE_1005072_length_312_cov_2.497908_g987143_i0	PRJNA1120060	1005072	312	2.497908	7.79347296	Human papillomavirus	10566	Viruses	Viruses	279	1.23e-70	NTclustered	gi\|1144331739\|gb\|KX781283.1\|	10566	g987143	i0	100	3.37820512820513	151	0	97	0	162	312	2906	2756	Human papillomavirus isolate Dysk4, complete genome	blastn	1054	279	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
16829885	16829885	PRJNA1120060_P_NODE_2529174_length_253_cov_1.294444_g2511102_i0	PRJNA1120060	2529174	253	1.294444	3.27494332	Gammapapillomavirus 10	1175852	Viruses	Viruses	468	1.92e-127	NTclustered	gi\|312451813\|gb\|GU117633.1\|	909332	g2511102	i0	100	1.98418972332016	253	0	100	0	1	253	203	455	Human papillomavirus type 133, complete genome	blastn	502	468	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Gammapapillomavirus	Gammapapillomavirus 10
16849141	16849141	PRJNA1120060_P_NODE_835214_length_316_cov_2.481481_g817301_i0	PRJNA1120060	835214	316	2.481481	7.84147996	TTV-like mini virus	93678	Viruses	Viruses	54.7	0.008	NTclustered	gi\|2164985327\|gb\|MN770248.1\|	93678	g817301	i0	96.97	0.522151898734177	33	0	10	1	118	150	282	313	MAG: TTV-like mini virus isolate SAfiA-300-21, complete genome	blastn	165	54.7	1	Viruses		Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus
18110703	18110703	PRJNA1120060_P_NODE_3068375_length_237_cov_4.548780_g3050274_i0	PRJNA1120060	3068375	237	4.54878	10.7806086	Betapapillomavirus 2	333924	Viruses	Viruses	394	3.069999999999999e-105	NTclustered	gi\|186461194\|gb\|EU410348.1\|	518629	g3050274	i0	96.624	9.19409282700422	237	8	100	0	1	237	5771	5535	Human papillomavirus type 110, complete genome	blastn	2179	394	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Betapapillomavirus	Betapapillomavirus 2
18115814	18115814	PRJNA1120060_P_NODE_3529095_length_204_cov_5.916031_g3510968_i0	PRJNA1120060	3529095	204	5.916031	12.06870324	Gammapapillomavirus 7	1175849	Viruses	Viruses	324	3.42e-84	NTclustered	gi\|343411537\|gb\|HM999990.1\|	1070411	g3510968	i0	95.98	2.63235294117647	199	8	98	0	1	199	3675	3873	Human papillomavirus type 138 isolate GH13, complete genome	blastn	537	324	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Gammapapillomavirus	Gammapapillomavirus 7
23183659	23183659	PRJNA1120060_P_NODE_1013599_length_312_cov_2.372385_g995670_i0	PRJNA1120060	1013599	312	2.372385	7.4018412	Galvornvirus isengard	2955925	Viruses	Viruses	52.8	0.029	NTclustered	gi\|2302020959\|gb\|MT208456.1\|	1954248	g995670	i0	94.286	0.112179487179487	35	1	11	1	38	71	3520	3486	MAG: Circoviridae sp. isolate CN13_L19_588, complete genome	blastn	35	52.8	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
23193533	23193533	PRJNA1120060_P_NODE_1676379_length_286_cov_1.492958_g1658378_i0	PRJNA1120060	1676379	286	1.492958	4.26985988	Human papillomavirus	10566	Viruses	Viruses	501	2.18e-137	NTclustered	gi\|1559669484\|gb\|MH777321.2\|	10566	g1658378	i0	98.252	14.8251748251748	286	5	100	0	1	286	4458	4743	MAG: Human papillomavirus isolate HPV-mSK_179, complete genome	blastn	4240	501	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
23196495	23196495	PRJNA1120060_P_NODE_1886839_length_277_cov_2.500000_g1868820_i0	PRJNA1120060	1886839	277	2.5	6.925	Human papillomavirus	10566	Viruses	Viruses	507	4.53e-139	NTclustered	gi\|371486189\|gb\|JF966371.1\|	10566	g1868820	i0	99.639	3	277	1	100	0	1	277	1386	1662	Human papillomavirus isolate 915 F 06 002 KN1, complete genome	blastn	831	507	1	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
23205309	23205309	PRJNA1120060_P_NODE_2542159_length_252_cov_3.525140_g2524084_i0	PRJNA1120060	2542159	252	3.52514	8.8833528	Galvornvirus isengard	2955925	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2302017528\|gb\|MT205156.1\|	1954248	g2524084	i0	90.476	0.166666666666667	42	2	16	2	45	85	1856	1816	MAG: Circoviridae sp. isolate CN3_L16_2910, complete genome	blastn	42	54.7	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
23220708	23220708	PRJNA1120060_P_NODE_586599_length_351_cov_1.179856_g568888_i0	PRJNA1120060	586599	351	1.179856	4.14129456	Galvornvirus isengard	2955925	Viruses	Viruses	52.8	0.033	NTclustered	gi\|2302008998\|gb\|MT202264.1\|	1954248	g568888	i0	100	0.0797720797720798	28	0	8	0	134	161	1191	1218	MAG: Circoviridae sp. isolate CN3_L15_2942, complete genome	blastn	28	52.8	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard

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