metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA512103" 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
6864247	6864247	PRJNA512103_P_NODE_6_length_10678_cov_7273.287986_g4_i0	PRJNA512103	6	10678	7273.287986	776641.69114508	Maanshan Dicis tick virus 1	2972097	Viruses	Viruses	843	6.289999999999998e-258	NR	UYL95314.1	2972097	g4	i0	32.3	4.52725229443716	1819	974	49.4	34	1997	7267	108	1731	UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1]	diamond	48342	843	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Maanshan Dicis tick virus 1
27866709	27866709	PRJNA512103_P_NODE_7065_length_504_cov_1.046154_g6659_i0	PRJNA512103	7065	504	1.046154	5.27261616	brine shrimp arlivirus 2	2900377	Viruses	Viruses	301	4.05e-99	NR	UNI74075.1	2900377	g6659	i0	87.7	1.92857142857143	162	20	96.4	0	11	496	67	228	UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2]	diamond	972	301	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsasecalis
27929999	27929999	PRJNA512103_P_NODE_27125_length_180_cov_1.274809_g26713_i0	PRJNA512103	27125	180	1.274809	2.2946562	brine shrimp arlivirus 9	2900384	Viruses	Viruses	107	2.03e-25	NR	UNI74144.1	2900384	g26713	i0	96.3	0.9	54	2	90	0	171	10	1240	1293	UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9]	diamond	162	107	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
28435223	28435223	PRJNA512103_P_NODE_26326_length_183_cov_1.358209_g25914_i0	PRJNA512103	26326	183	1.358209	2.48552247	brine shrimp arlivirus 9	2900384	Viruses	Viruses	94	1.57e-20	NR	UNI74144.1	2900384	g25914	i0	86.2	0.950819672131147	58	8	95.1	0	1	174	1792	1849	UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9]	diamond	174	94	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
29130024	29130024	PRJNA512103_P_NODE_26409_length_183_cov_1.037313_g25997_i0	PRJNA512103	26409	183	1.037313	1.89828279	brine shrimp arlivirus 9	2900384	Viruses	Viruses	110	1.7600000000000002e-26	NR	UNI74144.1	2900384	g25997	i0	91.4	0.950819672131147	58	5	95.1	0	183	10	1307	1364	UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9]	diamond	174	110	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
29697708	29697708	PRJNA512103_P_NODE_25430_length_187_cov_0.963768_g25018_i0	PRJNA512103	25430	187	0.963768	1.80224616	Fusarium culmorum yue-like virus 1	3233859	Viruses	Viruses	43.9	0.00683	NR	XCO56027.1	3233859	g25018	i0	42.4	1.82887700534759	59	32	94.7	1	3	179	456	512	XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1]	diamond	342	43.9	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Fusarium culmorum yue-like virus 1
29824260	29824260	PRJNA512103_P_NODE_32591_length_165_cov_1.413793_g32179_i0	PRJNA512103	32591	165	1.413793	2.33275845	brine shrimp arlivirus 9	2900384	Viruses	Viruses	103	6.529999999999999e-24	NR	UNI74144.1	2900384	g32179	i0	86.8	0.963636363636364	53	7	96.4	0	160	2	57	109	UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9]	diamond	159	103	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
31150979	31150979	PRJNA512103_P_NODE_32375_length_166_cov_0.888889_g31963_i0	PRJNA512103	32375	166	0.888889	1.47555574	Chuvivirus	2842604	Viruses	Viruses	76.6	1.47e-14	NR	UVF58769.1	2842604	g31963	i0	65.3	0.885542168674699	49	17	88.6	0	159	13	357	405	UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus]	diamond	147	76.6	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Chuvivirus
31910476	31910476	PRJNA512103_P_NODE_6797_length_520_cov_1.908705_g6393_i0	PRJNA512103	6797	520	1.908705	9.925266	Fusarium culmorum yue-like virus 1	3233859	Viruses	Viruses	68.2	9.27e-10	NR	XCO56027.1	3233859	g6393	i0	31.8	0.853846153846154	148	89	85.4	2	48	491	590	725	XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1]	diamond	444	68.2	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Fusarium culmorum yue-like virus 1
32163756	32163756	PRJNA512103_P_NODE_25118_length_188_cov_1.057554_g24706_i0	PRJNA512103	25118	188	1.057554	1.98820152	Hebei betayadokarivirus	3372915	Viruses	Viruses	48.1	2.25e-4	NR	XHZ00044.1	3372915	g24706	i0	37	1.72340425531915	54	34	86.2	0	170	9	926	979	XHZ00044.1 MAG: RNA-dependent RNA polymerase [Hebei betayadokarivirus]	diamond	324	48.1	1	Viruses	Orthornavirae	Pisuviricota		Yadokarivirales	Yadokariviridae	Betayadokarivirus	Hebei betayadokarivirus
32432265	32432265	PRJNA512103_P_NODE_26679_length_182_cov_1.045113_g26267_i0	PRJNA512103	26679	182	1.045113	1.90210566	Lispiviridae	2501987	Viruses	Viruses	99.4	1.6000000000000002e-22	NR	UNI74076.1	2900377	g26267	i0	80.7	1.86263736263736	57	11	94	0	180	10	454	510	UNI74076.1 MAG: hypothetical protein [brine shrimp arlivirus 2]	diamond	339	99.4	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsasecalis

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