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

8 rows where analysis = "diamond", bioproject = "PRJNA719595" 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
12188631	12188631	PRJNA719595_P_NODE_2450_length_387_cov_1.710191_g2415_i0	PRJNA719595	2450	387	1.710191	6.61843917	Chrysanthemum virus B	12165	Viruses	Viruses	242	2.33e-71	NR	UGL76538.1	12165	g2415	i0	91.4	2.96899224806202	128	11	99.2	0	3	386	1073	1200	UGL76538.1 replicase [Chrysanthemum virus B]	diamond	1149	242	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus betachrysanthemi
27873297	27873297	PRJNA719595_P_NODE_8345_length_246_cov_0.901734_g8310_i0	PRJNA719595	8345	246	0.901734	2.21826564	uncultured phage MedDCM-OCT-S46-C1	278008	Viruses	Viruses	70.5	4.96e-12	NR	YP_009777829.1	2741074	g8310	i0	53.7	2.74390243902439	67	30	81.7	1	242	42	43	108	YP_009777829.1 tail fiber protein [uncultured phage MedDCM-OCT-S46-C10]	diamond	675	70.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales		Foussvirus	Foussvirus S46C10
29010381	29010381	PRJNA719595_P_NODE_7808_length_248_cov_0.891429_g7773_i0	PRJNA719595	7808	248	0.891429	2.21074392	uncultured marine virus	186617	Viruses	Viruses	107	8.2e-28	NR	BCV08434.1	186617	g7773	i0	87	0.653225806451613	54	6	65.3	1	3	164	66	118	BCV08434.1 MAG: hypothetical protein CM15mL5_2090 [uncultured marine virus]	diamond	162	107	1	Viruses							uncultured marine virus
30178330	30178330	PRJNA719595_P_NODE_1332_length_507_cov_1.433180_g1298_i0	PRJNA719595	1332	507	1.43318	7.2662226	Carya illinoinensis carlavirus 1	2794420	Viruses	Viruses	324	3.73e-99	NR	QQG34672.1	2794420	g1298	i0	97.6	1	169	4	100	0	1	507	1493	1661	QQG34672.1 RdRp [Carya illinoinensis carlavirus 1]	diamond	507	324	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carya illinoinensis carlavirus 1
30694411	30694411	PRJNA719595_P_NODE_8213_length_247_cov_0.896552_g8178_i0	PRJNA719595	8213	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	51.6	1.27e-5	NR	BAR18313.1	1407671	g8178	i0	43.1	2.61133603238866	72	36	87.4	1	6	221	39	105	BAR18313.1 hypothetical protein [uncultured Mediterranean phage uvMED]	diamond	645	52	0.992307692307692	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
30873523	30873523	PRJNA719595_P_NODE_7494_length_249_cov_0.886364_g7459_i0	PRJNA719595	7494	249	0.886364	2.20704636	uncultured marine virus	186617	Viruses	Viruses	137	8.82e-36	NR	BCU95492.1	186617	g7459	i0	76.8	0.987951807228916	82	19	98.8	0	248	3	440	521	BCU95492.1 MAG: hypothetical protein CM15mV9_1050 [uncultured marine virus]	diamond	246	137	1	Viruses							uncultured marine virus
31600823	31600823	PRJNA719595_P_NODE_8096_length_247_cov_0.896552_g8061_i0	PRJNA719595	8096	247	0.896552	2.21448344	Prochlorococcus phage P-SSM7	445688	Viruses	Viruses	64.7	1.55e-11	NR	YP_004324882.1	445688	g8061	i0	68.4	0.923076923076923	38	12	46.2	0	119	6	1	38	YP_004324882.1 hypothetical protein PSSM7_051 [Prochlorococcus phage P-SSM7]	diamond	228	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae	Palaemonvirus	Palaemonvirus pssm7
32675622	32675622	PRJNA719595_P_NODE_2940_length_358_cov_1.164912_g2905_i0	PRJNA719595	2940	358	1.164912	4.17038496	Chrysanthemum yellow edge associated virus 2	3025447	Viruses	Viruses	77	1.23e-13	NR	WCL16046.1	3025447	g2905	i0	46.5	0.720670391061452	86	45	71.2	1	1	255	351	436	WCL16046.1 inclusion body protein [Chrysanthemum yellow edge associated virus 2]	diamond	258	77	1	Viruses							Chrysanthemum yellow edge associated virus 2

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