metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1066877" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1066877" 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_genus	tax_species
3563541	3563541	PRJNA1066877_S_NODE_1543_length_357_cov_4.301948_g1508_i0	PRJNA1066877	1543	357	4.301948	15.35795436	Betacoronavirus	694002	Viruses	Viruses	106	2.56e-18	NTclustered	gi\|2165835518\|emb\|OV196584.1\|	2697049	g1508	i0	94.286	22.9439775910364	70	3	19	1	289	357	88	19	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	8191	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
4006837	4006837	PRJNA1066877_S_NODE_5204_length_224_cov_3.262857_g5169_i0	PRJNA1066877	5204	224	3.262857	7.30879968	Crogonang virus 9	3062921	Viruses	Viruses	259	1.09e-64	NTclustered	gi\|2836327217\|gb\|PQ161481.1\|	3062921	g5169	i0	97.386	1.98214285714286	153	2	68	1	1	153	8958	9108	MAG: Crogonang virus 9 isolate CS13 RNA-dependent RNA polymerase and capsid protein genes, complete cds	blastn	444	259	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Crogonang virus 9
4006844	4006844	PRJNA1066877_S_NODE_5584_length_219_cov_0.870588_g5549_i0	PRJNA1066877	5584	219	0.870588	1.90658772	Caudoviricetes sp.	2832643	Viruses	Viruses	322	1.34e-83	NTclustered	gi\|2059625654\|tpg\|BK028308.1\|	2832643	g5549	i0	93.151	1	219	15	100	0	1	219	118472	118254	MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome	blastn	219	322	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4840959	4840959	PRJNA1066877_S_NODE_12124_length_164_cov_0.913043_g12089_i0	PRJNA1066877	12124	164	0.913043	1.49739052	Aliceevansviridae	3044455	Viruses	Viruses	281	1.6000000000000001e-71	NTclustered	gi\|2437983729\|ref\|NC_070651.1\|	1718281	g12089	i0	97.561	97.0609756097561	164	4	100	0	1	164	27056	27219	Streptococcus phage 128, complete genome	blastn	15918	281	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Aliceevansviridae	Moineauvirus	Moineauvirus mv128
5283294	5283294	PRJNA1066877_S_NODE_8745_length_186_cov_1.313869_g8710_i0	PRJNA1066877	8745	186	1.313869	2.44379634	Caudoviricetes sp.	2832643	Viruses	Viruses	283	5.179999999999999e-72	NTclustered	gi\|2059625654\|tpg\|BK028308.1\|	2832643	g8710	i0	94.086	1	186	11	100	0	1	186	118066	118251	MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome	blastn	186	283	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
7390603	7390603	PRJNA1066877_S_NODE_11406_length_167_cov_0.864407_g11371_i0	PRJNA1066877	11406	167	0.864407	1.44355969	Pahexavirus	1982251	Viruses	Viruses	298	1.63e-76	NTclustered	gi\|1336448649\|gb\|MG820645.1\|	2079404	g11371	i0	98.802	99.3053892215569	167	2	100	0	1	167	11741	11907	Propionibacterium phage pa3-SS3, complete genome	blastn	16584	298	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Propionibacterium phage pa3-SS3
11659028	11659028	PRJNA1066877_S_NODE_7330_length_198_cov_1.919463_g7295_i0	PRJNA1066877	7330	198	1.919463	3.80053674	Caudoviricetes sp.	2832643	Viruses	Viruses	316	5.51e-82	NTclustered	gi\|2059625654\|tpg\|BK028308.1\|	2832643	g7295	i0	95.477	1.0050505050505	199	8	100	1	1	198	131286	131088	MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome	blastn	199	316	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
14208975	14208975	PRJNA1066877_S_NODE_1112_length_405_cov_1.084270_g1077_i0	PRJNA1066877	1112	405	1.08427	4.3912935	Gammaretrovirus felleu	3428951	Viruses	Viruses	527	5.299999999999998e-145	NTclustered	gi\|1249614576\|dbj\|AB898926.1\|	11768	g1077	i0	93.075	0.891358024691358	361	24	89	1	1	360	1421	1061	Feline leukemia virus gene for gag-pol polyprotein gPr80, partial sequence, clone: g45-5R	blastn	361	527	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus felleu
16757392	16757392	PRJNA1066877_S_NODE_934_length_438_cov_1.357326_g899_i0	PRJNA1066877	934	438	1.357326	5.94508788	Caudoviricetes sp.	2832643	Viruses	Viruses	809	0	NTclustered	gi\|2057978434\|tpg\|BK046703.1\|	2832643	g899	i0	100	1	438	0	100	0	1	438	10075	9638	MAG TPA_asm: Caudoviricetes sp. isolate ctLaR6, partial genome	blastn	438	809	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19305962	19305962	PRJNA1066877_S_NODE_12356_length_163_cov_1.210526_g12321_i0	PRJNA1066877	12356	163	1.210526	1.97315738	Caudoviricetes sp.	2832643	Viruses	Viruses	219	1.2699999999999999e-52	NTclustered	gi\|2059625654\|tpg\|BK028308.1\|	2832643	g12321	i0	90.798	1	163	15	100	0	1	163	77825	77987	MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome	blastn	163	219	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19305974	19305974	PRJNA1066877_S_NODE_12996_length_161_cov_0.866071_g12961_i0	PRJNA1066877	12996	161	0.866071	1.39437431	Erysiphe necator associated ourmia-like virus 104	2741765	Viruses	Viruses	102	1.31e-17	NTclustered	gi\|1848976741\|gb\|MN611632.1\|	2741765	g12961	i0	79.618	1.80124223602484	157	20	91	7	16	161	1968	1813	Erysiphe necator associated ourmia-like virus 104 isolate PMS6_146, complete genome	blastn	290	102	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Ourmiavirus	Erysiphe necator associated ourmia-like virus 104
21857109	21857109	PRJNA1066877_S_NODE_10998_length_169_cov_1.275000_g10963_i0	PRJNA1066877	10998	169	1.275	2.15475	Caudoviricetes sp.	2832643	Viruses	Viruses	307	2.73e-79	NTclustered	gi\|2914754492\|gb\|OR221467.1\|	2832643	g10963	i0	99.408	2.6094674556213	169	1	100	0	1	169	15003	15171	MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence	blastn	441	307	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
23132610	23132610	PRJNA1066877_S_NODE_12519_length_162_cov_2.743363_g12484_i0	PRJNA1066877	12519	162	2.743363	4.44424806	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	248	1.6e-61	NTclustered	gi\|2754692226\|gb\|PP872826.1\|	3003959	g12484	i0	98.582	0.87037037037037	141	1	86	1	1	140	8429	8569	MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence	blastn	141	248	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
23132757	23132757	PRJNA1066877_S_NODE_79_length_1200_cov_33.277150_g69_i0	PRJNA1066877	79	1200	33.27715	399.3258	Betacoronavirus pandemicum	3418604	Viruses	Viruses	106	9.27e-18	NTclustered	gi\|2165834303\|emb\|OV196009.1\|	2697049	g69	i0	94.366	6.67166666666667	71	1	6	3	6	74	46	115	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	8006	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum

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