metadata: contig_metadata: 9 rows where bioproject = "PRJNA315399", tax_phylum = "Pisuviricota" and tax

9 rows where bioproject = "PRJNA315399", tax_phylum = "Pisuviricota" 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
385236	385236	PRJNA315399_S_NODE_4261_length_463_cov_19.849765_g4072_i0	PRJNA315399	4261	463	19.849765	91.90441195	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	370	1.09e-97	NTclustered	gi\|2754804027\|tpg\|BK063169.1\|	3032225	g4072	i0	93.6	0.53995680345572294	250	13	54	2	11	260	4420	4666	TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds	blastn	250	370	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Periplaneta americana dicistro-like virus
4212349	4212349	PRJNA315399_S_NODE_28624_length_251_cov_7.182243_g28423_i0	PRJNA315399	28624	251	7.182243	18.02742993	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	97.1	3.32e-21	NR	QPG92982.1	2789378	g28423	i0	54.9	1.9601593625498	82	37	98	0	4	249	819	900	QPG92982.1 polyprotein [Shenzhen dicistro-like virus]	diamond	492	97.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
15685681	15685681	PRJNA315399_P_NODE_400413_length_161_cov_7.427419_g399965_i0	PRJNA315399	400413	161	7.427419	11.95814459	Picobirnavirus sp.	1907787	Viruses	Viruses	69.4	1.33e-7	NTclustered	gi\|2120560637\|gb\|MZ556535.1\|	1907787	g399965	i0	90.566	0.329192546583851	53	4	33	1	98	150	2092	2143	MAG: Picobirnavirus sp. isolate 87-k141_33409 putative RNA-dependent RNA polymerase gene, complete cds	blastn	53	69.4	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Picobirnavirus sp.
20786321	20786321	PRJNA315399_S_NODE_19357_length_283_cov_2.792683_g19156_i0	PRJNA315399	19357	283	2.792683	7.90329289	Alphafusarivirus roqueforti	2955275	Viruses	Viruses	477	3.639999999999999e-130	NTclustered	gi\|704698626\|ref\|NC_024699.1\|	1532180	g19156	i0	99.242	1.86572438162544	264	2	93	0	1	264	5739	6002	Penicillium roqueforti ssRNA mycovirus 1 strain PRG42-7 RNA-dependent RNA polymerase and ORF2 genes, complete cds	blastn	528	477	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae	Alphafusarivirus	Alphafusarivirus roqueforti
20786755	20786755	PRJNA315399_S_NODE_42477_length_224_cov_15.433155_g42276_i0	PRJNA315399	42477	224	15.433155	34.5702672	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	257	3.93e-64	NTclustered	gi\|2754804027\|tpg\|BK063169.1\|	3032225	g42276	i0	89.95	0.888392857142857	199	20	89	0	13	211	1783	1585	TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds	blastn	199	257	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Periplaneta americana dicistro-like virus
22743541	22743541	PRJNA315399_S_NODE_167338_length_156_cov_6.983193_g167137_i0	PRJNA315399	167338	156	6.983193	10.89378108	Viruses	10239	Viruses	Viruses	237	3.31e-58	NTclustered	gi\|2689146139\|gb\|PP352012.1\|	1530251	g167137	i0	96.528	41.1474358974359	144	4	92	1	1	143	9939	9796	MAG: Picornaviridae sp. isolate Hunan/CHN/2022 genomic sequence	blastn	6419	237	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
23336252	23336252	PRJNA315399_S_NODE_116379_length_171_cov_9.320896_g116178_i0	PRJNA315399	116379	171	9.320896	15.93873216	Picornaviridae sp.	1530251	Viruses	Viruses	257	2.83e-64	NTclustered	gi\|2689146139\|gb\|PP352012.1\|	1530251	g116178	i0	94.611	33.5263157894737	167	7	97	2	1	166	9971	9806	MAG: Picornaviridae sp. isolate Hunan/CHN/2022 genomic sequence	blastn	5733	257	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
32192597	32192597	PRJNA315399_S_NODE_12758_length_322_cov_10.378947_g12557_i0	PRJNA315399	12758	322	10.378947	33.42020934	Panax cryptic virus 4	2809267	Viruses	Viruses	75.5	3.33e-15	NR	WAQ73893.1	2809267	g12557	i0	84.1	0.819875776397516	44	7	41	0	2	133	53	96	WAQ73893.1 coat protein, partial [Panax cryptic virus 4]	diamond	264	75.5	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Panax cryptic virus 4
32287803	32287803	PRJNA315399_S_NODE_17819_length_290_cov_8.387352_g17618_i0	PRJNA315399	17819	290	8.387352	24.3233208	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	127	1.22e-31	NR	QPG92982.1	2789378	g17618	i0	63.5	0.993103448275862	96	35	99.3	0	289	2	1114	1209	QPG92982.1 polyprotein [Shenzhen dicistro-like virus]	diamond	288	127	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like 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);;