metadata: contig_metadata: 9 rows where bioproject = "PRJNA1262902" and tax

9 rows where bioproject = "PRJNA1262902" 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
363482	363482	PRJNA1262902_P_NODE_11701_length_242_cov_0.911243_g11659_i0	PRJNA1262902	11701	242	0.911243	2.20520806	Pithovirus LCDPAC02	2506601	Viruses	Viruses	52.8	0.022	NTclustered	gi\|1588058210\|gb\|MK500300.1\|	2506601	g11659	i0	94.286	0.144628099173554	35	1	14	1	13	47	67448	67415	MAG: Pithovirus LCDPAC02 genomic sequence	blastn	35	52.8	1	Viruses	Pithoviruses							Pithovirus LCDPAC02
6741292	6741292	PRJNA1262902_P_NODE_12126_length_241_cov_0.916667_g12084_i0	PRJNA1262902	12126	241	0.916667	2.20916747	Caudoviricetes sp.	2832643	Viruses	Viruses	440	3.959999999999999e-119	NTclustered	gi\|2914972312\|gb\|OR222040.1\|	2832643	g12084	i0	99.585	34.9294605809129	241	1	100	0	1	241	124291	124531	MAG: Caudoviricetes sp. isolate MSP0074 genomic sequence	blastn	8418	440	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8016929	8016929	PRJNA1262902_P_NODE_4587_length_284_cov_1.919431_g4545_i0	PRJNA1262902	4587	284	1.919431	5.45118404	Retrovirus rattus8197	3117313	Viruses	Viruses	87.4	1.18e-17	NR	DBA47493.1	3117313	g4545	i0	75	0.633802816901408	60	15	63.4	0	243	64	550	609	DBA47493.1 MAG TPA_asm: Env [Retrovirus rattus8197]	diamond	180	87.4	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retrovirus rattus8197
10567637	10567637	PRJNA1262902_P_NODE_3349_length_309_cov_0.995763_g3307_i0	PRJNA1262902	3349	309	0.995763	3.07690767	Metapenaeus joyneri majanivirus	2984280	Viruses	Viruses	52.8	0.029	NTclustered	gi\|2327925658\|dbj\|LC738878.1\|	2984280	g3307	i0	100	0.0906148867313916	28	0	9	0	114	141	190831	190804	MAG: Metapenaeus joyneri majanivirus Tokushima2020 DNA, complete genome	blastn	28	52.8	1	Viruses				Naldaviricetes		Nimaviridae		Metapenaeus joyneri majanivirus
27186371	27186371	PRJNA1262902_P_NODE_1382_length_395_cov_1.298137_g1340_i0	PRJNA1262902	1382	395	1.298137	5.12764115	Betaretrovirus	140052	Viruses	Viruses	90.1	5.58e-18	NR	NP_955564.1	11757	g1340	i0	45.2	6.65316455696203	73	40	55.4	0	295	77	755	827	NP_955564.1 p30DU-p13PR-RT-IN [Mouse mammary tumor virus]	diamond	2628	90.1	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus murmamtum
28147896	28147896	PRJNA1262902_P_NODE_9425_length_247_cov_0.885057_g9383_i0	PRJNA1262902	9425	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	68.9	4.77e-12	NR	DAS40667.1	2832643	g9383	i0	64.6	1.25101214574899	48	17	58.3	0	146	3	3	50	DAS40667.1 MAG TPA: chromosome partitioning protein [Caudoviricetes sp.]	diamond	309	68.9	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30263774	30263774	PRJNA1262902_P_NODE_2712_length_325_cov_1.726190_g2670_i0	PRJNA1262902	2712	325	1.72619	5.6101175	Mouse mammary tumor virus	11757	Viruses	Viruses	93.6	1.45e-19	NR	NP_955564.1	11757	g2670	i0	43.8	3.87692307692308	105	59	96.9	0	325	11	630	734	NP_955564.1 p30DU-p13PR-RT-IN [Mouse mammary tumor virus]	diamond	1260	93.6	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Betaretrovirus	Betaretrovirus murmamtum
31622439	31622439	PRJNA1262902_P_NODE_7296_length_251_cov_1.679775_g7254_i0	PRJNA1262902	7296	251	1.679775	4.21623525	Brevundimonas phage vB_BgoS-Bajun	2948594	Viruses	Viruses	79.7	9.21e-16	NR	UTC29866.1	2948594	g7254	i0	53	0.99203187250996006	83	38	98	1	4	249	10	92	UTC29866.1 hypothetical protein BAJUN_02360 [Brevundimonas phage vB_BgoS-Bajun]	diamond	249	79.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Brevundimonas phage vB_BgoS-Bajun
32287213	32287213	PRJNA1262902_P_NODE_12679_length_226_cov_2.183007_g12637_i0	PRJNA1262902	12679	226	2.183007	4.93359582	Retrovirus rattus8197	3117313	Viruses	Viruses	91.3	2.45e-19	NR	DBA47493.1	3117313	g12637	i0	66.1	0.783185840707965	59	20	78.3	0	196	20	126	184	DBA47493.1 MAG TPA_asm: Env [Retrovirus rattus8197]	diamond	177	91.3	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retrovirus rattus8197

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