metadata: contig_metadata: 5 rows where bioproject = "PRJNA380660" and tax

5 rows where bioproject = "PRJNA380660" and tax_phylum = "Duplornaviricota"

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
16979566	16979566	PRJNA380660_P_NODE_12774_length_153_cov_1.943548_g12374_i0	PRJNA380660	12774	153	1.943548	2.97362844	Totivirus sp.	2776824	Viruses	Viruses	272	8.84e-69	NTclustered	gi\|1918615616\|gb\|MT949667.1\|	2776824	g12374	i0	98.693	1.99346405228758	153	2	100	0	1	153	1259	1107	Totivirus sp. isolate sequence_5835 genomic sequence	blastn	305	272	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
27264734	27264734	PRJNA380660_P_NODE_2603_length_521_cov_6.250000_g2241_i0	PRJNA380660	2603	521	6.25	32.5625	Sanya totivirus 3	2905262	Viruses	Viruses	117	4.990000000000001e-27	NR	UHK03125.1	2905262	g2241	i0	39.4	0.978886756238004	170	99	96.2	3	506	6	281	449	UHK03125.1 MAG: RNA-dependent RNA polymerase [Sanya totivirus 3]	diamond	510	117	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Sanya totivirus 3
27643906	27643906	PRJNA380660_P_NODE_11144_length_187_cov_1.316456_g10744_i0	PRJNA380660	11144	187	1.316456	2.46177272	Prasiola crispa toti-like virus	2933125	Viruses	Viruses	44.7	0.0038	NR	CAI5383883.1	2933125	g10744	i0	42	0.802139037433155	50	29	80.2	0	154	5	112	161	CAI5383883.1 RNA-dependent RNA polymerase [Prasiola crispa toti-like virus]	diamond	150	44.7	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Prasiola crispa toti-like virus
28906447	28906447	PRJNA380660_P_NODE_368_length_1412_cov_5.903109_g256_i0	PRJNA380660	368	1412	5.903109	83.35189908	Cryptolin alternavirus 1	3081027	Viruses	Viruses	163	4.92e-39	NR	WOC29231.1	3081027	g256	i0	29.9	1.95679886685552	428	281	87.1	5	1373	144	1977	2403	WOC29231.1 hypothetical protein [Cryptolin alternavirus 1]	diamond	2763	163	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Alternaviridae	Alternavirus	Cryptolin alternavirus 1
30706852	30706852	PRJNA380660_P_NODE_14_length_4015_cov_7.299047_g11_i0	PRJNA380660	14	4015	7.299047	293.05673705	Prasiola crispa toti-like virus	2933125	Viruses	Viruses	70.9	5.09e-8	NR	CAI5383882.1	2933125	g11	i0	25.9	0.153175591531756	205	119	13.5	6	1146	1688	464	659	CAI5383882.1 putative capsid protein [Prasiola crispa toti-like virus]	diamond	615	70.9	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Prasiola crispa toti-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);;