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

14 rows where analysis = "blastn", bioproject = "PRJNA345071" 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
1668071	1668071	PRJNA345071_P_NODE_7242_length_257_cov_1.402174_g7202_i0	PRJNA345071	7242	257	1.402174	3.60358718	Pseudomonas phage UFJF_PfPro	3384676	Viruses	Viruses	475	1.1699999999999999e-129	NTclustered	gi\|2865722204\|gb\|PQ412991.1\|	3384676	g7202	i0	100	30.7003891050584	257	0	100	0	1	257	13758	13502	Pseudomonas phage UFJF_PfPro, complete genome	blastn	7890	475	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae		Pseudomonas phage UFJF_PfPro
2345731	2345731	PRJNA345071_P_NODE_22_length_1844_cov_504.219085_g16_i0	PRJNA345071	22	1844	504.219085	9297.7999274	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	900	0	NTclustered	gi\|4760940\|gb\|AF100359.1\|AF100359	RQ01	g16	i0	77.302	84.337852494577	1564	332	84	19	37	1590	1743	193	Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds	blastn	155519	902	0.997782705099778	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
2944099	2944099	PRJNA345071_P_NODE_8163_length_251_cov_0.876404_g8123_i0	PRJNA345071	8163	251	0.876404	2.19977404	Maltschvirus maltsch	2956182	Viruses	Viruses	464	2.47e-126	NTclustered	gi\|1220004050\|gb\|MF417968.1\|	2100421	g8123	i0	100	12.796812749004	251	0	100	0	1	251	6774	7024	Uncultured Caudovirales phage clone 8F_9, partial genome	blastn	3212	464	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
5497048	5497048	PRJNA345071_P_NODE_7365_length_255_cov_2.120879_g7325_i0	PRJNA345071	7365	255	2.120879	5.40824145	Trichovirus chloropersicae	3432984	Viruses	Viruses	388	1.5499999999999998e-103	NTclustered	gi\|1479557639\|gb\|MH084696.1\|	2358294	g7325	i0	94.118	20.5647058823529	255	15	100	0	1	255	5664	5918	Peach chlorotic leaf spot virus isolate RP19-2, complete genome	blastn	5244	388	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Trichovirus chloropersicae
7448274	7448274	PRJNA345071_P_NODE_6_length_2383_cov_21.471429_g3_i0	PRJNA345071	6	2383	21.471429	511.66415307	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	1711	0	NTclustered	gi\|2070683497\|gb\|MZ603947.1\|	RQ01	g3	i0	79.84	99.0709190096517	2371	456	99	22	4	2363	2	2361	Influenza B virus (B/USA/5/2017) segment 2 polymerase PB2 (PB2) gene, complete cds	blastn	236086	1711	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
8046579	8046579	PRJNA345071_P_NODE_2507_length_368_cov_1.359322_g2467_i0	PRJNA345071	2507	368	1.359322	5.00230496	Great lobelia partitivirus	2933144	Viruses	Viruses	375	1.8299999999999998e-99	NTclustered	gi\|2381814345\|emb\|OX380358.1\|	2933144	g2467	i0	85.674	0.967391304347826	356	51	97	0	2	357	210	565	Great lobelia partitivirus RNA2	blastn	356	375	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Great lobelia partitivirus
8722949	8722949	PRJNA345071_P_NODE_7_length_2357_cov_14.318301_g4_i0	PRJNA345071	7	2357	14.318301	337.48235457	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	1628	0	NTclustered	gi\|2054205231\|gb\|MZ401397.1\|	RQ01	g4	i0	79.504	96.7293169282987	2298	463	97	8	62	2355	2295	2	Influenza B virus (B/USA/762910_Segment_1/2021) segment 1 polymerase PB1 (PB1) gene, complete cds	blastn	227991	1628	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
11273616	11273616	PRJNA345071_P_NODE_9_length_2260_cov_14.909465_g6_i0	PRJNA345071	9	2260	14.909465	336.953909	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	1448	0	NTclustered	gi\|1128385509\|gb\|CY211229.1\|	RQ01	g6	i0	78.662	97.1092920353982	2198	455	97	14	19	2209	2	2192	Influenza B virus (B/Florida/91/2016) polymerase PA (PA) gene, complete cds	blastn	219467	1448	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
12548899	12548899	PRJNA345071_P_NODE_110_length_1179_cov_515.866184_g97_i0	PRJNA345071	110	1179	515.866184	6082.06230936	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	641	5.609999999999999e-179	NTclustered	gi\|2449947533\|gb\|OQ535360.1\|	RQ01	g97	i0	80.546	71.4758269720102	843	156	71	8	6	844	1	839	Influenza B virus (B/USA/8B1/2011) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds	blastn	84270	641	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
14422036	14422036	PRJNA345071_P_NODE_152_length_1090_cov_195.870206_g133_i0	PRJNA345071	152	1090	195.870206	2134.9852454	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	468	9.29e-127	NTclustered	gi\|2413738156\|gb\|OQ034364.1\|	RQ01	g133	i0	74.886	79.2403669724771	1099	240	99	32	1	1085	1077	1	Influenza B virus (B/Great Lakes/1739/1954) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds	blastn	86372	468	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
15696053	15696053	PRJNA345071_P_NODE_6393_length_268_cov_1.610256_g6353_i0	PRJNA345071	6393	268	1.610256	4.31548608	Trichovirus chloropersicae	3432984	Viruses	Viruses	424	4.5099999999999996e-114	NTclustered	gi\|1479557639\|gb\|MH084696.1\|	2358294	g6353	i0	95.149	46.9850746268657	268	13	100	0	1	268	6966	6699	Peach chlorotic leaf spot virus isolate RP19-2, complete genome	blastn	12592	424	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Trichovirus chloropersicae
18245042	18245042	PRJNA345071_P_NODE_9335_length_247_cov_0.896552_g9295_i0	PRJNA345071	9335	247	0.896552	2.21448344	Anatid alphaherpesvirus 2	3080522	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2600977532\|gb\|OR540300.1\|	3080522	g9295	i0	96.97	0.267206477732794	33	0	13	1	190	222	146969	146938	Anatid alphaherpesvirus 2 isolate ACDP 22-00165, partial genome	blastn	66	54.7	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae		Anatid alphaherpesvirus 2
20794800	20794800	PRJNA345071_P_NODE_6657_length_264_cov_2.324607_g6617_i0	PRJNA345071	6657	264	2.324607	6.13696248	Maltschvirus maltsch	2956182	Viruses	Viruses	488	1.5499999999999999e-133	NTclustered	gi\|1220001067\|gb\|MF417896.1\|	2100421	g6617	i0	100	13.5492424242424	264	0	100	0	1	264	25596	25333	Uncultured Caudovirales phage clone 3S_18, partial genome	blastn	3577	488	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
23345329	23345329	PRJNA345071_P_NODE_6659_length_264_cov_2.219895_g6619_i0	PRJNA345071	6659	264	2.219895	5.8605228	Caudoviricetes sp.	2832643	Viruses	Viruses	488	1.5499999999999999e-133	NTclustered	gi\|2053025026\|tpg\|BK023955.1\|	2832643	g6619	i0	100	6.18939393939394	264	0	100	0	1	264	17208	16945	MAG TPA_asm: Caudoviricetes sp. isolate ctWEw2, partial genome	blastn	1634	488	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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