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

10 rows where bioproject = "PRJNA1136957" 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
284576	284576	PRJNA1136957_S_NODE_16141_length_217_cov_1.158228_g16044_i0	PRJNA1136957	16141	217	1.158228	2.51335476	Caudoviricetes sp.	2832643	Viruses	Viruses	93.5	1.13e-14	NTclustered	gi\|2059642312\|tpg\|BK028639.1\|	2832643	g16044	i0	100	0.230414746543779	50	0	23	0	1	50	36832	36881	MAG TPA_asm: Caudoviricetes sp. isolate ctcSv2, partial genome	blastn	50	93.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
1559171	1559171	PRJNA1136957_S_NODE_16702_length_213_cov_1.850649_g16605_i0	PRJNA1136957	16702	213	1.850649	3.94188237	Moovirus moo	3060392	Viruses	Viruses	344	2.76e-90	NTclustered	gi\|2438080420\|ref\|NC_070850.1\|	2886042	g16605	i0	95.775	9.22065727699531	213	9	100	0	1	213	18536	18324	Shigella virus Moo19, complete genome	blastn	1964	344	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Schitoviridae	Moovirus	Moovirus moo
6662409	6662409	PRJNA1136957_S_NODE_15026_length_224_cov_1.472727_g14929_i0	PRJNA1136957	15026	224	1.472727	3.29890848	Caudoviricetes sp.	2832643	Viruses	Viruses	161	3.1699999999999996e-35	NTclustered	gi\|2059642312\|tpg\|BK028639.1\|	2832643	g14929	i0	90.909	0.540178571428571	121	9	54	2	100	219	16879	16998	MAG TPA_asm: Caudoviricetes sp. isolate ctcSv2, partial genome	blastn	121	161	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18136307	18136307	PRJNA1136957_S_NODE_19895_length_197_cov_0.855072_g19798_i0	PRJNA1136957	19895	197	0.855072	1.68449184	Moovirus moo	3060392	Viruses	Viruses	353	4.18e-93	NTclustered	gi\|2438080420\|ref\|NC_070850.1\|	2886042	g19798	i0	98.985	29.5583756345178	197	2	100	0	1	197	58212	58408	Shigella virus Moo19, complete genome	blastn	5823	353	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Schitoviridae	Moovirus	Moovirus moo
20686024	20686024	PRJNA1136957_S_NODE_4857_length_358_cov_1.254181_g4760_i0	PRJNA1136957	4857	358	1.254181	4.48996798	Varicellovirus cervidalpha2	3050260	Viruses	Viruses	63.9	1.57e-5	NTclustered	gi\|2500372361\|ref\|NC_075563.1\|	365327	g4760	i0	84.615	1.09497206703911	65	8	18	2	251	314	94531	94594	Cervid alphaherpesvirus 2 strain Norway, complete genome	blastn	392	63.9	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Varicellovirus	Varicellovirus cervidalpha2
20686046	20686046	PRJNA1136957_S_NODE_9237_length_279_cov_1.109091_g9140_i0	PRJNA1136957	9237	279	1.109091	3.09436389	Pijolavirus UFJFPfSW6	3431677	Viruses	Viruses	488	1.6499999999999999e-133	NTclustered	gi\|2416396763\|gb\|OP924544.1\|	3003725	g9140	i0	98.208	3.86021505376344	279	5	100	0	1	279	36140	36418	Pseudomonas phage UFJF_PfSW6, complete genome	blastn	1077	488	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autotranscriptaviridae	Pijolavirus	Pijolavirus UFJFPfSW6
27355015	27355015	PRJNA1136957_S_NODE_11883_length_249_cov_1.284211_g11786_i0	PRJNA1136957	11883	249	1.284211	3.19768539	Pseudomonas phage OBP	1124849	Viruses	Viruses	45.1	0.00574	NR	YP_004958196.1	1124849	g11786	i0	35.6	0.710843373493976	59	38	71.1	0	230	54	1	59	YP_004958196.1 hypothetical protein OBP_289 [Pseudomonas phage OBP]	diamond	177	45.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Petsuvirus	Pseudomonas phage OBP
30733832	30733832	PRJNA1136957_S_NODE_16114_length_217_cov_1.500000_g16017_i0	PRJNA1136957	16114	217	1.5	3.255	Caudoviricetes sp.	2832643	Viruses	Viruses	43.5	0.0033	NR	DAV53031.1	2832643	g16017	i0	88.9	0.248847926267281	18	2	24.9	0	62	9	2	19	DAV53031.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	54	43.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31112828	31112828	PRJNA1136957_S_NODE_13855_length_232_cov_1.554913_g13758_i0	PRJNA1136957	13855	232	1.554913	3.60739816	Caudoviricetes sp.	2832643	Viruses	Viruses	145	1.4099999999999999e-42	NR	DAV52985.1	2832643	g13758	i0	88	0.969827586206897	75	9	97	0	6	230	38	112	DAV52985.1 MAG TPA: Terminase small subunit [Caudoviricetes sp.]	diamond	225	145	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31840241	31840241	PRJNA1136957_S_NODE_14957_length_224_cov_2.957576_g14860_i0	PRJNA1136957	14957	224	2.957576	6.62497024	Caudoviricetes sp.	2832643	Viruses	Viruses	39.7	0.0345	NR	DAV53021.1	2832643	g14860	i0	42.5	0.535714285714286	40	23	53.6	0	86	205	1	40	DAV53021.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	120	39.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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