metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1122875" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1122875" 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
26753309	26753309	PRJNA1122875_P_NODE_8861_length_553_cov_1.491667_g8642_i0	PRJNA1122875	8861	553	1.491667	8.24891851	Suillus luteus narnavirus 4	3067823	Viruses	Viruses	77	1.02e-12	NR	WLK77412.1	3067823	g8642	i0	30	0.976491862567812	180	119	94.9	5	527	3	48	225	WLK77412.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 4]	diamond	540	77	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus suilli
26901327	26901327	PRJNA1122875_P_NODE_40821_length_259_cov_1.430108_g40597_i0	PRJNA1122875	40821	259	1.430108	3.70397972	Viruses	10239	Viruses	Viruses	167	1.02e-45	NR	QGX73514.1	2686012	g40597	i0	93	2.97683397683398	86	6	99.6	0	2	259	609	694	QGX73514.1 RNA dependent RNA polymerase [Camellia japonica associated betaflexivirus 2]	diamond	771	167	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae		Camellia japonica associated betaflexivirus 2
26932812	26932812	PRJNA1122875_P_NODE_22162_length_352_cov_1.655914_g21938_i0	PRJNA1122875	22162	352	1.655914	5.82881728	Viruses	10239	Viruses	Viruses	53.5	2.11e-5	NR	WPR16645.1	3066916	g21938	i0	38.9	3.89488636363636	113	56	88.6	3	313	2	280	388	WPR16645.1 MAG: RNA-dependent RNA polymerase [Lwood associated narna-like virus]	diamond	1371	53.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Lwood associated narna-like virus
27375791	27375791	PRJNA1122875_P_NODE_3_length_5644_cov_12.296536_g2_i0	PRJNA1122875	3	5644	12.296536	694.01649184	Orthornavirae	2732396	Viruses	Viruses	105	2.6e-19	NR	WAY16551.1	2809883	g2	i0	25.9	0.737243090007087	494	276	26.1	13	4012	5484	1	407	WAY16551.1 hypothetical protein [Stellavirales sp.]	diamond	4161	105	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales			Stellavirales sp.
27817670	27817670	PRJNA1122875_P_NODE_10984_length_501_cov_2.852804_g10763_i0	PRJNA1122875	10984	501	2.852804	14.29254804	Narnavirus	186767	Viruses	Viruses	81.6	1.51e-14	NR	WZE65507.1	3139161	g10763	i0	32.3	4	167	64	98.2	4	496	5	431	551	WZE65507.1 RNA-dependent RNA polymerase [Ophiocordyceps sinensis narnavirus 4]	diamond	2004	81.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Ophiocordyceps sinensis narnavirus 4
28428251	28428251	PRJNA1122875_P_NODE_35286_length_279_cov_1.150485_g35062_i0	PRJNA1122875	35286	279	1.150485	3.20985315	Iflaviridae-like virus 3	3077009	Viruses	Viruses	119	7.07e-29	NR	WPR18798.1	3077009	g35062	i0	60	1.93548387096774	90	36	96.8	0	3	272	2685	2774	WPR18798.1 MAG: RNA-dependent RNA polymerase [Iflaviridae-like virus 3]	diamond	540	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Iflaviridae-like virus 3
28459907	28459907	PRJNA1122875_P_NODE_23206_length_346_cov_1.380952_g22982_i0	PRJNA1122875	23206	346	1.380952	4.77809392	Lentinula eaodes hypovirus 2	2992848	Viruses	Viruses	201	3.37e-57	NR	UZA97544.1	2992848	g22982	i0	90.4	0.988439306358382	114	11	98.8	0	3	344	743	856	UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2]	diamond	342	201	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Hypovirus	Lentinula eaodes hypovirus 2
29501548	29501548	PRJNA1122875_P_NODE_2350_length_919_cov_1.825059_g2196_i0	PRJNA1122875	2350	919	1.825059	16.77229221	Lentinula eaodes hypovirus 2	2992848	Viruses	Viruses	565	2.609999999999999e-181	NR	UZA97544.1	2992848	g2196	i0	96.4	0.998911860718172	306	11	99.9	0	918	1	432	737	UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2]	diamond	918	565	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Hypovirus	Lentinula eaodes hypovirus 2
32030085	32030085	PRJNA1122875_P_NODE_21938_length_354_cov_1.597865_g21714_i0	PRJNA1122875	21938	354	1.597865	5.6564421	Lentinula eaodes hypovirus 2	2992848	Viruses	Viruses	164	2.3999999999999996e-44	NR	UZA97544.1	2992848	g21714	i0	91.9	0.728813559322034	86	7	72.9	0	259	2	1	86	UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2]	diamond	258	164	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Hypovirus	Lentinula eaodes hypovirus 2
32093280	32093280	PRJNA1122875_P_NODE_54678_length_227_cov_2.142857_g54454_i0	PRJNA1122875	54678	227	2.142857	4.86428539	Plasmopara viticola lesion associated Partitivirus 8	2692006	Viruses	Viruses	61.2	9e-9	NR	QHD64792.1	2692006	g54454	i0	47.2	0.700440528634361	53	28	70	0	160	2	271	323	QHD64792.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated Partitivirus 8]	diamond	159	61.2	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Plasmopara viticola lesion associated Partitivirus 8
32219894	32219894	PRJNA1122875_P_NODE_14118_length_444_cov_1.032345_g13894_i0	PRJNA1122875	14118	444	1.032345	4.5836118	Wuhan Fly Virus 1	1608101	Viruses	Viruses	70.1	3.77e-11	NR	YP_009304999.1	1608101	g13894	i0	32.3	2.55405405405405	130	80	82.4	3	3	368	31	160	YP_009304999.1 nucleocapsid protein [Wuhan Fly Virus 1]	diamond	1134	70.1	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Phasivirus	Phasivirus wuhanense
32473174	32473174	PRJNA1122875_P_NODE_35479_length_278_cov_1.502439_g35255_i0	PRJNA1122875	35479	278	1.502439	4.17678042	Sanya narna-like virus 1	2970204	Viruses	Viruses	81.3	1.62e-15	NR	UUW20996.1	2970204	g35255	i0	39.3	0.960431654676259	89	51	96	1	272	6	170	255	UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1]	diamond	267	81.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Sanya narna-like virus 1
32693731	32693731	PRJNA1122875_P_NODE_1560_length_1047_cov_4.960986_g1440_i0	PRJNA1122875	1560	1047	4.960986	51.94152342	Downy mildew lesion associated splipalmivirus 2	2719503	Viruses	Viruses	49.7	0.00695	NR	WNA22207.1	2719503	g1440	i0	29.9	0.306590257879656	107	67	30.1	3	108	422	12	112	WNA22207.1 MAG: hypothetical protein, partial [Downy mildew lesion associated splipalmivirus 2]	diamond	321	49.7	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 2
32714532	32714532	PRJNA1122875_P_NODE_21420_length_359_cov_1.244755_g21196_i0	PRJNA1122875	21420	359	1.244755	4.46867045	Viruses	10239	Viruses	Viruses	218	3.58e-63	NR	QEJ80628.1	2606570	g21196	i0	86.6	2.98328690807799	119	16	99.4	0	2	358	671	789	QEJ80628.1 replicase [Camellia ringspot associated virus 2]	diamond	1071	218	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae		Camellia ringspot 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);;