metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA811237" 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
808795	808795	PRJNA811237_S_NODE_34101_length_162_cov_0.902655_g33861_i0	PRJNA811237	34101	162	0.902655	1.4623011	Lentivirus simimdef	3418654	Viruses	Viruses	65.8	1.73e-6	NTclustered	gi\|331687935\|gb\|JF741333.1\|	11723	g33861	i0	95.122	3.42592592592593	41	2	25	0	1	41	324	284	Simian immunodeficiency virus isolate SIVmac251_1991SIV4_C01 envelope glycoprotein-like (env) gene, partial sequence	blastn	555	65.8	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus simimdef
14837048	14837048	PRJNA811237_S_NODE_4432_length_344_cov_2.294915_g4192_i0	PRJNA811237	4432	344	2.294915	7.8945076	Lentivirus humimdef1	3418650	Viruses	Viruses	62.1	5.41e-5	NTclustered	gi\|407734945\|gb\|JX447155.1\|	11676	g4192	i0	95	0.232558139534884	40	0	12	2	187	226	4394	4357	HIV-1 isolate AA039a03R from Thailand pol protein (pol) gene, partial cds; and vif protein (vif), vpr protein (vpr), vpu protein (vpu), envelope glycoprotein (env), and nef protein (nef) genes, complete cds	blastn	80	62.1	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
14837050	14837050	PRJNA811237_S_NODE_4512_length_340_cov_2.749141_g4272_i0	PRJNA811237	4512	340	2.749141	9.3470794	Caudoviricetes sp.	2832643	Viruses	Viruses	58.4	6.9e-4	NTclustered	gi\|2052168031\|tpg\|BK032975.1\|	2832643	g4272	i0	97.059	0.194117647058824	34	1	10	0	93	126	12793	12760	MAG TPA_asm: Caudoviricetes sp. isolate ctSSP12, partial genome	blastn	66	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22485692	22485692	PRJNA811237_S_NODE_35198_length_161_cov_0.910714_g34958_i0	PRJNA811237	35198	161	0.910714	1.46624954	Bridgettevirus constance	2734223	Viruses	Viruses	54.7	0.004	NTclustered	gi\|1842028270\|ref\|NC_048092.1\|	2419950	g34958	i0	92.105	0.236024844720497	38	3	24	0	58	95	35030	34993	Arthrobacter phage Constance, complete genome	blastn	38	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Bridgettevirus	Bridgettevirus constance
25450213	25450213	PRJNA811237_S_NODE_27940_length_167_cov_0.864407_g27700_i0	PRJNA811237	27940	167	0.864407	1.44355969	root	1	Root_unresolved	Root_unresolved	309	7.53e-80	NTclustered	gi\|2915048543\|gb\|OR222821.1\|	2832643	g27700	i0	100	2.98802395209581	167	0	100	0	1	167	54676	54842	MAG: Caudoviricetes sp. isolate MSP0536 genomic sequence	blastn	499	309	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);;