metadata: contig_metadata: 9 rows where bioproject = "PRJNA429937", tax_phylum = "Duplornaviricota" and tax

9 rows where bioproject = "PRJNA429937", tax_phylum = "Duplornaviricota" 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
425900	425900	PRJNA429937_P_NODE_13761_length_987_cov_5.175365_g8136_i0	PRJNA429937	13761	987	5.175365	51.08085255	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	1694	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g8136	i0	97.186	1.49138804457953	995	20	100	2	1	987	2677	3671	Malassezia restricta virus MrV40L, complete genome	blastn	1472	1694	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
2976841	2976841	PRJNA429937_P_NODE_19023_length_843_cov_3.094595_g11234_i0	PRJNA429937	19023	843	3.094595	26.08743585	Coltivirus dermacentoris	3428066	Viruses	Viruses	532	2.49e-146	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g11234	i0	92.328	49.8386714116251	378	24	81	4	147	522	5357	4983	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	42014	532	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
5530426	5530426	PRJNA429937_P_NODE_43305_length_545_cov_2.812016_g27656_i0	PRJNA429937	43305	545	2.812016	15.3254872	Coltivirus dermacentoris	3428066	Viruses	Viruses	448	5.85e-121	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g27656	i0	92.857	46.051376146789	308	22	69	0	169	476	4559	4866	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	25098	448	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
9354254	9354254	PRJNA429937_P_NODE_17568_length_878_cov_3.030624_g10403_i0	PRJNA429937	17568	878	3.030624	26.60887872	Coltivirus dermacentoris	3428066	Viruses	Viruses	534	7.21e-147	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g10403	i0	92.348	47.8530751708428	379	24	78	4	322	698	4983	5358	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	42015	534	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
10630677	10630677	PRJNA429937_P_NODE_46209_length_525_cov_2.852823_g29824_i0	PRJNA429937	46209	525	2.852823	14.97732075	Coltivirus dermacentoris	3428066	Viruses	Viruses	453	1.21e-122	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g29824	i0	93.182	47.7904761904762	308	21	59	0	50	357	4866	4559	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	25090	453	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
20829327	20829327	PRJNA429937_P_NODE_9437_length_1171_cov_16.560420_g5551_i0	PRJNA429937	9437	1171	16.56042	193.9225182	Totivirus ichi	3432942	Viruses	Viruses	2063	0	NTclustered	gi\|558066\|gb\|J04692.1\|SCSCOATRNA	11008	g5551	i0	98.877	2.9666951323655	1158	9	99	4	1	1156	1470	315	Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds	blastn	3474	2063	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus ichi
22102954	22102954	PRJNA429937_P_NODE_27558_length_697_cov_3.305389_g16590_i0	PRJNA429937	27558	697	3.305389	23.03856133	Coltivirus dermacentoris	3428066	Viruses	Viruses	538	4.3799999999999986e-148	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g16590	i0	92.593	60.7919655667145	378	23	98	4	322	697	4983	5357	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	42372	538	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
30977045	30977045	PRJNA429937_P_NODE_7354_length_1303_cov_7.319466_g4350_i0	PRJNA429937	7354	1303	7.319466	95.37264198	Ghabrivirales	2732540	Viruses	Viruses	123	3.9e-26	NR	WAK77569.1	1955172	g4350	i0	35.2	1.06600153491942	230	144	52.3	4	1257	577	351	578	WAK77569.1 MAG: capsid protein [Totiviridae sp.]	diamond	1389	124	0.991935483870968	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
32193893	32193893	PRJNA429937_P_NODE_9558_length_1166_cov_5.156552_g5619_i0	PRJNA429937	9558	1166	5.156552	60.12539632	Totiviridae sp.	1955172	Viruses	Viruses	311	8.13e-98	NR	UHS72443.1	1955172	g5619	i0	67	0.545454545454545	212	70	54.5	0	636	1	2	213	UHS72443.1 MAG: putative RNA-dependent RNA polymerase, partial [Totiviridae sp.]	diamond	636	311	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae 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);;