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

5 rows where analysis = "blastn", bioproject = "PRJNA473824" 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
446373	446373	PRJNA473824_P_NODE_130161_length_158_cov_0.958678_g129523_i0	PRJNA473824	130161	158	0.958678	1.51471124	Yellow silver pine associated botourmia-like virus 46	3066816	Viruses	Viruses	169	1.24e-37	NTclustered	gi\|2626077041\|gb\|OQ987364.1\|	3066816	g129523	i0	86.538	2.77848101265823	156	17	97	4	5	158	130	283	MAG: Yellow silver pine associated botourmia-like virus 46 isolate LEPINT genomic sequence	blastn	439	169	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Yellow silver pine associated botourmia-like virus 46
4273371	4273371	PRJNA473824_P_NODE_1384_length_2546_cov_23586.354324_g1259_i0	PRJNA473824	1384	2546	23586.354324	600508.58108904	Narnavirus saccharominor	3431059	Viruses	Viruses	4566	0	NTclustered	gi\|21557564\|ref\|NC_004051.1\|	186772	g1259	i0	99.443	4.85545954438335	2514	14	99	0	17	2530	2514	1	Saccharomyces 20S RNA narnavirus, complete genome	blastn	12362	4566	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus saccharominor
9374074	9374074	PRJNA473824_P_NODE_127848_length_161_cov_0.895161_g127210_i0	PRJNA473824	127848	161	0.895161	1.44120921	Ripachij virus	3130407	Viruses	Viruses	246	5.7199999999999986e-61	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g127210	i0	94.375	149.515527950311	160	9	99	0	1	160	447	606	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	24072	246	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
17024128	17024128	PRJNA473824_P_NODE_314_length_4652_cov_425.325894_g279_i0	PRJNA473824	314	4652	425.325894	19786.16058888	Totivirus ni	3432954	Viruses	Viruses	5129	0	NTclustered	gi\|9627980\|ref\|NC_001641.1\|	42478	g279	i0	99.056	3.94733447979364	2859	25	99	2	1795	4652	4614	1757	Saccharomyces cerevisiae virus L-BC (La), complete genome	blastn	18363	5129	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus ni
17673816	17673816	PRJNA473824_P_NODE_132454_length_155_cov_1.322034_g131816_i0	PRJNA473824	132454	155	1.322034	2.0491527	Tobamovirus	12234	Viruses	Viruses	276	6.95e-70	NTclustered	gi\|2647550531\|gb\|OR843968.1\|	2795454	g131816	i0	98.71	15.3032258064516	155	2	100	0	1	155	455	301	Tobamovirus sp. strain MR233-17E/1297 nonstructural polyprotein p183 and nonstructural polyprotein p126 genes, partial cds; and movement protein and structural protein genes, complete cds	blastn	2372	276	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus 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);;