metadata: contig_metadata: 5 rows where bioproject = "PRJNA432257", tax_phylum = "Negarnaviricota" and tax

5 rows where bioproject = "PRJNA432257", tax_phylum = "Negarnaviricota" 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
2979662	2979662	PRJNA432257_S_NODE_108463_length_168_cov_1.809160_g108082_i0	PRJNA432257	108463	168	1.80916	3.0393888	Formivirus gorytis	2844681	Viruses	Viruses	52.8	0.014	NTclustered	gi\|2500379381\|ref\|NC_076500.1\|	2789450	g108082	i0	100	0.166666666666667	28	0	17	0	9	36	4094	4121	Hymenopteran orino-related virus OKIAV85 nucleoprotein (QKO73_gp1), hypothetical protein (QKO73_gp2), hypothetical protein (QKO73_gp3), glycoprotein (QKO73_gp4), and RdRp (QKO73_gp5) genes, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Nyamiviridae	Formivirus	Formivirus gorytis
24040386	24040386	PRJNA432257_S_NODE_1279_length_906_cov_1435.552359_g1183_i0	PRJNA432257	1279	906	1435.552359	13006.10437254	root	1	Root_unresolved	Root_unresolved	1286	0	NTclustered	gi\|2288961152\|gb\|OP242455.1\|	12814	g1183	i0	100	79.0883002207506	696	0	77	0	107	802	99	794	Mutant Respiratory syncytial virus clone RSV_mKate2_1-0006434_2269X, complete genome	blastn	71654	1297	0.991518889745567	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Pneumoviridae	Orthopneumovirus	Orthopneumovirus bovis
26664007	26664007	PRJNA432257_S_NODE_7181_length_458_cov_64.178147_g6868_i0	PRJNA432257	7181	458	64.178147	293.93591326	Aspen mosaic-associated virus	2681381	Viruses	Viruses	122	2.26e-30	NR	WLF82580.1	2681381	g6868	i0	50	1.53930131004367	120	57	76.6	1	425	75	186	305	WLF82580.1 nucleoprotein [Aspen mosaic-associated virus]	diamond	705	122	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Fimoviridae	Emaravirus	Emaravirus populi
29160271	29160271	PRJNA432257_S_NODE_4009_length_568_cov_8.638418_g3774_i0	PRJNA432257	4009	568	8.638418	49.06621424	blackberry leaf mottle-associated virus	3070201	Viruses	Viruses	78.6	2.14e-13	NR	QBM15141.1	3070201	g3774	i0	40.9	0.670774647887324	127	70	67.1	1	568	188	236	357	QBM15141.1 movement protein [blackberry leaf mottle-associated virus]	diamond	381	78.6	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Fimoviridae	Emaravirus	Emaravirus rubi
29270996	29270996	PRJNA432257_S_NODE_79949_length_193_cov_1.961538_g79568_i0	PRJNA432257	79949	193	1.961538	3.78576834	Chuvivirus	2842604	Viruses	Viruses	52	1.06e-5	NR	YP_010839346.1	2842604	g79568	i0	46.4	1.74093264248705	56	29	87	1	184	17	454	508	YP_010839346.1 putative nucleoprotein [Wenzhou crab virus 2]	diamond	336	52	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus

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