metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA635874" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA635874" and tax_kingdom = "Orthornavirae"

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
27630710	27630710	PRJNA635874_P_NODE_41384_length_265_cov_1.093750_g41237_i0	PRJNA635874	41384	265	1.09375	2.8984375	Marafivirus	12051	Viruses	Viruses	129	1.28e-32	NR	UEP57879.1	630199	g41237	i0	67	6.97358490566038	88	29	99.6	0	264	1	44	131	UEP57879.1 putative 230 kDa polyprotein, partial [Grapevine Syrah virus 1]	diamond	1848	129	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Marafivirus	Marafivirus syrahense
27713176	27713176	PRJNA635874_P_NODE_33184_length_290_cov_1.419355_g33037_i0	PRJNA635874	33184	290	1.419355	4.1161295	Olive latent virus 3	626962	Viruses	Viruses	124	1.99e-30	NR	WQF62470.1	626962	g33037	i0	59.4	0.993103448275862	96	39	99.3	0	2	289	1028	1123	WQF62470.1 MAG: replicase [Olive latent virus 3]	diamond	288	124	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Marafivirus	Marafivirus oleae
27744630	27744630	PRJNA635874_P_NODE_1204_length_1032_cov_1.980188_g1101_i0	PRJNA635874	1204	1032	1.980188	20.43554016	Guiyang Paspalum paspaloides tymo-like virus 1	2970310	Viruses	Viruses	274	5.77e-79	NR	UUW20925.1	2970310	g1101	i0	52.1	0.837209302325581	288	128	83.7	3	3	866	1843	2120	UUW20925.1 MAG: methyltransferase [Guiyang Paspalum paspaloides tymo-like virus 1]	diamond	864	274	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Guiyang Paspalum paspaloides tymo-like virus 1
28767162	28767162	PRJNA635874_P_NODE_43067_length_260_cov_1.235294_g42920_i0	PRJNA635874	43067	260	1.235294	3.2117644	Marafivirus	12051	Viruses	Viruses	48.1	5.97e-4	NR	QQG34652.1	2794433	g42920	i0	33.3	3.98076923076923	90	50	99.2	3	1	258	961	1044	QQG34652.1 polyprotein [Davidia involucrata marafivirus 1]	diamond	1035	48.1	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Marafivirus	Davidia involucrata marafivirus 1
28849261	28849261	PRJNA635874_P_NODE_7488_length_523_cov_2.313333_g7342_i0	PRJNA635874	7488	523	2.313333	12.09873159	Guiyang Paspalum paspaloides tymo-like virus 1	2970310	Viruses	Viruses	182	1.4e-49	NR	UUW20925.1	2970310	g7342	i0	53.9	0.957934990439771	167	77	95.8	0	518	18	1105	1271	UUW20925.1 MAG: methyltransferase [Guiyang Paspalum paspaloides tymo-like virus 1]	diamond	501	182	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Guiyang Paspalum paspaloides tymo-like virus 1
29493422	29493422	PRJNA635874_P_NODE_36390_length_280_cov_1.323671_g36243_i0	PRJNA635874	36390	280	1.323671	3.7062788	Chuvivirus	2842604	Viruses	Viruses	113	3.5e-27	NR	WET19887.1	2842604	g36243	i0	62	1.97142857142857	92	35	98.6	0	277	2	255	346	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	552	113	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
32104101	32104101	PRJNA635874_P_NODE_3378_length_716_cov_3.256610_g3241_i0	PRJNA635874	3378	716	3.25661	23.3173276	Pseudomonas phage ER16	2917704	Viruses	Viruses	49.3	3.44e-4	NR	UNI73398.1	2917704	g3241	i0	34.8	0.289106145251397	69	45	28.9	0	242	36	1	69	UNI73398.1 hypothetical protein ER16_Large9 [Pseudomonas phage ER16]	diamond	207	49.3	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Pseudomonas phage ER16

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