metadata: contig_metadata: 10 rows where bioproject = "PRJEB80557" and tax

10 rows where bioproject = "PRJEB80557" 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
18848303	18848303	PRJEB80557_S_NODE_4455_length_402_cov_1.348442_g4059_i0	PRJEB80557	4455	402	1.348442	5.42073684	root	1	Root_unresolved	Root_unresolved	737	0	NTclustered	gi\|2648012127\|gb\|PP068615.1\|	10515	g4059	i0	99.751	100	402	1	100	0	1	402	13650	13249	Human adenovirus 2 isolate HAdV-C2/USA/5R6/2010, complete genome	blastn	40200	743	0.991924629878869	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
19264758	19264758	PRJEB80557_S_NODE_6456_length_346_cov_9.124579_g6060_i0	PRJEB80557	6456	346	9.124579	31.57104334	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.033	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g6060	i0	94.286	0.101156069364162	35	1	10	1	211	244	153509	153475	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
25222767	25222767	PRJEB80557_S_NODE_9580_length_294_cov_2.522449_g9184_i0	PRJEB80557	9580	294	2.522449	7.41600006	root	1	Root_unresolved	Root_unresolved	544	3.69e-150	NTclustered	gi\|2288721861\|gb\|OP218818.1\|	10535	g9184	i0	100	100	294	0	100	0	1	294	13777	14070	Unidentified adenovirus strain CHOP Ad5	blastn	29400	544	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	unidentified adenovirus
26970840	26970840	PRJEB80557_S_NODE_12942_length_258_cov_1.492823_g12546_i0	PRJEB80557	12942	258	1.492823	3.85148334	Orchesella springtail adintovirus	2609862	Viruses	Viruses	125	1.1399999999999999e-32	NR	DAC81371.1	2609862	g12546	i0	65.1	1	86	30	100	0	1	258	65	150	DAC81371.1 TPA_asm: integrase [Orchesella springtail adintovirus]	diamond	258	125	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Orchesella springtail adintovirus
30697648	30697648	PRJEB80557_S_NODE_29754_length_177_cov_2.523438_g29358_i0	PRJEB80557	29754	177	2.523438	4.46648526	Thermus phage phiKo	2301535	Viruses	Viruses	58.9	3.49e-9	NR	AYJ74698.1	2301535	g29358	i0	79.3	0.491525423728814	29	6	49.2	0	64	150	44	72	AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo]	diamond	87	58.9	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
30761043	30761043	PRJEB80557_S_NODE_34274_length_167_cov_0.872881_g33878_i0	PRJEB80557	34274	167	0.872881	1.45771127	Orchesella springtail adintovirus	2609862	Viruses	Viruses	83.6	2.13e-17	NR	DAC81371.1	2609862	g33878	i0	69.1	0.988023952095808	55	17	98.8	0	1	165	158	212	DAC81371.1 TPA_asm: integrase [Orchesella springtail adintovirus]	diamond	165	83.6	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Orchesella springtail adintovirus
31488202	31488202	PRJEB80557_S_NODE_17796_length_224_cov_1.251429_g17400_i0	PRJEB80557	17796	224	1.251429	2.80320096	Thermus phage phiKo	2301535	Viruses	Viruses	86.7	5.23e-19	NR	AYJ74689.1	2301535	g17400	i0	68.3	0.803571428571429	60	17	77.7	1	175	2	133	192	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	180	86.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
31709377	31709377	PRJEB80557_S_NODE_30977_length_174_cov_1.640000_g30581_i0	PRJEB80557	30977	174	1.64	2.8536	Thermus phage phiKo	2301535	Viruses	Viruses	42	0.00436	NR	AYJ74697.1	2301535	g30581	i0	60	0.603448275862069	35	12	56.9	1	122	24	37	71	AYJ74697.1 hypothetical protein phiKo_22 [Thermus phage phiKo]	diamond	105	42	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
31930694	31930694	PRJEB80557_S_NODE_1837_length_574_cov_2.948571_g1448_i0	PRJEB80557	1837	574	2.948571	16.92479754	Thermus phage phiKo	2301535	Viruses	Viruses	77.8	1.14e-14	NR	AYJ74698.1	2301535	g1448	i0	55	0.313588850174216	60	26	31.4	1	202	23	10	68	AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo]	diamond	180	77.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
32595217	32595217	PRJEB80557_S_NODE_26380_length_188_cov_1.115108_g25984_i0	PRJEB80557	26380	188	1.115108	2.09640304	Nucleocytoviricota sp. D1	3116512	Viruses	Viruses	60.8	2.66e-9	NR	BFG87833.1	3116512	g25984	i0	59.6	1.81914893617021	52	21	83	0	156	1	40	91	BFG87833.1 GIY-YIg catalytic domain-containing endonuclease [Nucleocytoviricota sp. D1]	diamond	342	60.8	1	Viruses	Bamfordvirae	Nucleocytoviricota					Nucleocytoviricota sp. D1

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