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

11 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_phylum = "Lenarviricota"

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
16711890	16711890	PRJEB73599_P_NODE_94_length_2186_cov_6.146036_g63_i0	PRJEB73599	94	2186	6.146036	134.35234696	Mitoviridae sp.	2809572	Viruses	Viruses	543	1.2599999999999995e-180	NR	URG16541.1	2809572	g63	i0	44.5	0.952424519670631	694	381	94.7	3	2111	42	21	714	URG16541.1 MAG: RNA dependent RNA polymerase, partial [Mitoviridae sp.]	diamond	2082	543	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
27508283	27508283	PRJEB73599_P_NODE_4543_length_315_cov_2.195804_g4256_i0	PRJEB73599	4543	315	2.195804	6.9167826	Ripashan virus	3131120	Viruses	Viruses	64.3	2.29e-9	NR	WZH60887.1	3131120	g4256	i0	50	0.59047619047619	62	31	59	0	5	190	603	664	WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus]	diamond	186	64.3	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripashan virus
27761017	27761017	PRJEB73599_P_NODE_84_length_2241_cov_8.401447_g55_i0	PRJEB73599	84	2241	8.401447	188.27642727	Chrocafunk virus	3129695	Viruses	Viruses	230	6.1e-67	NR	WZH58726.1	3129695	g55	i0	52.9	0.281124497991968	210	97	28.1	2	1387	758	2	209	WZH58726.1 MAG: RNA-dependent RNA polymerase, partial [Chrocafunk virus]	diamond	630	230	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Chrocafunk virus
29213336	29213336	PRJEB73599_P_NODE_6589_length_231_cov_2.702970_g6302_i0	PRJEB73599	6589	231	2.70297	6.2438607	Proteus mito-like virus	2912713	Viruses	Viruses	62.4	3.7e-9	NR	DAZ87243.1	2912713	g6302	i0	46.1	0.987012987012987	76	40	98.7	1	2	229	430	504	DAZ87243.1 TPA_asm: RNA-dependent polymerase [Proteus mito-like virus]	diamond	228	62.4	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Proteus mito-like virus
29307769	29307769	PRJEB73599_P_NODE_8589_length_179_cov_1.613333_g8302_i0	PRJEB73599	8589	179	1.613333	2.88786607	Ripashan virus	3131120	Viruses	Viruses	68.9	9.06e-12	NR	WZH60887.1	3131120	g8302	i0	69.2	0.871508379888268	52	13	87.2	1	1	156	712	760	WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus]	diamond	156	68.9	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripashan virus
30350611	30350611	PRJEB73599_P_NODE_3712_length_364_cov_1.982090_g3426_i0	PRJEB73599	3712	364	1.98209	7.2148076	Ripatrop virus	3131332	Viruses	Viruses	63.2	9.88e-9	NR	WZH61242.1	3131332	g3426	i0	27	0.947802197802198	115	68	89.8	4	354	28	347	451	WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus]	diamond	345	63.2	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripatrop virus
30350612	30350612	PRJEB73599_P_NODE_4272_length_330_cov_1.936877_g3985_i0	PRJEB73599	4272	330	1.936877	6.3916941	Ripashan virus	3131120	Viruses	Viruses	168	6.63e-46	NR	WZH60887.1	3131120	g3985	i0	72.5	0.990909090909091	109	30	99.1	0	3	329	261	369	WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus]	diamond	327	168	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripashan virus
30665983	30665983	PRJEB73599_P_NODE_3913_length_351_cov_3.624224_g3627_i0	PRJEB73599	3913	351	3.624224	12.72102624	Proteus mito-like virus	2912713	Viruses	Viruses	44.7	0.0267	NR	DAZ87243.1	2912713	g3627	i0	32.9	0.64957264957265	76	49	63.2	1	222	1	14	89	DAZ87243.1 TPA_asm: RNA-dependent polymerase [Proteus mito-like virus]	diamond	228	44.7	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Proteus mito-like virus
30919002	30919002	PRJEB73599_P_NODE_9014_length_171_cov_1.549296_g8727_i0	PRJEB73599	9014	171	1.549296	2.64929616	ssRNA phage SRR7976357_8	2786748	Viruses	Viruses	58.5	4.46e-9	NR	YP_010769076.1	2786748	g8727	i0	87.1	0.543859649122807	31	4	54.4	0	93	1	1	31	YP_010769076.1 coat protein [ssRNA phage SRR7976357_8]	diamond	93	58.5	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Ashucavirus	Ashucavirus caenivicinum
31013547	31013547	PRJEB73599_P_NODE_8535_length_180_cov_1.748344_g8248_i0	PRJEB73599	8535	180	1.748344	3.1470192	Ripatrop virus	3131332	Viruses	Viruses	73.9	1.53e-13	NR	WZH61242.1	3131332	g8248	i0	50.8	0.983333333333333	59	28	98.3	1	2	178	164	221	WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus]	diamond	177	73.9	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripatrop virus
31962260	31962260	PRJEB73599_P_NODE_1058_length_733_cov_2.144886_g877_i0	PRJEB73599	1058	733	2.144886	15.72201438	Ripashan virus	3131120	Viruses	Viruses	194	3.32e-53	NR	WZH60887.1	3131120	g877	i0	58.4	0.679399727148704	166	67	67.1	1	162	653	54	219	WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus]	diamond	498	194	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripashan virus

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