metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA657343" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA657343" 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
27302745	27302745	PRJNA657343_P_NODE_26563_length_187_cov_1.500000_g26539_i0	PRJNA657343	26563	187	1.5	2.805	Kaumoebavirus	1859492	Viruses	Viruses	46.2	0.00107	NR	QQV29407.1	1859492	g26539	i0	41.2	0.818181818181818	51	29	81.8	1	171	19	48	97	QQV29407.1 dual oxidase [Kaumoebavirus]	diamond	153	46.2	1	Viruses							Kaumoebavirus
27460710	27460710	PRJNA657343_P_NODE_39983_length_165_cov_1.560345_g39959_i0	PRJNA657343	39983	165	1.560345	2.57456925	Tupanvirus soda lake	2126985	Viruses	Viruses	85.1	1.41e-17	NR	YP_010782185.1	2126985	g39959	i0	70.4	1.96363636363636	54	16	98.2	0	2	163	374	427	YP_010782185.1 peptidase inhibitor I9 [Tupanvirus soda lake]	diamond	324	85.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
28060423	28060423	PRJNA657343_P_NODE_36565_length_168_cov_0.873950_g36541_i0	PRJNA657343	36565	168	0.87395	1.468236	Cotonvirus japonicus	2811091	Viruses	Viruses	55.8	3.17e-7	NR	YP_010841863.1	2811091	g36541	i0	51	1.85714285714286	49	24	87.5	0	8	154	939	987	YP_010841863.1 hypothetical protein QLL95_gp0868 [Cotonvirus japonicus]	diamond	312	55.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
28817939	28817939	PRJNA657343_S_NODE_28428_length_167_cov_1.762712_g28403_i0	PRJNA657343	28428	167	1.762712	2.94372904	Gammaretrovirus murleu	3428959	Viruses	Viruses	108	7.480000000000001e-26	NR	8WUS_E	11801	g28403	i0	98.2	7.90419161676647	55	1	98.8	0	1	165	254	308	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	1320	108	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28849635	28849635	PRJNA657343_P_NODE_3828_length_383_cov_3.077844_g3805_i0	PRJNA657343	3828	383	3.077844	11.78814252	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	52	1.05e-4	NR	YP_009449258.1	2023057	g3805	i0	34.8	1.51958224543081	92	52	68.1	5	78	338	162	250	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	582	52	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
29102553	29102553	PRJNA657343_P_NODE_25068_length_191_cov_1.063380_g25044_i0	PRJNA657343	25068	191	1.06338	2.0310558	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	68.2	8.16e-12	NR	YP_009449316.1	2023057	g25044	i0	63.6	0.691099476439791	44	16	69.1	0	186	55	204	247	YP_009449316.1 Fatty acid hydroxylase (C-5 sterol desaturase putative) [Orpheovirus IHUMI-LCC2]	diamond	132	68.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
29986575	29986575	PRJNA657343_P_NODE_28271_length_183_cov_1.477612_g28247_i0	PRJNA657343	28271	183	1.477612	2.70402996	uncultured virus	340016	Viruses	Viruses	52	9.09e-6	NR	CAH6419989.1	340016	g28247	i0	59.1	1.62295081967213	44	18	72.1	0	28	159	35	78	CAH6419989.1 Hypothetical protein HVR_LOCUS1046, partial [uncultured virus]	diamond	297	52	1	Viruses							uncultured virus
30271180	30271180	PRJNA657343_P_NODE_2652_length_438_cov_2.311054_g2629_i0	PRJNA657343	2652	438	2.311054	10.12241652	Pandoravirus inopinatum	1605721	Viruses	Viruses	46.6	0.012	NR	YP_009120448.1	1605721	g2629	i0	37.2	0.643835616438356	94	44	62.3	2	413	141	140	221	YP_009120448.1 hypothetical protein TW95_gp1479 [Pandoravirus inopinatum]	diamond	282	46.6	1	Viruses						Pandoravirus	Pandoravirus inopinatum
30302992	30302992	PRJNA657343_S_NODE_18032_length_213_cov_1.579268_g18007_i0	PRJNA657343	18032	213	1.579268	3.36384084	Gammaretrovirus murleu	3428959	Viruses	Viruses	145	2.97e-39	NR	8WUS_E	11801	g18007	i0	100	6	71	0	100	0	1	213	192	262	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	1278	145	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
30966194	30966194	PRJNA657343_P_NODE_20474_length_206_cov_0.955414_g20450_i0	PRJNA657343	20474	206	0.955414	1.96815284	Terrestrivirus sp.	2487775	Viruses	Viruses	107	1.54e-25	NR	AYV76711.1	2487775	g20450	i0	72.7	8.60679611650485	66	18	96.1	0	199	2	12	77	AYV76711.1 MAG: hypothetical protein Terrestrivirus12_14 [Terrestrivirus sp.]	diamond	1773	107	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31630003	31630003	PRJNA657343_P_NODE_36476_length_168_cov_0.873950_g36452_i0	PRJNA657343	36476	168	0.87395	1.468236	Klosneuvirus KNV1	1977640	Viruses	Viruses	62.4	1.6e-9	NR	ARF12058.1	1977640	g36452	i0	60.9	0.821428571428571	46	18	82.1	0	13	150	415	460	ARF12058.1 aminotransferase class-III [Klosneuvirus KNV1]	diamond	138	62.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
31851251	31851251	PRJNA657343_P_NODE_35237_length_169_cov_0.866667_g35213_i0	PRJNA657343	35237	169	0.866667	1.46466723	Catovirus CTV1	1977631	Viruses	Viruses	80.9	6.6e-17	NR	ARF08362.1	1977631	g35213	i0	69.8	24.4615384615385	53	16	94.1	0	4	162	105	157	ARF08362.1 cyclophilin type peptidyl-prolyl cis-trans isomerase [Catovirus CTV1]	diamond	4134	80.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
31851252	31851252	PRJNA657343_P_NODE_37357_length_167_cov_1.677966_g37333_i0	PRJNA657343	37357	167	1.677966	2.80220322	Pandoravirus dulcis	1349409	Viruses	Viruses	41.6	0.0344	NR	YP_008319013.1	1349409	g37333	i0	42.9	0.754491017964072	42	24	75.4	0	134	9	256	297	YP_008319013.1 hypothetical protein pdul_cds_333 [Pandoravirus dulcis]	diamond	126	41.6	1	Viruses						Pandoravirus	Pandoravirus dulcis
32021871	32021871	PRJNA657343_S_NODE_15538_length_230_cov_2.872928_g15513_i0	PRJNA657343	15538	230	2.872928	6.6077344	Gammaretrovirus	153135	Viruses	Viruses	142	3.89e-37	NR	NP_057933.2	11801	g15513	i0	98.7	14.8695652173913	76	1	99.1	0	228	1	1181	1256	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	3420	142	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
32168006	32168006	PRJNA657343_P_NODE_44158_length_162_cov_0.920354_g44134_i0	PRJNA657343	44158	162	0.920354	1.49097348	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	58.5	8.14e-9	NR	YP_009449036.1	2023057	g44134	i0	51.2	0.796296296296296	43	21	79.6	0	139	11	49	91	YP_009449036.1 Hypothetical protein ORPV_830 [Orpheovirus IHUMI-LCC2]	diamond	129	58.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense

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