metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA799842" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA799842" 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
27316081	27316081	PRJNA799842_P_NODE_59323_length_369_cov_1.543919_g57750_i0	PRJNA799842	59323	369	1.543919	5.69706111	Deltapartitivirus	1511810	Viruses	Viruses	130	6.8399999999999985e-34	NR	QRG29188.1	2562459	g57750	i0	51.3	1.90243902439024	117	57	95.1	0	368	18	179	295	QRG29188.1 putative CP [Camellia oleifera cryptic virus 1]	diamond	702	130	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Deltapartitivirus	Camellia oleifera cryptic virus 1
27465003	27465003	PRJNA799842_P_NODE_26223_length_574_cov_1.421158_g24670_i0	PRJNA799842	26223	574	1.421158	8.15744692	brine shrimp arlivirus 8	2900383	Viruses	Viruses	217	9.000000000000002e-66	NR	UNI74120.1	2900383	g24670	i0	56.4	0.945993031358885	181	79	94.6	0	560	18	187	367	UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8]	diamond	543	217	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsaeighalis
27505592	27505592	PRJNA799842_P_NODE_94303_length_299_cov_1.022124_g92730_i0	PRJNA799842	94303	299	1.022124	3.05615076	root	1	Root_unresolved	Root_unresolved	118	1.54e-29	NR	UHA47118.1	351495	g92730	i0	58.6	3.93311036789298	99	40	99.3	1	299	3	217	314	UHA47118.1 hypothetical protein [Raphanus sativus cryptic virus 2]	diamond	1176	119	0.991596638655462	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Raphanus sativus cryptic virus 2
27654458	27654458	PRJNA799842_P_NODE_61584_length_363_cov_1.013793_g60011_i0	PRJNA799842	61584	363	1.013793	3.68006859	brine shrimp arlivirus 5	2900380	Viruses	Viruses	206	7.76e-63	NR	UNI74090.1	2900380	g60011	i0	82.5	0.991735537190083	120	21	99.2	0	2	361	256	375	UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5]	diamond	360	206	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
28033350	28033350	PRJNA799842_P_NODE_63805_length_357_cov_0.950704_g62232_i0	PRJNA799842	63805	357	0.950704	3.39401328	Raphanus sativus cryptic virus 2	351495	Viruses	Viruses	119	1.64e-29	NR	YP_001686784.1	351495	g62232	i0	51.7	0.974789915966387	116	56	97.5	0	6	353	99	214	YP_001686784.1 unknown [Raphanus sativus cryptic virus 2]	diamond	348	119	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Raphanus sativus cryptic virus 2
28105166	28105166	PRJNA799842_P_NODE_26065_length_576_cov_1.530815_g24513_i0	PRJNA799842	26065	576	1.530815	8.8174944	Picornavirales	464095	Viruses	Viruses	158	5.439999999999999e-42	NR	URG14575.1	1530251	g24513	i0	43.2	7.91666666666667	185	104	95.8	1	2	553	53	237	URG14575.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	4560	158	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28285505	28285505	PRJNA799842_P_NODE_114326_length_274_cov_1.149254_g112753_i0	PRJNA799842	114326	274	1.149254	3.14895596	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	52.8	1.69e-5	NR	XCM68122.1	3003959	g112753	i0	46.3	0.733576642335766	67	32	69	2	61	249	948	1014	XCM68122.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.]	diamond	201	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28285577	28285577	PRJNA799842_P_NODE_866_length_2459_cov_3.443839_g663_i0	PRJNA799842	866	2459	3.443839	84.68400101	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	310	3.77e-89	NR	XCM67884.1	3003959	g663	i0	32.7	3.11468076453843	623	390	73.4	12	1894	89	9	623	XCM67884.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	7659	310	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28443796	28443796	PRJNA799842_P_NODE_162866_length_246_cov_0.890173_g161293_i0	PRJNA799842	162866	246	0.890173	2.18982558	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	124	7.53e-31	NR	QDH89622.1	3003959	g161293	i0	78.8	0.975609756097561	80	17	97.6	0	245	6	677	756	QDH89622.1 MAG: hypothetical protein H1RhizoLitter1238_000002 [Picornavirales sp.]	diamond	240	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28475253	28475253	PRJNA799842_P_NODE_42566_length_436_cov_2.168044_g40994_i0	PRJNA799842	42566	436	2.168044	9.45267184	Marnaviridae sp.	2715102	Viruses	Viruses	62.4	4.1e-8	NR	ULF99925.1	2715102	g40994	i0	33	0.729357798165138	106	70	72.9	1	323	6	753	857	ULF99925.1 MAG: hypothetical protein 2 [Marnaviridae sp.]	diamond	318	62.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
29043710	29043710	PRJNA799842_P_NODE_162268_length_246_cov_0.890173_g160695_i0	PRJNA799842	162268	246	0.890173	2.18982558	Botryosphaeria dothidea botrexvirus 1	2785370	Viruses	Viruses	102	9.87e-25	NR	QQD86175.1	2785370	g160695	i0	59.8	1	82	33	100	0	1	246	129	210	QQD86175.1 coat protein [Botryosphaeria dothidea botrexvirus 1]	diamond	246	102	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Botrexvirus	Botryosphaeria dothidea botrexvirus 1
30749108	30749108	PRJNA799842_P_NODE_130154_length_256_cov_1.153005_g128581_i0	PRJNA799842	130154	256	1.153005	2.9516928	brine shrimp toti-like virus 1	2900477	Viruses	Viruses	127	5.489999999999999e-32	NR	UNI73811.1	2900477	g128581	i0	59.5	1.96875	84	34	98.4	0	1	252	596	679	UNI73811.1 MAG: capsid protein [brine shrimp toti-like virus 1]	diamond	504	127	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		brine shrimp toti-like virus 1
31286209	31286209	PRJNA799842_P_NODE_68015_length_346_cov_1.410256_g66442_i0	PRJNA799842	68015	346	1.410256	4.87948576	Raphanus sativus cryptic virus 2	351495	Viruses	Viruses	56.6	1.43e-6	NR	UHA47119.1	351495	g66442	i0	34.5	1.73410404624277	113	74	98	0	6	344	1	113	UHA47119.1 hypothetical protein [Raphanus sativus cryptic virus 2]	diamond	600	56.6	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Raphanus sativus cryptic virus 2
31412852	31412852	PRJNA799842_P_NODE_114576_length_274_cov_0.970149_g113003_i0	PRJNA799842	114576	274	0.970149	2.65820826	Raphanus sativus cryptic virus 2	351495	Viruses	Viruses	64.3	1.15e-9	NR	YP_001686784.1	351495	g113003	i0	42.2	1.97080291970803	90	43	98.5	1	272	3	20	100	YP_001686784.1 unknown [Raphanus sativus cryptic virus 2]	diamond	540	64.3	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Raphanus sativus cryptic virus 2
32623675	32623675	PRJNA799842_P_NODE_30460_length_526_cov_2.777042_g28898_i0	PRJNA799842	30460	526	2.777042	14.60724092	Viruses	10239	Viruses	Viruses	139	1.2e-34	NR	URG14944.1	1530251	g28898	i0	39.9	4.57984790874525	163	96	93	1	9	497	450	610	URG14944.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.]	diamond	2409	139	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae 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);;