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

5 rows where bioproject = "PRJNA1122875", 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
26753309	26753309	PRJNA1122875_P_NODE_8861_length_553_cov_1.491667_g8642_i0	PRJNA1122875	8861	553	1.491667	8.24891851	Suillus luteus narnavirus 4	3067823	Viruses	Viruses	77	1.02e-12	NR	WLK77412.1	3067823	g8642	i0	30	0.976491862567812	180	119	94.9	5	527	3	48	225	WLK77412.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 4]	diamond	540	77	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus suilli
26932812	26932812	PRJNA1122875_P_NODE_22162_length_352_cov_1.655914_g21938_i0	PRJNA1122875	22162	352	1.655914	5.82881728	Viruses	10239	Viruses	Viruses	53.5	2.11e-5	NR	WPR16645.1	3066916	g21938	i0	38.9	3.89488636363636	113	56	88.6	3	313	2	280	388	WPR16645.1 MAG: RNA-dependent RNA polymerase [Lwood associated narna-like virus]	diamond	1371	53.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Lwood associated narna-like virus
27817670	27817670	PRJNA1122875_P_NODE_10984_length_501_cov_2.852804_g10763_i0	PRJNA1122875	10984	501	2.852804	14.29254804	Narnavirus	186767	Viruses	Viruses	81.6	1.51e-14	NR	WZE65507.1	3139161	g10763	i0	32.3	4	167	64	98.2	4	496	5	431	551	WZE65507.1 RNA-dependent RNA polymerase [Ophiocordyceps sinensis narnavirus 4]	diamond	2004	81.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Ophiocordyceps sinensis narnavirus 4
32473174	32473174	PRJNA1122875_P_NODE_35479_length_278_cov_1.502439_g35255_i0	PRJNA1122875	35479	278	1.502439	4.17678042	Sanya narna-like virus 1	2970204	Viruses	Viruses	81.3	1.62e-15	NR	UUW20996.1	2970204	g35255	i0	39.3	0.960431654676259	89	51	96	1	272	6	170	255	UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1]	diamond	267	81.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Sanya narna-like virus 1
32693731	32693731	PRJNA1122875_P_NODE_1560_length_1047_cov_4.960986_g1440_i0	PRJNA1122875	1560	1047	4.960986	51.94152342	Downy mildew lesion associated splipalmivirus 2	2719503	Viruses	Viruses	49.7	0.00695	NR	WNA22207.1	2719503	g1440	i0	29.9	0.306590257879656	107	67	30.1	3	108	422	12	112	WNA22207.1 MAG: hypothetical protein, partial [Downy mildew lesion associated splipalmivirus 2]	diamond	321	49.7	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 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);;