metadata: contig_metadata: 14 rows where bioproject = "PRJNA681822" and tax

14 rows where bioproject = "PRJNA681822" and tax_kingdom = "Bamfordvirae"

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
8823389	8823389	PRJNA681822_P_NODE_28367_length_710_cov_1.357928_g27017_i0	PRJNA681822	28367	710	1.357928	9.6412888	root	1	Root_unresolved	Root_unresolved	1312	0	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g27017	i0	100	100	710	0	100	0	1	710	13311	14020	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	71000	1312	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
9584575	9584575	PRJNA681822_P_NODE_463188_length_243_cov_0.905882_g461698_i0	PRJNA681822	463188	243	0.905882	2.20129326	Yellowstone lake mimivirus	1586712	Viruses	Viruses	182	2.68e-41	NTclustered	gi\|941356135\|dbj\|LC015646.1\|	1586712	g461698	i0	82.381	1.72839506172839	210	35	86	2	30	238	6365	6573	Yellowstone lake mimivirus DNA, complete genome, isolate: 1	blastn	420	182	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Yellowstone lake mimivirus
10100062	10100062	PRJNA681822_S_NODE_2008_length_153_cov_2.483871_g1983_i0	PRJNA681822	2008	153	2.483871	3.80032263	root	1	Root_unresolved	Root_unresolved	283	4.0799999999999995e-72	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g1983	i0	100	99.9869281045752	153	0	100	0	1	153	17417	17265	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	15298	283	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
12650234	12650234	PRJNA681822_P_NODE_446950_length_245_cov_0.877907_g445461_i0	PRJNA681822	446950	245	0.877907	2.15087215	root	1	Root_unresolved	Root_unresolved	453	5.1900000000000006e-123	NTclustered	gi\|15485521\|emb\|AJ293908.1\|	10515	g445461	i0	100	99.9918367346939	245	0	100	0	1	245	1366	1122	Human adenovirus type 2 penton gene, isolate 352	blastn	24498	453	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
16472565	16472565	PRJNA681822_P_NODE_117893_length_370_cov_1.555556_g116407_i0	PRJNA681822	117893	370	1.555556	5.7555572	root	1	Root_unresolved	Root_unresolved	684	0	NTclustered	gi\|2079660852\|emb\|OU501478.1\|	10515	g116407	i0	100	100	370	0	100	0	1	370	11894	11525	Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE	blastn	37000	684	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
16472762	16472762	PRJNA681822_P_NODE_168313_length_328_cov_1.756863_g166825_i0	PRJNA681822	168313	328	1.756863	5.76251064	root	1	Root_unresolved	Root_unresolved	606	5.249999999999998e-169	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g166825	i0	100	99.9969512195122	328	0	100	0	1	328	16187	15860	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	32799	606	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
19022919	19022919	PRJNA681822_P_NODE_62215_length_474_cov_2.162095_g60744_i0	PRJNA681822	62215	474	2.162095	10.2483303	Mastadenovirus	10509	Viruses	Viruses	876	0	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g60744	i0	100	100.050632911392	474	0	100	0	1	474	16954	16481	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	47424	876	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
20296118	20296118	PRJNA681822_P_NODE_118536_length_369_cov_2.929054_g117049_i0	PRJNA681822	118536	369	2.929054	10.80820926	root	1	Root_unresolved	Root_unresolved	682	0	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g117049	i0	100	100	369	0	100	0	1	369	12094	12462	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	36900	682	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
26607001	26607001	PRJNA681822_P_NODE_492921_length_226_cov_4.254902_g491431_i0	PRJNA681822	492921	226	4.254902	9.61607852	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	87	7.16e-18	NR	YP_010803055.1	3060017	g491431	i0	55.4	0.982300884955752	74	28	98.2	1	222	1	367	435	YP_010803055.1 asparaginyl-tRNA synthetase class IIb [Fadolivirus algeromassiliense]	diamond	222	87	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
26923871	26923871	PRJNA681822_P_NODE_388522_length_251_cov_0.865169_g387033_i0	PRJNA681822	388522	251	0.865169	2.17157419	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	48.9	2.76e-4	NR	BCT22646.1	RQ14	g387033	i0	67.6	0.406374501992032	34	11	40.6	0	1	102	687	720	BCT22646.1 virion core protein P4b [Carp edema virus]	diamond	102	48.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
27050490	27050490	PRJNA681822_P_NODE_454742_length_244_cov_0.900585_g453252_i0	PRJNA681822	454742	244	0.900585	2.1974274	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	44.3	0.00223	NR	BCT22591.1	RQ14	g453252	i0	41.8	0.823770491803279	67	35	82.4	2	42	242	1	63	BCT22591.1 hypothetical protein [Carp edema virus]	diamond	201	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
27208222	27208222	PRJNA681822_P_NODE_419262_length_247_cov_1.770115_g417773_i0	PRJNA681822	419262	247	1.770115	4.37218405	Klosneuvirus KNV1	1977640	Viruses	Viruses	110	1.32e-27	NR	ARF11372.1	1977640	g417773	i0	60	0.97165991902834	80	32	97.2	0	242	3	132	211	ARF11372.1 START domain protein [Klosneuvirus KNV1]	diamond	240	110	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28218725	28218725	PRJNA681822_P_NODE_185626_length_317_cov_1.110656_g184138_i0	PRJNA681822	185626	317	1.110656	3.52077952	Terrestrivirus sp.	2487775	Viruses	Viruses	56.2	7.01e-7	NR	AYV76183.1	2487775	g184138	i0	38.8	0.634069400630915	67	40	62.5	1	317	120	134	200	AYV76183.1 MAG: hypothetical protein Terrestrivirus5_5 [Terrestrivirus sp.]	diamond	201	56.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31535988	31535988	PRJNA681822_P_NODE_453396_length_244_cov_0.900585_g451906_i0	PRJNA681822	453396	244	0.900585	2.1974274	Adintovirus homo7556	3115916	Viruses	Viruses	54.3	3.14e-6	NR	DBA48859.1	3115916	g451906	i0	30.3	0.934426229508197	76	51	91	1	236	15	356	431	DBA48859.1 MAG TPA_asm: PolBb [Adintovirus homo7556]	diamond	228	54.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus homo7556

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