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

14 rows where bioproject = "PRJNA900028" 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
6349191	6349191	PRJNA900028_P_NODE_29385_length_241_cov_1.328125_g28636_i0	PRJNA900028	29385	241	1.328125	3.20078125	root	1	Root_unresolved	Root_unresolved	440	3.959999999999999e-119	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g28636	i0	99.585	99.9958506224066	241	1	100	0	1	241	16944	16704	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	24099	440	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
8527112	8527112	PRJNA900028_P_NODE_106127_length_173_cov_1.233871_g105378_i0	PRJNA900028	106127	173	1.233871	2.13459683	Orthopoxvirus	10242	Viruses	Viruses	93.6	8.25e-22	NR	ATB55171.1	10243	g105378	i0	100	22.8901734104046	44	0	76.3	0	134	3	1	44	ATB55171.1 CPXV129 protein [Cowpox virus]	diamond	3960	93.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus cowpox
8528657	8528657	PRJNA900028_P_NODE_66947_length_191_cov_0.830986_g66198_i0	PRJNA900028	66947	191	0.830986	1.58718326	Erythrocytic necrosis virus	1543320	Viruses	Viruses	78.7	2.71e-10	NTclustered	gi\|1624806751\|gb\|MK638742.1\|	1543320	g66198	i0	95.918	0.837696335078534	49	1	25	1	27	74	60	108	Erythrocytic necrosis virus isolate SEQ_14 putative RNA-dependent DNA polymerase mRNA, complete cds	blastn	160	78.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
12725055	12725055	PRJNA900028_P_NODE_59510_length_197_cov_2.635135_g58761_i0	PRJNA900028	59510	197	2.635135	5.19121595	root	1	Root_unresolved	Root_unresolved	364	1.929999999999999e-96	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g58761	i0	100	100	197	0	100	0	1	197	13251	13055	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	19700	364	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
13999324	13999324	PRJNA900028_P_NODE_4351_length_514_cov_4.666667_g3623_i0	PRJNA900028	4351	514	4.666667	23.98666838	root	1	Root_unresolved	Root_unresolved	869	0	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g3623	i0	98.016	98.0544747081712	504	1	98	1	5	508	14729	15223	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	50400	869	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
17823102	17823102	PRJNA900028_P_NODE_70814_length_189_cov_1.271429_g70065_i0	PRJNA900028	70814	189	1.271429	2.40300081	root	1	Root_unresolved	Root_unresolved	350	5.14e-92	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g70065	i0	100	100	189	0	100	0	1	189	17989	18177	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	18900	350	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
20371540	20371540	PRJNA900028_P_NODE_3316_length_593_cov_3.027574_g2603_i0	PRJNA900028	3316	593	3.027574	17.95351382	root	1	Root_unresolved	Root_unresolved	1074	0	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g2603	i0	99.327	100.168634064081	594	3	100	1	1	593	11551	10958	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	59400	1079	0.995366079703429	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
27845331	27845331	PRJNA900028_P_NODE_75024_length_187_cov_1.471014_g74275_i0	PRJNA900028	75024	187	1.471014	2.75079618	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	81.3	4.73e-16	NR	VBB18416.1	2420051	g74275	i0	69	0.93048128342246	58	18	93	0	4	177	143	200	VBB18416.1 68 kDa protein, putative [Yasminevirus sp. GU-2018]	diamond	174	81.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
27916107	27916107	PRJNA900028_P_NODE_126745_length_167_cov_0.864407_g125996_i0	PRJNA900028	126745	167	0.864407	1.44355969	Orthopoxvirus	10242	Viruses	Viruses	115	3.23e-28	NR	WBA78916.1	10244	g125996	i0	100	28.6526946107784	55	0	98.8	0	1	165	582	636	WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus]	diamond	4785	115	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
28074056	28074056	PRJNA900028_P_NODE_8505_length_375_cov_1.561350_g7759_i0	PRJNA900028	8505	375	1.56135	5.8550625	Orthopoxvirus	10242	Viruses	Viruses	250	1.08e-75	NR	XEX53185.1	10244	g7759	i0	99.2	29.952	125	1	100	0	375	1	165	289	XEX53185.1 mRNA capping enzyme large subunit [Monkeypox virus]	diamond	11232	250	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
28792521	28792521	PRJNA900028_P_NODE_174567_length_163_cov_0.894737_g173818_i0	PRJNA900028	174567	163	0.894737	1.45842131	Tupanvirus soda lake	2126985	Viruses	Viruses	68.9	5.38e-12	NR	YP_010781579.1	2126985	g173818	i0	58.5	0.975460122699387	53	22	97.5	0	3	161	86	138	YP_010781579.1 hypothetical protein QJ857_gp1128 [Tupanvirus soda lake]	diamond	159	68.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
31256448	31256448	PRJNA900028_P_NODE_21015_length_267_cov_2.247706_g20266_i0	PRJNA900028	21015	267	2.247706	6.00137502	Camelpox virus	28873	Viruses	Viruses	180	1.2e-50	NR	NP_570494.1	28873	g20266	i0	97.7	9.98876404494382	88	2	98.9	0	266	3	465	552	NP_570494.1 CMLV104 [Camelpox virus]	diamond	2667	180	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus camelpox
31454014	31454014	PRJNA900028_P_NODE_55696_length_201_cov_1.677632_g54947_i0	PRJNA900028	55696	201	1.677632	3.37204032	Orthopoxvirus	10242	Viruses	Viruses	120	6.67e-30	NR	WBA78916.1	10244	g54947	i0	100	29.1044776119403	61	0	91	0	199	17	698	758	WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus]	diamond	5850	120	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
31952306	31952306	PRJNA900028_P_NODE_92077_length_179_cov_1.569231_g91328_i0	PRJNA900028	92077	179	1.569231	2.80892349	Erythrocytic necrosis virus	1543320	Viruses	Viruses	79	7.44e-16	NR	QCF47454.1	1543320	g91328	i0	64.4	4.84357541899441	59	21	98.9	0	179	3	151	209	QCF47454.1 hypothetical protein, partial [Erythrocytic necrosis virus]	diamond	867	79	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus

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