metadata: contig_metadata: 19 rows where bioproject = "PRJEB10320" and tax

19 rows where bioproject = "PRJEB10320" 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
3839684	3839684	PRJEB10320_P_NODE_14204_length_245_cov_1.333333_g13946_i0	PRJEB10320	14204	245	1.333333	3.26666585	Mimivirus U306	1932880	Viruses	Viruses	152	2.12e-32	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g13946	i0	84.375	37.4326530612245	160	20	90	4	26	181	877740	877582	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	9171	152	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306
11491513	11491513	PRJEB10320_P_NODE_18850_length_201_cov_1.108434_g18592_i0	PRJEB10320	18850	201	1.108434	2.22795234	Lymphocryptovirus humangamma4	3050299	Viruses	Viruses	372	1.18e-98	NTclustered	gi\|1519305892\|dbj\|AP019128.1\|	10376	g18592	i0	100	100	201	0	100	0	1	201	152368	152168	Human gammaherpesvirus 4 UPN326_PBMC DNA, nearly complete genome	blastn	20100	372	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Lymphocryptovirus	Lymphocryptovirus humangamma4
12767064	12767064	PRJEB10320_P_NODE_16651_length_219_cov_1.750000_g16393_i0	PRJEB10320	16651	219	1.75	3.8325	Moumouvirus australiense	3080759	Viruses	Viruses	198	2.35e-46	NTclustered	gi\|2500366567\|ref\|NC_075368.1\|	2109587	g16393	i0	83.491	55.6803652968037	212	35	97	0	7	218	261899	262110	Moumouvirus australiensis isolate 10A, complete genome	blastn	12194	198	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus australiense
14041626	14041626	PRJEB10320_P_NODE_22472_length_177_cov_1.387324_g22214_i0	PRJEB10320	22472	177	1.387324	2.45556348	Caudoviricetes sp.	2832643	Viruses	Viruses	62.1	2.48e-5	NTclustered	gi\|2054495546\|tpg\|BK032237.1\|	2832643	g22214	i0	97.222	0.604519774011299	36	1	20	0	4	39	6980	7015	MAG TPA_asm: Caudoviricetes sp. isolate ct3v52, partial genome	blastn	107	62.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15315777	15315777	PRJEB10320_P_NODE_26413_length_158_cov_1.130081_g26155_i0	PRJEB10320	26413	158	1.130081	1.78552798	Lymphocryptovirus humangamma4	3050299	Viruses	Viruses	292	7.07e-75	NTclustered	gi\|1862917033\|emb\|LR812981.1\|	10376	g26155	i0	100	100.867088607595	158	0	100	0	1	158	78440	78283	Human gammaherpesvirus 4 isolate HC-0002 genome assembly, chromosome: EBV	blastn	15937	292	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Lymphocryptovirus	Lymphocryptovirus humangamma4
16590377	16590377	PRJEB10320_P_NODE_14614_length_240_cov_1.365854_g14356_i0	PRJEB10320	14614	240	1.365854	3.2780496	Klebsiella phage RCIP0070	3094238	Viruses	Viruses	52.8	0.022	NTclustered	gi\|2622974681\|gb\|OR532864.1\|	3094238	g14356	i0	100	0.116666666666667	28	0	12	0	213	240	25100	25073	Klebsiella phage RCIP0070, complete genome	blastn	28	52.8	1	Viruses							Klebsiella phage RCIP0070
16590396	16590396	PRJEB10320_P_NODE_20554_length_189_cov_1.259740_g20296_i0	PRJEB10320	20554	189	1.25974	2.3809086	Moumouvirus sp. 'lavasanguinem'	3138182	Viruses	Viruses	91.6	3.44e-14	NTclustered	gi\|2733972295\|dbj\|LC813553.1\|	3138182	g20296	i0	78.986	4.31216931216931	138	25	72	4	53	188	315490	315355	Moumouvirus lavasanguinem DNA, nearly complete genome	blastn	815	91.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'lavasanguinem'
20108988	20108988	PRJEB10320_P_NODE_7276_length_380_cov_1.686957_g7020_i0	PRJEB10320	7276	380	1.686957	6.4104366	Megavirus	3044761	Viruses	Viruses	52.8	0.036	NTclustered	gi\|363539767\|ref\|NC_016072.1\|	1094892	g7020	i0	100	0.368421052631579	28	0	7	0	345	372	282214	282241	Megavirus chiliensis, complete genome	blastn	140	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
20414192	20414192	PRJEB10320_P_NODE_757_length_1136_cov_2.039964_g649_i0	PRJEB10320	757	1136	2.039964	23.17399104	Megavirus chilense	3060301	Viruses	Viruses	87.9	3.17e-12	NTclustered	gi\|444236153\|gb\|JX885207.1\|	1235314	g649	i0	78.417	0.70862676056338	139	26	12	4	1000	1136	304686	304822	Megavirus lba isolate LBA111, complete genome	blastn	805	87.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
21690177	21690177	PRJEB10320_P_NODE_27258_length_155_cov_0.950000_g27000_i0	PRJEB10320	27258	155	0.95	1.4725	Lymphocryptovirus humangamma4	3050299	Viruses	Viruses	287	3.21e-73	NTclustered	gi\|1540305393\|gb\|MH590479.1\|	10376	g27000	i0	100	100	155	0	100	0	1	155	156768	156614	Human gammaherpesvirus 4 isolate HKHD110, partial genome	blastn	15500	287	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Lymphocryptovirus	Lymphocryptovirus humangamma4
21690204	21690204	PRJEB10320_P_NODE_858_length_1084_cov_1.761678_g743_i0	PRJEB10320	858	1084	1.761678	19.09658952	Megavirus powaiense	3060302	Viruses	Viruses	152	1.0599999999999998e-31	NTclustered	gi\|2500352667\|ref\|NC_075034.1\|	1842663	g743	i0	78.077	7.17343173431734	260	44	25	5	2	261	328659	328905	Powai lake megavirus isolate 1, complete genome	blastn	7776	152	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus powaiense
26652598	26652598	PRJEB10320_P_NODE_6221_length_418_cov_1.443864_g5969_i0	PRJEB10320	6221	418	1.443864	6.03535152	Terrestrivirus sp.	2487775	Viruses	Viruses	103	2.12e-23	NR	AYV75160.1	2487775	g5969	i0	38.5	0.9688995215311	135	72	96.2	2	413	12	215	339	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	405	103	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
26811240	26811240	PRJEB10320_P_NODE_20341_length_190_cov_1.806452_g20083_i0	PRJEB10320	20341	190	1.806452	3.4322588	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	70.5	3.08e-12	NR	YP_010804131.1	3060017	g20083	i0	57.4	0.963157894736842	61	25	94.7	1	11	190	118	178	YP_010804131.1 bifunctional protein with cytochrome P450 domain and alkylated DNA repair dioxygenase alkb domain [Fadolivirus algeromassiliense]	diamond	183	70.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27412249	27412249	PRJEB10320_P_NODE_9023_length_331_cov_1.702703_g8765_i0	PRJEB10320	9023	331	1.702703	5.63594693	Hyperionvirus sp.	2487770	Viruses	Viruses	109	1.8899999999999999e-28	NR	AYV83304.1	2487770	g8765	i0	60	0.725075528700906	80	32	72.5	0	2	241	17	96	AYV83304.1 MAG: cysteine methyltransferase [Hyperionvirus sp.]	diamond	240	109	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
27538386	27538386	PRJEB10320_P_NODE_27444_length_154_cov_1.319328_g27186_i0	PRJEB10320	27444	154	1.319328	2.03176512	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	44.3	0.00324	NR	YP_009449258.1	2023057	g27186	i0	51.1	0.876623376623377	45	19	87.7	1	20	154	859	900	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	135	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
28006025	28006025	PRJEB10320_P_NODE_1305_length_906_cov_2.375431_g1159_i0	PRJEB10320	1305	906	2.375431	21.52140486	root	1	Root_unresolved	Root_unresolved	350	4.18e-115	NR	AYV78014.1	2487765	g1159	i0	61.4	8.09602649006623	272	103	90.1	1	3	818	205	474	AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.]	diamond	7335	350	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31044149	31044149	PRJEB10320_P_NODE_8335_length_349_cov_2.063694_g8077_i0	PRJEB10320	8335	349	2.063694	7.20229206	Indivirus ILV1	1977633	Viruses	Viruses	142	2.6899999999999993e-40	NR	ARF09980.1	1977633	g8077	i0	64.4	0.868194842406877	101	35	86	1	50	349	1	101	ARF09980.1 methyltransferase [Indivirus ILV1]	diamond	303	142	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
31802562	31802562	PRJEB10320_P_NODE_6757_length_398_cov_1.553719_g6502_i0	PRJEB10320	6757	398	1.553719	6.18380162	Bodo saltans virus	2024608	Viruses	Viruses	57.4	8.36e-7	NR	YP_010778882.1	2024608	g6502	i0	30.1	1.0251256281407	136	89	98.7	4	393	1	64	198	YP_010778882.1 hypothetical protein QJ851_gp1043 [Bodo saltans virus]	diamond	408	57.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
32309300	32309300	PRJEB10320_P_NODE_23839_length_169_cov_2.037313_g23581_i0	PRJEB10320	23839	169	2.037313	3.44305897	Pentanymphon antarcticum iridovirus	3040692	Viruses	Viruses	68.9	1.07e-13	NR	WYL19114.1	3040692	g23581	i0	67.4	3.26627218934911	46	15	81.7	0	1	138	29	74	WYL19114.1 078R-like protein [Pentanymphon antarcticum iridovirus]	diamond	552	68.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Pentanymphon antarcticum iridovirus

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