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

8 rows where analysis = "diamond", bioproject = "PRJNA1032461" 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
27129508	27129508	PRJNA1032461_S_NODE_13462_length_172_cov_1.024390_g13364_i0	PRJNA1032461	13462	172	1.02439	1.7619508	ssRNA phage Esthiorhiza.4_1	2786089	Viruses	Viruses	51.2	3.32e-6	NR	YP_010769712.1	2786090	g13364	i0	60	0.697674418604651	40	16	69.8	0	171	52	90	129	YP_010769712.1 coat protein [ssRNA phage Esthiorhiza.4_10]	diamond	120	51.2	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Phobpsivirus	Phobpsivirus agradaptatum
27698898	27698898	PRJNA1032461_S_NODE_2884_length_327_cov_1.762590_g2786_i0	PRJNA1032461	2884	327	1.76259	5.7636693	Leviviridae sp.	2027243	Viruses	Viruses	117	9.06e-29	NR	URG16378.1	2027243	g2786	i0	62.4	1.8348623853211	93	35	85.3	0	49	327	6	98	URG16378.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	600	117	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
28077342	28077342	PRJNA1032461_S_NODE_14185_length_169_cov_0.866667_g14087_i0	PRJNA1032461	14185	169	0.866667	1.46466723	Pseudomonas phage vB_PsaM_M1	2995601	Viruses	Viruses	73.2	2.35e-13	NR	UZS00927.1	2995601	g14087	i0	62.3	2.85798816568047	53	20	94.1	0	161	3	4	56	UZS00927.1 tail sheath protein [Pseudomonas phage vB_PsaM_M1]	diamond	483	73.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Andersonviridae		Pseudomonas phage vB_PaeM_M1
29719010	29719010	PRJNA1032461_S_NODE_14870_length_168_cov_1.882353_g14772_i0	PRJNA1032461	14870	168	1.882353	3.16235304	Caudoviricetes sp.	2832643	Viruses	Viruses	73.2	1.77e-15	NR	DAI61056.1	2832643	g14772	i0	67.9	0.946428571428571	53	15	94.6	1	160	2	2	52	DAI61056.1 MAG TPA: repressor [Caudoviricetes sp.]	diamond	159	73.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30659065	30659065	PRJNA1032461_S_NODE_17833_length_165_cov_1.793103_g17735_i0	PRJNA1032461	17833	165	1.793103	2.95861995	Viruses	10239	Viruses	Viruses	79.3	1.31e-15	NR	URG16378.1	2027243	g17735	i0	59.3	5.89090909090909	54	22	98.2	0	1	162	279	332	URG16378.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	972	79.3	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
30856567	30856567	PRJNA1032461_S_NODE_12474_length_177_cov_2.742188_g12376_i0	PRJNA1032461	12474	177	2.742188	4.85367276	Betapolyomavirus macacae	1891767	Viruses	Viruses	50.1	8.22e-6	NR	AAS20328.1	1891767	g12376	i0	53.8	0.661016949152542	39	18	66.1	0	48	164	81	119	AAS20328.1 large tumor antigen, partial [Betapolyomavirus macacae]	diamond	117	50.1	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31868259	31868259	PRJNA1032461_S_NODE_10697_length_189_cov_1.664286_g10599_i0	PRJNA1032461	10697	189	1.664286	3.14550054	Leviviridae sp.	2027243	Viruses	Viruses	79.7	1.39e-15	NR	URG15777.1	2027243	g10599	i0	57.1	1.98412698412698	63	26	98.4	1	2	187	328	390	URG15777.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	375	79.7	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
32627324	32627324	PRJNA1032461_S_NODE_10440_length_191_cov_1.718310_g10342_i0	PRJNA1032461	10440	191	1.71831	3.2819721	Leviviridae sp.	2027243	Viruses	Viruses	60.5	1.04e-8	NR	UJQ85322.1	2027243	g10342	i0	74.3	2.18324607329843	35	9	55	0	111	7	210	244	UJQ85322.1 MAG: putative replicase protein [Leviviridae sp.]	diamond	417	60.5	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.

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