metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1010662" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1010662" 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
2705233	2705233	PRJNA1010662_S_NODE_3_length_2060_cov_31.965791_g2_i0	PRJNA1010662	3	2060	31.965791	658.4952946	Moloney murine leukemia virus	11801	Viruses	Viruses	1282	0	NR	NP_057933.2	11801	g2	i0	97.5	2.85291262135922	653	16	95.1	0	82	2040	677	1329	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5877	1282	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
3552049	3552049	PRJNA1010662_S_NODE_23_length_1074_cov_8.774006_g15_i0	PRJNA1010662	23	1074	8.774006	94.23282444	Bundibugyo virus	565995	Viruses	Viruses	580	4.199999999999999e-207	NR	YP_003815434.1	565995	g15	i0	100	0.818435754189944	293	0	81.8	0	194	1072	1	293	YP_003815434.1 matrix protein [Bundibugyo virus]	diamond	879	580	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Filoviridae	Orthoebolavirus	Orthoebolavirus bundibugyoense
17579342	17579342	PRJNA1010662_S_NODE_3554_length_180_cov_8.051095_g3509_i0	PRJNA1010662	3554	180	8.051095	14.491971	Bundibugyo virus	565995	Viruses	Viruses	88.2	5.26e-19	NR	YP_003815434.1	565995	g3509	i0	100	0.666666666666667	40	0	66.7	0	179	60	287	326	YP_003815434.1 matrix protein [Bundibugyo virus]	diamond	120	88.2	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Filoviridae	Orthoebolavirus	Orthoebolavirus bundibugyoense
26932137	26932137	PRJNA1010662_P_NODE_17422_length_152_cov_2.009709_g17363_i0	PRJNA1010662	17422	152	2.009709	3.05475768	Alphabaculovirus	558016	Viruses	Viruses	72	5.45e-15	NR	NP_037883.1	10454	g17363	i0	68	2.96052631578947	50	16	98.7	0	3	152	2	51	NP_037883.1 ORF123 v-ubiquitin [Spodoptera exigua multiple nucleopolyhedrovirus]	diamond	450	72	1	Viruses			Naldaviricetes	Lefavirales	Baculoviridae	Alphabaculovirus	Spodoptera exigua multiple nucleopolyhedrovirus
27002678	27002678	PRJNA1010662_P_NODE_8262_length_198_cov_1.852349_g8203_i0	PRJNA1010662	8262	198	1.852349	3.66765102	Betapolyomavirus macacae	1891767	Viruses	Viruses	55.8	4.78e-7	NR	AAK29054.1	1891767	g8203	i0	64.3	0.636363636363636	42	15	63.6	0	136	11	494	535	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	126	55.8	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
27508670	27508670	PRJNA1010662_P_NODE_11503_length_174_cov_1.664000_g11444_i0	PRJNA1010662	11503	174	1.664	2.89536	Barrevirus sp.	2487763	Viruses	Viruses	70.9	1.25e-12	NR	AYV77123.1	2487763	g11444	i0	57.1	0.96551724137931	56	24	96.6	0	2	169	250	305	AYV77123.1 MAG: GDP-mannose 4,6 dehydratase [Barrevirus sp.]	diamond	168	70.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29402955	29402955	PRJNA1010662_P_NODE_5649_length_228_cov_2.351955_g5590_i0	PRJNA1010662	5649	228	2.351955	5.3624574	Caudoviricetes sp.	2832643	Viruses	Viruses	42.7	0.00302	NR	DAV81047.1	2832643	g5590	i0	50	0.5	38	19	50	0	76	189	9	46	DAV81047.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	114	42.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31393526	31393526	PRJNA1010662_P_NODE_5456_length_232_cov_1.125683_g5397_i0	PRJNA1010662	5456	232	1.125683	2.61158456	Caudoviricetes sp.	2832643	Viruses	Viruses	43.1	0.0249	NR	DAT67653.1	2832643	g5397	i0	40.3	2.58620689655172	62	36	80.2	1	1	186	1473	1533	DAT67653.1 MAG TPA: Large polyvalent protein associated domain 23 [Caudoviricetes sp.]	diamond	600	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31520015	31520015	PRJNA1010662_P_NODE_14196_length_166_cov_0.880342_g14137_i0	PRJNA1010662	14196	166	0.880342	1.46136772	Mimivirus LCMiAC	2506609	Viruses	Viruses	43.5	0.00706	NR	QBK89022.1	2506609	g14137	i0	68	2.69277108433735	25	8	45.2	0	8	82	20	44	QBK89022.1 MAG: MORN repeat protein [Mimivirus LCMiAC02]	diamond	447	43.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Mimivirus LCMiAC02
32152582	32152582	PRJNA1010662_P_NODE_13078_length_168_cov_0.873950_g13019_i0	PRJNA1010662	13078	168	0.87395	1.468236	Homavirus sp.	2487769	Viruses	Viruses	91.7	8.09e-20	NR	AYV82270.1	2487769	g13019	i0	67.3	0.982142857142857	55	18	98.2	0	165	1	439	493	AYV82270.1 MAG: hypothetical protein Homavirus23_1, partial [Homavirus sp.]	diamond	165	91.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
32500844	32500844	PRJNA1010662_S_NODE_2659_length_203_cov_1.500000_g2614_i0	PRJNA1010662	2659	203	1.5	3.045	Erysiphe necator associated ssRNA virus 13	2743179	Viruses	Viruses	56.2	3.87e-7	NR	QKN22659.1	2743179	g2614	i0	49.1	0.842364532019704	57	29	84.2	0	201	31	1060	1116	QKN22659.1 replicase [Erysiphe necator associated ssRNA virus 13]	diamond	171	56.2	1	Viruses							Erysiphe necator associated ssRNA virus 13
32689722	32689722	PRJNA1010662_P_NODE_12600_length_169_cov_0.866667_g12541_i0	PRJNA1010662	12600	169	0.866667	1.46466723	uncultured Caudovirales phage	2100421	Viruses	Viruses	64.7	1.58e-10	NR	CAB4159814.1	2100421	g12541	i0	59.2	1.7396449704142	49	20	87	0	14	160	29	77	CAB4159814.1 hypothetical protein UFOVP726_42 [uncultured Caudovirales phage]	diamond	294	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch

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