metadata: contig_metadata: 15 rows where bioproject = "PRJEB81171" and tax

15 rows where bioproject = "PRJEB81171" 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
996645	996645	PRJEB81171_P_NODE_7801_length_252_cov_1.385475_g7674_i0	PRJEB81171	7801	252	1.385475	3.491397	Jamesmcgillvirus	2948768	Viruses	Viruses	449	6.94e-122	NTclustered	gi\|48697070\|ref\|NC_005884.1\|	270673	g7674	i0	98.81	7.36111111111111	252	3	100	0	1	252	38307	38558	Pseudomonas phage PaP2, complete genome	blastn	1855	449	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Fredfastierviridae	Jamesmcgillvirus	Pseudomonas phage PaP2
1414107	1414107	PRJEB81171_P_NODE_9362_length_245_cov_0.906977_g9235_i0	PRJEB81171	9362	245	0.906977	2.22209365	Caudoviricetes sp.	2832643	Viruses	Viruses	309	1.19e-79	NTclustered	gi\|2060040681\|tpg\|BK027668.1\|	2832643	g9235	i0	89.388	2	245	26	100	0	1	245	26151	26395	MAG TPA_asm: Caudoviricetes sp. isolate ct6vn6, partial genome	blastn	490	309	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2689528	2689528	PRJEB81171_P_NODE_7923_length_252_cov_0.871508_g7796_i0	PRJEB81171	7923	252	0.871508	2.19620016	Betacoronavirus pandemicum	3418604	Viruses	Viruses	466	6.89e-127	NTclustered	gi\|2316342856\|gb\|OP624554.1\|	2697049	g7796	i0	100	100	252	0	100	0	1	252	29444	29695	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome	blastn	25200	466	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
6517689	6517689	PRJEB81171_P_NODE_9746_length_243_cov_0.917647_g9619_i0	PRJEB81171	9746	243	0.917647	2.22988221	Pormufvirus salinum	3431827	Viruses	Viruses	261	3.34e-65	NTclustered	gi\|2231638396\|ref\|NC_062761.1\|	2878009	g9619	i0	86.008	1	243	34	100	0	1	243	20733	20491	Halorubrum virus HRTV-28, complete genome	blastn	243	261	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Suolaviridae	Pormufvirus	Pormufvirus salinum
7791766	7791766	PRJEB81171_P_NODE_9067_length_246_cov_0.901734_g8940_i0	PRJEB81171	9067	246	0.901734	2.21826564	Bacillus phage vB_BpuM-ZY1	3096073	Viruses	Viruses	303	5.56e-78	NTclustered	gi\|2622943848\|gb\|OR820920.1\|	3096073	g8940	i0	89.256	0.983739837398374	242	26	98	0	3	244	36791	37032	Bacillus phage vB_BpuM-ZY1, complete genome	blastn	242	303	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae		Bacillus phage vB_BpuM-ZY1
7791774	7791774	PRJEB81171_P_NODE_9547_length_244_cov_0.912281_g9420_i0	PRJEB81171	9547	244	0.912281	2.22596564	Microviridae sp.	2202644	Viruses	Viruses	424	4.05e-114	NTclustered	gi\|2054416160\|tpg\|BK035639.1\|	2202644	g9420	i0	97.951	14.9877049180328	244	5	100	0	1	244	16910	16667	MAG TPA_asm: Microviridae sp. isolate cteV86, partial genome	blastn	3657	424	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp.
10342486	10342486	PRJEB81171_P_NODE_7549_length_254_cov_1.292818_g7422_i0	PRJEB81171	7549	254	1.292818	3.28375772	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	350	7.3e-92	NTclustered	gi\|1707910805\|gb\|MK892832.1\|	2591644	g7422	i0	91.7	0.996062992125984	253	20	99	1	1	253	17968	17717	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome	blastn	253	350	1	Viruses							Prokaryotic dsDNA virus sp.
16716156	16716156	PRJEB81171_P_NODE_5254_length_291_cov_1.146789_g5127_i0	PRJEB81171	5254	291	1.146789	3.33715599	Caudoviricetes sp.	2832643	Viruses	Viruses	442	1.3699999999999994e-119	NTclustered	gi\|2053078945\|tpg\|BK020046.1\|	2832643	g5127	i0	94.425	1.96219931271478	287	16	99	0	2	288	11652	11938	MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome	blastn	571	442	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17991026	17991026	PRJEB81171_P_NODE_8155_length_251_cov_0.876404_g8028_i0	PRJEB81171	8155	251	0.876404	2.19977404	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	337	5.609999999999998e-88	NTclustered	gi\|1707910805\|gb\|MK892832.1\|	2591644	g8028	i0	90.837	1	251	23	100	0	1	251	46507	46257	MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome	blastn	251	337	1	Viruses							Prokaryotic dsDNA virus sp.
24365291	24365291	PRJEB81171_P_NODE_9360_length_245_cov_0.906977_g9233_i0	PRJEB81171	9360	245	0.906977	2.22209365	Escherichia phage Turkey3	3375710	Viruses	Viruses	60.2	1.32e-4	NTclustered	gi\|2890139370\|gb\|PQ471515.1\|	3375710	g9233	i0	100	0.130612244897959	32	0	13	0	31	62	151731	151762	Escherichia phage Turkey3, complete genome	blastn	32	60.2	1	Viruses							Escherichia phage Turkey3
28448365	28448365	PRJEB81171_P_NODE_7166_length_260_cov_1.668449_g7039_i0	PRJEB81171	7166	260	1.668449	4.3379674	Viruses	10239	Viruses	Viruses	54.7	5.95e-7	NR	YP_006560771.1	1132026	g7039	i0	48.1	1.26923076923077	54	25	58.8	1	218	66	21	74	YP_006560771.1 tail completion or Neck1 protein [Burkholderia phage vB_BceS_KL1]	diamond	330	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Kilunavirus	Kilunavirus KL1
28921641	28921641	PRJEB81171_P_NODE_6368_length_273_cov_1.560000_g6241_i0	PRJEB81171	6368	273	1.56	4.2588	Chuvivirus	2842604	Viruses	Viruses	130	2.31e-33	NR	WET19887.1	2842604	g6241	i0	65.6	1.97802197802198	90	31	98.9	0	272	3	303	392	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	540	130	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
29560389	29560389	PRJEB81171_P_NODE_5710_length_283_cov_1.485714_g5583_i0	PRJEB81171	5710	283	1.485714	4.20457062	Rhodococcus phage Finch	2094144	Viruses	Viruses	153	4.02e-41	NR	YP_010059023.1	2094144	g5583	i0	71.3	0.996466431095406	94	27	99.6	0	2	283	439	532	YP_010059023.1 terminase [Rhodococcus phage Finch]	diamond	282	153	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Finchvirus	Finchvirus finch
32088978	32088978	PRJEB81171_P_NODE_9318_length_245_cov_0.906977_g9191_i0	PRJEB81171	9318	245	0.906977	2.22209365	uncultured Caudovirales phage	2100421	Viruses	Viruses	70.9	4.51e-12	NR	CAB4170702.1	2100421	g9191	i0	81.1	0.906122448979592	37	7	45.3	0	111	1	1	37	CAB4170702.1 major capsid protein [uncultured Caudovirales phage]	diamond	222	70.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
32088979	32088979	PRJEB81171_P_NODE_9878_length_242_cov_1.781065_g9751_i0	PRJEB81171	9878	242	1.781065	4.3101773	Caudoviricetes sp.	2832643	Viruses	Viruses	107	5.66e-26	NR	XOR47457.1	2832643	g9751	i0	62	0.979338842975207	79	30	97.9	0	239	3	10	88	XOR47457.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	237	107	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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