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

12 rows where analysis = "diamond", bioproject = "PRJNA489308" 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
4277337	4277337	PRJNA489308_P_NODE_404_length_1223_cov_43.285217_g366_i0	PRJNA489308	404	1223	43.285217	529.37820391	Phoenicopteridae parvo-like hybrid virus	2794528	Viruses	Viruses	596	1.1799999999999996e-211	NR	QTE03744.1	2794528	g366	i0	71.4	1.88879803761243	388	110	95.2	1	18	1181	1	387	QTE03744.1 MAG: replication protein [Phoenicopteridae parvo-like hybrid virus]	diamond	2310	596	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Phoenicopteridae parvo-like hybrid virus
17027434	17027434	PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0	PRJNA489308	214	1473	66.962857	986.36288361	Psittacidae aveparvovirus	2794556	Viruses	Viruses	285	1.74e-86	NR	QTE03752.1	2794556	g184	i0	45.3	1.5050916496945	369	187	73.5	9	1110	28	165	526	QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus]	diamond	2217	285	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus
17675757	17675757	PRJNA489308_P_NODE_31754_length_250_cov_0.870056_g31678_i0	PRJNA489308	31754	250	0.870056	2.17514	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	147	4.96e-39	NR	CAK7597324.1	3072188	g31678	i0	83.1	1.968	83	14	99.6	0	250	2	272	354	CAK7597324.1 Vesicle-fusing ATPase [Catovirus sp. 'naegleriensis']	diamond	492	147	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
21499981	21499981	PRJNA489308_P_NODE_35777_length_245_cov_0.895349_g35701_i0	PRJNA489308	35777	245	0.895349	2.19360505	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	109	5.4e-26	NR	YP_010803343.1	3060017	g35701	i0	72.8	1.98367346938776	81	22	99.2	0	243	1	216	296	YP_010803343.1 inosine-5'-monophosphate dehydrogenase [Fadolivirus algeromassiliense]	diamond	486	109	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27392570	27392570	PRJNA489308_P_NODE_25303_length_267_cov_1.360825_g25227_i0	PRJNA489308	25303	267	1.360825	3.63340275	Lonomia obliqua multiple nucleopolyhedrovirus	134394	Viruses	Viruses	52.4	1.69e-5	NR	YP_009666434.1	134394	g25227	i0	38.2	0.853932584269663	76	43	85.4	1	39	266	189	260	YP_009666434.1 Inhibitor of apoptosis 2 [Lonomia obliqua multiple nucleopolyhedrovirus]	diamond	228	52.4	1	Viruses			Naldaviricetes	Lefavirales	Baculoviridae	Alphabaculovirus	Alphabaculovirus lonobliquae
27645237	27645237	PRJNA489308_P_NODE_30304_length_252_cov_1.290503_g30228_i0	PRJNA489308	30304	252	1.290503	3.25206756	Chuvivirus	2842604	Viruses	Viruses	115	7.33e-28	NR	UVF58769.1	2842604	g30228	i0	60.7	3	84	33	100	0	1	252	337	420	UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus]	diamond	756	115	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Chuvivirus
27676852	27676852	PRJNA489308_P_NODE_15504_length_310_cov_1.565401_g15428_i0	PRJNA489308	15504	310	1.565401	4.8527431	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	116	1.9000000000000003e-28	NR	YP_010803269.1	3060017	g15428	i0	49.5	0.996774193548387	103	52	99.7	0	1	309	277	379	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	309	116	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27708620	27708620	PRJNA489308_P_NODE_38064_length_242_cov_0.911243_g37988_i0	PRJNA489308	38064	242	0.911243	2.20520806	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	72.8	9.8e-13	NR	WLN26256.1	2951531	g37988	i0	43	0.979338842975207	79	45	97.9	0	238	2	132	210	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	237	72.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
28766053	28766053	PRJNA489308_P_NODE_10527_length_350_cov_2.072202_g10451_i0	PRJNA489308	10527	350	2.072202	7.252707	Megaviricetes	2732523	Viruses	Viruses	92.8	3.5e-19	NR	YP_007676312.1	755272	g10451	i0	45.7	6.96	116	54	99.4	1	1	348	231	337	YP_007676312.1 heat shock protein 70 [Micromonas pusilla virus 12T]	diamond	2436	92.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Micromonas pusilla virus 12T
28939676	28939676	PRJNA489308_P_NODE_12848_length_329_cov_1.203125_g12772_i0	PRJNA489308	12848	329	1.203125	3.95828125	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	75.1	4.24e-13	NR	YP_009448666.1	2023057	g12772	i0	52.8	0.984802431610942	108	51	98.5	0	328	5	277	384	YP_009448666.1 Flotillin domain-containing protein [Orpheovirus IHUMI-LCC2]	diamond	324	75.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
29286754	29286754	PRJNA489308_P_NODE_26669_length_262_cov_2.037037_g26593_i0	PRJNA489308	26669	262	2.037037	5.33703694	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	67	1.88e-11	NR	YP_010804033.1	3060017	g26593	i0	42.4	0.973282442748092	85	49	97.3	0	2	256	61	145	YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense]	diamond	255	67	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31941139	31941139	PRJNA489308_P_NODE_33337_length_248_cov_0.880000_g33261_i0	PRJNA489308	33337	248	0.88	2.1824	Erwinia phage vB_EamM_Kwan	1883374	Viruses	Viruses	44.3	0.0108	NR	YP_009278638.1	1883374	g33261	i0	32.3	0.786290322580645	65	44	78.6	0	48	242	37	101	YP_009278638.1 hypothetical protein BIZ80_gp266 [Erwinia phage vB_EamM_Kwan]	diamond	195	44.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Wellingtonvirus	Wellingtonvirus wellington

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