metadata: contig_metadata: 6 rows where bioproject = "PRJDB4941" and tax

6 rows where bioproject = "PRJDB4941" 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
14038302	14038302	PRJDB4941_P_NODE_2132_length_1196_cov_2.339146_g1552_i0	PRJDB4941	2132	1196	2.339146	27.97618616	Zhangzhou Narna tick virus 4	2972250	Viruses	Viruses	526	1.33e-181	NR	UYL95399.1	2972250	g1552	i0	77	1.67809364548495	335	76	84	1	1188	184	210	543	UYL95399.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 4]	diamond	2007	526	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Zhangzhou Narna tick virus 4
27412019	27412019	PRJDB4941_P_NODE_19163_length_235_cov_1.118280_g18395_i0	PRJDB4941	19163	235	1.11828	2.627958	Nanning Narna tick virus 3	2972237	Viruses	Viruses	148	9.38e-40	NR	UYL95385.1	2972237	g18395	i0	78.2	0.995744680851064	78	17	99.6	0	1	234	465	542	UYL95385.1 MAG: hypothetical protein [Nanning Narna tick virus 3]	diamond	234	148	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Nanning Narna tick virus 3
28011893	28011893	PRJDB4941_P_NODE_5945_length_527_cov_1.960251_g5178_i0	PRJDB4941	5945	527	1.960251	10.33052277	Downy mildew lesion associated splipalmivirus 44	3070776	Viruses	Viruses	160	1.02e-46	NR	XHY85182.1	3070776	g5178	i0	54.3	0.922201138519924	162	65	88.8	4	470	3	10	168	XHY85182.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 44]	diamond	486	160	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 44
28416345	28416345	PRJDB4941_P_NODE_40686_length_162_cov_0.920354_g39918_i0	PRJDB4941	40686	162	0.920354	1.49097348	Viruses	10239	Viruses	Viruses	45.4	0.00136	NR	UYL95400.1	2972251	g39918	i0	50	1.48148148148148	42	20	75.9	1	160	38	438	479	UYL95400.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 5]	diamond	240	45.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Zhangzhou Narna tick virus 5
29337824	29337824	PRJDB4941_P_NODE_13169_length_299_cov_1.456000_g12401_i0	PRJDB4941	13169	299	1.456	4.35344	Zhangzhou Narna tick virus 4	2972250	Viruses	Viruses	173	3.35e-49	NR	UYL95399.1	2972250	g12401	i0	79.8	0.993311036789298	99	20	99.3	0	1	297	107	205	UYL95399.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 4]	diamond	297	173	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Zhangzhou Narna tick virus 4
30222020	30222020	PRJDB4941_P_NODE_40092_length_163_cov_0.912281_g39324_i0	PRJDB4941	40092	163	0.912281	1.48701803	Leptosphaeria biglobosa narnavirus 9	2985684	Viruses	Viruses	80.9	4.55e-16	NR	UYL94476.1	2985684	g39324	i0	75.9	0.993865030674847	54	13	99.4	0	1	162	42	95	UYL94476.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa narnavirus 9]	diamond	162	80.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Leptosphaeria biglobosa narnavirus 9

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