metadata: contig_metadata: 14 rows where bioproject = "PRJNA177642" and tax

14 rows where bioproject = "PRJNA177642" and tax_kingdom = "Heunggongvirae"

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
2916177	2916177	PRJNA177642_P_NODE_17883_length_165_cov_1.058824_g16658_i0	PRJNA177642	17883	165	1.058824	1.7470596	Caudoviricetes sp.	2832643	Viruses	Viruses	244	2.12e-60	NTclustered	gi\|2914758139\|gb\|OR221626.1\|	2832643	g16658	i0	93.333	1	165	11	100	0	1	165	43320	43156	MAG: Caudoviricetes sp. isolate MSP1433 genomic sequence	blastn	165	244	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2916198	2916198	PRJNA177642_P_NODE_18943_length_156_cov_2.149606_g17718_i0	PRJNA177642	18943	156	2.149606	3.35338536	Caudoviricetes sp.	2832643	Viruses	Viruses	285	1.16e-72	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g17718	i0	100	0.987179487179487	154	0	99	0	2	155	27184	27031	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	154	285	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
11258395	11258395	PRJNA177642_P_NODE_8909_length_393_cov_22.258242_g7694_i0	PRJNA177642	8909	393	22.258242	87.47489106	root	1	Root_unresolved	Root_unresolved	108	7.91e-19	NTclustered	gi\|671698184\|gb\|KM192300.1\|	10359	g7694	i0	98.361	31.4351145038168	61	1	30	0	69	129	39438	39498	Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome	blastn	12354	108	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Cytomegalovirus	Cytomegalovirus humanbeta5
11844051	11844051	PRJNA177642_P_NODE_17250_length_168_cov_1.007194_g16025_i0	PRJNA177642	17250	168	1.007194	1.69208592	Caudoviricetes sp.	2832643	Viruses	Viruses	309	7.58e-80	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g16025	i0	100	0.994047619047619	167	0	99	0	2	168	16215	16049	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	167	309	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16942732	16942732	PRJNA177642_P_NODE_15814_length_180_cov_1.874172_g14589_i0	PRJNA177642	15814	180	1.874172	3.3735096	Caudoviricetes sp.	2832643	Viruses	Viruses	331	1.75e-86	NTclustered	gi\|2914852811\|gb\|OR221766.1\|	2832643	g14589	i0	100	0.994444444444444	179	0	99	0	1	179	22229	22407	MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence	blastn	179	331	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22042021	22042021	PRJNA177642_P_NODE_13338_length_258_cov_1.803493_g12113_i0	PRJNA177642	13338	258	1.803493	4.65301194	Kenyattavirus kv136	3060064	Viruses	Viruses	169	2.23e-37	NTclustered	gi\|2438272093\|ref\|NC_071049.1\|	2419619	g12113	i0	79.498	3.70542635658915	239	48	92	1	20	257	45907	45669	Bacillus phage vB_BcoS-136, complete genome	blastn	956	169	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Kenyattavirus	Kenyattavirus kv136
23317523	23317523	PRJNA177642_P_NODE_13479_length_249_cov_1.263636_g12254_i0	PRJNA177642	13479	249	1.263636	3.14645364	Parageobacillus phage vB_PtoS_NIIg3.2	2985569	Viruses	Viruses	156	1.67e-33	NTclustered	gi\|2320140881\|gb\|OP341623.1\|	2985569	g12254	i0	79.817	0.875502008032129	218	40	87	4	31	246	29129	29344	Parageobacillus phage vB_PtoS_NIIg3.2, complete genome	blastn	218	156	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Parageobacillus phage vB_PtoS_NIIg3.2
26630803	26630803	PRJNA177642_P_NODE_17781_length_165_cov_1.882353_g16556_i0	PRJNA177642	17781	165	1.882353	3.10588245	Caudoviricetes sp.	2832643	Viruses	Viruses	97.8	5.1e-22	NR	XOR76509.1	2832643	g16556	i0	84.6	0.945454545454545	52	8	94.5	0	163	8	339	390	XOR76509.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	156	97.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27863523	27863523	PRJNA177642_P_NODE_17685_length_166_cov_1.029197_g16460_i0	PRJNA177642	17685	166	1.029197	1.70846702	Bacillus phage vB_BanS-Thrax2	2951250	Viruses	Viruses	50.1	3.28e-5	NR	UUV46239.1	2951250	g16460	i0	52.7	0.993975903614458	55	21	90.4	1	164	15	192	246	UUV46239.1 RNA ligase [Bacillus phage vB_BanS-Thrax2]	diamond	165	50.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Bacillus phage vB_BanS-Thrax2
27926772	27926772	PRJNA177642_P_NODE_16125_length_175_cov_1.917808_g14900_i0	PRJNA177642	16125	175	1.917808	3.356164	uncultured Caudovirales phage	2100421	Viruses	Viruses	52.8	3.61e-7	NR	CAB4138490.1	2100421	g14900	i0	52.3	0.754285714285714	44	21	75.4	0	2	133	44	87	CAB4138490.1 hypothetical protein UFOVP331_68 [uncultured Caudovirales phage]	diamond	132	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28337248	28337248	PRJNA177642_P_NODE_16066_length_176_cov_1.829932_g14841_i0	PRJNA177642	16066	176	1.829932	3.22068032	Caudoviricetes sp.	2832643	Viruses	Viruses	84.3	3.32e-17	NR	XOR29232.1	2832643	g14841	i0	69.5	1.00568181818182	59	17	98.9	1	3	176	812	870	XOR29232.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	177	84.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28937228	28937228	PRJNA177642_P_NODE_18008_length_164_cov_2.000000_g16783_i0	PRJNA177642	18008	164	2	3.28	Bacillus phage vB_BcoS-136	2419619	Viruses	Viruses	58.9	2.47e-8	NR	YP_010681477.1	2419619	g16783	i0	58.5	0.969512195121951	53	19	97	1	162	4	279	328	YP_010681477.1 AAA-like domain protein [Bacillus phage vB_BcoS-136]	diamond	159	58.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Kenyattavirus	Kenyattavirus kv136
30390320	30390320	PRJNA177642_P_NODE_14493_length_209_cov_1.533333_g13268_i0	PRJNA177642	14493	209	1.533333	3.20466597	Geobacillus virus E2	447909	Viruses	Viruses	98.2	1.4000000000000002e-23	NR	YP_001285807.1	447909	g13268	i0	96	1.43540669856459	50	2	71.8	0	207	58	155	204	YP_001285807.1 terminase small subunit [Geobacillus virus E2]	diamond	300	98.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Geobacillus virus E2
31717437	31717437	PRJNA177642_P_NODE_9917_length_360_cov_1.737160_g8696_i0	PRJNA177642	9917	360	1.73716	6.253776	Bacillus phage pW2	2500559	Viruses	Viruses	56.6	1.77e-6	NR	YP_010680057.1	2500559	g8696	i0	46.8	0.516666666666667	62	33	51.7	0	3	188	160	221	YP_010680057.1 exonuclease [Bacillus phage pW2]	diamond	186	56.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Sophritavirus	Sophritavirus pW2

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