metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA896973" 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
27181953	27181953	PRJNA896973_S_NODE_1522_length_311_cov_3.193277_g1508_i0	PRJNA896973	1522	311	3.193277	9.93109147	Ripoglor virus	3130730	Viruses	Viruses	47.8	0.00147	NR	WZH60210.1	3130730	g1508	i0	31.9	0.877813504823151	91	55	84.9	3	277	14	97	183	WZH60210.1 MAG: RNA-dependent RNA polymerase [Ripoglor virus]	diamond	273	47.8	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Ripoglor virus
27435189	27435189	PRJNA896973_P_NODE_28543_length_235_cov_5.580247_g28449_i0	PRJNA896973	28543	235	5.580247	13.11358045	Tolivirales sp.	2809914	Viruses	Viruses	75.1	1.31e-13	NR	WRQ65272.1	2809914	g28449	i0	66	0.676595744680851	53	18	67.7	0	212	54	978	1030	WRQ65272.1 polyprotein [Tolivirales sp.]	diamond	159	75.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp.
27592994	27592994	PRJNA896973_P_NODE_21724_length_251_cov_0.865169_g21630_i0	PRJNA896973	21724	251	0.865169	2.17157419	Caudoviricetes sp.	2832643	Viruses	Viruses	63.5	1.15e-9	NR	XOR31489.1	2832643	g21630	i0	44.7	1.01593625498008	85	36	99.2	3	2	250	125	200	XOR31489.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	255	63.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28516234	28516234	PRJNA896973_P_NODE_23447_length_248_cov_1.314286_g23353_i0	PRJNA896973	23447	248	1.314286	3.25942928	Gervaisevirus	2843385	Viruses	Viruses	99.8	2.1599999999999998e-24	NR	QKW95377.1	2736195	g23353	i0	58.2	2.86693548387097	79	33	95.6	0	6	242	79	157	QKW95377.1 hypothetical protein [Ralstonia phage RPZH6]	diamond	711	99.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Gervaisevirus	Ralstonia phage RPZH6
28760948	28760948	PRJNA896973_P_NODE_27087_length_242_cov_1.721893_g26993_i0	PRJNA896973	27087	242	1.721893	4.16698106	Caudoviricetes sp.	2832643	Viruses	Viruses	118	4.27e-29	NR	DAS67052.1	2832643	g26993	i0	68.8	0.991735537190083	80	25	99.2	0	240	1	448	527	DAS67052.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	240	118	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30592743	30592743	PRJNA896973_P_NODE_24993_length_246_cov_0.890173_g24899_i0	PRJNA896973	24993	246	0.890173	2.18982558	Flavobacterium phage vB_FspM_immuto_2-6A	2801477	Viruses	Viruses	144	7.65e-42	NR	YP_010114475.1	2801477	g24899	i0	82.9	5	82	14	100	0	246	1	59	140	YP_010114475.1 hydrolase [Flavobacterium phage vB_FspM_immuto_2-6A]	diamond	1230	144	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Immutovirus	Immutovirus immuto
30719127	30719127	PRJNA896973_P_NODE_4834_length_473_cov_7.300000_g4740_i0	PRJNA896973	4834	473	7.3	34.529	Beihai levi-like virus 25	1922411	Viruses	Viruses	273	1.21e-86	NR	APG77018.1	1922411	g4740	i0	82.2	0.995771670190275	157	28	99.6	0	471	1	372	528	APG77018.1 hypothetical protein [Beihai levi-like virus 25]	diamond	471	273	1	Viruses							Beihai levi-like virus 25
30877175	30877175	PRJNA896973_P_NODE_23754_length_248_cov_0.880000_g23660_i0	PRJNA896973	23754	248	0.88	2.1824	Erysiphales associated mitovirus 1	2719863	Viruses	Viruses	45.1	0.00609	NR	QIP68031.1	2719863	g23660	i0	47.7	0.532258064516129	44	23	53.2	0	248	117	698	741	QIP68031.1 RNA-dependent RNA polymerase [Erysiphales associated mitovirus 1]	diamond	132	45.1	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Erysiphales associated mitovirus 1
30877177	30877177	PRJNA896973_S_NODE_1974_length_280_cov_2.458937_g1960_i0	PRJNA896973	1974	280	2.458937	6.8850236	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	76.3	9.67e-14	NR	UNY42122.1	3003959	g1960	i0	65.4	0.557142857142857	52	17	54.6	1	279	127	425	476	UNY42122.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	156	76.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30908918	30908918	PRJNA896973_S_NODE_2294_length_263_cov_2.705263_g2280_i0	PRJNA896973	2294	263	2.705263	7.11484169	Qianjiang tombus-like virus 56	3348124	Viruses	Viruses	47	0.00143	NR	XHA86470.1	3348124	g2280	i0	45.5	0.627376425855513	55	30	62.7	0	46	210	275	329	XHA86470.1 MAG: hypothetical protein [Qianjiang tombus-like virus 56]	diamond	165	47	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Qianjiang tombus-like virus 56
31699254	31699254	PRJNA896973_P_NODE_27597_length_242_cov_0.911243_g27503_i0	PRJNA896973	27597	242	0.911243	2.20520806	Meldvirus drosophila17434	3116721	Viruses	Viruses	47.4	8.78e-4	NR	DBA45728.1	3116721	g27503	i0	40.3	0.830578512396694	67	37	83.1	2	3	203	1091	1154	DBA45728.1 MAG TPA_asm: PolBa [Meldvirus drosophila17434]	diamond	201	47.4	1	Viruses							Meldvirus drosophila17434
32773825	32773825	PRJNA896973_P_NODE_19920_length_260_cov_1.459893_g19826_i0	PRJNA896973	19920	260	1.459893	3.7957218	Caudoviricetes sp.	2832643	Viruses	Viruses	72.8	1.18e-12	NR	XOE99632.1	2832643	g19826	i0	56.7	2.52692307692308	67	28	77.3	1	209	9	112	177	XOE99632.1 MAG: terminase large subunit [Caudoviricetes sp.]	diamond	657	72.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;