metadata: contig_metadata: 5 rows where bioproject = "PRJNA615175", tax_phylum = "Pisuviricota" and tax

5 rows where bioproject = "PRJNA615175", 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
594880	594880	PRJNA615175_P_NODE_1_length_9040_cov_85.556039_g0_i0	PRJNA615175	1	9040	85.556039	7734.2659256	Cripavirus drosophilae	3047809	Viruses	Viruses	15546	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g0	i0	97.886	21.1269911504425	8989	189	99	1	1	8988	270	9258	Drosophila C virus isolate Davidson2006, complete genome	blastn	190988	15546	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
6973146	6973146	PRJNA615175_P_NODE_10626_length_448_cov_2.842667_g10458_i0	PRJNA615175	10626	448	2.842667	12.73514816	Canine astrovirus	1157338	Viruses	Viruses	795	0	NTclustered	gi\|1917349463\|gb\|MN882008.1\|	1157338	g10458	i0	98.661	67.578125	448	6	100	0	1	448	6425	5978	Canine astrovirus strain B091/China/GZ/2018, complete genome	blastn	30275	795	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Mamastrovirus	Canine astrovirus
8248318	8248318	PRJNA615175_P_NODE_4027_length_775_cov_3.414530_g3871_i0	PRJNA615175	4027	775	3.41453	26.4626075	Skokie dicistro-like virus	2789443	Viruses	Viruses	1387	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g3871	i0	98.968	2	775	8	100	0	1	775	5259	4485	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	1550	1387	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
27680856	27680856	PRJNA615175_P_NODE_11604_length_424_cov_3.928775_g11436_i0	PRJNA615175	11604	424	3.928775	16.658006	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	130	4.48e-32	NR	QPN36948.1	2789378	g11436	i0	48	2.12971698113208	150	63	95.5	2	409	5	990	1139	QPN36948.1 polyprotein [Shenzhen dicistro-like virus]	diamond	903	130	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
31280948	31280948	PRJNA615175_P_NODE_1915_length_1100_cov_4.378773_g1803_i0	PRJNA615175	1915	1100	4.378773	48.166503	Fusarium mangiferae partitivirus 1	2880274	Viruses	Viruses	630	7.319999999999996e-222	NR	UBZ25877.1	2880274	g1803	i0	81.7	0.998181818181818	366	67	99.8	0	1	1098	26	391	UBZ25877.1 coat protein [Fusarium mangiferae partitivirus 1]	diamond	1098	630	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Fusarium mangiferae partitivirus 1

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