metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1240804" 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
346912	346912	PRJNA1240804_P_NODE_119441_length_167_cov_0.881356_g119075_i0	PRJNA1240804	119441	167	0.881356	1.47186452	Betascleroulivirus thetaplasmoparae	2955488	Viruses	Viruses	189	1.0199999999999999e-43	NTclustered	gi\|2500381320\|ref\|NC_076772.1\|	2686512	g119075	i0	89.333	3.53892215568862	150	16	90	0	4	153	412	263	Plasmopara viticola lesion associated ourmia-like virus 42 isolate DMG-G_38207 RNA dependent RNA polymerase (QKR47_gp1) gene, complete cds	blastn	591	189	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Betascleroulivirus	Betascleroulivirus thetaplasmoparae
4176087	4176087	PRJNA1240804_P_NODE_7524_length_457_cov_3.845588_g7163_i0	PRJNA1240804	7524	457	3.845588	17.57433716	Chrocagosk virus	3129397	Viruses	Viruses	285	4.01e-72	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g7163	i0	90.367	39.2625820568928	218	19	47	2	1	217	357	141	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	17943	285	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
6725644	6725644	PRJNA1240804_P_NODE_24086_length_290_cov_1.817427_g23720_i0	PRJNA1240804	24086	290	1.817427	5.2705383	Chrocagost virus	3129398	Viruses	Viruses	339	1.84e-88	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g23720	i0	89.85	401.231034482759	266	23	91	4	25	288	5863	5600	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	116357	339	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
13102309	13102309	PRJNA1240804_P_NODE_54031_length_213_cov_1.280488_g53665_i0	PRJNA1240804	54031	213	1.280488	2.72743944	Ripabiq virus	3130194	Viruses	Viruses	163	8.3e-36	NTclustered	gi\|2717319120\|gb\|PP172496.1\|	3130194	g53665	i0	82.723	81.2112676056338	191	26	88	7	1	188	606	792	MAG: Ripabiq virus isolate DRCP1_k141_78731 genomic sequence	blastn	17298	163	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripabiq virus
19474388	19474388	PRJNA1240804_P_NODE_43076_length_231_cov_1.401099_g42710_i0	PRJNA1240804	43076	231	1.401099	3.23653869	Chrocaturd virus	3129638	Viruses	Viruses	302	1.8600000000000002e-77	NTclustered	gi\|2717318092\|gb\|PP172086.1\|	3129638	g42710	i0	90.476	296.766233766234	231	19	99	2	1	230	3268	3040	MAG: Chrocaturd virus isolate CC1C_k141_57646 genomic sequence	blastn	68553	302	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocaturd virus
22023507	22023507	PRJNA1240804_P_NODE_101578_length_172_cov_1.634146_g101212_i0	PRJNA1240804	101578	172	1.634146	2.81073112	Chrocadirk virus	3129419	Viruses	Viruses	211	2.25e-50	NTclustered	gi\|2717317529\|gb\|PP171867.1\|	3129419	g101212	i0	95.455	330.406976744186	132	6	77	0	10	141	679	548	MAG: Chrocadirk virus isolate CC1B_k141_10698 genomic sequence	blastn	56830	211	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chrocadirk virus
22023650	22023650	PRJNA1240804_P_NODE_109658_length_169_cov_0.866667_g109292_i0	PRJNA1240804	109658	169	0.866667	1.46466723	Sonafor virus	3131557	Viruses	Viruses	169	1.34e-37	NTclustered	gi\|2717322811\|gb\|PP173858.1\|	3131557	g109292	i0	87.162	0.875739644970414	148	19	88	0	8	155	2927	3074	MAG: Sonafor virus isolate SN1_k141_345389 genomic sequence	blastn	148	169	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Sonafor virus
22024891	22024891	PRJNA1240804_P_NODE_37258_length_244_cov_1.671795_g36892_i0	PRJNA1240804	37258	244	1.671795	4.0791798	Sopazov virus	3131687	Viruses	Viruses	279	9.27e-71	NTclustered	gi\|2717323152\|gb\|PP173988.1\|	3131687	g36892	i0	88.646	55.7663934426229	229	26	94	0	3	231	59	287	MAG: Sopazov virus isolate SP1B_k141_222276 genomic sequence	blastn	13607	279	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopazov virus
23299420	23299420	PRJNA1240804_P_NODE_117479_length_167_cov_1.720339_g117113_i0	PRJNA1240804	117479	167	1.720339	2.87296613	Moss associated narna-like virus 14	3066973	Viruses	Viruses	106	1.06e-18	NTclustered	gi\|2626077263\|gb\|OQ987512.1\|	3066973	g117113	i0	80.435	1.74850299401198	138	27	83	0	26	163	758	895	MAG: Moss associated narna-like virus 14 isolate DICBIL genomic sequence	blastn	292	106	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Moss associated narna-like virus 14
23301235	23301235	PRJNA1240804_P_NODE_69199_length_194_cov_1.951724_g68833_i0	PRJNA1240804	69199	194	1.951724	3.78634456	Ripathuj virus	3131458	Viruses	Viruses	182	2.05e-41	NTclustered	gi\|2717322573\|gb\|PP173760.1\|	3131458	g68833	i0	85.632	0.896907216494845	174	23	89	1	9	180	469	296	MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence	blastn	174	182	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripathuj 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);;