metadata: contig_metadata: 20 rows where bioproject = "PRJNA1010662" and tax

20 rows where bioproject = "PRJNA1010662" 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
1001472	1001472	PRJNA1010662_S_NODE_2841_length_198_cov_1.858065_g2796_i0	PRJNA1010662	2841	198	1.858065	3.6789687	Pestivirus	11095	Viruses	Viruses	300	5.55e-77	NTclustered	gi\|800924334\|gb\|KP941592.1\|	11099	g2796	i0	93.939	99.2323232323232	198	12	100	0	1	198	8789	8986	Bovine viral diarrhea virus 1 strain USMARC-55926 polyprotein gene, complete cds	blastn	19648	300	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
2705231	2705231	PRJNA1010662_S_NODE_3823_length_175_cov_1.954545_g3778_i0	PRJNA1010662	3823	175	1.954545	3.42045375	Sopidub virus	3131684	Viruses	Viruses	141	3.06e-29	NTclustered	gi\|2717323145\|gb\|PP173985.1\|	3131684	g3778	i0	88.136	8.46857142857143	118	14	67	0	48	165	2145	2262	MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence	blastn	1482	141	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae		Sopidub virus
2705233	2705233	PRJNA1010662_S_NODE_3_length_2060_cov_31.965791_g2_i0	PRJNA1010662	3	2060	31.965791	658.4952946	Moloney murine leukemia virus	11801	Viruses	Viruses	1282	0	NR	NP_057933.2	11801	g2	i0	97.5	2.85291262135922	653	16	95.1	0	82	2040	677	1329	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5877	1282	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
3552049	3552049	PRJNA1010662_S_NODE_23_length_1074_cov_8.774006_g15_i0	PRJNA1010662	23	1074	8.774006	94.23282444	Bundibugyo virus	565995	Viruses	Viruses	580	4.199999999999999e-207	NR	YP_003815434.1	565995	g15	i0	100	0.818435754189944	293	0	81.8	0	194	1072	1	293	YP_003815434.1 matrix protein [Bundibugyo virus]	diamond	879	580	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Filoviridae	Orthoebolavirus	Orthoebolavirus bundibugyoense
4829483	4829483	PRJNA1010662_S_NODE_384_length_431_cov_5.097938_g339_i0	PRJNA1010662	384	431	5.097938	21.97211278	root	1	Root_unresolved	Root_unresolved	756	0	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g339	i0	99.758	95.8074245939675	413	0	96	1	14	426	17212	16801	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	41293	756	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
5257865	5257865	PRJNA1010662_P_NODE_9565_length_187_cov_2.623188_g9506_i0	PRJNA1010662	9565	187	2.623188	4.90536156	Sopidub virus	3131684	Viruses	Viruses	117	5.600000000000001e-22	NTclustered	gi\|2717323145\|gb\|PP173985.1\|	3131684	g9506	i0	88.542	54.8877005347594	96	11	51	0	1	96	2225	2130	MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence	blastn	10264	117	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae		Sopidub virus
5257904	5257904	PRJNA1010662_S_NODE_725_length_337_cov_2.676871_g680_i0	PRJNA1010662	725	337	2.676871	9.02105527	Caudoviricetes sp.	2832643	Viruses	Viruses	425	1.63e-114	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g680	i0	90.03	353.878338278932	331	29	97	4	1	328	17851	18180	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	119257	425	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
9082354	9082354	PRJNA1010662_P_NODE_15368_length_164_cov_0.904348_g15309_i0	PRJNA1010662	15368	164	0.904348	1.48313072	Caudoviricetes sp.	2832643	Viruses	Viruses	159	7.84e-35	NTclustered	gi\|2914780835\|gb\|OR222308.1\|	2832643	g15309	i0	86.076	8.13414634146342	158	10	91	10	1	150	1367	1214	MAG: Caudoviricetes sp. isolate MSP0659 genomic sequence	blastn	1334	159	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11633531	11633531	PRJNA1010662_P_NODE_6090_length_222_cov_1.416185_g6031_i0	PRJNA1010662	6090	222	1.416185	3.1439307	Microbacterium phage Lyell	2250351	Viruses	Viruses	52.8	0.02	NTclustered	gi\|1428086676\|gb\|MH371109.1\|	2250351	g6031	i0	96.875	0.144144144144144	32	0	14	1	135	165	58114	58145	Microbacterium phage Lyell, complete genome	blastn	32	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Microbacterium phage Lyell
16731875	16731875	PRJNA1010662_S_NODE_1734_length_239_cov_2.020408_g1689_i0	PRJNA1010662	1734	239	2.020408	4.82877512	Caudoviricetes sp.	2832643	Viruses	Viruses	403	5.15e-108	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g1689	i0	97.071	287.573221757322	239	7	100	0	1	239	18075	18313	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	68730	403	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17579342	17579342	PRJNA1010662_S_NODE_3554_length_180_cov_8.051095_g3509_i0	PRJNA1010662	3554	180	8.051095	14.491971	Bundibugyo virus	565995	Viruses	Viruses	88.2	5.26e-19	NR	YP_003815434.1	565995	g3509	i0	100	0.666666666666667	40	0	66.7	0	179	60	287	326	YP_003815434.1 matrix protein [Bundibugyo virus]	diamond	120	88.2	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Filoviridae	Orthoebolavirus	Orthoebolavirus bundibugyoense
26932137	26932137	PRJNA1010662_P_NODE_17422_length_152_cov_2.009709_g17363_i0	PRJNA1010662	17422	152	2.009709	3.05475768	Alphabaculovirus	558016	Viruses	Viruses	72	5.45e-15	NR	NP_037883.1	10454	g17363	i0	68	2.96052631578947	50	16	98.7	0	3	152	2	51	NP_037883.1 ORF123 v-ubiquitin [Spodoptera exigua multiple nucleopolyhedrovirus]	diamond	450	72	1	Viruses			Naldaviricetes	Lefavirales	Baculoviridae	Alphabaculovirus	Spodoptera exigua multiple nucleopolyhedrovirus
27002678	27002678	PRJNA1010662_P_NODE_8262_length_198_cov_1.852349_g8203_i0	PRJNA1010662	8262	198	1.852349	3.66765102	Betapolyomavirus macacae	1891767	Viruses	Viruses	55.8	4.78e-7	NR	AAK29054.1	1891767	g8203	i0	64.3	0.636363636363636	42	15	63.6	0	136	11	494	535	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	126	55.8	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
27508670	27508670	PRJNA1010662_P_NODE_11503_length_174_cov_1.664000_g11444_i0	PRJNA1010662	11503	174	1.664	2.89536	Barrevirus sp.	2487763	Viruses	Viruses	70.9	1.25e-12	NR	AYV77123.1	2487763	g11444	i0	57.1	0.96551724137931	56	24	96.6	0	2	169	250	305	AYV77123.1 MAG: GDP-mannose 4,6 dehydratase [Barrevirus sp.]	diamond	168	70.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29402955	29402955	PRJNA1010662_P_NODE_5649_length_228_cov_2.351955_g5590_i0	PRJNA1010662	5649	228	2.351955	5.3624574	Caudoviricetes sp.	2832643	Viruses	Viruses	42.7	0.00302	NR	DAV81047.1	2832643	g5590	i0	50	0.5	38	19	50	0	76	189	9	46	DAV81047.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	114	42.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31393526	31393526	PRJNA1010662_P_NODE_5456_length_232_cov_1.125683_g5397_i0	PRJNA1010662	5456	232	1.125683	2.61158456	Caudoviricetes sp.	2832643	Viruses	Viruses	43.1	0.0249	NR	DAT67653.1	2832643	g5397	i0	40.3	2.58620689655172	62	36	80.2	1	1	186	1473	1533	DAT67653.1 MAG TPA: Large polyvalent protein associated domain 23 [Caudoviricetes sp.]	diamond	600	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31520015	31520015	PRJNA1010662_P_NODE_14196_length_166_cov_0.880342_g14137_i0	PRJNA1010662	14196	166	0.880342	1.46136772	Mimivirus LCMiAC	2506609	Viruses	Viruses	43.5	0.00706	NR	QBK89022.1	2506609	g14137	i0	68	2.69277108433735	25	8	45.2	0	8	82	20	44	QBK89022.1 MAG: MORN repeat protein [Mimivirus LCMiAC02]	diamond	447	43.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Mimivirus LCMiAC02
32152582	32152582	PRJNA1010662_P_NODE_13078_length_168_cov_0.873950_g13019_i0	PRJNA1010662	13078	168	0.87395	1.468236	Homavirus sp.	2487769	Viruses	Viruses	91.7	8.09e-20	NR	AYV82270.1	2487769	g13019	i0	67.3	0.982142857142857	55	18	98.2	0	165	1	439	493	AYV82270.1 MAG: hypothetical protein Homavirus23_1, partial [Homavirus sp.]	diamond	165	91.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
32500844	32500844	PRJNA1010662_S_NODE_2659_length_203_cov_1.500000_g2614_i0	PRJNA1010662	2659	203	1.5	3.045	Erysiphe necator associated ssRNA virus 13	2743179	Viruses	Viruses	56.2	3.87e-7	NR	QKN22659.1	2743179	g2614	i0	49.1	0.842364532019704	57	29	84.2	0	201	31	1060	1116	QKN22659.1 replicase [Erysiphe necator associated ssRNA virus 13]	diamond	171	56.2	1	Viruses							Erysiphe necator associated ssRNA virus 13
32689722	32689722	PRJNA1010662_P_NODE_12600_length_169_cov_0.866667_g12541_i0	PRJNA1010662	12600	169	0.866667	1.46466723	uncultured Caudovirales phage	2100421	Viruses	Viruses	64.7	1.58e-10	NR	CAB4159814.1	2100421	g12541	i0	59.2	1.7396449704142	49	20	87	0	14	160	29	77	CAB4159814.1 hypothetical protein UFOVP726_42 [uncultured Caudovirales phage]	diamond	294	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch

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