metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1093380" 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
18050716	18050716	PRJNA1093380_P_NODE_10255_length_260_cov_1.978610_g10149_i0	PRJNA1093380	10255	260	1.97861	5.144386	Gammaretrovirus	153135	Viruses	Viruses	172	1.8e-47	NR	NP_057933.2	11801	g10149	i0	98.8	1.98461538461538	86	1	99.2	0	260	3	1232	1317	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	516	172	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26940936	26940936	PRJNA1093380_P_NODE_13242_length_248_cov_3.234286_g13136_i0	PRJNA1093380	13242	248	3.234286	8.02102928	Orthomarburgvirus marburgense	3052505	Viruses	Viruses	170	7.18e-47	NR	AAR85459.1	3052505	g13136	i0	98.8	1.98387096774194	82	1	99.2	0	248	3	1179	1260	AAR85459.1 L protein [Orthomarburgvirus marburgense]	diamond	492	170	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Filoviridae	Orthomarburgvirus	Orthomarburgvirus marburgense
27035986	27035986	PRJNA1093380_P_NODE_12762_length_249_cov_1.880682_g12656_i0	PRJNA1093380	12762	249	1.880682	4.68289818	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	93.2	6.42e-20	NR	QDP60537.1	2591644	g12656	i0	58	0.831325301204819	69	29	83.1	0	247	41	189	257	QDP60537.1 MAG: putative ATP-dependent DNA helicase [Prokaryotic dsDNA virus sp.]	diamond	207	93.2	1	Viruses							Prokaryotic dsDNA virus sp.
27288849	27288849	PRJNA1093380_P_NODE_9803_length_263_cov_1.621053_g9697_i0	PRJNA1093380	9803	263	1.621053	4.26336939	Agrobacterium phage Atu_ph	3435407	Viruses	Viruses	104	6.28e-25	NR	YP_009612140.1	2024264	g9697	i0	63.2	0.992395437262357	87	32	99.2	0	2	262	40	126	YP_009612140.1 hypothetical protein FDI40_gp475 [Agrobacterium phage Atu_ph07]	diamond	261	104	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Polybotosvirus	Polybotosvirus Atuph07
29530775	29530775	PRJNA1093380_P_NODE_4470_length_304_cov_1.000000_g4364_i0	PRJNA1093380	4470	304	1	3.04	Jiangsu mito-like virus 11	2937150	Viruses	Viruses	87.8	1.16e-17	NR	UPW42172.1	2937150	g4364	i0	51.1	0.888157894736842	90	43	88.8	1	2	271	473	561	UPW42172.1 MAG: putative RNA dependent RNA polymerase [Jiangsu mito-like virus 11]	diamond	270	87.8	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Jiangsu mito-like virus 11
31015472	31015472	PRJNA1093380_P_NODE_8795_length_269_cov_1.387755_g8689_i0	PRJNA1093380	8795	269	1.387755	3.73306095	Ralstonia phage RSK1	1417599	Viruses	Viruses	115	4.97e-28	NR	YP_008853800.1	1417599	g8689	i0	76.7	0.95910780669145	86	15	94.8	2	268	14	419	500	YP_008853800.1 released from the phage upon host infection [Ralstonia phage RSK1]	diamond	258	115	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Firingavirus	Firingavirus RSK1
32439057	32439057	PRJNA1093380_P_NODE_12739_length_249_cov_2.295455_g12633_i0	PRJNA1093380	12739	249	2.295455	5.71568295	Porcine circovirus 2	85708	Viruses	Viruses	43.5	0.0178	NR	AIT52334.1	85708	g12633	i0	56.3	0.385542168674699	32	14	38.6	0	210	115	109	140	AIT52334.1 truncated ORF2 [Porcine circovirus 2]	diamond	96	43.5	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Circovirus porcine2
32461879	32461879	PRJNA1093380_P_NODE_12179_length_251_cov_0.865169_g12073_i0	PRJNA1093380	12179	251	0.865169	2.17157419	Firingavirus	2843381	Viruses	Viruses	145	4.3499999999999997e-38	NR	YP_008853801.1	1417599	g12073	i0	86.7	3.9681274900398402	83	11	99.2	0	3	251	976	1058	YP_008853801.1 putative transglycosylase [Ralstonia phage RSK1]	diamond	996	145	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Firingavirus	Firingavirus RSK1

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