metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA408129" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA408129" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16995788	16995788	PRJNA408129_S_NODE_14814_length_196_cov_4.031447_g14796_i0	PRJNA408129	14814	196	4.031447	7.90163612	Caudoviricetes sp.	2832643	Viruses	Viruses	87	8.78e-21	NR	XOS31861.1	2832643	g14796	i0	91.5	0.719387755102041	47	4	71.9	0	143	3	3	49	XOS31861.1 MAG: hypothetical protein MSP0777_13 [Caudoviricetes sp.]	diamond	141	87	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27454979	27454979	PRJNA408129_S_NODE_3023_length_304_cov_2.595506_g3005_i0	PRJNA408129	3023	304	2.595506	7.89033824	Indomegoura indica nege-like virus 1	2830222	Viruses	Viruses	45.4	0.00606	NR	QUE41596.1	2830222	g3005	i0	60	0.394736842105263	40	15	38.5	1	124	8	10	49	QUE41596.1 ORF3 [Indomegoura indica nege-like virus 1]	diamond	120	45.4	1	Viruses	unclassified ssRNA positive-strand viruses							Indomegoura indica nege-like virus 1
27739271	27739271	PRJNA408129_S_NODE_12164_length_209_cov_3.232558_g12146_i0	PRJNA408129	12164	209	3.232558	6.75604622	Pandoravirus Pa2-1	3068388	Viruses	Viruses	42.4	0.033	NR	GMQ21468.1	3068388	g12146	i0	40.9	0.631578947368421	44	25	61.7	1	133	5	21	64	GMQ21468.1 Ankyrin repeat domain containing protein [Pandoravirus Pa2-1]	diamond	132	42.4	1	Viruses							Pandoravirus	Pandoravirus Pa2-1
28401972	28401972	PRJNA408129_S_NODE_5226_length_264_cov_3.127753_g5208_i0	PRJNA408129	5226	264	3.127753	8.25726792	Pecan associated jivivirus 1	2979118	Viruses	Viruses	70.1	1.19e-11	NR	DAZ92373.1	2979118	g5208	i0	43	0.977272727272727	86	48	96.6	1	4	258	1226	1311	DAZ92373.1 TPA_asm: P1 protein [Pecan associated jivivirus 1]	diamond	258	70.1	1	Viruses								Pecan associated jivivirus 1
28591525	28591525	PRJNA408129_S_NODE_6467_length_249_cov_5.683962_g6449_i0	PRJNA408129	6467	249	5.683962	14.15306538	Raphidiopteran orthomyxo-related virus OKIAV18	2792563	Viruses	Viruses	73.2	7.58e-13	NR	QPL15349.1	2792563	g6449	i0	57.1	0.759036144578313	63	27	75.9	0	208	20	1	63	QPL15349.1 polymerase PA [Raphidiopteran orthomyxo-related virus OKIAV180]	diamond	189	73.2	1	Viruses		Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Raphidiopteran orthomyxo-related virus OKIAV180
28654604	28654604	PRJNA408129_S_NODE_21847_length_174_cov_2.262774_g21829_i0	PRJNA408129	21847	174	2.262774	3.93722676	Menghai virus	1919071	Viruses	Viruses	76.6	1.47e-14	NR	QSL97688.1	1919071	g21829	i0	64.3	0.96551724137931	56	20	96.6	0	6	173	367	422	QSL97688.1 N protein [Menghai virus]	diamond	168	76.6	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Almendravirus	Almendravirus menghai
29191432	29191432	PRJNA408129_S_NODE_16429_length_190_cov_2.183007_g16411_i0	PRJNA408129	16429	190	2.183007	4.1477133	Penicillium vanoranjei associated RNA virus 1	2918179	Viruses	Viruses	52.8	5.14e-6	NR	BDF97667.1	2918179	g16411	i0	74.2	0.489473684210526	31	8	48.9	0	179	87	413	443	BDF97667.1 RNA-dependent RNA polymerase [Penicillium vanoranjei associated RNA virus 1]	diamond	93	52.8	1	Viruses								Penicillium vanoranjei associated RNA virus 1
29475189	29475189	PRJNA408129_S_NODE_29810_length_158_cov_3.809917_g29792_i0	PRJNA408129	29810	158	3.809917	6.01966886	Moumouvirus maliensis	2682469	Viruses	Viruses	42	0.0224	NR	QGR53984.1	2682469	g29792	i0	39.5	0.721518987341772	38	23	72.2	0	23	136	182	219	QGR53984.1 RNA helicase [Moumouvirus maliensis]	diamond	114	42	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'maliensis'
29980780	29980780	PRJNA408129_S_NODE_10231_length_220_cov_3.650273_g10213_i0	PRJNA408129	10231	220	3.650273	8.0306006	Caudoviricetes sp.	2832643	Viruses	Viruses	48.1	3.41e-4	NR	XOR29252.1	2832643	g10213	i0	32.8	0.790909090909091	58	38	77.7	1	206	36	1055	1112	XOR29252.1 MAG: DNA polymerase III alpha subunit [Caudoviricetes sp.]	diamond	174	48.1	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30391964	30391964	PRJNA408129_S_NODE_3713_length_289_cov_2.456349_g3695_i0	PRJNA408129	3713	289	2.456349	7.09884861	Adintovirus anguilla10665	3115889	Viruses	Viruses	69.3	3.84e-12	NR	DBA49783.1	3115889	g3695	i0	36.8	0.986159169550173	95	53	91.3	2	3	266	59	153	DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665]	diamond	285	69.3	1	Viruses		Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus anguilla10665
30423448	30423448	PRJNA408129_S_NODE_5913_length_255_cov_5.160550_g5895_i0	PRJNA408129	5913	255	5.16055	13.1594025	Erysiphe necator associated fusarivirus 1	2695354	Viruses	Viruses	46.6	3.78e-4	NR	QHD64835.1	2695354	g5895	i0	37.1	0.729411764705882	62	39	72.9	0	21	206	47	108	QHD64835.1 ORF-C [Erysiphe necator associated fusarivirus 1]	diamond	186	46.6	1	Viruses		Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae		Erysiphe necator associated fusarivirus 1
30960281	30960281	PRJNA408129_S_NODE_31554_length_156_cov_1.285714_g31536_i0	PRJNA408129	31554	156	1.285714	2.00571384	Caudoviricetes sp.	2832643	Viruses	Viruses	60.8	4.53e-9	NR	XOR78576.1	2832643	g31536	i0	96.4	1.05769230769231	28	1	53.8	0	154	71	658	685	XOR78576.1 MAG: putative tail fiber protein H [Caudoviricetes sp.]	diamond	165	60.8	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31181061	31181061	PRJNA408129_S_NODE_20095_length_178_cov_7.049645_g20077_i0	PRJNA408129	20095	178	7.049645	12.5483681	Acinetobacter phage vB_AbaM_ME3	1837876	Viruses	Viruses	46.2	9.16e-4	NR	YP_009595867.1	1837876	g20077	i0	36.5	0.876404494382023	52	33	87.6	0	18	173	225	276	YP_009595867.1 virion structural protein [Acinetobacter phage vB_AbaM_ME3]	diamond	156	46.2	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Metrivirus	Metrivirus ME3
31719040	31719040	PRJNA408129_S_NODE_157_length_541_cov_33.716270_g145_i0	PRJNA408129	157	541	33.71627	182.4050207	Indomegoura indica nege-like virus 1	2830222	Viruses	Viruses	175	5.239999999999999e-52	NR	QUE41596.1	2830222	g145	i0	72.5	0.66543438077634	120	32	66.5	1	531	172	89	207	QUE41596.1 ORF3 [Indomegoura indica nege-like virus 1]	diamond	360	175	1	Viruses	unclassified ssRNA positive-strand viruses							Indomegoura indica nege-like virus 1
32636024	32636024	PRJNA408129_S_NODE_2360_length_322_cov_14.063158_g2342_i0	PRJNA408129	2360	322	14.063158	45.28336876	Fusarium poae partitivirus 2	1849533	Viruses	Viruses	66.6	3.73e-10	NR	YP_009272948.1	1849533	g2342	i0	70	0.372670807453416	40	12	37.3	0	3	122	610	649	YP_009272948.1 capsid protein [Fusarium poae partitivirus 2]	diamond	120	66.6	1	Viruses		Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Fusarium poae partitivirus 2
32793432	32793432	PRJNA408129_S_NODE_24480_length_168_cov_2.519084_g24462_i0	PRJNA408129	24480	168	2.519084	4.23206112	Microvirus D_HF4_162	3071176	Viruses	Viruses	76.6	9.14e-15	NR	WMC01464.1	3071176	g24462	i0	73.3	0.803571428571429	45	12	80.4	0	142	8	50	94	WMC01464.1 DNA pilot protein [Microvirus D_HF4_162]	diamond	135	76.6	1	Viruses		Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microvirus D_HF4_162

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