metadata: contig_metadata: 5 rows where bioproject = "PRJNA1160211", tax_kingdom = "Orthornavirae" and tax

5 rows where bioproject = "PRJNA1160211", tax_kingdom = "Orthornavirae" and tax_phylum = "Lenarviricota"

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
6687148	6687148	PRJNA1160211_S_NODE_138566_length_391_cov_12.044025_g137334_i0	PRJNA1160211	138566	391	12.044025	47.09213775	Leviviridae sp.	2027243	Viruses	Viruses	222	2.69e-53	NTclustered	gi\|2245487496\|gb\|ON162862.1\|	2027243	g137334	i0	91.463	0.419437340153453	164	10	41	4	230	391	22	183	MAG: Leviviridae sp. isolate 308R-k141_271748 RNA dependent RNA polymerase gene, partial cds	blastn	164	222	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
13062714	13062714	PRJNA1160211_S_NODE_116851_length_426_cov_39.626062_g115622_i0	PRJNA1160211	116851	426	39.626062	168.80702412	Narnaviridae sp.	2583949	Viruses	Viruses	619	8.979999999999999e-173	NTclustered	gi\|2395813472\|gb\|ON812038.1\|	2583949	g115622	i0	96.063	3.87793427230047	381	14	89	1	41	421	1511	1890	MAG: Narnaviridae sp. isolate TIGMIC_6 putative RNA-dependent RNA polymerase gene, partial cds	blastn	1652	619	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Narnaviridae sp.
27217508	27217508	PRJNA1160211_S_NODE_40082_length_609_cov_7.777985_g38943_i0	PRJNA1160211	40082	609	7.777985	47.36792865	Fiersviridae	2842319	Viruses	Viruses	68.9	8.66e-10	NR	YP_010769172.1	2786366	g38943	i0	47	1.04926108374384	83	40	40.4	2	336	581	105	184	YP_010769172.1 maturation protein, partial [ssRNA phage Gerhypos.4_61]	diamond	639	69.3	0.994227994227994	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Cahrpivirus	Cahrpivirus humenecus
28966965	28966965	PRJNA1160211_S_NODE_270688_length_247_cov_1.942529_g269455_i0	PRJNA1160211	270688	247	1.942529	4.79804663	Magnaporthe oryzae botourmiavirus 7	2755484	Viruses	Viruses	67.4	8.11e-11	NR	QVU39995.1	2755484	g269455	i0	48.2	2.01619433198381	83	41	98.4	1	5	247	392	474	QVU39995.1 RNA-dependent RNA polymerase [Magnaporthe oryzae botourmiavirus 7]	diamond	498	67.4	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Epsilonscleroulivirus	Epsilonscleroulivirus alphaoryzae
29345725	29345725	PRJNA1160211_S_NODE_10509_length_808_cov_17.221769_g9710_i0	PRJNA1160211	10509	808	17.221769	139.15189352	Sclerotinia sclerotiorum mitovirus 39	2822890	Viruses	Viruses	102	2.32e-20	NR	QUE49178.1	2822890	g9710	i0	43.2	0.516089108910891	139	75	51.2	3	347	760	15	150	QUE49178.1 MAG: RNA-dependent RNA polymerase, partial [Sclerotinia sclerotiorum mitovirus 39]	diamond	417	102	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Sclerotinia sclerotiorum mitovirus 39

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