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

5 rows where bioproject = "PRJNA438111", 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
27708188	27708188	PRJNA438111_P_NODE_2704_length_591_cov_2.743772_g2244_i0	PRJNA438111	2704	591	2.743772	16.21569252	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	94	2.32e-18	NR	YP_010840939.1	2951531	g2244	i0	41.4	0.736040609137056	145	80	71.6	3	6	428	24	167	YP_010840939.1 L protein [Hardyhead chuvirus]	diamond	435	94	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
28781123	28781123	PRJNA438111_P_NODE_5127_length_436_cov_2.486486_g4559_i0	PRJNA438111	5127	436	2.486486	10.84107896	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	99.4	5.65e-21	NR	WLN26256.1	2951531	g4559	i0	42	1.65137614678899	119	69	81.9	0	421	65	97	215	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	720	99.4	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
30597664	30597664	PRJNA438111_P_NODE_9493_length_331_cov_2.122517_g8873_i0	PRJNA438111	9493	331	2.122517	7.02553127	Chuvivirus	2842604	Viruses	Viruses	77.8	4.92e-14	NR	WET19887.1	2842604	g8873	i0	73.1	0.942598187311178	52	14	47.1	0	176	331	305	356	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	312	77.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
31434678	31434678	PRJNA438111_P_NODE_11356_length_305_cov_3.608696_g10731_i0	PRJNA438111	11356	305	3.608696	11.0065228	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	65.1	1.14e-9	NR	UVF58767.1	2951531	g10731	i0	43.6	2.31147540983607	78	43	75.7	1	231	1	1	78	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	705	65.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
31845881	31845881	PRJNA438111_P_NODE_65017_length_168_cov_1.021583_g64392_i0	PRJNA438111	65017	168	1.021583	1.71625944	Liverwort associated bunyavirus 3	2933081	Viruses	Viruses	66.2	6.83e-11	NR	CAI5383925.1	2933081	g64392	i0	56.9	1.73214285714286	51	22	91.1	0	11	163	735	785	CAI5383925.1 RNA-dependent RNA polymerase [Liverwort associated bunyavirus 3]	diamond	291	66.2	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Liverwort associated bunyavirus 3

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