metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax_kingdom = "Orthornavirae"

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
847264	847264	PRJNA864829_S_NODE_2141_length_357_cov_4.142857_g2055_i0	PRJNA864829	2141	357	4.142857	14.78999949	Ripaglys virus	3130696	Viruses	Viruses	292	1.83e-74	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g2055	i0	82.687	297.574229691877	335	52	93	6	1	332	91	422	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	106234	292	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
847297	847297	PRJNA864829_S_NODE_7621_length_223_cov_6.155172_g7535_i0	PRJNA864829	7621	223	6.155172	13.72603356	Carlavirus latensdianthi	3427766	Viruses	Viruses	60.2	1.18e-4	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g7535	i0	97.222	0.663677130044843	36	0	16	1	1	35	13	48	Carnation latent virus isolate KL, complete genome	blastn	148	60.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
847301	847301	PRJNA864829_S_NODE_81_length_1201_cov_21.381076_g62_i0	PRJNA864829	81	1201	21.381076	256.78672276	Ripaglys virus	3130696	Viruses	Viruses	483	3.669999999999999e-131	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g62	i0	74.897	111.326394671107	1211	229	97	55	39	1201	2452	1269	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	133703	483	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
2122650	2122650	PRJNA864829_S_NODE_3322_length_305_cov_3.722656_g3236_i0	PRJNA864829	3322	305	3.722656	11.3541008	Ripaglys virus	3130696	Viruses	Viruses	233	9.46e-57	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g3236	i0	80.906	173.63606557377	309	48	100	11	1	305	1006	1307	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	52959	233	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
5950575	5950575	PRJNA864829_S_NODE_2265_length_350_cov_2.252492_g2179_i0	PRJNA864829	2265	350	2.252492	7.883722	Ripaglys virus	3130696	Viruses	Viruses	182	4.04e-41	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g2179	i0	94.828	56.6971428571429	116	6	33	0	217	332	755	640	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	19844	182	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
7225496	7225496	PRJNA864829_S_NODE_7366_length_226_cov_16.723164_g7280_i0	PRJNA864829	7366	226	16.723164	37.79435064	Ripachij virus	3130407	Viruses	Viruses	318	1.8e-82	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g7280	i0	92.035	177.632743362832	226	18	100	0	1	226	721	496	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	40145	318	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
11051006	11051006	PRJNA864829_S_NODE_1629_length_399_cov_6.445714_g1543_i0	PRJNA864829	1629	399	6.445714	25.71839886	Ripaglys virus	3130696	Viruses	Viruses	320	9.49e-83	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g1543	i0	85	93.9674185463659	320	42	79	6	53	369	1	317	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	37493	320	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
13600935	13600935	PRJNA864829_S_NODE_10551_length_195_cov_1.445205_g10465_i0	PRJNA864829	10551	195	1.445205	2.81814975	Ripakrox virus	3130763	Viruses	Viruses	220	4.36e-53	NTclustered	gi\|2717320712\|gb\|PP173065.1\|	3130763	g10465	i0	87.113	0.994871794871795	194	25	99	0	2	195	53	246	MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence	blastn	194	220	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripakrox virus
13600949	13600949	PRJNA864829_S_NODE_13751_length_173_cov_2.153226_g13665_i0	PRJNA864829	13751	173	2.153226	3.72508098	Ripaglys virus	3130696	Viruses	Viruses	102	1.42e-17	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g13665	i0	79.114	7.54913294797688	158	26	90	7	19	173	242	89	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	1306	102	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
14875319	14875319	PRJNA864829_S_NODE_72_length_1223_cov_31.003407_g55_i0	PRJNA864829	72	1223	31.003407	379.17166761	Ripaglys virus	3130696	Viruses	Viruses	725	0	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g55	i0	77.832	142.398201144726	1227	235	98	31	1	1204	1258	2470	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	174153	725	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
22524006	22524006	PRJNA864829_S_NODE_7598_length_224_cov_1.160000_g7512_i0	PRJNA864829	7598	224	1.16	2.5984	Dolerus tritici iflavirus 1	3350209	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2833733277\|gb\|PQ323359.2\|	3350209	g7512	i0	100	0.65625	30	0	13	0	195	224	85	56	Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds	blastn	147	56.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Dolerus tritici iflavirus 1

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