metadata: contig_metadata: 7 rows where bioproject = "PRJNA1074408" and tax

7 rows where bioproject = "PRJNA1074408" and tax_kingdom = "Orthornavirae"

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
190997	190997	PRJNA1074408_S_NODE_2401_length_295_cov_6.571429_g2271_i0	PRJNA1074408	2401	295	6.571429	19.38571555	Jujube closterovirus 1	3043313	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2496749738\|gb\|OP673405.1\|	3043313	g2271	i0	100	0.196610169491525	30	0	10	0	266	295	35	6	Jujube closterovirus 1 isolate AKS15-20, complete genome	blastn	58	56.5	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae		Jujube closterovirus 1
1465576	1465576	PRJNA1074408_S_NODE_1242_length_404_cov_7.454294_g1112_i0	PRJNA1074408	1242	404	7.454294	30.11534776	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	652	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1112	i0	95.771	0.995049504950495	402	17	99	0	1	402	6654	7055	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	402	652	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
4017544	4017544	PRJNA1074408_S_NODE_8684_length_160_cov_1.230769_g8554_i0	PRJNA1074408	8684	160	1.230769	1.9692304	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	263	5.629999999999999e-66	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8554	i0	96.25	1	160	6	100	0	1	160	2284	2443	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	160	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
16767926	16767926	PRJNA1074408_S_NODE_1854_length_333_cov_3.582759_g1724_i0	PRJNA1074408	1854	333	3.582759	11.93058747	Zebrafish picornavirus 1	2304617	Viruses	Viruses	582	8.999999999999997e-162	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1724	i0	98.198	4.54054054054054	333	6	100	0	1	333	7840	8172	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1512	582	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
16767949	16767949	PRJNA1074408_S_NODE_7454_length_172_cov_1.116279_g7324_i0	PRJNA1074408	7454	172	1.116279	1.91999988	Pestivirus bovis	3052619	Viruses	Viruses	196	6.3e-46	NTclustered	gi\|2127986378\|gb\|MW054934.1\|	11099	g7324	i0	87.647	9.73255813953488	170	19	98	2	1	169	811	643	Bovine viral diarrhea virus 1 strain LA/87/05, complete genome	blastn	1674	196	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
18042735	18042735	PRJNA1074408_S_NODE_9775_length_152_cov_0.880734_g9645_i0	PRJNA1074408	9775	152	0.880734	1.33871568	Chronazanb virus	3129852	Viruses	Viruses	119	1.21e-22	NTclustered	gi\|2717318485\|gb\|PP172249.1\|	3129852	g9645	i0	94.737	7.72368421052632	76	4	50	0	77	152	4398	4473	MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence	blastn	1174	119	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazanb virus
21867795	21867795	PRJNA1074408_S_NODE_5178_length_203_cov_1.768750_g5048_i0	PRJNA1074408	5178	203	1.76875	3.5905625	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	279	7.45e-71	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5048	i0	91.542	0.990147783251232	201	16	99	1	1	201	6766	6965	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	201	279	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2

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