metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
1024927	1024927	PRJNA1118794_P_NODE_44041_length_260_cov_1.406417_g43291_i0	PRJNA1118794	44041	260	1.406417	3.6566842	Orthorubulavirus	2560195	Viruses	Viruses	481	2.55e-131	NTclustered	gi\|2449300967\|gb\|ON241249.1\|	2560580	g43291	i0	100	68.2692307692308	260	0	100	0	1	260	4160	4419	Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome	blastn	17750	481	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
1505161	1505161	PRJNA1118794_P_NODE_16422_length_363_cov_7.610345_g15672_i0	PRJNA1118794	16422	363	7.610345	27.62555235	Ripothoz virus	3131336	Viruses	Viruses	93.5	2.03e-14	NTclustered	gi\|2717322249\|gb\|PP173638.1\|	3131336	g15672	i0	81.739	23.030303030303	115	17	31	3	46	158	5317	5429	MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence	blastn	8360	93.5	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Ripothoz virus
1505548	1505548	PRJNA1118794_P_NODE_45782_length_256_cov_1.683060_g45032_i0	PRJNA1118794	45782	256	1.68306	4.3086336	Orthorubulavirus mammalis	3052558	Viruses	Viruses	472	1.51e-128	NTclustered	gi\|2562721692\|gb\|OQ994985.1\|	2905673	g45032	i0	100	67.984375	255	0	99	0	2	256	13822	14076	Parainfluenza virus 5 strain GX2020, complete genome	blastn	17404	472	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
2780969	2780969	PRJNA1118794_P_NODE_17483_length_355_cov_1.627660_g16733_i0	PRJNA1118794	17483	355	1.62766	5.778193	Chronazanb virus	3129852	Viruses	Viruses	202	3.1499999999999996e-47	NTclustered	gi\|2717318485\|gb\|PP172249.1\|	3129852	g16733	i0	95.968	46.4929577464789	124	5	35	0	188	311	4362	4485	MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence	blastn	16505	202	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazanb virus
2781129	2781129	PRJNA1118794_P_NODE_29743_length_293_cov_2.781818_g28993_i0	PRJNA1118794	29743	293	2.781818	8.15072674	Chrocurosk virus	3129322	Viruses	Viruses	357	5.14e-94	NTclustered	gi\|2717317280\|gb\|PP171770.1\|	3129322	g28993	i0	94.093	268.044368600683	237	10	80	4	57	291	1896	1662	MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence	blastn	78537	357	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Chrocurosk virus
6608488	6608488	PRJNA1118794_P_NODE_18846_length_346_cov_1.124542_g18096_i0	PRJNA1118794	18846	346	1.124542	3.89091532	Carlavirus rhochrysanthemi	3427791	Viruses	Viruses	353	8.02e-93	NTclustered	gi\|1571845974\|ref\|NC_040703.1\|	2116736	g18096	i0	85.174	0.994219653179191	344	51	99	0	3	346	1788	1445	Chrysanthemum virus R strain BJ, complete genome	blastn	344	353	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus rhochrysanthemi
7883475	7883475	PRJNA1118794_P_NODE_27047_length_304_cov_2.528139_g26297_i0	PRJNA1118794	27047	304	2.528139	7.68554256	Chronazanb virus	3129852	Viruses	Viruses	207	5.71e-49	NTclustered	gi\|2717318485\|gb\|PP172249.1\|	3129852	g26297	i0	96.774	64.9243421052632	124	4	41	0	138	261	4362	4485	MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence	blastn	19737	207	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Chronazanb virus
7884082	7884082	PRJNA1118794_P_NODE_7_length_7211_cov_42.281171_g4_i0	PRJNA1118794	7	7211	42.281171	3048.89524081	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2488	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4	i0	91.863	0.667175149077798	1782	141	67	4	5427	7206	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4811	2488	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
10434641	10434641	PRJNA1118794_P_NODE_8909_length_472_cov_2.481203_g8162_i0	PRJNA1118794	8909	472	2.481203	11.71127816	Ripasluq virus	3131229	Viruses	Viruses	510	6.3e-140	NTclustered	gi\|2717321969\|gb\|PP173531.1\|	3131229	g8162	i0	89.512	529.512711864407	410	34	86	8	67	472	2903	3307	MAG: Ripasluq virus isolate MP3_k141_106077 genomic sequence	blastn	249930	510	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripasluq virus
12984681	12984681	PRJNA1118794_P_NODE_51_length_4038_cov_110.911980_g30_i0	PRJNA1118794	51	4038	110.91198	4478.6257524	Alphacarmovirus dianthi	3047728	Viruses	Viruses	6857	0	NTclustered	gi\|797178909\|gb\|KR002041.1\|	11986	g30	i0	97.881	45.55720653789	3965	84	99	0	67	4031	3966	2	Carnation mottle virus, complete genome	blastn	183960	6857	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Alphacarmovirus	Alphacarmovirus dianthi
15052671	15052671	PRJNA1118794_P_NODE_69852_length_242_cov_1.366864_g69102_i0	PRJNA1118794	69852	242	1.366864	3.30781088	Orthorubulavirus	2560195	Viruses	Viruses	448	2.3799999999999995e-121	NTclustered	gi\|2507986953\|gb\|OQ348510.1\|	2560580	g69102	i0	100	68.004132231405	242	0	100	0	1	242	13035	12794	Mammalian orthorubulavirus 5 isolate HLJ-W, complete genome	blastn	16457	448	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
21907269	21907269	PRJNA1118794_P_NODE_14018_length_386_cov_1.980831_g13268_i0	PRJNA1118794	14018	386	1.980831	7.64600766	Alphacarmovirus dianthi	3047728	Viruses	Viruses	630	3.7199999999999986e-176	NTclustered	gi\|2073357638\|gb\|MZ405660.1\|	11986	g13268	i0	96.114	26.9844559585492	386	15	100	0	1	386	659	274	Carnation mottle virus isolate DSMZ PV-0878, partial sequence	blastn	10416	630	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Alphacarmovirus	Alphacarmovirus dianthi
25251184	25251184	PRJNA1118794_P_NODE_14720_length_379_cov_1.307190_g13970_i0	PRJNA1118794	14720	379	1.30719	4.9542501	Orthorubulavirus	2560195	Viruses	Viruses	684	0	NTclustered	gi\|1806608684\|gb\|MN604146.1\|	2560580	g13970	i0	99.208	63.5804749340369	379	3	100	0	1	379	15239	14861	Mammalian orthorubulavirus 5 isolate XJ033, complete genome	blastn	24097	684	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis

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