metadata: contig_metadata: 25 rows where bioproject = "PRJNA798905" and tax

25 rows where bioproject = "PRJNA798905" and tax_phylum = "Cressdnaviricota"

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
4620013	4620013	PRJNA798905_S_NODE_10044_length_435_cov_11.132597_g9595_i0	PRJNA798905	10044	435	11.132597	48.42679695	Cressdnaviricota sp.	2748378	Viruses	Viruses	699	0	NTclustered	gi\|1851855983\|gb\|MT138075.1\|	2748378	g9595	i0	96.056	0.990804597701149	431	14	99	3	1	429	2448	2877	MAG: Cressdnaviricota sp. isolate tou80cre3 genomic sequence	blastn	431	699	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
4620711	4620711	PRJNA798905_S_NODE_40524_length_238_cov_2.830303_g40075_i0	PRJNA798905	40524	238	2.830303	6.73612114	Red panda feces-associated circular DNA virus 23	2863977	Viruses	Viruses	244	3.2899999999999996e-60	NTclustered	gi\|2099633381\|gb\|MZ556221.1\|	2863977	g40075	i0	93.865	2.36974789915966	163	8	81	2	73	235	2071	1911	Red panda feces-associated circular DNA virus 23 isolate Rpf113unssDNA01-8 genomic sequence	blastn	564	244	1	Viruses	Shotokuvirae	Cressdnaviricota					Red panda feces-associated circular DNA virus 23
5895405	5895405	PRJNA798905_S_NODE_20645_length_328_cov_3.713725_g20196_i0	PRJNA798905	20645	328	3.713725	12.181018	Smacoviridae sp.	2715094	Viruses	Viruses	372	2.09e-98	NTclustered	gi\|2635142644\|gb\|OR370861.1\|	2715094	g20196	i0	96.053	1.45731707317073	228	9	70	0	99	326	639	412	MAG: Smacoviridae sp. isolate YakFeces01-11706 genomic sequence	blastn	478	372	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cremevirales	Smacoviridae		Smacoviridae sp.
8445460	8445460	PRJNA798905_S_NODE_4347_length_637_cov_22.289007_g3910_i0	PRJNA798905	4347	637	22.289007	141.98097459	Cressdnaviricota sp.	2748378	Viruses	Viruses	253	1.58e-80	NR	XNT20928.1	2748378	g3910	i0	61.2	0.970172684458399	206	78	96.5	2	617	3	19	223	XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	618	253	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
12271572	12271572	PRJNA798905_S_NODE_35550_length_251_cov_5.550562_g35101_i0	PRJNA798905	35550	251	5.550562	13.93191062	Cressdnaviricota sp.	2748378	Viruses	Viruses	106	1.72e-18	NTclustered	gi\|2896100834\|gb\|PQ792294.1\|	2748378	g35101	i0	96.825	0.250996015936255	63	2	25	0	189	251	18	80	MAG: Cressdnaviricota sp. isolate SbovineF087_cress11 genomic sequence	blastn	63	106	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
12271761	12271761	PRJNA798905_S_NODE_45030_length_198_cov_6.136000_g44581_i0	PRJNA798905	45030	198	6.136	12.14928	Smacoviridae sp.	2715094	Viruses	Viruses	276	9.36e-70	NTclustered	gi\|2635142644\|gb\|OR370861.1\|	2715094	g44581	i0	91.878	0.994949494949495	197	16	99	0	2	198	20	216	MAG: Smacoviridae sp. isolate YakFeces01-11706 genomic sequence	blastn	197	276	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cremevirales	Smacoviridae		Smacoviridae sp.
13545384	13545384	PRJNA798905_S_NODE_17591_length_350_cov_14.953069_g17142_i0	PRJNA798905	17591	350	14.953069	52.3357415	Cressdnaviricota sp.	2748378	Viruses	Viruses	228	5.119999999999998e-55	NTclustered	gi\|2896100810\|gb\|PQ792283.1\|	2748378	g17142	i0	84.615	0.705714285714286	247	19	65	10	121	349	872	627	MAG: Cressdnaviricota sp. isolate SbovineF086_cress3 genomic sequence	blastn	247	228	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
13545574	13545574	PRJNA798905_S_NODE_25791_length_297_cov_4.558036_g25342_i0	PRJNA798905	25791	297	4.558036	13.53736692	Cressdnaviricota sp.	2748378	Viruses	Viruses	394	3.98e-105	NTclustered	gi\|1851855983\|gb\|MT138075.1\|	2748378	g25342	i0	90.635	1.00673400673401	299	24	100	3	1	297	2667	2371	MAG: Cressdnaviricota sp. isolate tou80cre3 genomic sequence	blastn	299	394	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
16094392	16094392	PRJNA798905_S_NODE_18753_length_341_cov_7.914179_g18304_i0	PRJNA798905	18753	341	7.914179	26.98735039	Cressdnaviricota sp.	2748378	Viruses	Viruses	182	3.94e-41	NTclustered	gi\|2896100810\|gb\|PQ792283.1\|	2748378	g18304	i0	77.077	1.02346041055718	349	58	98	15	1	335	287	627	MAG: Cressdnaviricota sp. isolate SbovineF086_cress3 genomic sequence	blastn	349	182	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
27275284	27275284	PRJNA798905_S_NODE_26183_length_295_cov_3.337838_g25734_i0	PRJNA798905	26183	295	3.337838	9.8466221	Cressdnaviricota sp.	2748378	Viruses	Viruses	96.7	1.6e-21	NR	QJQ37761.1	2748378	g25734	i0	50	1.87118644067797	92	36	87.5	2	263	6	13	100	QJQ37761.1 replication-associated protein [Cressdnaviricota sp.]	diamond	552	96.7	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
27568429	27568429	PRJNA798905_S_NODE_42064_length_230_cov_3.146497_g41615_i0	PRJNA798905	42064	230	3.146497	7.2369431	Viruses	10239	Viruses	Viruses	69.3	1.04e-11	NR	XNT21009.1	2748378	g41615	i0	48	2.93478260869565	75	34	96.5	2	226	5	77	147	XNT21009.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	675	69.3	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
27875178	27875178	PRJNA798905_S_NODE_17525_length_351_cov_4.651079_g17076_i0	PRJNA798905	17525	351	4.651079	16.32528729	Circovirus sp.	1964372	Viruses	Viruses	88.2	2.14e-19	NR	WQA29644.1	1964372	g17076	i0	54.2	0.709401709401709	83	36	69.2	1	107	349	11	93	WQA29644.1 MAG: rep protein, partial [Circovirus sp.]	diamond	249	88.2	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Circovirus sp.
28348845	28348845	PRJNA798905_S_NODE_4006_length_665_cov_8.246622_g3572_i0	PRJNA798905	4006	665	8.246622	54.8400363	Cressdnaviricota sp.	2748378	Viruses	Viruses	105	6.149999999999999e-23	NR	XNT20928.1	2748378	g3572	i0	57	0.38796992481203	86	37	38.8	0	665	408	217	302	XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	258	105	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
29106738	29106738	PRJNA798905_S_NODE_15168_length_372_cov_6.481605_g14719_i0	PRJNA798905	15168	372	6.481605	24.1115706	Cressdnaviricota sp.	2748378	Viruses	Viruses	80.1	6.18e-16	NR	AXF52274.1	2748378	g14719	i0	38.5	0.943548387096774	117	63	90.3	4	369	34	57	169	AXF52274.1 MAG: putative capsid protein [Cressdnaviricota sp.]	diamond	351	80.1	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
29201502	29201502	PRJNA798905_S_NODE_36549_length_249_cov_1.732955_g36100_i0	PRJNA798905	36549	249	1.732955	4.31505795	Duck associated circular virus VC9	2781378	Viruses	Viruses	71.6	2.04e-13	NR	QOQ34601.1	2781378	g36100	i0	45.6	0.951807228915663	79	42	94	1	14	247	1	79	QOQ34601.1 capsid protein [Duck associated circular virus VC9]	diamond	237	71.6	1	Viruses	Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Genomoviridae		Duck associated circular virus VC9
29233075	29233075	PRJNA798905_S_NODE_33369_length_260_cov_5.983957_g32920_i0	PRJNA798905	33369	260	5.983957	15.5582882	Cressdnaviricota sp.	2748378	Viruses	Viruses	81.6	4.27e-16	NR	XNT20928.1	2748378	g32920	i0	65.4	0.6	52	17	58.8	1	232	80	13	64	XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	156	81.6	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
29453604	29453604	PRJNA798905_S_NODE_40750_length_237_cov_2.347561_g40301_i0	PRJNA798905	40750	237	2.347561	5.56371957	Cressdnaviricota sp.	2748378	Viruses	Viruses	108	1.5600000000000002e-26	NR	XNT20928.1	2748378	g40301	i0	67.9	0.987341772151899	78	25	98.7	0	236	3	148	225	XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	234	108	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
29896139	29896139	PRJNA798905_S_NODE_7831_length_482_cov_2.933985_g7382_i0	PRJNA798905	7831	482	2.933985	14.1418077	Cressdnaviricota sp.	2748378	Viruses	Viruses	111	4.42e-26	NR	XNT20928.1	2748378	g7382	i0	60	0.560165975103734	90	34	55.4	2	269	3	8	96	XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	270	111	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
30125973	30125973	PRJNA798905_S_NODE_43692_length_217_cov_4.812500_g43243_i0	PRJNA798905	43692	217	4.8125	10.443125	Naryaviridae	2946188	Viruses	Viruses	47	4.87e-4	NR	WQA30166.1	2748378	g43243	i0	71	1.56221198156682	31	8	42.9	1	201	109	134	163	WQA30166.1 MAG: rep protein [Cressdnaviricota sp.]	diamond	339	47	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
30189326	30189326	PRJNA798905_S_NODE_26972_length_291_cov_2.119266_g26523_i0	PRJNA798905	26972	291	2.119266	6.16706406	Cyclovirus	742914	Viruses	Viruses	86.3	8.6e-18	NR	XCO48057.1	1983780	g26523	i0	47.3	3.72164948453608	91	47	92.8	1	3	272	30	120	XCO48057.1 MAG: putative replication-associated protein [Cyclovirus sp.]	diamond	1083	86.3	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Cyclovirus	Cyclovirus sp.
30685743	30685743	PRJNA798905_S_NODE_11113_length_419_cov_12.505780_g10664_i0	PRJNA798905	11113	419	12.50578	52.3992182	Cressdnaviricota sp.	2748378	Viruses	Viruses	174	1.19e-50	NR	XNT20928.1	2748378	g10664	i0	63	0.966587112171838	135	50	96.7	0	406	2	86	220	XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	405	174	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
30843968	30843968	PRJNA798905_S_NODE_34534_length_255_cov_7.005495_g34085_i0	PRJNA798905	34534	255	7.005495	17.86401225	Cressdnaviricota sp.	2748378	Viruses	Viruses	91.7	4.55e-20	NR	XNT20546.1	2748378	g34085	i0	68.2	1.55294117647059	66	20	76.5	1	197	3	14	79	XNT20546.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	396	91.7	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
31697460	31697460	PRJNA798905_S_NODE_29297_length_279_cov_3.364078_g28848_i0	PRJNA798905	29297	279	3.364078	9.38577762	Syrmaticus ellioti CRESS-DNA-virus sp.	2815058	Viruses	Viruses	53.9	4.92e-6	NR	QTE03432.1	2815058	g28848	i0	36.7	1.35483870967742	60	38	64.5	0	4	183	191	250	QTE03432.1 MAG: capsid protein [Syrmaticus ellioti CRESS-DNA-virus sp.]	diamond	378	53.9	1	Viruses	Shotokuvirae	Cressdnaviricota					Syrmaticus ellioti CRESS-DNA-virus sp.
32013845	32013845	PRJNA798905_S_NODE_29758_length_277_cov_2.083333_g29309_i0	PRJNA798905	29758	277	2.083333	5.77083241	Smacoviridae sp.	2715094	Viruses	Viruses	57.8	7.38e-8	NR	WCR62157.1	2715094	g29309	i0	42.5	1.61371841155235	73	40	79.1	1	44	262	36	106	WCR62157.1 MAG: capsid protein [Smacoviridae sp.]	diamond	447	57.8	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cremevirales	Smacoviridae		Smacoviridae sp.
32740860	32740860	PRJNA798905_S_NODE_15160_length_372_cov_7.377926_g14711_i0	PRJNA798905	15160	372	7.377926	27.44588472	Cressdnaviricota sp.	2748378	Viruses	Viruses	109	1.53e-27	NR	WQA30176.1	2748378	g14711	i0	48.7	0.92741935483871	115	52	88.7	2	364	35	43	155	WQA30176.1 MAG: rep protein [Cressdnaviricota sp.]	diamond	345	109	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota 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);;