metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA400391" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA400391" 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_species
2964794	2964794	PRJNA400391_S_NODE_2523_length_252_cov_21.396313_g2462_i0	PRJNA400391	2523	252	21.396313	53.91870876	Chronazork virus	3129863	Viruses	Viruses	176	1.3e-39	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g2462	i0	82.192	15.7777777777778	219	26	83	10	18	226	315	100	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	3976	176	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Chronazork virus
5517760	5517760	PRJNA400391_S_NODE_1405_length_318_cov_1.332155_g1344_i0	PRJNA400391	1405	318	1.332155	4.2362529	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	124	6.2299999999999996e-24	NTclustered	gi\|1698237878\|gb\|MN034986.1\|	3003959	g1344	i0	97.26	1.65723270440252	73	2	23	0	246	318	79	7	MAG: Picornavirales sp. isolate H1_Bulk_30_scaffold_9721 sequence	blastn	527	124	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
6791752	6791752	PRJNA400391_S_NODE_1426_length_316_cov_55.982206_g1365_i0	PRJNA400391	1426	316	55.982206	176.90377096	Chronaparn virus	3129907	Viruses	Viruses	87.9	8.11e-13	NTclustered	gi\|2717318620\|gb\|PP172304.1\|	3129907	g1365	i0	90	10.4272151898734	70	3	21	3	1	66	3687	3756	MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence	blastn	3295	87.9	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Chronaparn virus
8067383	8067383	PRJNA400391_S_NODE_2927_length_235_cov_9.310000_g2866_i0	PRJNA400391	2927	235	9.31	21.8785	uncultured human fecal virus	239364	Viruses	Viruses	416	6.4799999999999985e-112	NTclustered	gi\|1569729598\|gb\|MK233924.1\|	239364	g2866	i0	98.718	251.885106382979	234	3	99	0	1	234	757	990	Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence	blastn	59193	416	1	Viruses						uncultured human fecal virus
8067438	8067438	PRJNA400391_S_NODE_5727_length_164_cov_3.976744_g5666_i0	PRJNA400391	5727	164	3.976744	6.52186016	Caudoviricetes sp.	2832643	Viruses	Viruses	285	1.24e-72	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g5666	i0	98.16	289.164634146341	163	3	99	0	1	163	18059	17897	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	47423	285	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
11892927	11892927	PRJNA400391_S_NODE_5470_length_169_cov_2.402985_g5409_i0	PRJNA400391	5470	169	2.402985	4.06104465	Caudoviricetes sp.	2832643	Viruses	Viruses	272	9.95e-69	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g5409	i0	95.858	320.05325443787	169	6	99	1	2	169	18419	18251	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	54089	272	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
11892935	11892935	PRJNA400391_S_NODE_5790_length_163_cov_2.296875_g5729_i0	PRJNA400391	5790	163	2.296875	3.74390625	Ripocalt virus	3130345	Viruses	Viruses	224	2.72e-54	NTclustered	gi\|2717319477\|gb\|PP172647.1\|	3130345	g5729	i0	91.411	26.3865030674847	163	14	100	0	1	163	171	9	MAG: Ripocalt virus isolate KCAP1_k141_19090 genomic sequence	blastn	4301	224	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Ripocalt virus
14442984	14442984	PRJNA400391_S_NODE_2572_length_250_cov_4.381395_g2511_i0	PRJNA400391	2572	250	4.381395	10.9534875	Chrocagost virus	3129398	Viruses	Viruses	283	7.379999999999999e-72	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g2511	i0	88.841	582.584	233	22	92	4	20	250	5601	5831	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	145646	283	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes			Chrocagost virus
14442986	14442986	PRJNA400391_S_NODE_2612_length_248_cov_12.272300_g2551_i0	PRJNA400391	2612	248	12.2723	30.435304	Chronazork virus	3129863	Viruses	Viruses	121	6.059999999999999e-23	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g2551	i0	78.037	13.7620967741935	214	31	81	11	2	203	106	315	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	3413	121	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Chronazork virus
15108828	15108828	PRJNA400391_S_NODE_5912_length_161_cov_3.547619_g5851_i0	PRJNA400391	5912	161	3.547619	5.71166659	Viruses	10239	Viruses	Viruses	291	2.6e-74	NTclustered	gi\|1569729598\|gb\|MK233924.1\|	239364	g5851	i0	100	193.850931677019	157	0	98	0	5	161	2343	2187	Uncultured human fecal virus clone R.bromii_S11.J19_2_c1 sequence	blastn	31210	291	1	Viruses						uncultured human fecal virus
15716847	15716847	PRJNA400391_S_NODE_6453_length_153_cov_2.432203_g6392_i0	PRJNA400391	6453	153	2.432203	3.72127059	Ripadip virus	3130510	Viruses	Viruses	207	2.53e-49	NTclustered	gi\|2717319943\|gb\|PP172812.1\|	3130510	g6392	i0	91.892	19.5424836601307	148	12	97	0	2	149	4535	4388	MAG: Ripadip virus isolate KCAP1_k141_658204 genomic sequence	blastn	2990	207	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Ripadip virus
19539865	19539865	PRJNA400391_S_NODE_4376_length_191_cov_24.762821_g4315_i0	PRJNA400391	4376	191	24.762821	47.29698811	Chronaparn virus	3129907	Viruses	Viruses	95.3	2.69e-15	NTclustered	gi\|2717318620\|gb\|PP172304.1\|	3129907	g4315	i0	87.952	18.6125654450262	83	7	42	2	1	80	3687	3769	MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence	blastn	3555	95.3	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Chronaparn virus
22090482	22090482	PRJNA400391_S_NODE_2118_length_273_cov_67.907563_g2057_i0	PRJNA400391	2118	273	67.907563	185.38764699	Sopozig virus	3131662	Viruses	Viruses	448	2.7399999999999995e-121	NTclustered	gi\|2717323079\|gb\|PP173963.1\|	3131662	g2057	i0	97.692	260.527472527473	260	6	95	0	1	260	329	588	MAG: Sopozig virus isolate SP1B_k141_130621 genomic sequence	blastn	71124	448	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Sopozig virus
22090493	22090493	PRJNA400391_S_NODE_2498_length_253_cov_34.321101_g2437_i0	PRJNA400391	2498	253	34.321101	86.83238553	Chronazork virus	3129863	Viruses	Viruses	185	2.1699999999999998e-42	NTclustered	gi\|2717318517\|gb\|PP172260.1\|	3129863	g2437	i0	83.028	17.6403162055336	218	24	82	10	18	224	315	100	MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence	blastn	4463	185	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Chronazork virus
22090578	22090578	PRJNA400391_S_NODE_5698_length_165_cov_1.561538_g5637_i0	PRJNA400391	5698	165	1.561538	2.5765377	uncultured human fecal virus	239364	Viruses	Viruses	261	2.11e-65	NTclustered	gi\|1569729248\|gb\|MK233574.1\|	239364	g5637	i0	95.706	0.987878787878788	163	6	99	1	1	163	796	635	Uncultured human fecal virus clone KLE1615.sp1_S11.L11_2_c1 sequence	blastn	163	261	1	Viruses						uncultured human fecal 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);;