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

6 rows where bioproject = "PRJNA613025" 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_species
591800	591800	PRJNA613025_S_NODE_23321_length_197_cov_3.263514_g23167_i0	PRJNA613025	23321	197	3.263514	6.42912258	Ripaglys virus	3130696	Viruses	Viruses	169	1.62e-37	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g23167	i0	82.234	527.629441624365	197	34	100	1	1	197	2499	2694	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	103943	169	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Ripaglys virus
1867407	1867407	PRJNA613025_S_NODE_10402_length_382_cov_1.780781_g10249_i0	PRJNA613025	10402	382	1.780781	6.80258342	Ripaglys virus	3130696	Viruses	Viruses	287	9.17e-73	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g10249	i0	81.564	257.376963350785	358	57	93	9	1	354	1306	954	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	98318	287	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Ripaglys virus
5695306	5695306	PRJNA613025_S_NODE_21385_length_209_cov_3.593750_g21231_i0	PRJNA613025	21385	209	3.59375	7.5109375	Ripaglys virus	3130696	Viruses	Viruses	165	2.26e-36	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g21231	i0	81.818	193	198	35	95	1	1	198	2498	2694	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	40337	165	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Ripaglys virus
8244745	8244745	PRJNA613025_S_NODE_18507_length_233_cov_6.065217_g18353_i0	PRJNA613025	18507	233	6.065217	14.13195561	Chrocagosk virus	3129397	Viruses	Viruses	169	1.9799999999999997e-37	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g18353	i0	100	39.3948497854077	91	0	39	0	1	91	236	326	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	9179	169	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Chrocagosk virus
13345610	13345610	PRJNA613025_S_NODE_12771_length_321_cov_6.191176_g12617_i0	PRJNA613025	12771	321	6.191176	19.87367496	Chrocagosk virus	3129397	Viruses	Viruses	69.4	2.99e-7	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g12617	i0	91.837	0.152647975077882	49	4	15	0	58	106	507	555	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	49	69.4	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Chrocagosk virus
24817867	24817867	PRJNA613025_S_NODE_15620_length_269_cov_9.627273_g15466_i0	PRJNA613025	15620	269	9.627273	25.89736437	Chrocagosk virus	3129397	Viruses	Viruses	342	1.31e-89	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g15466	i0	92.5	17.7063197026022	240	17	89	1	1	240	239	1	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	4763	342	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Chrocagosk virus

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