metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA451191" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA451191" 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_species
18292289	18292289	PRJNA451191_P_NODE_37755_length_232_cov_1.140351_g37484_i0	PRJNA451191	37755	232	1.140351	2.64561432	Adintovirus tegillarca14448	3115949	Viruses	Viruses	57	1.68e-7	NR	DBA51532.1	3115949	g37484	i0	47.4	0.737068965517241	57	30	73.7	0	33	203	143	199	DBA51532.1 MAG TPA_asm: PacK [Adintovirus tegillarca14448]	diamond	171	57	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus tegillarca14448
27297342	27297342	PRJNA451191_P_NODE_18763_length_333_cov_1.511029_g18492_i0	PRJNA451191	18763	333	1.511029	5.03172657	brine shrimp rhabdovirus 1	2900475	Viruses	Viruses	149	9.529999999999999e-43	NR	UNI73975.1	2900475	g18492	i0	66.1	0.981981981981982	109	37	98.2	0	6	332	60	168	UNI73975.1 MAG: hypothetical protein [brine shrimp rhabdovirus 1]	diamond	327	149	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	brine shrimp rhabdovirus 1
28465824	28465824	PRJNA451191_P_NODE_1386_length_1505_cov_69.879501_g1268_i0	PRJNA451191	1386	1505	69.879501	1051.68649005	Riboviria sp.	2585031	Viruses	Viruses	246	1.14e-72	NR	UBJ26091.1	2585031	g1268	i0	37.4	0.735548172757475	369	216	73.2	7	30	1130	6	361	UBJ26091.1 putative capsid protein [Riboviria sp.]	diamond	1107	246	1	Viruses						Riboviria sp.
28592080	28592080	PRJNA451191_P_NODE_39487_length_227_cov_1.078313_g39216_i0	PRJNA451191	39487	227	1.078313	2.44777051	brine shrimp rhabdovirus 1	2900475	Viruses	Viruses	101	7.709999999999999e-23	NR	UNI73977.1	2900475	g39216	i0	58.7	0.991189427312775	75	31	99.1	0	226	2	59	133	UNI73977.1 MAG: RNA-dependent RNA polymerase [brine shrimp rhabdovirus 1]	diamond	225	101	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	brine shrimp rhabdovirus 1
28844380	28844380	PRJNA451191_P_NODE_39188_length_227_cov_2.686747_g38917_i0	PRJNA451191	39188	227	2.686747	6.09891569	Permutotetraviridae sp.	2585115	Viruses	Viruses	43.5	0.0159	NR	WWV86538.1	2585115	g38917	i0	35.8	1.81057268722467	67	41	88.5	1	221	21	320	384	WWV86538.1 MAG: putative capsid protein, partial [Permutotetraviridae sp.]	diamond	411	43.5	1	Viruses	Orthornavirae				Permutotetraviridae	Permutotetraviridae sp.
29760044	29760044	PRJNA451191_P_NODE_331_length_2903_cov_67.874032_g290_i0	PRJNA451191	331	2903	67.874032	1970.38314896	Virus sp.	2202649	Viruses	Viruses	596	2.51e-202	NR	QVG74731.1	2202649	g290	i0	63	0.44746813641061	433	160	44.7	0	1544	2842	4	436	QVG74731.1 RNA-dependent RNA polymerase [Virus sp.]	diamond	1299	596	1	Viruses						Virus sp.
31624656	31624656	PRJNA451191_P_NODE_196_length_3634_cov_61.479149_g170_i0	PRJNA451191	196	3634	61.479149	2234.15227466	Fusarium culmorum yue-like virus 1	3233859	Viruses	Viruses	345	2.16e-97	NR	XCO56027.1	3233859	g170	i0	27.3	1.652724270776	950	637	77.7	16	3137	315	86	990	XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1]	diamond	6006	345	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae	Fusarium culmorum yue-like virus 1
31719620	31719620	PRJNA451191_P_NODE_45857_length_211_cov_0.866667_g45586_i0	PRJNA451191	45857	211	0.866667	1.82866737	Vibrio phage vB_pir	2762667	Viruses	Viruses	121	1.01e-30	NR	QNI21190.1	2762667	g45586	i0	80.9	0.966824644549763	68	13	96.7	0	6	209	7	74	QNI21190.1 hypothetical protein [Vibrio phage vB_pir03]	diamond	204	121	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Vibrio phage vB_pir03
31719623	31719623	PRJNA451191_P_NODE_9777_length_486_cov_1.376471_g9507_i0	PRJNA451191	9777	486	1.376471	6.68964906	Xanthomonas phage Xoo-sp14	2769337	Viruses	Viruses	59.7	4.8e-7	NR	QNR51805.1	2769337	g9507	i0	30.7	0.845679012345679	137	86	84.6	3	38	448	44	171	QNR51805.1 putative virion structural protein [Xanthomonas phage Xoo-sp14]	diamond	411	59.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Xanthomonas phage Xoo-sp14
31909411	31909411	PRJNA451191_P_NODE_55617_length_200_cov_2.460432_g55346_i0	PRJNA451191	55617	200	2.460432	4.920864	Adintovirus tegillarca14448	3115949	Viruses	Viruses	57.8	5.92e-8	NR	DBA51532.1	3115949	g55346	i0	38.7	2.88	62	38	93	0	187	2	138	199	DBA51532.1 MAG TPA_asm: PacK [Adintovirus tegillarca14448]	diamond	576	57.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus tegillarca14448

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