metadata: contig_metadata: 5 rows where bioproject = "PRJNA493244", tax_kingdom = "Orthornavirae" and tax

5 rows where bioproject = "PRJNA493244", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

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_species
1730428	1730428	PRJNA493244_P_NODE_1436682_length_258_cov_6.248731_g1413557_i0	PRJNA493244	1436682	258	6.248731	16.12172598	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	333	7.489999999999999e-87	NTclustered	gi\|2754804027\|tpg\|BK063169.1\|	3032225	g1413557	i0	92.704	0.90310077519379806	233	14	90	3	4	236	4638	4409	TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds	blastn	233	333	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Periplaneta americana dicistro-like virus
3007067	3007067	PRJNA493244_P_NODE_1666603_length_208_cov_0.870748_g1643478_i0	PRJNA493244	1666603	208	0.870748	1.81115584	Ustilaginoidea virens partitivirus	1346082	Viruses	Viruses	316	5.849999999999998e-82	NTclustered	gi\|512746091\|gb\|KC503901.1\|	1346082	g1643478	i0	95.025	0.966346153846154	201	10	97	0	8	208	854	654	Ustilaginoidea virens partitivirus segment 4, complete sequence	blastn	201	316	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Ustilaginoidea virens partitivirus
10660523	10660523	PRJNA493244_P_NODE_295529_length_987_cov_3.389849_g280235_i0	PRJNA493244	295529	987	3.389849	33.45780963	Poaceae Liege partitivirus 6	2972889	Viruses	Viruses	1469	0	NTclustered	gi\|2288738604\|gb\|OL330745.1\|	2972889	g280235	i0	93.522	2.00506585612969	988	63	100	1	1	987	550	1537	Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds	blastn	1979	1469	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Poaceae Liege partitivirus 6
24680787	24680787	PRJNA493244_P_NODE_1067500_length_378_cov_3.123028_g1044383_i0	PRJNA493244	1067500	378	3.123028	11.80504584	Poaceae Liege partitivirus 6	2972889	Viruses	Viruses	510	4.94e-140	NTclustered	gi\|2288738604\|gb\|OL330745.1\|	2972889	g1044383	i0	91.029	1.0026455026455	379	33	100	1	1	378	109	487	Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds	blastn	379	510	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Poaceae Liege partitivirus 6
30424450	30424450	PRJNA493244_P_NODE_582053_length_655_cov_5.513468_g560734_i0	PRJNA493244	582053	655	5.513468	36.1132154	Skokie dicistro-like virus	2789443	Viruses	Viruses	201	1.8899999999999996e-55	NR	QPG92978.1	2789443	g560734	i0	74.8	0.581679389312977	127	32	58.2	0	24	404	730	856	QPG92978.1 polyprotein 1 [Skokie dicistro-like virus]	diamond	381	201	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Skokie 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);;