metadata: contig_metadata: 16 rows where bioproject = "PRJEB15333" and tax

16 rows where bioproject = "PRJEB15333" 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
985830	985830	PRJEB15333_P_NODE_11461_length_201_cov_1.572368_g11377_i0	PRJEB15333	11461	201	1.572368	3.16045968	Alpharetrovirus	153057	Viruses	Viruses	366	5.5e-97	NTclustered	gi\|407979\|gb\|L10923.1\|MAVTYP1A2A	31668	g11377	i0	99.502	99.6417910447761	201	1	100	0	1	201	1984	1784	Myeloblastosis-associated virus type 1/2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds	blastn	20028	366	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Avian myeloblastosis-associated virus
2261124	2261124	PRJEB15333_P_NODE_13782_length_185_cov_2.139706_g13698_i0	PRJEB15333	13782	185	2.139706	3.9584561	Alpharetrovirus	153057	Viruses	Viruses	302	1.42e-77	NTclustered	gi\|308053557\|gb\|HM235670.1\|	11864	g13698	i0	96.196	98.6054054054054	184	7	99	0	2	185	2654	2471	Avian leukosis virus isolate YZ9902, complete genome	blastn	18242	302	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
2261128	2261128	PRJEB15333_P_NODE_3382_length_343_cov_2.255102_g3298_i0	PRJEB15333	3382	343	2.255102	7.73499986	Alpharetrovirus	153057	Viruses	Viruses	592	1.5499999999999996e-164	NTclustered	gi\|449139009\|gb\|KC149971.1\|	11864	g3298	i0	97.947	99.4256559766764	341	7	99	0	1	341	2011	2351	Avian leukosis virus strain SCAU11-XG, complete genome	blastn	34103	592	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
2571488	2571488	PRJEB15333_P_NODE_14123_length_183_cov_2.328358_g14039_i0	PRJEB15333	14123	183	2.328358	4.26089514	Alpharetrovirus avileu	3426267	Viruses	Viruses	329	6.43e-86	NTclustered	gi\|1041529576\|gb\|KU500038.1\|	11864	g14039	i0	99.448	98.9071038251366	181	1	99	0	3	183	4147	3967	Avian leukosis virus isolate GD1411-1 envelope protein (env) and gag protein (gag) genes, complete cds; and pol protein (pol) gene, partial cds	blastn	18100	329	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
3536435	3536435	PRJEB15333_P_NODE_15583_length_175_cov_1.658730_g15499_i0	PRJEB15333	15583	175	1.65873	2.9027775	Alpharetrovirus	153057	Viruses	Viruses	300	4.77e-77	NTclustered	gi\|345050319\|dbj\|AB522906.1\|	11864	g15499	i0	97.701	99.4285714285714	174	4	99	0	1	174	4539	4366	Avian leukosis virus proviral DNA, complete genome	blastn	17400	300	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
3847803	3847803	PRJEB15333_P_NODE_1464_length_486_cov_5.249428_g1384_i0	PRJEB15333	1464	486	5.249428	25.51222008	Tasmanian devil retrovirus	1332312	Viruses	Viruses	787	0	NTclustered	gi\|618757818\|gb\|KC845928.1\|	1332312	g1384	i0	95.902	100.954732510288	488	17	99	2	2	486	2063	1576	Tasmanian devil retrovirus strain DRV2010 polymerase (pol) and envelope protein (env) genes, partial cds	blastn	49064	787	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Tasmanian devil retrovirus
5124023	5124023	PRJEB15333_P_NODE_9285_length_221_cov_8.500000_g9201_i0	PRJEB15333	9285	221	8.5	18.785	Avian myeloblastosis-associated virus	11960	Viruses	Viruses	298	2.28e-76	NTclustered	gi\|407987\|gb\|L10924.1\|MAVTYP2AAA	31670	g9201	i0	91.855	30.262443438914	221	6	100	1	1	221	7512	7304	Myeloblastosis-associated virus type 2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds	blastn	6688	298	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Avian myeloblastosis-associated virus
7363537	7363537	PRJEB15333_P_NODE_866_length_602_cov_4.054250_g793_i0	PRJEB15333	866	602	4.05425	24.406585	Alpharetrovirus	153057	Viruses	Viruses	1042	0	NTclustered	gi\|407979\|gb\|L10923.1\|MAVTYP1A2A	31668	g793	i0	97.851	100.5	605	10	100	1	1	602	1342	738	Myeloblastosis-associated virus type 1/2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds	blastn	60501	1042	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Avian myeloblastosis-associated virus
8948623	8948623	PRJEB15333_P_NODE_7268_length_247_cov_1.919192_g7184_i0	PRJEB15333	7268	247	1.919192	4.74040424	Alpharetrovirus avileu	3426267	Viruses	Viruses	429	8.83e-116	NTclustered	gi\|2654355796\|gb\|OR670961.1\|	11864	g7184	i0	97.976	99.9959514170041	247	5	100	0	1	247	2608	2854	Avian leukosis virus strain CH/JXND2101, complete genome	blastn	24699	429	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
9914005	9914005	PRJEB15333_P_NODE_21948_length_151_cov_20.303922_g21864_i0	PRJEB15333	21948	151	20.303922	30.65892222	root	1	Root_unresolved	Root_unresolved	278	1.87e-70	NTclustered	gi\|699361943\|gb\|KM376510.1\|	11864	g21864	i0	100	99.3509933774834	150	0	99	0	2	151	4560	4709	Avian leukosis virus isolate HLJ13SH01, complete genome	blastn	15002	278	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
10224371	10224371	PRJEB15333_P_NODE_9289_length_221_cov_6.843023_g9205_i0	PRJEB15333	9289	221	6.843023	15.12308083	Alpharetrovirus avimyebla	3426268	Viruses	Viruses	344	2.8899999999999993e-90	NTclustered	gi\|210085\|gb\|M24159.1\|ALMAMV	11866	g9205	i0	96.618	93.6018099547511	207	7	94	0	3	209	402	196	Avian myeloblastosis virus polymerase gene, 3' end and transforming protein gene, complete cds	blastn	20686	344	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avimyebla
12465004	12465004	PRJEB15333_P_NODE_21990_length_151_cov_4.166667_g21906_i0	PRJEB15333	21990	151	4.166667	6.29166717	Alpharetrovirus	153057	Viruses	Viruses	261	1.88e-65	NTclustered	gi\|407983\|gb\|L10922.1\|MAVTYP1AAA	31669	g21906	i0	98.639	93.7483443708609	147	2	97	0	5	151	7152	7006	Avian myeloblastosis-associated virus type 1 env (env) and gag (gag) genes, complete cds; and pol (pol) gene, partial cds	blastn	14156	261	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Avian myeloblastosis-associated virus
16598429	16598429	PRJEB15333_P_NODE_3934_length_322_cov_0.912088_g3850_i0	PRJEB15333	3934	322	0.912088	2.93692336	Artemvirus bsafialis	3426459	Viruses	Viruses	590	5.18e-164	NTclustered	gi\|2209095102\|gb\|OL472401.1\|	2900376	g3850	i0	99.689	15	322	1	100	0	1	322	5472	5793	MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds	blastn	4830	590	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafialis
27412629	27412629	PRJEB15333_P_NODE_1743_length_452_cov_8.801489_g1662_i0	PRJEB15333	1743	452	8.801489	39.78273028	African cichlid piscichuvirus	3065075	Viruses	Viruses	89.7	1.55e-17	NR	WLN26256.1	3065075	g1662	i0	54.2	0.550884955752212	83	38	55.1	0	252	4	229	311	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	249	89.7	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
27665179	27665179	PRJEB15333_P_NODE_15184_length_177_cov_2.328125_g15100_i0	PRJEB15333	15184	177	2.328125	4.12078125	Microbacterium phage Endor	2944952	Viruses	Viruses	40.4	0.0198	NR	URC17906.1	2944952	g15100	i0	37.8	0.76271186440678	45	25	71.2	1	4	129	22	66	URC17906.1 hypothetical protein SEA_ENDOR_50 [Microbacterium phage Endor]	diamond	135	40.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Ilzatvirus	Microbacterium phage Endor
31929636	31929636	PRJEB15333_P_NODE_18617_length_166_cov_0.888889_g18533_i0	PRJEB15333	18617	166	0.888889	1.47555574	brine shrimp arlivirus 9	2900384	Viruses	Viruses	114	6.019999999999999e-28	NR	UNI74144.1	2900384	g18533	i0	98.2	0.993975903614458	55	1	99.4	0	165	1	442	496	UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9]	diamond	165	114	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9

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);;