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

8 rows where analysis = "diamond", bioproject = "PRJNA1025141" 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
9090424	9090424	PRJNA1025141_P_NODE_6388_length_317_cov_0.946721_g6327_i0	PRJNA1025141	6388	317	0.946721	3.00110557	Japanese yam mosaic virus	79917	Viruses	Viruses	188	6.47e-53	NR	AIT13016.1	79917	g6327	i0	81	1.98738170347003	105	20	99.4	0	2	316	2056	2160	AIT13016.1 polyprotein [Japanese yam mosaic virus]	diamond	630	188	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nippodioscoreae
12916534	12916534	PRJNA1025141_P_NODE_4551_length_381_cov_1.025974_g4490_i0	PRJNA1025141	4551	381	1.025974	3.90896094	Cryphonectria naterciae splipalmivirus 1	2841740	Viruses	Viruses	142	2.1899999999999998e-40	NR	BCX55511.1	2841740	g4490	i0	58.7	0.992125984251969	126	51	99.2	1	2	379	26	150	BCX55511.1 hypothetical protein 1 [Cryphonectria naterciae splipalmivirus 1]	diamond	378	142	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus cryphonectriae
28108734	28108734	PRJNA1025141_P_NODE_13185_length_241_cov_0.904762_g13124_i0	PRJNA1025141	13185	241	0.904762	2.18047642	Marsupial endogenous gammaretrovirus 2	3386030	Viruses	Viruses	58.2	1.32e-7	NR	DBA62711.1	3386030	g13124	i0	46.9	0.796680497925311	64	34	79.7	0	48	239	479	542	DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2]	diamond	192	58.2	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Marsupial endogenous gammaretrovirus 2
28866636	28866636	PRJNA1025141_P_NODE_12308_length_243_cov_0.905882_g12247_i0	PRJNA1025141	12308	243	0.905882	2.20129326	Yam chlorotic necrosis virus	2175329	Viruses	Viruses	145	2.83e-38	NR	YP_010086840.1	2175329	g12247	i0	87.3	0.975308641975309	79	10	97.5	0	242	6	1630	1708	YP_010086840.1 polyprotein [Yam chlorotic necrosis virus]	diamond	237	145	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Macluravirus	Macluravirus dioscoreaflavinecrosis
29371928	29371928	PRJNA1025141_P_NODE_7129_length_297_cov_1.491071_g7068_i0	PRJNA1025141	7129	297	1.491071	4.42848087	Japanese yam mosaic virus	79917	Viruses	Viruses	187	1.6699999999999999e-52	NR	AJD23395.1	79917	g7068	i0	91.8	1.97979797979798	98	8	99	0	2	295	1770	1867	AJD23395.1 polyprotein [Japanese yam mosaic virus]	diamond	588	187	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nippodioscoreae
30477492	30477492	PRJNA1025141_P_NODE_9833_length_250_cov_0.870056_g9772_i0	PRJNA1025141	9833	250	0.870056	2.17514	Pandoravirus japonicus	2823154	Viruses	Viruses	53.5	6.29e-6	NR	BCU03105.1	2823154	g9772	i0	51.2	0.984	41	20	49.2	0	177	55	226	266	BCU03105.1 morn repeat domain [Pandoravirus japonicus]	diamond	246	53.5	1	Viruses						Pandoravirus	Pandoravirus japonicus
30793217	30793217	PRJNA1025141_P_NODE_3594_length_430_cov_1.299720_g3533_i0	PRJNA1025141	3594	430	1.29972	5.588796	Grapevine wood holobiome associated narna-like virus 18	3398654	Viruses	Viruses	81.3	2.57e-16	NR	XOD45390.1	3398654	g3533	i0	39	0.948837209302326	136	76	90	5	389	3	6	141	XOD45390.1 HP2 [Grapevine wood holobiome associated narna-like virus 18]	diamond	408	81.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 18
32311550	32311550	PRJNA1025141_P_NODE_11979_length_244_cov_0.900585_g11918_i0	PRJNA1025141	11979	244	0.900585	2.1974274	Pseudomonas phage ER16	2917704	Viruses	Viruses	68.2	3.73e-11	NR	UNI73393.1	2917704	g11918	i0	43.2	1.99180327868852	81	42	94.7	2	3	233	206	286	UNI73393.1 RNA dependent RNA polymerase [Pseudomonas phage ER16]	diamond	486	68.2	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);;