metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA658591" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA658591" 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
625468	625468	PRJNA658591_S_NODE_1241_length_367_cov_134.295597_g1178_i0	PRJNA658591	1241	367	134.295597	492.86484099	Betacoronavirus pandemicum	3418604	Viruses	Viruses	71.3	9.62e-8	NTclustered	gi\|2565353280\|emb\|OY626164.1\|	2697049	g1178	i0	89.655	0.517711171662125	58	3	15	3	28	82	26558	26501	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	190	71.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
1901673	1901673	PRJNA658591_S_NODE_9482_length_165_cov_36.896552_g9419_i0	PRJNA658591	9482	165	36.896552	60.8793108	Orthoavulavirus javaense	3051375	Viruses	Viruses	63.9	6.37e-6	NTclustered	gi\|1810954291\|gb\|MN727300.2\|	2560319	g9419	i0	100	0.206060606060606	34	0	21	0	1	34	15286	15253	Avian paramyxovirus 1 isolate chicken/Indonesia/ITA/012WJ, complete genome	blastn	34	63.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthoavulavirus	Orthoavulavirus javaense
3176371	3176371	PRJNA658591_S_NODE_7503_length_179_cov_1.115385_g7440_i0	PRJNA658591	7503	179	1.115385	1.99653915	Caudoviricetes sp.	2832643	Viruses	Viruses	315	1.75e-81	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g7440	i0	98.324	328.77094972067	179	3	100	0	1	179	17963	18141	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	58850	315	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5728916	5728916	PRJNA658591_S_NODE_1445_length_342_cov_44.262799_g1382_i0	PRJNA658591	1445	342	44.262799	151.37877258	Betacoronavirus pandemicum	3418604	Viruses	Viruses	119	3.14e-22	NTclustered	gi\|2165835426\|emb\|OV196492.1\|	2697049	g1382	i0	94.872	6.5672514619883	78	1	22	2	1	75	61	138	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	2246	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
7004076	7004076	PRJNA658591_S_NODE_1646_length_323_cov_5.419708_g1583_i0	PRJNA658591	1646	323	5.419708	17.50565684	Orthopoxvirus monkeypox	3431483	Viruses	Viruses	54.7	0.008	NTclustered	gi\|2309594316\|gb\|OP536747.1\|	10244	g1583	i0	100	8.97832817337461	29	0	9	0	71	99	119302	119274	Monkeypox virus isolate 9000365, partial genome	blastn	2900	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
13379584	13379584	PRJNA658591_S_NODE_2771_length_259_cov_238.561905_g2708_i0	PRJNA658591	2771	259	238.561905	617.87533395	Tequatrovirus gee9062	2844202	Viruses	Viruses	80.5	1.08e-10	NTclustered	gi\|1595483537\|gb\|MK327945.1\|	2502305	g2708	i0	97.826	0.32046332046332	46	1	18	0	208	253	124000	124045	Escherichia phage vB_EcoM_G4500, complete genome	blastn	83	80.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Tequatrovirus	Tequatrovirus gee9062
15928398	15928398	PRJNA658591_S_NODE_2553_length_268_cov_7.470320_g2490_i0	PRJNA658591	2553	268	7.47032	20.0204576	Caudoviricetes sp.	2832643	Viruses	Viruses	63.9	1.13e-5	NTclustered	gi\|2059855482\|tpg\|BK040575.1\|	2832643	g2490	i0	97.368	0.261194029850746	38	0	14	1	232	268	42	5	MAG TPA_asm: Caudoviricetes sp. isolate ctwIV1, partial genome	blastn	70	63.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17203479	17203479	PRJNA658591_S_NODE_6574_length_187_cov_4.579710_g6511_i0	PRJNA658591	6574	187	4.57971	8.5640577	Lymphocryptovirus humangamma4	3050299	Viruses	Viruses	63.9	7.39e-6	NTclustered	gi\|2609791700\|gb\|OR652422.1\|	10376	g6511	i0	100	0.53475935828877	34	0	18	0	154	187	9243	9276	Human gammaherpesvirus 4 strain 725, partial genome	blastn	100	63.9	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Lymphocryptovirus	Lymphocryptovirus humangamma4
21028015	21028015	PRJNA658591_S_NODE_2457_length_272_cov_326.735426_g2394_i0	PRJNA658591	2457	272	326.735426	888.72035872	Parapoxvirus orf	3431389	Viruses	Viruses	110	1.46e-19	NTclustered	gi\|2755084441\|gb\|PP943425.1\|	10258	g2394	i0	95.714	5.49632352941176	70	0	25	3	185	251	67825	67756	Orf virus isolate FX10, partial genome	blastn	1495	110	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
21028021	21028021	PRJNA658591_S_NODE_297_length_660_cov_210.075286_g158_i1	PRJNA658591	297	660	210.075286	1386.4968876	Betacoronavirus pandemicum	3418604	Viruses	Viruses	115	8.26e-21	NTclustered	gi\|2165836832\|emb\|OV197136.1\|	2697049	g158	i1	94.737	0.284848484848485	76	1	11	2	1	73	41	116	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	188	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
21028024	21028024	PRJNA658591_S_NODE_3657_length_233_cov_194.815217_g3594_i0	PRJNA658591	3657	233	194.815217	453.91945561	Klebsiella phage phiKp_32	2979986	Viruses	Viruses	108	4.39e-19	NTclustered	gi\|2507497987\|dbj\|LC768500.1\|	2979986	g3594	i0	94.444	2.1244635193133	72	1	30	2	7	75	1	72	Klebsiella phage phiKp_32 DNA, complete genome	blastn	495	108	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Klebsiella phage phiKp_32
21028032	21028032	PRJNA658591_S_NODE_7337_length_180_cov_2.145038_g7274_i0	PRJNA658591	7337	180	2.145038	3.8610684	Ampelovirus tetravitis	3426346	Viruses	Viruses	62.1	2.54e-5	NTclustered	gi\|2452977696\|gb\|OP752675.1\|	70177	g7274	i0	100	0.338888888888889	33	0	18	0	148	180	13822	13854	Grapevine leafroll-associated virus 4 isolate LC9_N5, complete genome	blastn	61	62.1	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae	Ampelovirus	Ampelovirus tetravitis
22302771	22302771	PRJNA658591_S_NODE_858_length_425_cov_9.031915_g795_i0	PRJNA658591	858	425	9.031915	38.38563875	Achromobacter phage tuull	3074846	Viruses	Viruses	69.4	4.07e-7	NTclustered	gi\|2618964722\|gb\|OR396896.1\|	3074846	g795	i0	100	0.0870588235294118	37	0	9	0	9	45	36628	36664	Achromobacter phage tuull, partial genome	blastn	37	69.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Achromobacter phage tuull
24851735	24851735	PRJNA658591_S_NODE_6380_length_189_cov_3.271429_g6317_i0	PRJNA658591	6380	189	3.271429	6.18300081	Lymphocryptovirus humangamma4	3050299	Viruses	Viruses	56.5	0.001	NTclustered	gi\|1465382783\|emb\|LS992247.1\|	10376	g6317	i0	97.059	0.35978835978836	34	0	17	1	1	33	58024	58057	Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I	blastn	68	56.5	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Lymphocryptovirus	Lymphocryptovirus humangamma4

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