metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax_kingdom = "Orthornavirae"

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
27618495	27618495	PRJNA643700_P_NODE_356544_length_182_cov_1.834586_g354988_i0	PRJNA643700	356544	182	1.834586	3.33894652	Nidovirus hypomesus2	3116752	Viruses	Viruses	68.2	1.79e-11	NR	DBA47674.1	3116752	g354988	i0	50	0.956043956043956	58	29	95.6	0	180	7	404	461	DBA47674.1 MAG TPA_asm: ORF1ab polyprotein [Nidovirus hypomesus20729]	diamond	174	68.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales			Nidovirus hypomesus20729
27725759	27725759	PRJNA643700_P_NODE_124824_length_370_cov_0.919003_g123269_i0	PRJNA643700	124824	370	0.919003	3.4003111	Viruses	10239	Viruses	Viruses	194	7.709999999999998e-55	NR	QUS52660.1	2832174	g123269	i0	68.9	1.97837837837838	122	38	98.9	0	3	368	147	268	QUS52660.1 RNA-dependent RNA polymerase [Mute swan feces associated noda-like virus 2]	diamond	732	194	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		Mute swan feces associated noda-like virus 2
27870843	27870843	PRJNA643700_P_NODE_287045_length_217_cov_1.005952_g285489_i0	PRJNA643700	287045	217	1.005952	2.18291584	Aspergillus lentulus narnavirus 1	2747489	Viruses	Viruses	47.4	5.99e-4	NR	BCH36645.1	2747489	g285489	i0	55.3	0.525345622119816	38	17	52.5	0	217	104	283	320	BCH36645.1 hypothetical protein [Aspergillus lentulus narnavirus 1]	diamond	114	47.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Aspergillus lentulus narnavirus 1
27902321	27902321	PRJNA643700_P_NODE_353445_length_184_cov_1.155556_g351889_i0	PRJNA643700	353445	184	1.155556	2.12622304	Penicillium citrinum ourmia-like virus 1	2485924	Viruses	Viruses	97.4	9.01e-22	NR	YP_010797622.1	2485924	g351889	i0	73.3	0.978260869565217	60	16	97.8	0	182	3	117	176	YP_010797622.1 RNA-dependent RNA polymerase [Penicillium citrinum ourmia-like virus 1]	diamond	180	97.4	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Magoulivirus	Magoulivirus penicillii
28249693	28249693	PRJNA643700_P_NODE_16146_length_926_cov_4.101482_g15245_i0	PRJNA643700	16146	926	4.101482	37.97972332	African cichlid piscichuvirus	3065075	Viruses	Viruses	147	1.49e-35	NR	WLN26256.1	3065075	g15245	i0	42.3	0.61231101511879	189	105	59.9	2	16	570	46	234	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	567	147	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
28849561	28849561	PRJNA643700_P_NODE_398488_length_167_cov_0.881356_g396932_i0	PRJNA643700	398488	167	0.881356	1.47186452	Grapevine wood holobiome associated narna-like virus 6	3398663	Viruses	Viruses	45.8	0.00105	NR	XOD45342.1	3398663	g396932	i0	38.9	0.970059880239521	54	33	97	0	3	164	144	197	XOD45342.1 HP2 [Grapevine wood holobiome associated narna-like virus 6]	diamond	162	45.8	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 6
29480920	29480920	PRJNA643700_P_NODE_380090_length_172_cov_1.065041_g378534_i0	PRJNA643700	380090	172	1.065041	1.83187052	Betachrysovirus aspergilli	2164061	Viruses	Viruses	62	2.31e-9	NR	YP_010088025.1	2164061	g378534	i0	56.9	0.88953488372093	51	22	89	0	20	172	323	373	YP_010088025.1 capsid protein [Betachrysovirus aspergilli]	diamond	153	62	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Betachrysovirus	Betachrysovirus aspergilli
30586635	30586635	PRJNA643700_P_NODE_410333_length_165_cov_0.896552_g408777_i0	PRJNA643700	410333	165	0.896552	1.4793108	Betachrysovirus aspergilli	2164061	Viruses	Viruses	66.2	6.51e-11	NR	YP_010088028.1	2164061	g408777	i0	62	0.909090909090909	50	19	90.9	0	15	164	248	297	YP_010088028.1 RNA-dependent RNA polymerase [Betachrysovirus aspergilli]	diamond	150	66.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Betachrysovirus	Betachrysovirus aspergilli
32021850	32021850	PRJNA643700_P_NODE_394198_length_168_cov_0.873950_g392642_i0	PRJNA643700	394198	168	0.87395	1.468236	Umbravirus	39734	Viruses	Viruses	51.2	1.35e-5	NR	QKW91260.1	2231771	g392642	i0	47.2	3.78571428571429	53	28	94.6	0	3	161	82	134	QKW91260.1 replication associated protein [Sclerotinia sclerotiorum umbra-like virus 3]	diamond	636	51.2	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Umbravirus	Sclerotinia sclerotiorum umbra-like virus 3

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