metadata: contig_metadata: 10 rows where bioproject = "PRJNA385073" and tax

10 rows where bioproject = "PRJNA385073" 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
6784362	6784362	PRJNA385073_P_NODE_9306_length_418_cov_1.130435_g9145_i0	PRJNA385073	9306	418	1.130435	4.7252183	Andihavirus borborohabitans	2843692	Viruses	Viruses	211	6.27e-50	NTclustered	gi\|2497515024\|ref\|NC_074146.1\|	2786658	g9145	i0	87.166	0.447368421052632	187	23	45	1	92	278	1	186	SsRNA phage SRR7976300_9 genomic sequence	blastn	187	211	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Solspiviridae	Andihavirus	Andihavirus borborohabitans
11884162	11884162	PRJNA385073_P_NODE_14030_length_360_cov_1.898955_g13869_i0	PRJNA385073	14030	360	1.898955	6.836238	Chrocajirk virus	3129534	Viruses	Viruses	191	6.93e-44	NTclustered	gi\|2717317823\|gb\|PP171982.1\|	3129534	g13869	i0	100	36.25	103	0	29	0	1	103	14	116	MAG: Chrocajirk virus isolate CC1C_k141_100002 genomic sequence	blastn	13050	191	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Chrocajirk virus
11884955	11884955	PRJNA385073_P_NODE_4950_length_537_cov_17.081897_g4792_i0	PRJNA385073	4950	537	17.081897	91.72978689	Bahdevuvirus caenivivens	2843795	Viruses	Viruses	342	2.8e-89	NTclustered	gi\|2497513288\|ref\|NC_073766.1\|	2786400	g4792	i0	94.954	0.899441340782123	218	11	41	0	320	537	241	24	SsRNA phage SRR5466365_1 genomic sequence	blastn	483	342	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Atkinsviridae	Bahdevuvirus	Bahdevuvirus caenivivens
19531654	19531654	PRJNA385073_P_NODE_28716_length_282_cov_2.894737_g28554_i0	PRJNA385073	28716	282	2.894737	8.16315834	Chrocagosk virus	3129397	Viruses	Viruses	63.9	1.2e-5	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g28554	i0	97.297	0.131205673758865	37	1	13	0	48	84	517	553	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	37	63.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
20807085	20807085	PRJNA385073_P_NODE_15757_length_346_cov_1.875458_g15596_i0	PRJNA385073	15757	346	1.875458	6.48908468	Timirovirus borboradaptatum	2846450	Viruses	Viruses	501	2.71e-137	NTclustered	gi\|2497516585\|ref\|NC_074508.1\|	2786465	g15596	i0	93.003	0.991329479768786	343	24	99	0	1	343	1938	2280	SsRNA phage SRR5467091_15 genomic sequence	blastn	343	501	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Timlovirales	Steitzviridae	Timirovirus	Timirovirus borboradaptatum
22082517	22082517	PRJNA385073_P_NODE_41758_length_251_cov_0.865169_g41596_i0	PRJNA385073	41758	251	0.865169	2.17157419	Ripachij virus	3130407	Viruses	Viruses	267	7.459999999999999e-67	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g41596	i0	85.827	169.741035856574	254	32	100	4	1	251	684	432	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	42605	267	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
22082608	22082608	PRJNA385073_P_NODE_46198_length_248_cov_1.451429_g46036_i0	PRJNA385073	46198	248	1.451429	3.59954392	Ripaflec virus	3130560	Viruses	Viruses	313	9.32e-81	NTclustered	gi\|2717320098\|gb\|PP172862.1\|	3130560	g46036	i0	91.304	120.487903225806	230	18	92	2	20	248	5456	5684	MAG: Ripaflec virus isolate KCAP2_k141_128097 genomic sequence	blastn	29881	313	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaflec virus
23358480	23358480	PRJNA385073_P_NODE_5779_length_506_cov_7.988453_g5619_i0	PRJNA385073	5779	506	7.988453	40.42157218	Bahdevuvirus caenivivens	2843795	Viruses	Viruses	326	2.64e-84	NTclustered	gi\|2497513288\|ref\|NC_073766.1\|	2786400	g5619	i0	93.578	0.954545454545455	218	14	43	0	289	506	241	24	SsRNA phage SRR5466365_1 genomic sequence	blastn	483	326	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Atkinsviridae	Bahdevuvirus	Bahdevuvirus caenivivens
24631944	24631944	PRJNA385073_P_NODE_17860_length_331_cov_3.852713_g17698_i0	PRJNA385073	17860	331	3.852713	12.75248003	Bahdevuvirus caenivivens	2843795	Viruses	Viruses	292	1.6899999999999999e-74	NTclustered	gi\|2497513288\|ref\|NC_073766.1\|	2786400	g17698	i0	91.163	0.649546827794562	215	19	65	0	117	331	241	27	SsRNA phage SRR5466365_1 genomic sequence	blastn	215	292	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Atkinsviridae	Bahdevuvirus	Bahdevuvirus caenivivens
32320168	32320168	PRJNA385073_P_NODE_21579_length_310_cov_3.552743_g21417_i0	PRJNA385073	21579	310	3.552743	11.0135033	Leviviridae sp.	2027243	Viruses	Viruses	70.5	1.25e-11	NR	QDH91407.1	2027243	g21417	i0	44.3	0.590322580645161	61	34	59	0	305	123	244	304	QDH91407.1 MAG: hypothetical protein H1Rhizo25885e4861_000003 [Leviviridae sp.]	diamond	183	70.5	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.

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