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

10 rows where bioproject = "PRJNA680334" and tax_kingdom = "Bamfordvirae"

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
6273195	6273195	PRJNA680334_S_NODE_34745_length_214_cov_50.546961_g34259_i0	PRJNA680334	34745	214	50.546961	108.17049654	Mastadenovirus	10509	Viruses	Viruses	285	1.71e-72	NTclustered	gi\|2566084967\|gb\|OR361563.1\|	28280	g34259	i0	100	102.803738317757	154	0	98	0	59	212	34189	34342	Human adenovirus E4 isolate HAdV-E4/USA/6C9/2010, complete genome	blastn	22000	285	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus exoticum
27902999	27902999	PRJNA680334_S_NODE_52605_length_189_cov_1.852564_g52119_i0	PRJNA680334	52605	189	1.852564	3.50134596	Klosneuvirus KNV1	1977640	Viruses	Viruses	90.1	3.52e-19	NR	ARF11617.1	1977640	g52119	i0	62.9	0.984126984126984	62	23	98.4	0	186	1	376	437	ARF11617.1 lysyl-tRNA synthetase [Klosneuvirus KNV1]	diamond	186	90.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
27966299	27966299	PRJNA680334_S_NODE_69285_length_173_cov_2.100000_g68799_i0	PRJNA680334	69285	173	2.1	3.633	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	62.4	1.68e-9	NR	YP_010803999.1	3060017	g68799	i0	71.4	0.606936416184971	35	10	60.7	0	30	134	457	491	YP_010803999.1 mitochondrial chaperone BCS1 [Fadolivirus algeromassiliense]	diamond	105	62.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
28009920	28009920	PRJNA680334_S_NODE_83245_length_163_cov_1.938462_g82759_i0	PRJNA680334	83245	163	1.938462	3.15969306	root	1	Root_unresolved	Root_unresolved	55.8	2.99e-7	NR	AFX93238.1	1128140	g82759	i0	54	1.91411042944785	50	23	92	0	2	151	333	382	AFX93238.1 putative transposase [Megavirus courdo11]	diamond	312	55.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
28440097	28440097	PRJNA680334_S_NODE_92486_length_157_cov_5.483871_g92000_i0	PRJNA680334	92486	157	5.483871	8.60967747	Klosneuvirus KNV1	1977640	Viruses	Viruses	42.7	0.0117	NR	ARF12021.1	1977640	g92000	i0	50	0.611464968152866	32	16	61.1	0	61	156	241	272	ARF12021.1 RNA ligase [Klosneuvirus KNV1]	diamond	96	42.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28597961	28597961	PRJNA680334_S_NODE_32887_length_218_cov_6.118919_g32401_i0	PRJNA680334	32887	218	6.118919	13.33924342	Klosneuvirus KNV1	1977640	Viruses	Viruses	61.6	5.85e-9	NR	ARF11649.1	1977640	g32401	i0	50	0.880733944954128	64	32	88.1	0	193	2	384	447	ARF11649.1 transposase [Klosneuvirus KNV1]	diamond	192	61.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
28945421	28945421	PRJNA680334_S_NODE_36488_length_211_cov_9.213483_g36002_i0	PRJNA680334	36488	211	9.213483	19.44044913	Edafosvirus sp.	2487765	Viruses	Viruses	79.3	3.45e-16	NR	AYV78935.1	2487765	g36002	i0	58.3	1.02369668246445	72	28	99.5	1	211	2	116	187	AYV78935.1 MAG: Clp protease, partial [Edafosvirus sp.]	diamond	216	79.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
31642217	31642217	PRJNA680334_S_NODE_107616_length_150_cov_1.897436_g107130_i0	PRJNA680334	107616	150	1.897436	2.846154	root	1	Root_unresolved	Root_unresolved	69.7	3.28e-12	NR	ARF09766.1	1977633	g107130	i0	64	15.88	50	18	100	0	150	1	1467	1516	ARF09766.1 ribonucleoside diphosphate reductase large subunit [Indivirus ILV1]	diamond	2382	70.1	0.994293865905849	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
32358517	32358517	PRJNA680334_S_NODE_36879_length_211_cov_2.061798_g36393_i0	PRJNA680334	36879	211	2.061798	4.35039378	Harvfovirus sp.	2487768	Viruses	Viruses	77.4	1.51e-14	NR	AYV81429.1	2487768	g36393	i0	50	2.90047393364929	68	34	96.7	0	2	205	730	797	AYV81429.1 MAG: ubiquitin-conjugating enzyme E2 [Harvfovirus sp.]	diamond	612	77.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
32799910	32799910	PRJNA680334_S_NODE_82980_length_163_cov_2.584615_g82494_i0	PRJNA680334	82980	163	2.584615	4.21292245	Edafosvirus sp.	2487765	Viruses	Viruses	43.9	0.00478	NR	AYV78613.1	2487765	g82494	i0	50	0.736196319018405	40	20	73.6	0	27	146	243	282	AYV78613.1 MAG: GIY-YIG catalytic domain-containing endonuclease [Edafosvirus sp.]	diamond	120	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus 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);;