metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1068513" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1068513" 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
26592213	26592213	PRJNA1068513_S_NODE_10121_length_281_cov_1.125000_g10075_i0	PRJNA1068513	10121	281	1.125	3.16125	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	124	2.2599999999999996e-31	NR	YP_010803269.1	3060017	g10075	i0	65.1	0.918149466192171	86	30	91.8	0	281	24	329	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	258	124	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
26846086	26846086	PRJNA1068513_S_NODE_9841_length_286_cov_1.323944_g9795_i0	PRJNA1068513	9841	286	1.323944	3.78647984	Parvovirus dugesia6	3117077	Viruses	Viruses	44.7	0.0132	NR	DBA49073.1	3117077	g9795	i0	34.3	0.734265734265734	70	45	73.4	1	74	283	300	368	DBA49073.1 MAG TPA_asm: CressRep [Parvovirus dugesia6041]	diamond	210	44.7	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvovirus dugesia6041
26972309	26972309	PRJNA1068513_S_NODE_82_length_1327_cov_45.779904_g70_i0	PRJNA1068513	82	1327	45.779904	607.49932608	Human immunodeficiency virus 1	11676	Viruses	Viruses	44.3	0.0306	NR	ABO75472.1	11676	g70	i0	55.6	0.0610399397136398	27	12	6.1	0	649	569	9	35	ABO75472.1 gag protein, partial [Human immunodeficiency virus 1]	diamond	81	44.3	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
27098881	27098881	PRJNA1068513_S_NODE_402_length_873_cov_5.058750_g376_i0	PRJNA1068513	402	873	5.05875	44.1628875	Planaria asexual strain-specific virus-like element type 1	159252	Viruses	Viruses	83.2	7.48e-15	NR	NP_476522.1	159252	g376	i0	38.1	0.47766323024055	139	84	47.8	2	293	709	60	196	NP_476522.1 helicase [Planaria asexual strain-specific virus-like element type 1]	diamond	417	83.2	1	Viruses							Planaria asexual strain-specific virus-like element type 1
27762533	27762533	PRJNA1068513_S_NODE_4044_length_445_cov_4.750000_g3999_i0	PRJNA1068513	4044	445	4.75	21.1375	Harvfovirus sp.	2487768	Viruses	Viruses	47.8	0.00422	NR	AYV80395.1	2487768	g3999	i0	34.5	0.391011235955056	58	36	39.1	1	261	88	232	287	AYV80395.1 MAG: putative ubiquitin carboxyl-terminal hydrolase 2-like [Harvfovirus sp.]	diamond	174	47.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
28141411	28141411	PRJNA1068513_S_NODE_5125_length_401_cov_2.393293_g5080_i0	PRJNA1068513	5125	401	2.393293	9.59710493	Planaria asexual strain-specific virus-like element type 1	159252	Viruses	Viruses	47.8	0.00283	NR	NP_476526.1	159252	g5080	i0	35.4	0.613466334164589	82	52	60.6	1	361	119	191	272	NP_476526.1 Rep [Planaria asexual strain-specific virus-like element type 1]	diamond	246	47.8	1	Viruses							Planaria asexual strain-specific virus-like element type 1
28393699	28393699	PRJNA1068513_S_NODE_9266_length_296_cov_1.919283_g9220_i0	PRJNA1068513	9266	296	1.919283	5.68107768	Adintovirus sediment12437	3115945	Viruses	Viruses	90.1	1.63e-18	NR	DBA50653.1	3115945	g9220	i0	48.9	0.952702702702703	94	47	94.3	1	279	1	1069	1162	DBA50653.1 MAG TPA_asm: PolBa [Adintovirus sediment12437]	diamond	282	90.1	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus sediment12437
29025578	29025578	PRJNA1068513_S_NODE_7008_length_345_cov_1.746324_g6962_i0	PRJNA1068513	7008	345	1.746324	6.0248178	Adintovirus notospermus15	3115931	Viruses	Viruses	85.5	8.37e-18	NR	DBA47335.1	3115931	g6962	i0	50	2.12173913043478	82	39	70.4	2	11	253	133	213	DBA47335.1 MAG TPA_asm: PacK [Adintovirus notospermus15040]	diamond	732	85.5	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus notospermus15040
30857138	30857138	PRJNA1068513_S_NODE_2654_length_520_cov_1.821029_g2610_i0	PRJNA1068513	2654	520	1.821029	9.4693508	Parvovirus dugesia6	3117077	Viruses	Viruses	62.8	5.93e-8	NR	DBA49069.1	3117077	g2610	i0	25.7	0.986538461538462	171	120	95.8	3	4	501	50	218	DBA49069.1 MAG TPA_asm: VP [Parvovirus dugesia6041]	diamond	513	62.8	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvovirus dugesia6041
31932123	31932123	PRJNA1068513_S_NODE_9617_length_290_cov_0.875576_g9571_i0	PRJNA1068513	9617	290	0.875576	2.5391704	Parvovirus dugesia6	3117077	Viruses	Viruses	48.1	7.73e-4	NR	DBA49074.1	3117077	g9571	i0	39.7	0.703448275862069	68	41	70.3	0	85	288	148	215	DBA49074.1 MAG TPA_asm: Alt [Parvovirus dugesia6041]	diamond	204	48.1	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvovirus dugesia6041
32398569	32398569	PRJNA1068513_S_NODE_9359_length_294_cov_2.746606_g9313_i0	PRJNA1068513	9359	294	2.746606	8.07502164	root	1	Root_unresolved	Root_unresolved	63.9	2.48e-9	NR	YP_010841334.1	2811091	g9313	i0	39.5	3.86734693877551	76	44	77.6	1	289	62	1572	1645	YP_010841334.1 putative serine/threonine-protein kinase [Cotonvirus japonicus]	diamond	1137	64.3	0.993779160186625	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum

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