metadata: contig_metadata: 10 rows where bioproject = "PRJNA1168532" and tax

10 rows where bioproject = "PRJNA1168532" 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
2315538	2315538	PRJNA1168532_S_NODE_4082_length_1082_cov_3.185756_g3256_i0	PRJNA1168532	4082	1082	3.185756	34.46987992	root	1	Root_unresolved	Root_unresolved	1146	0	NTclustered	gi\|1039754121\|gb\|KX165321.1\|	10386	g3256	i0	85.767	100	1082	154	100	0	1	1082	27446	26365	Mutant Gallid alphaherpesvirus 1 strain GdORFC, complete genome	blastn	108200	1146	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Iltovirus	Iltovirus gallidalpha1
2866046	2866046	PRJNA1168532_S_NODE_55343_length_409_cov_2.000000_g52471_i0	PRJNA1168532	55343	409	2	8.18	Betapolyomavirus macacae	1891767	Viruses	Viruses	315	4.54e-81	NTclustered	gi\|15705935\|gb\|AF416237.1\|AF416237	1891767	g52471	i0	86.411	1.5281173594132	287	39	70	0	45	331	296	10	Simian virus 40 clone G14M12 non-archetypal regulatory sequence	blastn	625	315	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
4142101	4142101	PRJNA1168532_S_NODE_84484_length_345_cov_5.566225_g81541_i0	PRJNA1168532	84484	345	5.566225	19.20347625	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.033	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g81541	i0	94.286	0.101449275362319	35	1	10	1	104	137	153475	153509	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
7418089	7418089	PRJNA1168532_S_NODE_196106_length_222_cov_1.100559_g193163_i0	PRJNA1168532	196106	222	1.100559	2.44324098	Pestivirus	11095	Viruses	Viruses	372	1.33e-98	NTclustered	gi\|2731951075\|gb\|PP770551.1\|	11099	g193163	i0	96.847	100	222	7	100	0	1	222	10616	10395	Bovine viral diarrhea virus 1 isolate YN2-11/2023, complete genome	blastn	22200	372	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
11793796	11793796	PRJNA1168532_S_NODE_302370_length_168_cov_1.128000_g299427_i0	PRJNA1168532	302370	168	1.128	1.89504	Pestivirus bovis	3052619	Viruses	Viruses	272	9.95e-69	NTclustered	gi\|1129879569\|gb\|KX170152.1\|	11099	g299427	i0	95.833	99.8214285714286	168	7	100	0	1	168	639	806	Bovine viral diarrhea virus 1 isolate V029 E2 gene, partial cds	blastn	16770	272	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
20166588	20166588	PRJNA1168532_S_NODE_138276_length_272_cov_1.764192_g135333_i0	PRJNA1168532	138276	272	1.764192	4.79860224	Pestivirus	11095	Viruses	Viruses	464	2.7099999999999998e-126	NTclustered	gi\|2419860346\|dbj\|LC727644.1\|	11099	g135333	i0	97.426	100.893382352941	272	7	100	0	1	272	622	893	Bovine viral diarrhea virus 1 Tokachi-8 RNA, nearly complete genome	blastn	27443	464	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
26660312	26660312	PRJNA1168532_S_NODE_26701_length_536_cov_2.014199_g24114_i0	PRJNA1168532	26701	536	2.014199	10.79610664	Gammaretrovirus murleu	3428959	Viruses	Viruses	364	1.51e-122	NR	8WUS_E	11801	g24114	i0	99.4	2.98880597014925	178	1	99.6	0	535	2	151	328	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	1602	364	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
27861672	27861672	PRJNA1168532_S_NODE_128145_length_283_cov_3.020833_g125202_i0	PRJNA1168532	128145	283	3.020833	8.54895739	Human alphaherpesvirus 1	10298	Viruses	Viruses	55.1	5.09e-8	NR	DAC85507.1	10298	g125202	i0	68.6	0.68904593639576	35	11	37.1	0	42	146	1	35	DAC85507.1 TPA_asm: UL22 uORF 2, partial [Human alphaherpesvirus 1]	diamond	195	55.1	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Simplexvirus	Simplexvirus humanalpha1
28998807	28998807	PRJNA1168532_S_NODE_158028_length_252_cov_2.148325_g155085_i0	PRJNA1168532	158028	252	2.148325	5.413779	Betapolyomavirus macacae	1891767	Viruses	Viruses	70.1	9.39e-12	NR	AAK29054.1	1891767	g155085	i0	82.5	0.476190476190476	40	7	47.6	0	119	238	498	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	120	70.1	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
29965034	29965034	PRJNA1168532_S_NODE_85651_length_343_cov_4.476667_g82708_i0	PRJNA1168532	85651	343	4.476667	15.35496781	Gammaretrovirus	153135	Viruses	Viruses	216	1.62e-62	NR	NP_040333.1	11795	g82708	i0	95.6	8.89504373177843	113	5	98.8	0	341	3	633	745	NP_040333.1 RNA-dependent DNA polymerase, partial [Friend murine leukemia virus]	diamond	3051	218	0.990825688073395	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu

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