metadata: contig_metadata: 5 rows where bioproject = "PRJNA798511" and tax

5 rows where bioproject = "PRJNA798511" 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
13544050	13544050	PRJNA798511_P_NODE_42551_length_401_cov_1.817073_g38287_i0	PRJNA798511	42551	401	1.817073	7.28646273	Rheavirus sinusmexicani	3047716	Viruses	Viruses	58.4	8.26e-4	NTclustered	gi\|310830989\|ref\|NC_014637.1\|	693272	g38287	i0	88	0.124688279301746	50	5	12	1	285	334	113263	113215	Cafeteria roenbergensis virus BV-PW1, complete genome	blastn	50	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Rheavirus	Rheavirus sinusmexicani
16092716	16092716	PRJNA798511_P_NODE_25293_length_633_cov_1.637500_g21108_i0	PRJNA798511	25293	633	1.6375	10.365375	Cotonvirus japonicum	3059904	Viruses	Viruses	56.5	0.005	NTclustered	gi\|2500766720\|ref\|NC_079139.1\|	2811091	g21108	i0	100	0.0473933649289099	30	0	5	0	54	83	1303378	1303349	Cotonvirus japonicus DNA, complete genome	blastn	30	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
28633205	28633205	PRJNA798511_P_NODE_49007_length_362_cov_1.550173_g44741_i0	PRJNA798511	49007	362	1.550173	5.61162626	Adintovirus eptesicus6483	3115904	Viruses	Viruses	58.5	4.33e-7	NR	DBA49209.1	3115904	g44741	i0	38	2.46961325966851	100	43	82	5	358	62	496	577	DBA49209.1 MAG TPA_asm: PolBb [Adintovirus eptesicus6483]	diamond	894	58.5	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus eptesicus6483
29485233	29485233	PRJNA798511_P_NODE_77630_length_272_cov_1.160804_g73364_i0	PRJNA798511	77630	272	1.160804	3.15738688	Drosophila-associated adintovirus 1	2744816	Viruses	Viruses	62.8	4.73e-9	NR	QKS69560.1	2744816	g73364	i0	49.2	0.672794117647059	61	31	67.3	0	271	89	260	320	QKS69560.1 PolB [Drosophila-associated adintovirus 1]	diamond	183	62.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Drosophila-associated adintovirus 1
32298925	32298925	PRJNA798511_P_NODE_48879_length_363_cov_1.100000_g44613_i0	PRJNA798511	48879	363	1.1	3.993	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	159	7.92e-44	NR	YP_010803522.1	3060017	g44613	i0	63.9	0.983471074380165	119	42	97.5	1	362	9	356	474	YP_010803522.1 flotillin domain-containing protein [Fadolivirus algeromassiliense]	diamond	357	159	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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