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

10 rows where bioproject = "PRJNA706190" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
7081388	7081388	PRJNA706190_P_NODE_50646_length_169_cov_0.866667_g50510_i0	PRJNA706190	50646	169	0.866667	1.46466723	Caudoviricetes sp.	2832643	Viruses	Viruses	307	2.73e-79	NTclustered	gi\|2058071592\|tpg\|BK042950.1\|	2832643	g50510	i0	99.408	30.810650887574	169	1	100	0	1	169	8686	8854	MAG TPA_asm: Caudoviricetes sp. isolate ct9Dg12, partial genome	blastn	5207	307	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13456470	13456470	PRJNA706190_P_NODE_82791_length_163_cov_1.368421_g82655_i0	PRJNA706190	82791	163	1.368421	2.23052623	Caudoviricetes sp.	2832643	Viruses	Viruses	276	7.41e-70	NTclustered	gi\|2058148954\|tpg\|BK034473.1\|	2832643	g82655	i0	98.101	1.8159509202454	158	3	97	0	6	163	13104	12947	MAG TPA_asm: Caudoviricetes sp. isolate ctWKI2, partial genome	blastn	296	276	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16005327	16005327	PRJNA706190_P_NODE_36693_length_181_cov_2.916667_g36557_i0	PRJNA706190	36693	181	2.916667	5.27916727	Seadornavirus kadipiroense	3241299	Viruses	Viruses	287	3.87e-73	NTclustered	gi\|2083529919\|tpd\|BR001724.1\|	104580	g36557	i0	99.371	2.60220994475138	159	0	87	1	1	158	1277	1119	TPA_asm: Kadipiro virus rat/2019/395 gene for VP4 protein, complete cds	blastn	471	287	1	Viruses		Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Sedoreoviridae	Seadornavirus	Seadornavirus kadipiroense
22380157	22380157	PRJNA706190_P_NODE_12018_length_228_cov_2.033520_g11882_i0	PRJNA706190	12018	228	2.03352	4.6364256	Varicellovirus cercopithecinealpha9	3050257	Viruses	Viruses	411	2.909999999999999e-110	NTclustered	gi\|126882977\|ref\|NC_002686.2\|	35246	g11882	i0	99.127	1.00438596491228	229	0	100	2	1	228	103670	103443	Cercopithecine herpesvirus 9, complete genome	blastn	229	411	1	Viruses		Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Varicellovirus	Varicellovirus cercopithecinealpha9
27589138	27589138	PRJNA706190_P_NODE_33264_length_186_cov_1.138686_g33128_i0	PRJNA706190	33264	186	1.138686	2.11795596	Arizlama microvirus	2859450	Viruses	Viruses	47.4	3.95e-4	NR	QXP08617.1	2859450	g33128	i0	71.8	0.629032258064516	39	9	62.9	1	184	68	360	396	QXP08617.1 MAG: replication initiator protein [Arizlama microvirus]	diamond	117	47.4	1	Viruses		Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Arizlama microvirus
28409990	28409990	PRJNA706190_P_NODE_12906_length_225_cov_1.602273_g12770_i0	PRJNA706190	12906	225	1.602273	3.60511425	Baboon endogenous virus strain M7	11764	Viruses	Viruses	149	2.1e-44	NR	YP_009109693.1	11764	g12770	i0	93.3	4	75	5	100	0	225	1	10	84	YP_009109693.1 protease [Baboon endogenous virus strain M7]	diamond	900	149	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Baboon endogenous virus
29862331	29862331	PRJNA706190_P_NODE_9711_length_238_cov_1.677249_g9575_i0	PRJNA706190	9711	238	1.677249	3.99185262	Baboon endogenous virus strain M7	11764	Viruses	Viruses	159	3.76e-43	NR	YP_009109689.1	11764	g9575	i0	100	5.97478991596639	79	0	99.6	0	238	2	1155	1233	YP_009109689.1 gag-pol precursor polyprotein [Baboon endogenous virus strain M7]	diamond	1422	159	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Baboon endogenous virus
30936689	30936689	PRJNA706190_P_NODE_3274_length_312_cov_4.102662_g3138_i0	PRJNA706190	3274	312	4.102662	12.80030544	Kadipiro virus	104580	Viruses	Viruses	136	9.61e-35	NR	WZI48451.1	104580	g3138	i0	87	1.52884615384615	77	10	74	0	16	246	1110	1186	WZI48451.1 MAG: VP1 protein [Kadipiro virus]	diamond	477	136	1	Viruses		Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Sedoreoviridae	Seadornavirus	Seadornavirus kadipiroense
31031599	31031599	PRJNA706190_P_NODE_33535_length_186_cov_0.905109_g33399_i0	PRJNA706190	33535	186	0.905109	1.68350274	Baboon endogenous virus strain M7	11764	Viruses	Viruses	89	9.38e-19	NR	YP_009109689.1	11764	g33399	i0	93.6	3.01612903225806	47	3	75.8	0	141	1	970	1016	YP_009109689.1 gag-pol precursor polyprotein [Baboon endogenous virus strain M7]	diamond	561	89	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Baboon endogenous virus
31284102	31284102	PRJNA706190_P_NODE_36575_length_182_cov_0.992481_g36439_i0	PRJNA706190	36575	182	0.992481	1.80631542	Human endogenous retrovirus K	45617	Viruses	Viruses	72.4	1.11e-13	NR	ABA28250.1	45617	g36439	i0	53.3	6.90659340659341	60	28	98.9	0	3	182	52	111	ABA28250.1 protease, partial [Human endogenous retrovirus K]	diamond	1257	72.8	0.994505494505495	Viruses	Human endogenous retroviruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Human endogenous retrovirus K

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