metadata: contig_metadata: 15 rows where bioproject = "PRJNA235310" and tax

15 rows where bioproject = "PRJNA235310" 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
367338	367338	PRJNA235310_P_NODE_1_length_9208_cov_13.460094_g0_i0	PRJNA235310	1	9208	13.460094	1239.40545552	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	3395	0	NR	WEU70895.1	3029006	g0	i0	62.8	0.891724587315378	2737	957	88.9	17	836	9022	12	2694	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	8211	3395	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1
15670138	15670138	PRJNA235310_P_NODE_2053_length_274_cov_1.413333_g2027_i0	PRJNA235310	2053	274	1.413333	3.87253242	Indivirus ILV1	1977633	Viruses	Viruses	108	5.3e-19	NTclustered	gi\|1174570775\|gb\|KY684086.1\|	1977633	g2027	i0	83.333	0.693430656934307	120	17	43	3	120	238	146633	146516	Indivirus ILV1 isolate ILV1 clone Indivirus_2, sequence	blastn	190	108	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
20768858	20768858	PRJNA235310_P_NODE_177_length_755_cov_1.599150_g159_i0	PRJNA235310	177	755	1.59915	12.0735825	Plotvirus plot	2170099	Viruses	Viruses	62.1	1.26e-4	NTclustered	gi\|1720702708\|gb\|MN119378.1\|	2596982	g159	i0	91.489	0.16953642384106	47	1	6	2	380	423	45867	45913	Mycobacterium phage Penelope2018, complete genome	blastn	128	62.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Plotvirus	Plotvirus plot
26884301	26884301	PRJNA235310_P_NODE_1021_length_396_cov_1.377522_g995_i0	PRJNA235310	1021	396	1.377522	5.45498712	Perth bee virus 4	2201298	Viruses	Viruses	238	1.06e-69	NR	AWK77898.1	2201298	g995	i0	84.7	0.992424242424242	131	19	98.5	1	2	391	1058	1188	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	393	238	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Perth bee virus 4
27358643	27358643	PRJNA235310_P_NODE_3863_length_192_cov_1.293706_g3837_i0	PRJNA235310	3863	192	1.293706	2.48391552	Perth bee virus 4	2201298	Viruses	Viruses	45.8	0.00155	NR	AWK77898.1	2201298	g3837	i0	47.2	0.5625	36	19	56.3	0	169	62	561	596	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	108	45.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Perth bee virus 4
27358644	27358644	PRJNA235310_P_NODE_4083_length_186_cov_1.751825_g4057_i0	PRJNA235310	4083	186	1.751825	3.2583945	Perth bee virus 4	2201298	Viruses	Viruses	130	1.33e-33	NR	AWK77899.1	2201298	g4057	i0	98.4	0.983870967741935	61	1	98.4	0	2	184	160	220	AWK77899.1 structural polyprotein [Perth bee virus 4]	diamond	183	130	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Perth bee virus 4
27642856	27642856	PRJNA235310_P_NODE_3284_length_209_cov_1.300000_g3258_i0	PRJNA235310	3284	209	1.3	2.717	Perth bee virus 4	2201298	Viruses	Viruses	133	3.65e-34	NR	AWK77898.1	2201298	g3258	i0	91.3	0.990430622009569	69	6	99	0	3	209	237	305	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	207	133	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Perth bee virus 4
28873981	28873981	PRJNA235310_P_NODE_1508_length_329_cov_1.300000_g1482_i0	PRJNA235310	1508	329	1.3	4.277	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	62.4	1.36e-8	NR	XCM67955.1	3003959	g1482	i0	37.2	2.00607902735562	78	46	68.4	1	80	304	2000	2077	XCM67955.1 MAG: polyprotein [Picornavirales sp.]	diamond	660	62.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28968853	28968853	PRJNA235310_P_NODE_168_length_764_cov_2.476923_g150_i0	PRJNA235310	168	764	2.476923	18.92369172	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	67.8	9.24e-9	NR	XCM67955.1	3003959	g150	i0	33.1	0.604712041884817	154	97	58.9	3	751	302	2271	2422	XCM67955.1 MAG: polyprotein [Picornavirales sp.]	diamond	462	67.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28968854	28968854	PRJNA235310_P_NODE_3208_length_212_cov_1.276074_g3182_i0	PRJNA235310	3208	212	1.276074	2.70527688	Picornaviridae sp.	1530251	Viruses	Viruses	110	3.5100000000000004e-26	NR	URG14784.1	1530251	g3182	i0	73.9	1.96698113207547	69	18	97.6	0	209	3	212	280	URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	417	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29316073	29316073	PRJNA235310_P_NODE_6009_length_164_cov_0.904348_g5983_i0	PRJNA235310	6009	164	0.904348	1.48313072	Klosneuvirus KNV1	1977640	Viruses	Viruses	73.2	2.2e-13	NR	ARF12269.1	1977640	g5983	i0	58.5	0.969512195121951	53	22	97	0	163	5	246	298	ARF12269.1 ornithine decarboxylase [Klosneuvirus KNV1]	diamond	159	73.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
31274655	31274655	PRJNA235310_P_NODE_5895_length_164_cov_1.217391_g5869_i0	PRJNA235310	5895	164	1.217391	1.99652124	Gaeavirus sp.	2487767	Viruses	Viruses	63.5	5.8e-10	NR	AYV79987.1	2487767	g5869	i0	56.4	1.00609756097561	55	23	98.8	1	1	162	977	1031	AYV79987.1 MAG: mRNA capping enzyme [Gaeavirus sp.]	diamond	165	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
31337860	31337860	PRJNA235310_P_NODE_4816_length_169_cov_1.300000_g4790_i0	PRJNA235310	4816	169	1.3	2.197	Qianjiang marna-like virus 118	3347539	Viruses	Viruses	49.7	4.79e-5	NR	XHA88256.1	3347539	g4790	i0	52.9	0.905325443786982	51	22	87	2	9	155	1485	1535	XHA88256.1 MAG: polyprotein [Qianjiang marna-like virus 118]	diamond	153	49.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Qianjiang marna-like virus 118
32033893	32033893	PRJNA235310_P_NODE_2698_length_233_cov_1.016304_g2672_i0	PRJNA235310	2698	233	1.016304	2.36798832	Perth bee virus 4	2201298	Viruses	Viruses	137	7.36e-36	NR	AWK77899.1	2201298	g2672	i0	93.5	0.991416309012876	77	5	99.1	0	232	2	59	135	AWK77899.1 structural polyprotein [Perth bee virus 4]	diamond	231	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Perth bee virus 4
32413661	32413661	PRJNA235310_P_NODE_1979_length_280_cov_2.952381_g1953_i0	PRJNA235310	1979	280	2.952381	8.2666668	Gaeavirus sp.	2487767	Viruses	Viruses	65.9	7.8e-12	NR	AYV80119.1	2487767	g1953	i0	46.5	0.760714285714286	71	35	76.1	1	7	219	4	71	AYV80119.1 MAG: hypothetical protein Gaeavirus10_15 [Gaeavirus sp.]	diamond	213	65.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus 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);;